Spreadsheet: darron_c_giron__7909__PeoplesEnergyCorp
Sheet: Results

Counterparty | Deal Num | Fin | Pub Code | Period | Quantity | Quantity | Factor | Price | Price | Cash | Value
PEOPLESENECOR | V73727.1 | F | NX1 | 2003-01-01 00:00:00 | 186000 | 182228.1045 | 0.979720992041894 | 3.044 | 4.3025 | 0 | -229334.0695
PEOPLESENECOR | V73727.1 | F | NX1 | 2003-02-01 00:00:00 | 168000 | 164174.8058 | 0.97723098680216 | 3.002 | 4.3025 | 0 | -213509.3349
PEOPLESENECOR | V73727.1 | F | NX1 | 2003-03-01 00:00:00 | 186000 | 181328.7797 | 0.97488591209874 | 2.935 | 4.3025 | 0 | -247967.1062
PEOPLESENECOR | V73727.1 | F | NX1 | 2003-04-01 00:00:00 | 180000 | 174980.6892 | 0.972114940214549 | 2.805 | 4.3025 | 0 | -262033.5821
PEOPLESENECOR | V73727.1 | F | NX1 | 2003-05-01 00:00:00 | 186000 | 180280.4989 | 0.969249994155215 | 2.805 | 4.3025 | 0 | -269970.0471
PEOPLESENECOR | V73727.1 | F | NX1 | 2003-06-01 00:00:00 | 180000 | 173909.6817 | 0.966164898245931 | 2.855 | 4.3025 | 0 | -251734.2642
PEOPLESENECOR | V73727.1 | F | NX1 | 2003-07-01 00:00:00 | 186000 | 179123.2431 | 0.963028188680082 | 2.895 | 4.3025 | 0 | -252115.9647
PEOPLESENECOR | V73727.1 | F | NX1 | 2003-08-01 00:00:00 | 186000 | 178488.1298 | 0.959613601055795 | 2.93 | 4.3025 | 0 | -244974.9581
PEOPLESENECOR | V73727.1 | F | NX1 | 2003-09-01 00:00:00 | 180000 | 172092.2701 | 0.956068167087971 | 2.93 | 4.3025 | 0 | -236196.6407
PEOPLESENECOR | V73727.1 | F | NX1 | 2003-10-01 00:00:00 | 186000 | 177171.0231 | 0.952532382099924 | 2.97 | 4.3025 | 0 | -236080.3882
PEOPLESENECOR | V73727.1 | F | NX1 | 2003-11-01 00:00:00 | 180000 | 170780.1896 | 0.948778831024702 | 3.126 | 4.3025 | 0 | -200922.893
PEOPLESENECOR | V73727.1 | F | NX1 | 2003-12-01 00:00:00 | 186000 | 175775.5861 | 0.945030032600121 | 3.278 | 4.3025 | 0 | -180082.0879
PEOPLESENECOR | V73729.1 | F | NX1 | 2004-01-01 00:00:00 | 124000 | 116693.4377 | 0.94107611059325 | 3.335 | 4.27 | 0 | -109108.3643
PEOPLESENECOR | V73729.1 | F | NX1 | 2004-02-01 00:00:00 | 116000 | 108697.6675 | 0.937048857975434 | 3.24 | 4.27 | 0 | -111958.5976
PEOPLESENECOR | V73729.1 | F | NX1 | 2004-03-01 00:00:00 | 124000 | 115714.4296 | 0.933180884075015 | 3.14 | 4.27 | 0 | -130757.3055
PEOPLESENECOR | V73729.1 | F | NX1 | 2004-04-01 00:00:00 | 120000 | 111482.8135 | 0.929023445932518 | 2.97 | 4.27 | 0 | -144927.6576
PEOPLESENECOR | V73729.1 | F | NX1 | 2004-05-01 00:00:00 | 124000 | 114698.9321 | 0.924991387530789 | 2.975 | 4.27 | 0 | -148535.117
PEOPLESENECOR | V73729.1 | F | NX1 | 2004-06-01 00:00:00 | 120000 | 110487.7988 | 0.920731656485566 | 3.015 | 4.27 | 0 | -138662.1875
PEOPLESENECOR | V73729.1 | F | NX1 | 2004-07-01 00:00:00 | 124000 | 113658.312 | 0.916599290579185 | 3.059 | 4.27 | 0 | -137640.2159
PEOPLESENECOR | V73729.1 | F | NX1 | 2004-08-01 00:00:00 | 124000 | 113129.2281 | 0.912332484723205 | 3.109 | 4.27 | 0 | -131343.0338
PEOPLESENECOR | V73729.1 | F | NX1 | 2004-09-01 00:00:00 | 120000 | 108958.2127 | 0.90798510582424 | 3.09 | 4.27 | 0 | -128570.691
PEOPLESENECOR | V73729.1 | F | NX1 | 2004-10-01 00:00:00 | 124000 | 112069.7326 | 0.903788166261051 | 3.105 | 4.27 | 0 | -130561.2385
PEOPLESENECOR | V73729.1 | F | NX1 | 2004-11-01 00:00:00 | 120000 | 107935.6379 | 0.899463649062396 | 3.25 | 4.27 | 0 | -110094.3506
PEOPLESENECOR | V73729.1 | F | NX1 | 2004-12-01 00:00:00 | 124000 | 111006.5511 | 0.895214122075174 | 3.385 | 4.27 | 0 | -98240.7978
PEOPLESENECOR | V73730.1 | F | NX1 | 2005-01-01 00:00:00 | 31000 | 27615.242 | 0.890814257669634 | 3.45 | 4.28 | 0 | -22920.6508
PEOPLESENECOR | V73730.1 | F | NX1 | 2005-02-01 00:00:00 | 28000 | 24819.1874 | 0.886399551620233 | 3.37 | 4.28 | 0 | -22585.4606
PEOPLESENECOR | V73730.1 | F | NX1 | 2005-03-01 00:00:00 | 31000 | 27353.1918 | 0.882361027377819 | 3.271 | 4.28 | 0 | -27599.3706
PEOPLESENECOR | V73730.1 | F | NX1 | 2005-04-01 00:00:00 | 30000 | 26337.8406 | 0.877928018460226 | 3.096 | 4.28 | 0 | -31184.0032
PEOPLESENECOR | V73730.1 | F | NX1 | 2005-05-01 00:00:00 | 31000 | 27083.8208 | 0.87367163884272 | 3.096 | 4.28 | 0 | -32067.2438
PEOPLESENECOR | V73730.1 | F | NX1 | 2005-06-01 00:00:00 | 30000 | 26076.7644 | 0.869225480384934 | 3.136 | 4.28 | 0 | -29831.8185
PEOPLESENECOR | V73730.1 | F | NX1 | 2005-07-01 00:00:00 | 31000 | 26813.3215 | 0.864945855272747 | 3.18 | 4.28 | 0 | -29494.6537
PEOPLESENECOR | V73730.1 | F | NX1 | 2005-08-01 00:00:00 | 31000 | 26676.9702 | 0.860547426607793 | 3.23 | 4.28 | 0 | -28010.8187
PEOPLESENECOR | V73730.1 | F | NX1 | 2005-09-01 00:00:00 | 30000 | 25683.2504 | 0.856108345067649 | 3.211 | 4.28 | 0 | -27455.3946
PEOPLESENECOR | V73730.1 | F | NX1 | 2005-10-01 00:00:00 | 31000 | 26406.2455 | 0.851814372441698 | 3.226 | 4.28 | 0 | -27832.1828
PEOPLESENECOR | V73730.1 | F | NX1 | 2005-11-01 00:00:00 | 30000 | 25422.7125 | 0.847423749139529 | 3.371 | 4.28 | 0 | -23109.2456
PEOPLESENECOR | V73730.1 | F | NX1 | 2005-12-01 00:00:00 | 31000 | 26137.4178 | 0.843142510406505 | 3.506 | 4.28 | 0 | -20230.3614
PEOPLESENECOR | V73732.1 | F | NX1 | 2002-01-01 00:00:00 | 46500 | 0 | 1 | 2.555 | 4.62 | 0 | -96022.5
PEOPLESENECOR | V73732.1 | F | NX1 | 2002-02-01 00:00:00 | 42000 | 41955.6382 | 0.998943765948451 | 2.204 | 4.62 | 0 | -101364.8218
PEOPLESENECOR | V73732.1 | F | NX1 | 2002-03-01 00:00:00 | 46500 | 46385.1946 | 0.997531067211104 | 2.203 | 4.62 | 0 | -112113.0154
PEOPLESENECOR | V73732.1 | F | NX1 | 2002-04-01 00:00:00 | 45000 | 44818.1753 | 0.995959450586816 | 2.25 | 4.62 | 0 | -106219.0754
PEOPLESENECOR | V73732.1 | F | NX1 | 2002-05-01 00:00:00 | 46500 | 46243.014 | 0.994473418647577 | 2.322 | 4.62 | 0 | -106266.4461
PEOPLESENECOR | V73732.1 | F | NX1 | 2002-06-01 00:00:00 | 45000 | 44683.9739 | 0.992977198579575 | 2.39 | 4.62 | 0 | -99645.2619
PEOPLESENECOR | V73732.1 | F | NX1 | 2002-07-01 00:00:00 | 46500 | 46103.2746 | 0.991468271113674 | 2.46 | 4.62 | 0 | -99583.0732
PEOPLESENECOR | V73732.1 | F | NX1 | 2002-08-01 00:00:00 | 46500 | 46022.9336 | 0.989740507098562 | 2.505 | 4.62 | 0 | -97338.5045
PEOPLESENECOR | V73732.1 | F | NX1 | 2002-09-01 00:00:00 | 45000 | 44458.1066 | 0.987957923956766 | 2.51 | 4.62 | 0 | -93806.6049
PEOPLESENECOR | V73732.1 | F | NX1 | 2002-10-01 00:00:00 | 46500 | 45854.8142 | 0.986125036971477 | 2.535 | 4.62 | 0 | -95607.2876
PEOPLESENECOR | V73732.1 | F | NX1 | 2002-11-01 00:00:00 | 45000 | 44283.4473 | 0.984076606805884 | 2.745 | 4.62 | 0 | -83031.4637
PEOPLESENECOR | V73732.1 | F | NX1 | 2002-12-01 00:00:00 | 46500 | 45663.6111 | 0.982013141127998 | 2.95 | 4.62 | 0 | -76258.2305
PEOPLESENECOR | YA8793.1 | F | NX1 | 2002-01-01 00:00:00 | 155000 | 0 | 1 | 2.555 | 3.08 | 0 | -81375
PEOPLESENECOR | YA8793.1 | F | NX1 | 2002-02-01 00:00:00 | 140000 | 139852.1272 | 0.998943765948451 | 2.204 | 3.08 | 0 | -122510.4635
PEOPLESENECOR | YA8793.1 | F | NX1 | 2002-03-01 00:00:00 | 155000 | 154617.3154 | 0.997531067211104 | 2.203 | 3.08 | 0 | -135599.3856
PEOPLESENECOR | YA8793.1 | F | NX1 | 2002-04-01 00:00:00 | 150000 | 149393.9176 | 0.995959450586816 | 2.25 | 3.08 | 0 | -123996.9516
PEOPLESENECOR | YA8793.1 | F | NX1 | 2002-05-01 00:00:00 | 155000 | 154143.3799 | 0.994473418647577 | 2.322 | 3.08 | 0 | -116840.682
PEOPLESENECOR | YA8793.1 | F | NX1 | 2002-06-01 00:00:00 | 150000 | 148946.5798 | 0.992977198579575 | 2.39 | 3.08 | 0 | -102773.1401
PEOPLESENECOR | YA8793.1 | F | NX1 | 2002-07-01 00:00:00 | 155000 | 153677.582 | 0.991468271113674 | 2.46 | 3.08 | 0 | -95280.1009
PEOPLESENECOR | YA8793.1 | F | NX1 | 2002-08-01 00:00:00 | 155000 | 153409.7786 | 0.989740507098562 | 2.505 | 3.08 | 0 | -88210.6227
PEOPLESENECOR | YA8793.1 | F | NX1 | 2002-09-01 00:00:00 | 150000 | 148193.6886 | 0.987957923956766 | 2.51 | 3.08 | 0 | -84470.4025
PEOPLESENECOR | YA8793.1 | F | NX1 | 2002-10-01 00:00:00 | 155000 | 152849.3807 | 0.986125036971477 | 2.535 | 3.08 | 0 | -83302.9125
PEOPLESENECOR | YA8793.1 | F | NX1 | 2002-11-01 00:00:00 | 150000 | 147611.491 | 0.984076606805884 | 2.745 | 3.08 | 0 | -49449.8495
PEOPLESENECOR | YA8793.1 | F | NX1 | 2002-12-01 00:00:00 | 155000 | 152212.0369 | 0.982013141127998 | 2.95 | 3.08 | 0 | -19787.5648
PEOPLESENECOR | YC6668.1 | F | NX1 | 2002-01-01 00:00:00 | 77500 | 0 | 1 | 2.555 | 3.21 | 0 | -50762.5
PEOPLESENECOR | YC6668.1 | F | NX1 | 2002-02-01 00:00:00 | 70000 | 69926.0636 | 0.998943765948451 | 2.204 | 3.21 | 0 | -70345.62
PEOPLESENECOR | YC6668.1 | F | NX1 | 2002-03-01 00:00:00 | 77500 | 77308.6577 | 0.997531067211104 | 2.203 | 3.21 | 0 | -77849.8183
PEOPLESENECOR | YC6668.1 | F | NX1 | 2002-04-01 00:00:00 | 75000 | 74696.9588 | 0.995959450586816 | 2.25 | 3.21 | 0 | -71709.0804
PEOPLESENECOR | YC6668.1 | F | NX1 | 2002-05-01 00:00:00 | 77500 | 77071.6899 | 0.994473418647577 | 2.322 | 3.21 | 0 | -68439.6607
PEOPLESENECOR | YC6668.1 | F | NX1 | 2002-06-01 00:00:00 | 75000 | 74473.2899 | 0.992977198579575 | 2.39 | 3.21 | 0 | -61068.0977
PEOPLESENECOR | YC6668.1 | F | NX1 | 2002-07-01 00:00:00 | 77500 | 76838.791 | 0.991468271113674 | 2.46 | 3.21 | 0 | -57629.0933
PEOPLESENECOR | YC6668.1 | F | NX1 | 2002-08-01 00:00:00 | 77500 | 76704.8893 | 0.989740507098562 | 2.505 | 3.21 | 0 | -54076.947
PEOPLESENECOR | YC6668.1 | F | NX1 | 2002-09-01 00:00:00 | 75000 | 74096.8443 | 0.987957923956766 | 2.51 | 3.21 | 0 | -51867.791
PEOPLESENECOR | YC6668.1 | F | NX1 | 2002-10-01 00:00:00 | 77500 | 76424.6904 | 0.986125036971477 | 2.535 | 3.21 | 0 | -51586.666
PEOPLESENECOR | YC6668.1 | F | NX1 | 2002-11-01 00:00:00 | 75000 | 73805.7455 | 0.984076606805884 | 2.745 | 3.21 | 0 | -34319.6717
PEOPLESENECOR | YC6668.1 | F | NX1 | 2002-12-01 00:00:00 | 77500 | 76106.0184 | 0.982013141127998 | 2.95 | 3.21 | 0 | -19787.5648