Spreadsheet: kam_keiser__17975__new power 12-3-01
Sheet: BANK B

Counterparty | Deal Num | Fin | Pub Code | Period | Quantity | Quantity | Factor | Price | Price | Cash | Value
NEWPOWCOM | QX3686.1 | P | NGI-PGE/CG | 2001-12-01 00:00:00 | -251142 | -251142 | 1 | 0.36 | 1.915 | 0 | 390525.81
NEWPOWCOM | QX3686.1 | P | NGI-PGE/CG | 2002-01-01 00:00:00 | -206502 | -206146.1387 | 0.998276717277804 | 0.42 | 1.915 | 0 | 308188.4773
NEWPOWCOM | QX3686.1 | P | NGI-PGE/CG | 2002-02-01 00:00:00 | -167064 | -166488.1136 | 0.996552899368784 | 0.32 | 1.915 | 0 | 265548.5412
NEWPOWCOM | QX3686.1 | P | NGI-PGE/CG | 2002-03-01 00:00:00 | -152267 | -151511.4264 | 0.995037837510279 | 0.29 | 1.915 | 0 | 246206.0679
NEWPOWCOM | QX3686.1 | P | NGI-PGE/CG | 2002-04-01 00:00:00 | -108987 | -108283.2836 | 0.993543115981984 | 0.155 | 1.915 | 0 | 190578.5791
NEWPOWCOM | QX3686.1 | P | NGI-PGE/CG | 2002-05-01 00:00:00 | -80837 | -80179.6816 | 0.991868595282231 | 0.165 | 1.915 | 0 | 140314.4429
NEWPOWCOM | QX3686.1 | P | NGI-PGE/CG | 2002-06-01 00:00:00 | -59455 | -58867.5078 | 0.990118707740375 | 0.23 | 1.915 | 0 | 99191.7506
NEWPOWCOM | QX3686.1 | P | NGI-PGE/CG | 2002-07-01 00:00:00 | -53441 | -52816.8227 | 0.988320254913888 | 0.36 | 1.915 | 0 | 82130.1594
NEWPOWCOM | QX3686.1 | P | NGI-PGE/CG | 2002-08-01 00:00:00 | -50799 | -50100.9333 | 0.986258258250427 | 0.37 | 1.915 | 0 | 77405.9419
NEWPOWCOM | QX3686.1 | P | NGI-PGE/CG | 2002-09-01 00:00:00 | -52497 | -51662.8741 | 0.984110979917124 | 0.365 | 1.915 | 0 | 80077.4549
NEWPOWCOM | QX3686.1 | P | NGI-PGE/CG | 2002-10-01 00:00:00 | -70563 | -69284.8086 | 0.981885813068546 | 0.26 | 1.915 | 0 | 114666.3583
NEWPOWCOM | QX3686.1 | P | NGI-PGE/CG | 2002-11-01 00:00:00 | -157860 | -154605.984 | 0.979386696897611 | 0.24 | 1.915 | 0 | 258965.0232
NEWPOWCOM | QX3686.1 | P | NGI-PGE/CG | 2002-12-01 00:00:00 | -214177 | -209220.5424 | 0.976858123894859 | 0.35 | 1.915 | 0 | 327430.1489
NEWPOWCOM | QX3686.1 | P | NGI-PGE/CG | 2003-01-01 00:00:00 | -175987 | -171423.5678 | 0.97406949242571 | 0.48 | 1.915 | 0 | 245992.8197
NEWPOWCOM | QX3686.1 | P | NGI-PGE/CG | 2003-02-01 00:00:00 | -142288 | -138172.4035 | 0.971075589742057 | 0.38 | 1.915 | 0 | 212094.6394
NEWPOWCOM | QX3686.1 | P | NGI-PGE/CG | 2003-03-01 00:00:00 | -129608 | -125493.8458 | 0.968256942786828 | 0.25 | 1.915 | 0 | 208947.2533
NEWPOWCOM | QX3686.1 | P | NGI-PGE/CG | 2003-04-01 00:00:00 | -92710 | -89466.6556 | 0.96501623941169 | 0.47 | 1.915 | 0 | 129279.3173
NEWPOWCOM | QX3686.1 | P | NGI-PGE/CG | 2003-05-01 00:00:00 | -68725 | -66098.3292 | 0.961779981262143 | 0.47 | 1.915 | 0 | 95512.0857
NEWPOWCOM | QX3686.1 | P | NGI-PGE/CG | 2003-06-01 00:00:00 | -50515 | -48409.149 | 0.958312363093096 | 0.47 | 1.915 | 0 | 69951.2203
NEWPOWCOM | QX3686.1 | P | NGI-PGE/CG | 2003-07-01 00:00:00 | -22978 | -21940.6895 | 0.954856363782377 | 0.47 | 1.915 | 0 | 31704.2964
NEWPOWCOM | QX3686.1 | P | NGI-PGE/CG | 2003-08-01 00:00:00 | -7912 | -7525.8407 | 0.951193217174873 | 0.47 | 1.915 | 0 | 10874.8399
NEWPOWCOM | V42613.1 | P | NGI-PGE/CG | 2001-12-01 00:00:00 | 97437 | 97437 | 1 | 0.36 | 3.7 | 0 | -325439.58
NEWPOWCOM | V42613.1 | P | NGI-PGE/CG | 2002-01-01 00:00:00 | 79045 | 78908.7831 | 0.998276717277804 | 0.42 | 3.7 | 0 | -258820.8086
NEWPOWCOM | V42613.1 | P | NGI-PGE/CG | 2002-02-01 00:00:00 | 63507 | 63288.085 | 0.996552899368784 | 0.32 | 3.7 | 0 | -213913.7272
NEWPOWCOM | V42613.1 | P | NGI-PGE/CG | 2002-03-01 00:00:00 | 57558 | 57272.3879 | 0.995037837510279 | 0.29 | 3.7 | 0 | -195298.8426
NEWPOWCOM | V42613.1 | P | NGI-PGE/CG | 2002-04-01 00:00:00 | 40916 | 40651.8101 | 0.993543115981984 | 0.155 | 3.7 | 0 | -144110.6669
NEWPOWCOM | V42613.1 | P | NGI-PGE/CG | 2002-05-01 00:00:00 | 30150 | 29904.8381 | 0.991868595282231 | 0.165 | 3.7 | 0 | -105713.6029
NEWPOWCOM | V42613.1 | P | NGI-PGE/CG | 2002-06-01 00:00:00 | 22019 | 21801.4238 | 0.990118707740375 | 0.23 | 3.7 | 0 | -75650.9407
NEWPOWCOM | V42613.1 | P | NGI-PGE/CG | 2002-07-01 00:00:00 | 19658 | 19428.3996 | 0.988320254913888 | 0.36 | 3.7 | 0 | -64890.8546
NEWPOWCOM | V42613.1 | P | NGI-PGE/CG | 2002-08-01 00:00:00 | 18548 | 18293.1182 | 0.986258258250427 | 0.37 | 3.7 | 0 | -60916.0835
NEWPOWCOM | V42613.1 | P | NGI-PGE/CG | 2002-09-01 00:00:00 | 19021 | 18718.7749 | 0.984110979917124 | 0.365 | 3.7 | 0 | -62427.1145
NEWPOWCOM | V42613.1 | P | NGI-PGE/CG | 2002-10-01 00:00:00 | 25379 | 24919.28 | 0.981885813068546 | 0.26 | 3.7 | 0 | -85722.3234
NEWPOWCOM | V42613.1 | P | NGI-PGE/CG | 2002-11-01 00:00:00 | 56318 | 55157.1 | 0.979386696897611 | 0.24 | 3.7 | 0 | -190843.566
NEWPOWCOM | V42613.1 | P | NGI-PGE/CG | 2002-12-01 00:00:00 | 75820 | 74065.383 | 0.976858123894859 | 0.35 | 3.7 | 0 | -248119.0329
NEWPOWCOM | V42613.1 | P | NGI-PGE/CG | 2003-01-01 00:00:00 | 61484 | 59889.6887 | 0.97406949242571 | 0.48 | 3.7 | 0 | -192844.7975
NEWPOWCOM | V42613.1 | P | NGI-PGE/CG | 2003-02-01 00:00:00 | 49260 | 47835.1836 | 0.971075589742057 | 0.38 | 3.7 | 0 | -158812.8094
NEWPOWCOM | V42613.1 | P | NGI-PGE/CG | 2003-03-01 00:00:00 | 44529 | 43115.5134 | 0.968256942786828 | 0.25 | 3.7 | 0 | -148748.5212
NEWPOWCOM | V42613.1 | P | NGI-PGE/CG | 2003-04-01 00:00:00 | 31563 | 30458.8076 | 0.96501623941169 | 0.47 | 3.7 | 0 | -98381.9484
NEWPOWCOM | V42613.1 | P | NGI-PGE/CG | 2003-05-01 00:00:00 | 23195 | 22308.4867 | 0.961779981262143 | 0.47 | 3.7 | 0 | -72056.4119
NEWPOWCOM | V42613.1 | P | NGI-PGE/CG | 2003-06-01 00:00:00 | 16889 | 16184.9375 | 0.958312363093096 | 0.47 | 3.7 | 0 | -52277.3481
NEWPOWCOM | V42613.1 | P | NGI-PGE/CG | 2003-07-01 00:00:00 | 7620 | 7276.0055 | 0.954856363782377 | 0.47 | 3.7 | 0 | -23501.4977
NEWPOWCOM | V42613.1 | P | NGI-PGE/CG | 2003-08-01 00:00:00 | 2599 | 2472.1512 | 0.951193217174873 | 0.47 | 3.7 | 0 | -7985.0483
NEWPOWCOM | Y19446.1 | P | NGI-PGE/CG | 2003-08-01 00:00:00 | -7448 | -7084.4871 | 0.951193217174873 | 0.47 | 0.415 | 0 | -389.6468
NEWPOWCOM | Y19446.1 | P | NGI-PGE/CG | 2003-09-01 00:00:00 | -10504 | -9951.6313 | 0.947413494698583 | 0.47 | 0.415 | 0 | -547.3397
NEWPOWCOM | Y19446.1 | P | NGI-PGE/CG | 2003-10-01 00:00:00 | -9328 | -8802.7985 | 0.943696237423744 | 0.47 | 0.415 | 0 | -484.1539
NEWPOWCOM | Y19446.1 | P | NGI-PGE/CG | 2003-11-01 00:00:00 | -2881 | -2707.6011 | 0.939812962690508 | 0.52 | 0.415 | 0 | -284.2981
NEWPOWCOM | Y19649.1 | P | NGI-PGE/CG | 2001-12-01 00:00:00 | 89299 | 89299 | 1 | 0.36 | 0.25 | 0 | 9822.89
NEWPOWCOM | Y19649.1 | P | NGI-PGE/CG | 2002-01-01 00:00:00 | 74136 | 74008.2427 | 0.998276717277804 | 0.42 | 0.25 | 0 | 12581.4013
NEWPOWCOM | Y19649.1 | P | NGI-PGE/CG | 2002-02-01 00:00:00 | 59961 | 59754.3084 | 0.996552899368784 | 0.32 | 0.25 | 0 | 4182.8016
NEWPOWCOM | Y19649.1 | P | NGI-PGE/CG | 2002-03-01 00:00:00 | 55027 | 54753.9471 | 0.995037837510279 | 0.29 | 0.25 | 0 | 2190.1579
NEWPOWCOM | Y19649.1 | P | NGI-PGE/CG | 2002-04-01 00:00:00 | 38060 | 37814.251 | 0.993543115981984 | 0.155 | 0.25 | 0 | -3592.3538
NEWPOWCOM | Y19649.1 | P | NGI-PGE/CG | 2002-05-01 00:00:00 | 28530 | 28298.011 | 0.991868595282231 | 0.165 | 0.25 | 0 | -2405.3309
NEWPOWCOM | Y19649.1 | P | NGI-PGE/CG | 2002-06-01 00:00:00 | 21117 | 20908.3368 | 0.990118707740375 | 0.23 | 0.25 | 0 | -418.1667
NEWPOWCOM | Y19649.1 | P | NGI-PGE/CG | 2002-07-01 00:00:00 | 18850 | 18629.8368 | 0.988320254913888 | 0.36 | 0.25 | 0 | 2049.282
NEWPOWCOM | Y19649.1 | P | NGI-PGE/CG | 2002-08-01 00:00:00 | 18065 | 17816.7554 | 0.986258258250427 | 0.37 | 0.25 | 0 | 2138.0107
NEWPOWCOM | Y19649.1 | P | NGI-PGE/CG | 2002-09-01 00:00:00 | 18799 | 18500.3023 | 0.984110979917124 | 0.365 | 0.25 | 0 | 2127.5348
NEWPOWCOM | Y19649.1 | P | NGI-PGE/CG | 2002-10-01 00:00:00 | 25178 | 24721.921 | 0.981885813068546 | 0.26 | 0.25 | 0 | 247.2192
NEWPOWCOM | Y19649.1 | P | NGI-PGE/CG | 2002-11-01 00:00:00 | 58557 | 57349.9468 | 0.979386696897611 | 0.24 | 0.25 | 0 | -573.4995
NEWPOWCOM | Y19649.1 | P | NGI-PGE/CG | 2002-12-01 00:00:00 | 80009 | 78157.4416 | 0.976858123894859 | 0.35 | 0.25 | 0 | 7815.7442
NEWPOWCOM | Y19649.1 | P | NGI-PGE/CG | 2003-01-01 00:00:00 | 66287 | 64568.1444 | 0.97406949242571 | 0.48 | 0.25 | 0 | 14850.6732
NEWPOWCOM | Y19649.1 | P | NGI-PGE/CG | 2003-02-01 00:00:00 | 53601 | 52050.6227 | 0.971075589742057 | 0.38 | 0.25 | 0 | 6766.5809
NEWPOWCOM | Y19649.1 | P | NGI-PGE/CG | 2003-03-01 00:00:00 | 49195 | 47633.4003 | 0.968256942786828 | 0.25 | 0.25 | 0 | 0
NEWPOWCOM | Y19649.1 | P | NGI-PGE/CG | 2003-04-01 00:00:00 | 34009 | 32819.2373 | 0.96501623941169 | 0.47 | 0.25 | 0 | 7220.2322
NEWPOWCOM | Y19649.1 | P | NGI-PGE/CG | 2003-05-01 00:00:00 | 25496 | 24521.5424 | 0.961779981262143 | 0.47 | 0.25 | 0 | 5394.7393
NEWPOWCOM | Y19649.1 | P | NGI-PGE/CG | 2003-06-01 00:00:00 | 18870 | 18083.3543 | 0.958312363093096 | 0.47 | 0.25 | 0 | 3978.3379
NEWPOWCOM | Y19649.1 | P | NGI-PGE/CG | 2003-07-01 00:00:00 | 1896 | 1810.4077 | 0.954856363782377 | 0.47 | 0.25 | 0 | 398.2897
NEWPOWCOM | [NAME] | P | MICH_CG-GD | 2001-12-01 00:00:00 | -86800 | -86800 | 1 | 0.144 | -0.0225 | 0 | -14452.2
NEWPOWCOM | [NAME] | P | MICH_CG-GD | 2002-01-01 00:00:00 | -86800 | -86650.4191 | 0.998276717277804 | 0.115 | -0.0225 | 0 | -11914.4326
NEWPOWCOM | [NAME] | P | MICH_CG-GD | 2002-02-01 00:00:00 | -78400 | -78129.7473 | 0.996552899368784 | 0.105 | -0.0225 | 0 | -9961.5428
NEWPOWCOM | [NAME] | P | MICH_CG-GD | 2002-03-01 00:00:00 | -86800 | -86369.2843 | 0.995037837510279 | 0.095 | -0.0225 | 0 | -10148.3909