City of Arden Hills, MinnesotaCapital Improvement PlanSOURCES AND USES OF FUNDS2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033Water Utility FundsBeginning Balance 2,623,227 3,388,137 2,483,547 1,923,407 2,103,927 2,198,467 2,344,127 2,587,812 2,413,672 2,600,742 1,896,652 Revenues and Other Fund SourcesOperating Revenue3,163,170 3,163,170 3,163,840 3,164,520 3,165,220 3,165,930 3,166,650 3,167,390 3,168,140 3,168,900 3,169,680 Grants/Trade In721,570 - - - 5,000 - - - - - - Total Revenues and Other Fund Sources3,884,740 3,163,170 3,163,840 3,164,520 3,170,220 3,165,930 3,166,650 3,167,390 3,168,140 3,168,900 3,169,680 Expenses and UsesEmergency GeneratorsEquipment - - - - (150,000) - - - - - - Old Snelling Ave PMP, CR E - Hwy 51Streets (34,860) - - - - - - - - - - Lexington Avenue, CR E to 694Streets (367,360) - - - - - - - - - - Old Snelling Ave/CR E Intersection Improvements Streets (250,600) - - - - - - - - - - 2024 PMPStreets - (219,600) - - - - - - - - - 2026 PMPStreets- - - (60,000) - - - - - - - 2028 PMPStreets- - - - - (150,000) - - - - - 2030 PMPStreets- - - - - - - (580,000) - - - 2032 PMPStreets- - - - - - - - - (960,000) - Water System Model UpdateWater- - (40,000) - - - - - - - - Water Tower MaintenanceWater(20,000) (350,000) - (10,000) (150,000) - - (10,000) (150,000) - (10,000) Booster Station ImprovementsWater- - (150,000) - - - - - - - - Trunk Water Main ImprovementsWater- (385,000) - (20,000) - (20,000) - - - - - MN-51 Water & Sewer CrossingsWater- (17,500) - (190,000) - - - - - - - Water MetersWater- (525,000) (900,000) - - - - - - - - Debt Service(248,050) (250,050) (246,750) (248,150) (249,150) (250,950) (248,675) - - - - Operating Expenses(2,098,960) (2,220,610) (2,287,230) (2,355,850) (2,426,530) (2,499,320) (2,574,290) (2,651,530) (2,731,070) (2,812,990) (2,897,370) Transfer to Equipment Fund(100,000) (100,000) (100,000) (100,000) (100,000) (100,000) (100,000) (100,000) (100,000) (100,000) (100,000) Total Expenses and Uses(3,119,830) (4,067,760) (3,723,980) (2,984,000) (3,075,680) (3,020,270) (2,922,965) (3,341,530) (2,981,070) (3,872,990) (3,007,370) Change in Fund Balance764,910 (904,590) (560,140) 180,520 94,540 145,660 243,685 (174,140) 187,070 (704,090) 162,310 Ending Balance 3,388,137 2,483,547 1,923,407 2,103,927 2,198,467 2,344,127 2,587,812 2,413,672 2,600,742 1,896,652 2,058,962 Minimum Cash Balance Goal 2,015,165 1,263,162 1,238,500 1,290,087 1,299,568 (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.5$1.0$1.5$2.0$2.5$3.02024 2025 2026 2027 2028 2029 2030 2031 2032 2033Millions73
|