Spreadsheet: tracy_geaccone__40534__NNGOrgPLFormatCORP02
Sheet: Format

NORTHERN NATURAL GAS GROUP
2002 PLAN
RESULTS OF OPERATIONS
(Millions of Dollars)
 |  |  | JAN |  | FEB |  | MAR |  | APR |  | MAY |  | JUN |  | JUL |  | AUG |  | SEP |  | OCT |  | NOV |  | DEC |  | TOTAL |  | 1st Qtr |  | 2nd Qtr |  | [NAME] |  | [NAME] |  | Total
Operating Revenues
 | Unrealized MTM |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Commodity Spot Trading |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Gas Sales |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Electricity Sales |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Transportation & Transmission |  | 55.3 |  | 54.3 |  | 57.8 |  | 23.1 |  | 22.1 |  | 25.2 |  | 25.1 |  | 24.7 |  | 24.5 |  | 24.3 |  | 52.5 |  | 53.5
 | Services |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Construction |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Fair Value (Unrealized Gain (Loss) on Merchant Assets) |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Gain (Loss) on sales of merchant investments |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Other |  | 0.8 |  | 0.8 |  | 1.1 |  | 0.7 |  | 0.7 |  | 3.1 |  | 0.7 |  | 0.7 |  | 1.1 |  | 0.7 |  | 1.3 |  | 1.7
Total Revenues
Cost of Sales |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
GROSS MARGIN
Operating Expenses
 | Salaries & Wages
 | Benefits
 | Employee Expenses
 | Outside Services
 | Technology Expense
 | Other Operating Expense
 | Depreciation, depletion & amortization |  | 4.1 |  | 4.1 |  | 4.1 |  | 4.1 |  | 4.1 |  | 4.1 |  | 4.1 |  | 4.1 |  | 4.1 |  | 4.2 |  | 4.2 |  | 4.3
 | Taxes other than income
 |  | Total
OPERATING INCOME
Other Income (Deductions)
 | Equity earnings |  | 0.3 |  | 0.3 |  | 0.3 |  | 0.3 |  | 0.3 |  | 0.8 |  | 0.8 |  | 0.7 |  | 0.7 |  | 0.7 |  | 0.7 |  | 0.7
 | Dividend and Interest income |  | 0 |  | 0 |  | 0.1 |  | 0 |  | 0 |  | 0.1 |  | 0 |  | 0.1 |  | 0 |  | 0 |  | 0 |  | 0.1
 | Gain (Loss) on sale of assets |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 7.6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 5
 | Other |  | 0.2 |  | 0.2 |  | 0.1 |  | 0.3 |  | 0.4 |  | 1.4 |  | 0.2 |  | 0.3 |  | 0.5 |  | 0.5 |  | 0.6 |  | 1.3
 |  | Total
INCOME BEFORE INTEREST & TAXES
Interest Expense
 | Interest expense - Third Party |  | 2.9 |  | 2.9 |  | 2.9 |  | 2.9 |  | 3 |  | 2.9 |  | 2.9 |  | 2.9 |  | 2.9 |  | 2.9 |  | 3 |  | 3
 | Interco interest expense/(income)  - Capital Charge |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Interco interest expense/(income)  - Other |  | -1 |  | -1 |  | -1.1 |  | -1.1 |  | -1.2 |  | -1.1 |  | -1.1 |  | -1.1 |  | -1 |  | -1 |  | -0.9 |  | -0.9
 | Capitalized interest/AFUDC |  | 0 |  | 0 |  | 0 |  | 0 |  | -0.1 |  | 0 |  | 0 |  | 0 |  | 0 |  | -0.1 |  | -0.1 |  | -0.1
 |  | Total
Minority Interest
 | Structured Transactions |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Other |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | Total
Preferred Dividends |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
INCOME BEFORE INCOME TAXES
Income Taxes
 | Payable currently |  | 11.5 |  | 10.9 |  | 12.6 |  | -1.1 |  | -2 |  | 4.1 |  | -0.4 |  | 0 |  | -1.4 |  | -0.7 |  | 11.5 |  | 13.4
 | Payment deferred |  | 0.6 |  | 0.7 |  | 0.7 |  | 0.5 |  | 1.4 |  | 1 |  | 0.1 |  | 0.2 |  | 1.5 |  | 0.3 |  | -0.1 |  | 0.5
 |  | Total
NET INCOME
Adjustments to Net Income
 | Changes in Accounting Principle |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Other |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | Adjusted Net Income
Cash Flow Statement
 |  |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | July |  | Aug |  | Sept |  | Oct |  | Nov |  | Dec |  | TOTAL |  | 1st Qtr |  | 2nd Qtr |  | [NAME] |  | [NAME] |  | Total
