Spreadsheet: john_lavorato__16612__2002 Consol Plan Review Template
Sheet: ENA

 |  |  |  |  |  |  |  | Enron North America
 |  |  |  |  |  |  |  | 2002 Plan Review
 |  | 2001 Forecast |  |  |  |  | 2001 Proforma |  |  |  |  | 2002 Plan
 |  |  | Capital | Direct |  |  |  | Capital | Direct |  |  |  | Capital | Direct | Allocated |  |  | 2001 Forecast | 2002 Plan | Fav/(Unfav)
Team |  | Margin | Charge | Expenses | EBIT |  | Margin | Charge | Expenses | EBIT |  | Margin | Charge | Expenses |  | EBIT |  | Headcount | Headcount | [NAME]
Northeast Trading |  | 182.7 | 0 | 2.9 |  |  | 164.6 | 0 | 3.1 |  |  |  | 0 | 4 |  |  |  | 15 | 23
Northeast Origination |  | 9.8 | 0 | 2.6 |  |  | 9.8 | 0 | 2.4 |  |  | 25 | 0 | 3.2 |  |  |  | 8 | 13
Midwest Trading |  | 107.3 | 0 | 1.9 |  |  | 87 | 0 | 1.7 |  |  |  | 0 | 2.4 |  |  |  | 10 | 15
Midwest Origination |  | 5.2 | 0 | 2.2 |  |  | 5.2 | 0 | 2.4 |  |  | 20 | 0 | 3.1 |  |  |  | 13 | 14
Southeast Trading |  | 15.6 | 0.1 | 1.8 |  |  | 6.3 | 0 | 1.5 |  |  |  | 0 | 2.5 |  |  |  | 13 | 15
Southeast Origination |  | 9.7 | 0.1 | 3.7 |  |  | 9.6 | 0 | 3.7 |  |  | 20 | 0 | 4.6 |  |  |  | 9 | 15
ERCOT Trading |  | 31.7 | 0 | 1.2 |  |  | 27.3 | 0 | 1.3 |  |  |  | 0 | 2.8 |  |  |  | 9 | 16
ERCOT Origination |  | 20.5 | 0 | 1.5 |  |  | 20.4 | 0 | 1.2 |  |  | 20 | 0 | 1.5 |  |  |  | 4 | 6
Options |  | 23.9 | 0 | 0.5 |  |  | 23 | 0 | 0.7 |  |  | 30 | 0 | 1.2 |  |  |  | 3 | 7
Management Book |  | 45.6 | 0 | 11.5 |  |  | 36.8 | 0 | 7.9 |  |  | 30 | 0 | 12.9 |  |  |  | 6 | 7
Genco Control Area |  | 0 | 0 | 0 |  |  | 0 | 0 | 3.4 |  |  | 0 | 0 | 2.5 |  |  |  | 6 | 11
TAC |  | 0 | 0 | 0 |  |  | 0 | 0 | 3.3 |  |  | 0 | 0 | 3.6 |  |  |  | 9 | 12
Services |  | 1.4 | 0 | 0.3 |  |  | 1.4 | 0 | 0.4 |  |  | 10 | 0 | 1.8 |  |  |  | 5 | 10
Development |  | 22.8 | 1 | 8.3 |  |  | 16.6 | 0 | 8.1 |  |  | 15 | 0 | 8.7 |  |  |  | 17 | 19
Generation Investments |  | 28.6 | 64.7 | 7.8 |  |  | 6.4 | 0 | 8.2 |  |  | 20 | 0 | 9.5 |  |  |  | 37 | 39
Structuring/Fundamentals |  | 0 | 0 | 5.4 |  |  | 0 | 0 |  |  |  | 0 | 0
East Power
Trading |  | 794.6 | 0 | 19.3 |  |  | 703.8 | 0 | 20 |  |  |  | 0 | 18.2 |  |  |  | 53 | 54
Middle Market Originations/Services |  | 52.4 | 0 |  |  |  | 48.7 | 0 | 1.4 |  |  |  | 0 | 1.7 |  |  |  | 6 | 10
Originations/Generation |  |  |  |  |  |  | 96.3 | 10.2 | 15.1 |  |  | 75 | 9.7
Executive |  | 11.3 | 0 | 1.3 |  |  | 11.2 | 0 | 4.5 |  |  | 0 | 0 | 5.1 |  |  |  | 23 | 23
Fundamentals |  | 0 | 0 | 0.9 |  |  | 0 | 0 | 0.8 |  |  | 0 | 0 | 1.1 |  |  |  | 6 | 9
West Power
East Trading |  | 30.1 | 3.6 | 10.3 |  |  | 1.9 | 2.8 | 9.5 |  |  |  | 2.8 | 9.6 |  |  |  | 16 | 17
East Origination |  | 9.6 | 0 | 3.5 |  |  | 10.7 | 0 | 2.9 |  |  | 15 | 0 | 4.7 |  |  |  | 10 | 21.5
Central Trading |  | 213.6 | 1.7 | 5.8 |  |  | 178.2 | 0 | 4.5 |  |  |  | 0 | 5.5 |  |  |  | 10 | 16
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 0
Central Origination |  | 4.8 | 0 | 2.8 |  |  | 11 | 1.9 | 3.6 |  |  | 15 | 1.8 | 6 |  |  |  | 20 | 26
Texas Trading |  | 172 | 0 | 4.2 |  |  | 151.9 | 0 | 3.3 |  |  |  | 0 | 3.8 |  |  |  | 7 | 10
Texas Origination |  | 0 | 0 | 0.4 |  |  | 0.1 | 0 | 1.2 |  |  | 10 | 0 | 2.8 |  |  |  | 5 | 12
West Trading |  | -193.1 | 0 | 4.7 |  |  | -239.2 | 0 | 4.8 |  |  |  | 0 | 5.3 |  |  |  | 16.3 | 17.3
West Origination |  | 49.6 | 0 | 2.2 |  |  | 48.3 | 0 | 2.2 |  |  | 25 | 0 | 4 |  |  |  | 11 | 19
Financial Gas |  | 778.2 | 0 | 1.7 |  |  | 710.7 | 0 | 1.7 |  |  |  | 0 | 2.1 |  |  |  | 10.3 | 11.3
Derivative Origination& East Producers |  | 34.4 | 0 | 4.1 |  |  | 26.9 | 0 | 4 |  |  | 35 | 0 | 4.8 |  |  |  | 15 | 19
NG Structuring |  | 0 | 0 | 2.1 |  |  | 0 | 0 | 1.8 |  |  | 0 | 0 | 2.1 |  |  |  | 16.5 | 13.5
NG Fundamentals |  | 0 | 0 | 2 |  |  | 0 | 0 | 1.7 |  |  | 0 | 0 | 2.4 |  |  |  | 15 | 18
Asset Management
Management |  | 254 | 0 | 0 |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  |  |  | 0 | 0
Natural Gas
Natural Gas Trading |  | -30.4 | 0.6 | 4.1 |  |  | -29.3 | 0 | 4.1 |  |  |  | 0 | 4.4 |  |  |  | 15 | 13
Natural Gas Origination |  | 14 | 0 | 1.2 |  |  | 18.7 | 0 | 0.95 |  |  | 25 | 0 | 1.8 |  |  |  | 11 | 15
Finance |  | 12.5 | 3.5 | 0.9 |  |  | 7.5 | 0 | 0.7 |  |  | 0 | 0 | 0.8 |  |  |  | 5 | 5
Alberta Power Trading |  | 253.8 | 0 | 1.4 |  |  | 249.5 | 0 | 1.7 |  |  |  | 0 | 1.2 |  |  |  | 6 | 10
Alberta Power Origination |  | 79.5 | 0 | 0.7 |  |  | 84.7 | 0 | 0.2 |  |  | 25 | 0 | 0.9 |  |  |  | 10 | 9
Ontario Power |  | 12.9 | 0.4 | 2.1 |  |  | 2 | 0 | 1.4 |  |  | 75 | 0 | 2.5 |  |  |  | 14 | 28
Executive |  | 5.1 | 0 | 3.1 |  |  | 3.2 | 0 | 2.4 |  |  | 0 | 0 | 2.5 |  |  |  | 5 | 5
Canada
Upstream Executive |  | 0 | 0 | 0 |  |  | 5.3 | 0 | 1.1 |  |  | 0 | 0 | 0.5 |  |  |  | 7 | 3
Compression Services |  | 0 | 0 | 0 |  |  | 4.9 | 0 | 1.5 |  |  | 12.9 | 0 | 1.1 |  |  |  | 8 | 6
Storage |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  |  |  | 0 | 0
Offshore |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  |  |  | 0 | 0
[NAME] |  | 0 | 0 | 0 |  |  | 1 | 0 | 0.6 |  |  | 4 | 0 | 0.8 |  |  |  | 3 | 4
[NAME] |  | 0 | 0 | 0 |  |  | 0.6 | 0 | 0.5 |  |  | 4 | 0 | 0.8 |  |  |  | 6 | 6
Upstream Products |  | 21 | 1.5 | 4.7 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 24 | 19
Bridgeline |  | 2.9 | 23.1 | 0 |  |  | 2.9 | 18.8 | 0 |  |  | 25 | 21 | 0 |  |  |  | 0 | 0
HPL |  | -70.2 | 0 | 26.8 |  |  | -68.4 | 0 | 31 |  |  | -40 | 0 | 13.6 |  |  |  | 4 | 5
Mexico |  | 18.5 | 0.1 | 5.6 |  |  | 18.2 | 0 | 5.4 |  |  | 20 | 0 | 2.8 |  |  |  | 12 | 13
Energy Capital Services |  |  |  | 7.1 |  |  | 24.8 | 28.1 | 7.4 |  |  | 35 | 35.2 | 8.6 |  |  |  | 30 | 33
Asset Marketing |  | 8 | 0 | 0.9 |  |  | 3 | 0 | 1 |  |  | 0 | 0 | 1.5 |  |  |  | 3 | 8
Principal Investing |  | -6.4 | 9.6 | 1.7 |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  |  |  | 0 | 0
Corporate Development |  | 0 | 0 | 0.7 |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  |  |  | 0 | 0
[NAME] |  | 644.4 | 40.5 | 18.7 |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  |  |  | 0 | 0
Cross Commodity |  | -1.3 | 0 | 0 |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  |  |  | 0 | 0
LT Fundamentals |  | -14.2 | 35.3 | 4.8 |  |  | 0 | 0 | 1.1 |  |  | 0 | 0 | 1.4 |  |  |  | 8 | 9
TVA Settlement |  | 0 | 0 | 253.3 |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  |  |  | 0 | 0
Office of the Chairman |  | -126.3 | 0 | 5.8 |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  |  |  | 0 | 0
Total Commercial
Group |  | 0 | 0 | 212.1 |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  |  | 0 | 0
Non-Allocable costs |  | 0 | 0 | 188.2 |  |  | 0 | 0 | 14.3 |  |  | 0 | 0 | 26.1 |  |  |  | 0 | 0
Bonus |  | 0 | 0 | 0 |  |  | 0 | 0 | 86.2 |  |  | 0 | 0 | 100 |  |  |  | 0 | 0
Prepay Expenses |  | -21.6 | 0 | 95.1 |  |  | -21.6 | 0 | 95.1 |  |  | 0 | 0 | 58.7 |  |  |  | 0 | 0
U.S. Drift |  | 150 | 0 | 3.5 |  |  | 149.9 | 0 | 3.5 |  |  | 50 | 0 | 4.5 |  |  |  | 0 | 0
Facility Costs |  | -60.5 | 0 | 0 |  |  | -60.6 | 0 | 0 |  |  | -43.2 | 0 | 0 |  |  |  | 0 | 0
Capital Charge Offset |  | 8 | -276.5 | 0 |  |  | 0 | -61.8 | 0 |  |  | 0 | -70.5 | 0 |  |  |  | 0 | 0
EBIT
 |  | appears high b/c includes o/s legal that will be pushed to commercial teams; is in commercial forecast 2001