|
Scenario 4 - Medium-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 160,000.00 790,000.00 1,890,000.00 2,184,840.00 294,840.00 546,299.25 11,472,284.25 36.2%
<br />2020 160,000.00 950,000.00 2,050,000.00 2,228,536.80 178,536.80 564,687.37 11,858,434.82 42.6%
<br />2021 100,000.00 1,050,000.00 2,150,000.00 2,273,107.54 123,107.54 586,766.36 12,322,093.65 46.2%
<br />2022 100,000.00 1,150,000.00 2,250,000.00 2,318,569.69 68,569.69 612,676.20 12,866,200.16 49.6%
<br />2023 100,000.00 1,250,000.00 2,350,000.00 2,364,941.08 14,941.08 642,562.95 13,493,822.04 52.9%
<br />2024 1,250,000.00 2,350,000.00 2,412,239.90 62,239.90 671,579.11 14,103,161.24 51.8%
<br />2025 1,250,000.00 2,350,000.00 2,460,484.70 110,484.70 699,633.83 14,692,310.37 50.8%
<br />2026 1,250,000.00 2,350,000.00 2,509,694.39 159,694.39 726,630.80 15,259,246.77 49.8%
<br />2027 1,250,000.00 2,350,000.00 2,559,888.28 209,888.28 752,467.92 15,801,826.41 48.8%
<br />2028 1,250,000.00 2,350,000.00 2,611,086.05 261,086.05 777,037.02 16,317,777.39 47.9%
<br />2029 1,250,000.00 2,350,000.00 2,663,307.77 313,307.77 800,223.48 16,804,693.10 46.9%
<br />2030 1,250,000.00 2,350,000.00 2,716,573.92 366,573.92 821,905.96 17,260,025.13 46.0%
<br />2031 1,250,000.00 2,350,000.00 2,770,905.40 420,905.40 841,955.99 17,681,075.72 45.1%
<br />2032 1,250,000.00 2,350,000.00 2,826,323.51 476,323.51 860,237.61 18,064,989.82 44.2%
<br />2033 1,250,000.00 2,350,000.00 2,882,849.98 532,849.98 876,606.99 18,408,746.83 43.4%
<br />2034 1,250,000.00 2,350,000.00 2,940,506.98 590,506.98 890,911.99 18,709,151.84 42.5%
<br />2035 1,250,000.00 2,350,000.00 2,999,317.12 649,317.12 902,991.74 18,962,826.46 41.7%
<br />2036 1,250,000.00 2,350,000.00 3,059,303.46 709,303.46 912,676.15 19,166,199.14 40.9%
<br />2037 1,250,000.00 2,350,000.00 3,120,489.53 770,489.53 919,785.48 19,315,495.09 40.1%
<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:15,470,461.20
<br />Endowment continues growing
<br />0.00
<br />5,000,000.00
<br />10,000,000.00
<br />15,000,000.00
<br />20,000,000.00
<br />25,000,000.00
<br />Revenues
<br />Expenditures
<br />Reserve Balance
<br />Pavement Management Program
|