|
Scenario 8 - Preservation of $10M endowment with 5% interest
<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 15,000.00 845,000.00 1,945,000.00 2,228,536.80 283,536.80 561,537.37 11,792,284.82 37.9%
<br />2021 15,000.00 860,000.00 1,960,000.00 2,273,107.54 313,107.54 573,958.86 12,053,136.15 37.8%
<br />2022 15,000.00 875,000.00 1,975,000.00 2,318,569.69 343,569.69 585,478.32 12,295,044.79 37.7%
<br />2023 15,000.00 890,000.00 1,990,000.00 2,364,941.08 374,941.08 596,005.19 12,516,108.89 37.6%
<br />2024 15,000.00 905,000.00 2,005,000.00 2,412,239.90 407,239.90 605,443.45 12,714,312.44 37.5%
<br />2025 15,000.00 920,000.00 2,020,000.00 2,460,484.70 440,484.70 613,691.39 12,887,519.13 37.4%
<br />2026 15,000.00 935,000.00 2,035,000.00 2,509,694.39 474,694.39 620,641.24 13,033,465.97 37.3%
<br />2027 15,000.00 950,000.00 2,050,000.00 2,559,888.28 509,888.28 626,178.88 13,149,756.57 37.1%
<br />2028 15,000.00 965,000.00 2,065,000.00 2,611,086.05 546,086.05 630,183.53 13,233,854.05 37.0%
<br />2029 15,000.00 980,000.00 2,080,000.00 2,663,307.77 583,307.77 632,527.31 13,283,073.60 36.8%
<br />2030 15,000.00 995,000.00 2,095,000.00 2,716,573.92 621,573.92 633,074.98 13,294,574.66 36.6%
<br />2031 20,000.00 1,015,000.00 2,115,000.00 2,770,905.40 655,905.40 631,933.46 13,270,602.72 36.6%
<br />2032 20,000.00 1,035,000.00 2,135,000.00 2,826,323.51 691,323.51 628,963.96 13,208,243.17 36.6%
<br />2033 20,000.00 1,055,000.00 2,155,000.00 2,882,849.98 727,849.98 624,019.66 13,104,412.84 36.6%
<br />2034 20,000.00 1,075,000.00 2,175,000.00 2,940,506.98 765,506.98 616,945.29 12,955,851.16 36.6%
<br />2035 20,000.00 1,095,000.00 2,195,000.00 2,999,317.12 804,317.12 607,576.70 12,759,110.74 36.5%
<br />2036 20,000.00 1,115,000.00 2,215,000.00 3,059,303.46 844,303.46 595,740.36 12,510,547.64 36.4%
<br />2037 20,000.00 1,135,000.00 2,235,000.00 3,120,489.53 885,489.53 581,252.91 12,206,311.01 36.4%
<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:12,576,277.12
<br />Interest earning of $581K every year into perpetuity
<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
|