|
Scenario 3- Expenditures at 75%
<br />Year Add'I Levy
<br />2014
<br />2015
<br />2016 160,000.00
<br />2017
<br />2018
<br />2019
<br />2020 650,000.00
<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.0(
<br />500,000.0(
<br />0.0(
<br />-500,000.0(
<br />-1,000,000.0(
<br />-1,500,000.0(
<br />-2,000,000.0(
<br />-2,500,000.0(
<br />-3,000,000.0(
<br />TotalLevy
<br />40,000.00
<br />200,000.00
<br />200,000.00
<br />200,000.00
<br />200,000.00
<br />850,000.00
<br />850,000.00
<br />850,000.00
<br />850,000.00
<br />850,000.00
<br />850,000.00
<br />850,000.00
<br />850,000.00
<br />850,000.00
<br />850,000.00
<br />850,000.00
<br />850,000.00
<br />850,000.00
<br />850,000.00
<br />850,000.00
<br />850,000.00
<br />Attachment B4 Appendix
<br />Levy Expenditure
<br />Expenditures Reserve Use Reserve Earnings Reserve Balance Coverage %
<br />799,000.00
<br />600,000.00 560,000.00 7,170.00 246,170.00 6.7%
<br />654,877.50 246,170.00 (208,707.50) 30.5%
<br />955,215.00 (963,922.50) 20.9%
<br />966,975.00 (1,730,897.50) 20.7%
<br />728,467.50 (2,259,365.00) 27.5%
<br />1,020,375.00 (2,429,740.00) 83.3%
<br />558,750.00 (2,138,490.00) 152.1%
<br />753,187.50 (2,041,677.50) 112.9%
<br />721,125.00 (1,912,802.50) 117.9%
<br />660,000.00 (1,722,802.50) 128.8%
<br />695,677.50 (1,568,480.00) 122.2%
<br />576,000.00 (1,294,480.00) 147.6%
<br />701,250.00 (1,145,730.00) 121.2%
<br />668,625.00 (964,355.00) 127.1%
<br />579,375.00 (693,730.00) 146.7%
<br />1,190,062.50 (1,033,792.50) 71.4%
<br />548,752.50 (732,545.00) 154.9%
<br />771,000.00 (653,545.00) 110.2%
<br />551,250.00 (354,795.00) 154.2%
<br />704,250.00 (209,045.00) 120.7%
<br />704,250.00 (63,295.00) 120.7%
<br />Assumptions: 2016 levy increase is a tax increase
<br />2020 levy increase is a repurpose of bond issuance #27
<br />Results: Solves itself over 20 years, CIP shortful during middle years
<br />
|