CASH FLOW FROM OPERATING ACTIVITIES
NET INCOME
Other Items not affecting cash:
 | Changes in Accounting Principle
 | Depreciation, depletion & amortization
 | Deferred income taxes
 | Net (gain)/loss on sale of assets
 | Unrealized (gain)/loss on price risk mgmt activities |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Merchant Activities
 |  | Realized (Gains) / Losses on Sales | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | Proceeds from Sales | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | Additions | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | Unrealized (Gains)/ Losses | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Other Operating Activities
 |  | Equity Earnings
 |  | Equity/Partnership Distributions | 0 |  | 0 |  | 0.9 |  | 0 |  | -4.5 |  | 1.3 |  | 0 |  | 0 |  | 1.9 |  | 0 |  | 0 |  | 1.9
 |  | Dividends on Pref Securities of Subsidiary Companies
 |  | Income Attributable to Minority Interest
 |  | Other (Including transfers & reclasses; see detail) | 0.3 |  | 0.2 |  | -0.2 |  | 0.3 |  | 0.2 |  | -2.2 |  | 0.2 |  | 0.3 |  | -0.3 |  | 0.3 |  | -0.4 |  | -6.6
 |  | FUNDS FLOW FROM OPERATIONS
Working Capital Changes:
 | Receivables |  | -0.9 |  | 1 |  | -3.5 |  | 34.8 |  | 1 |  | -3.1 |  | 0.1 |  | 0.4 |  | 0.2 |  | 0.2 |  | -28.3 |  | -0.9
 | Inventories |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Prepayments |  | 0.1 |  | 0.1 |  | 0.1 |  | 0.1 |  | 0.1 |  | 0.1 |  | 0.1 |  | 0 |  | 0.1 |  | 0.1 |  | 0.1 |  | -1.1
 | Broker net settlements |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Payables |  | -2.6 |  | -5.3 |  | -0.2 |  | 1.6 |  | 7.1 |  | -1.5 |  | 1.4 |  | 0.8 |  | 1 |  | 0.9 |  | -3.6 |  | -1.9
 | Accrued Taxes |  | 1.3 |  | 1.9 |  | -0.8 |  | 1.7 |  | -3.9 |  | -1.8 |  | 2.3 |  | 1.6 |  | -1.1 |  | 0.4 |  | 1.7 |  | -2.5
 | Accrued Interest |  | 2.9 |  | 2.9 |  | -2.2 |  | 2.9 |  | -0.6 |  | -5.9 |  | 2.9 |  | 2.9 |  | -2.2 |  | 2.9 |  | -0.6 |  | -5.9
 | Customer Deposits |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Changes in Other Current Assets |  | -0.4 |  | -0.4 |  | -0.3 |  | 0.3 |  | 0.3 |  | 0.7 |  | 0.7 |  | 0.8 |  | -2.4 |  | 0.4 |  | 0.5 |  | -0.3
 | Changes in Other Current Liabilities |  | 0.3 |  | 0.3 |  | 0.2 |  | 0 |  | -2.1 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0.2 |  | 0.3
 | TOTAL WORKING CAPITAL CHANGES
CASH FROM OPERATING ACTIVITIES
CASH FLOWS FROM INVESTING
 | Capital Expenditures |  | -1.8 |  | -4.2 |  | -5.6 |  | -11.1 |  | -11 |  | -12.4 |  | -12.7 |  | -12.2 |  | -12.7 |  | -10.4 |  | -10.1 |  | -7.9
 | Property Transfers - Intercompany |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Equity Investments |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Proceeds from Sale of Investments |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 7.6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 5
 | Cash paid for Business Acquisitions |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Other Investing Activity |  | -2.4 |  | -2.3 |  | -2.3 |  | 0 |  | -2.5 |  | -5.8 |  | -5 |  | -5 |  | -10 |  | -6.7 |  | 0 |  | 0
 | CASH FLOWS FROM INVESTING
CASH FLOWS FROM FINANCING
 | Issuance of Long-term Debt |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | (Repayment) of Long-term Debt |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Net Increase/(Decrease) [NAME] Debt |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Issuance of Common Stock |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Issuance of Preferred Stock of Subsidiaries |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | [NAME] to Third Parties - Preferred Stock |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | [NAME] to Third Parties - Common Stock
 | [NAME] to Corp |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Net (acquisition) / disposition of Treasury Stock |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Other Financing Activity |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | CASH FLOWS FROM FINANCING
NET CASH FLOW (After Financing Activities)
Cash and Intercompany Activity
 |  |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | July |  | Aug |  | Sept |  | Oct |  | Nov |  | Dec |  | TOTAL |  | 1st Qtr |  | 2nd Qtr |  | [NAME] |  | [NAME] |  | Total
NET CASH FLOW (After Financing Activities)
CASH FLOWS FROM INTERCOMPANY ACTIVITY
 | Accounts Receivable/Payable - Intercompany |  | -19.7 |  | -16.5 |  | -11.1 |  | -34 |  | 11.7 |  | 18.4 |  | 6.9 |  | 6.6 |  | 20.4 |  | 8.7 |  | 19.7 |  | -0.6
 | Other Investing Activities-Intercompany |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Other Financing Activities-Intercompany |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | (INCREASE)/DECREASE IN CASH AND NOTE FROM CORPORATE
 |  | Increase/(Decrease) in Restricted/Retained Cash