City of Roseville
<br />Street Replacement Fund (530 & 590)
<br />Capital Improvement Plan:
<br />2018-2037
<br />20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />Tax Levy: Current$ 630,000$ 630,000$ 630,000$ 630,000$ 630,000$ 630,000$ 630,000$ 630,000$ 630,000$ 630,000$ 630,000$ 630,000$ 630,000$ 630,000$
<br /> 630,000$ 630,000$ 630,000$ 630,000$ 630,000$ 630,000
<br />Tax Levy: Add/Sub--------------------
<br />Other - MSA, Assessments1,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,10
<br />0,000
<br />Sale of Assets--------------------
<br />Interest Earnings190,880185,298179,604171,796163,832155,708145,422134,931124,229109,31494,10078,58262,75444,60926,1015,223----
<br />Revenues$ 1,920,880$ 1,915,298$ 1,909,604$ 1,901,796$ 1,893,832$ 1,885,708$ 1,875,422$1,864,931$1,854,229$1,839,314$1,824,100$1,808,582$ 1,792,754$ 1,774,609$ 1,756,101$ 1,735,223$
<br />1,730,000$ 1,730,000$ 1,730,000$ 1,730,000$36,472,383
<br />Vehicles$ -$ -$ -$ -$ -$ -$ -$ -$ -$
<br /> -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
<br /> -
<br />Equipment--------------------
<br />Furniture & Fixtures--------------------
<br />Buildings--------------------
<br />Improvements2,200,0002,200,0002,300,0002,300,0002,300,0002,400,0002,400,0002,400,0002,600,0002,600,0002,600,0002,600,0002,700,0002,700,0002,800,0002,800,0002,800,0002,800,0003,000,0003,000,000
<br />
<br />Expenditures$ 2,200,000$ 2,200,000$ 2,300,000$ 2,300,000$ 2,300,000$ 2,400,000$ 2,400,000$2,400,000$2,600,000$2,600,000$2,600,000$2,600,000$ 2,700,000$ 2,700,000$ 2,800,000$ 2,800,000$
<br />2,800,000$ 2,800,000$ 3,000,000$ 3,000,000$51,500,000
<br />Beginning Cash Balance$ 9,544,000$ 9,264,880$ 8,980,178$ 8,589,781$ 8,191,577$ 7,785,408$ 7,271,116$6,746,539$6,211,470$5,465,699$4,705,013$3,929,113$ 3,137,695$ 2,230,449$ 1,305,058$
<br /> 261,160$ (803,617)$(1,873,617)$ (2,943,617)$ (4,213,617)
<br />Annual Surplus (deficit)(279,120)(284,702)(390,396)(398,204)(406,168)(514,292)(524,578)(535,069)(745,771)(760,686)(775,900)(791,418)(907,246)(925,391)(1,043,899)(1,064,777)(1,070,000)(1,070,000)(1,27
<br />0,000)(1,270,000)
<br />Cash Balance$ 9,264,880$ 8,980,178$ 8,589,781$ 8,191,577$ 7,785,408$ 7,271,116$ 6,746,539$6,211,470$5,465,699$4,705,013$3,929,113$3,137,695$ 2,230,449$ 1,305,058$ 261,160$
<br /> (803,617)$(1,873,617)$(2,943,617)$ (4,213,617)$ (5,483,617)
<br />5-Year Funding Status169%10-Year Funding Status120%Long-Term Funding Status89%
<br />5-Year Funding Sources (Rev + Beg Cash Balance)$19,085,40810-Year Funding Sources (Rev + Beg Cash Balance)#########Long-Term Funding Sources (Rev + Beg Cash Balance)$ 46,016,383
<br />Fund 530$10,199,000
<br />** Fund 590(655,000)
<br />Pavement Management Fund
<br />9,544,000
<br /> $12,000,000
<br />** $500K was left for up-front financing
<br /> $10,000,000
<br /> $8,000,000
<br /> $6,000,000
<br /> $4,000,000
<br /> $2,000,000
<br /> $-
<br />2018202120242027203020332036
<br /> $(2,000,000)
<br /> $(4,000,000)
<br /> $(6,000,000)
<br /> $(8,000,000)
<br />RevenuesExpendituresCash Balance
<br />Expenditure Detail
<br />KeyDescription20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />IMill & overlay - local streets$ 1,100,000$ 1,100,000$ 1,200,000$ 1,200,000$ 1,200,000$ 1,300,000$ 1,300,000$1,300,000$1,400,000$1,400,000$1,400,000$1,400,000$ 1,500,000$ 1,500,000$
<br />1,500,000$ 1,500,000$ 1,500,000$ 1,500,000$ 1,600,000$ 1,600,000$27,500,000
<br />IReconstruction - local streets---------------------
<br />IReconstruction/M & O - MSA stree1,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,200,0001,200,0001,200,0001,200,0001,200,0001,200,0001,300,0001,300,0001,300,0001,300,0001,40
<br />0,0001,400,00024,000,000
<br />ICo Road B2 (Snelling to Fairview)---------------------
<br />---------------------
<br />$ 2,200,000$ 2,200,000$ 2,300,000$ 2,300,000$ 2,300,000$ 2,400,000$ 2,400,000$2,400,000$2,600,000$2,600,000$2,600,000$2,600,000$ 2,700,000$ 2,700,000$ 2,800,000$ 2,800,000$ 2,800,000$
<br />2,800,000$ 3,000,000$ 3,000,000$51,500,000
<br />
<br />
|