Scenario 2 - Expenditures at 50%
<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 100,000.00 - 4,860.00 66,860.00 200.0%
<br />2018 200,000.00 1,046,045.00 846,045.00 - (779,185.00) 19.1%
<br />2019 200,000.00 555,645.00 355,645.00 - (1,134,830.00) 36.0%
<br />2020 650,000.00 850,000.00 652,000.00 - - (936,830.00) 130.4%
<br />2021 850,000.00 307,500.00 - - (394,330.00) 276.4%
<br />2022 850,000.00 389,625.00 - - 66,045.00 218.2%
<br />2023 850,000.00 403,250.00 - 15,383.85 528,178.85 210.8%
<br />2024 850,000.00 315,000.00 - 31,895.37 1,095,074.22 269.8%
<br />2025 850,000.00 366,285.00 - 47,363.68 1,626,152.89 232.1%
<br />2026 850,000.00 309,000.00 - 65,014.59 2,232,167.48 275.1%
<br />2027 850,000.00 292,500.00 - 83,690.02 2,873,357.50 290.6%
<br />2028 850,000.00 320,750.00 - 102,078.23 3,504,685.73 265.0%
<br />2029 850,000.00 348,750.00 - 120,178.07 4,126,113.80 243.7%
<br />2030 850,000.00 662,625.00 - 129,404.66 4,442,893.46 128.3%
<br />2031 850,000.00 365,835.00 - 147,811.75 5,074,870.22 232.3%
<br />2032 850,000.00 414,000.00 - 165,326.11 5,676,196.32 205.3%
<br />2033 850,000.00 355,000.00 - 185,135.89 6,356,332.21 239.4%
<br />2034 850,000.00 457,000.00 - 202,479.97 6,951,812.18 186.0%
<br />2035 850,000.00 309,500.00 - 224,769.37 7,717,081.55 274.6%
<br />2036 850,000.00 324,975.00 - 247,263.20 8,489,369.74 261.6%
<br />Assumptions:
<br />2020 levy increase is a repurpose of bond issuance #27
<br />Results: After temporary deficit, will accumulate $1.8M in reserve earnings in next 20 years
<br />-2,000,000.00
<br />0.00
<br />2,000,000.00
<br />4,000,000.00
<br />6,000,000.00
<br />8,000,000.00
<br />10,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
|