Page 4 of 10
<br /> 42 Table Al c: Facilities Replacement Fund:
<br /> 43 (Yellow highlighting indicates projected fund balances below current level. All figures are in 2011 dollars.)
<br /> 44
<br /> Starting
<br /> Sources Uses Bal: $200,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 $25,000 $70,000 $116,900 $8,000 $101,700 $118,200 $318,200
<br /> 2013 $25,000 $70,000 $116,900 $12,728 $514,500 ($289,872) $28,328
<br /> 2014 $25,000 $70,000 $116,900 $1,133 $156,000 $57,033 $85,361
<br /> 2015 $25,000 $70,000 $116,900 $3,414 $225,800 ($10,486) $74,876
<br /> 2016 $25,000 $70,000 $116,900 $2,995 $10,000 $204,895 $279,771
<br /> 2017 $25,000 $70,000 $116,900 $11,191 $109,200 $113,891 $393,661
<br /> 2018 $25,000 $70,000 $116,900 $15,746 $118,000 $109,646 $503,308
<br /> 2019 $25,000 $70,000 $116,900 $20,132 $90,000 $142,032 $645,340
<br /> 2020 $25,000 $70,000 $116,900 $25,814 $383,000 ($145,286) $500,054
<br /> 2021 $25,000 $70,000 $116,900 $20,002 $14,000 $217,902 $717,956
<br /> 2022 $25,000 $70,000 $116,900 $28,718 $46,200 $194,418 $912,374
<br /> 2023 $25,000 $70,000 $116,900 $36,495 $862,000 ($613,605) $298,769
<br /> 2024 $25,000 $70,000 $116,900 $11,951 $36,000 $187,851 $486,620
<br /> 2025 $25,000 $70,000 $116,900 $19,465 $181,000 $50,365 $536,985
<br /> 2026 $25,000 $70,000 $116,900 $21,479 $39,500 $193,879 $730,864
<br /> 2027 $25,000 $70,000 $116,900 $29,235 $64,200 $176,935 $907,799
<br /> 2028 $25,000 $70,000 $116,900 $36,312 $114,000 $134,212 $1,042,011
<br /> 2029 $25,000 $70,000 $116,900 $41,680 $297,500 ($43,920) $998,091
<br /> 2030 $25,000 $70,000 $116,900 $39,924 $194,500 $57,324 $1,055,415
<br /> 2031 $25,000 $70.000 $116.900 $42.217 $465.500 ($211,383) $844,031
<br /> Total $500,000 $1,400,000 $2,338,000 $428,631 $4,022,600 $644,031
<br /> Total(All Sources): $4,666,631
<br /> Lowest
<br /> Fund
<br /> Balance:
<br /> $28,328
<br /> 45
<br /> 46
<br /> 47
<br />
|