|
Scenario 2- Expenditures at 50%
<br />Year
<br />2014
<br />2015
<br />2016
<br />2017
<br />2018
<br />2019
<br />2020
<br />2021
<br />2022
<br />2023
<br />2024
<br />2025
<br />2026
<br />2027
<br />2028
<br />2029
<br />2030
<br />2031
<br />2032
<br />2033
<br />2034
<br />2035
<br />Add'I Levy Total Levy
<br />160,000.00
<br />650,000.00
<br />7,000,000.00
<br />6,000,000.00 -
<br />5,000,000.00
<br />4,000,000.00 --
<br />3,000,000.00
<br />2,000,000.00 --
<br />1,000,000.00 �
<br />0.00 • �
<br />Q,�"� 0,�'h �,y�
<br />-Z,000,000.00 ti '� '�
<br />-z,000,000.00 �-
<br />40,000.00
<br />200,000.00
<br />200,000.00
<br />200,000.00
<br />200,000.00
<br />850,000.00
<br />850,000.00
<br />850,000.00
<br />850,000.00
<br />850,000.00
<br />850,000.00
<br />850,000.00
<br />850,000.00
<br />850,000.00
<br />850,000.00
<br />850,000.00
<br />850,000.00
<br />850,000.00
<br />850,000.00
<br />850,000.00
<br />850,000.00
<br />Expenditures Reserve Use
<br />600,000.00
<br />436,585.00
<br />636,810.00
<br />644,650.00
<br />485,645.00
<br />680,250.00
<br />372,500.00
<br />502,125.00
<br />480,750.00
<br />440,000.00
<br />463,785.00
<br />384,000.00
<br />467,500.00
<br />445,750.00
<br />386,250.00
<br />793,375.00
<br />365,835.00
<br />514,000.00
<br />367,500.00
<br />469,500.00
<br />469,500.00
<br />560,000.00
<br />236,585.00
<br />9,872.55
<br />Attachment B4 Appendix
<br />Levy Expenditure
<br />Reserve Earnings Reserve Balance Coverage %
<br />799,000.00
<br />7,170.00 246,170.00 6.7%
<br />287.55 9,872.55 45.8%
<br />(426,937.45) 31.4%
<br />(871,587.45) 31.0%
<br />(1,157,232.45) 41.2%
<br />(987,482.45) 125.0%
<br />(509,982.45) 228.2%
<br />(162,107.45) 1693%
<br />207,142.55 176.8%
<br />6,214.28 623,356.83 193.2%
<br />18, 700. 70 1, 028, 2 72. 5 3 18 3 3%
<br />30, 848.18 1, 525,120.71 2 21.4%
<br />45,753.62 1,953,374.33 181.8%
<br />58,601.23 2,416,225.56 190.7%
<br />72,486.77 2,952,462.33 220.1%
<br />88,573.87 3,097,661.19 107.1%
<br />92,929.84 3,674,756.03 2323%
<br />110,242.68 4,120,998.71 165.4%
<br />123,629.96 4,727,128.67 2313%
<br />141,813.86 5,249,442.53 181.0%
<br />157,483.28 5,787,425.81 181.0%
<br />� � �_,� �,�.�,� �._�,�
<br />ti� ti°` ti`' ti`O ti� ti� ti°' 3° 3ti �ti 3� 3°` �`'
<br />,yo �,o ,�o ,�o tio tio ,yo ,�o ,yo ,�o ,�o ,�o ,�o
<br />Assumptions: 2016 levy increase is a tax increase
<br />2020 levy increase is a repurpose of bond issuance #27
<br />Results: After temporary deficit, will accumulate $951K in reserve earnings in next 20 years
<br />�Total Levy
<br />� Expenditures i
<br />-Reserve Balance
<br />
|