|
City of Roseville
<br />Parks & Recreation Vehicle & Equipment Fund (402)
<br />Capital Improvement Plan:
<br />2018-2037
<br />20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />Tax Levy: Current$218,000$218,000$218,000$218,000$218,000$218,000$218,000$218,000$218,000$218,000$218,000$218,000$218,000$218,000$218,000$218,000$218,000$218,000$218,000$218,000
<br />Tax Levy: Add/Sub (to Gen Fac.)
<br />--------------------
<br />Other--------------------
<br />Sale of Assets--------------------
<br />Interest Earnings-661,2771,2023,1266,4495,4785,3286,83410,57112,08213,12412,03612,91716,37517,64317,29621,94223,78127,756
<br />Revenues$218,000$218,066$219,277$219,202$221,126$224,449$223,478$223,328$224,834$228,571$230,082$231,124$230,036$230,917$234,375$235,643$235,296$239,942$241,781$245,756$4,575,283
<br />Vehicles$96,000$157,500$73,000$123,000$32,000$68,000$136,000$3,000$3,000$3,000$98,000$277,500$33,000$43,000$151,000$28,000$3,000$3,000$43,000$17,000
<br />Equipment80,000-150,000-23,000205,00095,000145,00035,000150,00080,0008,000153,00015,00020,000225,000-145,000--
<br />Furniture & Fixtures--------------------
<br />Buildings--------------------
<br />Improvements--------------------
<br />Expenditures$176,000$157,500$223,000$123,000$55,000$273,000$231,000$148,000$38,000$153,000$178,000$285,500$186,000$58,000$171,000$253,000$3,000$148,000$43,000$17,000$2,920,000
<br />Beginning Cash Balance$(38,720)$3,280$63,846$60,123$156,325$322,451$273,900$266,379$341,706$528,540$604,111$656,193$601,817$645,853$818,770$882,146$864,789$1,097,085$1,189,026$1,387,807
<br />
<br />Annual Surplus (deficit)42,00060,566(3,723)96,202166,126(48,551)(7,522)75,328186,83475,57152,082(54,376)44,036172,91763,375(17,357)232,29691,942198,781228,756
<br />Cash Balance$3,280$63,846$60,123$156,325$322,451$273,900$266,379$341,706$528,540$604,111$656,193$601,817$645,853$818,770$882,146$864,789$1,097,085$1,189,026$1,387,807$1,616,563
<br />5-Year Funding Status144%10-Year Funding Status138%Long-Term Funding Status155%
<br />5-Year Funding Sources (Rev + Beg Cash Balance)$1,056,95110-Year Funding Sources (Rev + Beg Cash Balance)$2,181,611Long-Term Funding Sources (Rev + Beg Cash Balance)$4,536,563
<br />Cash Balance (Year-End)$97,0002016
<br />Parks & Recreation Vehicle & Equipment
<br />Planned CIP Surplus/Deficit(135,720)2017
<br />Fund
<br />Adjust for Delayed CIP Items-2017
<br /> $1,800,000
<br />Cash Balance (Beg. Year)$(38,720)2018
<br /> $1,600,000
<br /> $1,400,000
<br /> $1,200,000
<br /> $1,000,000
<br /> $800,000
<br /> $600,000
<br /> $400,000
<br /> $200,000
<br /> $-
<br />2018202120242027203020332036
<br />RevenuesExpendituresCash Balance
<br />Expenditure Detail
<br />KeyDescription20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />VPuppet Wagon (2003)$-$-$-$-$14,000$-$-$-$-$-$-$-$-$-$-$-$-$-$-$14,000$28,000
<br />V#530 Ford F350 with Plow (2016)-----40,000------40,000-----80,000
<br />V#506 Ford 3/4-ton (2012)--40,000-------40,000-------40,000-120,000
<br />V#507 Chevy 1/2-ton (2003)-----40,000-------40,000------80,000
<br />V#528 Ford F350 Dump (2016)-----53,000-------53,000-----106,000
<br />V#510 Water truck (1/2 cost) (2006)-65,000---------65,000--------130,000
<br />V#511 Toolcat (2006)55,000---------55,000---------110,000
<br />VSkid Steer (Lease Program)41,0003,0003,0003,0003,0003,0003,0003,0003,0003,0003,0003,0003,0003,0003,0003,0003,0003,0003,0003,00098,000
<br />V#517 Ford F350 SD (2013)---40,000-------40,000--------80,000
<br />V#515 Ford 350 w. plow (2013)---40,000-------40,000--------80,000
<br />V#516 Ford with plow (2013)---40,000-------40,000--------80,000
<br />VZero Turn Replace (Arb.) (1999)-9,500---------9,500--------19,000
<br />V#532 Ford F350 (2016)-----40,000------40,000-----80,000
<br />V#534 Kromer field liner (2003)-----25,000---------25,000----50,000
<br />V#535 Ford Passenger van (2006)-40,000---------40,000--------80,000
<br />V#545 John Deere tractor (2007)--30,000---------30,000-------60,000
<br />V#560 Ford Passenger van (2006)-40,000---------40,000--------80,000
<br />VSkating Center Plow Truck (2002)----15,000---------15,000-----30,000
<br />E#504 Kubota Drag Tractor (2011)-----30,000---------30,000----60,000
<br />E#509 Toro 4000 Mower (2013)-----50,000---------50,000----100,000
<br />E#513 Toro 4000 Mower (2013)----50,000--------50,000----100,000
<br />E#520 Single axle trailer (1987)-------5,000--------5,000
<br />E#553 John Deere loader (2007)80,000---------80,000---------160,000
<br />E#536 Toro 16' mower (2016)------95,000-------95,000--190,000
<br />
<br />
|