|
Scenario 4- Expenditures at 75%, cash flow smoothing
<br />Year Add'I Levy
<br />2014
<br />2015
<br />2016 160,000.00
<br />2017 150,000.00
<br />2018 150,000.00
<br />2019
<br />2020 650,000.00
<br />2021
<br />2022
<br />2023
<br />2024 (450,000.00)
<br />2025
<br />2026
<br />2027
<br />2028
<br />2029
<br />2030
<br />2031
<br />2032
<br />2033
<br />2034
<br />2035
<br />TotalLevy
<br />40,000.00
<br />200,000.00
<br />350,000.00
<br />500,000.00
<br />500,000.00
<br />1,150,000.00
<br />1,150,000.00
<br />1,150,000.00
<br />1,150,000.00
<br />700,000.00
<br />700,000.00
<br />700,000.00
<br />700,000.00
<br />700,000.00
<br />700,000.00
<br />700,000.00
<br />700,000.00
<br />700,000.00
<br />700,000.00
<br />700,000.00
<br />700,000.00
<br />1,500,000.00
<br />1,000,000.00 -
<br />500,000.00
<br />0.00 - I
<br />� h
<br />,yoti ,yoti tio'' o°
<br />-500,000.00 -
<br />-1,000,000.00
<br />-1,500,000.00
<br />-2,000,000.00 I
<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 (813,922.50) 36.6%
<br />966,975.00 (1,280,897.50) 51.7%
<br />728,467.50 (1,509,365.00) 68.6%
<br />1,020,375.00 (1,379,740.00) 112.7%
<br />558,750.00 (788,490.00) 205.8%
<br />753,187.50 (391,677.50) 152.7%
<br />721,125.00 37,197.50 159.5%
<br />660,000.00 1,115.93 78,313.43 106.1%
<br />695,677.50 2,349.40 84,985.33 100.6%
<br />576,000.00 2,549.56 211,534.89 121.5%
<br />701,250.00 6,346.05 216,630.93 99.8%
<br />668,625.00 6,498.93 254,504.86 104.7%
<br />579,375.00 7,635.15 382,765.01 120.8%
<br />1,190,062.50 382,765.01 (107,297.49) 58.8%
<br />548,752.50 43,950.01 127.6%
<br />771,000.00 43,950.01 (27,049.99) 90.8%
<br />551,250.00 121,700.01 127.0%
<br />704,250.00 3,651.00 121,101.01 99.4%
<br />704,250.00 3,633.03 120,484.04 99.4%
<br />-- – , — `J- �� _ ..
<br />ti°` ti`' ti� ti� ti�' ti� 3° 3ti �ti 3"� �°` �`'
<br />,LO ,ti0 ,LO ,yo ,ti0 ,Lo ,y0 ,tio ,LO ,y0 ,yo ,LO
<br />Assumptions: 2016, 2017, & 2018 levy increases are a tax increase
<br />2020 levy increase is a repurpose of bond issuance #27
<br />2024 tax levy decrease
<br />$41K in reserve earnings over 20 years
<br />�Total Levy
<br />� Expenditures
<br />-Reserve Balance
<br />
|