City of Roseville
<br />Capital Improvement Plan: Street Light Maintenance Fund (406)
<br />2025-2044
<br />2025
<br />2026
<br />2027
<br />2028
<br />2029
<br />2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043
<br />Tax Levy: Current
<br />$ 21,000
<br />$ 21,000
<br />$ 21,000
<br />$ 21,000
<br />$ 21,000
<br />$ 21,000 $ 21,000 $ 21,000 $ 21,000 $ 21,000 $ 21,000 $ 21,000 $ 21,000 $ 21,000 $ 21,000 $ 21,000 $ 21,000 $ 21,000 $ 21,000 $
<br />Tax Levy: Add/Sub
<br />-
<br />-
<br />-
<br />-
<br />-
<br />- - - - - - - - - - - - - -
<br />Other/Transfer In
<br />25,000
<br />-
<br />140,000
<br />-
<br />-
<br />- - - - - - - - - - - - - -
<br />Sale of Assets
<br />-
<br />-
<br />-
<br />-
<br />-
<br />- - - - - - - - - - - - -
<br />Interest Earnings
<br />8,376
<br />8,313
<br />6,499
<br />4,149
<br />4,652
<br />1,465 - - - - - - - - - - - - -
<br />Revenues $ 54,376
<br />$ 29,313
<br />$ 167,499
<br />$ 25,149
<br />$ 25,652
<br />$ 22,465 $ 21,000 $ 21,000 $ 21,000 $ 21,000 $ 21,000 $ 21,000 $ 21,000 $ 21,000 $ 21,000 $ 21,000 $ 21,000 $ 21,000 $ 21,000 $
<br />Updated 811212024
<br />2044
<br />21,000
<br />21,000 $ 618,455
<br />Vehicles $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
<br />Equipment - - - - - - - - - - - - - - - - - - - -
<br />Furniture & Fixtures - - - - - - - - - - - - - - - - - - - -
<br />Buildings - - - - - - - - - - - - - - - - - - - -
<br />Improvements 57,500 120,000 285,000 - 185,000 347,500 170,000 22,500 22,500 - 175,000 30,000 20,000 50,000 85,000 155,000 50,000 65,000 - -
<br />Expenditures $ 57,500 $ 120,000 $ 285,000 $ - $ 185,000 $ 347,500 $ 170,000 $ 22,500 $ 22,500 $ - $ 175,000 $ 30,000 $ 20,000 $ 50,000 $ 85,000 $ 155,000 $ 50,000 $ 65,000 $ - $ - ia 1,840,000
<br />Beginning Cash Balance
<br />Annual Surplus (deficit)
<br />Cash B alance
<br />Cash Balance (Year -End)
<br />Planned CIP Surplus/Deficit
<br />Adjust for Delayed CIP Items
<br />Cash Balance (Beg. Year)
<br />$ 418,775 $ 415,651 $ 324,964 $ 207,463 $ 232,612 $ 73,264 $ (251,770) $ (400,770) $ (402,270) $ (403,770) $ (382,770) $ (536,770) $ (545,770) $ (544,770) $ (573,770) $ (637,770) $ (771,770) $ (800,770) $ (844,770) $ (823,770)
<br />(3125) (90687) (119501) 25149 (159348) (325035) (149000) (1500) (1500) 21000 (154,000) (9000) 1000 (29000) (64,000) (134000) (29000) (44000) 21000 21000
<br />$ 415,651 $ 324,964 $ 207,463 $ 232,612 $ 73,264 $ (251,770) $ (400,770) $ (402,270) $ (403,770) $ (382,770) $ (536,770) $ (545,770) $ (544,770) $ (573,770) $ (637,770) $ (771,770) $ (800,770) $ (844,770) $ (823,770) $ (802,770)
<br />$ 147,656
<br />2023
<br />271,119
<br />2024
<br />-
<br />2024
<br />$ 418,775
<br />2025
<br />* Current Assets - Current Liabilities
<br />Expenditure Detail
<br />Street Light Maintenance Fund
<br />$600,000
<br />$400,000
<br />$200,000
<br />$(200,000) 025 2028 2031 2034 2037 2040 2043
<br />$(400,000)
<br />$(600,000)
<br />$(800,000)
<br />$(1,000,000)
<br />Revenues Expenditures CashBalance
<br />Key
<br />Description
<br />2025
<br />2026
<br />2027 2028
<br />2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043
<br />2044
<br />I
<br />227448-Arthur
<br />10,000
<br />-
<br />- -
<br />- - - - - - - - - - - - - - -
<br />- $ 10,000
<br />I
<br />227448 - County Rd C
<br />2,500
<br />-
<br />- -
<br />- - - - - - - - - - - - - - -
<br />- 2,500
<br />I
<br />184393 - Centre Pointe System
<br />45,000
<br />-
<br />- -
<br />- - - - - - - - - - - - - - -
<br />- 45,000
<br />I
<br />184397-Long Lake Rd
<br />-
<br />20,000
<br />- -
<br />- - - - - - - - - - - - - - -
<br />- 20,000
<br />I
<br />227448 - Lincoln Area
<br />-
<br />60,000
<br />- -
<br />- - - - - - - - - - - - - - -
<br />- 60,000
<br />I
<br />227448 - 2955 Lincoln
<br />-
<br />5,000
<br />- -
<br />- - - - - - - - - - - - - - -
<br />- 5,000
<br />I
<br />Dale Street Tunnel Lighting System
<br />-
<br />35,000
<br />- -
<br />- - - - - - - - - - - - - - -
<br />- 35,000
<br />I
<br />227447-Highpointe
<br />-
<br />-
<br />82,500 -
<br />- - - - - - - - - - - - - - -
<br />- 82,500
<br />I
<br />227447 - Terrace Ct
<br />-
<br />-
<br />30,000 -
<br />- - - - - - - - - - - - - - -
<br />- 30,000
<br />I
<br />227447 - Overlook Dr
<br />-
<br />-
<br />7,500 -
<br />- - - - - - - - - - - - - - -
<br />- 7,500
<br />I
<br />227447 - Owasso Hills
<br />-
<br />-
<br />157,500 -
<br />- - - - - - - - - - - - - - -
<br />- 157,500
<br />I
<br />227448-Hillsview
<br />-
<br />-
<br />7,500 -
<br />- - - - - - - - - - - - - - -
<br />- 7,500
<br />I
<br />Lighting System - County Road C,
<br />-
<br />-
<br />- -
<br />185,000 - - - - - - - - - - - - - -
<br />- 185,000
<br />I
<br />227448-Patton Rd System
<br />-
<br />-
<br />- -
<br />- 17,500 - - - - - - - - - - - - -
<br />- 17,500
<br />I
<br />Lighting System - Terminal Rd/132I
<br />-
<br />-
<br />- -
<br />- 30,000 - - - - - - - - - - - - -
<br />- 30,000
<br />I
<br />Lighting System - Larpentuer
<br />-
<br />-
<br />- -
<br />- 250,000 - - - - - - - - - - - - -
<br />- 250,000
<br />I
<br />Lighting System - Cty Rd B2, Fairy
<br />-
<br />-
<br />- -
<br />- 50,000 - - - - - - - - - - - - -
<br />- 50,000
<br />21
<br />Page 24 of 55
<br />
|