Spreadsheet: chris_stokley__4003__April 00 thru June 00 retro Enron Request
Sheet: EPMI

 | Scheduling Coordinator |  | EPMI
 |  |  |  |  |  |  | Compound
 | Trade |  |  |  | Interest | Interest on | Interest,
Month | Period | Difference, $ | Principle, $ | Invoice date | Rate, % | Charge, $ | Qtrly, $ | Balance, $
April 00 | APRIL 98 | 0 | 0 | July 00 | 0.085 | 0 |  | 0
April 00 | MAY 98 | 0 | 0 | July 00 | 0.085 | 0 |  | 0
April 00 | JUNE 98 | 0 | 0 | July 00 | 0.085 | 0 |  | 0
April 00 | JULY 98 | 0 | 0 | July 00 | 0.085 | 0 | 0 | 0
April 00 | AUGUST 98 | 0 | 0 | July 00 | 0.085 | 0 | 0 | 0
April 00 | SEPTEMBER 98 | 0 | 0 | July 00 | 0.085 | 0 | 0 | 0
April 00 | October 98 | 0 | 0 | July 00 | 0.085 | 0 | 0 | 0
April 00 | NOVEMBER 98 | 0 | 0 | July 00 | 0.085 | 0 | 0 | 0
April 00 | DECEMBER 98 | 0 | 0 | July 00 | 0.085 | 0 | 0 | 0
April 00 | JANUARY  99 | 0 | 0 | July 00 | 0.0817 | 0 | 0 | 0
April 00 | FEBRUARY 99 | 0 | 0 | July 00 | 0.0817 | 0 | 0 | 0
April 00 | MARCH 99 | 0 | 0 | July 00 | 0.0817 | 0 | 0 | 0
April 00 | April 99 | 0 | 0 | July 00 | 0.0775 | 0 | 0 | 0
April 00 | May 99 | 0 | 0 | July 00 | 0.0775 | 0 | 0 | 0
April 00 | [NAME] 99 | 0 | 0 | July 00 | 0.0775 | 0 | 0 | 0
April 00 | JULY 99 | 0 | 0 | July 00 | 0.0775 | 0 | 0 | 0
April 00 | AUGUST 99 | 0 | 0 | July 00 | 0.0775 | 0 | 0 | 0
April 00 | Sept 99 | 0 | 0 | July 00 | 0.0775 | 0 | 0 | 0
April 00 | Oct 99 | 0 | 0 | July 00 | 0.0794 | 0 | 0 | 0
April 00 | Nov 99 | 0 | 0 | July 00 | 0.0794 | 0 | 0 | 0
April 00 | Dec 99 | 0 | 0 | July 00 | 0.0794 | 0 | 0 | 0
April 00 | January 00 | 0 | 0 | July 00 | 0.0829 | 0 | 0 | 0
April 00 | February 00 | 0 | 0 | July 00 | 0.0829 | 0 | 0 | 0
April 00 | March 00 | 0 | 0 | July 00 | 0.0829 | 0 | 0 | 0
April 00 | April 00 | 299.9 | 0 | July 00 | 0.0858 | 0 | 0 | 0
April 00 | May 00 | 0 | 0 | July 00 | 0.0858 | 0 | 0 | 0 |  |  |  | April first month interest
April 00 | June 00 | 0 | 0 | July 00 | 0.0858 | 0 | 0 | 0
April 00 | July 00 | 0 | 299.9 | July 00 | 0.0902 | 0.9453299462365592 | 0 | 0.9453299462365592 |  |  |  | 0.9453190385833333
April 00 | Aug 00 | 0 | 299.9 | July 00 | 0.0902 | 2.254248333333333 | 0 | 3.199578279569892 |  |  |  | 2.254248333333333 | for a full month
April 00 | Sept 00 | 0 | 299.9 | July 00 | 0.0902 | 2.254248333333333 | 0 | 5.453826612903226 |  |  |  | 2.374208333333333
April 00 | Oct 00 | 0 | 299.9 | July 00 | 0.095 | 2.374208333333333 | 0.04317612735215055 | 7.871211073588711 |  |  |  | 2.374208333333333
April 00 | Nov 00 | 0 | 299.9 | July 00 | 0.095 | 2.374208333333333 | 0.04317612735215055 | 10.2885955342742 |  |  |  | 2.374208333333333
April 00 | Dec 00 | 0 | 299.9 | July 00 | 0.095 | 2.374208333333333 | 0.04317612735215055 | 12.70597999495968
April 00 | Jan 01 | 0 | 299.9 | July 00 | 0.095 | 0.2297620967741935 | 0.1005890082934308 | 13.0363311000273
 |  |  | 299.9 |  |  |  |  | 13.0363311000273
 | Scheduling Coordinator |  | EPMI
 |  |  |  |  |  |  | Compound
 | Trade |  |  |  | Interest | Interest on | Interest,
