|
Monthly Calculations for Updated 1(-3 Schedule for FY 2012-13
<br />Based on February 2013 Prepayment
<br />(Water)
<br />6/30/12 Unpaid Balance
<br />Interest Rate:
<br />Origina!Term:
<br />Monthly Principal & Interest Calculation through 6/30/13
<br />Anl')ual Wholesale Revenue Requirement through 6/30/13:
<br />Prepayment Date
<br />Month Beginning
<br />Ending Mo. Pmt Balance Principal (ll
<br />6/30/12 n/a n/a
<br />7/30/12 2,081,055 328,945,481 674,813
<br />8/30/12 2,081,055 328,270,667 677,698
<br />9/30/12 2,081,055 327,592,970 680,595
<br />10/30/12 2,081,055 326,912,374 683,505
<br />11/30/12 2,081,055 326,228,870 686,427
<br />12/30/12 2,081,055 325,542,443 689,361
<br />1/30/13 2,081,055 324,853,082 692,308
<br />2/28/13 2,081,055 324,160,774 695,268
<br />3/30/13 2,081,055 8,236,010 2,045,846
<br />4/30/13 2,081,055 6,190,164 2,054,592
<br />5/30/13 2,081,055 4,135,572 2,063,375
<br />6/30/13 2,081,055 2,072,19� 2,072,196
<br />Total (Rev K-3): 13,715,985
<br />Current K-3 1�1:8,290,896
<br />Additlonal Principal Amortized: 5,425,089
<br />Interest (ll
<br />n/a
<br />1,406,242
<br />1,403,357
<br />1,400,460
<br />1,397,550
<br />1,394,628
<br />1,391,694
<br />1,388,747
<br />1,385,787
<br />35,209
<br />26,463
<br />17,680
<br />8,859
<br />11,256,676
<br />16,681,765
<br />Total
<br />n/a
<br />2,081,055
<br />2,081,055
<br />2,081,055
<br />2,081,055
<br />2,081,055
<br />2,081,055
<br />2,081,055
<br />2,081,055
<br />2,081,055
<br />2,081,055
<br />2,081,055
<br />2,081,055
<br />24,972,661 I
<br />24,972,661
<br />{1) Starting in March, the Prepayment is applied to the monthly Interest calculations
<br />and monthly p_ri.ncipal is calculated to maintain monthly principal and Interest
<br />$2,081,055 and the annual WRR amount at $24,972,661 resulting in no impact to the
<br />6/30/13 balancing account compared to no prepayment being made.
<br />{2) K-3 principal and Interest for FY 12-13 on K-3 before prepayment.
<br />Provided for reference only.
<br />Revised Attachment K-3
<br />328,945,481
<br />5.13%
<br />25
<br />2,081,055
<br />24,972,66_1
<br />2/27/13
<br />Ending Prepay-
<br />Balance ment
<br />328,945,481
<br />328,270,667
<br />327,592,970
<br />326,912,374
<br />326,228,870
<br />325,542,443
<br />324,853,082
<br />324,160,774
<br />323,465,506 315,22 9,496 Ill
<br />6,190,164
<br />4,135,572
<br />2,072,196
<br />0
<br />315,22 9,496
|