Spreadsheet: rick_buy__32703__100901CashFlow
Sheet: Daily NPW

 | NewPower |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NewPower |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NewPower
 | Daily Cash Flows |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Daily Cash Forecast |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Daily Cash Flow Forecast
 | October 2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | November 2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December 2001
 | M | T | W | TR | F | T | W | TR | F | M | T | W | TR | F | M | T | W | TR | F | M | T | W |  | TR | F | M | T | W | TR | F | M | T | W | TR | F | M | T | W | F | M | T | W | TR | F |  | M | T | W | TR | F | M | T | W | TR | F | M | T | W | TR | F | M | W | T | F
 | Actual | Actual | Actual | Actual | Actual | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | October | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | November | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Totals
 | 2001-10-01 00:00:00 | 2001-10-02 00:00:00 | 2001-10-03 00:00:00 | 2001-10-04 00:00:00 | 2001-10-05 00:00:00 | 2001-10-09 00:00:00 | 2001-10-10 00:00:00 | 2001-10-11 00:00:00 | 2001-10-12 00:00:00 | 2001-10-15 00:00:00 | 2001-10-16 00:00:00 | 2001-10-17 00:00:00 | 2001-10-18 00:00:00 | 2001-10-19 00:00:00 | 2001-10-22 00:00:00 | 2001-10-23 00:00:00 | 2001-10-24 00:00:00 | 2001-10-25 00:00:00 | 2001-10-26 00:00:00 | 2001-10-29 00:00:00 | 2001-10-30 00:00:00 | 2001-10-31 00:00:00 | Totals | 2001-11-01 00:00:00 | 2001-11-02 00:00:00 | 2001-11-05 00:00:00 | 2001-11-06 00:00:00 | 2001-11-07 00:00:00 | 2001-11-08 00:00:00 | 2001-11-09 00:00:00 | 2001-11-12 00:00:00 | 2001-11-13 00:00:00 | 2001-11-14 00:00:00 | 2001-11-15 00:00:00 | 2001-11-16 00:00:00 | 2001-11-19 00:00:00 | 2001-11-20 00:00:00 | 2001-11-21 00:00:00 | 2001-11-23 00:00:00 | 2001-11-26 00:00:00 | 2001-11-27 00:00:00 | 2001-11-28 00:00:00 | 2001-11-29 00:00:00 | 2001-11-30 00:00:00 | Totals | 2001-12-03 00:00:00 | 2001-12-04 00:00:00 | 2001-12-05 00:00:00 | 2001-12-06 00:00:00 | 2001-12-07 00:00:00 | 2001-12-10 00:00:00 | 2001-12-11 00:00:00 | 2001-12-12 00:00:00 | 2001-12-13 00:00:00 | 2001-12-14 00:00:00 | 2001-12-17 00:00:00 | 2001-12-18 00:00:00 | 2001-12-19 00:00:00 | 2001-12-20 00:00:00 | 2001-12-21 00:00:00 | 2001-12-24 00:00:00 | 2001-12-26 00:00:00 | 2001-12-27 00:00:00 | 2001-12-28 00:00:00 | December
