|
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
<br />Debt Service (interest) - from MSA maintenance
<br />account.$24,663 $21,063 $17,000 $12,469 $7,688 $2,625 $0 $0 $0 $0
<br />Debt Service (Principal) - from MSA Construction
<br />Account $115,000 $120,000 $125,000 $125,000 $130,000 $140,000 $0 $0 $0 $0
<br />Total Expenses $250,968 $180,501 $181,438 $176,907 $177,126 $182,063 $39,438 $39,438 $39,438 $39,438
<br />Yearly Allocation - MSA Maintenance $123,833 $123,833 $123,833 $123,833 $123,833 $123,833 $123,833 $123,833 $123,833 $123,833
<br />Yearly Allocation - MSA Construction $201,751 $201,751 $201,751 $201,751 $201,751 $201,751 $201,751 $201,751 $201,751 $201,751
<br />Annual Balance $74,617 $145,084 $144,146 $148,677 $148,459 $143,521 $286,146 $286,146 $286,146 $286,146
<br />Year End Cash Balance $74,617 $219,700 $363,846 $512,523 $660,982 $804,503 $1,090,649 $1,376,795 $1,662,941 $1,949,087
<br />Pavement Management Fund Current Balance:$0 43525000 Table B-5b
<br />Project 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030
<br />Annual Operation and Maintenance (1)$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
<br />CIP Expenditures $1,123,570 $1,114,800 $1,336,400 $1,520,200 $1,200,000 $1,167,800 $1,296,460 $1,320,389 $1,344,797 $1,369,693
<br />Total Expenses $1,123,570 $1,114,800 $1,336,400 $1,520,200 $1,200,000 $1,167,800 $1,296,460 $1,320,389 $1,344,797 $1,369,693
<br />Revenues (1)$375,000 $325,000 $275,000 $275,000 $250,000 $200,000 $155,000 $160,000 $165,000 $170,000
<br />Pavement Management Levy $750,000 $850,000 $1,000,000 $1,100,000 $1,100,000 $1,100,000 $1,150,000 $1,160,000 $1,170,000 $1,180,000
<br />Annual Balance $1,430 $60,200 ($61,400)($145,200)$150,000 $132,200 $8,540 ($389)($9,797)($19,693)
<br />Year End Cash Balance $1,430 $61,630 $230 ($144,970)$5,030 $137,230 $145,770 $145,381 $135,584 $115,891
<br />Water Fund 12/31/2021 Current Balance:$910,435 60111111 Table B-6
<br />Project 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030
<br />Annual Operation and Maintenance (3)$1,060,500 $1,085,240 $1,039,051 $1,072,440 $1,098,966 $1,122,995 $1,151,070 $1,179,847 $1,209,343 $1,239,576
<br />Debt Service $157,180 $156,830 $100,430 $98,570 $101,550 $99,350 $101,920 $99,310 $101,500 $0
<br />CIP Expenditures $420,500 $798,440 $142,889 $399,297 $397,833 $366,028 $489,242 $319,973 $420,722 $270,722
<br />Transfer to Equipment Fund $0 $10,000 $50,000 $0 $0 $0 $0 $0 $0 $0
<br />Total Expenses $1,638,180 $2,050,510 $1,332,370 $1,570,307 $1,598,349 $1,588,373 $1,742,231 $1,599,129 $1,731,565 $1,510,298
<br />Revenues (4)$1,192,528 $1,830,344 $1,248,994 $1,278,504 $1,308,899 $1,340,206 $1,367,010 $1,394,350 $1,422,237 $1,450,682
<br />Add back Depreciation $231,400 $245,889 $269,805 $287,271 $297,544 $304,983 $312,607 $320,422 $328,433 $336,644
<br />Assessments $10,387 $10,387 $10,387 $10,387 $10,387 $10,387 $0 $0 $0 $0
<br />Annual Balance ($203,865)$36,110 $196,816 $5,855 $18,481 $67,202 ($62,614)$115,643 $19,105 $277,027
<br />Year End Cash Balance $706,570 $742,680 $939,496 $945,351 $963,832 $1,031,034 $968,420 $1,084,063 $1,103,168 $1,380,196
<br />Sewer Fund Current Balance:$2,500,027 60211111 Table B-7
<br />Project 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030
|