Spreadsheet: louise_kitchen__24081__CashPlan_11
Sheet: NNG

Northern Natural Gas
Sources & Uses of Cash - Dec 2001 thru Dec 2002
 |  | Week Ended |  |  |  |  |  |  |  |  |  | 2001 |  | 2002 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2003
 |  | 2001-12-08 00:00:00 |  | 2001-12-15 00:00:00 |  | 2001-12-22 00:00:00 |  | 2001-12-29 00:00:00 |  | 2001-12-31 00:00:00 |  | Dec |  | JAN |  | FEB |  | MAR |  | APR |  | MAY |  | JUN |  | JUL |  | AUG |  | SEP |  | OCT |  | NOV |  | DEC |  | JAN |  | FEB |  | MAR |  | APR |  | MAY |  | JUN |  | TOTAL
Revenues (Cash) |  | 14.5 |  | 12.7 |  | 12.7 |  | 12.7 |  | 3.500000000000007 |  |  |  | 56.1 |  | 55.1 |  | 58.9 |  | 23.8 |  | 22.8 |  | 28.3 |  | 28.8 |  | 25.4 |  | 25.6 |  | 25 |  | 53.8 |  | 55.2
PRMA - Liquidations |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Customer Deposits/Broker Settlements |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Cost of Goods Sold |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
"Gross Margin"
Operating Expenses
Severance |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Interest Expense |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Current Taxes |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Dividend/Interest Income |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other Operating Income |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Equity Distributions |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other Funds Flow |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Merchant - Proceeds |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Merchant - Additions |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other Working Capital |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0.7 |  | 0.5 |  | -6.7 |  | 41.4 |  | 1.9 |  | -11.5 |  | 7.5 |  | 6.5 |  | -4.5 |  | 5 |  | -30 |  | -12.3
Other |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other Operating cash
Proceeds on Sale of Assets |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 7.6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 5
Capital Expenditures |  | -0.5 |  | -0.4 |  | -0.4 |  | -0.4 |  | -0.09999999999999987 |  |  |  | -1.8 |  | -4.2 |  | -5.6 |  | -11.1 |  | -11 |  | -12.4 |  | -12.7 |  | -12.2 |  | -12.7 |  | -10.4 |  | -10.1 |  | -7.9
Other Investing |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Net Investing
PRMA - Prepay Settlements |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 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 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Dividends - Preferred Stock |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Dividends - Common Stock |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
[NAME] to Corp |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Treasury Stock Activity |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Off-Balance Sheet Refinancings |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Financing Outflows
Sub-Total
PRMA - Prepay Inflows |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
New Long-Term Debt |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Short-term Debt (net) |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Issuance of Stock |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Financing Inflows
Cash To / (From) Corp
Memo:
Operating Expenses (Cash)
Employee Related Expenses |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other Operating Expenses |  | -5.2 |  | -4.5 |  | -4.5 |  | -4.5 |  | -1.3 |  |  |  | -20 |  | -20.2 |  | -19.7 |  | -20 |  | -19.3 |  | -19.3 |  | -21.5 |  | -20.2 |  | -20.5 |  | -21.2 |  | -20.1 |  | -20.7
Adjustments |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Chapter 11 Reductions |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Transfers to NETCo. |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Net