|
Scenario 8- Preservation of $lOM endowment with 5% 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 />15,000.00
<br />15,000.00
<br />15,000.00
<br />15,000.00
<br />15,000.00
<br />15,000.00
<br />15,000.00
<br />15,000.00
<br />15,000.00
<br />15,000.00
<br />15,000.00
<br />20,000.00
<br />20,000.00
<br />20,000.00
<br />20,000.00
<br />20,000.00
<br />20,000.00
<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 />160,000.00
<br />310,000.00
<br />470,000.00
<br />630,000.00
<br />830,000.00
<br />845,000.00
<br />860,000.00
<br />875,000.00
<br />890,000.00
<br />905,000.00
<br />920,000.00
<br />935,000.00
<br />950,000.00
<br />965,000.00
<br />980,000.00
<br />995,000.00
<br />1,015,000.00
<br />1,035,000.00
<br />1,055,000.00
<br />1,075,000.00
<br />1,095,000.00
<br />1,115,000.00
<br />Revenues Expenditures Reserve Use
<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,945,000.00
<br />1,960,000.00
<br />1,975,000.00
<br />1,990,000.00
<br />2,005,000.00
<br />2,020,000.00
<br />2,035,000.00
<br />2,050,000.00
<br />2,065,000.00
<br />2,080,000.00
<br />2,095,000.00
<br />2,115,000.00
<br />2,135,000.00
<br />2,155,000.00
<br />2,175,000.00
<br />2,195,000.00
<br />2,215,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 />373,569.69
<br />404,941.08
<br />437,239.90
<br />470,484.70
<br />504,694.39
<br />539,888.28
<br />576,086.05
<br />613,307.77
<br />651,573.92
<br />690,905.40
<br />731,323.51
<br />767,849.98
<br />805,506.98
<br />844,317.12
<br />884,303.46
<br />925,489.53
<br />967,899.32
<br />Reserve Earnings
<br />558,000.00
<br />549,300.00
<br />546,023.00
<br />548,397.31
<br />558,661.80
<br />567,916.40
<br />576,065.17
<br />583,006.43
<br />588,632.52
<br />592,829.43
<br />595,476.48
<br />596,446.01
<br />595,602.92
<br />592,804.37
<br />587,899.32
<br />580,728.11
<br />571,372.01
<br />559,665.26
<br />545,432.67
<br />528,489.13
<br />508,639.11
<br />485,676.10
<br />,yR ,y`' ,y�o ,y1 ,y4� ,y� .�,° ,ti'y �,'L .�,'' �,P ,ti`' �,6 ,y1 ,ti'b ,yoi .�° ,�'v ,�'L 3'' .�° ,y`' ,��0
<br />,LO ,y0 ,ti0 ,y0 ,LO ,y0 ,y0 ,ti0 ,y0 ,ti0 ,y0 ,ti0 ,y0 ,ti0 ,y0 ,ti0 ,y0 ,ti0 ,LO ,ti0 ,ti0 ,ti0 ,ti0
<br />Assumptions: MSA funds of $1.1M received every year
<br />Expendituresincrease at 2% peryear
<br />Reserve Earnings of 5%
<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 yearinterestearnings of: 12,417,063.55
<br />Interest earning of $486K every year into perpetuity
<br />Attachment B4 Appendix
<br />Reserve Balance
<br />12,000,000.00
<br />11,718,000.00
<br />11,535,300.00
<br />11,466,483.00
<br />11,516,343.51
<br />11,731,897.77
<br />11,926,244.49
<br />12,097,368.58
<br />12, 243,135.11
<br />12,361,282.93
<br />12,449,417.97
<br />12,505,006.17
<br />12,525,366.13
<br />12,507,661.28
<br />12,448,891.72
<br />12,345,885.63
<br />12,195,290.23
<br />11,998,812.26
<br />11,752,970.54
<br />11,454,086.09
<br />11,098,271.76
<br />10,681,421.34
<br />10,199,198.12
<br />� Revenues
<br />� Expenditures
<br />—Reserve Balance
<br />Levy Expenditure
<br />Coverage %
<br />7.6%
<br />14.5 %
<br />21.5%
<br />283 %
<br />36.5%
<br />36.4 %
<br />36.4%
<br />36.3%
<br />36.2%
<br />36.1 %
<br />35.9%
<br />35.8%
<br />35.7%
<br />35.5 %
<br />35.4%
<br />35.2%
<br />35.2%
<br />35.2%
<br />35.2%
<br />35.1%
<br />35.1%
<br />35.0%
<br />
|