|
City of Roseville
<br />Finance Equipment Fund (404)
<br />Capital Improvement Plan:
<br />2018-2037
<br />20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />Tax Levy: Current$15,000$15,000$15,000$15,000$15,000$15,000$15,000$15,000$15,000$15,000$15,000$15,000$15,000$15,000$15,000$15,000$15,000$15,000$15,000$15,000
<br />Tax Levy: Add/Sub--------------------
<br />Other--------------------
<br />Sale of Assets--------------------
<br />Interest Earnings973--2931995028131,129-1514547631,079--0300606--
<br />Revenues$15,973$15,000$15,000$15,293$15,199$15,502$15,813$16,129$15,000$15,151$15,454$15,763$16,079$15,000$15,000$15,000$15,300$15,606$15,000$15,000$307,263
<br />Vehicles$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-
<br />Equipment80,000--20,000---80,000----80,00020,000---80,000--
<br />Furniture & Fixtures--------------------
<br />Buildings--------------------
<br />Improvements--------------------
<br />Expenditures$80,000$-$-$20,000$-$-$-$80,000$-$-$-$-$80,000$20,000$-$-$-$80,000$-$-$360,000
<br />Beginning Cash Balance$48,660$(15,367)$(367)$14,633$9,926$25,124$40,627$56,439$(7,432)$7,568$22,720$38,174$53,937$(9,984)$(14,984)$16$15,017$30,317$(34,077)$(19,077)
<br />Annual Surplus (deficit)(64,027)15,00015,000(4,707)15,19915,50215,813(63,871)15,00015,15115,45415,763(63,921)(5,000)15,00015,00015,300(64,394)15,00015,000
<br />Cash Balance$(15,367)$(367)$14,633$9,926$25,124$40,627$56,439$(7,432)$7,568$22,720$38,174$53,937$(9,984)$(14,984)$16$15,017$30,317$(34,077)$(19,077)$(4,077)
<br />5-Year Funding Status125%10-Year Funding Status113%Long-Term Funding Status99%
<br />5-Year Funding Sources (Rev + Beg Cash Balance)$125,12410-Year Funding Sources (Rev + Beg Cash Balance)$202,720Long-Term Funding Sources (Rev + Beg Cash Balance)$355,923
<br />Cash Balance (Year-End)$33,0002016
<br />Finance Equipment Fund
<br />Planned CIP Surplus/Deficit(4,340)2017
<br />Adjust for Delayed CIP Items20,0002017
<br /> $100,000
<br />Cash Balance (Beg. Year)$48,6602018
<br /> $80,000
<br /> $60,000
<br /> $40,000
<br /> $20,000
<br /> $-
<br />2018202120242027203020332036
<br /> $(20,000)
<br /> $(40,000)
<br />RevenuesExpendituresCash Balance
<br />Expenditure Detail
<br />KeyDescription20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />EFinancial Software: Upgrade$80,000$-$-$-$-$-$-$80,000$-$-$-$-$80,000$-$-$-$-$80,000$-$-$320,000
<br />EInvestment & Debt Mgmt. Software---20,000---------20,000------40,000
<br />---------------------
<br />---------------------
<br />---------------------
<br />$80,000$-$-$20,000$-$-$-$80,000$-$-$-$-$80,000$20,000$-$-$-$80,000$-$-$360,000
<br />
<br />
|