Spreadsheet: joe_parks__14701__Hedge Quantity 020325
Sheet: Price 

Hedge Quantity |  |  |  |  | Pv'd  values, need to update to nominal
 |  | Price (NG)
 |  | ENA | ENA | ENA | EES | EES | EES
 |  | Financial | Physical | Total | (excl Oxy I & II) | Oxy II | Total | Net
Total
2002-04-01 00:00:00 |  | 319.1561791 | -53.1069384 |  | -224.9240330688687 | -65.14362968570227
2002-05-01 00:00:00 |  | 378.62151206 | -36.91720797 |  | -167.030150107424 | -59.32452180738047
2002-06-01 00:00:00 |  | 406.74705691 | -93.09870365 |  | -123.2546899907156 | -56.94873058725018
2002-07-01 00:00:00 |  | 423.95937403 | -64.78366147 |  | -109.0946746552686 | -51.59063746142544
2002-08-01 00:00:00 |  | 424.08534482 | -59.60607066 |  | -104.6704288723338 | -53.65370892314952
2002-09-01 00:00:00 |  | 413.36659765 | -55.99350745 |  | -100.0851935475189 | -51.83262836830639
2002-10-01 00:00:00 |  | 396.46362797 | -59.22250814 |  | -115.8948901028747 | -52.77811904496252
2002-11-01 00:00:00 |  | 387.44914542 | -41.02999175 |  | -118.0250377188157 | -49.65292993238935
2002-12-01 00:00:00 |  | 396.64385719 | -30.42512947 |  | -138.627054041637 | -49.95961328143288
2003-01-01 00:00:00 |  | 280.7353062 | 8.83889238 |  | -119.2924464127244 | -48.86172632122182
2003-02-01 00:00:00 |  | 260.52256141 | 7.32858346 |  | -106.8538834281411 | -47.20402964931721
2003-03-01 00:00:00 |  | 203.38138944 | -22.37396722 |  | -92.57391608971515 | -47.37686401384825
2003-04-01 00:00:00 |  | 179.16889974 | -16.87113895 |  | -65.5687110035513 | -35.56915395733129
2003-05-01 00:00:00 |  | 180.66985409 | -16.94413454 |  | -51.74704420972561 | -30.42437831717667
2003-06-01 00:00:00 |  | 180.66077264 | -16.88927579 |  | -42.63931089786244 | -26.27193646702763
2003-07-01 00:00:00 |  | 179.90542401 | -17.84725552 |  | -39.43738507394861 | -22.00439557825293
2003-08-01 00:00:00 |  | 179.29680836 | -18.10590968 |  | -37.15664012245279 | -22.99612734684668
2003-09-01 00:00:00 |  | 175.2557784 | -17.28355976 |  | -38.8228558036451 | -21.06622551619748
2003-10-01 00:00:00 |  | 174.60800139 | -24.25538574 |  | -43.48021699104036 | -22.56036524202877
2003-11-01 00:00:00 |  | 170.0228443 | -25.32844362 |  | -50.2499849461626 | -23.64872920492892
2003-12-01 00:00:00 |  | 172.85593539 | -27.47806256 |  | -58.39884090896031 | -26.58091591903068
2004-01-01 00:00:00 |  | 221.81976452 | -56.07702908 |  | -58.4747089987515 | -25.31523046560913
2004-02-01 00:00:00 |  | 216.12666849 | -51.87961659 |  | -51.95742891608289 | -23.80490652656192
2004-03-01 00:00:00 |  | 219.80136503 | -59.07642947 |  | -46.50511510720936 | -23.3285081310134
2004-04-01 00:00:00 |  | 205.98525345 | -56.29411912 |  | -35.95461484598476 | -18.21935631346966
2004-05-01 00:00:00 |  | 207.26725168 | -57.58858623 |  | -31.14495322232532 | -15.35827302497687
2004-06-01 00:00:00 |  | 204.01855653 | -55.54973147 |  | -18.76900543994277 | -14.46689936271376
2004-07-01 00:00:00 |  | 205.19008477 | -57.2198665 |  | -17.12603012786253 | -9.992872053915201
2004-08-01 00:00:00 |  | 204.19103077 | -57.019548 |  | -15.88548979347098 | -10.53757927017491
2004-09-01 00:00:00 |  | 200.81937239 | -54.93605737 |  | -16.13413495944938 | -7.073780571333868
2004-10-01 00:00:00 |  | 199.87010117 | -56.82071322 |  | -19.07649695248504 | -7.899675446431497
2004-11-01 00:00:00 |  | 197.57854706 | -54.70923681 |  | -16.93658191179642 | -7.729396747370147
2004-12-01 00:00:00 |  | 199.13488295 | -53.14588865 |  | -19.73704993543372 | -9.501553844906343
2005-01-01 00:00:00 |  | 95.60398206 | -52.54128781 |  | -19.32308479631769 | -8.650401260594483
2005-02-01 00:00:00 |  | 85.90666026 | -46.96857316 |  | -17.70203956919321 | -8.554634746347332
2005-03-01 00:00:00 |  | 94.66175535 | -55.17951023 |  | -16.32632385356085 | -8.059189785762564
2005-04-01 00:00:00 |  | 91.13132257 | -52.84524203 |  | -13.43479635703646 | -6.999451185608086
2005-05-01 00:00:00 |  | 93.69638392 | -53.95429053 |  | -11.32834220786955 | -5.423662473726349
2005-06-01 00:00:00 |  | 90.19796372 | -51.97078151 |  | -10.00197855225708 | -5.206628508063548
2005-07-01 00:00:00 |  | 92.73051096 | -52.20337789 |  | -9.422354488472862 | -4.603479989523717
2005-08-01 00:00:00 |  | 92.24264937 | -53.18436092 |  | -9.456341848824295 | -5.399453566430958
2005-09-01 00:00:00 |  | 88.79222539 | -51.22532109 |  | -9.586001621788277 | -5.057571312399228
2005-10-01 00:00:00 |  | 91.27777499 | -52.96530603 |  | -11.22013301719882 | -5.66798354711413
2005-11-01 00:00:00 |  | 87.86382595 | -54.45113615 |  | -11.31046813368793 | -5.492578498248979
2005-12-01 00:00:00 |  | 90.32100025 | -52.6210237 |  | -13.0771846986725 | -6.956889995755024
2006-01-01 00:00:00 |  | 89.65919386 | -53.18615034 |  | -13.3086192377755 | -6.208660070316446
2006-02-01 00:00:00 |  | 80.5441828 | -47.57494229 |  | -11.70915829950544 | -6.132018640515013
2006-03-01 00:00:00 |  | 88.73400597 | -55.51582444 |  | -11.24251646168313 | -5.95982381345348
2006-04-01 00:00:00 |  | 85.41326075 | -53.16209644 |  | -9.114313109611942 | -4.396232675179605
2006-05-01 00:00:00 |  | 87.82780003 | -54.41674604 |  | -7.635720725272684 | -2.443963704779604
2006-06-01 00:00:00 |  | 84.56170807 | -52.45521829 |  | -6.680610053948882 | -0.4205234422613099
2006-07-01 00:00:00 |  | 86.9471542 | -53.97919064 |  | -6.326116966325508 | -0.3924580423438501
2006-08-01 00:00:00 |  | 86.49911095 | -53.73956014 |  | -6.439926108309401 | -0.3634849459881767
2006-09-01 00:00:00 |  | 83.27493679 | -51.75755191 |  | -6.255495598377467 | -0.3469308032077319
2006-10-01 00:00:00 |  | 85.61662975 | -16.73464172 |  | -7.504559720819342 | -0.3786496144389449
2006-11-01 00:00:00 |  | 82.42043391 | -16.24955023 |  | -8.226201909226186 | -0.2536733952034977
2006-12-01 00:00:00 |  | 84.73320862 | -13.71161658 |  | -9.10335325995818 | -0.2656188113998724
2007-01-01 00:00:00 |  | 0.04575415 | -13.41890941 |  | -9.314353837542264 | -0.257214929372219
2007-02-01 00:00:00 |  | 0.04110598 | -11.86116603 |  | -8.312160803807876 | -0.2668058561753238
2007-03-01 00:00:00 |  | 0.04528978 | -16.84925927 |  | -8.429405224904338 | -0.2488800409623309
2007-04-01 00:00:00 |  | 0.04359354 | -16.14398549 |  | -6.844522755209746 | -0.2380908916178214
2007-05-01 00:00:00 |  | 0.04481283 | -16.47902011 |  | -6.067634612497304 | -0.0283001440430326
2007-06-01 00:00:00 |  | 0.04313345 | -15.88711719 |  | -5.613213953819857 | -0.0240391365977644
2007-07-01 00:00:00 |  | 0.04433748 | -16.36303134 |  | -0.165529231392523 | 0
2007-08-01 00:00:00 |  | 0.04409598 | -16.30448068 |  | -0.1614357288212254 | 0
2007-09-01 00:00:00 |  | 0.04243988 | -15.70742849 |  | -0.1983549553142971 | 0
2007-10-01 00:00:00 |  | 0.04362098 | -16.28199005 |  | -0.296254310941169 | 0
2007-11-01 00:00:00 |  | 0.04198038 | -15.77567667 |  | -0.2243845614118627 | 0
2007-12-01 00:00:00 |  | 0.04314636 | -13.71262644 |  | -0.4333341323821739 | 0
2008-01-01 00:00:00 |  | 0 | 0.35158663 |  | -0.3307148555246112 | 0
2008-02-01 00:00:00 |  | 0 | 0.32961465 |  | -0.3267647229696604 | 0
2008-03-01 00:00:00 |  | 0 | 0.36196294 |  | -0.1707437270566679 | 0
2008-04-01 00:00:00 |  | 0 | 0.34925376 |  | -0.1113045520271463 | 0
2008-05-01 00:00:00 |  | 0 | 0.46313874 |  | -0.09735074669695162 | 0
2008-06-01 00:00:00 |  | 0 | 0.44204556 |  | -0.05432482241580205 | 0
2008-07-01 00:00:00 |  | 0 | 0.45042694 |  | -0.05387988961153101 | 0
2008-08-01 00:00:00 |  | 0 | 0.4435397 |  | -0.05280551151712556 | 0
2008-09-01 00:00:00 |  | 0 | 0.42406039 |  | -0.0449469419259913 | 0
2008-10-01 00:00:00 |  | 0 | 0.33258706 |  | -0.0450313654478919 | 0
2008-11-01 00:00:00 |  | 0 | 0.31233554 |  | -0.044764414223323 | 0
2008-12-01 00:00:00 |  | 0 | 0.31341724 |  | -0.0431577493057716 | 0
2009-01-01 00:00:00 |  | 0 | 0.30493251 |  | -0.0435699163209563 | 0
2009-02-01 00:00:00 |  | 0 | 0.27971175 |  | -0.0426418553615292 | 0
2009-03-01 00:00:00 |  | 0 | 0.32264734 |  | -0.0437346786787771 | 0
2009-04-01 00:00:00 |  | 0 | 0.32885081 |  | -0.0434740383829649 | 0
2009-05-01 00:00:00 |  | 0 | 0.43658471 |  | -0.0429124526443161 | 0
2009-06-01 00:00:00 |  | 0 | 0.41760136 |  | -0.0423474117669571 | 0
2009-07-01 00:00:00 |  | 0 | 0.4262032 |  | -0.0421182694645609 | 0
2009-08-01 00:00:00 |  | 0 | 0.42052291 |  | -0.0418821767220948 | 0
2009-09-01 00:00:00 |  | 0 | 0.40255705 |  | -0.041967145896399 | 0
2009-10-01 00:00:00 |  | 0 | 0.3160015 |  | -0.042056885412137 | 0
2009-11-01 00:00:00 |  | 0 | 0.29876029 |  | -0.0418192850958235 | 0
2009-12-01 00:00:00 |  | 0 | 0.30107454 |  | -0.0403297325889525 | 0
2010-01-01 00:00:00 |  | 0 | 0.29391812 |  | -0.0407272863796777 | 0
2010-02-01 00:00:00 |  | 0 | 0.26993631 |  | -0.0398723987102983 | 0
2010-03-01 00:00:00 |  | 0 | 0.30731759 |  | -0.0409063757284741 | 0
2010-04-01 00:00:00 |  | 0 | 0.29259493 |  | -0.0406723201523505 | 0
2010-05-01 00:00:00 |  | 0 | 0.39934919 |  | -0.0401401026439089 | 0
2010-06-01 00:00:00 |  | 0 | 0.3825251 |  | -0.0396046095579322 | 0
2010-07-01 00:00:00 |  | 0 | 0.39053082 |  | -0.0393836144559828 | 0
2010-08-01 00:00:00 |  | 0 | 0.38620307 |  | -0.0391559738826572 | 0
2010-09-01 00:00:00 |  | 0 | 0.36978639 |  | -0.0392285230790776 | 0
2010-10-01 00:00:00 |  | 0 | 0.29055293 |  | -0.0393057269357257 | 0
2010-11-01 00:00:00 |  | 0 | 0.27623904 |  | -0.0390768076717222 | 0
2010-12-01 00:00:00 |  | 0 | 0.27942739 |  | -0.037678536672189 | 0
2011-01-01 00:00:00 |  | 0 | 0.27380305 |  | -0.0380432768059904 | 0
2011-02-01 00:00:00 |  | 0 | 0.24692799 |  | -0.0372381904566566 | 0
2011-03-01 00:00:00 |  | 0 | 0.28092403 |  | -0.0381978002325695 | 0
2011-04-01 00:00:00 |  | 0 | 0.25933696 |  | -0.0379725768390756 | 0
2011-05-01 00:00:00 |  | 0 | 0.34490341 |  | -0.0374693221746099 | 0
2011-06-01 00:00:00 |  | 0 | 0.33049935 |  | -0.0369629713915572 | 0
2011-07-01 00:00:00 |  | 0 | 0.3377106 |  | -0.0367504749995419 | 0
2011-08-01 00:00:00 |  | 0 | 0.33430893 |  | -0.036531643214164 | 0
2011-09-01 00:00:00 |  | 0 | 0.31991647 |  | -0.0365929086773178 | 0
2011-10-01 00:00:00 |  | 0 | 0.25166896 |  | -0.0366587005837971 | 0
2011-11-01 00:00:00 |  | 0 | 0.23997379 |  | -0.0364388043492852 | 0
2011-12-01 00:00:00 |  | 0 | 0.2433084 |  | -0.0351289636656418 | 0
2012-01-01 00:00:00 |  | 0 | 0.23909322 |  | -0.0354628017461096 | 0
2012-02-01 00:00:00 |  | 0 | 0.22961855 |  | -0.034706236142307 | 0
2012-03-01 00:00:00 |  | 0 | 0.25328078 |  | -0.0355879765568261 | 0
2012-04-01 00:00:00 |  | 0 | 0.23116696 |  | -0.035375533889453 | 0
2012-05-01 00:00:00 |  | 0 | 0.30765063 |  | -0.0349187623350019 | 0
2012-06-01 00:00:00 |  | 0 | 0.29484615
2012-07-01 00:00:00 |  | 0 | 0.30213393
2012-08-01 00:00:00 |  | 0 | 0.29946841
2012-09-01 00:00:00 |  | 0 | 0.28686355
2012-10-01 00:00:00 |  | 0 | 0.2260928
2012-11-01 00:00:00 |  | 0 | 0.2165195
2012-12-01 00:00:00 |  | 0 | 0.22064768
2013-01-01 00:00:00 |  | 0 | 0.21759347
2013-02-01 00:00:00 |  | 0 | 0.19546817
2013-03-01 00:00:00 |  | 0 | 0.2153687