|
MSA Fund Current Fund Balance:$0 State MSA Construction Balance =$550,000 Table B-5a
<br />Project 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029
<br />Annual Expenditures (MSA CIP)$71,867 $71,867 $71,867 $335,000 $0 $400,000 $408,000 $416,160 $424,483 $432,973
<br />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.$28,113 $24,663 $21,063 $17,000 $12,469 $7,688 $2,625 $0 $0 $0
<br />Debt Service (Principal) - from MSA Construction
<br />Account $115,000 $115,000 $120,000 $125,000 $125,000 $130,000 $140,000 $0 $0 $0
<br />Total Expenses $254,417 $250,967 $252,367 $516,438 $176,906 $577,125 $590,063 $455,598 $463,921 $472,410
<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 $71,167 $74,617 $73,217 ($190,854)$148,678 ($251,541)($264,479)($130,014)($138,337)($146,826)
<br />Year End Cash Balance $71,167 $145,784 $219,001 $28,148 $176,825 ($74,716)($339,194)($469,208)($607,544)($754,371)
<br />Pavement Management Fund Current Balance:-$150,000 43525000 Table B-5b
<br />Project 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029
<br />Annual Operation and Maintenance (1)$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
<br />CIP Expenditures $1,164,716 $1,892,256 $889,500 $1,206,700 $838,400 $1,150,000 $1,173,000 $1,196,460 $1,220,389 $1,244,797
<br />Total Expenses $1,164,716 $1,892,256 $889,500 $1,206,700 $838,400 $1,150,000 $1,173,000 $1,196,460 $1,220,389 $1,244,797
<br />Revenues (1)$0 $0 $0 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000
<br />Pavement Management Levy $617,450 $750,000 $850,000 $900,000 $900,000 $900,000 $900,000 $900,000 $900,000 $900,000
<br />Annual Balance ($547,266)($1,142,256)($39,500)($6,700)$361,600 $50,000 $27,000 $3,540 ($20,389)($44,797)
<br />Year End Cash Balance ($697,266)($1,839,522)($1,879,022)($1,885,722)($1,524,122)($1,474,122)($1,447,122)($1,443,582)($1,463,971)($1,508,768)
<br />Water Fund 12/30/2020 Current Balance:$219,475 60111111 Table B-6
<br />Project 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029
<br />Annual Operation and Maintenance (3)$933,250 $934,142.98 $983,678 $1,079,429 $1,113,431 $1,139,815 $1,168,311 $1,197,518 $1,227,456 $1,258,143
<br />Debt Service $155,430 $157,180 $156,830 $100,430 $98,570 $101,550 $100,500 $104,000 $100,600 $103,000
<br />CIP Expenditures $233,855 $390,760 $379,131 $420,094 $375,308 $422,833 $488,528 $484,544 $348,973 $306,742
<br />Total Expenses $1,322,535 $1,482,083 $1,519,639 $1,599,953 $1,587,309 $1,664,198 $1,757,339 $1,786,062 $1,677,029 $1,667,885
<br />Revenues (4)$1,134,237 $1,276,818 $1,317,278 $1,338,317 $1,359,776 $1,381,665 $1,423,115 $1,465,809 $1,509,783 $1,555,076
<br />Add back Depreciation $225,800 $231,385 $245,889 $269,805 $287,271 $297,544 $304,983 $312,607 $320,422 $328,433
<br />Assessments $10,387 $10,387 $10,387 $10,387 $10,387 $10,387 $10,387 $0 $0 $0
<br />Annual Balance $47,889 $36,507 $53,915 $18,556 $70,125 $25,398 ($18,854)($7,646)$153,176 $215,624
<br />Year End Cash Balance $267,364 $303,872 $357,787 $376,343 $446,468 $471,866 $453,011 $445,365 $598,541 $814,165
<br />Council Work Session
<br />8/24/20
<br />Page # 24
|