|
IG5iRM1TiL-- I a
<br />City of Roseville
<br />Capital Improvement Plan: Summary of All Capital Funds
<br />2025-2044
<br />Summary by Function
<br />2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035
<br />Tax Levy: Current $ 4,000,000 $ 4,000,000 $ 4,000,000 $ 4,000,000 $ 4,000,000 $ 4,000,000 $ 4,000,000 $ 4,000,000 $ 4,000,000 $ 4,000,000 $ 4,000,000
<br />Tax Levy: Add/Sub* - - - - - - - - - - -
<br />Fees, MSA, Asmnts,Trfs, ARP 4,257,600 6,738,208 4,986,350 4,249,430 3,255,000 3,285,000 3,315,000 3,396,000 3,599,000 3,666,000 3,736,000
<br />Sale ofAssets/Intemal Loan 167,000 2,776,909 165,500 133,000 148,500 123,000 130,000 1,953,000 30,000 64,500 177,000
<br />Interest Earnings 370,538 322,571 137,997 95,874 79,949 77,989 70,707 60,538 50,112 57,782 45,588
<br />Revenues $ 8,795,138 $ 13,837,688 $ 9,289,846 $ 8,478,304 $ 7,483,449 $ 7,485,989 $ 7,515,707 $ 9,409,538 $ 7,679,112 $ 7,788,282 $ 7,958,588
<br />2036 2037 2038 2039 2040 2041
<br />$ 4,000,000 $ 4,000,000 $ 4,000,000 $ 4,000,000 $ 4,000,000 $ 4,000,000
<br />3,710,000 3,774,000 3,753,000 3,750,000 3,759,000 3,710,000
<br />85,000 60,000 67,000 94,500 50,000 50,000
<br />15,634 13,197 12,850 14,773 12,397 19,799
<br />$ 7,810,634 $ 7,847,197 $ 7,832,850 $ 7,859,273 $ 7,821,397 $ 7,779,799
<br />Updated 8/I2/202
<br />2042 2043 2044 Total
<br />$ 4,000,000 $ 4,000,000 $ 4,000,000 $ 80,000,OOC
<br />3,696,000 3,740,000 3,696,000 78,071,58E
<br />30,000 30,000 30,000 6,364,909
<br />6,050 10,704 21,908 1,496,957
<br />$ 7,732,050 $ 7,780,704 $ 7,747,908 $ 165,933,454
<br />Administration $
<br />23,000 $
<br />75,000 $
<br />45,000 $
<br />23,000 $
<br />20,000 $
<br />20,000 $
<br />20,000 $
<br />20,000 $
<br />20,000 $
<br />23,000 $
<br />20,000
<br />$ 75,000 $
<br />23,000
<br />$ 20,000 $
<br />20,000 $
<br />23,000 $
<br />20,000
<br />$ 20,000
<br />$ 23,000 $
<br />20,000
<br />$ 553,000
<br />Finance
<br />-
<br />50,000
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />400,000
<br />-
<br />-
<br />-
<br />-
<br />-
<br />450,000
<br />Central Services
<br />58,500
<br />58,500
<br />58,500
<br />58,500
<br />58,500
<br />58,500
<br />58,500
<br />58,500
<br />58,500
<br />58,500
<br />58,500
<br />58,500
<br />58,500
<br />58,500
<br />58,500
<br />58,500
<br />58,500
<br />58,500
<br />58,500
<br />58,500
<br />1,170,000
<br />Police
<br />675,900
<br />781,010
<br />624,480
<br />733,845
<br />645,350
<br />624,020
<br />814,110
<br />583,160
<br />609,620
<br />745,845
<br />585,350
<br />736,230
<br />665,260
<br />599,800
<br />652,120
<br />712,845
<br />738,560
<br />601,880
<br />655,900
<br />641,800
<br />13,427,085
<br />Fire
<br />675,850
<br />1,922,000
<br />676,500
<br />380,000
<br />212,000
<br />374,350
<br />196,000
<br />607,000
<br />47,000
<br />360,000
<br />2,011,850
<br />375,000
<br />330,000
<br />180,000
<br />121,000
<br />737,350
<br />1,625,000
<br />585,000
<br />148,000
<br />10,000
<br />11,573,900
<br />Public Works
<br />341,000
<br />117,000
<br />783,500
<br />796,000
<br />165,000
<br />115,000
<br />466,000
<br />170,000
<br />633,000
<br />428,000
<br />671,000
<br />311,100
<br />857,500
<br />110,000
<br />280,000
<br />838,000
<br />297,000
<br />120,000
<br />65,000
<br />20,000
<br />7,584,100
<br />Parks & Recreation
<br />495,513
<br />192,000
<br />204,000
<br />244,000
<br />325,500
<br />428,000
<br />15,000
<br />447,000
<br />300,000
<br />400,000
<br />339,000
<br />163,000
<br />38,000
<br />596,000
<br />53,500
<br />157,000
<br />235,000
<br />79,000
<br />-
<br />-
<br />4,711,513
<br />General Facility Improvements
<br />1,264,595
<br />2,986,000
<br />1,073,925
<br />927,744
<br />572,500
<br />715,000
<br />1,099,000
<br />186,000
<br />981,300
<br />837,500
<br />872,000
<br />607,000
<br />575,000
<br />167,000
<br />544,000
<br />426,000
<br />2,419,000
<br />635,000
<br />11,087,000
<br />4,000
<br />27,979,564
<br />Park Improvements
<br />1,436,500
<br />2,102,500
<br />805,000
<br />940,000
<br />945,000
<br />1,022,500
<br />895,000
<br />663,000
<br />557,500
<br />1,397,000
<br />1,041,000
<br />1,010,000
<br />860,000
<br />640,000
<br />405,000
<br />535,000
<br />1,115,000
<br />560,000
<br />250,000
<br />250,000
<br />17,430,000
<br />Street Improvements
<br />2,125,000
<br />3,425,000
<br />3,350,000
<br />2,650,000
<br />1,650,000
<br />1,750,000
<br />1,750,000
<br />1,750,000
<br />1,750,000
<br />1,750,000
<br />1,750,000
<br />1,850,000
<br />1,850,000
<br />1,850,000
<br />1,850,000
<br />1,850,000
<br />1,850,000
<br />1,850,000
<br />1,850,000
<br />1,850,000
<br />40,350,000
<br />Street Lighting
<br />57,500
<br />120,000
<br />285,000
<br />-
<br />185,000
<br />347,500
<br />170,000
<br />22,500
<br />22,500
<br />-
<br />175,000
<br />30,000
<br />20,000
<br />50,000
<br />85,000
<br />155,000
<br />50,000
<br />65,000
<br />-
<br />-
<br />1,840,000
<br />Pathways (Existing)
<br />289,300
<br />336,300
<br />551,300
<br />441,300
<br />321,300
<br />411,300
<br />371,300
<br />341,300
<br />351,300
<br />341,300
<br />456,300
<br />451,300
<br />321,300
<br />321,300
<br />451,300
<br />366,300
<br />376,300
<br />391,300
<br />371,300
<br />341,300
<br />7,604,000
<br />Community Development
<br />45,000
<br />100,000
<br />45,000
<br />-
<br />-
<br />45,000
<br />-
<br />-
<br />-
<br />45,000
<br />45,000
<br />100,000
<br />45,000
<br />-
<br />-
<br />45,000
<br />-
<br />-
<br />-
<br />45,000
<br />560,000
<br />Golf
<br />68,000
<br />672,000
<br />69,500
<br />134,000
<br />94,500
<br />49,000
<br />17,000
<br />30,000
<br />84,000
<br />104,500
<br />187,000
<br />69,000
<br />108,000
<br />75,000
<br />118,500
<br />64,000
<br />34,000
<br />-
<br />44,000
<br />-
<br />2,022,000
<br />Recy ling
<br />650,000
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />650,000
<br />Water
<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 />Sanitary Sewer
<br />1,894,000
<br />1,654,000
<br />1,642,000
<br />1,743,500
<br />1,510,000
<br />1,154,000
<br />1,121,500
<br />1,089,000
<br />1,054,000
<br />1,204,000
<br />1,292,000
<br />1,194,000
<br />1,061,500
<br />2,029,000
<br />1,173,500
<br />1,054,000
<br />1,054,000
<br />1,454,000
<br />1,106,000
<br />20,000
<br />25,504,000
<br />StortnSewer
<br />1,124,000
<br />1,505,000
<br />1,335,500
<br />1,281,000
<br />1,165,000
<br />1,114,000
<br />1,562,000
<br />1,849,000
<br />1,609,000
<br />2,085,000
<br />1,914,000
<br />2,625,000
<br />1,856,500
<br />2,494,000
<br />1,903,000
<br />2,443,000
<br />2,234,000
<br />2,110,000
<br />2,121,000
<br />-
<br />34,330,000
<br />Expenditures $ 12,067,658 $ 16,550,310 $ 13,271,205 $ 11,446,389 $ 8,512,650 $ 8,912,170 $ 9,664,410 $ 10,335,460 $ 9,231,720 $ 10,866,645 $ 12,472,000 $ 10,909,130 $ 9,703,560 $ 10,324,600 $ 9,123,420 $ 10,478,995 $ 13,145,360 $ 9,538,680 $ 18,855,700 $ 3,260,600 $ 218,670,662
<br />Beginning Cash Balance $ 21,164,499 $ 17,891,979 $ 15,179,358 $ 11,197,999 $ 8,229,914 $ 7,200,714 $ 5,774,533 $ 3,625,830 $ 2,699,907 $ 1,147,299 $ (1,931,064) $ (6,444,476) $ (9,542,972) $ (11,399,336) $ (13,891,085) $ (15,155,232) $ (17,812,830) $ (23,178,390) $ (24,985,020) $ (36,060,017)
<br />Annual Surplus (deficit) (3,272,520) (2,712,622) (3,981,359) (2,968,085) (1,029,201) (1,426,181) (2,148,703) (925,922) (1,552,608) (3,078,363) (4,513,412) (3,098,496) (1,856,363) (2,491,750) (1,264,147) (2,657,598) (5,365,561) (1,806,630) (11,074,996) 4,487,308
<br />Ending Cash Balance $ 17,891,979 $ 15,179,358 $ 11,197,999 $ 8,229,914 $ 7,200,714 $ 5,774,533 $ 3,625,830 $ 2,699,907 $ 1,147,299 $ (1,931,064) $ (6,444,476) $ (9,542,972) $ (11,399,336) $ (13,891,085) $ (15,155,232) $ (17,812,830) $ (23,178,390) $ (24,985,020) $ (36,060,017) $ (31,572,709)
<br />$18 Summary of CIP - Financial Projection
<br />$30
<br />$20
<br />$10
<br />0
<br />$(10) 025 2028 2031 203 2037 2040 2043
<br />$(20) $(32)
<br />$(30)
<br />$(40)
<br />Revenues �Expendilures -Ending Cash Balance
<br />Total Expenditures $ 218,670,662
<br />Total Revenues 165,933,454
<br />Total Cash Reserves 21,164,499
<br />Total Funding $ 187,097,953
<br />Total Financing Surplus (Gap) $ (31,572,709)
<br />1
<br />Page 17 of 55
<br />
|