|
City of Roseville
<br />Capital Improvement Plan: Sanitary Sewer Capital Fund (600)
<br />2025-2044
<br />Updated 811212024
<br />2025 2026 2027 2028 2029
<br />2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044
<br />Tax Levy: current-
<br />TaxLevy:Add/Sub-
<br />Fees, Licenses, & Permits
<br />1,381,000 1,381,000 1,381,000 1,381,000 1,381,000
<br />1,381,000 1,381,000 1,381,000 1,381,000 1,381,000 1,381,000 1,381,000 1,381,000 1,381,000 1,381,000 1,381,000 1,381,000 1,381,000 1,381,000 1,381,000 $
<br />27,620,000
<br />Grants (Met Council, etc)
<br />-
<br />$
<br />-
<br />SaleofAssets
<br />165,000 - - - -
<br />- - - - - - - - - - - - - - - $
<br />165,000
<br />Interest Earnings
<br />59,202 53,426 49,034 44,795 38,441
<br />36,630 41,902 47,930 54,729 62,364 67,151 70,274 75,419 83,318 72,024 77,615 85,707 93,961 94,380 101,768 $
<br />1,310,071
<br />Revenues $ 1,605,202 $ 1,434,426 $ 1,430,034 $ 1,425,795 $ 1,419,441 $ 1,417,630 $ 1,422,902 $ 1,428,930 $1,435,729 $1,443,364 $1,448,151 $1,451,274 $1,456,419 $1,464,318 $1,453,024 $1,458,615 $1,466,707 $1,474,961 $ 1,475,380 $ 1,482,768 -$ 29,095,071
<br />Vehicles $ 605,000 $ 75,000 $ 73,000 $ 135,000 $ - $ - $ - $ - $ - $ 150,000 $ 238,000 $ - $ - $ 860,000 $ 73,000 $ - $ - $ - $ - $ -
<br />Equipment 120,000 230,000 270,000 314,500 56,000 100,000 67,500 35,000 - - - 140,000 7,500 115,000 46,500 - - 100,000 52,000 20,000
<br />Furniture & Fixtures - - - - - - - - - - - - - - - - - - - -
<br />Buildings _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
<br />Improvements 1,169,000 1,349,000 1,299,000 1,294,000 1,454,000 1,054,000 1,054,000 1,054,000 1,054,000 1,054,000 1,054,000 1,054,000 1,054,000 1,054,000 1,054,000 1,054,000 1,054,000 1,354,000 1,054,000 -
<br />Expenditures $1,894,000 $1,654,000 $1,642,000 $1,743,500 $ 1,510,000 $ 1,154,000 $ 1,121,500 $ 1,089,000 $ 1,054,000 $ 1,204,000 $ 1,292,000 $ 1,194,000 $ 1,061,500 $ 2,029,000 $ 1,173,500 $ 1,054,000 $ 1,054,000 $ 1,454,000 $ 1,106,000 $ 20,000 $ 25,504,000
<br />Beginning Cash Balance
<br />$2,960,094
<br />$2,671,296 $2,451,722 $2,239,756 $ 1,922,051 $ 1,831,492 $ 2,095,122 $ 2,396,525
<br />$2,736,455 $3,118,184 $3,357,548 $3,513,699 $3,770,973 $4,165,892 $3,601,210 $3,880,734 $4,285,349 $4,698,056 $4,719,017 $ 5,088,397
<br />Annual Surplus (deficit)
<br />(288,798)
<br />(219,574) (211,966) (317,705) (90,559) 263,630 301,402 339,930
<br />381,729 239,364 156,151 257,274 394,919 (564,682) 279,524 404,615 412,707 20,961 369,380 1,462,768
<br />Cash Balance
<br />$2,671,296
<br />$2,451,722 $2,239,756 $1,922,051 $ 1,831,492 $ 2,095,122 $ 2,396,525 $ 2,736,455
<br />$3,118,184 $3,357,548 $3,513,699 $3,770,973 $4,165,892 $3,601,210 $3,880,734 $4,285,349 $4,698,056 $4,719,017 $5,088,397 $ 6,551,165
<br />Cash Balance (Year -End) *
<br />$ 1'981,319
<br />2023
<br />Less AmtNeeded for Operations *"
<br />(771,387)
<br />2024
<br />Sanitary Sewer Capital Fund
<br />** 2020 Utility fee amount requires a 0.0%rate increase
<br />Planned CIP Surplus/Deficit
<br />250,162
<br />2024
<br />$7
<br />1.2
<br />Adjust for Delayed CIP Items
<br />(1,500,000)
<br />c
<br />Cash Balance (Beg. Year)
<br />$ 2,960,094
<br />2024
<br />2 $6
<br />1
<br />Adopted Budget (ExclCapital, Dep
<br />$ 5,142,581
<br />2024
<br />$5
<br />0.8
<br />* Current Assets - Current Liabilities
<br />** 15% of Annual Budget Needed for Cash -Flow Purposes
<br />Expenditure Detail
<br />Key
<br />Description 2025 2026
<br />2027 2028
<br />2029 2030 2031 2032
<br />E
<br />#137 2017 Trafifix Scorpion 10002 - -
<br />7,500 -
<br />- - - -
<br />E
<br />#211 A14 2015 Caterpillar CVP75 - -
<br />- 7,000
<br />- - - -
<br />E
<br />#211A Sand Bucket 24" 315D - -
<br />- 10,000
<br />- - - -
<br />E
<br />#2142021 Mobile Tech 7'X12'Car - -
<br />- -
<br />- - 42,500 -
<br />E
<br />#215 2005 Sreco-Flexible EMSP-6 - -
<br />- 35,000
<br />- - - -
<br />E
<br />#220 2010 Towmaster 12-T 9,980I - -
<br />- -
<br />- - 20,000
<br />E
<br />#225 Al2 2014 Caterpillar H65ES - -
<br />- -
<br />5,000 - - -
<br />E
<br />#225 A13 2014 Rotobec PCO18B C - -
<br />- -
<br />7,000 - - -
<br />E
<br />#225 2015 Caterpillar 305E Excava - -
<br />- -
<br />40,000 - - -
<br />E
<br />#232 1999 Cummins Onan Dgdb33 - -
<br />- -
<br />- - - -
<br />E
<br />#235 2004 Hirnoinsa/Iveco Hiw-40r Towable Gen 90,000
<br />- -
<br />- - - -
<br />E
<br />#237 2017 Bomag BMP8500 Coml - -
<br />- -
<br />- - - 15,000
<br />E
<br />#241 2019 Rover Sewer Camera - -
<br />- -
<br />- 100,000 - -
<br />E
<br />#xx 6" Pump Trailer 20,000
<br />- -
<br />E
<br />#xx GPS Unit (1/3) - -
<br />- -
<br />4,000 - - -
<br />E
<br />#xx Skid Steer (Track) - -
<br />- -
<br />- - 25,000 -
<br />2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044
<br />- - - - 7,500 - - - - - - - $ 15,000
<br />- - - - - - - - - - 7,000 14,000
<br />- - - - - - - - - 10,000 20,000
<br />42,500 = _ _ 40,000
<br />- - - - - - - - - - 35,000 70,000
<br />- - - - - - - - - - - 20,000 4Q,000
<br />5,000
<br />7,000
<br />- - - - - - - - - - - - 40,000
<br />- - - - 90,000 - - - - - - 180,000
<br />- - - - - - - - - - - - 15,000
<br />- - - - - - - - - 100,000 - - 200,000
<br />- - - - - - - - - - - - 20,000
<br />- - - - - - 4,000 - - - - - 8,000
<br />- - - - - 25,000 - - - - - - 50,000
<br />30
<br />Page 32 of 55
<br />
|