|
Table 9
<br />Calculation of Improvement Fee Credit for Rate Supported Project Costs
<br />Input
<br /> Variables 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014
<br />Sources of Funds
<br />Beginning Fund Balance 12,600,000 12,600,000 10,796,450 4,369,448 0 0 0 0 0 0 0
<br />
<br />Reimbursement Fee Revenue $245,086 $251,948 $259,003 $266,255 $273,710 $281,374 $289,252 $297,352 $305,677 $314,236
<br />Interest Earnings 3.00%
<br />Existing Customer Fund $378,000 $323,893 $131,083 $0 $0 $0 $0 $0 $0 $0
<br />Total Sources of Funds $13,223,086 $11,372,292 $4,759,534 $266,255 $273,710 $281,374 $289,252 $297,352 $305,677 $314,236
<br />Uses of Funds
<br />Capital Projects $2,426,636 $7,002,844 $6,458,199 $8,816,609 $14,543,417 $15,391,328 $5,007,0913 $3,102,216 $5,017,004 $2,940,930
<br />Ending Balance $10,796,450 $4,369,448 ($1,698,664) ($8,550,354) ($14,269,707) ($15,109,954) ($4,717,837) ($2,804,865) ($4,711,326) ($2,626,694)
<br />Rate Funded Contribution $0 $0 $1,698,664 $8,550,354 $14,269,707 $15,109,954 $4,717,837 $2,804,865 $4,711,326 $2,626,694
<br />Debt Service Payment $0 $0 $136,305 $686,103 $1,145,038 $1,212,462 $378,571 $225,070 $378,049 $210,773
<br />Cumulative Debt Service Payment $0 $0 $136,305 $822,408 $1,967,446 $3,179,908 $3,558,479 $3,783,549 $4,161,598 $4,372,371
<br />
<br />Rate Funding by Capacity Parameter $ $ $ 136,305 $ 822,408 $ 1,967,446 $ 3,179,908 $ 3,558,479 $ 3,783,549 $ 4,161,598 $ 4,372,371
<br />Average Flow ($/gallon) 63% $ $ $ 86,319 $ 520,814 $ 1,245,943 $ 2,013,770 $ 2,253,511 $ 2,396,043 $ 2,635,454 $ 2,768,932
<br />Peak Flow 0% $ $ $ $ $ $ $ $ $ $
<br />BOD 18% $ $ $ 24,061 $ 145,176 $ 347,305 $ 561,335 $ 628,163 $ 667,893 $ 734,629 $ 771,835
<br />TSS 19% $ $ $ 25,925 $ 156,418 $ 374,199 $ 604,803 $ 676,805 $ 719,612 $ 791,515 $ 831,603
<br /> 100%
<br />Billing Units by Capacity Parameter
<br />Average Flow (S/gallon) 43,832,110 44,604,639 45,377,168 46,149,698 46,922,227 47,694,757 48,467,286 49,239,815 50,012,345 50,784,874 51,557,404
<br />Peak Flow 247,000,000 248,500,000 250,000,000 251,500,000 253,000,000 254,500,000 256,000,000 257,500,000 259,000,000 260,500,000 262,000,000
<br />BOD 54,800 55,760 56,720 57,680 58,640 59,600 60,560 61,520 62,480 63,440 64,400
<br />TSS 64,700 65,845 66,990 68,135 69,280 70,425 71,570 72,715 73,860 75,005 76,150
<br />
<br />Rate Funding portion per Unit
<br />Average Flow (S/gallon) $ $ $ 0.00 $ 0.01 $ 0.03 $ 0.04 $ 0.05 $ 0.05 $ 0.05 $ 0.05
<br />Peak Flow $ $ $ $ $ $ $ $ $ $
<br />BOD $ $ $ 0.42 $ 2.48 $ 5.83 $ 9.27 $ 10.21 $ 10.69 $ 11.58 $ 11.99
<br />TSS $ $ $ 0.38 $ 2.26 $ 5.31 $ 8.45 $ 9.31 $ 9.74 $ 10.55 $ 10.92
<br />
<br />
<br />
|