Inflows:
Customer Revenues
PECO/PSEG | 2121 |  |  |  |  | 4023 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2200 |  |  |  |  | 2750 |  |  |  |  | 2750 |  |  |  | 2100 |  |  |  |  |  | 2000 |  |  |  |  | 3000 |  |  |  |  | 3500 |  |  |  |  | 3250
CES
- Columbia Energy Services
- Columbia Energy of Ohio |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15750
- Columbia Gas of Pennsylvania |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 1500 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3600
- Columbia Gas of Maryland |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
- Columbia Gas of Virginia |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80
- Atlanta Gas Light |  |  | 1538 |  |  |  | 1000 |  |  |  |  | 1000 |  |  |  |  | 1000 |  |  |  |  | 900 |  |  |  |  |  |  |  |  |  |  | 1900 |  |  |  |  | 1700 |  |  |  |  |  |  |  |  |  | 3750 |  |  |  |  | 4250 |  |  |  |  | 3750 |  |  |  | 3750
- Atlanta Gas Light
- Baltimore Gas & Electric |  |  |  |  | 10 |  |  |  | 10 |  |  |  |  | 10 |  |  |  |  | 10 |  |  |  |  |  | 20 |  |  |  |  | 20 |  |  |  |  | 20 |  |  |  | 20 |  |  |  |  | 75 |  |  |  |  |  | 40 |  |  |  |  | 40 |  |  |  |  | 40 |  |  |  | 40
- NIPSCO ([NAME]) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200 |  |  |  |  |  |  |  |  | 100 |  |  |  |  |  |  |  |  |  |  |  |  | 250 |  |  |  |  |  |  |  |  | 150
- NJ Natural |  |  |  |  |  | 85
- Michigan Cons |  |  |  | 116 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 150 |  |  |  |  |  |  |  |  |  | 150 |  |  |  |  |  |  |  |  |  |  | 300 |  |  |  |  |  |  |  |  |  |  | 200
- Titan (AES) |  |  | 104 |  |  |  | 1096 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 800 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1200
- Washington Gas Light |  |  |  |  |  |  |  |  |  | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 150
Energy USA
Reliant
East Ohio |  |  |  | 58 | 5 |  |  | 70 |  |  |  |  | 75 |  |  |  |  | 75 |  |  |  |  |  | 100 |  |  |  |  | 100 |  |  |  |  | 100 |  |  |  |  | 100 |  |  |  | 100 |  |  |  |  |  | 200 |  |  |  |  | 200 |  |  |  |  | 200 |  |  |  | 200
CoEnergy
Columbus Southern Power
First Energy |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200
Financial Transaction Settlements:
Electricity
Enron(EES)
Enron (ENA)
EPMI
Gas
Financial Transaction Settlements |  |  | -10900 |  | 290 |  |  |  |  |  |  |  |  | -900 | 0 |  |  |  |  |  |  |  |  |  |  | -7400 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -3700
Enron (ENA) - Basis Swaps
Enron (ENA) - Options
Enron (EES)
AIP Interest Income
Interest Income |  |  |  | 247 | 497 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 250 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 250
Total Inflows
Outflows:
Controlled Disbursements(A/P) | 227 | 454 | 324 |  | 995 | 600 | 600 | 600 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 |  | 400 | 400 | 400 | 400 | 400 | 400 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 375 |  | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 350 | 350 | 350 | 350
Controlled Disbursements(Refunds)
Commodity Purchases:
Electricity
- AEP |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 636
- AES Power Direct
- Aquila |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 149
- Cinergy |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 368
- Duke |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -11
- Duquesne
- CSP
- EES |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10664
- Exelon |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 972
- First Energy |  |  |  |  |  |  |  |  | 175 |  |  |  |  |  | 495
- NOVEC
- PJM |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3664
- Nepool
- Power Resources | 0
- PPL |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -27
- EPM |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -3031 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1012
- El Paso |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -170
- TXU
Gas |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7988
- Altrade |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -55
- Aquila Energy |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 217
- AGL Reliant
- Coenergy |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 286
- Coral |  |  |  |  | 318 |  |  |  |  |  |  |  |  |  |  |  |  | 299
- Dominion
- Duke |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 700
- E. Ohio
- El Paso |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 822
- Interstate Gas Supply Inc.
- Columbia Gas Trans. (TCO) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1350 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2750 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6900
- Columbia GULF Trans. (TCO) |  |  |  |  | 273
- Marathon Oil
- PEPCO
- NOVEC
- Energy Co-op
- Southern Natural Gas
- Texican
- Texex
- VEPCO
- NJ Natural
Enron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7138
EES
AOL
IBM |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4400 |  |  |  |  |  |  |  |  | 1500 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3200 |  |  |  |  |  |  |  | 800 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3000 |  |  |  | 1000
IBM - Escrow
JP Rushing
AGL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3100
[NAME]
Marketing
- GSD&M
- Rapp/Optima
- Paradigm
- TLP
- McCann
- WildCard
- Internet Home Alliance
Construction Payments |  |  |  |  |  |  |  | 170 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 300
Payroll |  |  |  |  |  |  | 94 |  | 1250 |  |  |  |  |  |  |  |  | 50 |  |  | 1250 |  |  |  |  |  |  |  |  | 50 |  |  | 1300 |  |  |  |  |  | 50 |  |  |  | 1300 |  |  |  |  |  |  |  | 50 |  |  | 1300 |  |  |  |  |  |  | 50 |  | 1300
Collateral Payments |  |  |  |  |  |  | 105 |  |  |  |  |  |  |  |  |  | 595
- Lumbermens
- Firemans | 175 |  |  |  |  | -700
- RLI |  |  |  | 595
- Prepayments
- Enron
T&E Reimbursements |  |  | 106 |  |  |  | 30 |  |  | 30 |  |  |  |  | 30 |  |  |  |  | 30 |  |  |  |  |  | 30 |  |  |  |  | 30 |  |  |  |  | 30 |  |  |  | 30 |  |  |  |  |  | 30 |  |  |  |  | 30 |  |  |  |  | 30 |  |  |  |  | 30
State Tax Payments |  |  |  |  |  |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500
Wilde (Postage)
Option Energy
Direct Mail (DME) - Fullfillment
Other - Coral |  |  |  |  |  |  |  |  | 4000
Total Outflows
Net Cash Flows
Opening Balance | 32000
Float
Transfer In from CSAM - Peco Escrow |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40000
AIP Investment Returned | 0
Net Flows
Amount Available to Reinvest
Closing Balance
 | M | T | W | TR | F | T | W | TR | F | M | T | W | TR | F | M | T | W | TR | F | M | T | W |  | TR | F | M | T | W | TR | F | M | T | W | TR | F | M | T | W | F | M | T | W | TR | F |  | M | T | W | TR | F | M | T | W | TR | F | M | T | W | TR | F | M | W | T | F
 | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | October | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | November | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Totals
 | 2001-10-01 00:00:00 | 2001-10-02 00:00:00 | 2001-10-03 00:00:00 | 2001-10-04 00:00:00 | 2001-10-05 00:00:00 | 2001-10-09 00:00:00 | 2001-10-10 00:00:00 | 2001-10-11 00:00:00 | 2001-10-12 00:00:00 | 2001-10-15 00:00:00 | 2001-10-16 00:00:00 | 2001-10-17 00:00:00 | 2001-10-18 00:00:00 | 2001-10-19 00:00:00 | 2001-10-22 00:00:00 | 2001-10-23 00:00:00 | 2001-10-24 00:00:00 | 2001-10-25 00:00:00 | 2001-10-26 00:00:00 | 2001-10-29 00:00:00 | 2001-10-30 00:00:00 | 2001-10-31 00:00:00 | Totals | 2001-11-01 00:00:00 | 2001-11-02 00:00:00 | 2001-11-05 00:00:00 | 2001-11-06 00:00:00 | 2001-11-07 00:00:00 | 2001-11-08 00:00:00 | 2001-11-09 00:00:00 | 2001-11-12 00:00:00 | 2001-11-13 00:00:00 | 2001-11-14 00:00:00 | 2001-11-15 00:00:00 | 2001-11-16 00:00:00 | 2001-11-19 00:00:00 | 2001-11-20 00:00:00 | 2001-11-21 00:00:00 | 2001-11-23 00:00:00 | 2001-11-26 00:00:00 | 2001-11-27 00:00:00 | 2001-11-28 00:00:00 | 2001-11-29 00:00:00 | 2001-11-30 00:00:00 | Totals | 2001-12-03 00:00:00 | 2001-12-04 00:00:00 | 2001-12-05 00:00:00 | 2001-12-06 00:00:00 | 2001-12-07 00:00:00 | 2001-12-10 00:00:00 | 2001-12-11 00:00:00 | 2001-12-12 00:00:00 | 2001-12-13 00:00:00 | 2001-12-14 00:00:00 | 2001-12-17 00:00:00 | 2001-12-18 00:00:00 | 2001-12-19 00:00:00 | 2001-12-20 00:00:00 | 2001-12-21 00:00:00 | 2001-12-24 00:00:00 | 2001-12-26 00:00:00 | 2001-12-27 00:00:00 | 2001-12-28 00:00:00 | December
