12-12-2016 Council Packet - Laserfiche WebLink

Home Browse Search

MSA Fund Current Fund Balance: $0 $572,000 State MSA Construction Balance = $550,000 Table B-6 Table B-Sa Project Project 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Annual Expenditures (MSA CIP) $643,545 $128,094 $208,703 $0 $0 $0 $1,330,342 $209,969 $0 $0 $225,567 $327,763 $312,156 $312,156 Annual MSA Maintenance Payment to the City $68,954 $68,954 $68,954 $68,954 $68,954 $68,954 $68,954 $68,954 $68,954 $68,954 $68,954 $68,954 $68,954 $68,954 Debt Service (interest) -from MSA maintenance account. 1 $39,438 1 $36,288 1 $33,138 1 $29,838 1 $26,388 $22,938 1 $19,188 1 $14,813 1 $10,125 1 $5,250 $1,186,810 $1,215,454 $1,244,958 $1,275,347 Debt Service (Principal) -from MSA Construction Account $105,000 $105,000 $110,000 $115,000 $115,000 $120,000 $125,000 $125,000 $130,000 $140,000 $0 $0 1 $0 Revenues (1) Total Expenses $856,936 $338,335 $420,794 $213,791 $210,341 $211,891 $1,543,483 $418,735 $209,079 $214,204 $294,521 $396,717 $381,110 $381,110 Pavement Management Levy $401,500 $401,500 $401,500 $401,500 $401,500 $401,500 $401,500 $401,500 $401,500 $401,500 $401,500 $401,500 $401,500 $401,500 Yearly Allocation - MSA Maintenance $123,833 $123,833 $123,833 $123,833 $123,833 $123,833 $123,833 $123,833 $123,833 $123,833 $123,833 $123,833 $123,833 $123,833 Yearly Allocation - MSA Construction $201,751 $201,751 $201,751 $201,751 $201,751 $201,751 $201,751 $201,751 $201,751 $201,751 $201,751 $201,751 $201,751 $201,751 Annual Balance ($531,352) ($12,751) ($95,210) $111,793 $115,243 $113,693 ($1,217,899) ($93,151) $116,506 $111,381 $31,064 ($71,133) ($55,526) ($55,526) Year End Cash Balance $18,648 $5,897 ($89,313) $22,480 $137,723 $251,416 ($966,483) ($1,059,634) ($943,128) ($831,748) ($800,684) ($871,817) ($927,342) ($982,868) Pavement Management Fund Current Balance: $1,429,949 Current Balance: $572,000 Table B-6 Table 13-5b Project Project 2017 2018 1 2019 1 2020 2021 1 2022 1 2023 1 2024 1 2025 1 2026 1 2027 2028 2029 2030 Annual Operation and Maintenance (1) $0 $0 1 $0 1 $0 $0 1 $0 1 $0 1 $0 1 $0 1 $0 1 $0 $0 $0 $0 CIP Expenditures $1,416,890 $653,029 $923,509 $1,075,025 $1,685,808 $676,847 $474,987 $1,531,663 $1,132,000 $1,159,000 $1,186,810 $1,215,454 $1,244,958 $1,275,347 Total Expenses $1,416,890 $653,029 $923,509 $1,075,025 $1,685,808 $676,847 $474,987 $1,531,663 $1,132,000 $1,159,000 $1,186,810 $1,215,454 $1,244,958 $1,275,347 Transfer to Equipment Fund for Sewer Equip $20,000 $0 $100,000 $31,500 $0 $450,000 $0 $35,000 $0 $0 $0 $0 1 $0 Revenues (1) Revenues(1) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Pavement Management Levy $401,500 $401,500 $401,500 $401,500 $401,500 $401,500 $401,500 $401,500 $401,500 $401,500 $401,500 $401,500 $401,500 $401,500 Annual Balance ($1,015,390) ($251,529) ($522,009) ($673,525) ($1,284,308) ($275,347) ($73,487) ($1,130,163) ($730,500) ($757,500) ($785,310) ($813,954) ($843,458) ($873,847) Year End Cash Balance ($443,390) ($694,919) ($1,216,928) ($1,890,452) ($3,174,760) ($3,450,107) ($3,523,594) ($4,653,757) ($5,384,257) ($6,141,757) ($6,927,067) ($7,741,021) ($8,584,479) ($9,458,326) Water Fund Current Balance: $1,429,949 $2,908,044 Table B-6 Table B-7 Project 2017 2018 2019 2020 2021 2022 1 2023 1 2024 1 2025 1 2026 1 2027 1 2028 2029 1 2030 Annual Operation and Maintenance (1) $489,620 $501,861 $514,407 $527,267 $540,449 $553,960 1 $567,809 1 $582,004 1 $596,554 1 $611,468 1 $626,755 $642,424 $658,484 $674,947 Debt Service $156,000 $160,000 $157,000 $156,000 $155,000 $158,000 1 $101,500 1 $100,000 1 $100,000 1 $100,500 1 $104,000 $100,600 $103,000 $0 CIP Expenditures Total Expenses $336,000 $981,620 $671,000 $1,332,861 $370,200 $1,041,607 $471,750 $1,155,017 $301,203 $996,651 $379,864 $1,091,824 $433,239 $1,102,549 $720,837 $1,402,841 $288,662 $985,216 $346,722 $1,058,690 $305,023 $1,035,778 $313,574 $1,056,598 $367,381 $1,128,866 $311,453 $986,399 $631,113 Transfer to Equipment Fund for Sewer Equip $20,000 $0 $100,000 $31,500 $0 $450,000 $0 $35,000 $0 $0 $0 $0 1 $0 Revenues (1) $720,000 $741,600 $763,848 $786,763 $810,366 $834,677 $859,718 $885,509 $912,074 $939,437 $967,620 $996,648 $1,036,514 $1,067,610 Assessments $10,387 $10,387 $10,387 $10,387 $10,387 $10,387 $10,387 $10,387 $10,387 $0 $0 $0 $0 $0 Annual Balance ($251,233) ($580,874) ($267,372) ($357,867) ($175,898) ($246,759) ($232,444) ($506,945) ($62,755) ($119,253) ($68,158) ($59,949) ($92,351) $81,211 Year End Cash Balance $1,178,716 $597,843 $330,470 ($27,396) ($203,294) ($450,054) ($682,498) ($1,189,442) ($1,252,197) ($1,371,450) ($1,439,609) ($1,499,558) ($1,591,910) ($1,510,699) Sewer Fund Current Balance: $2,908,044 Table B-7 Project 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Operation and Maintenance (1) $970,278 $994,535 $1,019,399 $1,044,884 $1,071,006 $1,097,781 $1,125,226 $1,153,356 $1,182,190 $1,211,745 $1,242,038 $1,273,089 $1,304,917 $1,337,540 Debt Service $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $0 $0 $0 $0 $0 $0 $0 $0 CIP Expenditures $1,140,520 $643,204 1 $815,967 $646,578 $779,696 $524,206 $539,153 $554,547 $544,404 $560,736 $577,558 $594,885 1 $612,731 $631,113 Transfer to Equipment Fund for Sewer Equip $20,000 $0 $100,000 $31,500 $0 $450,000 $0 $35,000 $0 $0 $0 $0 1 $0 $80,000 Total Expenses $2,240,798 $1,747,739 $2,045,366 $1,832,962 $1,960,701 $2,181,987 $1,664,378 $1,742,903 $1,726,594 $1,772,481 $1,819,596 $1,867,974 $1,917,648 $2,048,653 Revenues (1) $1,308,898 $1,361,254 $1,415,704 $1,472,333 $1,531,226 $1,592,475 $1,656,174 $1,722,421 $1,791,318 $1,862,970 $1,862,970.33 $1,909,545 $1,957,283 $2,006,215 Assessments $35,349 $35,349 $35,349 $30,368 $26,934 $24,902 $17,569 $17,569 $10,939 $2,000 $0 $0 $0 $0 Annual Balance ($896,551) ($351,136) ($594,313) ($330,261) ($402,542) ($564,611) $9,365 ($2,914) $75,663 $92,490 $43,374 $41,571 $39,635 ($42,437) Year End Cash Balance $2,011,493 $1,660,357 $1,066,044 $735,783 $333,241 ($231,369) ($222,005) ($224,918) ($149,255) ($56,766) ($13,392) $28,179 $67,814 $25,377