|
Scenario 5 - Long-term levy increases with 3% interest earnings
<br />Year Add'l Levy Total Levy Revenues Expenditures Reserve Use Reserve Earnings Reserve Balance
<br />Levy Expenditure
<br />Coverage %
<br />2016 11,100,000.00
<br />2017 160,000.00 470,000.00 1,570,000.00 2,100,000.00 530,000.00 317,100.00 10,887,100.00 22.4%
<br />2018 160,000.00 630,000.00 1,730,000.00 2,142,000.00 412,000.00 314,253.00 10,789,353.00 29.4%
<br />2019 120,000.00 750,000.00 1,850,000.00 2,184,840.00 334,840.00 313,635.39 10,768,148.39 34.3%
<br />2020 50,000.00 800,000.00 1,900,000.00 2,228,536.80 328,536.80 313,188.35 10,752,799.94 35.9%
<br />2021 50,000.00 850,000.00 1,950,000.00 2,273,107.54 323,107.54 312,890.77 10,742,583.17 37.4%
<br />2022 50,000.00 900,000.00 2,000,000.00 2,318,569.69 318,569.69 312,720.40 10,736,733.89 38.8%
<br />2023 50,000.00 950,000.00 2,050,000.00 2,364,941.08 314,941.08 312,653.78 10,734,446.60 40.2%
<br />2024 50,000.00 1,000,000.00 2,100,000.00 2,412,239.90 312,239.90 312,666.20 10,734,872.89 41.5%
<br />2025 50,000.00 1,050,000.00 2,150,000.00 2,460,484.70 310,484.70 312,731.65 10,737,119.84 42.7%
<br />2026 50,000.00 1,100,000.00 2,200,000.00 2,509,694.39 309,694.39 312,822.76 10,740,248.21 43.8%
<br />2027 50,000.00 1,150,000.00 2,250,000.00 2,559,888.28 309,888.28 312,910.80 10,743,270.73 44.9%
<br />2028 50,000.00 1,200,000.00 2,300,000.00 2,611,086.05 311,086.05 312,965.54 10,745,150.22 46.0%
<br />2029 50,000.00 1,250,000.00 2,350,000.00 2,663,307.77 313,307.77 312,955.27 10,744,797.72 46.9%
<br />2030 50,000.00 1,300,000.00 2,400,000.00 2,716,573.92 316,573.92 312,846.71 10,741,070.51 47.9%
<br />2031 50,000.00 1,350,000.00 2,450,000.00 2,770,905.40 320,905.40 312,604.95 10,732,770.06 48.7%
<br />2032 50,000.00 1,400,000.00 2,500,000.00 2,826,323.51 326,323.51 312,193.40 10,718,639.95 49.5%
<br />2033 50,000.00 1,450,000.00 2,550,000.00 2,882,849.98 332,849.98 311,573.70 10,697,363.67 50.3%
<br />2034 50,000.00 1,500,000.00 2,600,000.00 2,940,506.98 340,506.98 310,705.70 10,667,562.39 51.0%
<br />2035 50,000.00 1,550,000.00 2,650,000.00 2,999,317.12 349,317.12 309,547.36 10,627,792.63 51.7%
<br />2036 50,000.00 1,600,000.00 2,700,000.00 3,059,303.46 359,303.46 308,054.67 10,576,543.84 52.3%
<br />2037 50,000.00 1,650,000.00 2,750,000.00 3,120,489.53 370,489.53 306,181.63 10,512,235.94 52.9%
<br />Assumptions: MSA funds of $1.1M received every year
<br />Expenditures increase at 2% per year
<br />Reserve Earnings of 3%
<br />Results:
<br />22 year interest earnings of:6,557,202.05
<br />Endowment preserved at $10.5M
<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 />Pavement Management Program
|