City of Roseville
<br />License Center Facility & Equipment Fund (265)
<br />Capital Improvement Plan:
<br />2018-2037
<br />20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />Tax Levy: current$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-
<br />Tax Levy: Add/Sub--------------------
<br />Fees, Licenses, & Permits25,00025,00025,00025,00025,00025,00025,00025,00025,00025,00025,00025,00025,00025,00025,00025,00025,00025,00025,00025,000
<br />Sale of Assets--------------------
<br />Interest Earnings21,71318,48519,23720,03220,85621,7532,5723,1043,1043,6063,8904,3064,7345,2795,8086,3646,4127,0207,5448,195
<br />Revenues$46,713$43,485$44,237$45,032$45,856$46,753$27,572$28,104$28,104$28,606$28,890$29,306$29,734$30,279$30,808$31,364$31,412$32,020$32,544$33,195$694,014
<br />Vehicles$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-
<br />Equipment1,0003,8003,0003,8001,0005,8001,0003,8003,0004,8001,0005,8001,0003,8003,0003,8001,0005,800--
<br />Furniture & Fixtures2,1002,100-----2,100-9,6002,1002,100---2,200----
<br />Buildings205,000-1,500--1,000,000-22,200--5,000-1,500--23,000----
<br />Improvements--------------------
<br />Expenditures$208,100$5,900$4,500$3,800$1,000$1,005,800$1,000$28,100$3,000$14,400$8,100$7,900$2,500$3,800$3,000$29,000$1,000$5,800$-$-$1,336,700
<br />Beginning Cash Balance$1,085,642$924,254$961,839$1,001,576$1,042,808$1,087,664$128,617$155,190$155,193$180,297$194,503$215,293$236,699$263,933$290,412$318,220$320,584$350,996$377,216$409,760
<br />
<br />Annual Surplus (deficit)(161,387)37,58539,73741,23244,856(959,047)26,572425,10414,20620,79021,40627,23426,47927,8082,36430,41226,22032,54433,195
<br />Cash Balance$924,254$961,839$1,001,576$1,042,808$1,087,664$128,617$155,190$155,193$180,297$194,503$215,293$236,699$263,933$290,412$318,220$320,584$350,996$377,216$409,760$442,955
<br />5-Year Funding Status587%10-Year Funding Status115%Long-Term Funding Status133%
<br />5-Year Funding Sources (Rev + Beg Cash Balance)$1,310,96410-Year Funding Sources (Rev + Beg Cash Balance)$1,470,103Long-Term Funding Sources (Rev + Beg Cash Balance)$1,779,655
<br />Cash Balance (Year-End) *$1,536,0002016
<br />License Center Facility & Equipment Fund
<br />Less Amt Needed for Operations **(434,088)2017
<br />Planned CIP Surplus/Deficit(16,271)2017
<br /> $1,200,000
<br />Adjust for Delayed CIP Items-2017
<br />Cash Balance (Beg. Year)$1,085,6422018 $1,000,000
<br /> $800,000
<br />Adopted Budget (Excl.Capital)$1,736,3502017
<br /> $600,000
<br />* Current Assets - Current Liabilities
<br />** 25% of Annual Budget Needed for Cash-Flow Purposes
<br /> $400,000
<br /> $200,000
<br /> $-
<br />2018202120242027203020332036
<br />RevenuesExpendituresCash Balance
<br />Expenditure Detail
<br />KeyDescription20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />EGeneral office equipment (minor)$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$-$-$18,000
<br />EComputer equipment (4)2,800-2,8002,8002,800-2,8002,800-2,8002,8002,800--25,200
<br />EPrinters (2)---------1,000----------1,000
<br />EPassport camera--2,000--2,000--2,000--2,000--2,000--2,000--12,000
<br />FOffice chair replacement2,1002,100-------2,1002,1002,100--------10,500
<br />FConference table & chairs-------2,100-------2,200----4,300
<br />FWorkstation changes---------7,500----------7,500
<br />BSecurity camera replacement5,000---------5,000---------10,000
<br />BBathroom improvements--1,500---------1,500-------3,000
<br />BOffice painting-------6,700-------7,000----13,700
<br />BOffice carpeting-------15,500-------16,000----31,500
<br />BFacility Improvements **200,000-------------------200,000
<br />BNew Facility Construction-----1,000,000--------------1,000,000
<br />---------------------
<br />$208,100$5,900$4,500$3,800$1,000$1,005,800$1,000$28,100$3,000$14,400$8,100$7,900$2,500$3,800$3,000$29,000$1,000$5,800$-$-$1,336,700
<br />
<br />
|