|
City of Roseville
<br />Central Services Equipment Fund (409)
<br />Capital Improvement Plan:
<br />2018-2037
<br />20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />Tax Levy: Current$75,000$75,000$75,000$75,000$75,000$75,000$75,000$75,000$75,000$75,000$75,000$75,000$75,000$75,000$75,000$75,000$75,000$75,000$75,000$75,000
<br />Tax Levy: Add/Sub--------------------
<br />Other--------------------
<br />Sale of Assets--------------------
<br />Interest Earnings1,9601,8591,7561,6521,5451,4351,3241,2111,09597785673360848035021781---
<br />Revenues$76,960$76,859$76,756$76,652$76,545$76,435$76,324$76,211$76,095$75,977$75,856$75,733$75,608$75,480$75,350$75,217$75,081$75,000$75,000$75,000$1,518,140
<br />Vehicles$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-
<br />Equipment82,00082,00082,00082,00082,00082,00082,00082,00082,00082,00082,00082,00082,00082,00082,00082,00082,00082,00082,00082,000
<br />Furniture & Fixtures--------------------
<br />Buildings--------------------
<br />Improvements--------------------
<br />Expenditures$82,000$82,000$82,000$82,000$82,000$82,000$82,000$82,000$82,000$82,000$82,000$82,000$82,000$82,000$82,000$82,000$82,000$82,000$82,000$82,000$1,640,000
<br />Beginning Cash Balance$98,003$92,963$87,822$82,579$77,230$71,775$66,210$60,535$54,745$48,840$42,817$36,673$30,407$24,015$17,495$10,845$4,062$(2,857)$(9,857)$(16,857)
<br />Annual Surplus (deficit)(5,040)(5,141)(5,244)(5,348)(5,455)(5,565)(5,676)(5,789)(5,905)(6,023)(6,144)(6,267)(6,392)(6,520)(6,650)(6,783)(6,919)(7,000)(7,000)(7,000)
<br />Cash Balance$92,963$87,822$82,579$77,230$71,775$66,210$60,535$54,745$48,840$42,817$36,673$30,407$24,015$17,495$10,845$4,062$(2,857)$(9,857)$(16,857)$(23,857)
<br />5-Year Funding Status118%10-Year Funding Status105%Long-Term Funding Status99%
<br />5-Year Funding Sources (Rev + Beg Cash Balance)$481,77510-Year Funding Sources (Rev + Beg Cash Balance)$862,817Long-Term Funding Sources (Rev + Beg Cash Balance)$1,616,143
<br />Cash Balance (Year-End)$99,0002016
<br />Central Services Equipment Fund
<br />Planned CIP Surplus/Deficit(997)2017
<br />Adjust for Delayed CIP Items-2017
<br /> $100,000
<br />Cash Balance (Beg. Year)$98,0032018
<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 />EPostage Machine Lease$4,000$4,000$4,000$4,000$4,000$4,000$4,000$4,000$4,000$4,000$4,000$4,000$4,000$4,000$4,000$4,000$4,000$4,000$4,000$4,000$80,000
<br />ECopier/Printer/Scanner Lease78,00078,00078,00078,00078,00078,00078,00078,00078,00078,00078,00078,00078,00078,00078,00078,00078,00078,00078,00078,0001,560,000
<br />---------------------
<br />---------------------
<br />---------------------
<br />$82,000$82,000$82,000$82,000$82,000$82,000$82,000$82,000$82,000$82,000$82,000$82,000$82,000$82,000$82,000$82,000$82,000$82,000$82,000$82,000$1,640,000
<br />
<br />
|