11-26-2018 Council Work Session Packet

Home Browse Search

Capital Improvement Plan, City of Orono MSA Fund Current Fund Balance: $0 State MSA Construction Balance= $550,000 Table B -5b Table B -5a Project 2019 2020 Project 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 Annual Expenditures (MSA CIP) $75,000 $0 $0 $0 $0 $225,567 $209,969 $327,763 $312,156 $312,156 $0 $0 $0 $0 $0 Annual MSA Maintenance Payment to the City $39,438 $39,438 $39,438 $39,438 $39,438 $39,438 $39,438 $39,438 $39,438 $39,438 $39,438 $39,438 $39,438 $39,438 $39,438 Debt Service (interest) - from MSA maintenance account. $36,288 $33,138 $29,838 $26,388 $22,938 $19,188 $14,813 $10,125 $5,250 $520,581 $306,742 $313,031 $384,449 $325,999 $482,685 Debt Service (Principal) - from MSA Construction Account $105,000 $110,000 $115,000 $115,000 $120,000 $125,000 $125,000 $130,000 $140,000 $0 $0 $0 $300,000 $300,000 $300,000 Total Expenses $255,725 $182,575 $184,275 $180,825 $182,375 $409,192 $389,219 $507,326 $496,844 1 $351,594 1 $39,438 1 $39,438 1 $39,438 1 $39,438 1 $39,438 $544,450 $544,450 $544,450 $544,450 $544,450 $544,450 $544,450 Annual Ba lance ($511,845) ($193,034) ($62,702) ($187,048) $460,507 ($75,319) $94,450 $80,450 $66,170 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 1123,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 $201,751 Annual Balance $69,859 $143,009 $141,309 $144,759 $143,209 ($83,608) ($63,635) ($181,742) ($171,260) ($26,010) $286,147 $286,147 $286,147 $286,147 $286,147 Year End Cash Balance $69,859 $212,868 1 $354,177 $498,936 $642,145 1 $558,537 $494,902 $313,161 $141,901 $115,892 $402,038 $688,185 $974,331 $1,260,478 $1,546,624 Pavement Management Fund Current Balance: $462,233 $774,118 Table B -5b Table B-6 Project 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 Annual Operation and Maintenance 11) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0. $0 $0 CIP Expenditures $1,056,295 $737,484 $607,152 1 $731,498 1 $383,943 1 $919,769 $750,000 $764,000 $778,280 $792,846 $807,703 $822,857 $838,314 $854,080 $870,162 Total Expenses $1,056,295 $737,484 $607,152 1 $731,498 1 $383,943 $919,769 $750,000 $764,000 $778,280 $792,846 $807,703 $822,857 $838,314 $854,080 $870,162 $520,581 $306,742 $313,031 $384,449 $325,999 $482,685 Total Expenses $1,457,565 $1,826,083 $1,868,040 $1,413,736 $1,472,765 $1,337,760 $1,385,916 $2,006,289 Revenues(1) $0 $0 $0 $0 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 Pavement Management Levy $544,450 $544,450 $544,450 $544,450 $544,450 $544,450 $544,450 $544,450 $544,450 $544,450 $544,450 $544,450 $544,450 $544,450 $544,450 Annual Ba lance ($511,845) ($193,034) ($62,702) ($187,048) $460,507 ($75,319) $94,450 $80,450 $66,170 $51,604 $36,747 $21,593 $6,136 ($9,630) ($25,712) Year End Cash Balance ($49,612) ($242,646) ($305,348) ($492,396) ($31,889) ($107,208) ($12,758) $67,692 $133,862 $185,466 $222,213 $243,807 $249,943 $240,313 $214,602 Water Fund Current Balance: $774,118 Table B-6 Project 2019 2020 2021 2022 1 2023 1 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 Annual Operation and Maintenance (1) $847,710 $868,903 $890,625 $912,891 $935,713 $959,106 $983,084 $1,007,661 $1,032,852 $1,058,674 $1,085,140 $1,112,269 $1,140,076 $1,168,578 $1,197,792 Debt Service $135,000 $157,000 $156,000 $155,000 $158,000 1 $101,500 $100,000 $100,000 $100,500 $104,000 $100,600 $103,000 $0 $0 $0 CIP Expenditures $474,855 $800,180 $821,415 $345,845 1 $379,052 1 $277,154 $302,833 $898,628 $444,544 $520,581 $306,742 $313,031 $384,449 $325,999 $482,685 Total Expenses $1,457,565 $1,826,083 $1,868,040 $1,413,736 $1,472,765 $1,337,760 $1,385,916 $2,006,289 $1,577,896 $1,683,254 $1,492,483 $1,528,300 $1,524,524 $1,494,577 $1,680,477 Total Expenses $2,538,243 $2,971,499 $2,723,068 $2,712,983 $3,145,429 $2,634,724 $2,623,755 $2,615,283 $2,683,406 $2,753,314 $2,825,054 $2,898,674 $3,054,226 $6,103,516 $6,262,648 Revenues(1) $681,550 $701,997 $723,056 $744,748 $767,091 $790,103 $813,806 $838,221 $863,367 $889,268 $915,946 $952,584 $981,162 $1,010,596 $1,040,914 Add back Depreciation $207,400 $225,800 $241,400 $262,700 $272,300 $294,000 $294,000 $294,000 $294,000 $294,000 $294,000 $294,000 $294,000 $294,000 $294,000 Assessments $10,387 $10,387 $10,387 $10,387 $10,387 $10,387 $10,387 $10,387 $0 $0 $0 $0 $0 $0 $0 Annual Balance ($558,228) ($887,899) ($893,197) ($395,901) ($422,987) ($243,270) ($267,723) ($863,682) ($420,529) ($499,986) ($282,536) ($281,716) ($249,363) ($189,980) ($345,562) Year End Cash Balance $215,890 ($672,009) ($1,565,206) ($1,961,1071 ($2,384,095) ($2,627,364) ($2,895,087) ($3,758,769) ($4,179,298) ($4,679,284) ($4,961,821) ($5,243,536) ($5,492,899) ($5,682,879) ($6,028,442) Sewer Fund Current Balance: $2,585,816 Table B-7 Project 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 Operation and Maintenance (1) $1,624,175 $1,664,779 $1,706,399 $1,749,059 $1,792,785 $1,837,605 $1,883,545 $1,930,634 $1,978,900 $2,028,372 $2,079,081 $2,131,058 $2,184,335 $2,238,943 $2,294,917 Debt Service $110,000 $110,000 $110,000 $110,000 $110,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 CIP Expenditures $804,068 $1,096,720 $875,169 $853,924 $792,644 $797,119 $705,210 $684,650 $704,506 $724,942 $745,972 $767,616 $789,891 $812,815 $836,407 Transfer to Equipment Fund for Sewer Equip $0 $100,000 $31,500 $0 $450,000 $0 $35,000 $0 $0 $0 $0 $0 $80,000 $3,051,758 $3,131,324 Total Expenses $2,538,243 $2,971,499 $2,723,068 $2,712,983 $3,145,429 $2,634,724 $2,623,755 $2,615,283 $2,683,406 $2,753,314 $2,825,054 $2,898,674 $3,054,226 $6,103,516 $6,262,648 Revenues (1) $1,427,010 $1,484,090 $1,543,454 $1,605,192 $1,669,400 $1,736,176 $1,805,623 $1,877,848 $1,952,962 $2,031,080 $2,112,323 $2,196,816 $2,284,689 $2,376,077 $2,471,120 Add back Depreciation $330,000 $353,600 $382,200 $402,000 $416,200 $439,300 $439,300 $439,300 $439,300 $439,300 $439,300 $439,300 $439,300 $439,300 $439,300 Assessments $35,349 $35,349 $30,368 $26,934 $24,902 $17,569 $17,569 $10,939 $2,000 $0 $0 $0 $0 i ($675,682) ($660,205) Annual Balance ($745,684) ($1,098,460) ($767,046) ($678,856) ($1,034,927) ($441,679) ($361,263) ($287,197) ($289,144) ($282,933) ($273,430) ($262,558) ($330,237) ($3,963,8211 ($4,012,433) Year End Cash Balance $1,839,932 $741,473 ($25,573) 1 ($704,429) ($1,739,357) ($2,181,036) ($2,542,299) ($2,829,495) ($3,118,640) ($3,401,573) ($3,675,003) ($3,937,561) ($4,267,798) 1 ($8,231,619) ($12,244,052)