Scenario 4 - Expenditures at 75%, cash flow smoothing
<br />Year Add'l Levy Total Levy Expenditures Reserve Use Reserve Earnings Reserve Balance
<br />Levy Expenditure
<br />Coverage %
<br />2016 62,000.00
<br />2017 150,000.00 350,000.00 150,000.00 - 7,860.00 69,860.00 233.3%
<br />2018 150,000.00 500,000.00 1,569,067.50 1,069,067.50 - (999,207.50) 31.9%
<br />2019 500,000.00 833,467.50 333,467.50 - (1,332,675.00) 60.0%
<br />2020 650,000.00 1,150,000.00 978,000.00 - - (1,160,675.00) 117.6%
<br />2021 1,150,000.00 461,250.00 - - (471,925.00) 249.3%
<br />2022 1,150,000.00 584,437.50 - - 93,637.50 196.8%
<br />2023 1,150,000.00 604,875.00 - 19,162.88 657,925.38 190.1%
<br />2024 (450,000.00) 700,000.00 472,500.00 - 26,562.76 911,988.14 148.1%
<br />2025 700,000.00 549,427.50 - 31,876.82 1,094,437.46 127.4%
<br />2026 700,000.00 463,500.00 - 39,928.12 1,370,865.58 151.0%
<br />2027 700,000.00 438,750.00 - 48,963.47 1,681,079.05 159.5%
<br />2028 700,000.00 481,125.00 - 56,998.62 1,956,952.67 145.5%
<br />2029 700,000.00 523,125.00 - 64,014.83 2,197,842.50 133.8%
<br />2030 700,000.00 993,937.50 293,937.50 57,117.15 1,961,022.15 70.4%
<br />2031 700,000.00 548,752.50 - 63,368.09 2,175,637.74 127.6%
<br />2032 700,000.00 621,000.00 - 67,639.13 2,322,276.87 112.7%
<br />2033 700,000.00 532,500.00 - 74,693.31 2,564,470.18 131.5%
<br />2034 700,000.00 685,500.00 - 77,369.11 2,656,339.28 102.1%
<br />2035 700,000.00 464,250.00 - 86,762.68 2,978,851.96 150.8%
<br />2036 700,000.00 487,462.50 - 95,741.68 3,287,131.14 143.6%
<br />Assumptions: 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 />$818K in reserve earnings over 20 years
<br />-2,000,000.00
<br />-1,000,000.00
<br />0.00
<br />1,000,000.00
<br />2,000,000.00
<br />3,000,000.00
<br />4,000,000.00
<br />2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036
<br />Total Levy
<br />Expenditures
<br />Reserve Balance
<br />Park Improvement Program
|