|
Pavement Management Program
<br />Scenario 7- Preservation of $10M endowment with 3% interest
<br />Year
<br />2014
<br />2015
<br />2016
<br />2017
<br />2018
<br />2019
<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 />Add'I Levy Total Levy
<br />150,000.00
<br />160,000.00
<br />160, 000.00
<br />200,000.00
<br />110,000.00
<br />110,000.00
<br />110,000.00
<br />23,200.00
<br />23,664.00
<br />24,137.28
<br />24,620.03
<br />25,112.43
<br />25,614.67
<br />26,126.97
<br />26,649.51
<br />27,182.50
<br />27,726.15
<br />28,280.67
<br />28,846.28
<br />29,423.21
<br />30,011.67
<br />14,000,000.00
<br />160,000.00
<br />310,000.00
<br />470,000.00
<br />630,000.00
<br />830,000.00
<br />940,000.00
<br />1,050,000.00
<br />1,160,000.00
<br />1,183, 200.00
<br />1,206,864.00
<br />1,231,001.28
<br />1,255,62131
<br />1,280,733.73
<br />1,306,348.41
<br />1,332,475.37
<br />1,359,124.88
<br />1,386,307.38
<br />1,414,033.53
<br />1,442,314.20
<br />1,471,160.48
<br />1,500,583.69
<br />1,530,59537
<br />Revenues Expenditures Reserve Use Reserve Earnings
<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 />2,040,000.00
<br />2,150,000.00
<br />2,260,000.00
<br />2,283,200.00
<br />2,306,864.00
<br />2,331,001.28
<br />2,355,62131
<br />2,380,733.73
<br />2,406,348.41
<br />2,432,475.37
<br />2,459,124.88
<br />2,486,307.38
<br />2,514,033.53
<br />2,542,314.20
<br />2,571,160.48
<br />2,600,583.69
<br />2,630,595.37
<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,89932
<br />840,000.00
<br />732,000.00
<br />614,840.00
<br />498,536.80
<br />343,107.54
<br />278,569.69
<br />214,941.08
<br />152,239.90
<br />177,284.70
<br />202,830.39
<br />228,887.00
<br />255,464.74
<br />282,574.04
<br />310,225.52
<br />338,430.03
<br />367,198.63
<br />396,542.60
<br />426,473.45
<br />457,002.92
<br />488,142.98
<br />519,905.84
<br />552,303.96
<br />334,800.00
<br />322,884.00
<br />314,125.32
<br />308,592.98
<br />307,557.54
<br />308,427.17
<br />311,231.76
<br />316,001.51
<br />320,163.02
<br />323,683.00
<br />326,526.88
<br />328,658.74
<br />330,041.28
<br />330,635.75
<br />330,401.93
<br />329,298.02
<br />327,280.69
<br />324,304.90
<br />320,323.96
<br />315,289.39
<br />309,150.90
<br />301,856.31
<br />Attachment B4 Appendix
<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,589,332.99
<br />10,685,623.66
<br />10,849,385.27
<br />10,992,263.59
<br />11,113,116.19
<br />11,210,756.07
<br />11,283,950.06
<br />11,331,417.31
<br />11,351,827.54
<br />11,343,799.44
<br />11,305,898.84
<br />11,236,636.92
<br />11,134,468.37
<br />10,997,789.42
<br />10,824,935.83
<br />10, 614,180.89
<br />10,363,733.24
<br />12,000,000.00 -
<br />10,000,000.00 -
<br />8,000,000.00
<br />� Revenues
<br />6,000,000.00
<br />4,000,000.00 -
<br />2,000,000.00 -
<br />0.00 .:_ ,
<br />'Yb 'yh 'y�° 1'� 'y� 'y� 'LO 'L�' 'L'1' 'L"� 'L0� 'Lh 'L�o 'L'� 'L0 'L� "�O "��' '�i'l' "�"� "�D� 35 "��°
<br />,ti0 ,ti0 ,ti0 ,y0 ,ti0 ,y0 ,y0 ,ti0 ,ti0 ,ti0 ,y0 ,ti0 ,y0 ,ti0 ,y0 ,ti0 ,ti0 ,ti0 ,y0 ,ti0 ,ti0 ,ti0 ,ti0
<br />Assumptions: MSA funds of $1.1M received every year
<br />Expendituresincrease at 2% peryear
<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:
<br />22 year interest earnings of: 7,041,235.05
<br />Interest earnings of $300K every year into perpetuity
<br />� Expenditures
<br />—Reserve Balance
<br />Levy Expenditure
<br />Coverege %
<br />7.6 %
<br />14.5%
<br />21.5 %
<br />283%
<br />36.5 %
<br />40.5%
<br />44.4%
<br />48.1%
<br />48.1 %
<br />48.1%
<br />48.1%
<br />48.1%
<br />48.1 %
<br />48.1%
<br />48.1%
<br />48.1%
<br />48.1%
<br />48.1%
<br />48.1%
<br />48.1%
<br />48.1%
<br />48.1%
<br />
|