Page 3 of 10
<br /> 35 Table Alb: Equipment Replacement Fund:
<br /> 36 (Yellow highlighting indicates lowest projected fund balance. All figures are in 2011 dollars.) Note that
<br /> 37 the actual current balance is$0, and the$750,000 figure in the table represents the recommended
<br /> 38 transfer of$750,000 into the fund from the General Fund.
<br /> 39
<br /> Starting
<br /> Sources Uses Bal: $750,000
<br /> New Sources Fund
<br /> Current Additional Additional Balance Unfunded
<br /> Depreciation Depreciation Depreciation Interest (Negative Resulting
<br /> (Property (Shift from (Property (Assume Projected Amount is Fund
<br /> Year Taxes) Operating) Tax) 4%) Costs _ Unfunded) Balance
<br /> 2012 $102,875 $115,000 $192,050 $30,000 $401,525 $38,400 $788,400
<br /> 2013 $102,875 $115,000 $192,050 $31,536 $687,925 ($246,464) $541,936
<br /> 2014 $102,875 $115,000 $192,050 $21,677 $486,925 ($55,323) $486,613
<br /> 2015 $102,875 $115,000 $192,050 $19,465 $407,025 $22,365 $508,978
<br /> 2016 $102,875 $115,000 $192,050 $20,359 $716,125 ($285,841) $223,137
<br /> 2017 $102,875 $115,000 $192,050 $8,925 $346,125 $72,725 $295,863
<br /> 2018 $102,875 $115,000 $192,050 $11,835 $532,425 ($110,665) $185,197
<br /> 2019 $102,875 $115,000 $192,050 $7,408 $292,125 $125,208 $310,405
<br /> 2020 $102,875 $115,000 $192,050 $12,416 $444,825 ($22,484) $287,921
<br /> 2021 $102,875 $115,000 $192,050 $11,517 $296,625 $124,817 $412,738
<br /> 2022 $102,875 $115,000 $192,050 $16,510 $279,125 $147,310 $560,048
<br /> 2023 $102,875 $115,000 $192,050 $22,402 $320,025 $112,302 $672,349
<br /> 2024 $102,875 $115,000 $192,050 $26,894 $362,725 $74,094 $746,443
<br /> 2025 $102,875 $115,000 $192,050 $29,858 $517,455 ($77,672) $668,771
<br /> 2026 $102,875 $115,000 $192,050 $26,751 $300,575 $136,101 $804,872
<br /> 2027 $102,875 $115,000 $192,050 $32,195 $741,025 ($298,905) $505,967
<br /> 2028 $102,875 $115,000 $192,050 $20,239 $574,075 ($143,911) $362,056
<br /> 2029 $102,875 $115,000 $192,050 $14,482 $178,525 $245,882 $607,938
<br /> 2030 $102,875 $115,000 $192,050 $24,318 $644,025 ($209,782) $398,155
<br /> 2031 $102.875 $115,000 $192.050 $15.926 $297,725 $128,126 $526,281
<br /> Total $2,057,500 $2,300,000 $3,841,000 $404,711 $8,826,930 ($223,719)
<br /> Total(All Sources): $8,603,211
<br /> Lowest
<br /> Fund
<br /> Balance:
<br /> $185,197
<br /> 40
<br /> 41
<br />
|