Spreadsheet: sally_beck__34332__Cashflow Forecast Estate 12-18r 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 |  | -3.1 |  | -3.2 |  | -3.1 |  | -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 |  | -52.6
* 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.7 |  | -0.4 |  | -0.2 |  | -0.5 |  | -0.2 |  | -0.3 |  | -0.6 |  | -0.3 |  | -0.2 |  | -0.4 |  | -0.1 |  | -0.6 |  | -0.2 |  | -0.3 |  | -0.1 |  | -0.2 |  | -0.3 |  | -0.1 |  | -5.8
* Outside Services |  |  | 0 |  | -0.7 |  | -0.6 |  | -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.1
* Technology Expense |  |  | -1.6 |  | -1.8 |  | -0.5 |  | -1 |  | -1.5 |  | -2.7 |  | -0.5 |  | -0.8 |  | -0.7 |  | -0.5 |  | -0.6 |  | -0.8 |  | -0.4 |  | -0.5 |  | -0.5 |  | -1.2 |  | -1.5 |  | -0.9 |  | -0.9 |  | -18.9
* Other Operating Expenses |  |  | -4.5 |  | -2 |  | -1.4 |  | -1.1 |  | -1.1 |  | -0.9 |  | -0.7 |  | -0.8 |  | -0.5 |  | -0.5 |  | -0.5 |  | -0.4 |  | -0.4 |  | -0.4 |  | -0.3 |  | -0.3 |  | -0.3 |  | -1.5 |  | -0.3 |  | -17.9
* Taxes Other Than Income |  |  | -0.7 |  | -0.2 |  | -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.1
Total |  |  | -20.5 |  | -8.5 |  | -6.3 |  | -6.6 |  | -6.9 |  | -6.9 |  | -5.6 |  | -5.2 |  | -4.6 |  | -4 |  | -4.4 |  | -4 |  | -4.7 |  | -3.3 |  | -3.2 |  | -3.5 |  | -4.1 |  | -4.8 |  | -3.3 |  | -110.4
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 |  |  | -21.8 |  | -9.5 |  | -6.3 |  | -6.5 |  | -6.8 |  | -7.1 |  | -5.7 |  | -5.3 |  | -4.7 |  | -4.1 |  | -4.5 |  | -4.1 |  | -4.8 |  | -3.5 |  | -3.4 |  | -3.7 |  | -4.3 |  | -5 |  | -3.5 |  | -114.6
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) |  |  | -21.8 |  | -9.5 |  | -6.3 |  | -6.5 |  | -6.8 |  | -7.1 |  | -5.7 |  | -5.3 |  | -4.7 |  | -4.1 |  | -4.5 |  | -4.1 |  | -4.8 |  | -3.5 |  | -3.4 |  | -3.7 |  | -4.3 |  | -5 |  | -3.5 |  | -114.6
CASH (TO) / FROM CORP |  |  | 21.8 |  | 9.5 |  | 6.3 |  | 6.5 |  | 6.8 |  | 7.1 |  | 5.7 |  | 5.3 |  | 4.7 |  | 4.1 |  | 4.5 |  | 4.1 |  | 4.8 |  | 3.5 |  | 3.4 |  | 3.7 |  | 4.3 |  | 5 |  | 3.5 |  | 114.6
Ending Cash Balance |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0