City of Roseville
<br />Street Light Maintenance Fund (406)
<br />Capital Improvement Plan:
<br />2018-2037
<br />20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />Tax Levy: Current$21,000$21,000$21,000$21,000$21,000$21,000$21,000$21,000$21,000$21,000$21,000$21,000$21,000$21,000$21,000$21,000$21,000$21,000$21,000$21,000
<br />Tax Levy: Add/Sub--------------------
<br />Other--------------------
<br />Sale of Assets--------------------
<br />Interest Earnings1,7181,2721,7178729095477810052252473503433462891429457486416444
<br />Revenues$22,718$22,272$22,717$21,872$21,909$21,547$21,078$21,100$21,522$21,052$21,473$21,503$21,433$21,462$21,891$21,429$21,457$21,486$21,416$21,444$432,781
<br />Vehicles$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-
<br />Equipment--------------------
<br />Furniture & Fixtures--------------------
<br />Buildings--------------------
<br />Improvements45,000-65,00020,00040,00045,00020,000-45,000-20,00025,00020,000-45,00020,00020,00025,00020,000-
<br />Expenditures$45,000$-$65,000$20,000$40,000$45,000$20,000$-$45,000$-$20,000$25,000$20,000$-$45,000$20,000$20,000$25,000$20,000$-$475,000
<br />Beginning Cash Balance$85,880$63,598$85,870$43,587$45,459$27,368$3,915$4,994$26,093$2,615$23,668$25,141$21,644$23,077$44,538$21,429$22,857$24,315$20,801$22,217
<br />Annual Surplus (deficit)(22,282)22,272(42,283)1,872(18,091)(23,453)1,07821,100(23,478)21,0521,473(3,497)1,43321,462(23,109)1,4291,457(3,514)1,41621,444
<br />Cash Balance$63,598$85,870$43,587$45,459$27,368$3,915$4,994$26,093$2,615$23,668$25,141$21,644$23,077$44,538$21,429$22,857$24,315$20,801$22,217$43,661
<br />5-Year Funding Status116%10-Year Funding Status108%Long-Term Funding Status109%
<br />5-Year Funding Sources (Rev + Beg Cash Balance)$197,36810-Year Funding Sources (Rev + Beg Cash Balance)$303,668Long-Term Funding Sources (Rev + Beg Cash Balance)$518,661
<br />Cash Balance (Year-End)$70,0002016
<br />Street Light Maintenance Fund
<br />Planned CIP Surplus/Deficit15,8802017
<br />Adjust for Delayed CIP Items-2017
<br /> $100,000
<br />Cash Balance (Beg. Year)$85,8802018
<br /> $90,000
<br /> $80,000
<br /> $70,000
<br /> $60,000
<br /> $50,000
<br /> $40,000
<br /> $30,000
<br /> $20,000
<br /> $10,000
<br /> $-
<br />2018202120242027203020332036
<br />RevenuesExpendituresCash Balance
<br />Expenditure Detail
<br />KeyDescription20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />IPedestrian light @ Victoria----20,000---------------$20,000
<br />IMisc. pole fixture replacement25,000-25,000--25,000--25,000--25,000--25,000-25,000--175,000
<br />IPedestrian light @ Nature Ctr--20,000-----------------20,000
<br />IPedestrian light @ Lexington Centra ---20,000----------------20,000
<br />IPedestrian light @ Hamline and Gar-----20,000--------------20,000
<br />IPedestrian Light Cnty Rd D at Millw---------------10,000----10,000
<br />ISpeed Display Sign Cnty D---------------10,000----10,000
<br />ISignal Pole Painting (3 every other y20,000-20,000-20,000-20,000-20,000-20,000-20,000-20,000-20,000-20,000-200,000
<br />---------------------
<br />$45,000$-$65,000$20,000$40,000$45,000$20,000$-$45,000$-$20,000$25,000$20,000$-$45,000$20,000$20,000$25,000$20,000$-$475,000
<br />
<br />
|