Spreadsheet: tracy_geaccone__40469__Functional Income 2001
Sheet: NNG

 |  | NNG
 |  | 2001
 |  | Plan |  | Comments
Commercial
Margins
 | [NAME]
 | Demand | 342
 | Commodity | 36.7
 | 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 | 0
 | Other - IT, SFTS, PNR, Western | 0
 | Storage | 37
 | Structured Products | 7.7
 | New Deals | 5.5
 | Shared Cost Surcharge | 0
 | Provision for Billing Refund | 0
 | TC & S Costs | 0
 | Other - Penalties | 1
 | - PPA | 0
 | - Other | 0.3
 | Other Revenues:
 | Black Mesa | 0
 | Crestone | 0
 | Total Margins
Expenses
 | GRI/ACA | -9.8
 | Reg Commission Expense | -0.7
 | Reg Assets Amortization | -5.9
 | Reg Affairs | 0
 | Rate Case Amortization (0705) | 0
 | IMP/So GA Credits | 0.7
 | TC&S Mobil Carlton | -1.7
 | TC&S Base Gas SBA | -14.3
 | Net Fuel/UAF | 0
 | Revenue Management | -0.9
 | Direct  - Gross
 | - Marketing | 0
 | Capitalization | 1.4
 | Other  - Gomez Sale in 2001
 | ETS Support | 0 |  | Where are [NAME]'s expenses? CC111703
 | Aviation |  |  |  | Included in the GPG allocations from co. 366
 | Payroll Taxes | 0 | 0
 | Omaha Rent
 | Total Expenses
Margin Net of Expenses
Non-Recurring Elements
 | Base Gas | 0
 | Asset Sales | 9.9
 | Structured Products | 5
 | ECS Deals | 0
 | El Paso Settlement | 0
 | Rate Case Items | 0
 | WIC Shipper Credits | 0
 | Stretch | 4.1
 | Other | 0
 | Total Non Recurring
Net Contribution Commercial
Market Services
Other Income |  | 0
Expenses
 | Direct - Gross
 | Amortization (Encore) | 0
 | Capitalization | 0.5
 | [NAME] | 3.7
 | Payroll Taxes | 0 | 0
 | Other Expenses - G&A | 0
 | Total Expenses
Net Contribution Market Services
Net Contribution from Markets
Operations
Other Income |  | 0
CESI |  | 0
Expenses
 | Field Operations - Gross
 | Field Operations for Expansions | 0
 | Capitalization | 10.6
 | Group Operations(OTS)
 | Operations Support
 | Electric Compression | 0
 | Insurance | 0
 | Allocations In from HPL | 0
 | Overhaul Amortizations | 0
 | OTS Work Order Amortization | 0
 | Payroll Taxes | 0 | 0
 | Other Expenses - PCB and Env.
 | 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
 | Finance | 0
 | Commercial Support | 0
 | Operations Support | 0
 | Market Services / IT Support | 0
 | Executive | 0
 | Direct Support
 | NBP Direct | 0
 | Black Mesa Direct | 0
 | Crestone Direct | 0
 | ETS Support
 | Capitalization - Support | 0.4
 | Company Bonus
 | Capitalization - Bonus | 1
 | Other Expenses - G&A, Exec |  |  | What is this?
 | Bonus - ETS |  |  |  | Break out of the amount:
 | Corporate Overhead - ETS |  |  |  | -0.1 | Exec Direct (costs remaining in Bill Cordes cost center for NNG)
 | Payroll Taxes | 0 | 0 |  | -0.3 | Operatiion Information (OI) Amortization - completes June 2001)
 | Amortizations (Ramp up) | 0 |  |  | -0.1 | Service Awards
 | DD&A | -48.4 |  |  | -0.1 | Arthur Andersen Audit Fees
 | Corporate: |  |  |  | -0.1 | Computer Systems Misc. Expenses
 | Allocated - MMF |  |  |  |  | Total
 | Direct
 | EP&S
 | Total Corporate
 | Other Taxes:
 | Ad Valorem | -27.4
 | Total Other Taxes
 | Reserves | 0
 | Total Expenses
Net Contribution FA&A
Information Technology
Other Income - Lucent Credit |  | 2.3
DD&A - Lucent |  | -1.2
Expenses
 | Direct Support - Gross
 | Capitalization | 0.3
 | Commercial Support | 0
 | Field Operations Support | 0
 | ETS Support - Gross
 | Capitalization
 | Other Expenses
 | Payroll Taxes | 0 | 0
 | Amortization | 0
 | EIS
 | Total Expenses
Net Contribution IT
Legal
Expenses
 | Commercial Support - ETS
 | Field Operations Support - ETS
 | Deferred Legal Expense | 0
 | Other | 0
 | Total Expenses
Human Resources/Communications
Expenses
 | ETS Support - Gross
 | Capitalization | 0.3
 | Other Expenses - G&A | 0
 | Total Expenses
Executive & Other
Expenses
 | Direct  - Gross | 0
 | ETS Support |  |  | ETS Total allocations missing $0.2
 | Aviation - Stan |  |  |  | Payroll Taxes were reclassified to "TOTI" on the Inc. Stmt
 | Amortizations (Prepaid EDS Amort.) | 0 |  |  | consistent with how Actuals have been reclassified by Acct
 | Other (G&A, add Capitalized, 0705 | 0
 | Total Expenses
Total Net Contribution
Other Expenses:
 | Other - G&A | 0
 | Mangement Overview | 7.9
 | Other O&M Adjustment | 0
 | Other Taxes:
 | Payroll Taxes | 0 | 0
 | Other (Payroll/Franchise/Other) | -6.2
 | Total Other Taxes
 | Total Other Expenses
Other Income(Deductions)
Equity Earnings:
 | Northern Plains | 0
 | Enron Citrus | 0
 | EOTT | 0
 | Bighorn, Fort Union, Lost Creek | 0
 | Income Investment | 0
 | Pathnet | 0
 | AFUDC Equity | 0
 | Overview | 0
 | Other | 0
 | Other - Minority Interest Income | -0.1 |  | What is this?  Probably needs a new home
 | Total Other Income(Deductions) |  |  |  | Other Miscellaneous 3rd Party Interest Income
 | Mont Belvieu | 0
Income Before Interest and Taxes
 | AFUDC | 0
 | Interest | 0
Pretax Income
 | Income Taxes | 0
Net Income Before Financing
 | Financing | 0
Net Income