City of Roseville
<br />Storm Sewer Vehicle & Equipment Fund (640)
<br />Capital Improvement Plan:
<br />2018-2037
<br />20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />Tax Levy: current$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-
<br />Tax Levy: Add/Sub-------------------
<br />Fees, Licenses, & Permits1,039,5001,039,5001,039,5001,039,5001,039,5001,039,5001,039,5001,039,5001,039,5001,039,5001,039,5001,039,5001,039,5001,039,5001,039,5001,039,5001,039,5001,039,5001,039,5001,0
<br />39,500
<br />Sale of Assets--------------------
<br />Interest Earnings3,9523,0222,972-----------------
<br />Revenues$1,043,452$1,042,522$1,042,472$1,039,500$1,039,500$1,039,500$1,039,500$1,039,500$1,039,500$1,039,500$1,039,500$1,039,500$1,039,500$1,039,500$1,039,500$1,039,500$1,039,500$1,039,500$1,039,500$
<br />1,039,500$20,799,946
<br />Vehicles$-$270,000$200,000$45,000$-$240,000$180,000$-$220,000$-$-$35,000$-$470,000$45,000$-$200,000$-$180,000$240,000
<br />Equipment465,00075,000321,00030,000315,00034,000-273,000200,00017,50045,00067,00014,00015,00037,00020,000560,00034,000258,00027,500
<br />Furniture & Fixtures--------------------
<br />Buildings--------------------
<br />Improvements625,000700,000800,000875,000900,000900,000900,000900,000950,0001,040,000950,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,00090,000
<br />Expenditures$1,090,000$1,045,000$1,321,000$950,000$1,215,000$1,174,000$1,080,000$1,173,000$1,370,000$1,057,500$995,000$1,102,000$1,014,000$1,485,000$1,082,000$1,020,000$1,760,000$1,034,000$1,438,000$
<br />357,500$22,763,000
<br />Beginning Cash Balance$197,623$151,075$148,597$(129,931)$(40,431)$(215,931)$(350,431)$(390,931)$(524,431)$(854,931)$(872,931)$(828,431)$(890,931)$(865,431)$(1,310,931)$(1,353,431)$(1,333,931)$(2,054,
<br />431)$(2,048,931)$(2,447,431)
<br />Annual Surplus (deficit)(46,548)(2,478)(278,528)89,500(175,500)(134,500)(40,500)(133,500)(330,500)(18,000)44,500(62,500)25,500(445,500)(42,500)19,500(720,500)5,500(398,500)682,000
<br />Cash Balance$151,075$148,597$(129,931)$(40,431)$(215,931)$(350,431)$(390,931)$(524,431)$(854,931)$(872,931)$(828,431)$(890,931)$(865,431)$(1,310,931)$(1,353,431)$(1,333,931)$(2,054,431)$(2,048,931)$(
<br />2,447,431)$(1,765,431)
<br />5-Year Funding Status96%10-Year Funding Status92%Long-Term Funding Status92%
<br />5-Year Funding Sources (Rev + Beg Cash Balance)$5,405,06910-Year Funding Sources (Rev + Beg Cash Balance)#########Long-Term Funding Sources (Rev + Beg Cash Balance)$20,997,569
<br />Cash Balance (Year-End) *$329,0002016
<br />Storm Sewer Vehicle & Equipment Fund
<br />Less Amt Needed for Operations **(83,830)2016
<br />Planned CIP Surplus/Deficit(47,547)2017
<br /> $2,000,000
<br />Adjust for Delayed CIP Items-2017
<br /> $1,500,000
<br />Cash Balance (Beg. Year)$197,6232018
<br /> $1,000,000
<br /> $500,000
<br />Adopted Budget (Excl.Capital, Dep$838,3002017
<br /> $-
<br />2018202120242027203020332036
<br /> $(500,000)
<br />* Current Assets - Current Liabilities
<br /> $(1,000,000)
<br />** 10% of Annual Budget Needed for Cash-Flow Purposes
<br /> $(1,500,000)
<br /> $(2,000,000)
<br /> $(2,500,000)
<br /> $(3,000,000)
<br />RevenuesExpendituresCash Balance
<br />Expenditure Detail
<br />KeyDescription20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />V#103 Ford 450 w/ Plow$-$65,000$-$-$-$-$-$-$-$-$-$-$65,000$-$-$-$-$-$-130,000
<br />V#121 Regenerative Air Broom (Swe-----240,000-------------240,000480,000
<br />V#122 Wheel Loader -205,000-----------205,000------410,000
<br />V#132 Elgin sweeper 2002 3-wheel------------200,000-----200,000
<br />V#147 3-Ton dump truck ------180,000-----------180,000-360,000
<br />V#145 5-Ton hook dump-------220,000-----------220,000
<br />V#167 Elgin Sweeper 2006 3-wheel--200,000-------------200,000---400,000
<br />V#126 Bobcat Skidsteer ---45,000----------45,000-----90,000
<br />VTractor/snowblower (1/2 streets)-----------35,000--------35,000
<br />ECement mixer-----4,000-----------4,000--8,000
<br />E#171 Tennant 6600 sweeper--32,000-----------32,000-----64,000
<br />E#163 Electronic message board--20,000------------20,000----40,000
<br />E#139 Vacall----250,000-----------250,000---500,000
<br />E#130 Steamer "Amazing Machine" --15,000----------15,000------30,000
<br />E#131 LCT 600 Leaf Machine-----30,000--------------30,000
<br />E#172 Zero Turn Dixie Chopper15,000--------15,000---------30,000
<br />EMower/Snow Blower Combo (1/2 w ---30,000------30,000------30,000--90,000
<br />E#164 Bobcat UTV-------15,000----------15,00030,000
<br />E#168 Wildcat Compost Turner --250,000------------250,000---500,000
<br />E Electronic message board-attenuato---------7,500---------7,50015,000
<br />EField Computer Add/Replacements----5,000----5,000----5,000----5,00020,000
<br />EGPS Unit (1/3)--4,000---------4,000-------8,000
<br />E Generator for St Croix----------------180,000-180,000
<br />E#225 Cat Mini Back-hoe (1/3 san, 1 -----------40,000--------40,000
<br />E#211 360 Backhoe (Grapple Bucket-------18,000----------18,000-36,000
<br />E#165 5 ton trailer ----------12,000--------12,000
<br />E#211 Backhoe 1/3 water. Sewer, st----60,000-------------60,000-120,000
<br />E#211A Sand Bucket (1/3)---------5,000----------5,000
<br />EArona Storm Station Upgrades------20,000------------20,000
<br />EMillwood Storm Station Upgrades------200,000-----------200,000
<br />EOwasso Hills Storm Station Upgrad------200,000-----------200,000
<br />
<br />
|