|
Scenario 9 - Current "Revised" Plan, plus $400K one-time infusion & 2/3 of Park Dedication future revenues Park Improvement Program
<br />Year
<br /> Add'l Levy or
<br />Other Total Levy Expenditures Reserve Use Reserve Earnings Reserve Balance
<br />Levy Expenditure
<br />Coverage %
<br />2017 552,000.00
<br />2018 113,333.33 313,333.33 300,000.00 - 16,960.00 568,960.00 104.4%
<br />2019 313,333.33 1,185,880.00 872,546.67 - 96,413.33 26.4%
<br />2020 313,333.33 765,000.00 451,666.67 - (355,253.33) 41.0%
<br />2021 650,000.00 963,333.33 780,000.00 - - (171,920.00) 123.5%
<br />2022 963,333.33 638,000.00 - - 153,413.33 151.0%
<br />2023 963,333.33 1,661,500.00 698,166.67 - (544,753.33) 58.0%
<br />2024 963,333.33 520,000.00 - - (101,420.00) 185.3%
<br />2025 963,333.33 539,070.00 - - 322,843.33 178.7%
<br />2026 963,333.33 830,000.00 - 13,685.30 469,861.97 116.1%
<br />2027 963,333.33 720,000.00 - 21,395.86 734,591.16 133.8%
<br />2028 963,333.33 640,000.00 - 31,737.73 1,089,662.23 150.5%
<br />2029 963,333.33 488,500.00 - 46,934.87 1,611,430.43 197.2%
<br />2030 963,333.33 1,042,500.00 79,166.67 45,967.91 1,578,231.67 92.4%
<br />2031 963,333.33 516,670.00 - 60,746.85 2,085,641.86 186.5%
<br />2032 963,333.33 728,000.00 - 69,629.26 2,390,604.45 132.3%
<br />2033 963,333.33 677,500.00 - 80,293.13 2,756,730.91 142.2%
<br />2034 963,333.33 1,010,000.00 46,666.67 81,301.93 2,791,366.17 95.4%
<br />2035 963,333.33 1,145,000.00 181,666.67 78,290.99 2,687,990.49 84.1%
<br />2036 963,333.33 955,000.00 - 80,889.71 2,777,213.54 100.9%
<br />2037 963,333.33 365,000.00 - 101,266.41 3,476,813.28 263.9%
<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 />Defer some planned expenditure to ensure a stronger likelihood of positive cash flows in the next five 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 />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 />-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 />3,000,000.00
<br />3,500,000.00
<br />4,000,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 />Item 6: Attachment A
<br />3
|