Page 6 of 10
<br /> 62 Table Ala: Water Fund:
<br /> 63 (Yellow highlighting indicates lowest projected fund balance. All figures are in 2011 dollars.) Note that
<br /> 64 the actual current balance is$0, and the$600,000 figure in the table represents the recommended
<br /> 65 transfer of$600,000 into the fund from the Stormwater Fund.
<br /> 66
<br /> Starting
<br /> Sources Uses Bal: $600,000
<br /> New Sources Fund
<br /> Current Additional Balance Unfunded
<br /> Depreciation Depreciation Additional Interest (Negative Resulting
<br /> (from Base (Shift from Depreciation (Assume Projected Amount is Fund
<br /> Year Fees) Operating) (Base Fees) 4%) Costs Unfunded) Balance
<br /> 2012 $300,000 $0 $850,000 $24,000 $755,000 $419,000 $1,019,000
<br /> 2013 $300,000 $0 $850,000 $40,760 $1,108,000 $82,760 $1,101,760
<br /> 2014 $300,000 $0 $850,000 $44,070 $1,348,000 ($153,930) $947,830
<br /> 2015 $300,000 $0 $850,000 $37,913 $1,256,000 ($68,087) $879,744
<br /> 2016 $300,000 $0 $850,000 $35,190 $1,805,000 ($619,810) $259,933
<br /> 2017 $300,000 $0 $850,000 $10,397 $1,150,000 $10,397 $270,331
<br /> 2018 $300,000 $0 $850,000 $10,813 $1,085,000 $75,813 $346,144
<br /> 2019 $300,000 $0 $850,000 $13,846 $1,122,500 $41,346 $387,490
<br /> 2020 $300,000 $0 $850,000 $15,500 $1,214,000 ($48,500) $338,989
<br /> 2021 $300,000 $0 $850,000 $13,560 $1,120,000 $43,560 $382,549
<br /> 2022 $300,000 $0 $850,000 $15,302 $1,160,000 $5,302 $387,851
<br /> 2023 $300,000 $0 $850,000 $15,514 $1,113,000 $52,514 $440,365
<br /> 2024 $300,000 $0 $850,000 $17,615 $1,115,000 $52,615 $492,979
<br /> 2025 $300,000 $0 $850,000 $19,719 $1,095,000 $74,719 $567,699
<br /> 2026 $300,000 $0 $850,000 $22,708 $1,115,000 $57,708 $625,407
<br /> 2027 $300,000 $0 $850,000 $25,016 $1,136,000 $39,016 $664,423
<br /> 2028 $300,000 $0 $850,000 $26,577 $1,171,000 $5,577 $670,000
<br /> 2029 $300,000 $0 $850,000 $26,800 $1,143,000 $33,800 $703,800
<br /> 2030 $300,000 $0 $850,000 $28,152 $1,165,000 $13,152 $716,952
<br /> 2031 $300,000 10 $850,000 $28,678 $1,122,000 . $56,678 $773,630
<br /> Total $6,000,000 $0 $17,000,000 $472,130 $23,298,500 $173,630
<br /> Total(All Sources): $23,472,130
<br /> Lowest
<br /> Fund
<br /> Balance:
<br /> $259,933
<br /> 67
<br /> 68
<br />
|