|
Scenario S- Oval Expenditure at 50%
<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 />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 />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,272,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 />586,133.85
<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 />(718,832.94) 40.9%
<br />(758,832.94) 92.9%
<br />(973,032.94) 70.8%
<br />(1,235,932.94) 66.4%
<br />(1,014,332.94) 174.3%
<br />(1,232,832.94) 70.4%
<br />(779,832.94) 776.1%
<br />(308,432.94) 1070.0%
<br />2,597.01 89,164.07 416.0%
<br />6,097.92 209,361.99 128.1%
<br />17,071.86 586,133.85 324.4%
<br />(100,266.15) 43.1%
<br />(39,266.15) 113.3%
<br />(8,266.15) 106.3%
<br />2,167.02 74,400.87 118.3%
<br />12,207.03 419,107.90 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 50% of $2.1M Oval Expenditure in 2020
<br />Reserve earnings of $60K in 20 years
<br />
|