City of Roseville
<br />Pathway & Parking Lot Maintenance Fund (408)
<br />Capital Improvement Plan:
<br />2018-2037
<br />20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />Tax Levy: Current$245,000$245,000$245,000$245,000$245,000$245,000$245,000$245,000$245,000$245,000$245,000$245,000$245,000$245,000$245,000$245,000$245,000$245,000$245,000$245,000
<br />Tax Levy: Add/Sub--------------------
<br />Other--------------------
<br />Sale of Assets--------------------
<br />Interest Earnings-3,560-------------31-2321,136859
<br />Revenues$245,000$248,560$245,000$245,000$245,000$245,000$245,000$245,000$245,000$245,000$245,000$245,000$245,000$245,000$245,000$245,031$245,000$245,232$246,136$245,859$4,905,819
<br />Vehicles$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-
<br />Equipment--------------------
<br />Furniture & Fixtures--------------------
<br />Buildings--------------------
<br />Improvements250,000600,000260,000300,000230,000180,000180,000245,000200,000340,000280,000195,000200,000200,000200,000280,000200,000200,000260,000200,000
<br />Expenditures$250,000$600,000$260,000$300,000$230,000$180,000$180,000$245,000$200,000$340,000$280,000$195,000$200,000$200,000$200,000$280,000$200,000$200,000$260,000$200,000$5,000,000
<br />
<br />Beginning Cash Balance$183,000$178,000$(173,440)$(188,440)$(243,440)$(228,440)$(163,440)$(98,440)$(98,440)$(53,440)$(148,440)$(183,440)$(133,440)$(88,440)$(43,440)$1,560$(33,409)$11,591$56,823$42,959
<br />
<br />Annual Surplus (deficit)(5,000)(351,440)(15,000)(55,000)15,00065,00065,000-45,000(95,000)(35,000)50,00045,00045,00045,000(34,969)45,00045,232(13,864)45,859
<br />Cash Balance$178,000$(173,440)$(188,440)$(243,440)$(228,440)$(163,440)$(98,440)$(98,440)$(53,440)$(148,440)$(183,440)$(133,440)$(88,440)$(43,440)$1,560$(33,409)$11,591$56,823$42,959$88,819
<br />
<br />5-Year Funding Status86%10-Year Funding Status95%Long-Term Funding Status102%
<br />5-Year Funding Sources (Rev + Beg Cash Balance)$1,411,56010-Year Funding Sources (Rev + Beg Cash Balance)$2,636,560Long-Term Funding Sources (Rev + Beg Cash Balance)$5,088,819
<br />Cash Balance (Year-End)$118,0002016
<br />Pathway/Parking Lot Maintenance Fund
<br />Planned CIP Surplus/Deficit65,0002017
<br />Adjust for Delayed CIP Items-2017
<br /> $700,000
<br />Cash Balance (Beg. Year)$183,0002018
<br /> $600,000
<br /> $500,000
<br /> $400,000
<br /> $300,000
<br /> $200,000
<br /> $100,000
<br /> $-
<br />2018202120242027203020332036
<br /> $(100,000)
<br /> $(200,000)
<br /> $(300,000)
<br />RevenuesExpendituresCash Balance
<br />Expenditure Detail
<br />KeyDescription20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />IPathway maintenance$180,000$180,000$180,000$180,000$180,000$180,000$180,000$180,000$180,000$180,000$180,000$180,000$200,000$200,000$200,000$200,000$200,000$200,000$200,000$200,000$3,760,000
<br />
<br />IPathway construction---------------------
<br />IAcorn 2 east lots70,000-------------------70,000
<br />IAcorn west lot---30,000---------------30,000
<br />IArboretum(2001)-------20,000-----------20,000
<br />IAutumn Grove(2016)---------------------
<br />IB-Dale(2016)---------------------
<br />ICentral Park Lexingtion(2008)---------------80,000----80,000
<br />ICentral Park Lions-Victoria(2005)-------20,000------------20,000
<br />ICentral Pk W Victoria(Foundation)-80,000----------------80,000
<br />ICentral Pk EVictoria(Ballfields)201---------------------
<br />ICentral Pk EDale(Soccer Fields)201---------------------
<br />ICity Hall(2004)-400,000-----------------400,000
<br />IEvergreen(2000)-----15,000------------15,000
<br />IFire Station 1 Lexington(2015)-
<br />IFire Station Fairview---------------------
<br />IHoward Johnson(2002)--------25,000----------25,000
<br />IKent St Dog Park(2000)------15,000------------15,000
<br />ILangton Lk S lot off C2+ Soccer Lo---20,000----------------20,000
<br />ILexington Pk off Cty B(1999)---20,000--------------20,000
<br />INature Center-20,000------------------20,000
<br />IOasis Park(2016)---------------------
<br />IPublic Works Yard(2006)------------------60,000-60,000
<br />IOwasso Cherrywood ballfield(2017)---------------------
<br />
<br />
|