City of Arden Hills, MinnesotaCapital Improvement PlanSOURCES AND USES OF FUNDS2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033Sanitary Sewer Utility FundBeginning Balance931,302 1,491,052 713,922 741,392 1,048,212 731,002 845,427 834,667 1,168,937 1,345,817 1,488,437 Revenues and Other Fund SourcesOperating Revenue2,476,430 2,550,330 2,601,180 2,653,040 2,653,140 2,653,240 2,653,340 2,653,450 2,653,560 2,653,670 2,653,780 Grants/Trade In399,381 5,000 - 5,000 - 2,500 - - - - - Total Revenues and Other Fund Sources2,875,811 2,555,330 2,601,180 2,658,040 2,653,140 2,655,740 2,653,340 2,653,450 2,653,560 2,653,670 2,653,780 Expenses and UsesEmergency GeneratorsEquipment - (160,000) - (150,000) - (75,000) - - - - - Lift Station RehabilitationSewer (293,001) (665,000) (210,000) - (260,000) - (200,000) - - - - Sewer Lining/RehabilitationSewer - (415,000) (400,000) - (640,000) - (275,000) - (205,000) - (275,000) MN-51 Water & Sewer CrossingsSewer- (17,500) - (50,000) - - - - - - - Old Snelling Ave PMP, CR E - Hwy 51Streets(9,750) - - - - - - - - - - Old Snelling Ave/CR E Intersection Improvements Streets(198,980) - - - - - - - - - - 2024 PMPStreets- (167,300) - - - - - - - - - 2026 PMPStreets- - - (135,000) - - - - - - - 2028 PMPStreets- - - - - (340,000) - - - - - 2030 PMPStreets- - - - - - - (110,000) - - - 2032 PMPStreets- - - - - - - - - (175,000) - Debt Service(38,250) (37,050) (40,750) (39,350) (37,950) (36,725) (40,600) - - - - Operating Expenses(1,650,080) (1,744,610) (1,796,960) (1,850,870) (1,906,400) (1,963,590) (2,022,500) (2,083,180) (2,145,680) (2,210,050) (2,276,360) Operating transfer to Equipment Fund(126,000) (126,000) (126,000) (126,000) (126,000) (126,000) (126,000) (126,000) (126,000) (126,000) (126,000) Total Expenses and Uses(2,316,061) (3,332,460) (2,573,710) (2,351,220) (2,970,350) (2,541,315) (2,664,100) (2,319,180) (2,476,680) (2,511,050) (2,677,360) Change in Fund Balance559,750 (777,130) 27,470 306,820 (317,210) 114,425 (10,760) 334,270 176,880 142,620 (23,580) Ending Balance 1,491,052 713,922 741,392 1,048,212 731,002 845,427 834,667 1,168,937 1,345,817 1,488,437 1,464,857 Minimum Cash Balance Goal 1,753,165 1,555,011 1,838,388 1,293,004 1,228,662 (3 months expenses and uses +100% of year 1 + 1/2 of year 2 +1/3 of year 3 + 1/4 of year 4 +1/5 of year 5 capital outlay)$0.0$0.2$0.4$0.6$0.8$1.0$1.2$1.4$1.62024 2025 2026 2027 2028 2029 2030 2031 2032 2033Millions71
|