|
Scenario 9 - Current "Revised" Plan, plus $400K one-time infusion & 2/3 of Park Dedication future revenues
<br />Year Add'l Levy Total Levy Expenditures Reserve Use Reserve Earnings Reserve Balance
<br />Levy Expenditure
<br />Coverage %
<br />2016 462,000.00
<br />2017 113,333.33 313,333.33 200,000.00 - 17,260.00 479,260.00 156.7%
<br />2018 313,333.33 2,092,090.00 1,778,756.67 - (899,496.67) 15.0%
<br />2019 313,333.33 1,111,290.00 797,956.67 - (1,697,453.33) 28.2%
<br />2020 650,000.00 963,333.33 1,304,000.00 340,666.67 - (2,038,120.00) 73.9%
<br />2021 963,333.33 615,000.00 - - (1,689,786.67) 156.6%
<br />2022 963,333.33 779,250.00 - - (1,505,703.33) 123.6%
<br />2023 963,333.33 806,500.00 - - (1,348,870.00) 119.4%
<br />2024 963,333.33 630,000.00 - - (1,015,536.67) 152.9%
<br />2025 963,333.33 732,570.00 - - (784,773.33) 131.5%
<br />2026 963,333.33 618,000.00 - - (439,440.00) 155.9%
<br />2027 963,333.33 585,000.00 - - (61,106.67) 164.7%
<br />2028 963,333.33 641,500.00 - - 260,726.67 150.2%
<br />2029 963,333.33 697,500.00 - 15,796.80 542,356.80 138.1%
<br />2030 963,333.33 1,325,250.00 361,916.67 5,413.20 185,853.34 72.7%
<br />2031 963,333.33 731,670.00 - 12,525.50 430,042.17 131.7%
<br />2032 963,333.33 828,000.00 - 16,961.27 582,336.77 116.3%
<br />2033 963,333.33 710,000.00 - 25,070.10 860,740.21 135.7%
<br />2034 963,333.33 914,000.00 - 27,302.21 937,375.75 105.4%
<br />2035 963,333.33 619,000.00 - 38,451.27 1,320,160.35 155.6%
<br />2036 963,333.33 649,950.00 - 49,006.31 1,682,549.99 148.2%
<br />Assumptions:
<br />2020 levy increase is a repurpose of bond issuance #27
<br />Added $400K to Reserve Balance in 2016
<br />Added 2/3 of 10 yr average of $170K to Levy, which is just revenue
<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 />5,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 />-2,500,000.00
<br />-2,000,000.00
<br />-1,500,000.00
<br />-1,000,000.00
<br />-500,000.00
<br />0.00
<br />500,000.00
<br />1,000,000.00
<br />1,500,000.00
<br />2,000,000.00
<br />2,500,000.00
<br />1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
<br />Total Levy
<br />Expenditures
<br />Reserve Balance
<br />Park Improvement Program
|