|
Scenario 2 - Short-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 200,000.00 830,000.00 1,930,000.00 2,184,840.00 254,840.00 548,299.25 11,514,284.25 38.0%
<br />2020 830,000.00 1,930,000.00 2,228,536.80 298,536.80 560,787.37 11,776,534.82 37.2%
<br />2021 830,000.00 1,930,000.00 2,273,107.54 343,107.54 571,671.36 12,005,098.65 36.5%
<br />2022 830,000.00 1,930,000.00 2,318,569.69 388,569.69 580,826.45 12,197,355.41 35.8%
<br />2023 830,000.00 1,930,000.00 2,364,941.08 434,941.08 588,120.72 12,350,535.05 35.1%
<br />2024 830,000.00 1,930,000.00 2,412,239.90 482,239.90 593,414.76 12,461,709.90 34.4%
<br />2025 830,000.00 1,930,000.00 2,460,484.70 530,484.70 596,561.26 12,527,786.46 33.7%
<br />2026 830,000.00 1,930,000.00 2,509,694.39 579,694.39 597,404.60 12,545,496.67 33.1%
<br />2027 830,000.00 1,930,000.00 2,559,888.28 629,888.28 595,780.42 12,511,388.81 32.4%
<br />2028 830,000.00 1,930,000.00 2,611,086.05 681,086.05 591,515.14 12,421,817.90 31.8%
<br />2029 830,000.00 1,930,000.00 2,663,307.77 733,307.77 584,425.51 12,272,935.64 31.2%
<br />2030 830,000.00 1,930,000.00 2,716,573.92 786,573.92 574,318.09 12,060,679.80 30.6%
<br />2031 830,000.00 1,930,000.00 2,770,905.40 840,905.40 560,988.72 11,780,763.12 30.0%
<br />2032 830,000.00 1,930,000.00 2,826,323.51 896,323.51 544,221.98 11,428,661.59 29.4%
<br />2033 830,000.00 1,930,000.00 2,882,849.98 952,849.98 523,790.58 10,999,602.19 28.8%
<br />2034 830,000.00 1,930,000.00 2,940,506.98 1,010,506.98 499,454.76 10,488,549.97 28.2%
<br />2035 830,000.00 1,930,000.00 2,999,317.12 1,069,317.12 470,961.64 9,890,194.49 27.7%
<br />2036 830,000.00 1,930,000.00 3,059,303.46 1,129,303.46 438,044.55 9,198,935.58 27.1%
<br />2037 830,000.00 1,930,000.00 3,120,489.53 1,190,489.53 400,422.30 8,408,868.35 26.6%
<br />Assumptions: MSA funds of $1.1M received every year
<br />Expenditures increase at 2% per year
<br />Reserve Earnings of 5%
<br />The rest of levy increases are additional tax levy
<br />Results:$8.4M endowment remaining, providing $400K per year in interest earnings
<br />21 year interest earnings of:11,483,834.46
<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 />Revenues
<br />Expenditures
<br />Reserve Balance
<br />Pavement Management Program
|