Spreadsheet: robin_rodrigue__33265__CAN$1100
Sheet: OptionsIndex

Roll Forward Schedule
Book: | Options Index | Canadian $
Accounting Month:
Date:
Current Day Post ID: |  |  |  |  |  |  |  |  |  | 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 |  |  | -3420079 | -3374456 | [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;
NYMEX Options MTM Value |  |  | 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 |  |  |  |  | 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 |  |  |  | 0 | [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 |  |  |  | 868008 | [NAME] |  |  |  |  | Prior Month
Current Month Swap/Options Liquidations |  |  |  |  | Cell Ref |  |  |  |  | Gross Book Balance |  | -3331545 |  | [NAME]
Current Month NYMEX Futures Liquidations |  |  |  |  | Cell Ref |  |  |  |  | Prudency |  | 0 |  | [NAME]
Current Month NYMEX Option Premiums |  |  |  |  | Cell Ref |  |  |  |  | LTD Liquidations |  | 868008 |  | [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] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | W
Basis Curve Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | R
Index [NAME] |  |  | -802 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | F
Gas Daily Curve Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | S
FX Curve Shift |  | -3763 | 708 | -351 |  |  | 641 | -1076 | -2306 | -2709 | 2270 |  |  | -632 | -517 | -2867 | -356 | -1535
[NAME]
New Deals |  |  |  | 768 |  |  |  |  |  |  |  |  |  |  |  |  |  | 47534
Change in Existing Deals
Gamma
Vega
Theta
Rho |  | -112 | 96 | 51 |  |  | 36 | -69 | 85 | 17 | 45 |  |  | -9 | -31 | -18 | -15 | 78
Drift |  | -544 | -449 | -450 |  |  | -1351 | -451 | -450 | -451 | -451 |  |  | -1355 | -452 | -452 | -452 | -452
Origination
Liquidations - Book
2nd Order |  |  |  |  |  |  |  |  | -1 |  | -1 |  |  |  | 1 |  |  | -2
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:
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
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 |  |  | -329
1999-12-01 00:00:00 | Adj. Drift & Rho-12/99 |  |  | -937
2000-01-01 00:00:00 | Adj. Drift & Rho-01/00 |  |  | -1288
2000-02-01 00:00:00 | Adj. Drift & Rho-02/00 |  |  | -1132
2000-03-01 00:00:00 | Adj. Drift & Rho-03/00 |  |  | -2056
2000-04-01 00:00:00 | Adj. Drift & Rho-04/00 |  |  | -972
2000-05-01 00:00:00 | Adj. Drift & Rho-05/00 |  |  | 1852
2000-06-01 00:00:00 | Adj. Drift & Rho-06/00 |  |  | 16339
2000-07-01 00:00:00 | Adj. Drift & Rho-07/00 |  |  | 13874
2000-08-01 00:00:00 | Adj. Drift & Rho-08/00 |  |  | 15171
2000-09-01 00:00:00 | Adj. Drift & Rho-09/00 |  |  | 14019
2000-10-01 00:00:00 | Adj. Drift & Rho-10/00 |  |  | 15690
 |  |  | 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