Spreadsheet: chris_dorland__1603__MIRANT - Nov 30 2001 Termination
Sheet: Data

 |  | Phy/ |  | Start | End | Quantity | Monthly | PV | Discount | Mid | FP |  | Mid |  | Curve Dec. 22
Counterparty | Deal Num | Fin | Pub Code | Period | Period | GJ/D | Quantity | Quantity | Factor | Price | C/GJ | Cash | Value | POST ID | C/GJ
MIRANTCANENE | QP7039.1 | P | NGMR-AECO/C | 2002-01-01 00:00:00 | 2002-03-31 00:00:00 | 3500 | 0 | 0 | 1 | 3.56793687 | 7.645 | 0 | 422956.0643 | 1467371
MIRANTCANENE | V64794.1 | P | NGMR-AECO/C | 2002-01-01 00:00:00 | 2002-03-31 00:00:00 | 5000 | 0 | 0 | 1 | 3.56793687 | 7.42 | 0 | 633900.0286 | 1467371
MIRANTCANENE | V67831.1 | P | NGMR-AECO/C | 2002-01-01 00:00:00 | 2002-03-31 00:00:00 | 4200 | 0 | 0 | 1 | 3.56793687 | 7.17 | 0 | 524090.5662 | 1467371
MIRANTCANENE | V70968.1 | P | NGMR-AECO/C | 2002-01-01 00:00:00 | 2002-03-31 00:00:00 | 3500 | 0 | 0 | 1 | 3.56793687 | 7.02 | 0 | 843740.113 | 1467371
MIRANTCANENE | V92532.1 | P | CGPR-AECO/BASIS | 2002-01-01 00:00:00 | 2002-03-31 00:00:00 | 5275 | 0 | 0 | 1 | -0.32901837 | -0.48044654 | 0 | 386544.9061 | 1467371
MIRANTCANENE | V92532.1 | P | CGPR-AECO/BASIS | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | 5275.280006666667 | 158258.4002 | 157586.0468 | 0.9957515473172199 | -0.66392742 | -0.48077503 | 0 | 699484.8239 | 1467371
MIRANTCANENE | V98653.1 | P | NGMR-AECO/C | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | -3500 | -105000 | -104553.9125 | 0.9957515473172199 | 2.83275701 | 5.975 | 0 | 24763.6057 | 1467371
MIRANTCANENE | VB4050.1 | P | AECOUS | 2002-01-01 00:00:00 | 2002-03-31 00:00:00 | -5275 | 0 | 0 | 1 | 3.56793686 | 6.15429133 | 0 | 42223.4257 | 1467371
MIRANTCANENE | VB4050.1 | P | AECOUS | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | -5275.280006666667 | -158258.4002 | -157586.0468 | 0.9957515473172199 | 2.83275701 | 6.15849921 | 0 | -28862.2616 | 1467371
MIRANTCANENE | VB4050.1 | P | AECOUS | 2002-11-01 00:00:00 | 2002-12-31 00:00:00 | -5275.280006666667 | -158258.4002 | -155535.5689 | 0.9827950283088561 | 3.67444645 | 6.15969731 | 0 | -12025.9423 | 1467371
MIRANTCANENE | VC5783.3 | P | AECOUS | 2002-01-01 00:00:00 | 2002-03-31 00:00:00 | -10550.56001071429 | 0 | 0 | 1 | 3.56793686 | 5.91788113 | 0 | 203.2639 | 1467372
MIRANTCANENE | VC5783.3 | P | AECOUS | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | -10550.56001 | -316516.8003 | -315172.0937 | 0.9957515473172199 | 2.83275701 | 5.92192737 | 0 | 406.5278 | 1467372
MIRANTCANENE | VC5783.3 | P | AECOUS | 2002-11-01 00:00:00 | 2002-12-31 00:00:00 | -10550.56001 | -316516.8003 | -311071.1377 | 0.9827950283088561 | 3.67444645 | 5.92307944 | 0 | 406.5278 | 1467372
MIRANTCANENE | VD3558.1 | P | AECOUS | 2002-01-01 00:00:00 | 2002-03-31 00:00:00 | -10550.56001071429 | 0 | 0 | 1 | 3.56793686 | 5.50606981 | 0 | -195.8713 | 1467372
MIRANTCANENE | VD3558.1 | P | AECOUS | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | -10550.56001 | -316516.8003 | -315172.0937 | 0.9957515473172199 | 2.83275701 | 5.50983449 | 0 | 195.8713 | 1467372
MIRANTCANENE | VD3558.1 | P | AECOUS | 2002-11-01 00:00:00 | 2002-12-31 00:00:00 | -10550.56001 | -316516.8003 | -311071.1377 | 0.9827950283088561 | 3.67444645 | 5.51090639 | 0 | 391.7427 | 1467372
MIRANTCANENE | VF2542.1 | P | CGPR-AECO/BASIS | 2002-01-01 00:00:00 | 2002-03-31 00:00:00 | -21101.12002142857 | 0 | 0 | 1 | -0.32901837 | -0.58721243 | 0 | 193.3227 | 1467372
MIRANTCANENE | [NAME] | P | NGMR-AECO/C | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | 3500 | 105000 | 104553.9125 | 0.9957515473172199 | 2.83275701 | 5.33 | 0 | 386.6454 | 1467372
MIRANTCANENE | VG9103.1 | P | CGPR-AECO/BASIS | 2002-01-01 00:00:00 | 2002-03-31 00:00:00 | 5275.280003571429 | 0 | 0 | 1 | -0.32901837 | -0.58721243 | 0 | 386.6454 | 1467372
MIRANTCANENE | VG9103.1 | P | CGPR-AECO/BASIS | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | 5275.280006666667 | 158258.4002 | 157586.0468 | 0.9957515473172199 | -0.66392742 | -0.5876139300000001 | 0 | -193.3227 | 1467372
MIRANTCANENE | VG9103.1 | P | CGPR-AECO/BASIS | 2002-11-01 00:00:00 | 2002-12-31 00:00:00 | 5275.280006666667 | 158258.4002 | 155535.5689 | 0.9827950283088561 | -0.54956407 | -0.58772824 | 0 | 387.5 | 1467372
MIRANTCANENE | VH0021.1 | P | NGMR-AECO/C | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | -3500 | -105000 | -104553.9125 | 0.9957515473172199 | 2.83275701 | 5.32 | 0 | -468988.6201 | 1467371
MIRANTCANENE | VQ9540.1 | P | NGMR-AECO/C | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | 3500 | 105000 | 104553.9125 | 0.9957515473172199 | 2.83275701 | 4.39 | 0 | 95872.3929 | 1467371
MIRANTCANENE | VT2543.1 | P | NGMR-AECO/C | 2002-01-01 00:00:00 | 2002-03-31 00:00:00 | -2500 | 0 | 0 | 1 | 3.56793687 | 4.805 | 0 | -57051.4284 | 1467371
MIRANTCANENE | VT5299.1 | P | CGPR-AECO/BASIS | 2002-11-01 00:00:00 | 2003-03-31 00:00:00 | 5275.280006666667 | 158258.4002 | 155535.5689 | 0.9827950283088561 | -0.54956407 | -0.74801776 | 0 | -6072.085700000001 | 1467371
MIRANTCANENE | Y46805.1 | P | AECOUS | 2002-01-01 00:00:00 | 2002-03-31 00:00:00 | -10550.56001071429 | 0 | 0 | 1 | 3.56793686 | 5.98651635 | 0 | -261096.5247 | 1467371
MIRANTCANENE | Y46805.1 | P | AECOUS | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | -10550.56001 | -316516.8003 | -315172.0937 | 0.9957515473172199 | 2.83275701 | 5.99060952 | 0 | 260050.9856 | 1467371
MIRANTCANENE | Y46805.1 | P | AECOUS | 2002-11-01 00:00:00 | 2002-12-31 00:00:00 | -10550.56001 | -316516.8003 | -311071.1377 | 0.9827950283088561 | 3.67444645 | 5.99177495 | 0 | -162815.847 | 1467371
MIRANTCANENE | Y52420.1 | P | NGMR-AECO/IDX | 2002-01-01 00:00:00 | 2002-03-31 00:00:00 | 18956.33975714286 | 0 | 0 | 1 | -0.00131128 | 7e-08 | 0 | -115.5912 | 1467372
MIRANTCANENE | Y52471.1 | P | NGMR-AECO/IDX | 2002-01-01 00:00:00 | 2002-03-31 00:00:00 | 18956.33975714286 | 0 | 0 | 1 | -0.00131128 | -0.00032782 | 0 | 134.8564 | 1467372
MIRANTCANENE | Y81297.1 | P | IF-NTWST/CANB-I | 2002-01-01 00:00:00 | 2002-03-31 00:00:00 | 5000 | 0 | 0 | 1 | 0.04 | 0.0375 | 0 | -192.6519 | 1467372
MIRANTCANENE | Y92833.1 | P | NGMR-AECO/C | 2002-01-01 00:00:00 | 2002-03-31 00:00:00 | 5000 | 0 | 0 | 1 | 3.56793687 | 3.44 | 0 | -161.8276 | 1467372
MIRANTCANENE | Y92833.1 | P | NGMR-AECO/C | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | 5000 | 150000 | 149362.7321 | 0.9957515473172199 | 2.83275701 | 3.44 | 0 | -134.8564 | 1467372
MIRANTCANENE | YA7382.1 | P | STATION-2/C$ | 2002-01-01 00:00:00 | 2002-03-31 00:00:00 | 10000 | 0 | 0 | 1 | 3.79 | 3.6039 | 0 | -577.9269 | 1467372
MIRANTCANENE | YA7382.1 | P | STATION-2/IDX | 2002-01-01 00:00:00 | 2002-03-31 00:00:00 | 9478.169878571429 | 0 | 0 | 1 | 0 | 7e-08 | 0 | -192.6519 | 1467372
MIRANTCANENE | YA7382.2 | P | NGMR-AECO/C | 2002-01-01 00:00:00 | 2002-03-31 00:00:00 | -10000 | 0 | 0 | 1 | 3.56793687 | 3.3839 | 0 | -192.6519 | 1467372
MIRANTCANENE | YA7593.1 | P | STATION-2/C$ | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | 5000 | 150000 | 149362.7321 | 0.9957515473172199 | 2.89275701 | 3.5714 | 0 | 129.9517 | 1467372
MIRANTCANENE | YA7593.1 | P | STATION-2/IDX | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | 4739.08494 | 142172.5482 | 141665.3297 | 0.996432373608894 | 0 | 7e-08 | 0 | -129.9517 | 1467372
MIRANTCANENE | YA7593.2 | P | NGMR-AECO/C | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | -5000 | -150000 | -149362.7321 | 0.9957515473172199 | 2.83275701 | 3.4514 | 0 | 129.9517 | 1467372
MIRANTCANENE | YA8854.1 | P | STATION-2/C$ | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | 5000 | 150000 | 149362.7321 | 0.9957515473172199 | 2.89275701 | 3.5614 | 0 | -129.9517 | 1467372
MIRANTCANENE | YA8854.1 | P | STATION-2/IDX | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | 4739.08494 | 142172.5482 | 141665.3297 | 0.996432373608894 | 0 | 7e-08 | 0 | -185.6453 | 1467372
MIRANTCANENE | YA8854.2 | P | NGMR-AECO/C | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | -5000 | -150000 | -149362.7321 | 0.9957515473172199 | 2.83275701 | 3.4514 | 0 | 57691 | 1467371
MIRANTCANENE | YC1650.1 | P | NGMR-AECO/C | 2002-01-01 00:00:00 | 2001-01-31 00:00:00 |  | 0 | 0 | 1 | 3.56793687 | 3.785 | 0 | 7440 | 1467371
MIRANTCANENE | YC1650.1 | P | NGMR-AECO/IDX | 2002-01-01 00:00:00 | 2002-01-31 00:00:00 |  | 0 | 0 | 1 | -0.00131128 | 7e-08 | 0 | -101363.9707 | 1467371
MIRANTCANENE | YE3026.1 | P | NGMR-AECO/C | 2002-01-01 00:00:00 | 2002-03-31 00:00:00 | 5000 | 0 | 0 | 1 | 3.56793687 | 4.655 | 0 | -99870.3434 | 1467371
MIRANTCANENE | YE3026.1 | P | NGMR-AECO/IDX | 2002-01-01 00:00:00 | 2002-03-31 00:00:00 | 4739.084939285714 | 0 | 0 | 1 | -0.00131128 | 7e-08 | 0 | -0.0193 | 1467372
MIRANTCANENE | YF5957.1 | P | STATION-2/C$ | 2002-01-01 00:00:00 | 2002-03-31 00:00:00 | 2000 | 0 | 0 | 1 | 3.79 | 3.67 | 0 | -0.0039 | 1467372
MIRANTCANENE | YF5957.1 | P | STATION-2/IDX | 2002-01-01 00:00:00 | 2002-03-31 00:00:00 | 1895.633975 | 0 | 0 | 1 | 0 | 7e-08 | 0 | -0.009300000000000001 | 1467372
MIRANTCANENE | YF5957.2 | P | NGMR-AECO/C | 2002-01-01 00:00:00 | 2002-03-31 00:00:00 | -2000 | 0 | 0 | 1 | 3.56793687 | 3.47 | 0 | -0.009300000000000001 | 1467372