|
Storm Water Utility Fund #605
<br />Working Capital
<br />Beginning Balance
<br />Actual Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected
<br />2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034
<br />2,864,406 3,035,191 2,426,536 1,535,262 947,476 398,935 775,560 1,035,314 1,294,941 1,219,743 1,242,551 950,322
<br />Utility Revenue
<br />From Utility Billings
<br />Interest Earnings
<br />Total revenues
<br />Operating Expense
<br />(Personal Services, Supplies, Other
<br />Services & Charges)
<br />1,252,659 1,333,400 1,533,410 1,686,751 1,855,426 2,040,969 2,143,017 2,250,168 2,362,676 2,480,810 2,604,851 2,735,093
<br />148,835 30,352 24,265 15,353 9,475 3,989 7,756 10,353 12,949 12,197 12,426 9,503
<br />1,401,494
<br />1,363,752
<br />1,557,675 1,702,104
<br />1,864,901 2,044,958
<br />(482,623) (516,407) (663,869) (765,256) (841,781) (1,000,960)
<br />CIP Projects-Stormwater Utility
<br />Street Sweeper
<br />Water Truck (1/4 of Cost)
<br />Vactor Trailer (211,534)
<br />Jetter/Vac Truck ($850K total)
<br />Ford f550 (1/3 cost) $128,255 (58,650)
<br />Water Truck (Share of)
<br />Annual Drainage Enhancement
<br />Outlet Control Structure Improvement (81,925)
<br />Central Park Parking Lot Recon-Run Off (136,755)
<br />River Storm Water Discharge Treatment
<br />Storm Sewer 142nd Avenue
<br />Storm Sewer 161st Avenue (230,116) (10,000)
<br />Storm Sewer Anderson Estates
<br />Storm Sewer Alpine Drive
<br />Storm Sewer Barthels Rum River Acres (151,313)
<br />Storm Sewer Barthels Rum River Acres 2nd (231,896) (10,000)
<br />Storm Sewer Bunker Lake Blvd( Jackal St/Armstrong)
<br />Storm Sewer Carol Rose Est
<br />Storm Sewer Brookview Est
<br />Storm Sewer Countryside Est (From cc case)
<br />Storm sewer for concrete repairs
<br />Storm Sewer Deerwood St
<br />Storm Sewer Dickensons Mississippi Est
<br />Storm Sewer Echo Ridge
<br />Storm SewerXkimo St (106,600)
<br />Storm Sewer Fox Ridge Et 1st & 2nd
<br />Storm Sewer Ford Brook Est 3rd (108,360)
<br />Storm Sewer Halls Dover (88,200)
<br />Storm Sewer Alicia St
<br />Storm Sewer Alpine Drive
<br />Storm Sewer Alpine (puma-CSAH 83) (110,160)
<br />Storm Sewer Alpine Dr (5/47)
<br />Storm Sewer Alpine (CR 57/CSAJ 5)
<br />Storm Sewer Hall -Anderson Acres
<br />Storm Sewer Sorteberg 6
<br />Storm SewerJaspar St
<br />Storm Sewer Klemish & Klemish
<br />Storm Sewer Winnemere woods
<br />Storm Sewer High Point
<br />Storm Sewer Menkvels Country Park
<br />Storm Sewer Nature View
<br />Storm Sewer North Forty
<br />Storm Sewer Northfork Lake
<br />Storm Sewer Northfork Oaks 2nd
<br />Storm Sewer Northfork Oaks 3rd
<br />Storm Sewer Oakwood Hills
<br />Storm Sewer Riverside West
<br />Storm Sewer River Bluffs
<br />Storm Sewer Section 01 unplatted
<br />Storm Sewer Section 22 Unplatted
<br />Storm Sewer Section 06 Unplatted
<br />Storm Sewer Section 07 Unplatted
<br />Storm Sewer Section 17 Unplatted
<br />Storm Sewer Section 24 Unplatted
<br />Storm Sewer Section 15 Unplatted
<br />Storm Sewer Sunwood D/Waco Street Recon
<br />Storm Sewer Ramsey Meadows 1, 3 & 4
<br />Storm Sewer Sunfish Square 1 & 2
<br />Storm Sewer Sunwood (5/Erkium)
<br />Storm Sewer Section 21 unplatted
<br />Storm Sewer 167th Ave (78,550)
<br />Storm Sewer-Flintwood Hills
<br />Storm Sewer -Juniper between 156 & Roanoke
<br />Storm Sewer -Juniper Woods 1-3rd (61,875)
<br />Storm Sewer 142nd Avenue
<br />Storm Sewer 2027 MSA Overlay Projects
<br />Storm Sewer 2023 MSA Overlay Projects (11,657)
<br />Storm Sewer 2023 Overlay Projects (8,356)
<br />Storm Sewer 2024 MSA overlay projects (18,345)
<br />Storm Sewer 2024 overlay projects (114,195)
<br />Storm Sewer 2025 overlay projects
<br />Storm Sewer 2026 overlay projects
<br />Storm Sewer 2027 overlay projects
<br />Storm Sewer 2028 overlay projects
<br />Storm Sewer 2029 MSA overlay projects
<br />Storm Sewer 2029 Overlay Projects
<br />Storm Sewer 2030 MSA Overlay Projects
<br />Storm Sewer 2030 Overlay Projects
<br />Storm Sewer 2031 MSA Overlay Projects
<br />Storm Sewer 2031 Overlay Projects
<br />Storm Sewer 2034 MSA Overlay Projects
<br />Storm Sewer 2034 Overlay Projects
<br />Storm Sewer Rivenwick 1st & 2nd
<br />Storm Sewer Riverwood Hills
<br />Storm Sewer Rodeo Hills/Valley View (174,168)
<br />Storm Sewer Section 01 unplateed Recon (50,400)
<br />Storm Sewer Sortegerg's street recon
<br />Storm Sewer Whispering Pine Est Plat 5
<br />Storm Sewer Whispering Pine Est Plat 3 (47,381) (45,000)
<br />Storm Sewer Windsorwood
<br />Storm Sewer Woodlawn Est
<br />2026 MSA Overlays
<br />Storm Sewer-MSA Alpind Drive T 10 & PUMA
<br />Storm Sewer -Gateway Industrial Park
<br />Storm Sewer-MSA Uranimite
<br />Storm Sewer-MSA Waco Street
<br />Storm Sewer-Brookview Est
<br />Storm Sewer -hunters Ridge
<br />Storm Sewer -Regency Pond 1-3
<br />Storm Sewer Sports Have Secc 1 Unpl
<br />Stormwater Drainage Impr 156 & Juniper Ridge
<br />Stormwater Drainage Impr 156th & Armstrong
<br />Total Expenditures
<br />(330,000) (330,000)
<br />(84,000)
<br />(200,000)
<br />2,150,773 2,260,521
<br />(1,176,056) (1,368,661)
<br />2,375,626 2,493,008
<br />(1,580,527) (1,813,580)
<br />2,617,276 2,744,596
<br />(2,069,938) (2,351,932)
<br />(125,000)
<br />(75,000) (75,000) (75,000) (75,000) (75,000) (75,000) (75,000) (75,000) (75,000) (75,000)
<br />(75,000) (75,000) (75,000) (75,000) (75,000) (75,000) (75,000) (75,000) (75,000) (75,000)
<br />(108,486)
<br />(306,722)
<br />(394,506)
<br />(79,538)
<br />(66,755)
<br />(214,524)
<br />(44,541)
<br />(45,450)
<br />(69,190)
<br />(83,855)
<br />(49,215)
<br />(67,014)
<br />(291,006)
<br />(29,950)
<br />(132,192)
<br />(152,388)
<br />(32,451)
<br />(168,272)
<br />(43,146)
<br />(104,751)
<br />(163,152)
<br />(114,948)
<br />(98,803)
<br />(46,350)
<br />(58,594)
<br />(10,139)
<br />(37,389)
<br />(49,133)
<br />(58,401)
<br />(350,000)
<br />(43,290)
<br />(287,352)
<br />(20,592)
<br />(166,140)
<br />(143,182)
<br />(80,719)
<br />(89,775)
<br />(13,076)
<br />(121,078)
<br />(86,231)
<br />(11,970)
<br />(18,932)
<br />(152,948)
<br />(43,470)
<br />(62,606)
<br />(34,965)
<br />(3,308)
<br />(42,872)
<br />(142,065)
<br />(85,050)
<br />(73,828)
<br />(143,640)
<br />(105,840)
<br />(148,365)
<br />(43,824)
<br />(29,799)
<br />(175,000)
<br />(80,590)
<br />(22,680)
<br />(62,016)
<br />(58,590)
<br />(51,030)
<br />(94,500)
<br />(28,728)
<br />(49,140)
<br />(55,944)
<br />(77,490)
<br />(315,630)
<br />(191,363)
<br />(231,525)
<br />(49,022)
<br />(5,985)
<br />(125,213)
<br />(117,180)
<br />(16,632)
<br />(1,230,709) (1,972,407)
<br />(2,448,949) (2,289,890)
<br />(2,413,441) (1,668,334)
<br />(1,891,018) (2,000,895)
<br />(2,450,824) (2,470,200)
<br />(2,909,505) (3,132,538)
<br />Remaining Working Capital Balance
<br />3,035,191 2,426,536
<br />1,535,262 947,476
<br />398,935 775,560
<br />1,035,314 1,294,941
<br />1,219,743 1,242,551
<br />950,322 562,380
<br />5% rate inc 15% rate inc 10% rate inc 10% rate inc 10% rate inc 5% rate inc 5% rate inc 5% rate inc 5% rate inc 5% rate inc 5% rate inc
<br />309
<br />
|