Spreadsheet: james_steffes__12983__Stranded Cost Analysis Structuring Confidential
Sheet: Non-gas CALI_deal_sum

7/11/01 Using 7/10/01 Curves
 |  | Trade | Start | End |  | MWH
Deal | Counter | Date | Date | Date | Delivery | PV'd | Swap Vol | Notional | Deal Vol | Notional | MTM P/L | MTM P/L
Number | Party |  |  |  | Point | Peak | [NAME] | Peak | [NAME] | Total | Total Mid | Total Mid
--------- | ------------------ | -------- | -------- | -------- | ------------------------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ($/MWh)
662938 | Allegheny | 2001-07-06 00:00:00 | 2003-01-01 00:00:00 | 2003-12-31 00:00:00 | NP-15 | 668384 | 0 | 736800 | 0 |  | -19877405
662940 | Calpine | 2001-07-06 00:00:00 | 2001-10-01 00:00:00 | 2011-12-31 00:00:00 | NP-15 | 31446011 | 24645917 | 44224800 | 34667000 |  | -994154252
662940 | Calpine | 2001-07-06 00:00:00 | 2001-07-01 00:00:00 | 2011-12-31 00:00:00 | NP-15 | 34609631 | 27139864 | 47648000 | 37365800 |  | -1231527742
662940 | Calpine | 2001-07-06 00:00:00 | 2001-08-01 00:00:00 | 2021-07-31 00:00:00 | NP-15 | 26554986 | 0 | 47379600 | 0 |  | -2147483648
662978 | Clearwood | 2001-07-09 00:00:00 | 2002-05-31 00:00:00 | 2012-05-31 00:00:00 | NP-15 | 877744 | 688356 | 1228800 | 963600 |  | -41423566
663030 | Coral | 2001-07-09 00:00:00 | 2001-07-01 00:00:00 | 2005-12-31 00:00:00 | NP-15 | 10852649 | 0 | 12575200 | 0 |  | -661063052
662990 | El Paso | 2001-07-09 00:00:00 | 2001-07-09 00:00:00 | 2005-12-31 00:00:00 | NP-15 | 980604 | 0 | 1100800 | 0 |  | -70122316
663001 | Mirant | 2001-07-09 00:00:00 | 2001-06-01 00:00:00 | 2003-12-31 00:00:00 | NP-15 | 183645 | 143932 | 194816 | 152720 |  | -12069872
663001 | Mirant | 2001-07-09 00:00:00 | 2001-06-01 00:00:00 | 2002-12-31 00:00:00 | NP-15 | 3510960 | 0 | 3632000 | 0 |  | -253574379
 |  |  |  |  |  | ------------ | ------------- | ------------ | ------------- | ------------- | -------------
Total for | Region R10
 |  |  |  |  |  | ============ | ============= | ============ | ============= | ============= | =============
662937 | Alleghany | 2001-07-06 00:00:00 | 2001-10-01 00:00:00 | 2011-12-31 00:00:00 | SP-15 | 27374737 | 21459719 | 39612000 | 31056250 |  | -939072124
662975 | Alliance | 2001-07-09 00:00:00 | 2001-08-01 00:00:00 | 2010-07-01 00:00:00 | SP-15 | 493273 | 0 | 623462 | 0 |  | -75169854
662987 | Constellation | 2001-07-09 00:00:00 | 2001-04-02 00:00:00 | 2003-06-30 00:00:00 | SP-15 | 1855037 | 0 | 1942400 | 0 |  | -165463637
663042 | Dynegy | 2001-07-09 00:00:00 | 2002-01-01 00:00:00 | 2004-12-31 00:00:00 | SP-15 | 10688091 | 3603949 | 11801600 | 3980800 |  | -987044991
662990 | El Paso | 2001-07-09 00:00:00 | 2001-04-02 00:00:00 | 2005-12-31 00:00:00 | SP-15 | 980604 | 0 | 1100800 | 0 |  | -58212066
662991 | High Desert | 2001-07-09 00:00:00 | 2003-07-01 00:00:00 | 2011-09-30 00:00:00 | SP-15 | 21850141 | 17159398 | 31137360 | 24449240 |  | -674251353
663046 | Imperial Valley | 2001-07-09 00:00:00 | 2001-06-01 00:00:00 | 2003-12-31 00:00:00 | SP-15 | 183645 | 143932 | 194816 | 152720 |  | -13035452
663003 | Morgan Stanley | 2001-07-09 00:00:00 | 2001-04-02 00:00:00 | 2005-12-31 00:00:00 | SP-15 | 980604 | 768169 | 1100800 | 862450 |  | -82462946
663013 | PG&E | 2001-07-09 00:00:00 | 2001-10-01 00:00:00 | 2011-09-30 00:00:00 | SP-15 | 2438404 | 1911119 | 3272458 | 2564899 |  | -63165408
663004 | [NAME] | 2001-07-09 00:00:00 | 2001-06-01 00:00:00 | 2010-12-31 00:00:00 | SP-15 | 10953933 | 8589887 | 16201120 | 12706080 |  | -414817354
663004 | [NAME] | 2001-07-09 00:00:00 | 2001-04-02 00:00:00 | 2010-12-31 00:00:00 | SP-15 | 9561589 | 0 | 12726400 | 0 |  | -354963187
663004 | [NAME] | 2001-07-09 00:00:00 | 2001-06-01 00:00:00 | 2005-12-31 00:00:00 | SP-15 | 5088036 | 0 | 5860480 | 0 |  | -54726085
663004 | [NAME] | 2001-07-09 00:00:00 | 2003-01-01 00:00:00 | 2010-12-31 00:00:00 | SP-15 | 14363351 | 0 | 19656000 | 0 |  | -231727930
 |  |  |  |  |  | ------------ | ------------- | ------------ | ------------- | ------------- | -------------
Total for | Region R11
 |  |  |  |  |  | ============ | ============= | ============ | ============= | ============= | =============
662988 | Duke | 2001-07-09 00:00:00 | 2001-07-01 00:00:00 | 2001-09-30 00:00:00 | PALO VERDE | 55560 | 0 | 56000 | 0 |  | -2052733
 |  |  |  |  |  | ------------ | ------------- | ------------ | ------------- | ------------- | -------------
Total for | Region R7 |  |  |  |  | 55560 | 0 | 56000 | 0 |  | -2052733
 |  |  |  |  |  | ============ | ============= | ============ | ============= | ============= | =============
663011 | BPA | 2001-07-09 00:00:00 | 2001-04-02 00:00:00 | 2002-04-30 00:00:00 | COB | 70339 | 54662 | 71712 | 55728 |  | 2247714
 |  |  |  |  |  | ------------ | ------------- | ------------ | ------------- |  | -------------
Total for | Region R8 |  |  |  |  | 70339 | 54662 | 71712 | 55728 |  | 2247714
 |  |  |  |  |  | ============ | ============= | ============ | ============= | ============= | =============
Total Power | Price Book
 |  |  |  |  |  | ============ | ============= | ============ | ============= | ============= | =============