City of Roseville
<br />Communications Equipment Fund (110)
<br />Capital Improvement Plan:
<br />2018-2037
<br />20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />Tax Levy: current$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-
<br />Tax Levy: Add/Sub--------------------
<br />Fees, Licenses, & Permits5,0005,0005,0005,0005,0005,0005,0005,0005,0005,0005,0005,0005,0005,0005,0005,0005,0005,0005,0005,000
<br />Sale of Assets--------------------
<br />Interest Earnings4,0404,0214,1014,1534,2564,1412,7942,9201,3191,2451,1301,0521,0731,0651,106928----
<br />Revenues$9,040$9,021$9,101$9,153$9,256$9,141$7,794$7,920$6,319$6,245$6,130$6,052$6,073$6,065$6,106$5,928$5,000$5,000$5,000$5,000$139,346
<br />Vehicles$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-
<br />Equipment10,0005,0006,5004,00015,00076,5001,50088,00010,00012,00010,0005,0006,5004,00015,00076,5001,50088,00010,00012,000
<br />Furniture & Fixtures--------------------
<br />Buildings--------------------
<br />Improvements--------------------
<br />Expenditures$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$457,000
<br />Beginning Cash Balance$202,000$201,040$205,061$207,662$212,816$207,072$139,713$146,008$65,928$62,246$56,491$52,621$53,673$53,247$55,312$46,418$(24,154)$(20,654)$(103,654)$(108,654)
<br />Annual Surplus (deficit)(960)4,0212,6015,153(5,744)(67,359)6,294(80,080)(3,681)(5,755)(3,870)1,052(427)2,065(8,894)(70,572)3,500(83,000)(5,000)(7,000)
<br />Cash Balance$201,040$205,061$207,662$212,816$207,072$139,713$146,008$65,928$62,246$56,491$52,621$53,673$53,247$55,312$46,418$(24,154)$(20,654)$(103,654)$(108,654)$(115,654)
<br />5-Year Funding Status611%10-Year Funding Status125%Long-Term Funding Status75%
<br />5-Year Funding Sources (Rev + Beg Cash Balance)$247,57210-Year Funding Sources (Rev + Beg Cash Balance)$284,991Long-Term Funding Sources (Rev + Beg Cash Balance)$341,346
<br />Cash Balance (Year-End) *$335,0002016
<br />Communications Equipment Fund
<br />Less Amt Needed for Operations **(128,269)2017
<br />Planned CIP Surplus/Deficit(4,731)2017
<br /> $250,000
<br />Adjust for Delayed CIP Items-2017
<br /> $200,000
<br />Cash Balance (Beg. Year)$202,0002018
<br /> $150,000
<br />Adopted Budget (Excl.Capital, Depr$513,0752017
<br /> $100,000
<br /> $50,000
<br />* Current Assets - Current Liabilities
<br /> $-
<br />** 25% of Annual Budget Needed for Cash-Flow Purposes
<br />2018202120242027203020332036
<br /> $(50,000)
<br /> $(100,000)
<br /> $(150,000)
<br />RevenuesExpendituresCash Balance
<br />Expenditure Detail
<br />KeyDescription20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />EConference Room Equipment$-$-$1,500$-$-$-$1,500$-$-$-$-$1,500$-$-$-$-$1,500$-$-$6,000
<br />ECouncil camera replacement-------85,000---------85,000--170,000
<br />ECouncil Control/Sound System-----75,000---------75,000----150,000
<br />EGeneral Audio/Visual Equip. **10,0005,0005,0004,00015,0001,5001,5001,50010,00012,00010,0005,0005,0004,00015,0001,5001,5001,50010,00012,000131,000
<br />---------------------
<br />$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$457,000
<br />
<br />
|