|
Sewer Fund Current Balance:$2,192,747 60211111 Table B-7
<br />Project 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029
<br />Operation and Maintenance (3)$1,791,200 $1,844,027 $1,889,775 $1,936,836 $1,983,283 $2,025,100 $2,075,728 $2,127,621 $2,180,811 $2,235,331
<br />Debt Service $110,000 $110,000 $110,000 $0 $0 $0 $0 $0 $0 $0
<br />CIP Expenditures $815,000 $764,000 $658,250 $545,550 $449,480 $1,086,000 $656,700 $663,534 $670,505 $677,615
<br />Transfer to Equipment Fund for Sewer Equip $115,000 $31,500 $0 $450,000 $0 $35,000 $0 $0 $0 $0
<br />Total Expenses $2,831,200 $2,749,527 $2,658,025 $2,932,386 $2,432,763 $3,146,100 $2,732,428 $2,791,155 $2,851,316 $2,912,946
<br />Revenues (4)$1,889,629 $2,173,073 $2,216,535 $2,260,865 $2,306,083 $2,352,204 $2,399,249 $2,447,233 $2,496,178 $2,546,102
<br />Add back Depreciation $353,600 $377,100 $397,107 $410,136 $420,592 $430,805 $441,575 $452,615 $463,930 $475,528
<br />Assessments $35,349 $30,368 $26,934 $24,902 $17,569 $17,569 $10,939 $2,000 $0 $0
<br />Annual Balance ($552,622)($168,986)($17,450)($236,483)$311,481 ($345,522)$119,335 $110,693 $108,792 $108,684
<br />Year End Cash Balance $1,640,125 $1,471,139 $1,453,690 $1,217,207 $1,528,688 $1,183,166 $1,302,501 $1,413,195 $1,521,987 $1,630,670
<br />Storm Water Fund Current Balance:$1,151,700 65111111 Table B-8
<br />Project 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029
<br />Operation and Maintenance (3)$373,000 $384,385.00 $398,410.00 $412,662.00 $423,773 $435,096 $445,973 $457,123 $468,551 $480,265
<br />CIP Expenditures $404,140 $480,570 $417,515 $272,610 $279,605 $325,000 $327,800 $303,641 $333,569 $336,541
<br />Transfer to Equipment Fund for Storm Equip $100,000 $0 $75,000 $0 $0 $12,000 $600,000 $0 $0 $0
<br />Total Expenses $877,140 $864,955 $890,925 $685,272 $703,378 $772,096 $1,373,773 $760,763 $802,120 $816,805
<br />Revenues (4)$676,799 $683,567 $690,402 $697,306 $704,279 $711,322 $729,105 $747,333 $766,016 $785,166
<br />Add back depreciation $62,000 $71,454 $78,135 $86,407 $92,670 $101,004 $103,529 $106,117 $108,770 $111,490
<br />Annual Balance ($138,341)($109,934)($122,388)$98,441 $93,571 $40,230 ($541,139)$92,687 $72,666 $79,851
<br />Year End Cash Balance $1,013,359 $903,425 $781,037 $879,478 $973,049 $1,013,279 $472,140 $564,827 $637,493 $717,344
<br />40625000
<br />Permanent Improvement Revolving (PIR) Fund Current Balance:$1,000,000 Amount Available for Police Purchases =$280,000 Table B-9
<br />Project 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029
<br />Police Expenses $5,464 $40,628 $20,796 $55,970 $6,149 $21,334 $6,524 $6,720 $21,921 $57,129
<br />Total Expenses $5,464 $40,628 $20,796 $55,970 $6,149 $21,334 $6,524 $6,720 $21,921 $57,129
<br />Revenues $12,296 $10,068 $9,763 $9,652 $9,189 $9,220 $9,098 $9,124 $9,148 $9,021
<br />Annual Balance $6,832 ($30,559)($11,034)($46,318)$3,040 ($12,114)$2,575 $2,405 ($12,773)($48,108)
<br />Year End Cash Balance $1,006,832 $976,273 $965,239 $918,921 $921,961 $909,847 $912,422 $914,826 $902,053 $853,945
<br />NOTES:
<br />(1) Expenses and Revenues are based on the City's 2020 budget. For Planning purposes a 2.5% annual inflation factor has been used to project future costs.
<br />(2) Revenues are based on a 1.5% increased contribution starting in 2019 and adding a 1% interest earned on the previous year's balance.
<br />Council Work Session
<br />8/24/20
<br />Page # 25
|