Spreadsheet: sally_beck__34344__Cashflow Forecast Estate 1-7-02 to corp
Sheet: Format

Enron Net Works - Estate
Sources & (Uses) of Cash
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
* Provide [NAME] |  |  | 2001-12-31 00:00:00 |  | 2002-01-31 00:00:00 |  | 2002-02-28 00:00:00 |  | 2002-03-31 00:00:00 |  | 2002-04-30 00:00:00 |  | 2002-05-31 00:00:00 |  | 2002-06-30 00:00:00 |  | 2002-07-31 00:00:00 |  | 2002-08-31 00:00:00 |  | 2002-09-30 00:00:00 |  | 2002-10-30 00:00:00 |  | 2002-11-30 00:00:00 |  | 2002-12-31 00:00:00 |  | 2003-01-31 00:00:00 |  | 2003-02-28 00:00:00 |  | 2003-03-31 00:00:00 |  | 2003-04-30 00:00:00 |  | 2003-05-31 00:00:00 |  | 2003-06-30 00:00:00 |  | 19 Months
Margin
Revenues (Cash) - Inflows |  |  | 0.4 |  | 0.2 |  | 0.2 |  | 0.2 |  | 0.2 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 1.2
PRMA - Liquidations Inflows |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
PRML - Liquidations Outflows |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Customer Deposits/NBS - Inflows |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Customer Deposits/NBS - Outflows |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Cost of Goods Sold - Outflow |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Total |  |  | 0.4 |  | 0.2 |  | 0.2 |  | 0.2 |  | 0.2 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 1.2
Operating Expenses (see detail)
* Salaries, Wages & Benefits |  |  | -6.6 |  | -6.4 |  | -3.3 |  | -3.2 |  | -3 |  | -2.8 |  | -3.4 |  | -2.6 |  | -2.8 |  | -2.5 |  | -2.7 |  | -2.6 |  | -2.6 |  | -2.1 |  | -2 |  | -1.7 |  | -2 |  | -2 |  | -1.8 |  | -56.1
* Severance |  |  | -7 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -7
* Allocations to NETco |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
* Employee  Expenses |  |  | -0.1 |  | -0.6 |  | -0.5 |  | -0.3 |  | -0.6 |  | -0.3 |  | -0.4 |  | -0.5 |  | -0.4 |  | -0.3 |  | -0.5 |  | -0.2 |  | -0.7 |  | -0.2 |  | -0.3 |  | -0.2 |  | -0.2 |  | -0.3 |  | -0.2 |  | -6.8
* Outside Services |  |  | 0 |  | -0.7 |  | -0.7 |  | -0.7 |  | -0.6 |  | -0.1 |  | -0.1 |  | -0.2 |  | -0.1 |  | -0.1 |  | -0.1 |  | -0.1 |  | -0.1 |  | -0.1 |  | -0.1 |  | -0.1 |  | -0.1 |  | -0.1 |  | -0.1 |  | -4.2
* Technology Expense |  |  | -0.1 |  | -2.1 |  | -1.2 |  | -2.2 |  | -2.2 |  | -3.1 |  | -0.9 |  | -1.1 |  | -1 |  | -0.8 |  | -0.9 |  | -1.1 |  | -0.7 |  | -0.8 |  | -0.8 |  | -1.5 |  | -1.6 |  | -1.2 |  | -1.1 |  | -24.4
* Other Operating Expenses |  |  | -4.5 |  | -1.4 |  | -1.3 |  | -1.1 |  | -1 |  | -0.9 |  | -0.9 |  | -0.9 |  | -0.6 |  | -0.6 |  | -0.6 |  | -0.5 |  | -0.5 |  | -0.5 |  | -0.4 |  | -0.4 |  | -0.4 |  | -1.7 |  | -0.4 |  | -18.6
* Taxes Other Than Income |  |  | -0.7 |  | -0.5 |  | -0.2 |  | -0.5 |  | -0.2 |  | -0.2 |  | -0.6 |  | -0.2 |  | -0.2 |  | -0.2 |  | -0.1 |  | 0 |  | -0.6 |  | 0 |  | 0 |  | -0.1 |  | 0 |  | 0 |  | -0.1 |  | -4.4
Total |  |  | -19 |  | -11.7 |  | -7.2 |  | -8 |  | -7.6 |  | -7.4 |  | -6.3 |  | -5.5 |  | -5.1 |  | -4.5 |  | -4.9 |  | -4.5 |  | -5.2 |  | -3.7 |  | -3.6 |  | -4 |  | -4.3 |  | -5.3 |  | -3.7 |  | -121.5
Other Cash Activity
* Dividend/Interest Income Received |  |  | 0 |  | 0 |  | 0 |  | 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 |  | 0 |  | 0 |  | 0
* Merchant - Proceeds |  |  | 0 |  | 0 |  | 0 |  | 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 |  | 0 |  | 0 |  | 0
Collection of Pre-petition AR |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Payment of Pre-petition AP |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Sale of Inventory & Other Curr Assets |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 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 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Total |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Net Investing
* Proceeds on Sale of Assets |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
* Capital Expenditures |  |  | -1.7 |  | -1.2 |  | -0.2 |  | -0.1 |  | -0.1 |  | -0.2 |  | -0.1 |  | -0.1 |  | -0.1 |  | -0.1 |  | -0.1 |  | -0.1 |  | -0.1 |  | -0.2 |  | -0.2 |  | -0.2 |  | -0.2 |  | -0.2 |  | -0.2 |  | -5.4
* Equity & Other Investing |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Total |  |  | -1.7 |  | -1.2 |  | -0.2 |  | -0.1 |  | -0.1 |  | -0.2 |  | -0.1 |  | -0.1 |  | -0.1 |  | -0.1 |  | -0.1 |  | -0.1 |  | -0.1 |  | -0.2 |  | -0.2 |  | -0.2 |  | -0.2 |  | -0.2 |  | -0.2 |  | -5.4
Financing Activities
* PRML - Prepay Settlements |  |  | 0 |  | 0 |  | 0 |  | 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 |  | 0 |  | 0 |  | 0
* Repayment of Short-term Debt |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
* Increase in Debt
* Interest Expense |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
* Dividends Paid - Third Party |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 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 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Total |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Cash To / (From) Corp |  |  | -20.3 |  | -12.7 |  | -7.2 |  | -7.9 |  | -7.5 |  | -7.6 |  | -6.4 |  | -5.6 |  | -5.2 |  | -4.6 |  | -5 |  | -4.6 |  | -5.3 |  | -3.9 |  | -3.8 |  | -4.2 |  | -4.5 |  | -5.5 |  | -3.9 |  | -125.7
Opening Cash Balance |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Cash Generated/(Used) |  |  | -20.3 |  | -12.7 |  | -7.2 |  | -7.9 |  | -7.5 |  | -7.6 |  | -6.4 |  | -5.6 |  | -5.2 |  | -4.6 |  | -5 |  | -4.6 |  | -5.3 |  | -3.9 |  | -3.8 |  | -4.2 |  | -4.5 |  | -5.5 |  | -3.9 |  | -125.7
CASH (TO) / FROM CORP |  |  | 20.3 |  | 12.7 |  | 7.2 |  | 7.9 |  | 7.5 |  | 7.6 |  | 6.4 |  | 5.6 |  | 5.2 |  | 4.6 |  | 5 |  | 4.6 |  | 5.3 |  | 3.9 |  | 3.8 |  | 4.2 |  | 4.5 |  | 5.5 |  | 3.9 |  | 125.7
Ending Cash Balance |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0