|
000
<br />000
<br />005
<br />,,,
<br />00
<br />6
<br />47
<br />0
<br />581,00044
<br />495,9504
<br />,
<br />4,385,0001,688,0009,183,8958,667,3006,088,9004,495,5001,518,1955,155,0001
<br />Total
<br />83,940,00014,722,20017,074,50039,710,30522,312,50025,611,00046,806,000
<br />206,426,745
<br />$ $ $ $
<br />$ $
<br /> $
<br />Updated 7/1/2022
<br />---
<br />
<br />2,500
<br />16,00084,40020,00035,00092,26410,000
<br />285,000466,360173,500536,000875,000240,000796,953
<br />2042
<br />4,180,0001,850,0001,070,0002,190,0007,661,024
<br />(9,400,408)(8,603,455)
<br />Total Funding197,823,290
<br />$ 83,131,029 766,829 5,450,775$
<br /> $ $ $
<br />$ 177,673,633
<br />Total Revenues177,673,633
<br />---
<br />
<br />Total Expenditures206,426,745
<br />Total Cash Reserves20,149,657
<br />7,300
<br />16,00084,40096,000
<br />75,264
<br />285,000165,000245,000
<br />570,940
<br />2041
<br />4,180,0001,055,0001,850,0002,215,000
<br />1,338,0002,664,5001,170,0001,629,000
<br />(4,715,591)(4,684,817)(9,400,408)
<br />13,181,404
<br />Total Financing Surplus (Gap)(8,603,455)
<br />$ 3,721,000 25,000 246,977$ 8,457,977$
<br /> $ $ $
<br />--
<br />
<br />75,00084,40051,26441,30013,000
<br />285,000455,465100,000179,000401,500505,000245,000
<br />
<br />2040
<br />4,180,0001,161,0001,850,0001,107,0001,075,0002,458,0009,801,929
<br />(3,407,490)(1,308,102)(4,715,591)
<br />$ 3,721,000$ $
<br /> 25,000 285,587$ 8,496,587 $ $
<br />--
<br />
<br />16,00065,500
<br />84,40053,00075,03010,100
<br />455,000
<br />285,000517,140217,500551,000375,000330,000
<br />(719,184)
<br />2039
<br />4,180,0001,850,0001,100,0001,210,0002,346,5009,256,170
<br />(3,407,490)
<br />(2,688,305)
<br />$ 3,734,000 25,000 269,827$ 8,493,827$
<br /> $ $ $
<br />-
<br />
<br />00
<br />00
<br />00
<br />,,
<br />502,950
<br />16,00084,40066,1265083,000
<br />
<br />285,000387,920275,000461,000446,000195,5002
<br />610,000
<br />(994,341)
<br />2038
<br />4,180,0001,850,0001,200,0001,070,0002,535,0009,537,896
<br />(1,693,964)(2,688,305)
<br />$ 3,786,500 25,000 260,486$ 8,536,986$
<br /> $ $ $
<br />--
<br />
<br />21,00084,40036,00090,50056,000
<br />285,000428,080300,000176,600517,500108,119710,000200,000
<br />(607,853)
<br />2037
<br />4,180,0001,850,0001,155,0001,237,5002,627,5009,598,199
<br />(1,086,111)(1,693,964)
<br />$ 3,804,000 25,000 249,555$ $ $
<br /> $
<br />$ 8,543,555
<br />-
<br />
<br />7,300
<br />84,40040,00063,000
<br />16,000 70,650
<br />285,000421,100138,000445,500330,000
<br />528,710143,500890,000
<br />(607,853)
<br />2036
<br />4,180,0001,850,0001,350,0001,309,0002,778,0001,330,451
<br />(1,938,304)
<br />10,465,160
<br />$ 3,777,000 25,000 245,088$ 8,512,088$
<br /> $ $ $
<br />0
<br />0
<br />0
<br />,
<br />05,300
<br />984,40081,40045,00059,000
<br />235,000338,280303,000335,000304,500805,000335,000
<br />2035
<br />4,180,0001,056,5001,750,0001,107,0001,145,0002,212,5002,999,4241,330,451
<br />(1,668,973)
<br />10,141,880
<br />$ 3,784,000
<br /> 25,000 252,856$ 8,526,856$
<br /> $ $ $
<br />-
<br />
<br />12,000
<br />84,40048,00070,96470,00078,100
<br />702,000
<br />235,000424,915255,000912,500220,000
<br />2034
<br />4,180,0001,260,0001,750,0002,112,0001,085,0003,005,0006,645,0182,999,424
<br />(3,645,594)
<br />12,105,879
<br />$ 3,780,000 25,000 252,907$ 8,472,907
<br /> $ $ $
<br />$ 85,000
<br />-
<br />
<br />2,950
<br />84,40051,00084,43050,00030,000
<br />235,000448,340172,000980,800200,000
<br />116,000557,500
<br />(690,315)
<br />2033
<br />4,180,0001,750,0001,340,0002,215,0009,168,4206,645,018
<br />1,070,0007,335,333
<br />$ 3,733,000 25,000 287,285$ 8,460,285$ 16,000
<br /> $ $ $
<br />-
<br />
<br />0
<br />0
<br />0
<br />,
<br />52,500
<br />84,40051,826237,000
<br />205,000406,780266,500422,500396,000200,500653,000220,000
<br />(575,254)
<br />2032
<br />4,180,0001,750,0001,135,0001,070,0002,281,5009,023,5067,910,5887,335,333
<br />$ 3,751,000 25,000 $ $
<br /> 287,105$ 8,478,105$ 16,000 $
<br />--
<br />
<br />7,300
<br />84,40025,000
<br />10,000
<br />339,000
<br />215,000637,480346,000101,819570,000250,000
<br />2031
<br />4,180,0001,093,5001,750,0001,155,0001,124,0002,752,0009,608,6037,910,588
<br />(1,698,016)
<br />10,261,499
<br />$ 3,758,000 25,000 280,252$ 8,448,252$ 21,000
<br /> $ $ $
<br />--
<br />
<br />$(9)
<br />84,40086,05041,30052,000
<br />205,000547,150125,500335,000389,500942,500290,000
<br />2030
<br />4,180,0001,750,0001,187,0001,155,0002,204,0009,608,603
<br />1,060,500
<br />(1,726,559)
<br />10,329,90011,335,162
<br />$ 3,859,247 25,000 284,236$ 8,563,483$ 16,000
<br /> $ $ $
<br />-
<br />
<br />0000
<br />0000
<br />0010
<br />,,,,
<br />5000
<br />84,40085,3005 01 6
<br />
<br />(71,523)
<br />185,000403,730106,500144,000320,500179,500640,0002
<br />
<br />2029
<br />4,180,0001,650,0001,235,0001,135,0002,318,0008,643,030
<br />11,406,68511,335,162
<br />$ 3,901,247 25,000 292,094 $ $ $
<br />
<br />$ 8,603,341$ 80,000
<br />--
<br />
<br />0040000
<br />0060000
<br />0595005
<br />,,,,,,
<br />,
<br />0222,950002
<br />7
<br />Ending Cash Balance
<br />84,40080531
<br /> 4 2
<br />195,000385,465555,60017295,00022
<br />413,500 6
<br />,,
<br />,
<br />2028
<br />4,180,0002,650,00012
<br />1,215,0001
<br />
<br />(2,076,358)
<br />11,663,37913,483,04311,406,685
<br />$ 3,909,247 25,000 272,260$ 8,571,507$ 16,000 $
<br /> $ $
<br />---
<br />
<br />84,40081,73030,00090,500
<br />195,000366,450254,000476,600516,500620,000375,000
<br />
<br />(938,642)
<br />2027
<br />4,180,0001,650,0001,162,5001,427,5009,472,680
<br />
<br />
<br />14,421,68513,483,043
<br />
<br />
<br />Expenditures
<br />
<br />
<br />$ 4,896,747 25,000 $ $
<br /> 290,274$ 9,587,021$ 16,000 $
<br />-
<br />
<br />7,300
<br />84,40073,82625,000
<br />145,000471,630311,500127,000296,000449,500495,000180,000103,000
<br />(661,104)
<br />2026
<br />4,180,0002,463,0001,560,0001,424,000
<br />10,437,15615,082,78914,421,685
<br />Summary of CIP -Financial Projection
<br />$ 3,849,247 25,000 284,791$ 8,534,038$ 20,000
<br /> 2,317,500$ $ $
<br />
<br />Revenues
<br />-
<br />
<br />00
<br />00$18
<br />00
<br />,,
<br />005,300
<br />84,4003842,000
<br />
<br />145,000322,970932,000158,000857,500109,4192732,000
<br />418,500
<br />2025
<br />4,180,0002,306,0001,480,000
<br />1,126,500
<br />(1,828,412)
<br />11,235,58916,911,20215,082,789
<br />2023202620292032203520382041
<br />$ 4,885,247 291,829 273,976$ 9,776,052$ 16,000
<br /> 2,350,000$ $ $
<br />-
<br />
<br /> $-
<br /> $5
<br /> $(5)
<br /> $20 $15 $10
<br /> $(10) $(15)
<br />75,00050,00084,40080,00050,35078,100
<br />568,090196,000507,000320,000584,000210,000
<br />2024
<br />4,250,0001,555,5001,728,0002,450,0001,465,000
<br />Millions
<br />(1,529,683)
<br />11,727,44018,440,88516,911,202
<br />$ 4,767,247 25,000 289,930 2,301,000$
<br /> $ $
<br />$ 9,407,177$ 50,000
<br />2,300
<br />84,40045,000
<br />49,40089,500
<br />120,000300,000508,000464,000200,000
<br />221,300345,000
<br />2023
<br />4,450,0006,180,0523,091,3051,707,000
<br />1,442,0001,055,0001,810,000
<br />18,440,885
<br />$ 5,533,247 25,000 314,510$ 10,197,757$ 21,000
<br /> 1,780,000$ $ $
<br />A
<br />Summary of All Capital Funds
<br />Revenues11,005,833
<br />Expenditures12,714,605
<br /> Function
<br />r
<br />y
<br /> b
<br />y
<br />Tax Levy: CurrentTax Levy: Add/Sub*Fees, MSA, Asmnts,Trfs, ARPSale of Assets/Internal Loan25,000Interest Earnings230,781FinanceCentral ServicesPoliceFireParks & RecreationGeneral Facility
<br /> Improvements1,268,400Information TechnologyStreet ImprovementsStreet LightingPathways (Existing)Community DevelopmentWaterSanitary SewerStorm SeweBeginning Cash Balance20,149,657Annual
<br /> Surplus (deficit)(1,708,772)Ending Cash Balance* includes moving $250,000 from Street operations to Street Improvements - Mill & overlay
<br />Administration32,000Public WorksPark ImprovementsGolf
<br />City of Roseville
<br />Capital Improvement Plan: 2023-2042 Summar
<br />
<br />
|