|
Scenario 3 - Expenditures at 75%
<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 200,000.00 150,000.00 - 3,360.00 65,360.00 133.3%
<br />2018 200,000.00 1,569,067.50 1,369,067.50 - (1,303,707.50) 12.7%
<br />2019 200,000.00 833,467.50 633,467.50 - (1,937,175.00) 24.0%
<br />2020 650,000.00 850,000.00 978,000.00 128,000.00 - (2,065,175.00) 86.9%
<br />2021 850,000.00 461,250.00 - - (1,676,425.00) 184.3%
<br />2022 850,000.00 584,437.50 - - (1,410,862.50) 145.4%
<br />2023 850,000.00 604,875.00 - - (1,165,737.50) 140.5%
<br />2024 850,000.00 472,500.00 - - (788,237.50) 179.9%
<br />2025 850,000.00 549,427.50 - - (487,665.00) 154.7%
<br />2026 850,000.00 463,500.00 - - (101,165.00) 183.4%
<br />2027 850,000.00 438,750.00 - - 310,085.00 193.7%
<br />2028 850,000.00 481,125.00 - 20,368.80 699,328.80 176.7%
<br />2029 850,000.00 523,125.00 - 30,786.11 1,056,989.91 162.5%
<br />2030 850,000.00 993,937.50 143,937.50 27,391.57 940,443.99 85.5%
<br />2031 850,000.00 548,752.50 - 37,250.74 1,278,942.23 154.9%
<br />2032 850,000.00 621,000.00 - 45,238.27 1,553,180.50 136.9%
<br />2033 850,000.00 532,500.00 - 56,120.41 1,926,800.91 159.6%
<br />2034 850,000.00 685,500.00 - 62,739.03 2,154,039.94 124.0%
<br />2035 850,000.00 464,250.00 - 76,193.70 2,615,983.64 183.1%
<br />2036 850,000.00 487,462.50 - 89,355.63 3,067,876.77 174.4%
<br />Assumptions:
<br />2020 levy increase is a repurpose of bond issuance #27
<br />Results: More than solves itself over 20 years, CIP shortful during middle years
<br />-3,000,000.00
<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
|