Month | Period | Difference, $ | Principle, $ | Invoice date | Rate, % | Charge, $ | Qtrly, $ | Balance, $
May 00 | APRIL 98 | 0 | 0 | Aug 00 | 0.085 | 0 |  | 0
May 00 | MAY 98 | 0 | 0 | Aug 00 | 0.085 | 0 |  | 0
May 00 | JUNE 98 | 0 | 0 | Aug 00 | 0.085 | 0 |  | 0
May 00 | JULY 98 | 0 | 0 | Aug 00 | 0.085 | 0 | 0 | 0
May 00 | AUGUST 98 | 0 | 0 | Aug 00 | 0.085 | 0 | 0 | 0
May 00 | SEPTEMBER 98 | 0 | 0 | Aug 00 | 0.085 | 0 | 0 | 0
May 00 | October 98 | 0 | 0 | Aug 00 | 0.085 | 0 | 0 | 0
May 00 | NOVEMBER 98 | 0 | 0 | Aug 00 | 0.085 | 0 | 0 | 0
May 00 | DECEMBER 98 | 0 | 0 | Aug 00 | 0.085 | 0 | 0 | 0
May 00 | JANUARY  99 | 0 | 0 | Aug 00 | 0.0817 | 0 | 0 | 0
May 00 | FEBRUARY 99 | 0 | 0 | Aug 00 | 0.0817 | 0 | 0 | 0
May 00 | MARCH 99 | 0 | 0 | Aug 00 | 0.0817 | 0 | 0 | 0
May 00 | April 99 | 0 | 0 | Aug 00 | 0.0775 | 0 | 0 | 0
May 00 | May 99 | 0 | 0 | Aug 00 | 0.0775 | 0 | 0 | 0
May 00 | [NAME] 99 | 0 | 0 | Aug 00 | 0.0775 | 0 | 0 | 0
May 00 | JULY 99 | 0 | 0 | Aug 00 | 0.0775 | 0 | 0 | 0
May 00 | AUGUST 99 | 0 | 0 | Aug 00 | 0.0775 | 0 | 0 | 0
May 00 | Sept 99 | 0 | 0 | Aug 00 | 0.0775 | 0 | 0 | 0
May 00 | Oct 99 | 0 | 0 | Aug 00 | 0.0794 | 0 | 0 | 0
May 00 | Nov 99 | 0 | 0 | Aug 00 | 0.0794 | 0 | 0 | 0
May 00 | Dec 99 | 0 | 0 | Aug 00 | 0.0794 | 0 | 0 | 0
May 00 | January 00 | 0 | 0 | Aug 00 | 0.0829 | 0 | 0 | 0
May 00 | February 00 | 0 | 0 | Aug 00 | 0.0829 | 0 | 0 | 0
May 00 | March 00 | 0 | 0 | Aug 00 | 0.0829 | 0 | 0 | 0
May 00 | April 00 | 0 | 0 | Aug 00 | 0.0858 | 0 | 0 | 0
May 00 | May 00 | 982.409999999998 | 0 | Aug 00 | 0.0858 | 0 | 0 | 0 |  |  |  | April first month interest
May 00 | June 00 | 0 | 0 | Aug 00 | 0.0858 | 0 | 0 | 0
May 00 | July 00 | 0 | 0 | Aug 00 | 0.0902 | 0 | 0 | 0 |  |  |  | 0
May 00 | Aug 00 | 0 | 982.409999999998 | Aug 00 | 0.0902 | 3.334912225806445 | 0 | 3.334912225806445 |  |  |  | 7.384448499999985 | for a full month
May 00 | Sept 00 | 0 | 982.409999999998 | Aug 00 | 0.0902 | 7.384448499999985 | 0 | 10.71936072580643 |  |  |  | 7.777412499999985
May 00 | Oct 00 | 0 | 982.409999999998 | Aug 00 | 0.095 | 7.777412499999985 | 0.08486160574596757 | 18.58163483155238 |  |  |  | 7.777412499999985
May 00 | Nov 00 | 0 | 982.409999999998 | Aug 00 | 0.095 | 7.777412499999985 | 0.08486160574596757 | 26.44390893729834 |  |  |  | 7.777412499999985
May 00 | Dec 00 | 0 | 982.409999999998 | Aug 00 | 0.095 | 7.777412499999985 | 0.08486160574596757 | 34.30618304304429
May 00 | Jan 01 | 0 | 982.409999999998 | Aug 00 | 0.095 | 0.7526528225806437 | 0.271590615757434 | 35.33042648138237
 |  |  | 982.409999999998 |  |  |  |  | 35.33042648138237
 | Scheduling Coordinator |  | EPMI
 |  |  |  |  |  |  | Compound
 | Trade |  |  |  | Interest | Interest on | Interest,
