|
City of Roseville
<br />Capital Improvement Plan: Administration Equipment Fund (405)
<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 Earnings---260465775-----2705758871,1051,4271554587681,083
<br />Revenues$15,000$15,000$15,000$15,260$15,465$15,775$15,000$15,000$15,000$15,000$15,000$15,270$15,575$15,887$16,105$16,427$15,155$15,458$15,768$16,083$308,227
<br />Vehicles$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-
<br />Equipment-----71,00040,000--------80,000----
<br />Furniture & Fixtures---5,000----5,000----5,000------
<br />Buildings--------------------
<br />Improvements--------------------
<br />Expenditures$-$-$-$5,000$-$71,000$40,000$-$5,000$-$-$-$-$5,000$-$80,000$-$-$-$-$206,000
<br />Beginning Cash Balance$(32,000)$(17,000)$(2,000)$13,000$23,260$38,725$(16,500)$(41,500)$(26,500)$(16,500)$(1,500)$13,500$28,770$44,345$55,232$71,337$7,763$22,919$38,377$54,145
<br />Annual Surplus (deficit)15,00015,00015,00010,26015,465(55,225)(25,000)15,00010,00015,00015,00015,27015,57510,88716,105(63,573)15,15515,45815,76816,083
<br />Cash Balance$(17,000)$(2,000)$13,000$23,260$38,725$(16,500)$(41,500)$(26,500)$(16,500)$(1,500)$13,500$28,770$44,345$55,232$71,337$7,763$22,919$38,377$54,145$70,227
<br />5-Year Funding Status875%10-Year Funding Status99%Long-Term Funding Status134%
<br />5-Year Funding Sources (Rev + Beg Cash Balance)$43,72510-Year Funding Sources (Rev + Beg Cash Balance)$119,500Long-Term Funding Sources (Rev + Beg Cash Balance)$276,227
<br />Cash Balance (Year-End)$(47,000)2016
<br />Administration Equipment Fund
<br />Planned CIP Surplus/Deficit15,0002017
<br />Adjust for Delayed CIP Items-2017
<br /> $100,000
<br />Cash Balance (Beg. Year)$(32,000)2018
<br /> $80,000
<br /> $60,000
<br /> $40,000
<br /> $20,000
<br /> $-
<br />2018202120242027203020332036
<br /> $(20,000)
<br /> $(40,000)
<br /> $(60,000)
<br />RevenuesExpendituresCash Balance
<br />Expenditure Detail
<br />KeyDescription20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />EVoting Equipment$-$-$-$-$-$71,000$-$-$-$-$-$-$-$-$-$80,000$-$-$-$-$151,000
<br />EHR Software package------40,000-------------40,000
<br />FAdministration Office Furniture---5,000----5,000----5,000------15,000
<br />---------------------
<br />---------------------
<br />$-$-$-$5,000$-$71,000$40,000$-$5,000$-$-$-$-$5,000$-$80,000$-$-$-$-$206,000
<br />
<br />
|