|
City of Roseville
<br />Capital Improvement Plan: Storm Sewer Capital Fund (640)
<br />2025-2044
<br />Tax Levy: current
<br />Tax Levy: Add/Sub
<br />Fees, Licenses, & Permits
<br />Sale of Assets
<br />Interest Earnings
<br />Vehicles
<br />Equipment
<br />Furniture & Fixtures
<br />Buildings
<br />Improvements
<br />Updated 811212024
<br />2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2O40 2041 2042 2O43 2044
<br />1,115,000 1,115,000 1,115,000 1,115,000 1,115,000 1,115,000 1,115,000 1,115,000 1,115,000 1,115,000 1,115,000 1,115,000 1,115,000 1,115,000 1,115,000 1,115,000 1,115,000 1,115,000 1,115,000 1,115,000 $ 22,300,000
<br />34,578 35,089 27,991 24,141 21,304 20,730 21,164 12,647 - $ 197,643
<br />Revenues $ 1,149,578 $ 1,150,089 $ 1,142,991 $ 1,139,141 $ 1,136,304 $ 1,135,730 $ 1,136,164 $ 1,127,647 $ 1,115,000 $ 1,115,000 $ 1,115,000 $ 1,115,000 $ 1,115,000 $ 1,115,000 $ 1,115,000 $ 1,115,000 $ 1,115,000 $ 1,115,000 $ 1,115,000 $ 1,115,000
<br />$ - $ - $ - $ 135,000 $ - $ - $ 358,000 $ 250,000 $ - $ 400,000 $ 250,000 $ 616,000 $ - $ 315,000 $ - $ 134,000 $ - $ - $ - $ -
<br />45,000 386,000 186,500 27,000 76,000 25,000 80,000 - 20,000 96,000 75,000 - 7,500 390,000 64,000 20,000 135,000 11,000 32,000 -
<br />1,079,000 1,119,000 1,149,000 1,119,000 1,089,000 1,089,000 1,124,000 1,599,000 1,589,000 1,589,000 1,589,000 2,009,000 1,849,000 1,789,000 1,839,000 2,289,000 2,099,000 2,099,000 2,089,000
<br />Expenditures $ 1,124,000 $ 1,505,000 $ 1,335,500 $ 1,281,000 $ 1,165,000 $ 1,114,000 $ 1,562,000 $ 1,849,000 $ 1,609,000 $ 2,085,000 $ 1,914,000 $ 2,625,000 $ 1,856,500 $ 2,494,000 $ 1,903,000 $ 2,443,000 $ 2,234,000 $ 2,110,000 $ 2,121,000 $ -
<br />Beginning Cash Balance $ 1,728,878 $ 1,754,456 $ 1,399,545 $ 1,207,036 $ 1,065,176 $ 1,036,480 $ 1,058,209 $ 632,374 $ (88,979) $ (582,979) $ (1,552,979) $ (2,351,979) $ (3,861,979) $ (4,603,479) $ (5,982,479) $ (6,770,479) $ (8,098,479) $ (9,217,479) $ (10,212,479) $ (11,218,479)
<br />Annual Surplus (deficit) 25,578 (354,911) (192,509) (141,859) (28,696) 21,730 (425,836) (721,353) (494,000) (970,000) (799,000) (1,510,000) (741,500) (1,379,000) (788,000) (1,328,000) (1,119,000) (995,000) (1,006,000) 1,115,000
<br />Cash Balance $ 1,754,456 $ 1,399,545 $ 1,207,036 $ 1,065,176 $ 1,036,480 $ 1,058,209 $ 632,374 $ (88,979) $ (582,979) $ (1,552,979) $ (2,351,979) $ (3,861,979) $ (4,603,479) $ (5,982,479) $ (6,770,479) $ (8,098,479) $ (9,217,479) $ (10,212,479) $ (11,218,479) $ (10,103,479)
<br />Cash Balance (Year -End) * $
<br />2,451,766
<br />2023
<br />Less Arm Needed for Operations **
<br />(253,428)
<br />2024
<br />Planned CIP Surplus/Deficit
<br />(469,460)
<br />2024
<br />Adjust for Delayed CIP Items
<br />2023
<br />Cash Balance (Beg. Year) $
<br />1,728,878
<br />2025
<br />Adopted Budget(Excl.Capital, Dept. $
<br />1,689,520
<br />2024
<br />* Curent Assets - Curent Liabilities
<br />** 15% of Annual Budget Needed for Cash -Flow Purposes
<br />Expenditure Detail
<br />Key Description 2025 2026
<br />E #110 2021 Toro Goundmaster Polor' - -
<br />E #116 2015 Kubota M110GXDTC Tr - -
<br />E #116F 2015 Tiger 9119404J Flail Mc - -
<br />E #116P 2015 Bay Lynx Machinability - -
<br />E #1262019 Bobcat S650 -
<br />E #130 2019 Amazing Machine AM96 - -
<br />E #137 2017 Trafifix Scorpion 10002 F - -
<br />E #140 2018 Toro GrandStand 74519 D - 11,000
<br />E #163 2020 Ver-Mac PCMS -320 Sigi - -
<br />E #164 Bobcat 3400 25,000 -
<br />E #165 2019 Towmaster T-14DT Trailer -
<br />E #1681997 Wild Cat LS177A Compc - 375,000
<br />E #171 2020 TennantM-S30 Sweeper - -
<br />E #176 2018 PJ Trailer Ul 182 Mow T -
<br />E #211 A14 2015 Caterpillar CVP75 V - -
<br />E #211A Sand Bucket 24"315D - -
<br />E #225 Al2 2014 Caterpillar H65ES Hydraulic Breaker (1/3)
<br />E #225 A13 2014 Rotobec PC018B Grapple 360 Mini Excavator (1/3)
<br />E #225 2015 Caterpillar 305E Excavate - -
<br />E #xx 6" Pump Trailer 20,000
<br />E #xx GPS Unit (1/3) - -
<br />E #xx Skid Steer (Track) - -
<br />I Asset Management System (1/3) - 40,000
<br />I Lift Station - Arena Upgrades -
<br />Storm Sewer Capital Fund
<br />$4 1.2
<br />c
<br />$2 1
<br />$-
<br />$(2) 45 2028 2031 4 2037 2040 2043 0.8
<br />$FB 0.6
<br />$(6) 0.4
<br />$(8)
<br />$(10) 0.2
<br />$(12) 0
<br />Revenues Expenditures -Cash Balance
<br />2027 2028
<br />60,000
<br />32,000
<br />87,000
<br />7,500
<br />10,000
<br />7,000
<br />10,000
<br />2029 2030
<br />25,000
<br />20,000
<br />5,000
<br />7,000
<br />40,000
<br />4,000
<br />2031 2032
<br />40,000
<br />15,000
<br />25,000
<br />25,000
<br />2033 2034 2035 2036
<br />85,000
<br />- 11,000
<br />20,000 - -
<br />- 25,000
<br />50,000
<br />40,000
<br />** 2020 Utility fee amount requires a 0. 0%rate increase
<br />2037 2038 2039
<br />60,000
<br />7,500
<br />355,000
<br />10,000
<br />- 4,000
<br />25,000 -
<br />2040 2041 2042 2043 2044
<br />50,000
<br />- 85,000
<br />20,000
<br />11,000
<br />15,000
<br />7,000
<br />10,000
<br />90,000
<br />120,000
<br />25,000
<br />32,000
<br />257,000
<br />40,000
<br />15,000
<br />33,000
<br />20,000
<br />50,000
<br />30,000
<br />730,000
<br />50,000
<br />20,000
<br />14,000
<br />20,000
<br />5,000
<br />7,000
<br />40,000
<br />20,000
<br />8,000
<br />50,000
<br />80,000
<br />25,000
<br />26
<br />Page 28 of 55
<br />
|