Scenario 5 - Expenditures at 90%
<br />Year Add'l Levy Total Levy Expenditures Reserve Use Reserve Earnings Reserve Balance
<br />Levy Expenditure
<br />Coverage %
<br />2016 72,000.00
<br />2017 212,000.00 152,280.00 - 3,951.60 135,671.60 139.2%
<br />2018 - 212,000.00 794,250.00 582,250.00 - (446,578.40) 26.7%
<br />2019 335,000.00 547,000.00 372,420.00 - - (271,998.40) 146.9%
<br />2020 - 547,000.00 2,027,700.00 1,480,700.00 - (1,752,698.40) 27.0%
<br />2021 - 547,000.00 621,000.00 74,000.00 - (1,826,698.40) 88.1%
<br />2022 - 547,000.00 660,780.00 113,780.00 - (1,940,478.40) 82.8%
<br />2023 - 547,000.00 828,270.00 281,270.00 - (2,221,748.40) 66.0%
<br />2024 - 547,000.00 201,060.00 - - (1,875,808.40) 272.1%
<br />2025 - 547,000.00 792,900.00 245,900.00 - (2,121,708.40) 69.0%
<br />2026 - 547,000.00 60,300.00 - - (1,635,008.40) 907.1%
<br />2027 - 547,000.00 70,740.00 - - (1,158,748.40) 773.3%
<br />2028 - 547,000.00 330,300.00 - - (942,048.40) 165.6%
<br />2029 - 547,000.00 386,910.00 - - (781,958.40) 141.4%
<br />2030 - 547,000.00 77,670.00 - - (312,628.40) 704.3%
<br />2031 - 547,000.00 1,065,510.00 518,510.00 - (831,138.40) 51.3%
<br />2032 - 547,000.00 368,100.00 - - (652,238.40) 148.6%
<br />2033 - 547,000.00 520,200.00 - - (625,438.40) 105.2%
<br />2034 - 547,000.00 377,550.00 - - (455,988.40) 144.9%
<br />2035 - 547,000.00 194,850.00 - - (103,838.40) 280.7%
<br />2036 - 547,000.00 326,700.00 - - 116,461.60 167.4%
<br />Assumptions: Reserve Earnings of 3%
<br />2019 Levy increase is repurpose of bond issuance
<br />All expenditures are at 90% of existing CIP
<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 />20
<br />1
<br />6
<br />20
<br />1
<br />7
<br />20
<br />1
<br />8
<br />20
<br />1
<br />9
<br />20
<br />2
<br />0
<br />20
<br />2
<br />1
<br />20
<br />2
<br />2
<br />20
<br />2
<br />3
<br />20
<br />2
<br />4
<br />20
<br />2
<br />5
<br />20
<br />2
<br />6
<br />20
<br />2
<br />7
<br />20
<br />2
<br />8
<br />20
<br />2
<br />9
<br />20
<br />3
<br />0
<br />20
<br />3
<br />1
<br />20
<br />3
<br />2
<br />20
<br />3
<br />3
<br />20
<br />3
<br />4
<br />20
<br />3
<br />5
<br />20
<br />3
<br />6
<br />Total Levy
<br />Expenditures
<br />Reserve Balance
<br />General Facilities Program
|