Page 7 of 10
<br /> 69 Table Alb: Sanitary Sewer Fund:
<br /> 70 (Yellow highlighting indicates projected fund balances below current level. All figures are in 2011 dollars.)
<br /> 71
<br /> Starting
<br /> Sources Uses Bal: $1,000,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 $240,000 $0 $830,000 $40,000 $860,500 $249,500 $1,249,500
<br /> 2013 $240,000 $0 $830,000 $49,980 $905,000 $214,980 $1,464,480
<br /> 2014 $240,000 $0 $830,000 $58,579 $1,276,000 ($147,421) $1,317,059
<br /> 2015 $240,000 $0 $830,000 $52,682 $1,525,000 ($402,318) $914,742
<br /> 2016 $240,000 $0 $830,000 $36,590 $1,038,000 $68,590 $983,331
<br /> 2017 $240,000 $0 $830,000 $39,333 $1,067,000 $42,333 $1,025,664
<br /> 2018 $240,000 $0 $830,000 $41,027 $1,075,000 $36,027 $1,061,691
<br /> 2019 $240,000 $0 $830,000 $42,468 $1,051,300 $61,168 $1,122,859
<br /> 2020 $240,000 $0 $830,000 $44,914 $1,184,000 ($69,086) $1,053,773
<br /> 2021 $240,000 $0 $830,000 $42,151 $1,015,000 $97,151 $1,150,924
<br /> 2022 $240,000 $0 $830,000 $46,037 $1,150,000 ($33,963) $1,116,961
<br /> 2023 $240,000 $0 $830,000 $44,678 $1,150,000 ($35,322) $1,081,639
<br /> 2024 $240,000 $0 $830,000 $43,266 $1,150,000 ($36,734) $1,044,905
<br /> 2025 $240,000 $0 $830,000 $41,796 $1,085,000 $26,796 $1,071,701
<br /> 2026 $240,000 $0 $830,000 $42,868 $1,115,000 ($2,132) $1,069,569
<br /> 2027 $240,000 $0 $830,000 $42,783 $1,455,000 ($342,217) $727,352
<br /> 2028 $240,000 $0 $830,000 $29,094 $1,095,000 $4,094 $731,446
<br /> 2029 $240,000 $0 $830,000 $29,258 $1,092,000 $7,258 $738,704
<br /> 2030 $240,000 $0 $830,000 $29,548 $1,040,000 $59,548 $798,252
<br /> 2031 $240,000 Q $830,000 $31,930 $1,010,000 $91,930 $890,182
<br /> Total $4,800,000 $0 $16,600,000 $828,982 $22,338,800 ($109,818)
<br /> Total(All Sources): $22,228,982
<br /> Lowest
<br /> Fund
<br /> Balance:
<br /> $727,352
<br /> 72
<br /> 73
<br />
|