Loading...
HomeMy Public PortalAbout03 - Master - Pueblo West Non-ModifiedPUEBLO 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 0 9 Sustainable Metro Increased Staff 0 10 Sustainable Metro Salary Increases 0 11 New Initiatives (incorporation related)0 12 Debt Service for Civic Building 0 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 5,344,323 5,671,945 5,842,155 6,132,175 6,308,816 6,624,265 6,793,655 7,102,306 7,279,023 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 0 0 0 0 0 0 0 0 0 0 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 379,232 386,817 394,553 402,444 410,493 418,703 427,077 435,618 444,331 453,217 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 47,255 42,980 39,503 34,157 28,678 25,870 23,109 18,007 12,442 22 Other 3,801 14,791 11,535 1,024 0 0 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 8,437,399 8,607,337 9,007,575 9,253,485 9,619,704 9,874,871 10,274,064 10,529,891 10,925,383 11,191,326 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 0 0 0 0 0 0 0 0 0 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%0 0 0 0 0 0 0 0 0 30b Associated Benefits 0 0 0 0 0 0 0 0 0 30c Non-incorporation Increased Payments to Internal Services Fund 0 0 0 0 0 0 0 0 0 31a Add 37 Positions to Current Staff Salary and Benefits 0 0 0 0 0 0 0 0 0 31b Add 37 Positions to Current Staff Ongoing Ops 0 0 0 0 0 0 0 0 0 32a Incorporation Salary and Benefits 0 0 0 0 0 0 0 0 32b Incorporation Operations Expense 0 0 0 0 0 0 0 0 32c Incorporation Payments increased to Internal Service Fund 0 0 0 0 0 0 0 0 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 1,924 949 0 35a Debt Service for Civic Building 0 0 0 0 0 0 0 0 0 0 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 0 0 0 0 0 0 0 0 0 0 38b New Civic Building 0 39 Start-up desks, computers, etc 0 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 8,319,285 8,531,155 8,844,793 9,194,478 9,545,334 9,925,692 10,321,264 10,732,660 11,158,615 11,569,100 43 REVENUE OVER (UNDER) EXPENSES 56,856 (536,014)1,021,196 646,295 (345,475)118,114 76,182 162,782 59,006 74,371 (50,821)(47,200)(202,769)(233,233)(377,774) 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 0 0 0 0 0 0 0 0 0 154,138 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 0 0 0 0 0 0 0 0 Non-Modified Current Status 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 0 9 Sustainable Metro Increased Staff 0 10 Sustainable Metro Salary Increases 0 11 New Initiatives (incorporation related)0 12 Debt Service for Civic Building 0 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Budget Non-Modified Current Status 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 0 0 0 0 0 0 0 0 0 0 47c Transfers to Community Dev Fund - Incorp Costs 0 0 0 0 0 0 0 0 0 0 48 Lease/other Debt Proceeds 914,192 0 395,676 0 0 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)(333,813)(354,813)(385,188)(404,938)(429,063)(125,000)(125,000)(125,000)(125,000)29,138 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,412,287 3,133,657 2,911,251 2,565,320 2,210,628 2,034,807 1,862,607 1,534,838 1,176,605 827,969 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 249,579 255,935 265,344 275,834 286,360 297,771 309,638 321,980 334,758 347,073 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,150,334 2,865,348 2,633,533 2,277,112 1,911,894 1,724,662 1,540,595 1,200,484 829,473 468,522 58 % of FB to Current Year Exp (basis for City Policy)36%37%52%64%34%38%34%30%25%20%17%15%11%7%4% 59 % of FB to Current Year Revenues (calcs used by Moody's)36%40%45%59%36%37%33%29%25%20%17%15%11%8%4%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 0 9 Sustainable Metro Increased Staff 0 10 Sustainable Metro Salary Increases 0 11 New Initiatives (incorporation related)0 12 Debt Service for Civic Building 0 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Budget Non-Modified Current Status 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 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 45,972,601 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,287,041 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 5,344,323 5,671,945 5,842,155 6,132,175 6,308,816 6,624,265 6,793,655 7,102,306 7,279,023 75 Annual Increase 3.4%2.6%7.9%1.7%6.1%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 - - - - - - - - - - 77a Debt Service Mill Levy - - - - - - - - - - - - - 77b Mill Levy Required for Sustainable Metro Salary Adjustment - - - - - - - - - 77d Mill Levy Required for Sustainable Metro Increased Staff - - - - - - - - - 77e Mill Levy Required for Incorporation Added Salary and Operations 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 77 Grand Total Mill Levy Required Current Plus Adjustments As Shown 20.2300 20.2300 20.2300 20.2300 20.2300 20.2300 20.2300 20.2300 20.2300 20.2300 Total Property Taxes Assuming Adjustments Shown 4,593,405 4,749,852 4,854,867 5,256,547 5,344,323 5,671,945 5,842,155 6,132,175 6,308,816 6,624,265 6,793,655 7,102,306 7,279,023PROPERTY 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%4.00%4.00% 2 Interest Earnings 1.50%1.50%1.50%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 CIP Inflation Factor 3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00% 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 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 479 486 494 501 508 516 524 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 479 486 494 501 508 516 524 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 0 0 0 0 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 0 0 0 0 0 16 Revenues Over / (Under) Expenses (457,551)(645,845)(9,991)30,544 (764,400)458 465 472 479 486 494 501 508 516 524 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 0 0 0 0 0 0 0 0 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 0 0 0 0 0 0 0 0 23 Prior Period Adjustments 24 Ending Fund Balance 372,882 144,037 134,046 164,590 30,544 31,002 31,467 31,939 32,418 32,904 33,398 33,899 34,407 34,923 35,447CASH FLOW ANALYSISProjectedActual 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%4.00%4.00% 2 Interest Earnings 1.50%1.50%1.50%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% 3 4 CIP Inflation Factor 3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00% 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 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 24,347 27,700 31,090 34,518 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 245,237 248,590 251,980 255,408 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 0 0 0 0 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 20,877 21,712 22,580 23,483 24,422 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 221,045 223,525 226,010 228,497 230,986 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,623,147 1,846,673 2,072,683 2,301,181 2,532,167 Multiple 2019 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 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 - - - - - - - - - - - 26 TAP #1 East/West Completion Parks No 2018 40,000 40,000 - - - - - - - - - - - 27 McCulloch North Trail Seeding Parks No 2018 15,000 15,000 - - - - - - - - - - - 28 Riding Lawn Mower Parks No 2019 20,000 - 20,000 - - - - - - - - - - 29 Diving Board and Stand Parks No 2019 18,000 - 18,000 - - - - - - - - - - 30 FLAP Trail Parks No 2019 65,000 - 65,000 - - - - - - - - - - 31 TAP #2 McCulloch North Parks No 2019 195,903 - 195,903 - - - - - - - - - - 32 TAP #3 Purcell to SDS Parks No 2019 192,687 - 192,687 - - - - - - - - - - 33 - - - - - - - - - - - - 34 - - - - - - - - - - - - 35 - - - - - - - - - - - - 36 - - - - - - - - - - - - 37 - - - - - - - - - - - - 38 - - - - - - - - - - - - 39 - - - - - - - - - - - - 40 - - - - - - - - - - - - 68 Total Capital Projects 563,590 72,000 491,590 - - - - - - - - - - PROJECTED NEW DEBT TERMS Per MA:As of Date: 69 Par Amount (Line 17)- - - - - - - - - - - - 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%4.00%4.00% 72 New Debt Service (See Page 2)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%4.00%4.00% 2 Interest Earnings 1.50%1.50%1.50%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 CIP Inflation Factor 3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00% 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 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 354 359 365 370 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 25,357 26,362 27,408 28,495 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 0 0 0 0 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 24,041 25,003 26,003 27,043 28,125 16 Revenues Over / (Under) Expenses 12,571 2,256 1,834 (144)0 324 328 333 338 343 349 354 359 365 370 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 23,587 23,941 24,300 24,665 25,035CASH 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%10.00%10.00% 2 Interest Earnings 1.50%1.50%1.50%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 CIP Inflation Factor 3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00% 5 New Initiatives (non-incorporation related)0 6 New Initiatives (incorporation related)0 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 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 0 0 0 0 0 0 0 0 0 0 Charge Increase for Incorporation 0 0 0 0 0 0 0 0 0 0 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,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 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%0 0 0 0 0 0 0 0 0 0 Associated Benefits 0 0 0 0 0 0 0 0 0 0 Incorporation Salary and Benefits 0 0 0 0 0 0 0 0 0 0 Incorporation Operations Expense 0 0 0 0 0 0 0 0 0 0 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,093,662 1,180,291 1,274,674 1,377,549 1,489,728 1,612,101 1,745,647 1,891,442 2,050,665 2,224,614 15 Operating Income/(Loss)30,628 (21,192)15,125 (24,825)(37,017)(18,855)1,997 25,843 53,020 83,898 118,888 158,441 203,055 253,282 309,728 NON-OPERATING REVENUES/(EXPENSES) 16 Investment Income 0 0 0 0 0 106 (175)(148)238 1,037 2,311 4,129 6,567 9,712 13,656 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 4,129 6,567 9,712 13,656 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 330,584 493,154 702,776 965,770 1,289,153STATEMENT 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%0 0 0 0 0 0 0 0 0 0 Associated Benefits 0 0 0 0 0 0 0 0 0 0 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 8,999,048 9,359,010 9,733,371 10,122,706 10,527,614 10,948,719 11,386,668 11,842,135 12,315,820 12,315,820 14 15 Net Operations 671,666 335,982 (590,270)701,913 (628,231)(817,728)(1,097,814)(1,391,500)(1,699,353)(2,021,964)(2,359,949)(2,713,947)(3,084,624)(3,472,671)(3,472,671) 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 0 0 0 0 0 0 0 0 0 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 (822,165)(1,088,745)(1,363,332)(1,646,547)(1,960,180)(2,288,999)(2,633,641)(3,004,318)(3,392,365)(3,392,365) 29 Ending Net Assets 62,874,282 64,635,203 66,562,493 70,682,843 71,726,730 70,904,565 69,815,820 68,452,488 66,805,941 64,845,761 62,556,762 59,923,121 56,918,803 53,526,438 50,134,073 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,915,316 24,872,496 25,647,186 26,620,776 26,946,267 27,046,821 27,427,017 27,567,331 27,455,623 Add Cash Held in General Fund 20,721,470 41 Add net operations (line13)671,666 335,982 (590,270)701,913 (628,231)(817,728)(1,097,814)(1,391,500)(1,699,353)(2,021,964)(2,359,949)(2,713,947)(3,084,624)(3,472,671)(3,472,671) 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,915,316 24,872,496 25,647,186 26,620,776 26,946,267 27,046,821 27,427,017 27,567,331 27,455,623 27,373,204 48 49 Cash & Investments 4,485,604 5,076,371 5,076,371 31,137,479 22,714,922 23,915,316 24,872,496 25,647,186 26,620,776 26,946,267 27,046,821 27,427,017 27,567,331 27,455,623 27,373,204 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%0 0 0 0 0 0 0 0 0 0 Associated Benefits 0 0 0 0 0 0 0 0 0 0 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,214,238 3,342,808 3,476,521 3,615,582 3,760,205 3,910,613 4,067,038 4,229,719 4,398,908 4,398,908 14 15 Net Operations 344,667 (171,105)462,910 252,060 159,564 100,509 4,870 (95,583)(201,051)(311,745)(427,885)(549,700)(677,424)(811,307)(811,307) 16 Non-Operating Revenues/(Expenses) 17 Investment Income 5,308 10,966 18,159 62,730 40,000 56,642 4,979 19,492 36,526 47,950 58,567 68,375 77,309 85,298 85,298 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)(23,862)(23,862)(23,862)(23,862) 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 0 0 0 0 0 0 0 0 0 0 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 18,853 (30,057)(13,077)6,298 24,088 34,705 44,513 53,447 61,436 61,436 22 23 Change in Net Position 355,923 (134,073)623,390 475,991 294,817 119,362 (25,187)(108,660)(194,753)(287,657)(393,180)(505,187)(623,977)(749,871)(749,871) 24 Ending Net Assets 12,988,401 12,854,328 13,477,718 13,953,709 14,248,526 14,367,888 14,342,701 14,234,041 14,039,288 13,751,631 13,358,451 12,853,264 12,229,287 11,479,416 10,729,545 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)(245,862)(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 398,333 1,299,486 2,435,085 3,196,657 3,904,458 4,558,351 5,153,918 5,686,524 6,151,296 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 100,509 4,870 (95,583)(201,051)(311,745)(427,885)(549,700)(677,424)(811,307)(811,307) 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 18,853 (30,057)(13,077)6,298 24,088 34,705 44,513 53,447 61,436 61,436 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 (284,450)(294,949)(294,949)(294,949)(294,949)(294,949)(629,600) 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 398,333 1,299,486 2,435,085 3,196,657 3,904,458 4,558,351 5,153,918 5,686,524 6,151,296 6,281,417 42 43 Cash & Investments 0 0 0 540,690 5,344,153 78,333 979,486 2,115,085 2,876,657 3,584,458 4,238,351 4,833,918 5,366,524 5,831,296 5,961,417 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%2.00%2.00% 2 Interest Earnings 1.50%1.50%1.50%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 5 CIP Inflation Factor 3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00% 6New Initiatives (non-incorporation related)0 7 New Initiatives (incorporation related)0 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 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%0 0 0 0 0 0 0 0 0 0 Associated Benefits 0 0 0 0 0 0 0 0 0 0 Incorporation Salary and Benefits 0 0 0 0 0 0 0 0 0 0 Incorporation Operations Expense 0 0 0 0 0 0 0 0 0 0 12 Depreciation 0 0 0 0 0 13 Total Operating Expenses 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 14 Operating Income/(Loss)81,357 862,284 (217,121)(223,835)(186,324)5,827 (2,564)(11,123)(19,853)(28,758)(37,841)(47,106)(56,556)(66,195)(76,027) Non-Operating Revenues/(Expenses) 15 Investment Income 0 0 0 5,781 6,000 (1,507)(1,443)(1,503)(1,692)(2,015)(2,477)(3,082)(3,834)(4,740)(5,804) 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 0 0 0 0 0 0 0 0 0 0 17b Transfer from General/Inc Costs 0 0 0 0 0 0 0 0 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)(1,507)(1,443)(1,503)(1,692)(2,015)(2,477)(3,082)(3,834)(4,740)(5,804) 20 Change in Net Position 81,357 390,284 (217,121)(308,054)(230,324)4,320 (4,007)(12,626)(21,545)(30,773)(40,318)(50,188)(60,390)(70,935)(81,831) 21 Ending Net Assets 4,746,442 5,136,726 4,919,605 4,611,551 4,381,227 4,385,547 4,381,540 4,368,915 4,347,370 4,316,597 4,276,279 4,226,091 4,165,702 4,094,767 4,012,936 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)(96,174)(100,181)(112,806)(134,351)(165,124)(205,442)(255,630)(316,019)(386,954) 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)5,827 (2,564)(11,123)(19,853)(28,758)(37,841)(47,106)(56,556)(66,195)(76,027) 27 Add: Net Non-Operating (Line 19)0 (472,000)0 (84,219)(44,000)(1,507)(1,443)(1,503)(1,692)(2,015)(2,477)(3,082)(3,834)(4,740)(5,804) 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)(96,174)(100,181)(112,806)(134,351)(165,124)(205,442)(255,630)(316,019)(386,954)(468,785) 32 33 Cash & Investments 0 0 0 129,830 (100,494)(96,174)(100,181)(112,806)(134,351)(165,124)(205,442)(255,630)(316,019)(386,954)(468,785) 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%2.00%2.00% 2 Interest Earnings 1.50%1.50%1.50%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 CIP Inflation Factor 3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00% 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 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%0 0 0 0 0 0 0 0 0 0 Associated Benefits 0 0 0 0 0 0 0 0 0 0 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 116,305 118,322 120,379 122,477 124,617 126,800 129,026 131,297 133,613 135,976 11 Operating Income/(Loss)(77,077)(69,542)(53,200)(47,516)(73,728)(75,705)(77,722)(79,779)(81,877)(84,017)(86,200)(88,426)(90,697)(93,013)(95,376) Non-Operating Revenues/(Expenses) 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)(45,705)(27,722)221 18,123 40,983 38,800 36,574 34,303 31,987 29,624 18 Ending Net Assets 189,432 157,372 147,872 156,356 112,628 66,923 39,201 39,422 57,545 98,528 137,328 173,902 208,205 240,192 269,816 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 1,114 (11,131)4,567 38,167 94,627 148,904 200,955 250,735 298,199 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)(75,705)(77,722)(79,779)(81,877)(84,017)(86,200)(88,426)(90,697)(93,013)(95,376) 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) 29 Ending Cash 0 0 0 59,593 31,342 1,114 (11,131)4,567 38,167 94,627 148,904 200,955 250,735 298,199 343,300 30 31 Cash & Investments 0 0 0 59,593 31,342 1,114 (11,131)4,567 38,167 94,627 148,904 200,955 250,735 298,199 343,300 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