|
City of Roseville
<br />Updated 5/15/17
<br />Summary of Tax-Supported Capital Funds
<br />Capital Improvement Plan:
<br />2018-2037
<br />20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />Tax Levy: Current$3,120,000$3,120,000$3,120,000$3,120,000$3,120,000$3,120,000$3,120,000$3,120,000$3,120,000$3,120,000$3,120,000$3,120,000$3,120,000$3,120,000$3,120,000$3,120,000$3,120,000$3,120,000$3
<br />,120,000$3,120,000
<br />Tax Levy: Add/Sub--------------------
<br />Other (MSA, Assessments)1,110,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,10
<br />0,000
<br />Sale of Assets24,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,000
<br />Interest Earnings259,115275,382250,843227,203204,120198,962188,730183,375165,744162,195149,129136,972129,06088,40177,79963,49859,92068,83849,91653,324
<br />Revenues$4,513,115$4,519,382$4,494,843$4,471,203$4,448,120$4,442,962$4,432,730$4,427,375$4,409,744$4,406,195$4,393,129$4,380,972$4,373,060$4,332,401$4,321,799$4,307,498$4,303,920$4,312,838$4,293,916$
<br />4,297,324$87,882,525
<br />Administration$-$-$-$5,000$-$71,000$40,000$-$5,000$-$-$-$-$5,000$-$80,000$-$-$-$-
<br />Finance80,000--20,000---80,000----80,00020,000---80,000--
<br />Central Services82,00082,00082,00082,00082,00082,00082,00082,00082,00082,00082,00082,00082,00082,00082,00082,00082,00082,00082,00082,000
<br />Police304,425278,010510,270313,015318,250371,425300,925455,630312,175320,965280,790351,480495,745329,285336,640289,205287,790507,880275,705340,985
<br />Fire146,500221,900740,5001,125,000124,500182,400182,000701,500149,000356,400103,00057,500948,500183,900182,00095,000119,000955,000345,00054,000
<br />Public Works130,500276,500113,500426,000420,000235,000136,000255,50095,000361,600478,100153,000165,500259,000210,000406,000349,500493,000420,00079,500
<br />Parks & Recreation176,000157,500223,000123,00055,000273,000231,000148,00038,000153,000178,000285,500186,00058,000171,000253,0003,000148,00043,00017,000
<br />General Facility Improvements384,000853,4003,183,000340,000760,0001,320,300259,000406,50067,00049,400405,500448,50060,5001,171,900401,000237,800404,000366,500398,00068,000
<br />Information Technology254,880133,430176,980135,330290,280235,230257,530102,730167,58094,530181,580146,130662,230154,330120,780187,230205,180248,130165,230117,830
<br />Park Improvements300,0001,185,880765,000780,000638,0001,661,500520,000539,070830,000720,000640,000488,5001,042,500516,670728,000677,5001,010,0001,145,000955,000365,000
<br />Street Improvements2,200,0002,200,0002,300,0002,300,0002,300,0002,400,0002,400,0002,400,0002,600,0002,600,0002,600,0002,600,0002,700,0002,700,0002,800,0002,800,0002,800,0002,800,0003,000,0003,000,000
<br />
<br />Street Lighting45,000-65,00020,00040,00045,00020,000-45,000-20,00025,00020,000-45,00020,00020,00025,00020,000-
<br />Pathways (Existing)250,000600,000260,000300,000230,000180,000180,000245,000200,000340,000280,000195,000200,000200,000200,000280,000200,000200,000260,000200,000
<br />--------------------
<br />Expenditures$4,353,305$5,988,620$8,419,250$5,969,345$5,258,030$7,056,855$4,608,455$5,415,930$4,590,755$5,077,895$5,248,970$4,832,610$6,642,975$5,680,085$5,276,420$5,407,735$5,480,470$7,050,510$5,963,
<br />935$4,324,315$112,646,465
<br />Beginning Cash Balance####################$12,267,494$8,343,087$6,844,945$6,035,035$3,421,141$3,245,416$2,256,861$2,075,850$1,404,151$548,310$96,672$(2,173,243)$(3,520,927)$(4,475,548)$(5,575,785)$(6
<br />,752,335)$(9,490,008)$(11,160,027)
<br />Annual Surplus (deficit)159,810(1,469,238)(3,924,407)(1,498,142)(809,910)(2,613,893)(175,725)(988,555)(181,011)(671,700)(855,841)(451,638)(2,269,915)(1,347,684)(954,621)(1,100,237)(1,176,550)(2,737,6
<br />72)(1,670,019)(26,991)
<br />Ending Cash Balance####################$8,343,087$6,844,945$6,035,035$3,421,141$3,245,416$2,256,861$2,075,850$1,404,151$548,310$96,672$(2,173,243)$(3,520,927)$(4,475,548)$(5,575,785)$(6,752,335)$(9,4
<br />90,008)$(11,160,027)$(11,187,018)
<br />5-Year Funding Status120%10-Year Funding Status102%Long-Term Funding Status90%
<br />5-Year Funding Sources (Rev + Beg Cash Balance)##########10-Year Funding Sources (Rev + Beg Cash Balance)$58,142,591Long-Term Funding Sources (Rev + Beg Cash Balance)$101,459,447
<br />5-Year5-Year10-Year20-Year
<br />Tax-SupportedFundingSurplusFundingFunding
<br />Summary of Tax-Supported Capital Funds
<br />Capital Replacement FundStatus(Deficit)StatusStatus
<br />Administration875%$38,72599%134%
<br /> $15
<br />Finance125%25,124113%99%
<br />Millions
<br /> $10
<br />Central Services118%71,775105%99%
<br />Police122%373,906108%101%
<br /> $5
<br />Fire113%312,233112%113%
<br />Public Works138%518,907127%102%
<br /> $-
<br />Parks & Recreation144%322,451138%155%
<br />2018202120242027203020332036
<br /> $(5)
<br />General Facility Improvements52%(2,632,760)65%79%
<br />Information Technology148%472,181136%114%
<br /> $(10)
<br />Park Improvements71%(1,051,845)59%57%
<br />Street Improvements169%7,785,408120%89%
<br /> $(15)
<br />Street Lighting116%27,368108%109%
<br />RevenuesExpendituresEnding Cash Balance
<br />Pathways/Parking Lots (Existin86%(228,440)95%102%
<br />All Tax-Supported Capital Fund120%$6,035,035102%90%
<br />$ Surplus (Deficit)$6,035,035$1,404,151###########
<br />Revised
<br />5-Year
<br />Tax-SupportedFunding
<br />Capital Replacement FundStatus
<br />Administration875%
<br />Finance125%
<br />Central Services118%
<br />Police122%
<br />Fire113%
<br />Public Works138%
<br />Parks & Recreation144%
<br />General Facility Improvements114%
<br />Information Technology148%
<br />Park Improvements124%
<br />Street Improvements183%
<br />Street Lighting116%
<br />Pathways (Existing)86%
<br />
<br />
|