Spreadsheet: louise_kitchen__24070__CashPlan_11
Sheet: EREC

ENRON RENEWABLE ENERGY CORP.
Sources & Uses of Cash - Dec 2001 thru Dec 2002
 |  | Week Ended |  |  |  |  |  |  |  |  |  | 2001 |  | 2002
 |  | 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 |  | TOTAL
Revenues (Cash) |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 37.7 |  | 26.8 |  | 29.5 |  | 37.8 |  | 37.1 |  | 87.6 |  | 39 |  | 65.7 |  | 91.4 |  | 139.7 |  | 113.9 |  | 118.4
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 |  |  |  | 1 |  | 17 |  | -2.3 |  | -4.6 |  | 8.9 |  | 15.8 |  | 22.6 |  | -14.1 |  | -6.2 |  | -5.7 |  | -2.1 |  | -10.6
Cost of Goods Sold |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | -42.4 |  | -33 |  | -31.4 |  | -39.8 |  | -38.7 |  | -79.9 |  | -41.9 |  | -63.4 |  | -83.5 |  | -119.4 |  | -97.7 |  | -106.4
"Gross Margin"
Operating Expenses
Severance |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | -2.125 |  | -2.125 |  | -2.125 |  | -1.42375 |  | -0.7225 |  | 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.1 |  | 0 |  | 0 |  | 0
Other Operating Income |  | -0.1 |  | 0 |  | 0 |  | 0 |  | -0.1 |  |  |  | -0.1 |  | 0 |  | 0 |  | 0 |  | 0 |  | -0.1 |  | 0 |  | -0.1 |  | 0 |  | 0 |  | 0 |  | 0
Equity Distributions |  | 0 |  | 0 |  | 0 |  | 4.2 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other Funds Flow |  | 1.5 |  | 1.4 |  | 1.4 |  | 1.4 |  | 0.3000000000000007 |  |  |  | 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 |  |  |  | 18.4 |  | 6.8 |  | 23.3 |  | -1.4 |  | -14.3 |  | -10.4 |  | -0.4000000000000017 |  | -11.8 |  | 3.3 |  | -26.2 |  | -5 |  | 38.7
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 |  | 70 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Capital Expenditures |  | -11 |  | -14 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
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 |  | -2.6 |  | -2.2 |  | -2.2 |  | -2.2 |  | -0.9 |  |  |  | -10 |  | -10 |  | -10 |  | -10 |  | -10 |  | -10 |  | -10 |  | -10 |  | -10 |  | -10 |  | -10 |  | -10
Other Operating Expenses |  | -1.01 |  | -0.87 |  | -0.87 |  | -0.87 |  | -0.365 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Adjustments |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Chapter 11 Reductions |  | 2.21 |  | 1.87 |  | 1.87 |  | 1.87 |  | 0.765 |  |  |  | 8.5 |  | 8.5 |  | 8.5 |  | 8.5 |  | 8.5 |  | 8.5 |  | 8.5 |  | 8.5 |  | 8.5 |  | 8.5 |  | 8.5 |  | 8.5
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