Laserfiche WebLink
6.G. - Page 186 of 238 <br />Monthly Calculations for Updated K Schedules for FY 2012-13 <br />Based on February 2013 Prepayment <br />(Retch Hetchy) <br />6/30/12 Unpaid Balance <br />Interest Rate: <br />Original Term: <br />Monthly Principal & Interest Calculation through 6/30/13 <br />Annual Wholesale Revenue Requirement through 6/30/13: <br />Est. Prepayment Date <br />42,689,343 <br />5.13% <br />25 <br />270,072 <br />3,240,861 <br />2/27/13 <br />Month <br />Beginning <br />Ending <br />Prepay - <br />Ending <br />Mo. Pmt <br />Balance <br />Principal (11 <br />Interest(') <br />Total <br />Balance <br />ment <br />6/30/12 <br />n/a <br />n/a <br />n/a <br />n/a <br />42,689,343 <br />7/30/12 <br />270,072 <br />42,689,343 <br />87,575 <br />182,497 <br />270,072 <br />42,601,769 <br />- <br />8/30/12 <br />270,072 <br />42,601,769 <br />87,949 <br />182,123 <br />270,072 <br />42,513,820 <br />9/30/12 <br />270,072 <br />42,513,820 <br />88,325 <br />181,747 <br />270,072 <br />42,425,494 <br />10/30/12 <br />270,072 <br />42,425,494 <br />88,703 <br />181,369 <br />270,072 <br />42,336,792 <br />- <br />11/30/12 <br />270,072 <br />42,336,792 <br />89,082 <br />180,990 <br />270,072 <br />42,247,710 <br />12/30/12 <br />270,072 <br />42,247,710 <br />89,463 <br />180,609 <br />270,072 <br />42,158,247 <br />- <br />1/30/13 <br />270,072 <br />42,158,247 <br />89,845 <br />180,227 <br />270,072 <br />42,068,402 <br />2/28/13 <br />270,072 <br />42,068,402 <br />90,229 <br />179,842 <br />270,072 <br />41,978,172 <br />40,909,333 11) <br />3/30/13 <br />270,072 <br />1,068,839 <br />265,502 <br />4,569 <br />270,072 <br />803,337 <br />- <br />4/30/13 <br />270,072 <br />803,337 <br />266,637 <br />3,434 <br />270,072 <br />536,699 <br />- <br />5/30/13 <br />270,072 <br />536,699 <br />267,777 <br />2,294 <br />270,072 <br />268,922 <br />6/30/13 <br />270,072 <br />268,922. <br />268,922 <br />1,150 <br />270,072 <br />0 <br />- <br />Total (Rev K-4): <br />40,909,333 <br />1,780,010 <br />1,460,850 <br />3,240,861 <br />Current K-4 (2i: <br />1,075,962 <br />2,164,899 <br />3,240,861 <br />Additional Principal Amortized (K-4): <br />704,048 <br />Combined <br />Plus Additional K-3 Principal: <br />5,425,089 <br />Prepayment <br />)Combined Additional Principal: <br />6,129,137 <br />356,138,829 <br />(1) Starting In March, the Prepayment is applied to the monthly interest calculations <br />and monthly principal Is calculated to malntaln monthly principal and interest <br />$270,072 and the annual WRR amount at $3,240,861, resulting In no Impact to the <br />6/30/13 balancing account compared to np prepayment being made. <br />(2) K-4 principal and interest for FY 12-13 on K-4 before prepayment, <br />Revised Attachment K-4 <br />517 <br />