|
City of Roseville
<br />Updated 5/15/17
<br />Summary of Fee-Supported Capital Funds
<br />Capital Improvement Plan:
<br />2018-2037
<br />20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />Tax Levy: current$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-
<br />Tax Levy: Add/Sub--------------------
<br />Fees, Licenses, Permits, MSA3,578,1003,578,1003,578,1003,578,1003,578,1003,578,1003,578,1003,578,1003,578,1003,578,1003,578,1003,578,1003,578,1003,578,1003,578,1003,578,1003,578,1003,578,1003,578,100
<br />3,578,100
<br />Sale of Assets500500500500500500500500500500500500500500500500500500500500
<br />Interest Earnings83,48867,52964,12863,07166,71670,22953,56058,21559,94663,30462,78663,75364,75964,83369,53177,06779,68474,94984,25884,412
<br />Revenues$3,662,088$3,646,129$3,642,728$3,641,671$3,645,316$3,648,829$3,632,160$3,636,815$3,638,546$3,641,904$3,641,386$3,642,353$3,643,359$3,643,433$3,648,131$3,655,667$3,658,284$3,653,549$3,662,858$
<br />3,663,012$72,948,217
<br />Communications$10,000$5,000$6,500$4,000$15,000$76,500$1,500$88,000$10,000$12,000$10,000$5,000$6,500$4,000$15,000$76,500$1,500$88,000$10,000$12,000
<br />License Center208,1005,9004,5003,8001,0001,005,8001,00028,1003,00014,4008,1007,9002,5003,8003,00029,0001,0005,800--
<br />Community Development22,50024,30025,3004,5009,0005,30027,30027,50033,00029,3005,3004,5009,00032,30033,30033,50039,0005,3004,300-
<br />Water2,175,000735,000842,0001,035,0001,065,0001,025,0001,000,0001,037,0001,055,0001,242,5001,200,0001,205,0001,252,0001,100,0001,180,0001,330,0001,810,0001,117,0001,970,0001,130,000
<br />
<br />Sanitary Sewer1,625,0001,840,0001,640,0001,549,0001,510,0001,355,0001,245,0001,260,0001,319,0001,047,5001,400,0001,055,0001,085,0001,039,0001,000,0001,040,0001,000,0001,015,0001,099,0001,107,500
<br />
<br />Storm Sewer1,090,0001,045,0001,321,000950,0001,215,0001,174,0001,080,0001,173,0001,370,0001,057,500995,0001,102,0001,014,0001,485,0001,082,0001,020,0001,760,0001,034,0001,438,000357,500
<br />
<br />Golf Course30,00067,00040,00043,00038,000518,00073,00012,50020,0007,00057,00087,00072,00017,500-40,0005,00015,00058,00032,000
<br />--------------------
<br />Expenditures$5,160,600$3,722,200$3,879,300$3,589,300$3,853,000$5,159,600$3,427,800$3,626,100$3,810,000$3,410,200$3,675,400$3,466,400$3,441,000$3,681,600$3,313,300$3,569,000$4,616,500$3,280,100$4,579,
<br />300$2,639,000$75,899,700
<br />Beginning Cash Balance$4,174,408$2,675,896$2,599,825$2,363,253$2,415,624$2,207,939$697,168$901,528$912,243$740,789$972,494$938,479$1,114,432$1,316,791$1,278,624$1,613,454$1,700,122$741,905$1,115,355$
<br />198,913
<br />Annual Surplus (deficit)(1,498,512)(76,071)(236,572)52,371(207,684)(1,510,771)204,36010,715(171,454)231,704(34,014)175,953202,359(38,167)334,83186,667(958,216)373,449(916,442)1,024,012
<br />
<br />Ending Cash Balance$2,675,896$2,599,825$2,363,253$2,415,624$2,207,939$697,168$901,528$912,243$740,789$972,494$938,479$1,114,432$1,316,791$1,278,624$1,613,454$1,700,122$741,905$1,115,355$198,913$1,222
<br />,925
<br />5-Year Funding Status111%10-Year Funding Status102%Long-Term Funding Status102%
<br />5-Year Funding Sources (Rev + Beg Cash Balance)##########10-Year Funding Sources (Rev + Beg Cash Balance)$40,610,594Long-Term Funding Sources (Rev + Beg Cash Balance)$77,122,625
<br />5-Year10-Year20-Year
<br />Fee-SupportedFundingFundingFunding
<br />Summary of Fee-Supported Capital Funds
<br />Capital Replacement FundStatusStatusStatus
<br /> $6
<br />Millions
<br />Communications611%125%75%
<br />License Center587%115%133%
<br /> $5
<br />Community Development2287%1033%683%
<br />Water106%108%98%
<br /> $4
<br />Sanitary Sewer87%96%108%
<br /> $3
<br />Storm Sewer96%92%92%
<br />Golf Course87%23%16%
<br /> $2
<br />All Fee-Supported Capital Fund111%102%102%
<br /> $1
<br />$ Surplus (Deficit)$2,207,939$972,494$1,222,925
<br /> $-
<br />2018202120242027203020332036
<br />RevenuesExpendituresEnding Cash Balance
<br />
<br />
|