|
Scenario 6- Long-term levy increases with 5% interest earnings
<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 />120,000.00
<br />100, 000.00
<br />100,000.00
<br />100, 000.00
<br />100,000.00
<br />50,000.00
<br />50,000.00
<br />50,000.00
<br />50,000.00
<br />50,000.00
<br />50,000.00
<br />50,000.00
<br />50,000.00
<br />50,000.00
<br />50,000.00
<br />50,000.00
<br />50,000.00
<br />50,000.00
<br />25,000,000.00
<br />20,000,000.00
<br />15,000,000.00
<br />160,000.00
<br />310,000.00
<br />470,000.00
<br />630,000.00
<br />750,000.00
<br />850,000.00
<br />950,000.00
<br />1,050,000.00
<br />1,150,000.00
<br />1,200,000.00
<br />1,250,000.00
<br />1,300,000.00
<br />1,350,000.00
<br />1,400,000.00
<br />1,450,000.00
<br />1,500,000.00
<br />1,550,000.00
<br />1,600,000.00
<br />1,650,000.00
<br />1,700,000.00
<br />1,750,000.00
<br />1,800,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,850,000.00
<br />1,950,000.00
<br />2,050,000.00
<br />2,150,000.00
<br />2,250,000.00
<br />2,300,000.00
<br />2,350,000.00
<br />2,400,000.00
<br />2,450,000.00
<br />2,500,000.00
<br />2,550,000.00
<br />2,600,000.00
<br />2,650,000.00
<br />2,700,000.00
<br />2,750,000.00
<br />2,800,000.00
<br />2,850,000.00
<br />2,900,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 />423,107.54
<br />368,569.69
<br />314,941.08
<br />262,239.90
<br />210,484.70
<br />209,694.39
<br />209,888.28
<br />211,086.05
<br />213,307.77
<br />216,573.92
<br />220,905.40
<br />226,323.51
<br />232,849.98
<br />240,506.98
<br />249,317.12
<br />259,303.46
<br />270,489.53
<br />282,899.32
<br />Reserve Earnings
<br />558,000.00
<br />549,300.00
<br />546,023.00
<br />548,397.31
<br />554,661.80
<br />563,966.40
<br />576,417.67
<br />592,126.56
<br />611,208.65
<br />631,284.36
<br />652,354.17
<br />674,417.57
<br />697,473.07
<br />721,518.02
<br />746,548.65
<br />772,559.91
<br />799,545.41
<br />827,497.33
<br />856,406.34
<br />886,261.48
<br />917,050.08
<br />948,757.62
<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,647,897.77
<br />11,843,294.49
<br />12,104, 771.08
<br />12,434,657.74
<br />12,835,381.69
<br />13,256,971.66
<br />13,699,437.55
<br />14,162, 769.07
<br />14,646,934.37
<br />15,151, 878.47
<br />15,677,521.72
<br />16,223,758.12
<br />16,790,453.55
<br />17,377,443.89
<br />17,984,533.11
<br />18,611,491.13
<br />19,258,051.68
<br />19,923,909.98
<br />� Revenues
<br />� Expenditures
<br />10,000,000.00 •
<br />—Reserve Balance
<br />5,000,000.00
<br />o ao _�_ d: i d i, d_ �_M �_-� �_ � d �, ��_���. �_ b. �
<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 yearinterest earnings of: 14,283,017.79
<br />Endowment continues growing
<br />Levy Expenditure
<br />Coverage %
<br />7.6%
<br />14.5 %
<br />21.5%
<br />28.3 %
<br />33.0%
<br />36.7 %
<br />40.2%
<br />43.5%
<br />46.7%
<br />47.8%
<br />48.8%
<br />49.8%
<br />50.7%
<br />51.5 %
<br />523%
<br />53.1%
<br />53.8%
<br />54.4%
<br />55.0%
<br />55.6%
<br />56.1%
<br />56.6%
<br />
|