Spreadsheet: robin_rodrigue__33265__CAN$1100
Sheet: OptionsProp

Roll Forward Schedule
Book: | Canadian Gas Options-Prop | Canadian $
Accounting Month:
Date:
Current Day Post ID: | 894200 |  |  |  |  |  |  |  |  | NOTIONAL VOLUMES |  |  |  |  |  |  |  | CALCULATED LONG/SHORT |  |  | Permanent Volume Adjustment
 |  |  | Prior | Today |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | Long | Short |  | When system was changed over from Lotus to Oracle, a discrepancy
[NAME] MTM Gain (Losses) |  |  |  |  |  | Source |  |  |  | Current Day |  |  |  |  |  |  |  |  |  |  | between the Oracle volumes and Lotus volumes was discovered
Mid P/L Swaps |  |  | 0 | 0 | [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;
Options Gas Daily |  |  | 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 |  |  | 0 | 0 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Use March 1995 as basis for adjustment |  |  | PERMANENT
Rho/Drift  Adjustments - Schedule A |  |  |  |  | Cell Ref |  |  |  |  | Net Notional |  |  |  |  |  |  |  |  |  |  |  |  |  | ADJUSTMENT
Transactions ex Oracle - Schedule B |  |  |  | 0 | 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 |  |  |  | -2577247 | [NAME] |  |  |  |  | Prior Month
Current Month Swap/Options Liquidations |  |  |  |  | Cell Ref |  |  |  |  | Gross Book Balance |  | 280546 |  | [NAME]
Current Month NYMEX Futures Liquidations |  |  |  |  | Cell Ref |  |  |  |  | Prudency |  | 0 |  | [NAME]
Current Month NYMEX Option Premiums |  |  |  |  | Cell Ref |  |  |  |  | LTD Liquidations |  | -2577247 |  | [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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Amalgamated into Canadian Options Book |  |  |  |  |  |  |  |  |  |  | 3 | T
Price [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | W
Basis Curve Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | R
Index [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | F
Gas Daily Curve Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | S
FX Curve Shift
[NAME]
New Deals
Change in Existing Deals
Gamma
Vega
Theta
Rho
Drift
Origination
Liquidations - Book
2nd Order
Prudency
FX Rho
FX Drift
Prepaid Amortization
Broker Fees (s/b negative)
Spot Liquidations
Book/Act Recon Liquid
Other (See schedule E)
"Other" Note reference | Sched E Ref:
 | Prior Month Bal
Total Prudency Balance
Broker Fees (Intra Month)
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
LTD Through 1997 | LTD Rho/Drift Adjustment through December 1997
LTD Through 1998 | LTD Rho/Drift Adjustment through December 1998
1999-01-01 00:00:00 | Adj. Drift & Rho-01/99
1999-02-01 00:00:00 | Adj. Drift & Rho-02/99
1999-03-01 00:00:00 | Adj. Drift & Rho-03/99
1999-04-01 00:00:00 | Adj. Drift & Rho-04/99
1999-05-01 00:00:00 | Adj. Drift & Rho-05/99
1999-06-01 00:00:00 | Adj. Drift & Rho-06/99
1999-07-01 00:00:00 | Adj. Drift & Rho-07/99
1999-08-01 00:00:00 | Adj. Drift & Rho-08/99
1999-09-01 00:00:00 | Adj. Drift & Rho-09/99
1999-10-01 00:00:00 | Adj. Drift & Rho-10/99
1999-11-01 00:00:00 | Adj. Drift & Rho-11/99
1999-12-01 00:00:00 | Adj. Drift & Rho-12/99
2000-01-01 00:00:00 | Adj. Drift & Rho-01/00
2000-02-01 00:00:00 | Adj. Drift & Rho-02/00 |  |  | -38040
2000-03-01 00:00:00 | Adj. Drift & Rho-03/00 |  |  | -31368
2000-04-01 00:00:00 | Adj. Drift & Rho-04/00 |  |  | -3234
2000-05-01 00:00:00 | Adj. Drift & Rho-05/00 |  |  | -15730
2000-06-01 00:00:00 | Adj. Drift & Rho-06/00 |  |  | -42401
2000-07-01 00:00:00 | Adj. Drift & Rho-07/00 |  |  | -2005
2000-08-01 00:00:00 | Adj. Drift & Rho-08/00 |  |  | 160980
2000-09-01 00:00:00 | Adj. Drift & Rho-09/00 |  |  | 172343
2000-10-01 00:00:00 | Adj. Drift & Rho-10/00 |  |  | 92743
 |  |  | Total Rho & Drift Adjustments
 |  |  |  |  |  |  |  |  |  | Total [NAME]
Schedule C: Perm Book Adjustments
Date | Adj. Drift & Rho-09/00 |  |  | Amount
 | Adj. Drift & Rho-09/00
 |  |  | 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