|
City of Roseville
<br />Golf Vehicle & Equipment Fund (620)
<br />Capital Improvement Plan:
<br />2018-2037
<br />20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />Tax Levy: current$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-
<br />Tax Levy: Add/Sub--------------------
<br />Other / TBD--------------------
<br />Sale of Assets500500500500500500500500500500500500500500500500500500500500
<br />Interest Earnings3,5683,0491,7801,026197---------------
<br />Revenues$4,068$3,549$2,280$1,526$697$500$500$500$500$500$500$500$500$500$500$500$500$500$500$500$19,620
<br />Vehicles$-$-$-$-$28,000$-$-$-$-$-$-$-$-$-$-$35,000$-$-$-$-
<br />Equipment-47,00035,00043,0005,00013,00058,000-20,0007,00028,00070,00035,000----10,00058,00022,000
<br />Furniture & Fixtures--------------------
<br />Buildings-20,000---505,0005,000---9,00017,0007,000--5,0005,0005,000-10,000
<br />Improvements30,000-5,000-5,000-10,00012,500--20,000-30,00017,500------
<br />Expenditures$30,000$67,000$40,000$43,000$38,000$518,000$73,000$12,500$20,000$7,000$57,000$87,000$72,000$17,500$-$40,000$5,000$15,000$58,000$32,000$1,232,000
<br />Beginning Cash Balance$178,403$152,471$89,020$51,301$9,827$(27,477)$(544,977)$(617,477)$(629,477)$(648,977)$(655,477)$(711,977)$(798,477)$(869,977)$(886,977)$(886,477)$(925,977)$(930,477)$(944,977)$(
<br />1,002,477)
<br />Annual Surplus (deficit)(25,932)(63,451)(37,720)(41,474)(37,303)(517,500)(72,500)(12,000)(19,500)(6,500)(56,500)(86,500)(71,500)(17,000)500(39,500)(4,500)(14,500)(57,500)(31,500)
<br />Cash Balance$152,471$89,020$51,301$9,827$(27,477)$(544,977)$(617,477)$(629,477)$(648,977)$(655,477)$(711,977)$(798,477)$(869,977)$(886,977)$(886,477)$(925,977)$(930,477)$(944,977)$(1,002,477)$(1,033,
<br />977)
<br />5-Year Funding Status87%10-Year Funding Status23%Long-Term Funding Status16%
<br />5-Year Funding Sources (Rev + Beg Cash Balance)$190,52310-Year Funding Sources (Rev + Beg Cash Balance)$193,023Long-Term Funding Sources (Rev + Beg Cash Balance)$198,023
<br />Cash Balance (Year-End) *$268,0002016
<br />Golf Course Capital Replacement Fund
<br />Less Amt Needed for Operations **(70,930)2016
<br /> $600,000
<br />Planned CIP Surplus/Deficit(18,667)2017
<br /> $400,000
<br />Adjust for Delayed CIP Items-2017
<br /> $200,000
<br />Cash Balance (Beg. Year)$178,4032018
<br /> $-
<br />2018202120242027203020332036
<br /> $(200,000)
<br />Adopted Budget (Excl.Capital, Dep$354,6502017
<br /> $(400,000)
<br /> $(600,000)
<br />* Includes SA Receivable
<br /> $(800,000)
<br />** 20% of Annual Budget Needed for Cash-Flow Purposes
<br /> $(1,000,000)
<br /> $(1,200,000)
<br />RevenuesExpendituresCash Balance
<br />Expenditure Detail
<br />KeyDescription20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />VPickup Truck 2012$-$-$-$-$28,000$-$-$-$-$-$-$-$-$-$35,000$-$-$-$-63,000
<br />EGas pump / tank: est: 1967/1997---------------------
<br />E zero turn mower 2008-----13,000-----14,000--------27,000
<br />EFairway mower 2008------58,000-----------58,000-116,000
<br />EGreens Mowers 2000-30,000---------30,000-------60,000
<br />EGreens/Tee Mowers 2002--35,000---------35,000-------70,000
<br />EComputer equipment 2014---7,000-----7,000-------10,000--24,000
<br />ETurf equipment/aerators 2001---21,000-------21,000-------22,00064,000
<br />ECushman #1 & 2 2014 and 1988-17,000--------28,000---------45,000
<br />EGreens covers 1997/replaced 2 -20-------------------
<br />ECourse netting/patio/shelter 1985/1--------20,000-----------20,000
<br />ETop Dresser Tufco 1993---15,000----------------15,000
<br />EOperational power equipment 1980----5,000------5,000--------10,000
<br />BClubhouse kitchen equipment 1970------5,000----5,000----5,000---15,000
<br />BClubhouse upkeep/repairs 1999/2-----5,000----9,000--------10,00024,000
<br />BClubhouse furnace / AC 1999---------------------
<br />BClubhouse roof replace 1988---------------------
<br />BClubhouse /carpeting/flooring 1998-----------12,000--------12,000
<br />BReplace Clubhouse CH 1970est.--------------------
<br />BReplace Shop ----500,000------7,000--5,000----512,000
<br />BShop heating and other/upgrades -20,000---------------5,000--25,000
<br />ISidewalk/exterior repairs 1985----------15,000---------15,000
<br />ICourse improvements, landscaping --5,000-5,000--5,000--5,000--10,000------30,000
<br />IParking lot repairs/sealing 1990/20-------7,500-----7,500------15,000
<br />IIrrigation system upgrades 1960/19 30,000-----10,000-----30,000-------70,000
<br />---------------------
<br />$30,000$67,000$40,000$43,000$38,000$518,000$73,000$12,500$20,000$7,000$57,000$87,000$72,000$17,500$-$40,000$5,000$15,000$58,000$32,000$1,232,000
<br />
|