Spreadsheet: errol_mclaughlin_jr__10264__belcooil
Sheet: Price

Fixed |  |  |  |  |  |  |  |  | Totals
 |  | Phy/ |  |  | Monthly | PV | Discount | Mid | Fixed |  | Mid
Counterparty | Deal Num | Fin | Pub Code | Period | Quantity | Quantity | Factor | Price | Price | Cash | Value
BELCO OIL | E01073.7 | F | NX3 | 2000-06-01 00:00:00 | 300000 | 0 | 1 | 4.23833333 | 2.2 | 0 | 611500
BELCO OIL | E01073.7 | F | NX3 | 2000-07-01 00:00:00 | 310000 | 0 | 0.999819509617605 | 4.53833333 | 2.2 | 0 | 724752.4989
BELCO OIL | E01073.7 | F | NX3 | 2000-08-01 00:00:00 | 310000 | 308187.0313 | 0.99415171393413 | 4.476 | 2.2 | 0 | 701433.6833
BELCO OIL | E01073.7 | F | NX3 | 2000-09-01 00:00:00 | 300000 | 296538.0357 | 0.988460119078021 | 4.442 | 2.2 | 0 | 664838.2761
BELCO OIL | E01073.7 | F | NX3 | 2000-10-01 00:00:00 | 310000 | 304686.0453 | 0.982858210673136 | 4.411 | 2.2 | 0 | 673660.8462
BELCO OIL | E01073.7 | F | NX3 | 2000-11-01 00:00:00 | 300000 | 293128.1924 | 0.977093974743391 | 4.466 | 2.2 | 0 | 664228.484
BELCO OIL | E01073.7 | F | NX3 | 2000-12-01 00:00:00 | 310000 | 301167.1538 | 0.971506947816572 | 4.536 | 2.2 | 0 | 703526.4713
BELCO OIL | E01073.9 | F | NX3 | 2000-06-01 00:00:00 | -300000 | 0 | 1 | 4.23833333 | 2.2 | 0 | -611500
BELCO OIL | E01073.9 | F | NX3 | 2000-07-01 00:00:00 | -310000 | 0 | 0.999819509617605 | 4.53833333 | 2.2 | 0 | -724752.4989
BELCO OIL | E01073.9 | F | NX3 | 2000-08-01 00:00:00 | -310000 | -308187.0313 | 0.99415171393413 | 4.476 | 2.2 | 0 | -701433.6833
BELCO OIL | E01073.9 | F | NX3 | 2000-09-01 00:00:00 | -300000 | -296538.0357 | 0.988460119078021 | 4.442 | 2.2 | 0 | -664838.2761
BELCO OIL | E01073.9 | F | NX3 | 2000-10-01 00:00:00 | -310000 | -304686.0453 | 0.982858210673136 | 4.411 | 2.2 | 0 | -673660.8462
BELCO OIL | E01073.9 | F | NX3 | 2000-11-01 00:00:00 | -300000 | -293128.1924 | 0.977093974743391 | 4.466 | 2.2 | 0 | -664228.484
BELCO OIL | E01073.9 | F | NX3 | 2000-12-01 00:00:00 | -310000 | -301167.1538 | 0.971506947816572 | 4.536 | 2.2 | 0 | -703526.4713
BELCO OIL | EC4292.2 | F | NX3 | 2000-06-01 00:00:00 | 150000 | 0 | 1 | 4.23833333 | 2.105 | 0 | 320000
BELCO OIL | EC4292.2 | F | NX3 | 2000-07-01 00:00:00 | 155000 | 0 | 0.999819509617605 | 4.53833333 | 2.105 | 0 | 377098.5917
BELCO OIL | EC4292.2 | F | NX3 | 2000-08-01 00:00:00 | 155000 | 154093.5157 | 0.99415171393413 | 4.476 | 2.105 | 0 | 365355.7256
BELCO OIL | EC4292.2 | F | NX3 | 2000-09-01 00:00:00 | 150000 | 148269.0179 | 0.988460119078021 | 4.442 | 2.105 | 0 | 346504.6947
BELCO OIL | EC4292.2 | F | NX3 | 2000-10-01 00:00:00 | 155000 | 152343.0227 | 0.982858210673136 | 4.411 | 2.105 | 0 | 351303.0102
BELCO OIL | EC4292.2 | F | NX3 | 2000-11-01 00:00:00 | 150000 | 146564.0962 | 0.977093974743391 | 4.466 | 2.105 | 0 | 346037.8312
BELCO OIL | EC4292.2 | F | NX3 | 2000-12-01 00:00:00 | 155000 | 150583.5769 | 0.971506947816572 | 4.536 | 2.105 | 0 | 366068.6755
BELCO OIL | EC4292.4 | F | NX3 | 2000-06-01 00:00:00 | -150000 | 0 | 1 | 4.23833333 | 2.105 | 0 | -320000
BELCO OIL | EC4292.4 | F | NX3 | 2000-07-01 00:00:00 | -155000 | 0 | 0.999819509617605 | 4.53833333 | 2.105 | 0 | -377098.5917
BELCO OIL | EC4292.4 | F | NX3 | 2000-08-01 00:00:00 | -155000 | -154093.5157 | 0.99415171393413 | 4.476 | 2.105 | 0 | -365355.7256
BELCO OIL | EC4292.4 | F | NX3 | 2000-09-01 00:00:00 | -150000 | -148269.0179 | 0.988460119078021 | 4.442 | 2.105 | 0 | -346504.6947
BELCO OIL | EC4292.4 | F | NX3 | 2000-10-01 00:00:00 | -155000 | -152343.0227 | 0.982858210673136 | 4.411 | 2.105 | 0 | -351303.0102
BELCO OIL | EC4292.4 | F | NX3 | 2000-11-01 00:00:00 | -150000 | -146564.0962 | 0.977093974743391 | 4.466 | 2.105 | 0 | -346037.8312
BELCO OIL | EC4292.4 | F | NX3 | 2000-12-01 00:00:00 | -155000 | -150583.5769 | 0.971506947816572 | 4.536 | 2.105 | 0 | -366068.6755
BELCO OIL | ED6925.5 | F | NX3 | 2000-06-01 00:00:00 | 150000 | 0 | 1 | 4.23833333 | 2.31 | 0 | 289250
BELCO OIL | ED6925.5 | F | NX3 | 2000-07-01 00:00:00 | 155000 | 0 | 0.999819509617605 | 4.53833333 | 2.31 | 0 | 345329.3268
BELCO OIL | ED6925.5 | F | NX3 | 2000-08-01 00:00:00 | 155000 | 154093.5157 | 0.99415171393413 | 4.476 | 2.31 | 0 | 333766.5549
BELCO OIL | ED6925.5 | F | NX3 | 2000-09-01 00:00:00 | 150000 | 148269.0179 | 0.988460119078021 | 4.442 | 2.31 | 0 | 316109.5461
BELCO OIL | ED6925.5 | F | NX3 | 2000-10-01 00:00:00 | 155000 | 152343.0227 | 0.982858210673136 | 4.411 | 2.31 | 0 | 320072.6906
BELCO OIL | ED6925.5 | F | NX3 | 2000-11-01 00:00:00 | 150000 | 146564.0962 | 0.977093974743391 | 4.466 | 2.31 | 0 | 315992.1914
BELCO OIL | ED6925.5 | F | NX3 | 2000-12-01 00:00:00 | 155000 | 150583.5769 | 0.971506947816572 | 4.536 | 2.31 | 0 | 335199.0422
BELCO OIL | ED9136.7 | F | NX3 | 2000-06-01 00:00:00 | 150000 | 0 | 1 | 4.23833333 | 2.24 | 0 | 299750
BELCO OIL | ED9136.7 | F | NX3 | 2000-07-01 00:00:00 | 155000 | 0 | 0.999819509617605 | 4.53833333 | 2.24 | 0 | 356177.3685
BELCO OIL | ED9136.7 | F | NX3 | 2000-08-01 00:00:00 | 155000 | 154093.5157 | 0.99415171393413 | 4.476 | 2.24 | 0 | 344553.101
BELCO OIL | ED9136.7 | F | NX3 | 2000-09-01 00:00:00 | 150000 | 148269.0179 | 0.988460119078021 | 4.442 | 2.24 | 0 | 326488.3773
BELCO OIL | ED9136.7 | F | NX3 | 2000-10-01 00:00:00 | 155000 | 152343.0227 | 0.982858210673136 | 4.411 | 2.24 | 0 | 330736.7022
BELCO OIL | ED9136.7 | F | NX3 | 2000-11-01 00:00:00 | 150000 | 146564.0962 | 0.977093974743391 | 4.466 | 2.24 | 0 | 326251.6782
BELCO OIL | ED9136.7 | F | NX3 | 2000-12-01 00:00:00 | 155000 | 150583.5769 | 0.971506947816572 | 4.536 | 2.24 | 0 | 345739.8926
BELCO OIL | [NAME] | F | NX3 | 2000-06-01 00:00:00 | 150000 | 0 | 1 | 4.23833333 | 2.3 | 0 | 290750
BELCO OIL | EF1397.4 | F | NX3 | 2000-07-01 00:00:00 | 155000 | 0 | 0.999819509617605 | 4.53833333 | 2.3 | 0 | 346879.047
BELCO OIL | EF1397.4 | F | NX3 | 2000-08-01 00:00:00 | 155000 | 154093.5157 | 0.99415171393413 | 4.476 | 2.3 | 0 | 335307.4901
BELCO OIL | EF1397.4 | F | NX3 | 2000-09-01 00:00:00 | 150000 | 148269.0179 | 0.988460119078021 | 4.442 | 2.3 | 0 | 317592.2363
BELCO OIL | EF1397.4 | F | NX3 | 2000-10-01 00:00:00 | 155000 | 152343.0227 | 0.982858210673136 | 4.411 | 2.3 | 0 | 321596.1208
BELCO OIL | EF1397.4 | F | NX3 | 2000-11-01 00:00:00 | 150000 | 146564.0962 | 0.977093974743391 | 4.466 | 2.3 | 0 | 317457.8324
BELCO OIL | EF1397.4 | F | NX3 | 2000-12-01 00:00:00 | 155000 | 150583.5769 | 0.971506947816572 | 4.536 | 2.3 | 0 | 336704.878
BELCO OIL | EF1397.4 | F | NX3 | 2001-01-01 00:00:00 | 155000 | 149685.5663 | 0.965713330797771 | 4.516 | 2.3 | 0 | 331703.2149
BELCO OIL | EF1397.4 | F | NX3 | 2001-02-01 00:00:00 | 140000 | 134385.4416 | 0.959896011600467 | 4.24 | 2.3 | 0 | 260707.7568
BELCO OIL | EF1397.4 | F | NX3 | 2001-03-01 00:00:00 | 155000 | 147966.9784 | 0.954625666933866 | 3.965 | 2.3 | 0 | 246365.019
BELCO OIL | EF1397.4 | F | NX3 | 2001-04-01 00:00:00 | 150000 | 142323.651 | 0.948824339756754 | 3.671 | 2.3 | 0 | 195125.7255
BELCO OIL | EF1397.4 | F | NX3 | 2001-05-01 00:00:00 | 155000 | 146211.1075 | 0.943297468051374 | 3.516 | 2.3 | 0 | 177792.7068
BELCO OIL | EF1397.4 | F | NX3 | 2001-06-01 00:00:00 | 150000 | 140639.7947 | 0.937598631583334 | 3.461 | 2.3 | 0 | 163282.8017
BELCO OIL | EI9660.1 | F | NX3 | 2000-06-01 00:00:00 | 150000 | 0 | 1 | 4.23833333 | 2.28 | 0 | 293750
BELCO OIL | EI9660.1 | F | NX3 | 2000-07-01 00:00:00 | 155000 | 0 | 0.999819509617605 | 4.53833333 | 2.28 | 0 | 349978.4875
BELCO OIL | EI9660.1 | F | NX3 | 2000-08-01 00:00:00 | 155000 | 154093.5157 | 0.99415171393413 | 4.476 | 2.28 | 0 | 338389.3604
BELCO OIL | EI9660.1 | F | NX3 | 2000-09-01 00:00:00 | 150000 | 148269.0179 | 0.988460119078021 | 4.442 | 2.28 | 0 | 320557.6166
BELCO OIL | EI9660.1 | F | NX3 | 2000-10-01 00:00:00 | 155000 | 152343.0227 | 0.982858210673136 | 4.411 | 2.28 | 0 | 324642.9813
BELCO OIL | EI9660.1 | F | NX3 | 2000-11-01 00:00:00 | 150000 | 146564.0962 | 0.977093974743391 | 4.466 | 2.28 | 0 | 320389.1143
BELCO OIL | EI9660.1 | F | NX3 | 2000-12-01 00:00:00 | 155000 | 150583.5769 | 0.971506947816572 | 4.536 | 2.28 | 0 | 339716.5495
BELCO OIL | EJ0432.1 | F | NX3 | 2000-06-01 00:00:00 | 150000 | 0 | 1 | 4.23833333 | 2.335 | 0 | 285500
BELCO OIL | EJ0432.1 | F | NX3 | 2000-07-01 00:00:00 | 155000 | 0 | 0.999819509617605 | 4.53833333 | 2.335 | 0 | 341455.0262
BELCO OIL | EJ0432.1 | F | NX3 | 2000-08-01 00:00:00 | 155000 | 154093.5157 | 0.99415171393413 | 4.476 | 2.335 | 0 | 329914.217
BELCO OIL | EJ0432.1 | F | NX3 | 2000-09-01 00:00:00 | 150000 | 148269.0179 | 0.988460119078021 | 4.442 | 2.335 | 0 | 312402.8206
BELCO OIL | EJ0432.1 | F | NX3 | 2000-10-01 00:00:00 | 155000 | 152343.0227 | 0.982858210673136 | 4.411 | 2.335 | 0 | 316264.115
BELCO OIL | EJ0432.1 | F | NX3 | 2000-11-01 00:00:00 | 150000 | 146564.0962 | 0.977093974743391 | 4.466 | 2.335 | 0 | 312328.089
BELCO OIL | EJ0432.1 | F | NX3 | 2000-12-01 00:00:00 | 155000 | 150583.5769 | 0.971506947816572 | 4.536 | 2.335 | 0 | 331434.4528
BELCO OIL | EY4352.1 | F | NX3 | 2000-06-01 00:00:00 | 300000 | 0 | 1 | 4.23833333 | 2.3 | 0 | 581500
BELCO OIL | EY4352.1 | F | NX3 | 2000-07-01 00:00:00 | 310000 | 0 | 0.999819509617605 | 4.53833333 | 2.3 | 0 | 693758.0941
BELCO OIL | EY4352.1 | F | NX3 | 2000-08-01 00:00:00 | 310000 | 308187.0313 | 0.99415171393413 | 4.476 | 2.3 | 0 | 670614.9802
BELCO OIL | EY4352.1 | F | NX3 | 2000-09-01 00:00:00 | 300000 | 296538.0357 | 0.988460119078021 | 4.442 | 2.3 | 0 | 635184.4725
BELCO OIL | EY4352.1 | F | NX3 | 2000-10-01 00:00:00 | 310000 | 304686.0453 | 0.982858210673136 | 4.411 | 2.3 | 0 | 643192.2416
BELCO OIL | EY4352.1 | F | NX3 | 2000-11-01 00:00:00 | 300000 | 293128.1924 | 0.977093974743391 | 4.466 | 2.3 | 0 | 634915.6648
BELCO OIL | EY4352.1 | F | NX3 | 2000-12-01 00:00:00 | 310000 | 301167.1538 | 0.971506947816572 | 4.536 | 2.3 | 0 | 673409.7559
BELCO OIL | N07204.2 | F | NX3 | 2001-01-01 00:00:00 | 155000 | 149685.5663 | 0.965713330797771 | 4.516 | 2.5125 | 0 | 299895.032
BELCO OIL | N07204.2 | F | NX3 | 2001-02-01 00:00:00 | 140000 | 134385.4416 | 0.959896011600467 | 4.24 | 2.5125 | 0 | 232150.8504
BELCO OIL | N07204.2 | F | NX3 | 2001-03-01 00:00:00 | 155000 | 147966.9784 | 0.954625666933866 | 3.965 | 2.5125 | 0 | 214922.0361
BELCO OIL | N07204.2 | F | NX3 | 2001-04-01 00:00:00 | 150000 | 142323.651 | 0.948824339756754 | 3.671 | 2.5125 | 0 | 164881.9496
BELCO OIL | N07204.2 | F | NX3 | 2001-05-01 00:00:00 | 155000 | 146211.1075 | 0.943297468051374 | 3.516 | 2.5125 | 0 | 146722.8464
BELCO OIL | N07204.2 | F | NX3 | 2001-06-01 00:00:00 | 150000 | 140639.7947 | 0.937598631583334 | 3.461 | 2.5125 | 0 | 133396.8453
BELCO OIL | N07204.2 | F | NX3 | 2001-07-01 00:00:00 | 155000 | 144477.3164 | 0.932111718572608 | 3.438 | 2.5125 | 0 | 133713.7563
BELCO OIL | N07204.2 | F | NX3 | 2001-08-01 00:00:00 | 155000 | 143605.8953 | 0.92648964734032 | 3.418 | 2.5125 | 0 | 130035.1382
BELCO OIL | N07204.2 | F | NX3 | 2001-09-01 00:00:00 | 150000 | 138133.1695 | 0.920887796650918 | 3.398 | 2.5125 | 0 | 122316.9216
BELCO OIL | N07204.2 | F | NX3 | 2001-10-01 00:00:00 | 155000 | 141902.5416 | 0.915500268347653 | 3.408 | 2.5125 | 0 | 127073.726
BELCO OIL | N07204.2 | F | NX3 | 2001-11-01 00:00:00 | 150000 | 136496.9739 | 0.909979825916359 | 3.488 | 2.5125 | 0 | 133152.798
BELCO OIL | N07204.2 | F | NX3 | 2001-12-01 00:00:00 | 155000 | 140222.4905 | 0.90466122875746 | 3.568 | 2.5125 | 0 | 148004.8387
BELCO OIL | NH8734.1 | F | NX3 | 2000-08-01 00:00:00 | -155000 | -154093.5157 | 0.99415171393413 | 4.476 | 3.21 | 0 | -195082.3908
BELCO OIL | [NAME] | F | NX3 | 2003-01-01 00:00:00 | 77500 | 64914.7655 | 0.837609876958191 | 3.134 | 3.35 | 0 | -14021.5893
BELCO OIL | [NAME] | F | NX3 | 2003-02-01 00:00:00 | 70000 | 58280.4034 | 0.832577191319155 | 2.999 | 3.35 | 0 | -20456.4216
BELCO OIL | [NAME] | F | NX3 | 2003-03-01 00:00:00 | 77500 | 64174.3761 | 0.828056466319271 | 2.859 | 3.35 | 0 | -31509.6187
BELCO OIL | [NAME] | F | NX3 | 2003-04-01 00:00:00 | 75000 | 61732.4899 | 0.823099865280748 | 2.713 | 3.35 | 0 | -39323.5961
BELCO OIL | [NAME] | F | NX3 | 2003-05-01 00:00:00 | 77500 | 63422.8731 | 0.818359653231005 | 2.685 | 3.35 | 0 | -42176.2106
BELCO OIL | [NAME] | F | NX3 | 2003-06-01 00:00:00 | 75000 | 61011.8908 | 0.813491877722601 | 2.688 | 3.35 | 0 | -40389.8717
BELCO OIL | [NAME] | F | NX3 | 2003-07-01 00:00:00 | 77500 | 62682.7122 | 0.808809189316771 | 2.693 | 3.35 | 0 | -41182.5419
BELCO OIL | [NAME] | F | NX3 | 2003-08-01 00:00:00 | 77500 | 62309.8937 | 0.803998628789066 | 2.772 | 3.35 | 0 | -36015.1186
BELCO OIL | [NAME] | F | NX3 | 2003-09-01 00:00:00 | 75000 | 59941.3708 | 0.799218277255611 | 2.757 | 3.35 | 0 | -35545.2329
BELCO OIL | [NAME] | F | NX3 | 2003-10-01 00:00:00 | 77500 | 61582.9849 | 0.794619160322704 | 2.774 | 3.35 | 0 | -35471.7993
BELCO OIL | [NAME] | F | NX3 | 2003-11-01 00:00:00 | 75000 | 59242.0524 | 0.789894031480794 | 2.871 | 3.35 | 0 | -28376.9431
BELCO OIL | [NAME] | F | NX3 | 2003-12-01 00:00:00 | 77500 | 60864.5786 | 0.785349400938827 | 2.969 | 3.35 | 0 | -23189.4044
BELCO OIL | NL0626.1 | F | NX3 | 2000-07-01 00:00:00 | -155000 | 0 | 0.999819509617605 | 4.53833333 | 3.85 | 0 | -106672.4098
BELCO OIL | NL0626.1 | F | NX3 | 2000-08-01 00:00:00 | -155000 | -154093.5157 | 0.99415171393413 | 4.476 | 3.85 | 0 | -96462.5408
BELCO OIL | NL0626.1 | F | NX3 | 2000-09-01 00:00:00 | -150000 | -148269.0179 | 0.988460119078021 | 4.442 | 3.85 | 0 | -87775.2586