Golf Vehicle & Equipment Fund
<br />Scenario 1 - Current CIP Plan
<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,026,000.00 1,026,000.00 - (902,739.90) 0.0%
<br />2019 - 88,000.00 88,000.00 - (990,739.90) 0.0%
<br />2020 - 45,000.00 45,000.00 - (1,035,739.90) 0.0%
<br />2021 - 55,000.00 55,000.00 - (1,090,739.90) 0.0%
<br />2022 - 261,000.00 261,000.00 - (1,351,739.90) 0.0%
<br />2023 - 53,000.00 53,000.00 - (1,404,739.90) 0.0%
<br />2024 - 70,000.00 70,000.00 - (1,474,739.90) 0.0%
<br />2025 - 27,500.00 27,500.00 - (1,502,239.90) 0.0%
<br />2026 - 10,000.00 10,000.00 - (1,512,239.90) 0.0%
<br />2027 - 22,000.00 22,000.00 - (1,534,239.90) 0.0%
<br />2028 - 88,000.00 88,000.00 - (1,622,239.90) 0.0%
<br />2029 - 35,000.00 35,000.00 - (1,657,239.90) 0.0%
<br />2030 - 23,800.00 23,800.00 - (1,681,039.90) 0.0%
<br />2031 - 22,500.00 22,500.00 - (1,703,539.90) 0.0%
<br />2032 - -- - (1,703,539.90) #DIV/0!
<br />2033 - 62,000.00 62,000.00 - (1,765,539.90) 0.0%
<br />2034 - 30,000.00 30,000.00 - (1,795,539.90) 0.0%
<br />2035 - 10,000.00 10,000.00 - (1,805,539.90) 0.0%
<br />2036 - 10,000.00 10,000.00 - (1,815,539.90) 0.0%
<br />Assumptions:
<br />-3,500,000.00
<br />-3,000,000.00
<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 />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 />Golf Vehicle & Equipment Program
|