Spreadsheet: phillip_m_love__30489__NUI new deals
Sheet: Basis

 |  |  |  |  |  |  |  |  | Totals
 |  | Phy/ |  |  | Monthly | PV | Discount | Mid | Fixed |  | Mid
Counterparty | Deal Num | Fin | Pub Code | Period | Quantity | Quantity | Factor | Price | Price | Cash | Value
NUIUTI | V09140.1 | P | IF-TRANSCO/Z3 | 2001-04-01 00:00:00 | -900000 | -900000 | 1 | -0.004 | 1e-07 | 0 | 3600.09
NUIUTI | V09140.1 | P | IF-TRANSCO/Z3 | 2001-05-01 00:00:00 | -930000 | -929181.4354 | 0.999119823050932 | 0.0175 | 1e-07 | 0 | -16260.5822
NUIUTI | V09140.1 | P | IF-TRANSCO/Z3 | 2001-06-01 00:00:00 | -900000 | -895773.8389 | 0.995304265407535 | 0.0225 | 1e-07 | 0 | -20154.8218
NUIUTI | V09140.1 | P | IF-TRANSCO/Z3 | 2001-07-01 00:00:00 | -930000 | -922310.6543 | 0.991731886299985 | 0.0225 | 1e-07 | 0 | -20751.8975
NUIUTI | V09140.1 | P | IF-TRANSCO/Z3 | 2001-08-01 00:00:00 | -930000 | -918999.1787 | 0.988171159851759 | 0.0225 | 1e-07 | 0 | -20677.3896
NUIUTI | V09140.1 | P | IF-TRANSCO/Z3 | 2001-09-01 00:00:00 | -900000 | -886255.2387 | 0.984728043038908 | 0.0225 | 1e-07 | 0 | -19940.6542
NUIUTI | V09140.1 | P | IF-TRANSCO/Z3 | 2001-10-01 00:00:00 | -930000 | -912743.5175 | 0.981444642513591 | 0.0225 | 1e-07 | 0 | -20536.6379
NUIUTI | V09140.2 | P | IF-TETCO/ELA | 2001-04-01 00:00:00 | -300000 | -300000 | 1 | -0.104 | 1e-07 | 0 | 31200.03
NUIUTI | V09140.2 | P | IF-TETCO/ELA | 2001-05-01 00:00:00 | -310000 | -309727.1451 | 0.999119823050932 | -0.0825 | 1e-07 | 0 | 25552.5204
NUIUTI | V09140.2 | P | IF-TETCO/ELA | 2001-06-01 00:00:00 | -300000 | -298591.2796 | 0.995304265407535 | -0.075 | 1e-07 | 0 | 22394.3758
NUIUTI | V09140.2 | P | IF-TETCO/ELA | 2001-07-01 00:00:00 | -310000 | -307436.8848 | 0.991731886299985 | -0.075 | 1e-07 | 0 | 23057.7971
NUIUTI | V09140.2 | P | IF-TETCO/ELA | 2001-08-01 00:00:00 | -310000 | -306333.0596 | 0.988171159851759 | -0.075 | 1e-07 | 0 | 22975.0101
NUIUTI | V09140.2 | P | IF-TETCO/ELA | 2001-09-01 00:00:00 | -300000 | -295418.4129 | 0.984728043038908 | -0.075 | 1e-07 | 0 | 22156.4105
NUIUTI | V09140.2 | P | IF-TETCO/ELA | 2001-10-01 00:00:00 | -310000 | -304247.8392 | 0.981444642513591 | -0.075 | 1e-07 | 0 | 22818.6184
NUIENEBRO | V09140.4 | F | IF-TRANSCO/Z3 | 2001-05-01 00:00:00 | 930000 | 929181.4354 | 0.999119823050932 | 0.0175 | 1e-07 | 0 | 16260.5822
NUIENEBRO | V09140.4 | F | IF-TRANSCO/Z3 | 2001-06-01 00:00:00 | 900000 | 895773.8389 | 0.995304265407535 | 0.0225 | 1e-07 | 0 | 20154.8218
NUIENEBRO | V09140.4 | F | IF-TRANSCO/Z3 | 2001-07-01 00:00:00 | 930000 | 922310.6543 | 0.991731886299985 | 0.0225 | 1e-07 | 0 | 20751.8975
NUIENEBRO | V09140.4 | F | IF-TRANSCO/Z3 | 2001-08-01 00:00:00 | 930000 | 918999.1787 | 0.988171159851759 | 0.0225 | 1e-07 | 0 | 20677.3896
NUIENEBRO | V09140.4 | F | IF-TRANSCO/Z3 | 2001-09-01 00:00:00 | 900000 | 886255.2387 | 0.984728043038908 | 0.0225 | 1e-07 | 0 | 19940.6542
NUIENEBRO | V09140.4 | F | IF-TRANSCO/Z3 | 2001-10-01 00:00:00 | 930000 | 912743.5175 | 0.981444642513591 | 0.0225 | 1e-07 | 0 | 20536.6379
NUIENEBRO | V09140.5 | F | IF-TETCO/ELA | 2001-05-01 00:00:00 | 310000 | 309727.1451 | 0.999119823050932 | -0.0825 | 1e-07 | 0 | -25552.5204
NUIENEBRO | V09140.5 | F | IF-TETCO/ELA | 2001-06-01 00:00:00 | 300000 | 298591.2796 | 0.995304265407535 | -0.075 | 1e-07 | 0 | -22394.3758
NUIENEBRO | V09140.5 | F | IF-TETCO/ELA | 2001-07-01 00:00:00 | 310000 | 307436.8848 | 0.991731886299985 | -0.075 | 1e-07 | 0 | -23057.7971
NUIENEBRO | V09140.5 | F | IF-TETCO/ELA | 2001-08-01 00:00:00 | 310000 | 306333.0596 | 0.988171159851759 | -0.075 | 1e-07 | 0 | -22975.0101
NUIENEBRO | V09140.5 | F | IF-TETCO/ELA | 2001-09-01 00:00:00 | 300000 | 295418.4129 | 0.984728043038908 | -0.075 | 1e-07 | 0 | -22156.4105
NUIENEBRO | V09140.5 | F | IF-TETCO/ELA | 2001-10-01 00:00:00 | 310000 | 304247.8392 | 0.981444642513591 | -0.075 | 1e-07 | 0 | -22818.6184