Spreadsheet: phillip_m_love__30489__NUI new deals
Sheet: Price

 |  |  |  |  |  |  |  |  | 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 | NX1 | 2001-04-01 00:00:00 | -900000 | 0 | 1 | 5.384 | 1e-07 | 0 | -4845599.91
NUIUTI | V09140.1 | P | NX1 | 2001-05-01 00:00:00 | -930000 | -929181.4354 | 0.999119823050932 | 5.078 | 1e-07 | 0 | -4718383.2362
NUIUTI | V09140.1 | P | NX1 | 2001-06-01 00:00:00 | -900000 | -895773.8389 | 0.995304265407535 | 5.114 | 1e-07 | 0 | -4580987.3224
NUIUTI | V09140.1 | P | NX1 | 2001-07-01 00:00:00 | -930000 | -922310.6543 | 0.991731886299985 | 5.177 | 1e-07 | 0 | -4774802.1649
NUIUTI | V09140.1 | P | NX1 | 2001-08-01 00:00:00 | -930000 | -918999.1787 | 0.988171159851759 | 5.232 | 1e-07 | 0 | -4808203.6109
NUIUTI | V09140.1 | P | NX1 | 2001-09-01 00:00:00 | -900000 | -886255.2387 | 0.984728043038908 | 5.245 | 1e-07 | 0 | -4648408.6385
NUIUTI | V09140.1 | P | NX1 | 2001-10-01 00:00:00 | -930000 | -912743.5175 | 0.981444642513591 | 5.275 | 1e-07 | 0 | -4814721.9637
NUIUTI | V09140.2 | P | NX1 | 2001-04-01 00:00:00 | -300000 | 0 | 1 | 5.384 | 1e-07 | 0 | -1615199.97
NUIUTI | V09140.2 | P | NX1 | 2001-05-01 00:00:00 | -310000 | -309727.1451 | 0.999119823050932 | 5.078 | 1e-07 | 0 | -1572794.4121
NUIUTI | V09140.2 | P | NX1 | 2001-06-01 00:00:00 | -300000 | -298591.2796 | 0.995304265407535 | 5.114 | 1e-07 | 0 | -1526995.7741
NUIUTI | V09140.2 | P | NX1 | 2001-07-01 00:00:00 | -310000 | -307436.8848 | 0.991731886299985 | 5.177 | 1e-07 | 0 | -1591600.7216
NUIUTI | V09140.2 | P | NX1 | 2001-08-01 00:00:00 | -310000 | -306333.0596 | 0.988171159851759 | 5.232 | 1e-07 | 0 | -1602734.537
NUIUTI | V09140.2 | P | NX1 | 2001-09-01 00:00:00 | -300000 | -295418.4129 | 0.984728043038908 | 5.245 | 1e-07 | 0 | -1549469.5462
NUIUTI | V09140.2 | P | NX1 | 2001-10-01 00:00:00 | -310000 | -304247.8392 | 0.981444642513591 | 5.275 | 1e-07 | 0 | -1604907.3212
NUIUTI | V09140.3 | P | ANNUITY | 2001-11-01 00:00:00 | 0 | 0 | 0.978012868047364 | 5.42 | 0 | 9739503.0039 | 0
NUIUTI | V09140.3 | P | ANNUITY | 2001-12-01 00:00:00 | 0 | 0 | 0.974741223356497 | 5.562 | 0 | 9706922.4579 | 0
NUIUTI | V09140.3 | P | ANNUITY | 2002-01-01 00:00:00 | 0 | 0 | 0.971309677455204 | 5.617 | 0 | 9672749.5419 | 0
NUIUTI | V09140.3 | P | ANNUITY | 2002-02-01 00:00:00 | 0 | 0 | 0.96774773892674 | 5.462 | 0 | 9637278.1159 | 0
NUIUTI | V09140.3 | P | ANNUITY | 2002-03-01 00:00:00 | 0 | 0 | 0.964524863431302 | 5.205 | 0 | 9605183.236 | 0
NUIENEBRO | V09140.4 | F | NX1 | 2001-05-01 00:00:00 | 930000 | 929181.4354 | 0.999119823050932 | 5.078 | 5.579 | 0 | -465519.8992
NUIENEBRO | V09140.4 | F | NX1 | 2001-06-01 00:00:00 | 900000 | 895773.8389 | 0.995304265407535 | 5.114 | 5.579 | 0 | -416534.8351
NUIENEBRO | V09140.4 | F | NX1 | 2001-07-01 00:00:00 | 930000 | 922310.6543 | 0.991731886299985 | 5.177 | 5.579 | 0 | -370768.883
NUIENEBRO | V09140.4 | F | NX1 | 2001-08-01 00:00:00 | 930000 | 918999.1787 | 0.988171159851759 | 5.232 | 5.579 | 0 | -318892.715
NUIENEBRO | V09140.4 | F | NX1 | 2001-09-01 00:00:00 | 900000 | 886255.2387 | 0.984728043038908 | 5.245 | 5.579 | 0 | -296009.2497
NUIENEBRO | V09140.4 | F | NX1 | 2001-10-01 00:00:00 | 930000 | 912743.5175 | 0.981444642513591 | 5.275 | 5.579 | 0 | -277474.0293
NUIENEBRO | V09140.5 | F | NX1 | 2001-05-01 00:00:00 | 310000 | 309727.1451 | 0.999119823050932 | 5.078 | 5.477 | 0 | -123581.1309
NUIENEBRO | V09140.5 | F | NX1 | 2001-06-01 00:00:00 | 300000 | 298591.2796 | 0.995304265407535 | 5.114 | 5.477 | 0 | -108388.6345
NUIENEBRO | V09140.5 | F | NX1 | 2001-07-01 00:00:00 | 310000 | 307436.8848 | 0.991731886299985 | 5.177 | 5.477 | 0 | -92231.0654
NUIENEBRO | V09140.5 | F | NX1 | 2001-08-01 00:00:00 | 310000 | 306333.0596 | 0.988171159851759 | 5.232 | 5.477 | 0 | -75051.5996
NUIENEBRO | V09140.5 | F | NX1 | 2001-09-01 00:00:00 | 300000 | 295418.4129 | 0.984728043038908 | 5.245 | 5.477 | 0 | -68537.0718
NUIENEBRO | V09140.5 | F | NX1 | 2001-10-01 00:00:00 | 310000 | 304247.8392 | 0.981444642513591 | 5.275 | 5.477 | 0 | -61458.0635