|
Scenario 2 - Add one-time new clubhouse funding
<br />Year Add'l Levy Total Levy Expenditures Reserve Use Reserve Earnings Reserve Balance
<br />Levy
<br />Expenditure
<br />Coverage %
<br />2016 141,670.00
<br />2017 - 22,000.00 22,000.00 3,590.10 123,260.10 0.0%
<br />2018 1,000,000.00 1,026,000.00 26,000.00 2,917.80 100,177.90 97.5%
<br />2019 - 88,000.00 88,000.00 365.34 12,543.24 0.0%
<br />2020 - 45,000.00 45,000.00 - (32,456.76) 0.0%
<br />2021 - 55,000.00 55,000.00 - (87,456.76) 0.0%
<br />2022 - 261,000.00 261,000.00 - (348,456.76) 0.0%
<br />2023 - 53,000.00 53,000.00 - (401,456.76) 0.0%
<br />2024 - 70,000.00 70,000.00 - (471,456.76) 0.0%
<br />2025 - 27,500.00 27,500.00 - (498,956.76) 0.0%
<br />2026 - 10,000.00 10,000.00 - (508,956.76) 0.0%
<br />2027 - 22,000.00 22,000.00 - (530,956.76) 0.0%
<br />2028 - 88,000.00 88,000.00 - (618,956.76) 0.0%
<br />2029 - 35,000.00 35,000.00 - (653,956.76) 0.0%
<br />2030 - 23,800.00 23,800.00 - (677,756.76) 0.0%
<br />2031 - 22,500.00 22,500.00 - (700,256.76) 0.0%
<br />2032 - - - - (700,256.76) #DIV/0!
<br />2033 - 62,000.00 62,000.00 - (762,256.76) 0.0%
<br />2034 - 30,000.00 30,000.00 - (792,256.76) 0.0%
<br />2035 - 10,000.00 10,000.00 - (802,256.76) 0.0%
<br />2036 - 10,000.00 10,000.00 - (812,256.76) 0.0%
<br />Assumptions: $1M in new clubhouse funding in 2018
<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 />Year 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035
<br />Total Levy
<br />Expenditures
<br />Reserve Balance
<br />Golf Vehicle & Equipment Program
|