City of Roseville
<br />Community Development Vehicle & Equipment Fund (260)
<br />Capital Improvement Plan:
<br />2018-2037
<br />20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />Tax Levy: current$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-
<br />Tax Levy: Add/Sub--------------------
<br />Fees, Licenses, & Permits--------------------
<br />Sale of Assets--------------------
<br />Interest Earnings35,54735,80736,03836,25236,88737,44538,08838,30438,52038,63038,81739,48740,18740,81140,98141,13541,28741,33342,05442,809
<br />Revenues$35,547$35,807$36,038$36,252$36,887$37,445$38,088$38,304$38,520$38,630$38,817$39,487$40,187$40,811$40,981$41,135$41,287$41,333$42,054$42,809$780,418
<br />Vehicles$19,000$19,000$20,000$-$-$-$22,000$23,000$24,000$24,000$-$-$-$27,000$28,000$29,000$30,000$-$-$-
<br />Equipment2,5004,3004,3003,5008,0004,3004,3003,5008,0004,3004,3003,5008,0004,3004,3003,5008,0004,3004,300-
<br />Furniture & Fixtures1,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,000--
<br />Buildings--------------------
<br />Improvements--------------------
<br />Expenditures$22,500$24,300$25,300$4,500$9,000$5,300$27,300$27,500$33,000$29,300$5,300$4,500$9,000$32,300$33,300$33,500$39,000$5,300$4,300$-$374,500
<br />Beginning Cash Balance$1,777,326$1,790,372$1,801,879$1,812,617$1,844,369$1,872,257$1,904,402$1,915,190$1,925,994$1,931,514$1,940,844$1,974,361$2,009,348$2,040,535$2,049,046$2,056,727$2,064,361$2,066,
<br />648$2,102,681$2,140,435
<br />Annual Surplus (deficit)13,04711,50710,73831,75227,88732,14510,78810,8045,5209,33033,51734,98731,1878,5117,6817,6352,28736,03337,75442,809
<br />Cash Balance$1,790,372$1,801,879$1,812,617$1,844,369$1,872,257$1,904,402$1,915,190$1,925,994$1,931,514$1,940,844$1,974,361$2,009,348$2,040,535$2,049,046$2,056,727$2,064,361$2,066,648$2,102,681$2,140,
<br />435$2,183,244
<br />5-Year Funding Status2287%10-Year Funding Status1033%Long-Term Funding Status683%
<br />5-Year Funding Sources (Rev + Beg Cash Balance)$1,957,85710-Year Funding Sources (Rev + Beg Cash Balance)$2,148,844Long-Term Funding Sources (Rev + Beg Cash Balance)$2,557,744
<br />Cash Balance (Year-End) *$2,212,0002016
<br />Community Development Vehicle &
<br />Less Amt Needed for Operations **(394,748)2017
<br />Equipment Fund
<br />Planned CIP Surplus/Deficit(39,927)2017
<br /> $2,500,000
<br />Adjust for Delayed CIP Items-2017
<br />Cash Balance (Beg. Year)$1,777,3262018
<br /> $2,000,000
<br />Adopted Budget (Excl.Capital)$1,578,9902017
<br /> $1,500,000
<br />* Current Assets - Current Liabilities
<br /> $1,000,000
<br />** 25% of Annual Budget Needed for Cash-Flow Purposes
<br /> $500,000
<br /> $-
<br />2018202120242027203020332036
<br />RevenuesExpendituresCash Balance
<br />Expenditure Detail
<br />KeyDescription20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />VInspection vehicles$19,000$19,000$20,000$-$-$-$22,000$23,000$24,000$24,000$-$-$-$27,000$28,000$29,000$30,000---$265,000
<br />EComputers/monitors2,5004,3004,3003,5008,0004,3004,3003,5008,0004,3004,3003,5008,0004,3004,3003,5008,0004,3004,300-91,500
<br />EPermit Database conversion---------------------
<br />EOnline Permit/Schedul. Software---------------------
<br />FOffice furniture1,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,000--18,000
<br />---------------------
<br />$22,500$24,300$25,300$4,500$9,000$5,300$27,300$27,500$33,000$29,300$5,300$4,500$9,000$32,300$33,300$33,500$39,000$5,300$4,300$-$374,500
<br />
<br />
|