|
Scenario 3- Medium-term levy increases with 3% 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 />160, 000.00
<br />160, 000.00
<br />100,000.00
<br />100, 000.00
<br />100,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 />790,000.00
<br />950,000.00
<br />1,050,000.00
<br />1,150,000.00
<br />1,250,000.00
<br />1,250,000.00
<br />1,250,000.00
<br />1,250,000.00
<br />1,250,000.00
<br />1,250,000.00
<br />1,250,000.00
<br />1,250,000.00
<br />1,250,000.00
<br />1,250,000.00
<br />1,250,000.00
<br />1,250,000.00
<br />1,250,000.00
<br />1,250,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,890,000.00
<br />2,050,000.00
<br />2,150,000.00
<br />2,250,000.00
<br />2,350,000.00
<br />2,350,000.00
<br />2,350,000.00
<br />2,350,000.00
<br />2,350,000.00
<br />2,350,000.00
<br />2,350,000.00
<br />2,350,000.00
<br />2,350,000.00
<br />2,350,000.00
<br />2,350,000.00
<br />2,350,000.00
<br />2,350,000.00
<br />2,350,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 />383,107.54
<br />268,569.69
<br />214,941.08
<br />162,239.90
<br />110,484.70
<br />159,694.39
<br />209,888.28
<br />261,086.05
<br />313,307.77
<br />366,573.92
<br />420,905.40
<br />476,323.51
<br />532,849.98
<br />590,506.98
<br />649,317.12
<br />709,303.46
<br />770,489.53
<br />832,899.32
<br />Reserve Earnings
<br />334,800.00
<br />322,884.00
<br />314,125.32
<br />308,592.98
<br />306,357.54
<br />307,491.17
<br />310,267.68
<br />314,708.51
<br />320,835.22
<br />325,669.45
<br />329,142.88
<br />331,184.59
<br />331,720.89
<br />330,675.30
<br />327,968.40
<br />323,517.75
<br />317,237J8
<br />309,039.70
<br />298,831.38
<br />286,517.22
<br />271,998.05
<br />255,171.01
<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 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: 6,878,736.84
<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,518,275.50
<br />10, 557,196.99
<br />10,652,523.58
<br />10,804,992.19
<br />11,015,342.72
<br />11,181,317.77
<br />11,300,572.37
<br />11,370,670.92
<br />11,389,084.04
<br />11, 353,185.42
<br />11,260,248.42
<br />11,107,442.66
<br />10,891,830.46
<br />10,610,363.18
<br />10,259,877.44
<br />9,837,091.20
<br />9,338,599.72
<br />8,760,871.41
<br />� Revenues
<br />� Expenditures
<br />—Reserve Balance
<br />Levy Expenditure
<br />Coverage %
<br />7.6%
<br />14.5 %
<br />21.5%
<br />283 %
<br />34.8%
<br />41.0 %
<br />44.4%
<br />47.7%
<br />50.8%
<br />49.8%
<br />48.8%
<br />47.9%
<br />46.9%
<br />46.0 %
<br />45.1%
<br />44.2 %
<br />43.4%
<br />42.5%
<br />41.7%
<br />40.9%
<br />40.1%
<br />393%
<br />
|