|
Pavement Management Program
<br />Scenario 1 - Short-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 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 830,000.00 1,930,000.00 2,228,536.80 298,536.80 316,560.35 10,868,571.94 37.2%
<br />2021 830,000.00 1,930,000.00 2,273,107.54 343,107.54 315,763.93 10,841,228.33 36.5%
<br />2022 830,000.00 1,930,000.00 2,318,569.69 388,569.69 313,579.76 10,766,238.41 35.8%
<br />2023 830,000.00 1,930,000.00 2,364,941.08 434,941.08 309,938.92 10,641,236.25 35.1%
<br />2024 830,000.00 1,930,000.00 2,412,239.90 482,239.90 304,769.89 10,463,766.23 34.4%
<br />2025 830,000.00 1,930,000.00 2,460,484.70 530,484.70 297,998.45 10,231,279.98 33.7%
<br />2026 830,000.00 1,930,000.00 2,509,694.39 579,694.39 289,547.57 9,941,133.15 33.1%
<br />2027 830,000.00 1,930,000.00 2,559,888.28 629,888.28 279,337.35 9,590,582.22 32.4%
<br />2028 830,000.00 1,930,000.00 2,611,086.05 681,086.05 267,284.89 9,176,781.06 31.8%
<br />2029 830,000.00 1,930,000.00 2,663,307.77 733,307.77 253,304.20 8,696,777.49 31.2%
<br />2030 830,000.00 1,930,000.00 2,716,573.92 786,573.92 237,306.11 8,147,509.67 30.6%
<br />2031 830,000.00 1,930,000.00 2,770,905.40 840,905.40 219,198.13 7,525,802.39 30.0%
<br />2032 830,000.00 1,930,000.00 2,826,323.51 896,323.51 198,884.37 6,828,363.25 29.4%
<br />2033 830,000.00 1,930,000.00 2,882,849.98 952,849.98 176,265.40 6,051,778.67 28.8%
<br />2034 830,000.00 1,930,000.00 2,940,506.98 1,010,506.98 151,238.15 5,192,509.84 28.2%
<br />2035 830,000.00 1,930,000.00 2,999,317.12 1,069,317.12 123,695.78 4,246,888.50 27.7%
<br />2036 830,000.00 1,930,000.00 3,059,303.46 1,129,303.46 93,527.55 3,211,112.59 27.1%
<br />2037 830,000.00 1,930,000.00 3,120,489.53 1,190,489.53 60,618.69 2,081,241.75 26.6%
<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:Will need a 1,190,489.53 levy increase plus inflation starting in 2038 to continue Pavement Mgmt Program
<br />21 year interest earnings of:5,156,207.86
<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 />Revenues
<br />Expenditures
<br />Reserve Balance
<br />Pavement Management Program
|