Enron Impact:
Margin Requirement
Mark to Market |  |  |  |  |  |  |  |  | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 |  | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 |  | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600 | -110600
Current Month Settlement |  |  |  |  |  |  |  |  | -14800 | -14800 | -14800 | -14800 | -14800 | -14800 | -14800 |  | -7100 | -7100 | 0 | 0 | 0 | 0 |  | -11500 | -11500 | -11500 | -11500 | -11500 | -11500 | -11500 |  |  |  |  |  |  |  |  |  | -5300 | 0 | 0 | 0 | 0 |  | -17000 | -17000 | -17000 | -17000 | -17000 | -17000 | -17000 | -17000 | -17000 | -17000 | -17000 | -17000 | -17000 | -17000 |  |  |  | 0 | 0
Current Month Purchases
Total Margin Requirement
Substitution Amount |  |  |  |  |  |  |  |  | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 |  | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 |  | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000
Cash Collateral |  |  |  |  |  |  |  |  | 109300
Total Collateral Posted
Due to NewPower/(Enron)
Settled to NewPower/(Enron) |  |  |  |  |  |  |  |  | 0
[NAME] to NewPower/(Enron)
Ending Cash Position
[NAME] 10/05 | 33719 | 33607 | 23919 | 23388 | 22895 | 26141 | 26356 | 25656 | 20016 | 21884.3870967742 | 20371.48387096774 | 20600.51612903227 | 19904.54838709679 | 17743.5806451613 | 6325.612903225818 | 4812.709677419363 | 12346.74193548388 | 1170.774193548394 | 409.8064516129089 | 8458.838709677424 | 5695.93548387097 | 5824.967741935485 |  | 3754 | 22907.33333333333 | 16810.66666666667 | 15060.66666666667 | 16119 | 15352.33333333333 | 15430.66666666667 | 16297 | 15334 | 15092.33333333333 | 14500.66666666667 | 13679 | 15557.33333333333 | 8664.333333333343 | 6322.666666666657 | 2451 | 462.6666666666715 | -1512.333333333328 | 4296 | 2254.333333333328 | 1487.666666666672 |  | 1716 | -662.2258064516063 | -1654.967741935485 | -2497.709677419349 | -1800.451612903213 | 39106.80645161291 | 36728.5806451613 | 39935.83870967742 | 37793.09677419355 | 36790.35483870967 | 39217.61290322582 | 36839.38709677418 | 39546.64516129033 | 37493.90322580645 | 33491.16129032258 | 36843.4193548387 | 24970.19354838709 | 22184.70967741936 | 30006.96774193548
[NAME])
 | Major Changes:
 | EES Receipt |  |  |  | 0.29
 | First Energy Collateral Returned |  |  |  | 0.7
 | Trans. Gas Pipeline WT |  |  |  | -0.273
 | First Energy WT |  |  |  | -0.175
 | Coral Energy WT |  |  |  | -0.32
 | Note: Timing of customer collections has been adjusted based on actual cash received 10/1-10/9.  October total remains the same.
Total Enron Power - October Flow | -6000
Total Enron Gas  - October Flow | -5500
Days in October | 31
Total Enron Power - November Flow
Total Enron Gas  - November Flow
Days in November | 30
Total Enron Power - December Flow | -7200
Total Enron Gas  - December Flow | -13500
Days in December | 31
2001-12-01 00:00:00