|
City of Roseville
<br />General Facilities Replacement Fund (410)
<br />Capital Improvement Plan:
<br />2018-2037
<br />20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />BCampus loop pump------------------10,000-
<br />BFluid cooler fan-----2,000--------------
<br />BHeat zone pumps (6)-----3,600--------------
<br />BConcrete Exterior------50,000-------------
<br />BExterior Lighting-----15,000--------------
<br />BInterior Lighting-----15,000--------------
<br />BParking Lot----------50,000---------
<br />BAir Monitoring Sensors-9,000----9,000----9,000----9,000---
<br />--------------------
<br />$ 384,000$ 853,400$ 3,183,000$ 340,000$ 760,000$ 1,320,300$ 259,000$ 406,500$ 67,000$ 49,400$ 405,500$ 448,500$ 60,500$ 1,171,900$ 401,000$
<br /> 237,800$ 404,000$ 366,500$ 398,000$ 68,000
<br />City Hall & PW Building, Community Gyms
<br />Skating Center
<br />Fire Station
<br />2.0%= Projected interest earnings rate
<br />Revised Funding Summary
<br />20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />Tax Levy: Current$ 421,000$ 421,000$ 421,000$ 421,000$ 421,000$ 421,000$ 421,000$ 421,000$ 421,000$ 421,000$ 421,000$ 421,000$ 421,000$ 421,000$
<br /> 421,000$ 421,000$ 421,000$ 421,000$ 421,000$ 421,000
<br />Tax Levy: Add/Sub (see below)-355,000355,000355,000355,000355,000355,000355,000355,000355,000355,000355,000355,000355,000355,000355,000355,000355,000355,000355,000
<br />Other: (see below)--2,000,000-----------------
<br />Sale of Assets--------------------
<br />Interest Earnings14,88515,9227,593-----------------
<br />Revenues$ 435,885$ 791,922$ 2,783,593$ 776,000$ 776,000$ 776,000$ 776,000$ 776,000$ 776,000$ 776,000$ 776,000$ 776,000$ 776,000$ 776,000$ 776,000$
<br /> 776,000$ 776,000$ 776,000$ 776,000$ 776,000
<br />Vehicles$ -$ -$ -$ -$ -$ -$ -$ -$ -$
<br /> -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
<br /> -
<br />Equipment--------------------
<br />Furniture & Fixtures--------------------
<br />Buildings384,000853,4003,183,000340,000760,0001,320,300259,000406,50067,00049,400405,500448,50060,5001,171,900401,000237,800404,000366,500398,00068,000
<br />Improvements--------------------
<br />Expenditures$ 384,000$ 853,400$ 3,183,000$ 340,000$ 760,000$ 1,320,300$ 259,000$ 406,500$ 67,000$ 49,400$ 405,500$ 448,500$ 60,500$ 1,171,900$
<br /> 401,000$ 237,800$ 404,000$ 366,500$ 398,000$ 68,000
<br />Beginning Cash Balance$ 744,240$ 796,125$ 734,647$ 335,240$ 771,240$ 787,240$ 242,940$ 759,940$ 1,129,440$ 1,838,440$ 2,565,040$ 2,935,540$ 3,263,040$ 3,978,540$
<br />3,582,640$ 3,957,640$ 4,495,840$ 4,867,840$ 5,277,340$ 5,655,340
<br />Annual Surplus (deficit)51,885(61,478)(399,407)436,00016,000(544,300)517,000369,500709,000726,600370,500327,500715,500(395,900)375,000538,200372,000409,500378,000708,000
<br />Cash Balance$ 796,125$ 734,647$ 335,240$ 771,240$ 787,240$ 242,940$ 759,940$ 1,129,440$ 1,838,440$ 2,565,040$ 2,935,540$ 3,263,040$ 3,978,540$ 3,582,640$ 3,957,640$
<br />4,495,840$ 4,867,840$ 5,277,340$ 5,655,340$ 6,363,340
<br />5-Year Funding Status114%10-Year Funding Status134%
<br />5-Year Funding Sources (Rev + Beg Cash Balance)$ 6,307,64010-Year Funding Sources (Rev + Beg Cash Balance)##########Long-Term Funding Status155%
<br />Long-Term Funding Sources (Rev + Beg Cash Balance)$17,947,640
<br />New Levy in lieu of PMP (2018)-
<br />General Facilities Replacement Fund -Revised
<br />Re-allocate from PR Fund (2019)25,000
<br />Re-Purpose Arena Debt Levy (2019355,000
<br /> $7,000,000
<br />State Bonding Money (2020)2,000,000
<br /> $6,000,000
<br /> $5,000,000
<br /> $4,000,000
<br /> $3,000,000
<br /> $2,000,000
<br /> $1,000,000
<br /> $-
<br />2018202120242027203020332036
<br />RevenuesExpendituresCash Balance
<br />
<br />
|