Page 2 of 10
<br /> 30 Table Ala: Vehicle Replacement Fund:
<br /> 31 (Yellow highlighting indicates projected fund balances below current level. All figures are in 2011 dollars.)
<br /> 32
<br /> Starting
<br /> Sources Uses Bal: $500,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 $461,000 $115,000 $192,050 $20,000 $467,095 $320,955 $820,955
<br /> 2013 $461,000 $115,000 $192,050 $32,838 $764,095 $36,793 $857,748
<br /> 2014 $461,000 $115,000 $192,050 $34,310 $708,055 $94,305 $952,053
<br /> 2015 $461,000 $115,000 $192,050 $38,082 $1,140,795 ($334,663) $617,390
<br /> 2016 $461,000 $115,000 $192,050 $24,696 $482,095 $310,651 $928,041
<br /> 2017 $461,000 $115,000 $192,050 $37,122 $525,095 $280,077 $1,208,117
<br /> 2018 $461,000 $115,000 $192,050 $48,325 $1,734,855 ($918,480) $289,637
<br /> 2019 $461,000 $115,000 $192,050 $11,585 $702,095 $77,540 $367,178
<br /> 2020 $461,000 $115,000 $192,050 $14,687 $1,122,095 ($339,358) $27,820
<br /> 2021 $461,000 $115,000 $192,050 $1,113 $482,095 $287,068 $3314,888
<br /> 2022 $461,000 $115,000 $192,050 $12,596 $335,055 $445,591 $760,478
<br /> 2023 $461,000 $115,000 $192,050 $30,419 $599,495 $198,974 $959,452
<br /> 2024 $461,000 $115,000 $192,050 $38,378 $423,095 $383,333 $1,342,785
<br /> 2025 $461,000 $115,000 $192,050 $53,711 $1,079,995 ($258,234) $1,084,552
<br /> 2026 $461,000 $115,000 $192,050 $43,382 $364,155 $447,277 $1,531,829
<br /> 2027 $461,000 $115,000 $192,050 $61,273 $973,095 ($143,772) $1,388,057
<br /> 2028 $461,000 $115,000 $192,050 $55,522 $899,165 ($75,593) $1,312,464
<br /> 2029 $461,000 $115,000 $192,050 $52,499 $384,695 $435,854 $1,748,318
<br /> 2030 $461,000 $115,000 $192,050 $69,933 $1,459,635 ($621,652) $1,126,665
<br /> 2031 $461.000 $115,000 $192.050 $45.067 $967.295 ($154,178) $972,487
<br /> Total $9,220,000 $2,300,000 $3,841,000 $725,537 $15,614,050 $472,487
<br /> [_ Total(All Sources): $16,086,537
<br /> Lowest
<br /> Fund
<br /> Balance:
<br /> $27,820
<br /> 33
<br /> 34
<br />
|