City of Roseville
<br />Park Improvement Fund (411)
<br />Capital Improvement Plan:
<br />2018-2037
<br />20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />Tax Levy: Current$ 410,000$ 410,000$ 410,000$ 410,000$ 410,000$ 410,000$ 410,000$ 410,000$ 410,000$ 410,000$ 410,000$ 410,000$ 410,000$ 410,000$
<br /> 410,000$ 410,000$ 410,000$ 410,000$ 410,000$ 410,000
<br />Tax Levy: Add/Sub--------------------
<br />Other--------------------
<br />Sale of Assets--------------------
<br />Interest Earnings88013,275------------------
<br />Revenues$ 410,880$ 423,275$ 410,000$ 410,000$ 410,000$ 410,000$ 410,000$ 410,000$ 410,000$ 410,000$ 410,000$ 410,000$ 410,000$ 410,000$
<br /> 410,000$ 410,000$ 410,000$ 410,000$ 410,000$ 410,000
<br />Vehicles$ -$ -$ -$ -$ -$ -$ -$ -$ -$
<br /> -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
<br /> -
<br />Equipment--------------------
<br />Furniture & Fixtures--------------------
<br />Buildings--------------------
<br />Improvements300,0001,185,880765,000780,000638,0001,661,500520,000539,070830,000720,000640,000488,5001,042,500516,670728,000677,5001,010,0001,145,000955,000365,000
<br />Expenditures$ 300,000$ 1,185,880$ 765,000$ 780,000$ 638,000$ 1,661,500$ 520,000$ 539,070$ 830,000$ 720,000$ 640,000$ 488,500$ 1,042,500$ 516,670$
<br /> 728,000$ 677,500$ 1,010,000$ 1,145,000$ 955,000$ 365,000
<br />Beginning Cash Balance$ 552,880$ 663,760$ (98,845)$ (453,845)$ (823,845)$(1,051,845)$(2,303,345)$(2,413,345)$(2,542,415)$(2,962,415)$(3,272,415)$(3,502,415)$(3,580,915)$
<br /> (4,213,415)$ (4,320,085)$ (4,638,085)$ (4,905,585)$ (5,505,585)$ (6,240,585)$ (6,785,585)
<br />Annual Surplus (deficit)110,880(762,605)(355,000)(370,000)(228,000)(1,251,500)(110,000)(129,070)(420,000)(310,000)(230,000)(78,500)(632,500)(106,670)(318,000)(267,500)(600,000)(735,000)(545,000)45,00
<br />0
<br />Cash Balance$ 663,760$ (98,845)$ (453,845)$ (823,845)$(1,051,845)$(2,303,345)$(2,413,345)$(2,542,415)$(2,962,415)$(3,272,415)$(3,502,415)$(3,580,915)$(4,213,415)$ (4,320,085)$
<br /> (4,638,085)$ (4,905,585)$ (5,505,585)$ (6,240,585)$ (6,785,585)$ (6,740,585)
<br />5-Year Funding Status71%10-Year Funding Status59%Long-Term Funding Status57%
<br />5-Year Funding Sources (Rev + Beg Cash Balance)$ 2,617,03510-Year Funding Sources (Rev + Beg Cash Balance)$ 4,667,035Long-Term Funding Sources (Rev + Beg Cash Balance)$ 8,767,035
<br />Cash Balance (Year-End)$ 552,0002016
<br />Park Improvement Fund
<br />Planned CIP Surplus/Deficit8802017
<br />Adjust for Delayed CIP Items-2017
<br /> $3,000,000
<br />Cash Balance (Beg. Year)$ 552,8802018
<br /> $2,000,000
<br /> $1,000,000
<br /> $-
<br /> $(1,000,000)
<br />2018202120242027203020332036
<br /> $(2,000,000)
<br /> $(3,000,000)
<br /> $(4,000,000)
<br /> $(5,000,000)
<br /> $(6,000,000)
<br /> $(7,000,000)
<br /> $(8,000,000)
<br />RevenuesExpendituresCash Balance
<br />Expenditure Breakdown
<br />KeyDescription20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />ITennis & Basketball Courts$ -$ 175,000$ 20,000$ 135,000$ 10,000$ -$ -$ -$ 400,000$ 125,000$ 275,000$
<br /> -$ -$ 125,000$ 145,000$ 185,000$ 75,000$ 75,000$ -$ -
<br />IShelters & Structures60,0005,00050,000-25,000510,00075,00034,070---10,00042,500-35,00027,50010,000-100,000-
<br />IPlayground Areas-600,000275,000125,000250,000150,000---225,000----125,000-400,000600,000450,000-
<br />IVolleyball & Bocce Ball Courts-----20,00010,000-------------
<br />IAthletic Fields-5,00075,000200,00033,000311,500115,000185,000110,00050,00045,0005,000180,00025,00078,000145,00070,000110,00060,00045,000
<br />IIrrigation Systems--25,000-----------------
<br />IBridges & Boardwalks-----------150,000500,00040,000--40,00040,000--
<br />IOther Capital Items-130,880---350,000-----3,500-6,67025,000-95,000-25,000-
<br />INatural Resources40,00070,000120,000120,000120,000120,000120,000120,000120,000120,000120,000120,000120,000120,000120,000120,000120,000120,000120,000120,000
<br />IPIP/CIP Category 200,000200,000200,000200,000200,000200,000200,000200,000200,000200,000200,000200,000200,000200,000200,000200,000200,000200,000200,000200,000
<br />--------------------
<br />$ 300,000$ 1,185,880$ 765,000$ 780,000$ 638,000$ 1,661,500$ 520,000$ 539,070$ 830,000$ 720,000$ 640,000$ 488,500$ 1,042,500$ 516,670$ 728,000$
<br /> 677,500$ 1,010,000$ 1,145,000$ 955,000$ 365,000
<br />
<br />
|