Loading...
HomeMy Public PortalAbout05 - Master - Pueblo West IncorporationPUEBLO WEST METROPOLITAN DISTRICT, COLORADO FINANCIAL MANAGEMENT PLAN (FMP) LONG RANGE BUDGET PROJECTIONS Inflation Assumptions 1 Revenue (Non-taxes) 2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00% 2 Specific Ownership Taxes 5.00%5.00%5.00%5.00%5.00%5.00%5.00%5.00%5.00%5.00% 3 Sales & Use Taxes 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% 4 Franchise Taxes 2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00% 5 Highway Users and Other Taxes 1.00%5.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00% 6 Investment Earnings 1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50% 7 Expenses 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% 8 Sustainable Metro Fire Station Operations 1 9 Sustainable Metro Increased Staff 1 10 Sustainable Metro Salary Increases 1 11 New Initiatives (incorporation related)1 12 Debt Service for Civic Building 1 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Budget REVENUE 13 Property Taxes 4,337,155 4,450,020 4,606,390 4,751,237 4,871,361 5,256,547 10,431,006 13,078,964 13,471,452 14,140,211 14,547,527 15,274,923 15,665,520 16,377,240 16,784,731 14 Specific Ownership Taxes 352,132 370,318 444,785 454,137 470,000 493,500 518,175 544,084 571,288 599,852 629,845 661,337 694,404 729,124 765,580 15 Sales and Use Tax 0 0 0 0 1,500,000 1,500,000 1,530,000 4,620,600 4,713,012 4,807,272 4,903,418 5,001,486 5,101,516 5,203,546 5,307,617 16 Highway Users Tax 1,405,155 1,418,266 1,456,092 1,594,569 1,500,000 1,515,000 1,545,300 1,576,206 1,607,730 1,639,885 1,672,682 1,706,136 1,740,259 1,775,064 1,810,565 17 Franchise Taxes 121,608 136,924 146,570 149,279 150,000 153,000 156,060 159,181 162,365 165,612 168,924 172,303 175,749 179,264 182,849 18 Other Taxes 0 42,581 179,307 520,756 280,000 282,800 296,940 299,909 302,908 305,938 308,997 312,087 315,208 318,360 321,543 19 Intergovernmental & Grants 0 79,101 3,375 39,751 371,796 1,379,232 406,817 414,953 423,252 431,717 440,351 449,158 (94,694)(94,694)(94,694) 20 Charges for Services 257,471 315,258 290,100 300,180 300,334 306,341 312,467 318,717 325,091 331,593 338,225 344,989 351,889 358,927 366,105 21 Investment Earnings 16,166 33,063 62,368 76,997 75,000 50,979 46,720 54,030 70,030 72,348 74,540 77,655 82,319 79,518 75,942 22 Other 3,801 14,791 11,535 1,024 0 850,000 0 0 0 0 0 0 0 0 0 23 Total Revenue 6,493,488 6,860,322 7,200,522 7,887,930 9,518,491 11,787,399 15,243,485 21,066,644 21,647,128 22,494,428 23,084,510 24,000,075 24,032,169 24,926,349 25,520,240 EXPENSES 24 Current Acct. No. 25 Streets and Roads 401 2,051,896 1,850,091 1,664,278 2,172,678 3,774,349 2,425,323 2,522,336 2,623,229 2,728,158 2,837,285 2,950,776 3,068,807 3,191,560 3,319,222 3,451,991 26 Fire Protection 403 2,185,767 2,215,116 2,162,887 2,329,807 2,710,628 2,819,053 2,931,815 3,049,088 3,171,051 3,297,893 3,429,809 3,567,002 3,709,682 3,858,069 4,012,392 26a New Fire Station #2 Operations 1,400,000 1,456,000 1,514,240 1,574,810 1,637,802 1,703,314 1,771,447 1,842,304 1,915,997 27 Engineering 407 446,796 574,115 620,304 624,531 912,124 948,609 986,553 1,026,015 1,067,056 1,109,738 1,154,128 1,200,293 1,248,305 1,298,237 1,350,166 28 Parks and Recreation 409 748,033 721,932 747,237 870,978 853,220 887,349 922,843 959,756 998,147 1,038,073 1,079,595 1,122,779 1,167,690 1,214,398 1,262,974 29 Administration 900 698,674 783,871 793,322 931,159 1,007,656 1,047,962 1,089,881 1,133,476 1,178,815 1,225,968 1,275,006 1,326,007 1,379,047 1,434,209 1,491,577 30a Salary Adjustment 18%552,528 574,629 597,614 621,519 646,380 672,235 699,124 727,089 756,173 30b Associated Benefits 82,879 86,194 89,642 93,228 96,957 100,835 104,869 109,063 113,426 30c Non-incorporation Increased Payments to Internal Services Fund 93,110 96,835 100,708 104,737 108,926 113,283 117,814 122,527 127,428 31a Add 37 Positions to Current Staff Salary and Benefits 1,901,598 1,977,662 2,056,768 2,139,039 2,224,601 2,313,585 2,406,128 2,502,373 2,602,468 31b Add 37 Positions to Current Staff Ongoing Ops 1,443,000 1,500,720 1,560,749 1,623,179 1,688,106 1,755,630 1,825,855 1,898,890 1,974,845 32a Incorporation Salary and Benefits 513,614 539,295 560,866 583,301 606,633 630,899 656,134 682,380 32b Incorporation Operations Expense 2,805,330 2,945,597 3,092,876 3,247,520 3,409,896 3,580,391 3,759,411 3,947,381 32c Incorporation Payments increased to Internal Service Fund 309,297 309,297 321,669 334,536 347,917 361,834 376,307 391,359 33 Debt Service 34 Principal 0 146,732 178,955 303,445 176,474 178,426 68,801 45,985 45,292 31,686 32,583 33,505 34,453 33,532 0 35 Interest and Fiscal Charges 0 12,683 12,343 9,037 14,515 12,562 8,926 7,244 5,958 4,691 3,794 2,872 (203,167)(203,167)(203,167) 35a Debt Service for Civic Building 385,938 387,313 383,488 384,535 386,003 386,413 386,600 386,560 386,145 386,145 36 Capital Outlay 0 0 0 0 0 0 0 0 0 0 0 0 0 37 Streets and Roads 305,466 1,091,796 0 0 240,000 0 0 0 0 0 0 0 0 0 0 38 Fire Protection 0 0 0 0 175,000 0 0 0 0 0 0 0 0 0 38a Construct Fire Station #2 2,000,000 0 0 0 0 0 0 0 0 0 38b New Civic Building 7,150,000 39 Start-up desks, computers, etc 107,000 40 Engineering 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 41 Parks and Recreation 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 42 Administration Total Expenses 6,436,632 7,396,336 6,179,326 7,241,635 9,863,966 17,855,223 14,391,584 18,655,563 19,292,924 20,063,259 20,880,233 21,731,193 22,412,490 23,334,744 24,263,535 43 REVENUE OVER (UNDER) EXPENSES 56,856 (536,014)1,021,196 646,295 (345,475)(6,067,824)851,901 2,411,081 2,354,205 2,431,169 2,204,276 2,268,882 1,619,680 1,591,606 1,256,705 44 OTHER FINANCING SOURCES / (USES) 45 Transfers In 0 0 0 90,000 50,000 0 0 0 0 0 0 0 0 0 0 45a Transfer in from Water/Wastewater for Civic Bldg Debt 204,547 205,276 203,249 203,804 204,582 204,799 204,898 204,877 204,657 204,233 46 Transfers (Out) - Desert Hawk Loan (308,863)(306,729)(303,978)(306,788)(307,850)(303,813)(304,813)(305,188)(304,938)(304,063) 47 Transfers (Out) - Capital Project Fund (81,000)(30,000)0 0 (630,354)0 0 (701,575)(1,633,070)(1,677,311)(1,677,311)(1,622,774)(1,460,674)(1,460,674)(960,674) Incorporation Projected CASH FLOW ANALYSISGENERAL FUND Actual Page 1 - General Fund PUEBLO WEST METROPOLITAN DISTRICT, COLORADO FINANCIAL MANAGEMENT PLAN (FMP) LONG RANGE BUDGET PROJECTIONS Inflation Assumptions 1 Revenue (Non-taxes) 2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00% 2 Specific Ownership Taxes 5.00%5.00%5.00%5.00%5.00%5.00%5.00%5.00%5.00%5.00% 3 Sales & Use Taxes 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% 4 Franchise Taxes 2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00% 5 Highway Users and Other Taxes 1.00%5.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00% 6 Investment Earnings 1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50% 7 Expenses 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% 8 Sustainable Metro Fire Station Operations 1 9 Sustainable Metro Increased Staff 1 10 Sustainable Metro Salary Increases 1 11 New Initiatives (incorporation related)1 12 Debt Service for Civic Building 1 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Budget Incorporation Projected CASH FLOW ANALYSISGENERAL FUND Actual 47a Transfers (Out) - Swim Pool (116,000)(30,000)(43,700)(56,000)(30,000)(30,000)(50,000)(80,000)(100,000)(125,000)(125,000)(125,000)(125,000)(125,000)(125,000) 47b Transfers to Community Dev Fund - Non-Inc Costs (42,709)(44,417)(46,194)(48,041)(49,963)(51,962)(54,040)(56,202)(58,450)(60,788) 47c Transfers to Community Dev Fund - Incorp Costs (286,802)(298,274)(310,205)(322,613)(335,518)(348,938)(362,896)(377,412) 48 Lease/other Debt Proceeds 914,192 0 395,676 0 6,000,000 0 0 0 0 0 0 0 0 49 Insurance Recovery 0 0 82,325 394,611 0 0 0 0 0 0 0 0 0 0 0 TOTAL OTHER SOURCES / (USES)(505,863)547,463 (265,353)517,499 (918,204)5,828,026 (193,954)(1,216,510)(2,180,519)(2,261,960)(1,972,087)(1,932,434)(1,785,937)(1,802,363)(1,319,641) 50 Prior Period Adjustments 51 Ending General Fund Balance 2,960,578 2,972,027 3,727,870 4,891,664 3,627,985 3,388,187 4,046,135 5,240,707 5,414,392 5,583,602 5,815,791 6,152,239 5,985,981 5,775,224 5,712,288 52 Nonspendable (Prepaid Expenses)9,566 9,082 8,322 12,374 12,374 12,374 12,374 12,374 12,374 12,374 12,374 12,374 12,374 12,374 12,374 53 Restricted (TABOR Emergency Reserves)200,000 210,000 212,000 217,000 217,000 261,157 431,748 559,667 578,788 601,898 626,407 651,936 672,375 700,042 727,906 54 Committed (Capital Projects)0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 55 Assigned to Community Center (TABOR excess)0 0 56 Assigned (Equipment)435,415 11,594 287,645 0 0 0 0 0 0 0 0 0 0 0 0 57 Unassigned General Fund Balance (FB)2,315,597 2,741,351 3,219,903 4,662,290 3,398,611 3,114,657 3,602,014 4,668,666 4,823,231 4,969,330 5,177,010 5,487,929 5,301,232 5,062,808 4,972,008 58 % of FB to Current Year Exp (basis for City Policy)36%37%52%64%34%17%25%25%25%25%25%25%24%22%20% 59 % of FB to Current Year Revenues (calcs used by Moody's)36%40%45%59%36%26%24%22%22%22%22%23%22%20%19%CASH FLOW ANALYSISPage 2 - General Fund PUEBLO WEST METROPOLITAN DISTRICT, COLORADO FINANCIAL MANAGEMENT PLAN (FMP) LONG RANGE BUDGET PROJECTIONS Inflation Assumptions 1 Revenue (Non-taxes) 2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00% 2 Specific Ownership Taxes 5.00%5.00%5.00%5.00%5.00%5.00%5.00%5.00%5.00%5.00% 3 Sales & Use Taxes 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% 4 Franchise Taxes 2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00% 5 Highway Users and Other Taxes 1.00%5.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00% 6 Investment Earnings 1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50% 7 Expenses 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% 8 Sustainable Metro Fire Station Operations 1 9 Sustainable Metro Increased Staff 1 10 Sustainable Metro Salary Increases 1 11 New Initiatives (incorporation related)1 12 Debt Service for Civic Building 1 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Budget Incorporation Projected CASH FLOW ANALYSISGENERAL FUND Actual 60 TOTAL DISTRICT MILL LEVY 20.2300 20.2160 20.2300 20.2300 20.2300 20.2300 20.2300 20.2300 20.2300 20.2300 20.2300 20.2300 20.2300 Mill Levy % change allowed without voter approval -0.07%-0.07%-0.07%-0.07%-0.07%-0.07%-0.07%-0.07%-0.07%-0.07%-0.07%-0.07% 61 62 Existing Tax Adjusted Assessed Value 227,059,092 234,955,069 239,983,553 251,982,731 259,839,194 272,103,421 280,372,968 294,562,447 303,122,850 318,091,550 327,447,603 342,537,238 351,077,92062Residential Growth Annually 0 0 0 0 0 0 0 0 0 0 0 56a Residential Growth Rate # of Housing Units 193 213 398 397 396 396 416 365 365 366 56b Median Housing Value 259,000 284,900 290,598 296,410 302,338 308,385 314,553 320,844 327,261 333,806 64 Total New Residential Value 49,987,000 60,683,700 115,658,004 117,674,754 119,725,911 122,120,429 130,853,890 117,107,941 119,450,100 122,172,907 65 Current Assessment Rate 7.20%7.15%7.15%7.15%7.15%7.15%7.15%7.15%7.15%7.15%7.15% 66 Residential Assessed Value - Growth Only - 3,574,071 4,338,885 8,269,547 8,413,745 8,560,403 8,731,611 9,356,053 8,373,218 8,540,682 8,735,363 Residential Assessed Value Including Growth 0 7,856,463 4,338,885 8,269,547 8,413,745 8,560,403 8,731,611 9,356,053 8,373,218 8,540,682 8,735,36367 68 Existing Non-Residential Assessed Value 0 0 0 0 0 0 0 0 0 0 69 Non-Residential Growth Rate 0 0 0 0 0 0 0 0 70 Current Assessment Rate 29.00%29.00%29.00%29.00%29.00%29.00%29.00%29.00%29.00%29.00%29.00% 71 Non-Residential Assessed Value - Growth Only - - - - - - - - - - - Non-Residential Assessed Value Including Growth 0 0 0 0 0 0 0 0 0 0 072 Total Assessed Value 227,059,092 234,955,069 239,983,553 259,839,194 264,178,079 280,372,968 288,786,713 303,122,850 311,854,461 327,447,603 335,820,821 351,077,920 359,813,283 73 74 General Fund Property Taxes With No Adjustments 4,593,405 4,749,852 4,871,361 5,256,547 10,431,006 13,078,964 13,471,452 14,140,211 14,547,527 15,274,923 15,665,520 16,377,240 16,784,731 75 Annual Increase 3.4%2.6%7.9%98.4%25.4%3.0%5.0%2.9%5.0%2.6%4.5%2.5% 75 Operating Mill Levy 20.2300 20.2160 20.2300 20.2300 20.2300 20.2300 20.2300 20.2300 20.2300 20.2300 20.2300 20.2300 20.2300 76 Potential New Debt Service for Civic Building - 385,938 387,313 383,488 384,535 386,003 386,413 386,600 386,560 386,145 77a Debt Service Mill Levy - - - - - - - - - - - - - 77b Mill Levy Required for Sustainable Metro Salary Adjustment 3.3761 3.3761 3.3761 3.3761 3.3761 3.3761 3.3761 3.3761 3.3761 77d Mill Levy Required for Sustainable Metro Increased Staff 15.8787 15.8787 15.8787 15.8787 15.8787 15.8787 15.8787 15.8787 15.8787 77e Mill Levy Required for Incorporation Added Salary and Operations 7.1637 7.1637 7.1637 7.1637 7.1637 7.1637 7.1637 7.1637 77 Grand Total Mill Levy Required Current Plus Adjustments As Shown 20.2300 39.4848 46.6484 46.6484 46.6484 46.6484 46.6484 46.6484 46.6484 46.6484 Total Property Taxes Assuming Adjustments Shown 4,593,405 4,749,852 4,854,867 5,256,547 10,431,006 13,078,964 13,471,452 14,140,211 14,547,527 15,274,923 15,665,520 16,377,240 16,784,731PROPERTY TAX LEVY AND TAX IMPACT$6MM Project Fund(20 Years) Page 3 - General Fund 11/4/2019 PUEBLO WEST METROPOLITAN DISTRICT, COLORADO Notes: Financial Management Plan Capital Projects Fund Capital Project Fund Inflation Assumptions 1 Sales and Use Taxes 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%0 4.00% 2 Interest Earnings 1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%0 1.50% 3 Expenses 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%0 4.00% 4 CIP Inflation Factor 3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%0 3.00% 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2,028 2029 CAPITAL PROJECTS FUND Budget REVENUE 5 Taxes 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6 Intergovernmental 85,000 0 0 196,186 431,000 0 0 0 0 0 0 0 0 0 0 7 Charges for Services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8 Interest Earnings 0 0 0 0 0 458 465 472 11,003 35,664 61,358 90,486 119,232 145,978 173,126 9 Grant Revenue 447,880 59,258 601,107 0 1,936,010 0 0 0 0 0 0 0 0 0 0 10 Miscellaneous Revenue 0 27,854 0 29,263 0 0 0 0 0 0 0 0 0 0 0 Debt Proceeds 11 Total Revenue 532,880 87,112 601,107 225,449 2,367,010 458 465 472 11,003 35,664 61,358 90,486 119,232 145,978 173,126 EXPENSES 12 Total Current 239,956 615,382 0 0 0 0 0 0 0 0 0 0 0 0 0 13 Total Capital Projects (Line 68)750,475 117,575 611,098 194,905 3,131,410 0 0 0 0 0 (203,167)(203,167)(203,167)(203,167)0 14 Bond Issuance Costs 0 0 0 0 15 Total Expenses 990,431 732,957 611,098 194,905 3,131,410 0 0 0 0 0 (203,167)(203,167)(203,167)(203,167)0 (94,694)(94,694)(94,694)(94,694) 16 Revenues Over / (Under) Expenses (457,551)(645,845)(9,991)30,544 (764,400)458 465 472 11,003 35,664 264,525 293,653 322,399 349,145 173,126 OTHER FINANCING SOURCES / (USES) 17 Bond Proceeds (Line 69)0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 18 Sale of Capital Assets 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 19 Transfers In - General Fund 81,000 30,000 0 0 630,354 0 0 701,575 1,633,070 1,677,311 1,677,311 1,622,774 1,460,674 1,460,674 960,674 20 Transfers In - Community Development/Land Sales 0 472,000 0 0 0 0 0 0 0 0 0 0 0 0 0 21 Transfers Out - Conservation Trust Fund 0 (85,000)0 0 0 0 0 0 0 0 0 0 0 0 0 22 Total Other Sources / (Uses)81,000 417,000 0 0 630,354 0 0 701,575 1,633,070 1,677,311 1,677,311 1,622,774 1,460,674 1,460,674 960,674 23 Prior Period Adjustments 24 Ending Fund Balance 372,882 144,037 134,046 164,590 30,544 31,002 31,467 733,514 2,377,587 4,090,562 6,032,398 7,948,825 9,731,898 11,541,717 12,675,517 Multiple 2019 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2,028 2029 Capital Project Name Department Year?First Year Last Year Costs Actual Budget 25 Capistrano at PWHS Streets No 2019 380,000 - 380,000 - - - - - - - - 0 - 26 N. McColloch & Platteville Streets No 2019 263,700 - 263,700 - - - - - - - - 0 - 27 Spaulding & Capistrano Streets No 2019 600,000 - 600,000 - - - - - - - - 0 - 28 Design & Engineering Fire Station #2 Fire No 2018 180,000 180,000 - - - - - - - - - 0 - 29 TAP #1 East/West Completion Parks No 2018 90,000 90,000 - - - - - - - - - 0 - 30 Cedar Ridge ADA Playground Parks No 2018 130,000 130,000 - - - - - - - - - 0 - 31 Intersection drainage improvements Streets No 2019 250,000 - 250,000 - - - - - - - - 0 - 32 Skyline Lane road improvements Streets No 2019 75,000 - 75,000 - - - - - - - - 0 - 33 State Ave. road improvements Streets No 2019 75,000 - 75,000 - - - - - (203,167) (203,167) (203,167) (203,167)- 34 FLAP Trail Grant Parks No 2019 431,000 - 431,000 - - - - - - - - 0 - 35 TAP #2 McCulloch North Parks No 2019 457,107 - 457,107 - - - - - - - - 0 - 36 TAP #3 Purcell to SDS Parks No 2019 449,603 - 449,603 - - - - - - - - 0 - 37 Electrical upgrades building 109 Administration No 2019 150,000 - 150,000 - - - - - - - - 0 - 38 TP-1 office extension - - - - - - - - - - 0 - 39 Construction of Fire Station #2 - - - - - - - - - 0 - 40 New Administrative Building - - - - - - - - - 0 - 43 - - - - - - - - - - 0 - 44 - - - - - - - - - - 0 - 48 - - - - - - - - - - 0 - 49 - - - - - - - - - - 0 - 50 - - - - - - - - - - 0 - 53 - - - - - - - - - - 0 - 54 - - - - - - - - - - 0 - 55 - - - - - - - - - - 0 - 56 - - - - - - - - - - 0 - 57 - - - - - - - - - - 0 - 58 - - - - - - - - - - 0 - 59 - - - - - - - - - - 0 - 60 - - - - - - - - - - 0 - 63 - - - - - - - - - - 0 - 64 - - - - - - - - - - 0 - 68 Total Capital Projects 3,531,410 400,000 3,131,410 - - - - - (203,167) (203,167) (203,167) (203,167)- PROJECTED NEW DEBT TERMS Per MA:As of Date: 69 Par Amount (Line 17)- - - - - - - - - - 0 - 70 Number of Years 5 5 5 10 10 10 10 10 10 10 10 10 71 Interest Rate 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%0 4.00% 72 New Debt Service 0 0 0 0 0 0 0 0 0 0 0 0CASH FLOW ANALYSISProjected CAPITAL PROJECTS & DEBT LEVYProject Projected Actual Page 4 - Capital Projects Fund 11/4/2019 PUEBLO WEST METROPOLITAN DISTRICT, COLORADO Notes: Financial Management Plan Conservation Trust Fund Special Projects Fund Inflation Assumptions 1 Sales and Use Taxes 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%0 4.00% 2 Interest Earnings 1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%0 1.50% 3 Expenses 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%0 4.00% 3 4 CIP Inflation Factor 3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%0 3.00% 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2,028 2029 CONSERVATION TRUST FUND Budget REVENUE 5 Taxes 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6 Intergovernmental 144,620 168,391 321,002 155,439 315,000 220,890 220,890 220,890 220,890 220,890 220,890 220,890 220,890 220,890 220,890 7 Charges for Services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8 Interest Earnings 885 1,828 3,027 5,638 0 5,008 8,139 11,307 14,511 17,753 21,032 27,395 33,841 40,371 46,985 9 Grant Revenue 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 Miscellaneous Revenue 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11 Total Revenue 145,505 170,219 324,029 161,077 315,000 225,898 229,029 232,197 235,401 238,643 241,922 248,285 254,731 261,261 267,875 EXPENSES 12 Total Current 11,094 35,098 11,866 17,851 16,500 17,160 17,846 18,560 19,302 20,074 20,877 21,712 22,580 23,483 24,422 13 Total Capital Projects (Line 68)86,508 238,389 265,901 71,209 501,590 0 0 0 0 0 (203,167)(203,167)(203,167)(203,167)0 14 Bond Issuance Costs 0 0 0 0 15 Total Expenses 97,602 273,487 277,767 89,060 518,090 17,160 17,846 18,560 19,302 20,074 (182,290)(181,455)(180,587)(179,684)24,422 (94,694)(94,694)(94,694)(94,694) 16 Revenues Over / (Under) Expenses 47,903 (103,268)46,262 72,017 (203,090)208,738 211,183 213,637 216,099 218,569 424,212 429,740 435,318 440,945 243,453 OTHER FINANCING SOURCES / (USES) 17 Bond Proceeds (Line 69)0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 18 Sale of Capital Assets 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 19 Transfers In - Capital Projects Fund 0 85,000 0 0 0 0 0 0 0 0 0 0 0 0 0 20 Transfers In - 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 21 Transfers Out 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 22 Total Other Sources / (Uses)0 85,000 0 0 0 0 0 0 0 0 0 0 0 0 0 23 Prior Period Adjustments 24 Ending Fund Balance 436,953 418,685 464,947 536,964 333,874 542,612 753,796 967,433 1,183,533 1,402,102 1,826,314 2,256,055 2,691,373 3,132,319 3,375,772 Multiple 2019 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2,028 2029 Capital Project Name Department Year?First Year Last Year Costs Actual Budget 25 Multi-purpose utility vehicle Parks No 2018 17,000 17,000 - - - - - - - - - 0 - 26 TAP #1 East/West Completion Parks No 2018 40,000 40,000 - - - - - - - - - 0 - 27 McCulloch North Trail Seeding Parks No 2018 15,000 15,000 - - - - - - - - - 0 - 28 Riding Lawn Mower Parks No 2019 20,000 - 20,000 - - - - - - - - 0 - 29 Diving Board and Stand Parks No 2019 18,000 - 18,000 - - - - - - - - 0 - 30 FLAP Trail Parks No 2019 65,000 - 65,000 - - - - - - - - 0 - 31 TAP #2 McCulloch North Parks No 2019 195,903 - 195,903 - - - - - - - - 0 - 32 TAP #3 Purcell to SDS Parks No 2019 192,687 - 192,687 - - - - - - - - 0 - 33 - - - - - - - (203,167) (203,167) (203,167) (203,167)- 34 - - - - - - - - - - 0 - 35 - - - - - - - - - - 0 - 36 - - - - - - - - - - 0 - 37 - - - - - - - - - - 0 - 38 - - - - - - - - - - 0 - 39 - - - - - - - - - - 0 - 40 - - - - - - - - - - 0 - 68 Total Capital Projects 563,590 72,000 491,590 - - - - - (203,167) (203,167) (203,167) (203,167)- PROJECTED NEW DEBT TERMS Per MA:As of Date: 69 Par Amount (Line 17)- - - - - - - - - - 0 - 70 Number of Years 5 5 5 10 10 10 10 10 10 10 10 10 71 Interest Rate 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%0 4.00% 72 New Debt Service 0 0 0 0 0 0 0 0 0 0 0 0 Intergovernmental Revenue is calcultated as the average of the previous 5 years CAPITAL PROJECTS & DEBT LEVYProject ProjectedCASH FLOW ANALYSISProjectedActual Page 5 - Conservation Trust Fund 11/4/2019 PUEBLO WEST METROPOLITAN DISTRICT, COLORADO Notes: Financial Management Plan Parks Donation Fund Special Projects Fund Inflation Assumptions 1 Sales and Use Taxes 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%0 4.00% 2 Interest Earnings 1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%0 1.50% 3 Expenses 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%0 4.00% 4 CIP Inflation Factor 3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%0 3.00% 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2,028 2029 PARKS DONATION FUND Budget REVENUE 5 Taxes 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6 Intergovernmental 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7 Charges for Services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8 Interest Earnings 0 0 0 0 0 324 328 333 338 343 349 (1,072)(2,492)(3,913)(5,333) 9 Grant Revenue 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 Miscellaneous Revenue 23,368 13,778 16,508 15,172 19,000 19,760 20,550 21,372 22,227 23,116 24,041 25,003 26,003 27,043 28,125 11 Total Revenue 23,368 13,778 16,508 15,172 19,000 20,084 20,878 21,705 22,565 23,459 24,390 23,931 23,511 23,130 22,792 EXPENSES 12 Total Current 7,880 11,522 14,674 15,316 19,000 19,760 20,550 21,372 22,227 23,116 24,041 25,003 26,003 27,043 28,125 13 Total Capital Projects (Line 68)2,917 0 0 0 0 0 0 0 0 0 (203,167)(203,167)(203,167)(203,167)0 14 Bond Issuance Costs 0 0 0 0 15 Total Expenses 10,797 11,522 14,674 15,316 19,000 19,760 20,550 21,372 22,227 23,116 (179,126)(178,164)(177,164)(176,124)28,125 16 Revenues Over / (Under) Expenses 12,571 2,256 1,834 (144)0 324 328 333 338 343 (94,694)(94,694)(94,694)(94,694)(5,333) OTHER FINANCING SOURCES / (USES) 17 Bond Proceeds (Line 69)0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 18 Sale of Capital Assets 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 19 Transfers In - Capital Projects Fund 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20 Transfers In - 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 21 Transfers Out 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 22 Total Other Sources / (Uses)0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 23 Prior Period Adjustments 24 Ending Fund Balance 17,626 19,882 21,716 21,572 21,572 21,896 22,224 22,557 22,895 23,238 (71,456)(166,150)(260,844)(355,538)(360,871)CASH FLOW ANALYSISProjectedActual Page 6 - Parks Donation Fund 11/4/2019 PUEBLO WEST METROPOLITAN DISTRICT, COLORADO Financial Management Plan Internal Services Fund Internal Service Fund Inflation Assumptions 1 Revenue (Non-property tax)10.00%10.00%10.00%10.00%10.00%10.00%10.00%10.00%0 10.00% 2 Interest Earnings 1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%0 1.50% 3 Expenses 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%0 4.00% 4 CIP Inflation Factor 3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%0 3.00% 5 New Initiatives (non-incorporation related)1 6 New Initiatives (incorporation related)1 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2,028 2029 INTERNAL SERVICES FUND Budget OPERATING REVENUE 6 Taxes 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7 Equipment Replacement Charges 954,352 958,444 880,073 758,052 977,097 1,074,807 1,182,288 1,300,517 1,430,569 1,573,626 1,730,989 1,904,088 2,094,497 2,303,947 2,534,342 7a Charge Increase for Non Inc Salary Increase 93,110 96,835 100,708 104,737 108,926 113,283 117,814 122,527 127,428 132,525 Charge Increase for Incorporation 309,297 309,297 321,669 334,536 347,917 361,834 376,307 391,359 407,014 423,294 8 Maintenance Charges 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 9 Total Operating Revenue 954,352 958,444 880,073 758,052 977,097 1,477,214 1,588,420 1,722,894 1,869,841 2,030,469 (94,694)(94,694)(94,694)(94,694)3,090,162 OPERATING EXPENSES 10 Personal Services 645,192 656,318 555,898 500,671 649,734 714,707 786,178 864,796 951,276 1,046,404 1,151,044 1,266,148 1,392,763 1,532,039 1,685,243 11 Materials and Supplies & Other 241,368 283,687 268,739 282,206 364,380 378,955 394,113 409,878 426,273 443,324 461,057 479,499 498,679 518,626 539,371 Salary Adjustment 18%80,966 84,204 87,572 91,075 94,718 98,507 102,447 106,545 110,807 115,239 Associated Benefits 12,145 12,631 13,136 13,661 14,208 14,776 15,367 15,982 16,621 17,286 Incorporation Salary and Benefits 163,290 163,290 169,822 176,614 183,679 191,026 198,667 206,614 214,879 223,474 Incorporation Operations Expense 146,007 146,007 151,847 157,921 164,238 170,808 177,640 184,745 192,135 199,821 12 Capital Replacement 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 13 Depreciation 37,164 39,631 40,311 0 0 0 14 Total Operating Expenses 923,724 979,636 864,948 782,877 1,014,114 1,496,070 1,586,423 1,697,051 1,816,821 1,946,571 2,087,218 2,239,769 2,405,329 2,585,107 2,780,434 15 Operating Income/(Loss)30,628 (21,192)15,125 (24,825)(37,017)(18,855)1,997 25,843 53,020 83,898 (2,181,912)(2,334,463)(2,500,023)(2,679,801)309,728 NON-OPERATING REVENUES/(EXPENSES) 16 Investment Income 0 0 0 0 0 106 (175)(148)238 1,037 2,311 (30,383)(65,856)(104,344)(146,106) 17 Gain on Sale of Assets 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 18 Operating Grant 5,000 19 Transfers In / (Out)0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20 Capital Contributions 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 21 TOTAL NON-OPERATING REVENUES/(EXPENSES)5,000 0 0 0 0 106 (175)(148)238 1,037 2,311 (30,383)(65,856)(104,344)(146,106) 22 Prior Period Adjustments 23 Ending Net Position 130,334 109,142 124,267 99,442 62,425 43,676 45,497 71,192 124,450 209,385 (203,167)(203,167)(203,167)(203,167)(39,545)STATEMENT OF REVENUES, EXPENSES & NET POSITIONProjectedActual Page 7 - Internal Services Fund PUEBLO WEST METROPOLITAN DISTRICT, COLORADO FINANCIAL MANAGEMENT PLAN (FMP) Water Utility 1 Water Rate Increase 2%2.0%1%1%1%1%1%1%1%1% 2 Investment Income 0.50%1.00%1.25%1.50%1.50%1.50%1.50%1.50%1.50%1.50% 3 Expenses 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% Budget WATER FUND 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2,029 4 Operating Revenues 5 Charges for Services 7,036,948 7,934,016 7,291,908 8,597,106 7,831,000 7,987,620 8,067,496 8,148,171 8,229,653 8,311,950 8,395,070 8,479,021 8,563,811 8,649,449 8,649,449 6 Tap Connection Fees 51,095 160,406 248,432 339,015 191,700 191,700 191,700 191,700 191,700 191,700 191,700 191,700 191,700 191,700 191,700 7 Water Leases 94,427 7,372 25,787 27,493 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 8 Total Operating Revenues 7,182,470 8,101,794 7,566,127 8,963,614 8,024,700 8,181,320 8,261,196 8,341,871 8,423,353 8,505,650 8,588,770 8,672,721 8,757,511 8,843,149 8,843,149 9 10 Operating Expenses 11 Operation and Maintenance 4,318,285 5,335,073 5,757,006 5,872,461 6,168,121 6,414,846 6,671,440 6,938,298 7,215,830 7,504,463 7,804,642 8,116,828 8,441,501 8,779,161 8,779,161 Salary Adjustment 18%329,541 342,723 356,432 370,689 385,517 400,938 416,975 433,654 451,000 451,000 Associated Benefits 49,431 51,408 53,465 55,603 57,828 60,141 62,546 65,048 67,650 67,650 12 Depreciation 2,192,519 2,430,739 2,399,391 2,389,240 2,484,810 2,584,202 2,687,570 2,795,073 2,906,876 3,023,151 3,144,077 3,269,840 3,400,634 3,536,659 3,536,659 13 Total Operating Expenses 6,510,804 7,765,812 8,156,397 8,261,701 8,652,931 9,378,021 9,753,142 10,143,268 10,548,999 10,970,958 11,409,797 11,866,189 12,340,837 12,834,470 12,834,470 14 15 Net Operations 671,666 335,982 (590,270)701,913 (628,231)(1,196,701)(1,491,946)(1,801,397)(2,125,646)(2,465,308)(2,821,027)(3,193,468)(3,583,326)(3,991,321)(3,991,321) 16 Non-Operating Revenues/(Expenses) 17 Investment Income 39,217 81,027 134,171 247,038 175,000 175,000 175,000 175,000 175,000 175,000 175,000 175,000 175,000 175,000 175,000 18 Interest Expense (245,093)(160,457)(100,912)(92,872)(165,182)(179,437)(165,931)(146,832)(122,194)(113,216)(104,050)(94,694)(94,694)(94,694)(94,694) 19 Debt Issuance Costs 0 (56,549)0 0 0 20 Insurance Recovery 0 0 58,795 22,753 0 21 Operating Grant 0 55,157 29,998 0 0 22 Gain/(Loss) on Sale of Assets 1,023 (97,831)0 0 0 0 0 0 0 0 0 0 0 0 0 23 Capital Contributions 791,296 1,296,863 2,091,530 2,934,730 1,662,300 24 Transfers In/(Out)308,863 306,729 303,978 306,788 0 0 0 0 0 0 0 0 0 0 0 24a Transfer Out for Civic Bldg Debt 154,375 154,925 153,395 153,814 154,401 154,565 154,640 154,624 154,458 154,138 25 Total Non-Operating Revenues/(Expenses)895,306 1,424,939 2,517,560 3,418,437 1,672,118 (4,437)9,069 28,168 52,806 61,784 70,950 80,306 80,306 80,306 80,306 26 27 Change in Net Position 1,566,972 1,760,921 1,927,290 4,120,350 1,043,887 (1,201,138)(1,482,877)(1,773,229)(2,072,840)(2,403,524)(2,750,077)(3,113,162)(3,503,020)(3,911,015)(3,911,015) 29 Ending Net Assets 62,874,282 64,635,203 66,562,493 70,682,843 71,726,730 70,525,592 69,042,716 67,269,487 65,196,647 62,793,123 60,043,045 56,929,883 53,426,863 49,515,847 45,604,832 30 CIP Funding 31 Purchase of Capital Assets (416,038)(654,141)(1,389,001)(563,798)(11,345,000)0 0 0 0 0 0 0 0 0 0 32 Acquisition of Note Receivable (308,863)(306,729)(303,978) 33 Bond/Note Proceeds Term Rate 0 4,565,000 0 0 60,000 385,000 34 Bond/Note P&I - Future 10 3.25%(7,124)(7,124)(7,124)(7,124)(7,124)(7,124)(7,124)(7,124)0 35 Bond/Note P&I - Future 10 3.25%(45,711)(45,711)(45,711)(45,711)(45,711)0 38 Bond/Note Prin - Existing (360,000)(5,530,000)(425,000)(606,154)(606,254)(621,643)(634,521)(649,927)(664,615)(684,645)(701,689)(203,167)(203,167)(203,167)(203,167) 39 40 Beginning Cash & Equivalents 5,076,370 5,076,370 5,076,371 5,076,371 31,137,479 22,714,922 23,536,343 24,099,392 24,464,185 25,011,482 24,893,629 24,533,104 24,433,779 24,075,391 23,445,032 Add Cash Held in General Fund 20,721,470 41 Add net operations (line13)671,666 335,982 (590,270)701,913 (628,231)(1,196,701)(1,491,946)(1,801,397)(2,125,646)(2,465,308)(2,821,027)(3,193,468)(3,583,326)(3,991,321)(3,991,321) 42 Add back depreciation (line12)2,192,519 2,430,739 2,399,391 2,389,240 2,484,810 2,584,202 2,687,570 2,795,073 2,906,876 3,023,151 3,144,077 3,269,840 3,400,634 3,536,659 3,536,659 43 Add net non operating (line 24)895,306 1,424,939 2,517,560 3,418,437 1,672,118 (4,437)9,069 28,168 52,806 61,784 70,950 80,306 80,306 80,306 80,306 44 Add capital and bond (lines 30-37)(1,084,901)(1,925,870)(2,117,979)(1,169,952)(11,951,254)(561,643)(641,645)(657,051)(286,739)(737,480)(754,524)(256,002)(256,002)(256,002)(226,712) 45 Net change in balance sheet items (2,700,542)(2,248,659)(2,231,351)0 46 Other investments 25,952 (17,130)22,649 0 47 Ending Cash & Equivalents 5,076,370 5,076,371 5,076,371 31,137,479 22,714,922 23,536,343 24,099,392 24,464,185 25,011,482 24,893,629 24,533,104 24,433,779 24,075,391 23,445,032 22,843,964 48 49 Cash & Investments 4,485,604 5,076,371 5,076,371 31,137,479 22,714,922 23,536,343 24,099,392 24,464,185 25,011,482 24,893,629 24,533,104 24,433,779 24,075,391 23,445,032 22,843,964 50 Restricted Cash & Investments 590,766 0 0 0 0 0 0 0 0 0 0 0 0 0 0WATER FUNDProjectionsActual Page 8 - Water Utility PUEBLO WEST METROPOLITAN DISTRICT, COLORADO FINANCIAL MANAGEMENT PLAN (FMP) Water Utility 1 Water Rate Increase 2%2.0%1%1%1%1%1%1%1%1% 2 Investment Income 0.50%1.00%1.25%1.50%1.50%1.50%1.50%1.50%1.50%1.50% 3 Expenses 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% ProjectionsActualCAPITAL IMPROVEMENTS 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2,029 51 2018 Capital Equipment 75,156 52 2018 Capital Projects 488,642 53 54 55 2019 Chevy 4x4 Colorado Truck 32,000 56 57 2019 1.5 Ton Utility Box 4x4 Truck 50,000 58 2019 Skidsteer 75,000 59 TP-1 office extension 200,000 60 Zone 251 construction 1,500,000 61 Looping mains 100,000 62 2 MG north tank 2,000,000 63 PRV's 300,000 64 Treatment for DOC 100,000 65 134 Part B Flume 50,000 66 Northside well development 1,500,000 67 Wild Horse pipeline 4,300,000 68 ROY storage assessment 200,000 69 SDS Partner Share 60,000 70 RPS discharge 600,000 71 River pump #2 upgrade 278,000 72 73 TOTAL CIP 0 0 0 563,798 11,345,000 0 0 0 0 0 0 0 0 0 0 74 Inflation Rate 2%563,798 11,345,000 0 0 0 0 0 0 0 0 0 0CIP PLANPage 9 - Water Utility PUEBLO WEST METROPOLITAN DISTRICT, COLORADO FINANCIAL MANAGEMENT PLAN (FMP) Sewer Utility 1 Sewer Rate Increase 2.0%2.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0% 2 Investment Income 0.25%0.50%1.00%1.25%1.50%1.50%1.50%1.50%1.50%1.50%1.50% 3 Expenses 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% Budget SEWER FUND 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2,029 4 Operating Revenues 5 Charges for Services 2,599,635 2,672,325 2,798,796 3,212,644 3,228,497 3,293,067 3,325,998 3,359,258 3,392,851 3,426,780 3,461,048 3,495,658 3,530,615 3,565,921 3,565,921 6 Tap Connection Fees 14,711 22,944 42,126 43,540 21,680 21,680 21,680 21,680 21,680 21,680 21,680 21,680 21,680 21,680 21,680 7 Other Revenues 0 0 181 847 0 8 Total Operating Revenues 2,614,346 2,695,269 2,841,103 3,257,031 3,250,177 3,314,747 3,347,678 3,380,938 3,414,531 3,448,460 3,482,728 3,517,338 3,552,295 3,587,601 3,587,601 9 10 Operating Expenses 11 Operation and Maintenance 1,192,147 1,821,460 1,347,759 1,985,145 2,029,994 2,111,194 2,195,642 2,283,468 2,374,807 2,469,799 2,568,591 2,671,335 2,778,188 2,889,316 2,889,316 Salary Adjustment 18%107,716 112,025 116,506 121,166 126,013 131,053 136,296 141,747 147,417 153,314 Associated Benefits 16,157 16,804 17,476 18,175 18,902 19,658 20,444 21,262 22,113 22,997 12 Depreciation 1,077,532 1,044,914 1,030,434 1,019,826 1,060,619 1,103,044 1,147,166 1,193,053 1,240,775 1,290,406 1,342,022 1,395,703 1,451,531 1,509,592 1,509,592 13 Total Operating Expenses 2,269,679 2,866,374 2,378,193 3,004,971 3,090,613 3,338,112 3,471,637 3,610,503 3,754,923 3,905,120 4,061,324 4,223,778 4,392,728 4,568,438 4,575,219 14 15 Net Operations 344,667 (171,105)462,910 252,060 159,564 (23,365)(123,959)(229,565)(340,392)(456,660)(578,596)(706,440)(840,433)(980,837)(987,618) 16 Non-Operating Revenues/(Expenses) 17 Investment Income 5,308 10,966 18,159 62,730 40,000 56,642 4,058 17,196 32,933 42,876 51,995 60,198 67,726 74,194 74,194 18 Interest Expense (82,172)(77,506)(73,288)(163,765)(40,827)(37,789)(35,036)(32,569)(30,228)(23,862)(23,862)(94,694)(94,694)(94,694)(94,694) 19 Capital Contributions 88,120 103,572 215,609 324,966 136,080 0 0 0 0 0 0 0 0 0 0 19a Transfer Out to GF for Civic Bldg 50,172 50,351 49,853 49,990 50,180 50,234 50,258 50,253 50,199 50,095 20 Transfers In/(Out)0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 21 Total Non-Operating Revenues/(Expenses)11,256 37,032 160,480 223,931 135,253 69,025 19,373 34,480 52,695 69,194 78,367 15,762 23,285 29,699 29,595 22 23 Change in Net Position 355,923 (134,073)623,390 475,991 294,817 45,660 (104,586)(195,084)(287,698)(387,465)(500,230)(690,678)(817,149)(951,138)(958,023) 24 Ending Net Assets 12,988,401 12,854,328 13,477,718 13,953,709 14,248,526 14,294,186 14,189,600 13,994,516 13,706,818 13,319,353 12,819,123 12,128,445 11,311,297 10,360,159 9,402,135 25 CIP Funding 26 Purchase of Capital Assets (17,149)(221,898)(773,013)(3,905,524)(2,115,000)(6,242,400)0 0 0 0 0 0 0 0 0 27 Bond/Note Proceeds Term Rate 0 0 0 0 5,803,000 25,000 300,000 28 Bond/Note P&I - Future 10 3.25%(2,968)(2,968)(2,968)(2,968)(2,968)(2,968)(2,968)(354,892) 29 Bond/Note P&I - Future 10 3.25%(35,619)(35,619)(35,619)(35,619)(35,619)(35,619)(18,347) 32 Bond/Note Prin - Existing (228,267)(234,120)(234,120)(234,020)(239,973)(245,826)(245,826)(245,826)(251,679)(256,361)(256,361)(256,361)(256,361)(256,361)(256,361) 33 34 Beginning Cash & Equivalents 320,000 320,000 320,000 320,000 860,690 5,664,153 324,631 1,146,385 2,195,559 2,858,370 3,466,362 4,013,206 4,515,064 4,946,280 5,301,567 Add Cash Held by General Fund 3,184,417 35 Add net operations (lines 12 & 33)344,667 (171,105)462,910 252,060 159,564 (23,365)(123,959)(229,565)(340,392)(456,660)(578,596)(706,440)(840,433)(980,837)(987,618) 36 Add back depreciation (lines 8 & 29)1,077,532 1,044,914 1,030,434 1,019,826 1,060,619 1,103,044 1,147,166 1,193,053 1,240,775 1,290,406 1,342,022 1,395,703 1,451,531 1,509,592 1,509,592 37 Add net non operating (line 19 & 40)11,256 37,032 160,480 223,931 135,253 69,025 19,373 34,480 52,695 69,194 78,367 15,762 23,285 29,699 29,595 38 Add capital and bond (lines 45-54)(245,416)(456,018)(1,007,133)(4,139,544)3,448,027 (6,488,226)(220,826)51,206 (290,267)(294,949)(294,949)(203,167)(203,167)(203,167)(203,167) 39 Net change in balance sheet items (1,176,972)(443,924)(636,006)0 40 Other investments (11,067)(10,899)(10,685)0 41 Ending Cash & Equivalents 320,000 320,000 320,000 860,690 5,664,153 324,631 1,146,385 2,195,559 2,858,370 3,466,362 4,013,206 4,515,064 4,946,280 5,301,567 5,649,968 42 43 Cash & Investments 0 0 0 540,690 5,344,153 4,631 826,385 1,875,559 2,538,370 3,146,362 3,693,206 4,195,064 4,626,280 4,981,567 5,329,968 44 Restricted Cash & Investments 320,000 320,000 320,000 320,000 320,000 320,000 320,000 320,000 320,000 320,000 320,000 320,000 320,000 320,000 320,000SEWER FUNDProjectionsActual Page 10 - Sewer Fund PUEBLO WEST METROPOLITAN DISTRICT, COLORADO FINANCIAL MANAGEMENT PLAN (FMP) Sewer Utility 1 Sewer Rate Increase 2.0%2.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0% 2 Investment Income 0.25%0.50%1.00%1.25%1.50%1.50%1.50%1.50%1.50%1.50%1.50% 3 Expenses 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% ProjectionsActualCAPITAL IMPROVEMENTS 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2,029 45 2018 Capital Equipment 215,749 46 2018 Capital Projects 3,689,775 47 48 2019 Vac Truck 425,000 49 Bobcat UTV 20,000 50 State Ave Force Main Design 6,000,000 51 Replace Force Main LS2-LS1 780,000 52 Plant Design Nutrient Handling 300,000 53 LS2 Pond Perimeter fence 40,000 54 Effluent reuse system 200,000 55 Biosolids aeration, control upgrades 350,000 56 57 TOTAL CIP 0 0 0 3,905,524 2,115,000 6,000,000 0 0 0 0 0 0 0 0 0 58 Inflation Rate 2%3,905,524 2,115,000 6,242,400 0 0 0 0 0 0 0 0 0CIP PLANPage 11 - Sewer Fund 11/4/2019 PUEBLO WEST METROPOLITAN DISTRICT, COLORADO Financial Management Plan Community Development Fund Enterprise Fund Inflation Assumptions 1 Revenue (Non-property tax)2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%0 2.00% 2 Interest Earnings 1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%0 1.50% 3 Expenses 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%0 4.00% 4 5 CIP Inflation Factor 3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%0 3.00% 6New Initiatives (non-incorporation related)1 7 New Initiatives (incorporation related)1 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2,028 2029 COMMUNITY DEVELOPMENT FUND Budget Operating Revenues 8 Land Sales & User Fees 388,190 1,204,071 171,127 138,498 225,000 425,377 425,377 425,377 425,377 425,377 425,377 425,377 425,377 425,377 425,377 9 Other 0 0 250 3,086 100 102 104 106 108 110 112 114 116 118 120 10 Total Operating Revenue 388,190 1,204,071 171,377 141,584 225,100 425,479 425,481 425,483 425,485 425,487 425,489 425,491 425,493 425,495 425,497 Operating Expenses 11 Operation and Maintenance 306,833 341,787 388,498 365,419 411,424 419,652 428,045 436,606 445,338 454,245 463,330 472,597 482,049 491,690 501,524 Salary Adjustment 18%37,138 38,623 40,168 41,775 43,446 45,184 46,991 48,871 50,826 52,859 Associated Benefits 5,571 5,794 6,025 6,266 6,517 6,778 7,049 7,331 7,624 7,929 Incorporation Salary and Benefits 211,448 219,906 228,702 237,850 247,364 257,259 267,549 278,251 Incorporation Operations Expense 75,354 78,368 81,503 84,763 88,154 91,680 95,347 99,161 12 Depreciation 0 0 0 0 0 (94,694)(94,694)(94,694)(94,694) 13 Total Operating Expenses 306,833 341,787 388,498 365,419 411,424 462,361 472,462 769,602 791,654 814,413 743,211 767,461 792,495 818,342 939,724 14 Operating Income/(Loss)81,357 862,284 (217,121)(223,835)(186,324)(36,881)(46,981)(344,118)(366,168)(388,926)(317,722)(341,970)(367,002)(392,847)(514,226) Non-Operating Revenues/(Expenses) 15 Investment Income 0 0 0 5,781 6,000 (1,507)2,859 7,338 7,632 7,814 7,880 (1,682)(1,948)(2,078)(8,095) 16 Gain on Sale of Assets 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 17 Transfers In / (Out)0 (472,000)0 (90,000)(50,000)0 0 0 0 0 0 0 0 0 0 17a Transfer from General/NonInc Costs 42,709 44,417 46,194 48,041 49,963 51,962 54,040 56,202 58,450 60,788 17b Transfer from General/Inc Costs 286,802 298,274 310,205 322,613 335,518 348,938 362,896 377,412 0 0 18 Capital Contributions 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 19 Total Non-Operating Revenues/(Expenses)0 (472,000)0 (84,219)(44,000)328,004 345,550 363,737 378,287 393,295 408,780 415,254 431,666 56,372 52,693 20 Change in Net Position 81,357 390,284 (217,121)(308,054)(230,324)291,122 298,569 19,618 12,118 4,369 91,058 73,284 64,664 (336,475)(461,534) 21 Ending Net Assets 4,746,442 5,136,726 4,919,605 4,611,551 4,381,227 4,672,349 4,970,918 4,990,537 5,002,655 5,007,024 5,098,082 5,171,367 5,236,030 4,899,556 4,438,022 CIP FUNDING 22 Capital Projects (Line 78)0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 23 Bond Proceeds (Line 79)0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 24 Total Future Bond Payments 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 CASH RECONCILIATION 25 Beginning Cash 0 0 0 0 129,830 (100,494)190,628 489,197 508,816 520,934 (203,167)(203,167)(203,167)(203,167)(539,642) Add Cash Held in the General Fund 437,884 26 Add: Operating Income/(Loss) (Line 14)81,357 862,284 (217,121)(223,835)(186,324)(36,881)(46,981)(344,118)(366,168)(388,926)(317,722)(341,970)(367,002)(392,847)(514,226) 27 Add: Net Non-Operating (Line 19)0 (472,000)0 (84,219)(44,000)328,004 345,550 363,737 378,287 393,295 408,780 415,254 431,666 56,372 52,693 28 Add: Capital and Bond (Lines 22 - 24)0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 29 Net Change in Cash Flows 0 0 0 30 Net Change in Balance Sheet (81,357)(390,284)217,121 31 Ending Cash 0 0 0 129,830 (100,494)190,628 489,197 508,816 520,934 525,303 (112,109)(129,883)(138,503)(539,642)(1,001,175) 32 33 Cash & Investments 0 0 0 129,830 (100,494)190,628 489,197 508,816 520,934 525,303 (112,109)(129,883)(138,503)(539,642)(1,001,175) 34 Restricted Cash & Investments 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Land Sales and User Fees are the average of the five preceding years STATEMENT OF REVENUES, EXPENSES & NET POSITIONProjected STATEMENT OF CASH FLOWSActual Page 12 - Community Development Fund 11/4/2019 PUEBLO WEST METROPOLITAN DISTRICT, COLORADO Financial Management Plan Swimming Pool Fund Enterprise Fund Inflation Assumptions 1 Revenue (Non-property tax)2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%0 2.00% 2 Interest Earnings 1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%0 1.50% 3 Expenses 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%0 4.00% 4 CIP Inflation Factor 3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%0 3.00% 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2,028 2029 SWIMMING POOL FUND Budget Operating Revenues 5 Charges for Services 33,545 33,867 36,000 43,266 40,600 40,600 40,600 40,600 40,600 40,600 40,600 40,600 40,600 40,600 40,600 6 Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7 Total Operating Revenue 33,545 33,867 36,000 43,266 40,600 40,600 40,600 40,600 40,600 40,600 40,600 40,600 40,600 40,600 40,600 Operating Expenses 8 Operation and Maintenance 110,622 86,777 73,447 75,305 98,851 100,828 102,845 104,902 107,000 109,140 111,323 113,549 115,820 118,136 120,499 Salary Adjustment 18%7,300 7,592 7,895 8,211 8,540 8,881 9,236 9,606 9,990 10,390 Associated Benefits 1,095 1,139 1,184 1,232 1,281 1,332 1,385 1,441 1,499 1,558 9 Depreciation 0 16,632 15,753 15,477 15,477 15,477 15,477 15,477 15,477 15,477 15,477 15,477 15,477 15,477 15,477 10 Total Operating Expenses 110,622 103,409 89,200 90,782 114,328 124,700 127,052 129,459 131,920 134,438 137,013 139,648 142,344 145,102 147,924 11 Operating Income/(Loss)(77,077)(69,542)(53,200)(47,516)(73,728)(84,100)(86,452)(88,859)(91,320)(93,838)(96,413)(99,048)(101,744)(104,502)(107,324) Non-Operating Revenues/(Expenses)(94,694)(94,694)(94,694)(94,694) 12 Investment Income 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 13 Gain on Sale of Assets 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 14 Transfers In / (Out)116,000 30,000 43,700 56,000 30,000 30,000 50,000 80,000 100,000 125,000 125,000 125,000 125,000 125,000 125,000 15 Capital Contributions 0 7,482 0 0 0 0 0 0 0 0 0 0 0 0 0 16 Total Non-Operating Revenues/(Expenses)116,000 37,482 43,700 56,000 30,000 30,000 50,000 80,000 100,000 125,000 125,000 125,000 125,000 125,000 125,000 17 Change in Net Position 38,923 (32,060)(9,500)8,484 (43,728)(54,100)(36,452)(8,859)8,680 31,162 28,587 25,952 23,256 20,498 17,676 18 Ending Net Assets 189,432 157,372 147,872 156,356 112,628 58,528 22,076 13,217 21,897 53,060 81,646 107,598 130,855 151,353 169,029 CIP FUNDING 19 Capital Projects (Line 76)(40,133)0 0 0 0 0 0 0 0 0 0 0 0 0 0 20 Bond Proceeds (Line 77)0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 21 Total Future Bond Payments 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 CASH RECONCILIATION 22 Beginning Cash 0 0 0 0 59,593 31,342 (7,281)(28,256)(21,638)2,519 49,159 (109,945)(271,683)(436,116)(603,308) Add Cash Held by General Fund 35,632 23 Add: Operating Income/(Loss) (Line 11)(77,077)(69,542)(53,200)(47,516)(73,728)(84,100)(86,452)(88,859)(91,320)(93,838)(96,413)(99,048)(101,744)(104,502)(107,324) 24 Add: Depreciation (line 9)0 16,632 15,753 15,477 15,477 15,477 15,477 15,477 15,477 15,477 15,477 15,477 15,477 15,477 15,477 25 Add: Net Non-Operating (Line 16)116,000 37,482 43,700 56,000 30,000 30,000 50,000 80,000 100,000 125,000 125,000 125,000 125,000 125,000 125,000 26 Add: Capital and Bond (Lines 19 - 21)(40,133)0 0 0 0 0 0 0 0 0 0 0 0 0 0 27 Net Change in Cash Flows 0 (7,482)0 28 Net Change in Balance Sheet 1,210 22,910 (6,253)(203,167)(203,167)(203,167)(203,167) 29 Ending Cash 0 0 0 59,593 31,342 (7,281)(28,256)(21,638)2,519 49,159 (109,945)(271,683)(436,116)(603,308)(570,155) 30 31 Cash & Investments 0 0 0 59,593 31,342 (7,281)(28,256)(21,638)2,519 49,159 (109,945)(271,683)(436,116)(603,308)(570,155) 32 Restricted Cash & Investments 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0STATEMENT OF REVENUES, EXPENSES & NET POSITIONProjected STATEMENT OF CASH FLOWSActual Page 13 - Swimming Pool Fund