|
City of Roseville
<br />Capital Improvement Plan: Water Capital Fund (610)
<br />2025-2044
<br />Updated 811212024
<br />2025
<br />2026
<br />2027
<br />2028
<br />2029
<br />2030
<br />2031
<br />2032
<br />2033
<br />2034
<br />2035
<br />2036
<br />2037
<br />2038
<br />2039
<br />2040
<br />2041
<br />2042
<br />2043
<br />2044
<br />Tax Levy: current
<br />$
<br />-
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ - $
<br />-
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />Tax Levy: Add/Sub
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />Fees, Licenses, & Permits
<br />507,600
<br />548,208
<br />592,065
<br />639,430
<br />700,000
<br />750,000
<br />800,000
<br />900,000
<br />1,000,000
<br />1,100,000
<br />1,200,000
<br />1,200,000
<br />1,200,000
<br />1,200,000
<br />1,200,000
<br />1,200,000
<br />1,200,000
<br />1,200,000
<br />1,200,000
<br />1,200,000
<br />19,537,302
<br />Debt Issuance
<br />-
<br />1,991,909
<br />0
<br />-
<br />-
<br />-
<br />-
<br />1,810,000
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />3,801,909
<br />Other - Arden Hills/ARPA
<br />100,000
<br />100,000
<br />200,000
<br />Interest Earnings
<br />28,387
<br />6,357
<br />1,162
<br />5,026
<br />8,846
<br />12,243
<br />16,308
<br />19,114
<br />97,442
<br />Revenues $
<br />607,600
<br />$ 2,640,117
<br />$ 620,452
<br />$ 645,786
<br />$ 700,000
<br />$ 750,000 $
<br />800,000
<br />$ 2,710,000
<br />$ 1,000,000
<br />$ 1,100,000
<br />$ 1,200,000
<br />$ 1,200,000
<br />$ 1,200,000
<br />$ 1,200,000
<br />$ 1,201,162
<br />$ 1,205,026
<br />$ 1,208,846
<br />$ 1,212,243
<br />$ 1,216,308
<br />$ 1,219,114
<br />Vehicles
<br />$
<br />-
<br />$ -
<br />$ 50,000
<br />$ 135,000
<br />$ 73,000
<br />$ 170,000 $
<br />30,000
<br />$ -
<br />$ -
<br />$ 73,000
<br />$ 50,000
<br />$ 110,000
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ 35,000
<br />$ -
<br />$ 50,000
<br />$ -
<br />Equipment
<br />120,000
<br />140,000
<br />270,000
<br />394,500
<br />56,000
<br />-
<br />65,000
<br />15,000
<br />-
<br />-
<br />-
<br />140,000
<br />-
<br />130,000
<br />4,000
<br />10,000
<br />-
<br />5,000
<br />22,000
<br />-
<br />Buildings
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />Improvements
<br />724,000
<br />314,000
<br />1,402,000
<br />564,000
<br />514,000
<br />514,000
<br />1,014,000
<br />2,504,000
<br />1,154,000
<br />1,014,000
<br />1,004,000
<br />1,004,000
<br />1,034,000
<br />1,004,000
<br />1,004,000
<br />1,004,000
<br />1,004,000
<br />1,004,000
<br />1,004,000
<br />Expenditures $
<br />844,000
<br />$ 454,000
<br />$ 1,722,000
<br />$ 1,093,500
<br />$ 643,000
<br />$ 684,000 $
<br />1,109,000
<br />$ 2,519,000
<br />$ 1,154,000
<br />$ 1,087,000
<br />$ 1,054,000
<br />$ 1,254,000
<br />$ 1,034,000
<br />$ 1,134,000
<br />$ 1,008,000
<br />$ 1,014,000
<br />$ 1,039,000
<br />$ 1,009,000
<br />$ 1,076,000
<br />$ - $
<br />20,931,500
<br />Beginning Cash Balance
<br />$
<br />(530,343)
<br />$ (766,743)
<br />$ 1,419,374
<br />$ 317,826
<br />$ (129,887)
<br />$ (72,887) $
<br />(6,887)
<br />$ (315,887)
<br />$ (124,887)
<br />$ (278,887)
<br />$ (265,887)
<br />$ (119,887)
<br />$ (173,887)
<br />$ (7,887)
<br />$ 58,113
<br />$ 251,275
<br />$ 442,301
<br />$ 612,147
<br />$ 815,390
<br />$ 955,697
<br />Annual Surplus (deficit)
<br />(236,400)
<br />2,186,117
<br />(1,101,548)
<br />(447,714)
<br />57,000
<br />66,000
<br />(309,000)
<br />191,000
<br />(154,000)
<br />13,000
<br />146,000
<br />(54,000)
<br />166,000
<br />66,000
<br />193,162
<br />191,026
<br />169,846
<br />203,243
<br />140,308
<br />1,219,114
<br />Cash Balance
<br />$
<br />(766,743)
<br />$ 1,419,374
<br />$ 317,826
<br />$ (129,887)
<br />$ (72,887)
<br />$ (6,887) $
<br />(315,887)
<br />$ (124,887)
<br />$ (278,887)
<br />$ (265,887)
<br />$ (119,887)
<br />$ (173,887)
<br />$ (7,887)
<br />$ 58,113
<br />$ 251,275
<br />$ 442,301
<br />$ 612,147
<br />$ 815,390
<br />$ 955,697
<br />$ 2,174,811
<br />Cash Balance (Year -End)
<br />** Less Amt Needed for Operations**
<br />Planned CIP Surplus/Deficit
<br />Adjust for Delayed CIP Items
<br />Cash Balance (Beg. Year)
<br />Adopted Budget (Excl.Capital, De
<br />* Current Assets - Current Liabilities excl. Deposits
<br />** 15% of Annual Budget Needed for Cash -Flow Purposes
<br />If we dont fund 100% of depreciation, $470,000 available in 2024
<br />Expenditure Detail
<br />Key Description
<br />E #137 2017 Trafifix Scorpion 10002 Alternator (1/3)
<br />E #138 2000 Towmaster Trailer
<br />E #211 A14 2015 Caterpillar CVP75 Vibratory Plate Compactor (1/
<br />E #211A Sand Bucket 24" 315D
<br />E #225 Al2 2014 Caterpillar H65ES Hydraulic Breaker (1/3)
<br />E #225 A13 2014 Rotobec PCO18B Grapple360 Mini Excavator (L
<br />E #225 2015 Caterpillar 305E Excavator
<br />E #2362021 Felling Ft7t Trailer
<br />E #237 2017 Boring BMP8500 Compactor
<br />E #240 2018 EH Wachs 77-000-38 Standard LX Valve Maintenanc
<br />E #xx 6" Pump Trailer
<br />E #xx GPS Unit (1/3)
<br />E #xx Skid Steer (Track)
<br />E Asset Management System
<br />E Trench Box - main 10'x8'
<br />E Trench Box GME 5'X3'
<br />E Water AMR meter system replacements
<br />I Water Booster Station
<br />I Elevated storage tank repainting contract
<br />I Elevated storage Tank #2
<br />I AH Meter Pits
<br />I Replace Water Tower Fence
<br />I Replace/Upgrade SCADA system (1/3)
<br />I Water Main Replacement *
<br />$ 748,483 2023
<br />(1,374,542) 2023
<br />95,716 2024
<br />2023
<br />$ (530,343) 2025
<br />$ 9,163,611 2023
<br />2025
<br />20,000
<br />100,000
<br />400,000
<br />10,000
<br />100,000
<br />14,000
<br />200,000
<br />2026
<br />40,000
<br />100,000
<br />10,000
<br />100,000
<br />4,000
<br />200,000
<br />Water - Capital Improvement Projects- 8% rates and bonding in
<br />$3 2026 1.2
<br />0
<br />$3 1
<br />$2 If
<br />$2 0.8
<br />$1 0.6
<br />EJM
<br />$1 0.4
<br />$-
<br />$(1) 0 of
<br />5 2028 2037 2040 2043 0.2
<br />$(1) 0
<br />Revenues Expenditures -Cash Balance
<br />2027 2028
<br />7,500 -
<br />10,000
<br />- 7,000
<br />- 10,000
<br />90,000
<br />2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044
<br />5,000
<br />7,000
<br />40,000
<br />10,000
<br />15,000
<br />4,000 -
<br />- 25,000
<br />30,000
<br />- 15,000 - - - -
<br />262,500 262,500 - - - -
<br />800,000 50,000 - - - -
<br />98,000 10,000 10,000 10,000 10,000 1,500,000
<br />140,000
<br />10,000
<br />10,000
<br />40,000
<br />100,000
<br />10,000
<br />90,000 -
<br />- 4,000
<br />25,000 -
<br />15,000
<br />30,000
<br />5,000
<br />7,000
<br />15,000
<br />4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000
<br />500,000 500,000 500,000 500,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000
<br />$ 7,500
<br />10,000
<br />14,000
<br />25,000
<br />5,000
<br />7,000
<br />40,000
<br />10,000
<br />30,000
<br />180,000
<br />20,000
<br />8,000
<br />50,000
<br />80,000
<br />30,000
<br />30,000
<br />825,000
<br />1,420,000
<br />1,678,000
<br />200,000
<br />86,000
<br />15,400,000
<br />28
<br />Page 30 of 55
<br />
|