Month | Period | Difference, $ | Principle, $ | Invoice date | Rate, % | Charge, $ | Qtrly, $ | Balance, $
June 00 | APRIL 98 | 0 | 0 | Aug 00 | 0.085 | 0 |  | 0
June 00 | MAY 98 | 0 | 0 | Aug 00 | 0.085 | 0 |  | 0
June 00 | JUNE 98 | 0 | 0 | Aug 00 | 0.085 | 0 |  | 0
June 00 | JULY 98 | 0 | 0 | Aug 00 | 0.085 | 0 | 0 | 0
June 00 | AUGUST 98 | 0 | 0 | Aug 00 | 0.085 | 0 | 0 | 0
June 00 | SEPTEMBER 98 | 0 | 0 | Aug 00 | 0.085 | 0 | 0 | 0
June 00 | October 98 | 0 | 0 | Aug 00 | 0.085 | 0 | 0 | 0
June 00 | NOVEMBER 98 | 0 | 0 | Aug 00 | 0.085 | 0 | 0 | 0
June 00 | DECEMBER 98 | 0 | 0 | Aug 00 | 0.085 | 0 | 0 | 0
June 00 | JANUARY  99 | 0 | 0 | Aug 00 | 0.0817 | 0 | 0 | 0
June 00 | FEBRUARY 99 | 0 | 0 | Aug 00 | 0.0817 | 0 | 0 | 0
June 00 | MARCH 99 | 0 | 0 | Aug 00 | 0.0817 | 0 | 0 | 0
June 00 | April 99 | 0 | 0 | Aug 00 | 0.0775 | 0 | 0 | 0
June 00 | May 99 | 0 | 0 | Aug 00 | 0.0775 | 0 | 0 | 0
June 00 | [NAME] 99 | 0 | 0 | Aug 00 | 0.0775 | 0 | 0 | 0
June 00 | JULY 99 | 0 | 0 | Aug 00 | 0.0775 | 0 | 0 | 0
June 00 | AUGUST 99 | 0 | 0 | Aug 00 | 0.0775 | 0 | 0 | 0
June 00 | Sept 99 | 0 | 0 | Aug 00 | 0.0775 | 0 | 0 | 0
June 00 | Oct 99 | 0 | 0 | Aug 00 | 0.0794 | 0 | 0 | 0
June 00 | Nov 99 | 0 | 0 | Aug 00 | 0.0794 | 0 | 0 | 0
June 00 | Dec 99 | 0 | 0 | Aug 00 | 0.0794 | 0 | 0 | 0
June 00 | January 00 | 0 | 0 | Aug 00 | 0.0829 | 0 | 0 | 0
June 00 | February 00 | 0 | 0 | Aug 00 | 0.0829 | 0 | 0 | 0
June 00 | March 00 | 0 | 0 | Aug 00 | 0.0829 | 0 | 0 | 0
June 00 | April 00 | 0 | 0 | Aug 00 | 0.0858 | 0 | 0 | 0
June 00 | May 00 | 0 | 0 | Aug 00 | 0.0858 | 0 | 0 | 0 |  |  |  | April first month interest
June 00 | June 00 | 1565.07 | 0 | Aug 00 | 0.0858 | 0 | 0 | 0
June 00 | July 00 | 0 | 0 | Aug 00 | 0.0902 | 0 | 0 | 0 |  |  |  | 0
June 00 | Aug 00 | 0 | 1565.07 | Aug 00 | 0.0902 | 0.3794874032258064 | 0 | 0.3794874032258064 |  |  |  | 11.7641095 | for a full month
June 00 | Sept 00 | 0 | 1565.07 | Aug 00 | 0.0902 | 11.7641095 | 0 | 12.14359690322581 |  |  |  | 12.3901375
June 00 | Oct 00 | 0 | 1565.07 | Aug 00 | 0.095 | 12.3901375 | 0.09613680881720431 | 24.62987121204301 |  |  |  | 12.3901375
June 00 | Nov 00 | 0 | 1565.07 | Aug 00 | 0.095 | 12.3901375 | 0.09613680881720431 | 37.11614552086021 |  |  |  | 12.3901375
June 00 | Dec 00 | 0 | 1565.07 | Aug 00 | 0.095 | 12.3901375 | 0.09613680881720431 | 49.60241982967742
June 00 | Jan 01 | 0 | 1565.07 | Aug 00 | 0.095 | 1.199045564516129 | 0.392685823651613 | 51.19415121784516
 |  |  | 1565.07 |  |  |  |  | 51.19415121784516
 |  | Total Refund | 2847.38 |  |  | Total Interest |  | 99.56090879925483 |  | Total Refund W/Interest |  | 2946.940908799253