|
Pavement Management Progrem
<br />Scenario 1- Short-term levy increases with 3% interest earnings
<br />Year Add'I Levy
<br />2014
<br />2015
<br />2016 150,000.00
<br />2017 160,000.00
<br />2018 160,000.00
<br />2019 200,000.00
<br />2020
<br />2021
<br />2022
<br />2023
<br />2024
<br />2025
<br />2026
<br />2027
<br />2028
<br />2029
<br />2030
<br />2031
<br />2032
<br />2033
<br />2034
<br />2035
<br />2036
<br />14,000,000.00 -----
<br />12,000,000.00
<br />10,000,000.00 -
<br />8,000,000.00 --
<br />6,000,000.00 '
<br />4,000,000.00 '-
<br />2,000,000.00 –
<br />0.00
<br />TotalLevy Revenues Expenditures Reserve Use Reserve Earnings
<br />160,000.00
<br />310,000.00
<br />470,000.00
<br />630,000.00
<br />830,000.00
<br />830,000.00
<br />830,000.00
<br />830,000.00
<br />830,000.00
<br />830,000.00
<br />830,000.00
<br />830,000.00
<br />830,000.00
<br />830,000.00
<br />830,000.00
<br />830,000.00
<br />830,000.00
<br />830,000.00
<br />830,000.00
<br />830,000.00
<br />830,000.00
<br />830,000.00
<br />1, 260,000.00
<br />1,410,000.00
<br />1,570,000.00
<br />1,730,000.00
<br />1,930,000.00
<br />1,930,000.00
<br />1,930,000.00
<br />1,930,000.00
<br />1,930,000.00
<br />1,930,000.00
<br />1,930,000.00
<br />1,930,000.00
<br />1,930,000.00
<br />1,930,000.00
<br />1,930,000.00
<br />1,930,000.00
<br />1,930,000.00
<br />1,930,000.00
<br />1,930,000.00
<br />1,930,000.00
<br />1, 930,000.00
<br />1,930,000.00
<br />2,100,000.00
<br />2,142,000.00
<br />2,184,840.00
<br />2,228,536.80
<br />2,273,107.54
<br />2,318,569.69
<br />2,364,941.08
<br />2,412,239.90
<br />2,460,484.70
<br />2,509,694.39
<br />2,559,888.28
<br />2,611,086.05
<br />2,663,307.77
<br />2,716,573.92
<br />2,770,905.40
<br />2,826,323.51
<br />2,882,849.98
<br />2,940,506.98
<br />2,999,317.12
<br />3,059,303.46
<br />3,120,489.53
<br />3,182,899.32
<br />840,000.00
<br />732,000.00
<br />614,840.00
<br />498,536.80
<br />343,107.54
<br />388,569.69
<br />434,941.08
<br />482,239.90
<br />530,484.70
<br />579,69439
<br />629,888.28
<br />681,086.05
<br />733,307.77
<br />786,573.92
<br />840,905.40
<br />896,323.51
<br />952,849.98
<br />1,010,506.98
<br />1,069,317.12
<br />1,129,303.46
<br />1,190,489.53
<br />1,252,89932
<br />334,800.00
<br />322,884.00
<br />314,125.32
<br />308,592.98
<br />307,557.54
<br />305,127.17
<br />301,232.76
<br />295,802.54
<br />288,762.08
<br />280,034.11
<br />269,538.48
<br />257,192.06
<br />242,908.59
<br />226,598.62
<br />208,169.42
<br />187,524.80
<br />164,565.04
<br />139,186.79
<br />111,282.88
<br />80,742.26
<br />47,449.84
<br />11,286.36
<br />Attachment B 1
<br />Reserve Balance
<br />12,000,000.00
<br />11,494,800.00
<br />11,085,684.00
<br />10,784,969.32
<br />10,595,025.50
<br />10,559,475.50
<br />10,476,032.99
<br />10,342,324.66
<br />10,155, 887.30
<br />9, 914,164.68
<br />9,614,504.40
<br />9,254,154.60
<br />8,830,260.61
<br />8,339,861.42
<br />7,779,886.12
<br />7,147,150.14
<br />6,438,351.43
<br />5,650,066.49
<br />4, 778, 746.30
<br />3, 820, 712.05
<br />2,772,150.85
<br />1,629,111.16
<br />387,498.19
<br />� Revenues
<br />� Expenditures '
<br />—Reserve Balance
<br />1a 1h 1�° 1� 1� 1°i 'L� 'L,1 'L•L 'L„� 'LA 'Lh 'y�O 'y� 'y`b 'y�' '�� '�•1 '�,ti '�,3 '�R '�5 '��° .
<br />,ti0 ,ti0 ,ti0 ,ti0 ,y0 ,ti0 .y0 ,ti0 ,ti0 ,ti0 ,ti0 ,y0 ,y0 ,y0 ,y0 ,y0 ,ti0 ,ti0 ,ti0 ,ti0 ,ti0 ,ti0 ,ti0 ��.
<br />Assumptions: MSA funds of $1.1M received every year
<br />Expenditures increase at 2% per year
<br />Reserve Earnings of 3%
<br />$160K in 2015 is repurpose of Street Bond Issue #25
<br />$150K in 2016 is repurpose of Street Bond Issue #23
<br />The rest of levy increases are additional tax levy
<br />Results: Will need a 1,252,899.32 levy increase plus inflation starting in 2037 to continue Pavement Mgmt Program
<br />No endowment remaining, loss of interest earnings of $335K annually
<br />22 year interest earnings of: 5,005,363.62
<br />Levy Expenditure
<br />Coverage %
<br />7.6 %
<br />14.5 %
<br />21.5%
<br />28.3 %
<br />36.5%
<br />35.8%
<br />35.1%
<br />34.4%
<br />33.7%
<br />33.1%
<br />32.4%
<br />31.8%
<br />31. Z%
<br />30.6%
<br />30.0%
<br />29.4%
<br />28.8 %
<br />28.2%
<br />27.7 %
<br />27.1 %
<br />26.6 %
<br />26.1 %
<br />
|