|
Scenario 6 - Expenditures at 95%, no Oval Expenditure
<br />Year Add'l Levy Total Levy Expenditures Reserve Use Reserve Earnings Reserve Balance
<br />Levy Expenditure
<br />Coverage %
<br />2016 72,000.00
<br />2017 212,000.00 160,740.00 - 3,697.80 126,957.80 131.9%
<br />2018 - 212,000.00 838,375.00 626,375.00 - (499,417.20) 25.3%
<br />2019 335,000.00 547,000.00 393,110.00 - - (345,527.20) 139.1%
<br />2020 - 547,000.00 145,350.00 - - 56,122.80 376.3%
<br />2021 - 547,000.00 655,500.00 108,500.00 - (52,377.20) 83.4%
<br />2022 - 547,000.00 697,490.00 150,490.00 - (202,867.20) 78.4%
<br />2023 - 547,000.00 874,285.00 327,285.00 - (530,152.20) 62.6%
<br />2024 - 547,000.00 212,230.00 - - (195,382.20) 257.7%
<br />2025 - 547,000.00 836,950.00 289,950.00 - (485,332.20) 65.4%
<br />2026 - 547,000.00 63,650.00 - - (1,982.20) 859.4%
<br />2027 - 547,000.00 74,670.00 - - 470,347.80 732.6%
<br />2028 - 547,000.00 348,650.00 - 20,060.93 688,758.73 156.9%
<br />2029 - 547,000.00 408,405.00 - 24,820.61 852,174.35 133.9%
<br />2030 - 547,000.00 81,985.00 - 39,515.68 1,356,705.03 667.2%
<br />2031 - 547,000.00 1,124,705.00 577,705.00 23,370.00 802,370.03 48.6%
<br />2032 - 547,000.00 388,550.00 - 28,824.60 989,644.63 140.8%
<br />2033 - 547,000.00 549,100.00 2,100.00 29,626.34 1,017,170.97 99.6%
<br />2034 - 547,000.00 398,525.00 - 34,969.38 1,200,615.35 137.3%
<br />2035 - 547,000.00 205,675.00 - 46,258.21 1,588,198.56 266.0%
<br />2036 - 547,000.00 344,850.00 - 53,710.46 1,844,059.01 158.6%
<br />Assumptions: Reserve Earnings of 3%
<br />2019 Levy increase is repurpose of bond issuance
<br />All expenditures are at 95% of existing CIP. No Oval Expenditure.
<br />-1,000,000.00
<br />-500,000.00
<br />0.00
<br />500,000.00
<br />1,000,000.00
<br />1,500,000.00
<br />2,000,000.00
<br />Ye
<br />a
<br />r
<br />20
<br />1
<br />6
<br />20
<br />1
<br />7
<br />20
<br />1
<br />8
<br />20
<br />1
<br />9
<br />20
<br />2
<br />0
<br />20
<br />2
<br />1
<br />20
<br />2
<br />2
<br />20
<br />2
<br />3
<br />20
<br />2
<br />4
<br />20
<br />2
<br />5
<br />20
<br />2
<br />6
<br />20
<br />2
<br />7
<br />20
<br />2
<br />8
<br />20
<br />2
<br />9
<br />20
<br />3
<br />0
<br />20
<br />3
<br />1
<br />20
<br />3
<br />2
<br />20
<br />3
<br />3
<br />20
<br />3
<br />4
<br />20
<br />3
<br />5
<br />Total Levy
<br />Expenditures
<br />Reserve Balance
<br />General Facilities Program
|