|
Scenario 7 - Preservation of $10M endowment with 3% 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 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 200,000.00 830,000.00 1,930,000.00 2,184,840.00 254,840.00 316,035.39 10,850,548.39 38.0%
<br />2020 110,000.00 940,000.00 2,040,000.00 2,228,536.80 188,536.80 319,860.35 10,981,871.94 42.2%
<br />2021 110,000.00 1,050,000.00 2,150,000.00 2,273,107.54 123,107.54 325,762.93 11,184,527.33 46.2%
<br />2022 110,000.00 1,160,000.00 2,260,000.00 2,318,569.69 58,569.69 333,778.73 11,459,736.38 50.0%
<br />2023 23,200.00 1,183,200.00 2,283,200.00 2,364,941.08 81,741.08 341,339.86 11,719,335.15 50.0%
<br />2024 23,664.00 1,206,864.00 2,306,864.00 2,412,239.90 105,375.90 348,418.78 11,962,378.03 50.0%
<br />2025 24,137.28 1,231,001.28 2,331,001.28 2,460,484.70 129,483.42 354,986.84 12,187,881.45 50.0%
<br />2026 24,620.03 1,255,621.31 2,355,621.31 2,509,694.39 154,073.09 361,014.25 12,394,822.61 50.0%
<br />2027 25,112.43 1,280,733.73 2,380,733.73 2,559,888.28 179,154.55 366,470.04 12,582,138.10 50.0%
<br />2028 25,614.67 1,306,348.41 2,406,348.41 2,611,086.05 204,737.64 371,322.01 12,748,722.47 50.0%
<br />2029 26,126.97 1,332,475.37 2,432,475.37 2,663,307.77 230,832.39 375,536.70 12,893,426.78 50.0%
<br />2030 26,649.51 1,359,124.88 2,459,124.88 2,716,573.92 257,449.04 379,079.33 13,015,057.07 50.0%
<br />2031 27,182.50 1,386,307.38 2,486,307.38 2,770,905.40 284,598.02 381,913.77 13,112,372.82 50.0%
<br />2032 27,726.15 1,414,033.53 2,514,033.53 2,826,323.51 312,289.98 384,002.49 13,184,085.32 50.0%
<br />2033 28,280.67 1,442,314.20 2,542,314.20 2,882,849.98 340,535.78 385,306.49 13,228,856.03 50.0%
<br />2034 28,846.28 1,471,160.48 2,571,160.48 2,940,506.98 369,346.50 385,785.29 13,245,294.81 50.0%
<br />2035 29,423.21 1,500,583.69 2,600,583.69 2,999,317.12 398,733.43 385,396.84 13,231,958.23 50.0%
<br />2036 30,011.67 1,530,595.37 2,630,595.37 3,059,303.46 428,708.10 384,097.50 13,187,347.63 50.0%
<br />2037 30,611.91 1,561,207.27 2,661,207.27 3,120,489.53 459,282.26 381,841.96 13,109,907.34 50.0%
<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:7,513,302.55
<br />Interest earnings of $300K+ 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
|