Spreadsheet: tracy_geaccone__40469__Functional Income 2001
Sheet: NB

 |  | NBP
 |  | 2001
 |  | Plan |  | Comments
Commercial
Margins
 | [NAME]
 | Demand | 272.5
 | Commodity | 6.9
 | Demand - FTS - 1 | 0
 | Commodity - FTS - 1 | 0
 | Demand - FTS - 2 | 0
 | Commodity - FTS - 2 | 0
 | Demand - Phase IV | 0
 | Commodity - Phase IV | 0
 | IT | 1.8
 | Other - IT, SFTS, PNR, Western | 0
 | Storage | 0
 | Structured Products | 0
 | New Deals | 0
 | Shared Cost Surcharge | 0
 | Provision for Billing Refund | 28.8
 | TC & S Costs
 | Other - Penalties | 0
 | - PPA | 0
 | - Other | 0
 | Other Revenues:
 | Black Mesa | 21.1
 | Crestone | 43.6
 | Total Margins
Expenses
 | GRI/ACA | -2
 | Reg Commission Expense | 0
 | Reg Assets Amortization | -1
 | Reg Affairs | -0.5
 | Rate Case Amortization (0705) | 0
 | IMP/So GA Credits | 0
 | TC&S Mobil Carlton | 0
 | TC&S Base Gas SBA | 0
 | Net Fuel/UAF | 0
 | Revenue Management | 0
 | Direct  - Gross | 0
 | - Marketing | -2.8
 | Capitalization | 0
 | Other  - Gomez Sale in 2001 | 0
 | ETS Support | 0 |  | Where are [NAME]'s expenses? CC111703
 | Aviation | 0
 | Payroll Taxes | 0 | 0
 | Omaha Rent | 0
 | Total Expenses
Margin Net of Expenses
Non-Recurring Elements
 | Base Gas | 0
 | Asset Sales | 0
 | Structured Products | 0
 | ECS Deals | 0
 | El Paso Settlement | 0
 | Rate Case Items | 0
 | WIC Shipper Credits | 0
 | Stretch | 0
 | Other | 0
 | Total Non Recurring
Net Contribution Commercial
Market Services
Other Income |  | 0
Expenses
 | Direct - Gross | -1.7
 | Amortization (Encore) | 0
 | Capitalization | 0
 | [NAME] | 0
 | Payroll Taxes | 0 | 0
 | Other Expenses - G&A | 0
 | Total Expenses
Net Contribution Market Services
Net Contribution from Markets
Operations
Other Income |  | 0.3
CESI |  | 0
Expenses
 | Field Operations - Gross | -12.6
 | Field Operations for Expansions | -1
 | Capitalization | 0.1
 | Group Operations(OTS) | -0.7 |  | This should only be $(0.3)
 | Operations Support | 0
 | Electric Compression | -4.4
 | Insurance | -0.8
 | Allocations In from HPL
 | Overhaul Amortizations | 0
 | OTS Work Order Amortization | 0
 | Payroll Taxes | 0 | 0
 | Other Expenses - PCB and Env. | 0
 | Total Expenses
Non-Recurring Elements
 |  | 0
 |  | 0
 | Total Non Recurring
Net Contribution Operations
Finance, Accounting & Admin
Other Income |  | 0
 | FAS 133 | 0
 | AFUDC Amortization (Phase III) | 0
Trading |  | 0
Expenses
 | Accounting | -0.7
 | Finance | -3.4
 | Commercial Support | 0
 | Operations Support | 0
 | Market Services / IT Support | 0
 | Executive | 0
 | Direct Support | 0
 | NBP Direct | -0.3
 | Black Mesa Direct | -13.5
 | Crestone Direct | -24.7
 | ETS Support | -0.1
 | Capitalization - Support | 0
 | Company Bonus | -1.6
 | Capitalization - Bonus | 0
 | Other Expenses - G&A, Exec | 0
 | Bonus - ETS | -1.9 |  | Should be ETS Bonus Allocation CC111724
 | Corporate Overhead - ETS | 0 |  | Should be ETS Corporate Allocation CC 111723
 | Payroll Taxes | 0 | 0
 | Amortizations (Ramp up) | 0
 | DD&A | -62.7
 | Corporate:
 | Allocated - MMF | -3
 | Direct | -1
 | EP&S | -1.6
 | Total Corporate
 | Other Taxes:
 | Ad Valorem | -27.3
 | Total Other Taxes
 | Reserves | 0
 | Total Expenses
Net Contribution FA&A
Information Technology
Other Income - Lucent Credit |  | 0
DD&A - Lucent |  | 0
Expenses
 | Direct Support - Gross | -2.9
 | Capitalization | 1
 | Commercial Support | 0
 | Field Operations Support | 0
 | ETS Support - Gross | -0.6 |  | Should be $(.3)
 | Capitalization | 0
 | Other Expenses | -0.5
 | Payroll Taxes | 0 | 0
 | Amortization | 0
 | EIS | -0.3
 | Total Expenses
Net Contribution IT
Legal
Expenses
 | Commercial Support - ETS | 0
 | Field Operations Support - ETS | 0
 | Deferred Legal Expense | 0
 | Other | -1.3
 | Total Expenses
Human Resources/Communications
Expenses
 | ETS Support - Gross | -0.5
 | Capitalization | 0
 | Other Expenses - G&A | 0
 | Total Expenses
Executive & Other
Expenses
 | Direct  - Gross | -0.5
 | ETS Support | -0.9 |  | This should only contain allocations from:
 | Aviation - Stan | 0 |  | 111725, 111692, 112215, 111719, 111721
 | Amortizations (Prepaid EDS Amort.) | 0 |  | Aviation should be $ (0.1) from 111722
 | Other (G&A, add Capitalized, 0705 | 0
 | Total Expenses
Total Net Contribution
Other Expenses:
 | Other - G&A | -0.1 |  | Needs a home
 | Mangement Overview | 0
 | Other O&M Adjustment | 0
 | Other Taxes:
 | Payroll Taxes | 0 | 0
 | Other (Payroll/Franchise/Other) | 0
 | Total Other Taxes
 | Total Other Expenses
Other Income(Deductions)
Equity Earnings:
 | Northern Plains | 0
 | Enron Citrus | 0
 | EOTT | 0
 | Bighorn, Fort Union, Lost Creek | 5.7
 | Income Investment | 0
 | Pathnet | 0.9
 | AFUDC Equity | 1.7
 | Overview | 0
 | Other
 | Other - Minority Interest Income | -37.9
 | Total Other Income(Deductions)
 | Mont Belvieu | 0
Income Before Interest and Taxes
 | AFUDC | 0
 | Interest | -88.3
Pretax Income
 | Income Taxes | 0
Net Income Before Financing
 | Financing | 0
Net Income