Spreadsheet: richard_shapiro__32381__Stranded Cost Analysis Structuring Confidential3
Sheet: Non-gas CALI_deal_sum

10/1/01 using 9/28/01 Curves
 |  | Trade | Start | End
Deal | Counter | Date | Date | Date | Delivery | PV'd | Swap Vol | Notional | Deal Vol | Notional | MTM P/L | MTM P/L
Number | Party | MM/DD/YY | MM/DD/YY | MM/DD/YY | 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 | 694001 | 0 | 736800 | 0 |  | -25343320
662940 | Calpine | 2001-07-06 00:00:00 | 2001-10-01 00:00:00 | 2011-12-31 00:00:00 | NP-15 | 33826556 | 26513315 | 44221600 | 34665400 |  | -1458468802
662940 | Calpine | 2001-07-06 00:00:00 | 2001-07-01 00:00:00 | 2011-12-31 00:00:00 | NP-15 | 36870109 | 28914870 | 47420800 | 37189800 |  | -1767495280
662940 | Calpine | 2001-07-06 00:00:00 | 2001-08-01 00:00:00 | 2021-07-31 00:00:00 | NP-15 | 28910516 | 0 | 47304720 | 0 |  | -2147483648
662978 | Clearwood | 2001-07-09 00:00:00 | 2002-05-31 00:00:00 | 2012-05-31 00:00:00 | NP-15 | 942993 | 739520 | 1228800 | 963600 |  | -55183513
663030 | Coral | 2001-07-09 00:00:00 | 2001-10-01 00:00:00 | 2005-12-31 00:00:00 | NP-15 | 11077111 | 0 | 12293600 | 0 |  | -740647039
662990 | El Paso | 2001-07-09 00:00:00 | 2001-07-09 00:00:00 | 2005-12-31 00:00:00 | NP-15 | 961704 | 0 | 1044000 | 0 |  | -85415179
663001 | Mirant | 2001-07-09 00:00:00 | 2001-06-01 00:00:00 | 2002-12-31 00:00:00 | NP-15 | 3005752 | 0 | 3064000 | 0 |  | -342719013
 |  |  |  |  |  | ------------ | ------------- | ------------ | ------------- | ------------- | -------------
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 | 29577065 | 23187706 | 39608000 | 31054250 |  | -1406259825
662975 | Alliance | 2001-07-09 00:00:00 | 2001-08-01 00:00:00 | 2010-07-01 00:00:00 | SP-15 | 494209 | 0 | 596173 | 0 |  | -84213305
662987 | Constellation | 2001-07-09 00:00:00 | 2001-04-02 00:00:00 | 2003-06-30 00:00:00 | SP-15 | 1668632 | 0 | 1715200 | 0 |  | -198854961
663042 | Dynegy | 2001-07-09 00:00:00 | 2002-01-01 00:00:00 | 2004-12-31 00:00:00 | SP-15 | 11079925 | 3736431 | 11801600 | 3980800 |  | -1238246742
662990 | El Paso | 2001-07-09 00:00:00 | 2001-04-02 00:00:00 | 2005-12-31 00:00:00 | SP-15 | 961704 | 0 | 1044000 | 0 |  | -73628512
662991 | High Desert | 2001-07-09 00:00:00 | 2003-07-01 00:00:00 | 2011-09-30 00:00:00 | SP-15 | 23584293 | 18520908 | 31137360 | 24449240 |  | -988655168
663046 | Imperial Valley | 2001-07-09 00:00:00 | 2001-06-01 00:00:00 | 2003-12-31 00:00:00 | SP-15 | 170211 | 133579 | 176640 | 138640 |  | -18676515
663003 | Morgan Stanley | 2001-07-09 00:00:00 | 2001-04-02 00:00:00 | 2005-12-31 00:00:00 | SP-15 | 961704 | 753894 | 1044000 | 818450 |  | -107460535
663013 | PG&E | 2001-07-09 00:00:00 | 2001-10-01 00:00:00 | 2011-09-30 00:00:00 | SP-15 | 2600740 | 2038679 | 3271392 | 2564366 |  | -114549360
663004 | [NAME] | 2001-07-09 00:00:00 | 2001-10-01 00:00:00 | 2010-12-31 00:00:00 | SP-15 | 11854876 | 9296947 | 16161280 | 12675240 |  | -592038956
663004 | [NAME] | 2001-07-09 00:00:00 | 2001-10-01 00:00:00 | 2010-12-31 00:00:00 | SP-15 | 9999526 | 0 | 12527200 | 0 |  | -468660256
663004 | [NAME] | 2001-07-09 00:00:00 | 2001-10-01 00:00:00 | 2005-12-31 00:00:00 | SP-15 | 5156949 | 0 | 5701120 | 0 |  | -119975014
663004 | [NAME] | 2001-07-09 00:00:00 | 2003-01-01 00:00:00 | 2010-12-31 00:00:00 | SP-15 | 15415990 | 0 | 19656000 | 0 |  | -333168588
 |  |  |  |  |  | ------------ | ------------- | ------------ | ------------- | ------------- | ------------- | -------------
Total for | Region R11
 |  |  |  |  |  | ============ | ============= | ============ | ============= | ============= | ============= | =============
663011 | BPA | 2001-07-09 00:00:00 | 2001-04-02 00:00:00 | 2002-04-30 00:00:00 | COB | 50755 | 39494 | 51264 | 39888 |  | -2544240
 |  |  |  |  |  | ------------ | ------------- | ------------ | ------------- | ------------- | ------------- | -------------
Total for | Region R8 |  |  |  |  | 59547 | 46794 | 60480 | 47520 |  | -1872822
 |  |  |  |  |  | ============ | ============= | ============ | ============= | ============= | ============= | =============
Total Power | Price Book |  |  |  |  | 222542842 | 109694416 | 302792496 | 148679103
 |  |  |  |  |  | ============ | ============= | ============ | ============= | ============= | ============= | =============