Spreadsheet: phillip_m_love__30498__Brooklyn
Sheet: Brooklyn

 |  |  |  |  |  |  |  |  | Totals
 |  | Phy/ |  |  | Monthly | PV | Discount | Mid | Fixed |  | Mid
Counterparty | Deal Num | Fin | Pub Code | Period | Quantity | Quantity | Factor | Price | Price | Cash | Value
BROOKLYN | E20873.4 | P | IF-TRANSCO/Z1 | 2001-11-01 00:00:00 | 10440 | 10440 | 1 | 0.04966667 | -0.0001 | 0 | 519.564
BROOKLYN | E20873.5 | P | IF-TRANSCO/Z3 | 2001-11-01 00:00:00 | 25260 | 25260 | 1 | 0.11966667 | 1e-07 | 0 | 3022.7775
BROOKLYN | E20873.6 | P | IF-TRANSCO/Z4 | 2001-11-01 00:00:00 | 25170 | 25170 | 1 | 0.12966667 | -0.0001 | 0 | 3266.227
BROOKLYN | E20873.1 | P | IF-TRANSCO/Z1 | 2001-11-01 00:00:00 | -160560 | -160560 | 1 | 0 | 1e-07 | 0 | 0.0161
BROOKLYN | E20873.2 | P | IF-TRANSCO/Z3 | 2001-11-01 00:00:00 | -388680 | -388680 | 1 | -0.0025 | 1e-07 | 0 | 971.7389
BROOKLYN | E20873.3 | P | IF-TRANSCO/Z4 | 2001-11-01 00:00:00 | -387150 | -387150 | 1 | -0.0025 | 1e-07 | 0 | 967.9137
BROOKLYN | E20873.4 | P | NX3 | 2001-11-01 00:00:00 | 10440 | 0 | 1 | 3.06033333 | 0.0001 | 0 | 31948.836
BROOKLYN | E20873.5 | P | NX3 | 2001-11-01 00:00:00 | 25260 | 0 | 1 | 3.06033333 | 0.0001 | 0 | 77301.494
BROOKLYN | E20873.6 | P | NX3 | 2001-11-01 00:00:00 | 25170 | 0 | 1 | 3.06033333 | 0.0001 | 0 | 77026.073
BROOKLYN | E20873.4 | P | IF-TRANSCO/Z1 | 2001-12-01 00:00:00 | 10788 | 10771.1157 | 0.998434903937346 | -0.0825 | -0.0001 | 0 | -887.5399
BROOKLYN | E20873.5 | P | IF-TRANSCO/Z3 | 2001-12-01 00:00:00 | 26102 | 26061.1479 | 0.998434903937346 | 0.0125 | 1e-07 | 0 | 325.7617
BROOKLYN | E20873.6 | P | IF-TRANSCO/Z4 | 2001-12-01 00:00:00 | 26009 | 25968.2934 | 0.998434903937346 | 0.0375 | -0.0001 | 0 | 976.4078
BROOKLYN | E20873.1 | P | IF-TRANSCO/Z1 | 2001-12-01 00:00:00 | -165912 | -165652.3318 | 0.998434903937346 | 0.01 | 1e-07 | 0 | -1656.5068
BROOKLYN | E20873.2 | P | IF-TRANSCO/Z3 | 2001-12-01 00:00:00 | -401636 | -401007.4011 | 0.998434903937346 | 0.0125 | 1e-07 | 0 | -5012.5524
BROOKLYN | E20873.3 | P | IF-TRANSCO/Z4 | 2001-12-01 00:00:00 | -400055 | -399428.8755 | 0.998434903937346 | 0.01 | 1e-07 | 0 | -3994.2488
BROOKLYN | E20873.4 | P | NX3 | 2001-12-01 00:00:00 | 10788 | 10760.2288 | 0.997425727949591 | 2.922 | 0.0001 | 0 | 31440.3124
BROOKLYN | E20873.5 | P | NX3 | 2001-12-01 00:00:00 | 26102 | 26034.8064 | 0.997425727949591 | 2.922 | 0.0001 | 0 | 76071.1007
BROOKLYN | E20873.6 | P | NX3 | 2001-12-01 00:00:00 | 26009 | 25942.0458 | 0.997425727949591 | 2.922 | 0.0001 | 0 | 75800.0635
BROOKLYN | E20873.4 | P | IF-TRANSCO/Z1 | 2002-01-01 00:00:00 | 10788 | 10750.8633 | 0.996557596261355 | -0.0825 | -0.0001 | 0 | -885.8711
BROOKLYN | E20873.5 | P | IF-TRANSCO/Z3 | 2002-01-01 00:00:00 | 26102 | 26012.1464 | 0.996557596261355 | 0.0125 | 1e-07 | 0 | 325.1492
BROOKLYN | E20873.6 | P | IF-TRANSCO/Z4 | 2002-01-01 00:00:00 | 26009 | 25919.4665 | 0.996557596261355 | 0.0375 | -0.0001 | 0 | 974.5719
BROOKLYN | E20873.1 | P | IF-TRANSCO/Z1 | 2002-01-01 00:00:00 | -165912 | -165340.8639 | 0.996557596261355 | 0.01 | 1e-07 | 0 | -1653.3921
BROOKLYN | E20873.2 | P | IF-TRANSCO/Z3 | 2002-01-01 00:00:00 | -401636 | -400253.4067 | 0.996557596261355 | 0.0125 | 1e-07 | 0 | -5003.1276
BROOKLYN | E20873.3 | P | IF-TRANSCO/Z4 | 2002-01-01 00:00:00 | -400055 | -398677.8492 | 0.996557596261355 | 0.01 | 1e-07 | 0 | -3986.7386
BROOKLYN | E20873.4 | P | NX3 | 2002-01-01 00:00:00 | 10788 | 10726.5328 | 0.994302265564013 | 3.092 | 0.0001 | 0 | 33165.3669
BROOKLYN | E20873.5 | P | NX3 | 2002-01-01 00:00:00 | 26102 | 25953.2777 | 0.994302265564013 | 3.092 | 0.0001 | 0 | 80244.9394
BROOKLYN | E20873.6 | P | NX3 | 2002-01-01 00:00:00 | 26009 | 25860.8076 | 0.994302265564013 | 3.092 | 0.0001 | 0 | 79959.0311
BROOKLYN | E20873.4 | P | IF-TRANSCO/Z1 | 2002-02-01 00:00:00 | 9744 | 9692.9209 | 0.994757894063593 | -0.0825 | -0.0001 | 0 | -798.6967
BROOKLYN | E20873.5 | P | IF-TRANSCO/Z3 | 2002-02-01 00:00:00 | 23576 | 23452.4121 | 0.994757894063593 | 0.0125 | 1e-07 | 0 | 293.1528
BROOKLYN | E20873.6 | P | IF-TRANSCO/Z4 | 2002-02-01 00:00:00 | 23492 | 23368.8524 | 0.994757894063593 | 0.0375 | -0.0001 | 0 | 878.6689
BROOKLYN | E20873.1 | P | IF-TRANSCO/Z1 | 2002-02-01 00:00:00 | -149856 | -149070.439 | 0.994757894063593 | 0.01 | 1e-07 | 0 | -1490.6895
BROOKLYN | E20873.2 | P | IF-TRANSCO/Z3 | 2002-02-01 00:00:00 | -362768 | -360866.3317 | 0.994757894063593 | 0.0125 | 1e-07 | 0 | -4510.7931
BROOKLYN | E20873.3 | P | IF-TRANSCO/Z4 | 2002-02-01 00:00:00 | -361340 | -359445.8174 | 0.994757894063593 | 0.01 | 1e-07 | 0 | -3594.4222
BROOKLYN | E20873.4 | P | NX3 | 2002-02-01 00:00:00 | 9744 | 9658.8555 | 0.991261856237356 | 3.11 | 0.0001 | 0 | 30038.0748
BROOKLYN | E20873.5 | P | NX3 | 2002-02-01 00:00:00 | 23576 | 23369.9895 | 0.991261856237356 | 3.11 | 0.0001 | 0 | 72678.3304
BROOKLYN | E20873.6 | P | NX3 | 2002-02-01 00:00:00 | 23492 | 23286.7235 | 0.991261856237356 | 3.11 | 0.0001 | 0 | 72419.3815
BROOKLYN | E20873.4 | P | IF-TRANSCO/Z1 | 2002-03-01 00:00:00 | 10788 | 10714.5685 | 0.99319322227878 | -0.0825 | -0.0001 | 0 | -882.8804
BROOKLYN | E20873.5 | P | IF-TRANSCO/Z3 | 2002-03-01 00:00:00 | 26102 | 25924.3295 | 0.99319322227878 | 0.0125 | 1e-07 | 0 | 324.0515
BROOKLYN | E20873.6 | P | IF-TRANSCO/Z4 | 2002-03-01 00:00:00 | 26009 | 25831.9625 | 0.99319322227878 | 0.0375 | -0.0001 | 0 | 971.2818
BROOKLYN | E20873.1 | P | IF-TRANSCO/Z1 | 2002-03-01 00:00:00 | -165912 | -164782.6739 | 0.99319322227878 | 0.01 | 1e-07 | 0 | -1647.8103
BROOKLYN | E20873.2 | P | IF-TRANSCO/Z3 | 2002-03-01 00:00:00 | -401636 | -398902.153 | 0.99319322227878 | 0.0125 | 1e-07 | 0 | -4986.237
BROOKLYN | E20873.3 | P | IF-TRANSCO/Z4 | 2002-03-01 00:00:00 | -400055 | -397331.9145 | 0.99319322227878 | 0.01 | 1e-07 | 0 | -3973.2794
BROOKLYN | E20873.4 | P | NX3 | 2002-03-01 00:00:00 | 10788 | 10664.8124 | 0.988581048470346 | 3.065 | 0.0001 | 0 | 32686.5834
BROOKLYN | E20873.5 | P | NX3 | 2002-03-01 00:00:00 | 26102 | 25803.9425 | 0.988581048470346 | 3.065 | 0.0001 | 0 | 79086.5035
BROOKLYN | E20873.6 | P | NX3 | 2002-03-01 00:00:00 | 26009 | 25712.0045 | 0.988581048470346 | 3.065 | 0.0001 | 0 | 78804.7226
BROOKLYN | E20873.4 | P | IF-TRANSCO/Z1 | 2002-04-01 00:00:00 | 10440 | 10351.0324 | 0.991478196622639 | -0.0825 | -0.0001 | 0 | -852.9251
BROOKLYN | E20873.5 | P | IF-TRANSCO/Z3 | 2002-04-01 00:00:00 | 25260 | 25044.7392 | 0.991478196622639 | 0.0125 | 1e-07 | 0 | 313.0567
BROOKLYN | E20873.6 | P | IF-TRANSCO/Z4 | 2002-04-01 00:00:00 | 25170 | 24955.5062 | 0.991478196622639 | 0.0375 | -0.0001 | 0 | 938.327
BROOKLYN | E20873.1 | P | IF-TRANSCO/Z1 | 2002-04-01 00:00:00 | -160560 | -159191.7392 | 0.991478196622639 | 0.01 | 1e-07 | 0 | -1591.9015
BROOKLYN | E20873.2 | P | IF-TRANSCO/Z3 | 2002-04-01 00:00:00 | -388680 | -385367.7455 | 0.991478196622639 | 0.0075 | 1e-07 | 0 | -2890.2196
BROOKLYN | E20873.3 | P | IF-TRANSCO/Z4 | 2002-04-01 00:00:00 | -387150 | -383850.7838 | 0.991478196622639 | 0.01 | 1e-07 | 0 | -3838.4695
BROOKLYN | E20873.4 | P | NX3 | 2002-04-01 00:00:00 | 10440 | 10290.0367 | 0.985635695655898 | 2.985 | 0.0001 | 0 | 30714.7304
BROOKLYN | E20873.5 | P | NX3 | 2002-04-01 00:00:00 | 25260 | 24897.1577 | 0.985635695655898 | 2.985 | 0.0001 | 0 | 74315.5259
BROOKLYN | E20873.6 | P | NX3 | 2002-04-01 00:00:00 | 25170 | 24808.4505 | 0.985635695655898 | 2.985 | 0.0001 | 0 | 74050.7438
BROOKLYN | E20873.4 | P | IF-TRANSCO/Z1 | 2002-05-01 00:00:00 | 10788 | 10677.7414 | 0.989779511372704 | -0.0825 | -0.0001 | 0 | -879.8459
BROOKLYN | E20873.5 | P | IF-TRANSCO/Z3 | 2002-05-01 00:00:00 | 26102 | 25835.2248 | 0.989779511372704 | 0.0125 | 1e-07 | 0 | 322.9377
BROOKLYN | E20873.6 | P | IF-TRANSCO/Z4 | 2002-05-01 00:00:00 | 26009 | 25743.1753 | 0.989779511372704 | 0.0375 | -0.0001 | 0 | 967.9434
BROOKLYN | E20873.1 | P | IF-TRANSCO/Z1 | 2002-05-01 00:00:00 | -165912 | -164216.2983 | 0.989779511372704 | 0.01 | 1e-07 | 0 | -1642.1466
BROOKLYN | E20873.2 | P | IF-TRANSCO/Z3 | 2002-05-01 00:00:00 | -401636 | -397531.0838 | 0.989779511372704 | 0.0075 | 1e-07 | 0 | -2981.4434
BROOKLYN | E20873.3 | P | IF-TRANSCO/Z4 | 2002-05-01 00:00:00 | -400055 | -395966.2424 | 0.989779511372704 | 0.01 | 1e-07 | 0 | -3959.6228
BROOKLYN | E20873.4 | P | NX3 | 2002-05-01 00:00:00 | 10788 | 10601.9341 | 0.982752509431928 | 3.02 | 0.0001 | 0 | 32016.7807
BROOKLYN | E20873.5 | P | NX3 | 2002-05-01 00:00:00 | 26102 | 25651.806 | 0.982752509431928 | 3.02 | 0.0001 | 0 | 77465.8889
BROOKLYN | E20873.6 | P | NX3 | 2002-05-01 00:00:00 | 26009 | 25560.41 | 0.982752509431928 | 3.02 | 0.0001 | 0 | 77189.8822
BROOKLYN | E20873.4 | P | IF-TRANSCO/Z1 | 2002-06-01 00:00:00 | 10440 | 10315.1665 | 0.988042763667407 | -0.0825 | -0.0001 | 0 | -849.9697
BROOKLYN | E20873.5 | P | IF-TRANSCO/Z3 | 2002-06-01 00:00:00 | 25260 | 24957.9602 | 0.988042763667407 | 0.0125 | 1e-07 | 0 | 311.972
BROOKLYN | E20873.6 | P | IF-TRANSCO/Z4 | 2002-06-01 00:00:00 | 25170 | 24869.0364 | 0.988042763667407 | 0.0375 | -0.0001 | 0 | 935.0758
BROOKLYN | E20873.1 | P | IF-TRANSCO/Z1 | 2002-06-01 00:00:00 | -160560 | -158640.1461 | 0.988042763667407 | 0.01 | 1e-07 | 0 | -1586.3856
BROOKLYN | E20873.2 | P | IF-TRANSCO/Z3 | 2002-06-01 00:00:00 | -388680 | -384032.4614 | 0.988042763667407 | 0.0075 | 1e-07 | 0 | -2880.2051
BROOKLYN | E20873.3 | P | IF-TRANSCO/Z4 | 2002-06-01 00:00:00 | -387150 | -382520.756 | 0.988042763667407 | 0.01 | 1e-07 | 0 | -3825.1693
BROOKLYN | E20873.4 | P | NX3 | 2002-06-01 00:00:00 | 10440 | 10229.0842 | 0.97979733735255 | 3.065 | 0.0001 | 0 | 31351.1202
BROOKLYN | E20873.5 | P | NX3 | 2002-06-01 00:00:00 | 25260 | 24749.6807 | 0.97979733735255 | 3.065 | 0.0001 | 0 | 75855.2965
BROOKLYN | E20873.6 | P | NX3 | 2002-06-01 00:00:00 | 25170 | 24661.499 | 0.97979733735255 | 3.065 | 0.0001 | 0 | 75585.0282
BROOKLYN | E20873.4 | P | IF-TRANSCO/Z1 | 2002-07-01 00:00:00 | 10788 | 10640.3233 | 0.986311023194519 | -0.0825 | -0.0001 | 0 | -876.7626
BROOKLYN | E20873.5 | P | IF-TRANSCO/Z3 | 2002-07-01 00:00:00 | 26102 | 25744.6903 | 0.986311023194519 | 0.0125 | 1e-07 | 0 | 321.8061
BROOKLYN | E20873.6 | P | IF-TRANSCO/Z4 | 2002-07-01 00:00:00 | 26009 | 25652.9634 | 0.986311023194519 | 0.0375 | -0.0001 | 0 | 964.5514
BROOKLYN | E20873.1 | P | IF-TRANSCO/Z1 | 2002-07-01 00:00:00 | -165912 | -163640.8345 | 0.986311023194519 | 0.01 | 1e-07 | 0 | -1636.392
BROOKLYN | E20873.2 | P | IF-TRANSCO/Z3 | 2002-07-01 00:00:00 | -401636 | -396138.0141 | 0.986311023194519 | 0.0075 | 1e-07 | 0 | -2970.9955
BROOKLYN | E20873.3 | P | IF-TRANSCO/Z4 | 2002-07-01 00:00:00 | -400055 | -394578.6564 | 0.986311023194519 | 0.01 | 1e-07 | 0 | -3945.7471
BROOKLYN | E20873.4 | P | NX3 | 2002-07-01 00:00:00 | 10788 | 10538.7211 | 0.976892944357849 | 3.108 | 0.0001 | 0 | 32753.2913
BROOKLYN | E20873.5 | P | NX3 | 2002-07-01 00:00:00 | 26102 | 25498.8596 | 0.976892944357849 | 3.108 | 0.0001 | 0 | 79247.9059
BROOKLYN | E20873.6 | P | NX3 | 2002-07-01 00:00:00 | 26009 | 25408.0086 | 0.976892944357849 | 3.108 | 0.0001 | 0 | 78965.5499
BROOKLYN | E20873.4 | P | IF-TRANSCO/Z1 | 2002-08-01 00:00:00 | 10788 | 10619.6676 | 0.984396326747927 | -0.0825 | -0.0001 | 0 | -875.0606
BROOKLYN | E20873.5 | P | IF-TRANSCO/Z3 | 2002-08-01 00:00:00 | 26102 | 25694.7129 | 0.984396326747927 | 0.0125 | 1e-07 | 0 | 321.1813
BROOKLYN | E20873.6 | P | IF-TRANSCO/Z4 | 2002-08-01 00:00:00 | 26009 | 25603.1641 | 0.984396326747927 | 0.0375 | -0.0001 | 0 | 962.679
BROOKLYN | E20873.1 | P | IF-TRANSCO/Z1 | 2002-08-01 00:00:00 | -165912 | -163323.1634 | 0.984396326747927 | 0.01 | 1e-07 | 0 | -1633.2153
BROOKLYN | E20873.2 | P | IF-TRANSCO/Z3 | 2002-08-01 00:00:00 | -401636 | -395369.0031 | 0.984396326747927 | 0.0075 | 1e-07 | 0 | -2965.228
BROOKLYN | E20873.3 | P | IF-TRANSCO/Z4 | 2002-08-01 00:00:00 | -400055 | -393812.6725 | 0.984396326747927 | 0.01 | 1e-07 | 0 | -3938.0873
BROOKLYN | E20873.4 | P | NX3 | 2002-08-01 00:00:00 | 10788 | 10505.0813 | 0.973774684168853 | 3.15 | 0.0001 | 0 | 33089.9556
BROOKLYN | E20873.5 | P | NX3 | 2002-08-01 00:00:00 | 26102 | 25417.4668 | 0.973774684168853 | 3.15 | 0.0001 | 0 | 80062.4787
BROOKLYN | E20873.6 | P | NX3 | 2002-08-01 00:00:00 | 26009 | 25326.9058 | 0.973774684168853 | 3.15 | 0.0001 | 0 | 79777.2205
BROOKLYN | E20873.4 | P | IF-TRANSCO/Z1 | 2002-09-01 00:00:00 | 10440 | 10256.8144 | 0.982453485382349 | -0.0825 | -0.0001 | 0 | -845.1615
BROOKLYN | E20873.5 | P | IF-TRANSCO/Z3 | 2002-09-01 00:00:00 | 25260 | 24816.775 | 0.982453485382349 | 0.0125 | 1e-07 | 0 | 310.2072
BROOKLYN | E20873.6 | P | IF-TRANSCO/Z4 | 2002-09-01 00:00:00 | 25170 | 24728.3542 | 0.982453485382349 | 0.0375 | -0.0001 | 0 | 929.7861
BROOKLYN | E20873.1 | P | IF-TRANSCO/Z1 | 2002-09-01 00:00:00 | -160560 | -157742.7316 | 0.982453485382349 | 0.01 | 1e-07 | 0 | -1577.4115
BROOKLYN | E20873.2 | P | IF-TRANSCO/Z3 | 2002-09-01 00:00:00 | -388680 | -381860.0207 | 0.982453485382349 | 0.0075 | 1e-07 | 0 | -2863.912
BROOKLYN | E20873.3 | P | IF-TRANSCO/Z4 | 2002-09-01 00:00:00 | -387150 | -380356.8669 | 0.982453485382349 | 0.01 | 1e-07 | 0 | -3803.5306
BROOKLYN | E20873.4 | P | NX3 | 2002-09-01 00:00:00 | 10440 | 10133.4308 | 0.970635130701984 | 3.15 | 0.0001 | 0 | 31919.2936
BROOKLYN | E20873.5 | P | NX3 | 2002-09-01 00:00:00 | 25260 | 24518.2434 | 0.970635130701984 | 3.15 | 0.0001 | 0 | 77230.0149
BROOKLYN | E20873.6 | P | NX3 | 2002-09-01 00:00:00 | 25170 | 24430.8862 | 0.970635130701984 | 3.15 | 0.0001 | 0 | 76954.8486
BROOKLYN | E20873.4 | P | IF-TRANSCO/Z1 | 2002-10-01 00:00:00 | 10788 | 10577.3958 | 0.980477921664507 | -0.0825 | -0.0001 | 0 | -871.5774
BROOKLYN | E20873.5 | P | IF-TRANSCO/Z3 | 2002-10-01 00:00:00 | 26102 | 25592.4347 | 0.980477921664507 | 0.0125 | 1e-07 | 0 | 319.9029
BROOKLYN | E20873.6 | P | IF-TRANSCO/Z4 | 2002-10-01 00:00:00 | 26009 | 25501.2503 | 0.980477921664507 | 0.0375 | -0.0001 | 0 | 958.847
BROOKLYN | E20873.1 | P | IF-TRANSCO/Z1 | 2002-10-01 00:00:00 | -165912 | -162673.0529 | 0.980477921664507 | 0.01 | 1e-07 | 0 | -1626.7143
BROOKLYN | E20873.2 | P | IF-TRANSCO/Z3 | 2002-10-01 00:00:00 | -401636 | -393795.2305 | 0.980477921664507 | 0.0075 | 1e-07 | 0 | -2953.4248
BROOKLYN | E20873.3 | P | IF-TRANSCO/Z4 | 2002-10-01 00:00:00 | -400055 | -392245.095 | 0.980477921664507 | 0.01 | 1e-07 | 0 | -3922.4117
BROOKLYN | E20873.4 | P | NX3 | 2002-10-01 00:00:00 | 10788 | 10437.4922 | 0.967509475287412 | 3.185 | 0.0001 | 0 | 33242.369
BROOKLYN | E20873.5 | P | NX3 | 2002-10-01 00:00:00 | 26102 | 25253.9323 | 0.967509475287412 | 3.185 | 0.0001 | 0 | 80431.2491
BROOKLYN | E20873.6 | P | NX3 | 2002-10-01 00:00:00 | 26009 | 25163.9539 | 0.967509475287412 | 3.185 | 0.0001 | 0 | 80144.6769