Spreadsheet: robin_rodrigue__33265__CAN$1100
Sheet: PriceEOL

Roll Forward Schedule
Book: | Canadian Gas (C4) -EOL | Canadian $
Accounting Month:
Date:
Current Day Post ID: |  |  |  |  |  |  |  |  |  | NOTIONAL VOLUMES |  |  |  |  |  |  |  | CALCULATED LONG/SHORT |  |  | Permanent Volume Adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | Long | Short |  | When system was changed over from Lotus to Oracle, a discrepancy
[NAME] MTM Gain (Losses) |  |  | Prior | Today |  | Source |  |  |  | Current Day |  |  |  |  |  |  |  |  |  |  | between the Oracle volumes and Lotus volumes was discovered
Mid P/L Swaps |  |  | 32191381 | 35284348 | [NAME] | (Oracle  - P&L Top Page) |  |  |  | Long | 0 | 0 | 0 | 0 | 0 | 0
Mid P/L Options |  |  | 0 | 0 | [NAME] | (Oracle  - P&L Top Page) |  |  |  | Short | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | An assumption was made the Lotus volumes (which were higher)  were more accurate;
GAS DAILY SWAPS |  |  | 0 | 0 | [NAME] | (Oracle - Rpt RSX0280 - Options daily P/(L) [NAME]) |  |  |  | Options | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | therefore adjustment to Oracle volumes is as follows:
NYMEX Futures MTM Value |  |  | 0 | 0 | [NAME] | (Oracle - NYMEX Accounting Summary Schedule) |  |  |  | Futures | 0 | 0 | 0 | 0 | 0 | 0
Foreign Currency |  |  | -32866215 | -34825257 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Use March 1995 as basis for adjustment |  |  | PERMANENT
Rho/Drift  Adjustments - Schedule A |  |  |  |  | Cell Ref |  |  |  |  | Net Notional |  |  |  |  |  |  |  |  |  |  |  |  |  | ADJUSTMENT
Transactions ex Oracle - Schedule B |  |  |  |  | Cell Ref |  |  |  |  | Volatility | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | PER ORACLE | PER ROLL | (/1,000,000)
Perm Book Adjustments - Schedule C |  |  |  |  | Cell Ref |  |  |  |  | Net PV | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | Purchase Position | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales Position | 0 | 0
 |  |  |  |  |  |  |  |  |  | Prior Month |  |  |  |  |  |  |  |  |  |  | Net Position
Gross Book Balance |  |  |  |  |  |  |  |  |  | Long | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | Short | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | Current Month Gross Book Balance with Current Month Rho/Drift Impact)
II. Prudency |  |  |  |  |  |  |  |  |  | Options | 0 | 0 | 0 | 0 | 0 | 0
Prior Month Prudency Balance |  |  |  | 0 | [NAME] |  |  |  |  | Futures | 0 | 0 | 0 | 0 | 0 | 0
Current Month Prudency |  |  |  |  | [NAME]
Current Month Prudency Balance |  |  |  |  | Cell Ref |  |  |  |  | Net Notional
Accounting Adjustments - Schedule D
Total Prudency
III. [NAME] (Losses) |  |  |  |  |  |  |  |  |  | ROLL TESTS |  | Book Balance | Prudency
Prior Month LTD Liquidations |  |  |  | 2431713 | [NAME] |  |  |  |  | Prior Month
Current Month Swap/Options Liquidations |  |  |  |  | Cell Ref |  |  |  |  | Gross Book Balance |  | 582322 |  | [NAME]
Current Month NYMEX Futures Liquidations |  |  |  |  | Cell Ref |  |  |  |  | Prudency |  | 0 |  | [NAME]
Current Month NYMEX Option Premiums |  |  |  |  | Cell Ref |  |  |  |  | LTD Liquidations |  | 2431713 |  | [NAME]
Current Month Spot Liquidations |  |  |  |  | Cell Ref
Current Month Liquidation Adjustments (Book/Acct Recon) |  |  |  |  | Cell Ref |  |  |  |  | Current MTD Daily |  |  |  | Daily Total Below
Prior Period Liquidations Adjustment - Sched E |  |  |  |  | Cell Ref
Current Month LTD Liquidations |  |  |  |  |  |  |  |  |  | Total
IV. [NAME] |  |  |  |  |  |  |  |  |  |  | Difference
OTC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DO NOT REMOVE
 | Ttl [NAME] => |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Value | Day of the Week
