|
Scenario 3 - Add one-time new clubhouse funding
<br />Year New Revenue Total Revenue Expenditures Reserve Use Reserve Earnings Reserve Balance
<br />Levy
<br />Expenditure
<br />Coverage %
<br />2016 141,670.00
<br />2017 50,000.00 50,000.00 22,000.00 - 5,090.10 146,760.10 227.3%
<br />2018 1,050,000.00 1,026,000.00 - 5,122.80 175,882.90 102.3%
<br />2019 50,000.00 88,000.00 38,000.00 4,136.49 142,019.39 56.8%
<br />2020 50,000.00 45,000.00 - 4,410.58 151,429.97 111.1%
<br />2021 50,000.00 55,000.00 5,000.00 4,392.90 150,822.87 90.9%
<br />2022 50,000.00 261,000.00 211,000.00 - (60,177.13) 19.2%
<br />2023 50,000.00 53,000.00 3,000.00 - (63,177.13) 94.3%
<br />2024 50,000.00 70,000.00 20,000.00 - (83,177.13) 71.4%
<br />2025 50,000.00 27,500.00 - - (60,677.13) 181.8%
<br />2026 50,000.00 10,000.00 - - (20,677.13) 500.0%
<br />2027 50,000.00 22,000.00 - - 7,322.87 227.3%
<br />2028 50,000.00 88,000.00 38,000.00 - (30,677.13) 56.8%
<br />2029 50,000.00 35,000.00 - - (15,677.13) 142.9%
<br />2030 50,000.00 23,800.00 - - 10,522.87 210.1%
<br />2031 50,000.00 22,500.00 - 1,140.69 39,163.56 222.2%
<br />2032 50,000.00 - - 2,674.91 91,838.46 #DIV/0!
<br />2033 50,000.00 62,000.00 12,000.00 2,395.15 82,233.62 80.6%
<br />2034 50,000.00 30,000.00 - 3,067.01 105,300.63 166.7%
<br />2035 50,000.00 10,000.00 - 4,359.02 149,659.65 500.0%
<br />2036 50,000.00 10,000.00 - 5,689.79 195,349.43 500.0%
<br />Assumptions: $1M in new clubhouse funding in 2018
<br />Additional $50K in new revenue every year
<br />-200,000.00
<br />0.00
<br />200,000.00
<br />400,000.00
<br />600,000.00
<br />800,000.00
<br />1,000,000.00
<br />1,200,000.00
<br />Total Revenue
<br />Expenditures
<br />Reserve Balance
<br />Golf Vehicle & Equipment Program
|