|
Scenario 6- Oval Expenditure at 75%
<br />Year Add'I Levy
<br />2014
<br />2015
<br />2016 50,000.00
<br />2017 -
<br />2018 335,000.00
<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 />2,000,000.00
<br />1,500,000.00
<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 />Total Levy Expenditures Reserve Use
<br />135,000.00
<br />185,000.00
<br />185,000.00
<br />520,000.00
<br />520,000.00
<br />520,000.00
<br />520,000.00
<br />520,000.00
<br />520,000.00
<br />520,000.00
<br />520,000.00
<br />520,000.00
<br />520,000.00
<br />520,000.00
<br />520,000.00
<br />520,000.00
<br />520,000.00
<br />520,000.00
<br />520,000.00
<br />520,000.00
<br />520,000.00
<br />447,300.00
<br />637,500.00
<br />337,700.00
<br />569,000.00
<br />378,800.00
<br />1,797,000.00
<br />560,000.00
<br />734,200.00
<br />782,900.00
<br />298,400.00
<br />738,500.00
<br />67,000.00
<br />48,600.00
<br />125,000.00
<br />405,900.00
<br />160,300.00
<br />1,206,400.00
<br />459,000.00
<br />489,000.00
<br />439,500.00
<br />187,500.00
<br />312,300.00
<br />452,500.00
<br />92,701.03
<br />36,428.07
<br />Attachment B4 Appendix
<br />Levy Expenditure
<br />Reserve Earnings Reserve Balance Coverage %
<br />839,000.00
<br />15,801.00 542,501.00 30.2%
<br />2,700.03 92,701.03 29.0%
<br />(59,998.97) 54.8%
<br />(108,998.97) 91.4%
<br />966.03 33,167.06 137.3%
<br />(1,243,832.94) 28.9%
<br />(1,283,832.94) 92.9%
<br />(1,498,032.94) 70.8%
<br />(1,760,932.94) 66.4%
<br />(1,539,332.94) 174.3%
<br />(1,757,832.94) 70.4%
<br />(1,304,832.94) 776.1%
<br />(833,432.94) 1070.0%
<br />(438,432.94) 416.0%
<br />(324,332.94) 128.1%
<br />1,061.01 36,428.07 324.4%
<br />(649,971.93) 43.1%
<br />(588,971.93) 113.3%
<br />(557,971.93) 106.3%
<br />(477,471.93) 118.3%
<br />(144,971.93) 277.3%
<br />Assumptions: Reserve Earnings of 3%
<br />2016 Levy increase is tax increase
<br />2018 Levy increase is repurpose of bond issuance
<br />Pay 75% of $2.1M Oval Expenditure in 2020
<br />Reserve earnings of $60K in 20 years
<br />
|