Spreadsheet: errol_mclaughlin_jr__10264__belcooil
Sheet: Basis

 |  |  |  |  |  |  |  |  | Totals
 |  | Phy/ |  |  | Monthly | PV | Discount | Mid | Fixed |  | Mid
Counterparty | Deal Num | Fin | Pub Code | Period | Quantity | Quantity | Factor | Price | Price | Cash | Value
BELCO OIL | E53321.3 | F | IF-NWPL_ROCKY_M | 2000-06-01 00:00:00 | 75000 | 0 | 1 | -0.58833333 | -0.521 | 0 | 0
BELCO OIL | E53321.3 | F | IF-NWPL_ROCKY_M | 2000-07-01 00:00:00 | 77500 | 77486.012 | 0.999819509617605 | -0.66933333 | -0.521 | 0 | -11493.7584
BELCO OIL | E53321.3 | F | IF-NWPL_ROCKY_M | 2000-08-01 00:00:00 | 77500 | 77046.7578 | 0.99415171393413 | -0.54 | -0.521 | 0 | -1463.8884
BELCO OIL | E53321.3 | F | IF-NWPL_ROCKY_M | 2000-09-01 00:00:00 | 75000 | 74134.5089 | 0.988460119078021 | -0.5375 | -0.521 | 0 | -1223.2194
BELCO OIL | E53321.3 | F | IF-NWPL_ROCKY_M | 2000-10-01 00:00:00 | 77500 | 76171.5113 | 0.982858210673136 | -0.5375 | -0.521 | 0 | -1256.8299
BELCO OIL | E53321.3 | F | IF-NWPL_ROCKY_M | 2000-11-01 00:00:00 | 75000 | 73282.0481 | 0.977093974743391 | -0.325 | -0.521 | 0 | 14363.2814
BELCO OIL | E53321.3 | F | IF-NWPL_ROCKY_M | 2000-12-01 00:00:00 | 77500 | 75291.7885 | 0.971506947816572 | -0.3 | -0.521 | 0 | 16639.4852
BELCO OIL | E73816.3 | F | IF-NWPL_ROCKY_M | 2000-06-01 00:00:00 | 150000 | 0 | 1 | -0.58833333 | -0.5025 | 0 | 0
BELCO OIL | E73816.3 | F | IF-NWPL_ROCKY_M | 2000-07-01 00:00:00 | 155000 | 154972.024 | 0.999819509617605 | -0.66933333 | -0.5025 | 0 | -25854.4993
BELCO OIL | E73816.3 | F | IF-NWPL_ROCKY_M | 2000-08-01 00:00:00 | 155000 | 154093.5157 | 0.99415171393413 | -0.54 | -0.5025 | 0 | -5778.5068
BELCO OIL | E73816.3 | F | IF-NWPL_ROCKY_M | 2000-09-01 00:00:00 | 150000 | 148269.0179 | 0.988460119078021 | -0.5375 | -0.5025 | 0 | -5189.4156
BELCO OIL | E73816.3 | F | IF-NWPL_ROCKY_M | 2000-10-01 00:00:00 | 155000 | 152343.0227 | 0.982858210673136 | -0.5375 | -0.5025 | 0 | -5332.0058
BELCO OIL | E73816.3 | F | IF-NWPL_ROCKY_M | 2000-11-01 00:00:00 | 150000 | 146564.0962 | 0.977093974743391 | -0.325 | -0.5025 | 0 | 26015.1271
BELCO OIL | E73816.3 | F | IF-NWPL_ROCKY_M | 2000-12-01 00:00:00 | 155000 | 150583.5769 | 0.971506947816572 | -0.3 | -0.5025 | 0 | 30493.1743
BELCO OIL | [NAME] | F | IF-NWPL_ROCKY_M | 2000-06-01 00:00:00 | 150000 | 0 | 1 | -0.58833333 | -0.625 | 0 | 0
BELCO OIL | NC6867.1 | F | IF-NWPL_ROCKY_M | 2001-01-01 00:00:00 | 155000 | 149685.5663 | 0.965713330797771 | -0.3 | -0.26 | 0 | -5987.4227
BELCO OIL | NC6867.1 | F | IF-NWPL_ROCKY_M | 2001-02-01 00:00:00 | 140000 | 134385.4416 | 0.959896011600467 | -0.325 | -0.26 | 0 | -8735.0537
BELCO OIL | NC6867.1 | F | IF-NWPL_ROCKY_M | 2001-03-01 00:00:00 | 155000 | 147966.9784 | 0.954625666933866 | -0.325 | -0.26 | 0 | -9617.8536
BELCO OIL | NC6867.1 | F | IF-NWPL_ROCKY_M | 2001-04-01 00:00:00 | 150000 | 142323.651 | 0.948824339756754 | -0.435 | -0.26 | 0 | -24906.6389
BELCO OIL | NC6867.1 | F | IF-NWPL_ROCKY_M | 2001-05-01 00:00:00 | 155000 | 146211.1075 | 0.943297468051374 | -0.435 | -0.26 | 0 | -25586.9438
BELCO OIL | NC6867.1 | F | IF-NWPL_ROCKY_M | 2001-06-01 00:00:00 | 150000 | 140639.7947 | 0.937598631583334 | -0.435 | -0.26 | 0 | -24611.9641
BELCO OIL | NC6867.1 | F | IF-NWPL_ROCKY_M | 2001-07-01 00:00:00 | 155000 | 144477.3164 | 0.932111718572608 | -0.435 | -0.26 | 0 | -25283.5304
BELCO OIL | NC6867.1 | F | IF-NWPL_ROCKY_M | 2001-08-01 00:00:00 | 155000 | 143605.8953 | 0.92648964734032 | -0.435 | -0.26 | 0 | -25131.0317
BELCO OIL | NC6867.1 | F | IF-NWPL_ROCKY_M | 2001-09-01 00:00:00 | 150000 | 138133.1695 | 0.920887796650918 | -0.435 | -0.26 | 0 | -24173.3047
BELCO OIL | NC6867.1 | F | IF-NWPL_ROCKY_M | 2001-10-01 00:00:00 | 155000 | 141902.5416 | 0.915500268347653 | -0.435 | -0.26 | 0 | -24832.9448
BELCO OIL | NC6867.1 | F | IF-NWPL_ROCKY_M | 2001-11-01 00:00:00 | 150000 | 136496.9739 | 0.909979825916359 | -0.31 | -0.26 | 0 | -6824.8487
BELCO OIL | NC6867.1 | F | IF-NWPL_ROCKY_M | 2001-12-01 00:00:00 | 155000 | 140222.4905 | 0.90466122875746 | -0.31 | -0.26 | 0 | -7011.1245
BELCO OIL | NH8359.1 | F | IF-NWPL_ROCKY_M | 2000-06-01 00:00:00 | -150000 | 0 | 1 | -0.58833333 | -0.445 | 0 | 0
BELCO OIL | NH8359.1 | F | IF-NWPL_ROCKY_M | 2000-07-01 00:00:00 | -155000 | -154972.024 | 0.999819509617605 | -0.66933333 | -0.445 | 0 | 34765.3907
BELCO OIL | NH8359.1 | F | IF-NWPL_ROCKY_M | 2000-08-01 00:00:00 | -155000 | -154093.5157 | 0.99415171393413 | -0.54 | -0.445 | 0 | 14638.884
BELCO OIL | NH8359.1 | F | IF-NWPL_ROCKY_M | 2000-09-01 00:00:00 | -150000 | -148269.0179 | 0.988460119078021 | -0.5375 | -0.445 | 0 | 13714.8842
BELCO OIL | NH8359.1 | F | IF-NWPL_ROCKY_M | 2000-10-01 00:00:00 | -155000 | -152343.0227 | 0.982858210673136 | -0.5375 | -0.445 | 0 | 14091.7296
BELCO OIL | NH8359.1 | F | IF-NWPL_ROCKY_M | 2000-11-01 00:00:00 | -150000 | -146564.0962 | 0.977093974743391 | -0.325 | -0.445 | 0 | -17587.6915
BELCO OIL | NH8359.1 | F | IF-NWPL_ROCKY_M | 2000-12-01 00:00:00 | -155000 | -150583.5769 | 0.971506947816572 | -0.3 | -0.445 | 0 | -21834.6187