SENSITIVITY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | S
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | M
 | MTD Cumulative |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | T
Price [NAME] |  | -94884 |  | -282342 |  |  | -7124 | 868634 | -1657410 | -160466 | -108631 |  |  | 1351214 |  |  | -4046578 | 57714 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | W
Basis Curve Shift |  | -156453 | 124887 | 4987 |  |  | 227345 | 33901 | -36384 | 86023 | 59406 |  |  | -37523 |  | -136337 | -28292 | -191065 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | R
Index [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | F
Gas Daily Curve Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | S
FX Curve Shift |  | 5603463 | -871609 | 412984 |  |  | -759430 | 1245990 | 2655709 | 2920177 | -2540439 |  |  | 738543 | 623486 | 3504860 | 440906 | 1933791
[NAME]
New Deals |  |  |  | -399750 |  |  |  | -393038 | 1706564 |  |  |  |  | 136887 |  |  | 389989 | 1289192
Foreign Currency-FX Book |  | -5476887 | 818000 | -412715 |  |  | 737022 | -1242611 | -2688061 | -3155387 | 2522513 |  |  | -740395 | -588695 | -3479023 | -452215 | -1955037
Gamma
Vega
Theta
Rho |  | 511 | -423 | -162 |  |  | -251 | 457 | -356 | 38 | -328 |  |  | 72 | 222 | 201 | 84 | -731
Drift |  | 3146 | 3122 | 3107 |  |  | 9195 | 3015 | 3285 | 3707 | 3955 |  |  | 10752 | 3947 | 4028 | 4722 | 4204
Origination
Liquidations - Book
2nd Order
Prudency
FX Rho |  | -709 | 952 | 502 |  |  | 241 | -600 | 947 | 207 | 588 |  |  | -52 | -562 | -170 | -286 | 1475
FX Drift |  | -3033 | -3854 | -3735 |  |  | -11419 | -3691 | -3883 | -4321 | -4804 |  |  | -13216 | -4525 | -4617 | -5183 | -5256
Prepaid Amortization
Broker Fees (s/b negative)
Spot Liquidations
Book/Act Recon Liquid
Other (See schedule E)
"Other" Note reference | Sched E Ref:
Total Monthly Change
EXCHANGE
 | Ttl [NAME] =>
FUTURES
 | MTD Cumulative
2 Year Bonds |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 Year Bonds |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10 Year Bonds |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
30 Year Bonds |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Canadian Dollars |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Crude |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Eurodallars |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Gas |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Gas Crack |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Heat Crack |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Heat Oil |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Propane |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Unleaded |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Tot MTD Futures Liquid.
 | Ttl [NAME] =>
OPTION PREMIUMS
 | MTD Cumulative
Crude |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Gas |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Gas Crack |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Heat Crack |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Heat Oil |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Unleaded |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Tot MTD Opt.[NAME].
SUPPORTING SCHEDULES
Schedule A: Rho & Drift Adjustments |  |  |  |  |  | Schedule B: Transactions Ex Oracle
Date | Description |  |  | Amount |  | Description |  |  |  |  | Amount
2000-04-01 00:00:00 | Adj. Drift & Rho-04/00 |  |  | 19
2000-05-01 00:00:00 | Adj. Drift & Rho-05/00 |  |  | -108
2000-06-01 00:00:00 | Adj. Drift & Rho-06/00 |  |  | -46133
2000-07-01 00:00:00 | Adj. Drift & Rho-07/00 |  |  | 10885
2000-08-01 00:00:00 | Adj. Drift & Rho-08/00 |  |  | -91115
2000-09-01 00:00:00 | Adj. Drift & Rho-09/00 |  |  | 7537
2000-10-01 00:00:00 | Adj. Drift & Rho-10/00 |  |  | -629
 |  |  | Total Rho & Drift Adjustments |  |  |  |  |  |  | Total [NAME]
Schedule C: Perm Book Adjustments
Date | Description |  |  | Amount
 |  |  | Total Perm Book Adjustments
Schedule D: Accounting Adjustments (Prudency)
Number | Date | Deal Number | Counterparty | Description |  |  |  |  |  |  |  | Amount
 |  |  |  |  |  |  |  |  |  |  | Total Accounting Adjustments (Prudency)
Scedule E: Prior Period Liquidation Adjustments
Number | Date | Deal Number | Counterparty |  | Amount
 |  |  |  | Total Prior Period Liquidation Adjustments