|
Scenario 5 - Long-term levy increases with 3% interest earnings PAVEMENT MANAGEMENT PROGRAM
<br />Year Add'l Levy Total Levy Revenues Expenditures Reserve Use Reserve Earnings Reserve Balance
<br />Levy Expenditure
<br />Coverage %
<br />2017 9,544,000.00
<br />2018 160,000.00 470,000.00 1,570,000.00 2,200,000.00 630,000.00 267,420.00 9,181,420.00 21.4%
<br />2019 160,000.00 630,000.00 1,730,000.00 2,200,000.00 470,000.00 261,342.60 8,972,762.60 28.6%
<br />2020 120,000.00 750,000.00 1,850,000.00 2,300,000.00 450,000.00 255,682.88 8,778,445.48 32.6%
<br />2021 50,000.00 800,000.00 1,900,000.00 2,300,000.00 400,000.00 251,353.36 8,629,798.84 34.8%
<br />2022 50,000.00 850,000.00 1,950,000.00 2,300,000.00 350,000.00 248,393.97 8,528,192.81 37.0%
<br />2023 50,000.00 900,000.00 2,000,000.00 2,400,000.00 400,000.00 243,845.78 8,372,038.59 37.5%
<br />2024 50,000.00 950,000.00 2,050,000.00 2,400,000.00 350,000.00 240,661.16 8,262,699.75 39.6%
<br />2025 50,000.00 1,000,000.00 2,100,000.00 2,400,000.00 300,000.00 238,880.99 8,201,580.74 41.7%
<br />2026 50,000.00 1,050,000.00 2,150,000.00 2,600,000.00 450,000.00 232,547.42 7,984,128.16 40.4%
<br />2027 50,000.00 1,100,000.00 2,200,000.00 2,600,000.00 400,000.00 227,523.84 7,811,652.01 42.3%
<br />2028 50,000.00 1,150,000.00 2,250,000.00 2,600,000.00 350,000.00 223,849.56 7,685,501.57 44.2%
<br />2029 50,000.00 1,200,000.00 2,300,000.00 2,600,000.00 300,000.00 221,565.05 7,607,066.62 46.2%
<br />2030 50,000.00 1,250,000.00 2,350,000.00 2,700,000.00 350,000.00 217,712.00 7,474,778.62 46.3%
<br />2031 50,000.00 1,300,000.00 2,400,000.00 2,700,000.00 300,000.00 215,243.36 7,390,021.97 48.1%
<br />2032 50,000.00 1,350,000.00 2,450,000.00 2,800,000.00 350,000.00 211,200.66 7,251,222.63 48.2%
<br />2033 50,000.00 1,400,000.00 2,500,000.00 2,800,000.00 300,000.00 208,536.68 7,159,759.31 50.0%
<br />2034 50,000.00 1,450,000.00 2,550,000.00 2,800,000.00 250,000.00 207,292.78 7,117,052.09 51.8%
<br />2035 50,000.00 1,500,000.00 2,600,000.00 2,800,000.00 200,000.00 207,511.56 7,124,563.65 53.6%
<br />2036 50,000.00 1,550,000.00 2,650,000.00 3,000,000.00 350,000.00 203,236.91 6,977,800.56 51.7%
<br />2037 50,000.00 1,600,000.00 2,700,000.00 3,000,000.00 300,000.00 200,334.02 6,878,134.58 53.3%
<br />Assumptions: MSA funds of $1.1M received every year
<br />Expenditures increase at 2% per year per CIP
<br />Reserve Earnings of 3%
<br />Results:
<br />22 year interest earnings of:4,584,134.58
<br />Endowment preserved at $10.5M (Target Amount)
<br />0.00
<br />2,000,000.00
<br />4,000,000.00
<br />6,000,000.00
<br />8,000,000.00
<br />10,000,000.00
<br />12,000,000.00
<br />Revenues
<br />Expenditures
<br />Reserve Balance
<br />Item 6: Attachment A
<br />2
|