|
Scenario 6 - Long-term levy increases with 5% 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 528,500.00 11,098,500.00 22.4%
<br />2018 160,000.00 630,000.00 1,730,000.00 2,142,000.00 412,000.00 534,325.00 11,220,825.00 29.4%
<br />2019 120,000.00 750,000.00 1,850,000.00 2,184,840.00 334,840.00 544,299.25 11,430,284.25 34.3%
<br />2020 50,000.00 800,000.00 1,900,000.00 2,228,536.80 328,536.80 555,087.37 11,656,834.82 35.9%
<br />2021 50,000.00 850,000.00 1,950,000.00 2,273,107.54 323,107.54 566,686.36 11,900,413.65 37.4%
<br />2022 50,000.00 900,000.00 2,000,000.00 2,318,569.69 318,569.69 579,092.20 12,160,936.16 38.8%
<br />2023 50,000.00 950,000.00 2,050,000.00 2,364,941.08 314,941.08 592,299.75 12,438,294.84 40.2%
<br />2024 50,000.00 1,000,000.00 2,100,000.00 2,412,239.90 312,239.90 606,302.75 12,732,357.68 41.5%
<br />2025 50,000.00 1,050,000.00 2,150,000.00 2,460,484.70 310,484.70 621,093.65 13,042,966.63 42.7%
<br />2026 50,000.00 1,100,000.00 2,200,000.00 2,509,694.39 309,694.39 636,663.61 13,369,935.85 43.8%
<br />2027 50,000.00 1,150,000.00 2,250,000.00 2,559,888.28 309,888.28 653,002.38 13,713,049.94 44.9%
<br />2028 50,000.00 1,200,000.00 2,300,000.00 2,611,086.05 311,086.05 670,098.19 14,072,062.09 46.0%
<br />2029 50,000.00 1,250,000.00 2,350,000.00 2,663,307.77 313,307.77 687,937.72 14,446,692.04 46.9%
<br />2030 50,000.00 1,300,000.00 2,400,000.00 2,716,573.92 316,573.92 706,505.91 14,836,624.02 47.9%
<br />2031 50,000.00 1,350,000.00 2,450,000.00 2,770,905.40 320,905.40 725,785.93 15,241,504.55 48.7%
<br />2032 50,000.00 1,400,000.00 2,500,000.00 2,826,323.51 326,323.51 745,759.05 15,660,940.09 49.5%
<br />2033 50,000.00 1,450,000.00 2,550,000.00 2,882,849.98 332,849.98 766,404.51 16,094,494.61 50.3%
<br />2034 50,000.00 1,500,000.00 2,600,000.00 2,940,506.98 340,506.98 787,699.38 16,541,687.02 51.0%
<br />2035 50,000.00 1,550,000.00 2,650,000.00 2,999,317.12 349,317.12 809,618.49 17,001,988.39 51.7%
<br />2036 50,000.00 1,600,000.00 2,700,000.00 3,059,303.46 359,303.46 832,134.25 17,474,819.17 52.3%
<br />2037 50,000.00 1,650,000.00 2,750,000.00 3,120,489.53 370,489.53 855,216.48 17,959,546.13 52.9%
<br />Assumptions: MSA funds of $1.1M received every year
<br />Expenditures increase at 2% per year
<br />Reserve Earnings of 5%
<br />Results:
<br />22 year interest earnings of:14,004,512.23
<br />Endowment continues growing
<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 />14,000,000.00
<br />16,000,000.00
<br />18,000,000.00
<br />20,000,000.00
<br />Revenues
<br />Expenditures
<br />Reserve Balance
<br />Pavement Management Program
|