|
Scenario 3 - Medium-term levy increases with 3% 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 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 160,000.00 790,000.00 1,890,000.00 2,184,840.00 294,840.00 314,835.39 10,809,348.39 36.2%
<br />2020 160,000.00 950,000.00 2,050,000.00 2,228,536.80 178,536.80 318,924.35 10,949,735.94 42.6%
<br />2021 100,000.00 1,050,000.00 2,150,000.00 2,273,107.54 123,107.54 324,798.85 11,151,427.25 46.2%
<br />2022 100,000.00 1,150,000.00 2,250,000.00 2,318,569.69 68,569.69 332,485.73 11,415,343.29 49.6%
<br />2023 100,000.00 1,250,000.00 2,350,000.00 2,364,941.08 14,941.08 342,012.07 11,742,414.28 52.9%
<br />2024 1,250,000.00 2,350,000.00 2,412,239.90 62,239.90 350,405.23 12,030,579.61 51.8%
<br />2025 1,250,000.00 2,350,000.00 2,460,484.70 110,484.70 357,602.85 12,277,697.76 50.8%
<br />2026 1,250,000.00 2,350,000.00 2,509,694.39 159,694.39 363,540.10 12,481,543.46 49.8%
<br />2027 1,250,000.00 2,350,000.00 2,559,888.28 209,888.28 368,149.66 12,639,804.84 48.8%
<br />2028 1,250,000.00 2,350,000.00 2,611,086.05 261,086.05 371,361.56 12,750,080.35 47.9%
<br />2029 1,250,000.00 2,350,000.00 2,663,307.77 313,307.77 373,103.18 12,809,875.76 46.9%
<br />2030 1,250,000.00 2,350,000.00 2,716,573.92 366,573.92 373,299.06 12,816,600.89 46.0%
<br />2031 1,250,000.00 2,350,000.00 2,770,905.40 420,905.40 371,870.86 12,767,566.36 45.1%
<br />2032 1,250,000.00 2,350,000.00 2,826,323.51 476,323.51 368,737.29 12,659,980.13 44.2%
<br />2033 1,250,000.00 2,350,000.00 2,882,849.98 532,849.98 363,813.90 12,490,944.05 43.4%
<br />2034 1,250,000.00 2,350,000.00 2,940,506.98 590,506.98 357,013.11 12,257,450.19 42.5%
<br />2035 1,250,000.00 2,350,000.00 2,999,317.12 649,317.12 348,243.99 11,956,377.06 41.7%
<br />2036 1,250,000.00 2,350,000.00 3,059,303.46 709,303.46 337,412.21 11,584,485.80 40.9%
<br />2037 1,250,000.00 2,350,000.00 3,120,489.53 770,489.53 324,419.89 11,138,416.16 40.1%
<br />Assumptions: MSA funds of $1.1M received every year
<br />Expenditures increase at 2% per year
<br />Reserve Earnings of 3%
<br />The rest of levy increases are additional tax levy
<br />Results:
<br />21 year interest earnings of:7,293,382.27
<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
|