|
City of Roseville
<br />General Facilities Replacement Fund (410)
<br />Capital Improvement Plan:
<br />2018-2037
<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 (a)--------------------
<br />Other--------------------
<br />Sale of Assets--------------------
<br />Interest Earnings14,88515,9227,593-----------------
<br />Revenues$ 435,885$ 436,922$ 428,593$ 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
<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$ 379,647$(2,374,760)$(2,293,760)$(2,632,760)$(3,532,060)$(3,370,060)$(3,355,560)$(3,001,560)$(2,629,960)$(2,614,460)$(2,641,960)$(2,281,460)$(3,032,360
<br />)$(3,012,360)$(2,829,160)$(2,812,160)$(2,757,660)$(2,734,660)
<br />Annual Surplus (deficit)51,885(416,478)(2,754,407)81,000(339,000)(899,300)162,00014,500354,000371,60015,500(27,500)360,500(750,900)20,000183,20017,00054,50023,000353,000
<br />Cash Balance$ 796,125$ 379,647$(2,374,760)$(2,293,760)$(2,632,760)$(3,532,060)$(3,370,060)$(3,355,560)$(3,001,560)$(2,629,960)$(2,614,460)$(2,641,960)$(2,281,460)$(3,032,360)$(3,012,360)$(2,829,1
<br />60)$(2,812,160)$(2,757,660)$(2,734,660)$(2,381,660)
<br />5-Year Funding Status52%10-Year Funding Status65%Long-Term Funding Status79%
<br />5-Year Funding Sources (Rev + Beg Cash Balance)$ 2,887,64010-Year Funding Sources (Rev + Beg Cash Balance)$ 4,992,640Long-Term Funding Sources (Rev + Beg Cash Balance)$ 9,202,640
<br />Cash Balance (Year-End)$ 200,0002016
<br />General Facilities Replacement Fund
<br />Planned CIP Surplus/Deficit544,2402017
<br />Adjust for Delayed CIP Items-2017
<br /> $4,000,000
<br />Cash Balance (Beg. Year)$ 744,2402018
<br /> $3,000,000
<br /> $2,000,000
<br />(a) $160K in 2018, $30K, $25K from PR Fund in 2019
<br /> $1,000,000
<br /> $-
<br />2018202120242027203020332036
<br /> $(1,000,000)
<br /> $(2,000,000)
<br /> $(3,000,000)
<br /> $(4,000,000)
<br />RevenuesExpendituresCash Balance
<br />Expenditure Detail
<br />KeyDescription20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />BReplace Rooftop Heat/AC$ -$ -$ -$ -$ -$ 275,000$ -$ -$ -$
<br /> -$ -$ -$ -$ 290,000$ -$ -$ -$ -$ -
<br />BReplace garage Co Ra Vac Heaters--60,000--------------60,000--
<br />BDoor Card Reader25,000------------25,000------
<br />BHeating boilers Police------70,000------70,500------
<br />BLiebert condensing unit (IT Server R--60,000-------------60,000---
<br />BLiebert AHV (IT Server Room)--30,000-------------30,000---
<br />BMake Up Air Units (Maintenance G-90,000--35,000------35,000------35,000-
<br />BCirculating pumps---15,000--------15,500-------
<br />BWater heaters (CH and Maintenanc----25,000--------------25,000
<br />BReplace boiler City Hall-----------------60,000--
<br />BPolice & PW garage Co2/No2 detec----10,000----10,000------10,000---
<br />BExhaust fans (10)--30,000----------25,000------
<br />BUnit heaters (4)6,000----------6,500--------
<br />BVAV's heat/cool---10,000----25,000------25,000----
<br />BVAV/s cool---10,000----25,000------25,000----
<br />BUpdate Flooring CH/PD----------100,000--50,000------
<br />BUpdate Restrooms CH-----------------100,000-
<br />
<br />
|