Spreadsheet: john_arnold__15200__AppalachiaGas2
Sheet: Curves

 | Discount Rate (flat) | Nymex Mid Curve | Nymex Mid Volatility |  | CNG Mid | CNG Volatility | TCO Mid | TCO Volatility
2000-12-01 00:00:00 | 0.9932457839728337 | 4.771 | 0.635 |  | 0.4 | 0.667 | 0.26 | 0.635
2001-01-01 00:00:00 | 0.9875990723399881 | 4.795 | 0.6725 |  | 0.48 | 0.7060000000000001 | 0.28 | 0.6729999999999999
2001-02-01 00:00:00 | 0.9817670338053394 | 4.612 | 0.6725 |  | 0.48 | 0.7060000000000001 | 0.28 | 0.6729999999999999
2001-03-01 00:00:00 | 0.9768468643841404 | 4.4 | 0.625 |  | 0.4 | 0.6559999999999999 | 0.25 | 0.625
2001-04-01 00:00:00 | 0.9714700414455075 | 4.175 | 0.505 |  | 0.27 | 0.495 | 0.22 | 0.495
2001-05-01 00:00:00 | 0.9662764037997693 | 4.097 | 0.44 |  | 0.24 | 0.431 | 0.2 | 0.431
2001-06-01 00:00:00 | 0.9609824434681254 | 4.092 | 0.425 |  | 0.25 | 0.417 | 0.21 | 0.417
2001-07-01 00:00:00 | 0.9559143315221984 | 4.087 | 0.42 |  | 0.27 | 0.412 | 0.21 | 0.412
2001-08-01 00:00:00 | 0.95071452670818 | 4.085 | 0.42 |  | 0.27 | 0.412 | 0.21 | 0.412
2001-09-01 00:00:00 | 0.9455762676873827 | 4.085 | 0.42 |  | 0.25 | 0.412 | 0.2 | 0.412
2001-10-01 00:00:00 | 0.9406385129450779 | 4.098 | 0.42 |  | 0.27 | 0.412 | 0.22 | 0.412
2001-11-01 00:00:00 | 0.9355503295441036 | 4.218 | 0.42 |  | 0.3225 | 0.42 | 0.25 | 0.42
2001-12-01 00:00:00 | 0.9306730756831438 | 4.34 | 0.4225 |  | 0.43 | 0.423 | 0.285 | 0.423
2002-01-01 00:00:00 | 0.9256385813682371 | 4.355 | 0.425 |  | 0.46 | 0.425 | 0.295 | 0.425
2002-02-01 00:00:00 | 0.9205838801814106 | 4.169 | 0.4175 |  | 0.45 | 0.418 | 0.295 | 0.418
2002-03-01 00:00:00 | 0.9160480073155134 | 3.992 | 0.38 |  | 0.43 | 0.38 | 0.265 | 0.38
2002-04-01 00:00:00 | 0.911067501601251 | 3.805 | 0.3325 |  | 0.25 | 0.326 | 0.205 | 0.326
2002-05-01 00:00:00 | 0.9062952631423455 | 3.76 | 0.3165 |  | 0.2025 | 0.31 | 0.1925 | 0.31
2002-06-01 00:00:00 | 0.9013995313266732 | 3.755 | 0.3165 |  | 0.2025 | 0.31 | 0.1925 | 0.31
2002-07-01 00:00:00 | 0.8966788406574668 | 3.78 | 0.3165 |  | 0.215 | 0.31 | 0.1925 | 0.31
2002-08-01 00:00:00 | 0.8918049712356356 | 3.79 | 0.3165 |  | 0.215 | 0.31 | 0.1925 | 0.31
2002-09-01 00:00:00 | 0.8869623575264773 | 3.802 | 0.3165 |  | 0.195 | 0.31 | 0.1925 | 0.31
2002-10-01 00:00:00 | 0.8822948115416809 | 3.81 | 0.3265 |  | 0.215 | 0.32 | 0.1975 | 0.32
2002-11-01 00:00:00 | 0.8774852476587797 | 3.935 | 0.33 |  | 0.315 | 0.33 | 0.2975 | 0.33
2002-12-01 00:00:00 | 0.8728580758402918 | 4.05 | 0.3315 |  | 0.395 | 0.332 | 0.335 | 0.332
2003-01-01 00:00:00 | 0.86807768706532 | 4.065 | 0.3325 |  | 0.465 | 0.333 | 0.32 | 0.333
2003-02-01 00:00:00 | 0.8632899518558337 | 3.92 | 0.3265 |  | 0.435 | 0.327 | 0.31 | 0.327
2003-03-01 00:00:00 | 0.858986328514677 | 3.74 | 0.314 |  | 0.39 | 0.314 | 0.29 | 0.314
2003-04-01 00:00:00 | 0.85426294714496 | 3.56 | 0.291 |  | 0.25 | 0.285 | 0.205 | 0.285
2003-05-01 00:00:00 | 0.8497406785040805 | 3.515 | 0.286 |  | 0.2025 | 0.28 | 0.1925 | 0.28
2003-06-01 00:00:00 | 0.845093609261533 | 3.528 | 0.2835 |  | 0.2025 | 0.278 | 0.1925 | 0.278
2003-07-01 00:00:00 | 0.8406146123186595 | 3.536 | 0.2835 |  | 0.215 | 0.278 | 0.1925 | 0.278
2003-08-01 00:00:00 | 0.8360015838910926 | 3.538 | 0.2835 |  | 0.215 | 0.278 | 0.1925 | 0.278
2003-09-01 00:00:00 | 0.8314136118449144 | 3.54 | 0.2835 |  | 0.195 | 0.278 | 0.1925 | 0.278
2003-10-01 00:00:00 | 0.8269923507395146 | 3.55 | 0.2845 |  | 0.215 | 0.279 | 0.1975 | 0.279
2003-11-01 00:00:00 | 0.8224414191254651 | 3.685 | 0.2875 |  | 0.315 | 0.288 | 0.2975 | 0.288
2003-12-01 00:00:00 | 0.8180602697330873 | 3.82 | 0.2925 |  | 0.395 | 0.293 | 0.335 | 0.293
2004-01-01 00:00:00 | 0.8135338365881739 | 3.845 | 0.305 |  | 0.465 | 0.305 | 0.32 | 0.305
2004-02-01 00:00:00 | 0.8090054295270842 | 3.735 | 0.295 |  | 0.435 | 0.295 | 0.31 | 0.295
2004-03-01 00:00:00 | 0.8047889321502194 | 3.6 | 0.2915 |  | 0.39 | 0.292 | 0.29 | 0.292
2004-04-01 00:00:00 | 0.8003238023631074 | 3.465 | 0.2725 |  | 0.25 | 0.267 | 0.205 | 0.267
2004-05-01 00:00:00 | 0.7960463016296603 | 3.425 | 0.27 |  | 0.2025 | 0.265 | 0.1925 | 0.265
2004-06-01 00:00:00 | 0.7916490539416644 | 3.438 | 0.27 |  | 0.2025 | 0.265 | 0.1925 | 0.265
2004-07-01 00:00:00 | 0.7874109586517977 | 3.461 | 0.2675 |  | 0.215 | 0.262 | 0.1925 | 0.262
2004-08-01 00:00:00 | 0.7830488009190133 | 3.478 | 0.2675 |  | 0.215 | 0.262 | 0.1925 | 0.262
2004-09-01 00:00:00 | 0.778709173760941 | 3.495 | 0.2675 |  | 0.195 | 0.262 | 0.1925 | 0.262
2004-10-01 00:00:00 | 0.7745266945432124 | 3.52 | 0.2675 |  | 0.215 | 0.262 | 0.1975 | 0.262
2004-11-01 00:00:00 | 0.7702225249450776 | 3.665 | 0.27 |  | 0.315 | 0.27 | 0.2725 | 0.27
2004-12-01 00:00:00 | 0.7660781034511478 | 3.81 | 0.2725 |  | 0.395 | 0.273 | 0.3075 | 0.273
2005-01-01 00:00:00 | 0.7617220445119587 | 3.845 | 0.28 |  | 0.465 | 0.28 | 0.3125 | 0.28
2005-02-01 00:00:00 | 0.7573056353467761 | 3.735 | 0.2675 |  | 0.435 | 0.268 | 0.3125 | 0.268
2005-03-01 00:00:00 | 0.7533310085255284 | 3.6 | 0.26 |  | 0.39 | 0.26 | 0.27 | 0.26
2005-04-01 00:00:00 | 0.7489464643406342 | 3.465 | 0.245 |  | 0.25 | 0.24 | 0.205 | 0.24
2005-05-01 00:00:00 | 0.744719306702733 | 3.425 | 0.2425 |  | 0.2025 | 0.238 | 0.1925 | 0.238
2005-06-01 00:00:00 | 0.7403677302908289 | 3.438 | 0.2425 |  | 0.2025 | 0.238 | 0.1925 | 0.238
2005-07-01 00:00:00 | 0.73617248635959 | 3.461 | 0.2425 |  | 0.215 | 0.238 | 0.1925 | 0.238
2005-08-01 00:00:00 | 0.7318538959664687 | 3.478 | 0.2425 |  | 0.215 | 0.238 | 0.1925 | 0.238
2005-09-01 00:00:00 | 0.7275520744265401 | 3.495 | 0.2425 |  | 0.195 | 0.238 | 0.1925 | 0.238
2005-10-01 00:00:00 | 0.7234049902077422 | 3.52 | 0.2425 |  | 0.215 | 0.238 | 0.1975 | 0.238
2005-11-01 00:00:00 | 0.7191605114393214 | 3.665 | 0.2425 |  | 0.315 | 0.243 | 0.2725 | 0.243
2005-12-01 00:00:00 | 0.7151932113178053 | 3.81 | 0.245 |  | 0.395 | 0.245 | 0.3075 | 0.245
2006-01-01 00:00:00 | 0.7111133819622756 | 3.86 | 0.245 |  | 0.465 | 0.245 | 0.3125 | 0.245
2006-02-01 00:00:00 | 0.7070535145800062 | 3.75 | 0.2425 |  | 0.435 | 0.243 | 0.3125 | 0.243
2006-03-01 00:00:00 | 0.7034036321299226 | 3.615 | 0.235 |  | 0.39 | 0.235 | 0.27 | 0.235
2006-04-01 00:00:00 | 0.6993815471095887 | 3.48 | 0.235 |  | 0.25 | 0.23 | 0.205 | 0.23
2006-05-01 00:00:00 | 0.6955080043806445 | 3.44 | 0.2325 |  | 0.2025 | 0.228 | 0.1925 | 0.228
2006-06-01 00:00:00 | 0.6915246942467284 | 3.453 | 0.2325 |  | 0.2025 | 0.228 | 0.1925 | 0.228
2006-07-01 00:00:00 | 0.68768853423146 | 3.476 | 0.2325 |  | 0.215 | 0.228 | 0.1925 | 0.228
2006-08-01 00:00:00 | 0.6837437071181479 | 3.493 | 0.2325 |  | 0.215 | 0.228 | 0.1925 | 0.228
2006-09-01 00:00:00 | 0.6798183254796432 | 3.51 | 0.2325 |  | 0.195 | 0.228 | 0.1925 | 0.228
2006-10-01 00:00:00 | 0.6760380131756677 | 3.535 | 0.2325 |  | 0.215 | 0.228 | 0.1975 | 0.228
2006-11-01 00:00:00 | 0.6721506766245351 | 3.68 | 0.235 |  | 0.315 | 0.235 | 0.2725 | 0.235
2006-12-01 00:00:00 | 0.6684070422289408 | 3.825 | 0.245 |  | 0.395 | 0.245 | 0.3075 | 0.245
2007-01-01 00:00:00 | 0.6645574619046799 | 3.89 | 0.2475 |  | 0.465 | 0.248 | 0.3125 | 0.248
2007-02-01 00:00:00 | 0.660726958858875 | 3.78 | 0.235 |  | 0.435 | 0.235 | 0.3125 | 0.235
2007-03-01 00:00:00 | 0.6572834853200047 | 3.645 | 0.225 |  | 0.39 | 0.225 | 0.27 | 0.225
2007-04-01 00:00:00 | 0.6534890859742407 | 3.51 | 0.225 |  | 0.25 | 0.221 | 0.205 | 0.221
2007-05-01 00:00:00 | 0.6498350469799504 | 3.47 | 0.225 |  | 0.2025 | 0.221 | 0.1925 | 0.221
2007-06-01 00:00:00 | 0.646077694038965 | 3.483 | 0.215 |  | 0.2025 | 0.211 | 0.1925 | 0.211
2007-07-01 00:00:00 | 0.6424593685349833 | 3.506 | 0.215 |  | 0.215 | 0.211 | 0.1925 | 0.211
2007-08-01 00:00:00 | 0.638738777378955 | 3.523 | 0.215 |  | 0.215 | 0.211 | 0.1925 | 0.211
2007-09-01 00:00:00 | 0.6350367597622175 | 3.54 | 0.215 |  | 0.195 | 0.211 | 0.1925 | 0.211
2007-10-01 00:00:00 | 0.6314717777685924 | 3.565 | 0.205 |  | 0.215 | 0.201 | 0.1975 | 0.201
2007-11-01 00:00:00 | 0.6278098031857782 | 3.71 | 0.205 |  | 0.315 | 0.205 | 0.2725 | 0.205
2007-12-01 00:00:00 | 0.6243171755000142 | 3.855 | 0.205 |  | 0.395 | 0.205 | 0.3075 | 0.205
2008-01-01 00:00:00 | 0.6207265799528876 | 3.935 | 0.205 |  | 0.465 | 0.205 | 0.3125 | 0.205
2008-02-01 00:00:00 | 0.6171546560055853 | 3.825 | 0.205 |  | 0.435 | 0.205 | 0.3125 | 0.205
2008-03-01 00:00:00 | 0.613830007367839 | 3.69 | 0.205 |  | 0.39 | 0.205 | 0.27 | 0.205
2008-04-01 00:00:00 | 0.6102939820072499 | 3.555 | 0.205 |  | 0.25 | 0.201 | 0.205 | 0.201
2008-05-01 00:00:00 | 0.6068895651298054 | 3.515 | 0.205 |  | 0.2025 | 0.201 | 0.1925 | 0.201
2008-06-01 00:00:00 | 0.6033897141654091 | 3.528 | 0.205 |  | 0.2025 | 0.201 | 0.1925 | 0.201
2008-07-01 00:00:00 | 0.6000201482700676 | 3.551 | 0.185 |  | 0.215 | 0.181 | 0.1925 | 0.181
2008-08-01 00:00:00 | 0.596556148857998 | 3.568 | 0.185 |  | 0.215 | 0.181 | 0.1925 | 0.181
2008-09-01 00:00:00 | 0.5931102461087856 | 3.585 | 0.185 |  | 0.195 | 0.181 | 0.1925 | 0.181
2008-10-01 00:00:00 | 0.589792654261533 | 3.61 | 0.185 |  | 0.215 | 0.181 | 0.1975 | 0.181
2008-11-01 00:00:00 | 0.5863821205451258 | 3.755 | 0.185 |  | 0.315 | 0.185 | 0.2725 | 0.185
2008-12-01 00:00:00 | 0.5830986031103391 | 3.9 | 0.185 |  | 0.395 | 0.185 | 0.3075 | 0.185
2009-01-01 00:00:00 | 0.5797231213924705 | 3.99 | 0.185 |  | 0.465 | 0.185 | 0.3125 | 0.185
2009-02-01 00:00:00 | 0.5763653322248669 | 3.88 | 0.185 |  | 0.435 | 0.185 | 0.3125 | 0.185
2009-03-01 00:00:00 | 0.5733476301520675 | 3.745 | 0.175 |  | 0.39 | 0.175 | 0.27 | 0.175
2009-04-01 00:00:00 | 0.5700232904129658 | 3.61 | 0.175 |  | 0.25 | 0.172 | 0.205 | 0.172
2009-05-01 00:00:00 | 0.5668228108517681 | 3.57 | 0.175 |  | 0.2025 | 0.172 | 0.1925 | 0.172
2009-06-01 00:00:00 | 0.563532748183783 | 3.583 | 0.175 |  | 0.2025 | 0.172 | 0.1925 | 0.172
2009-07-01 00:00:00 | 0.5603652901447777 | 3.606 | 0.175 |  | 0.215 | 0.172 | 0.1925 | 0.172
2009-08-01 00:00:00 | 0.5571091954546266 | 3.623 | 0.175 |  | 0.215 | 0.172 | 0.1925 | 0.172
2009-09-01 00:00:00 | 0.5538702454504896 | 3.64 | 0.175 |  | 0.195 | 0.172 | 0.1925 | 0.172
2009-10-01 00:00:00 | 0.5507520273665201 | 3.665 | 0.175 |  | 0.215 | 0.172 | 0.1975 | 0.172
2009-11-01 00:00:00 | 0.5475465834405361 | 3.81 | 0.175 |  | 0.315 | 0.175 | 0.2725 | 0.175
2009-12-01 00:00:00 | 0.5444606434945604 | 3.955 | 0.175 |  | 0.395 | 0.175 | 0.3075 | 0.175
2010-01-01 00:00:00 | 0.5412884022053623 | 4.055 | 0.175 |  | 0.465 | 0.175 | 0.3125 | 0.175
2010-02-01 00:00:00 | 0.5381329188158471 | 3.945 | 0.175 |  | 0.435 | 0.175 | 0.3125 | 0.175
2010-03-01 00:00:00 | 0.5352971440902696 | 3.81 | 0.17 |  | 0.39 | 0.17 | 0.27 | 0.17
2010-04-01 00:00:00 | 0.5321733409020788 | 3.675 | 0.17 |  | 0.25 | 0.167 | 0.205 | 0.167
2010-05-01 00:00:00 | 0.5291660486377572 | 3.635 | 0.17 |  | 0.2025 | 0.167 | 0.1925 | 0.167
2010-06-01 00:00:00 | 0.5260747065352314 | 3.648 | 0.17 |  | 0.2025 | 0.167 | 0.1925 | 0.167
2010-07-01 00:00:00 | 0.5230986848663874 | 3.671 | 0.17 |  | 0.215 | 0.167 | 0.1925 | 0.167
2010-08-01 00:00:00 | 0.5200395081293325 | 3.688 | 0.17 |  | 0.215 | 0.167 | 0.1925 | 0.167
2010-09-01 00:00:00 | 0.5169965651012254 | 3.705 | 0.17 |  | 0.195 | 0.167 | 0.1925 | 0.167
2010-10-01 00:00:00 | 0.5140671670459708 | 3.73 | 0.17 |  | 0.215 | 0.167 | 0.1975 | 0.167
2010-11-01 00:00:00 | 0.5110636004697127 | 3.875 | 0.17 |  | 0.315 | 0.17 | 0.2725 | 0.17
2010-12-01 00:00:00 | 0.5082108144457602 | 4.02 | 0.17 |  | 0.395 | 0.17 | 0.3075 | 0.17
2011-01-01 00:00:00 | 0.5052788522412368 | 4.13 | 0.17 |  | 0.465 | 0.17 | 0.3125 | 0.17
2011-02-01 00:00:00 | 0.5023629847735583 | 4.02 | 0.17 |  | 0.435 | 0.17 | 0.3125 | 0.17
2011-03-01 00:00:00 | 0.4997430624360703 | 3.885 | 0.16 |  | 0.39 | 0.16 | 0.27 | 0.16
2011-04-01 00:00:00 | 0.4968575968676567 | 3.75 | 0.16 |  | 0.25 | 0.157 | 0.205 | 0.157
2011-05-01 00:00:00 | 0.4940803065877567 | 3.71 | 0.16 |  | 0.2025 | 0.157 | 0.1925 | 0.157
2011-06-01 00:00:00 | 0.4912259588866803 | 3.723 | 0.16 |  | 0.2025 | 0.157 | 0.1925 | 0.157
2011-07-01 00:00:00 | 0.4884786289924665 | 3.746 | 0.16 |  | 0.215 | 0.157 | 0.1925 | 0.157
2011-08-01 00:00:00 | 0.4856550823146688 | 3.763 | 0.16 |  | 0.215 | 0.157 | 0.1925 | 0.157
2011-09-01 00:00:00 | 0.482847068157494 | 3.78 | 0.16 |  | 0.195 | 0.157 | 0.1925 | 0.157
2011-10-01 00:00:00 | 0.4801443481556198 | 3.805 | 0.16 |  | 0.215 | 0.157 | 0.1975 | 0.157
2011-11-01 00:00:00 | 0.4773666628454568 | 3.95 | 0.16 |  | 0.315 | 0.16 | 0.2725 | 0.16
2011-12-01 00:00:00 | 0.4746931432996333 | 4.095 | 0.16 |  | 0.395 | 0.16 | 0.3075 | 0.16
2012-01-01 00:00:00 | 0.4719454774953062 | 4.215 | 0.16 |  | 0.465 | 0.16 | 0.3125 | 0.16
2012-02-01 00:00:00 | 0.4692129499013429 | 4.105 | 0.16 |  | 0.435 | 0.16 | 0.3125 | 0.16
2012-03-01 00:00:00 | 0.4666703493755545 | 3.97 | 0.155 |  | 0.39 | 0.155 | 0.27 | 0.155
2012-04-01 00:00:00 | 0.4639668981801735 | 3.835 | 0.155 |  | 0.25 | 0.152 | 0.205 | 0.152
2012-05-01 00:00:00 | 0.4613648504149612 | 3.795 | 0.155 |  | 0.2025 | 0.152 | 0.1925 | 0.152
2012-06-01 00:00:00 | 0.4586906606674271 | 3.808 | 0.155 |  | 0.2025 | 0.152 | 0.1925 | 0.152
2012-07-01 00:00:00 | 0.4561167853251687 | 3.831 | 0.155 |  | 0.215 | 0.152 | 0.1925 | 0.152
2012-08-01 00:00:00 | 0.4534715578584662 | 3.848 | 0.155 |  | 0.215 | 0.152 | 0.1925 | 0.152
2012-09-01 00:00:00 | 0.4508409351943474 | 3.865 | 0.155 |  | 0.195 | 0.152 | 0.1925 | 0.152
2012-10-01 00:00:00 | 0.4483090053118118 | 3.89 | 0.155 |  | 0.215 | 0.152 | 0.1975 | 0.152
2012-11-01 00:00:00 | 0.4457068991209651 | 4.035 | 0.155 |  | 0.315 | 0.155 | 0.2725 | 0.155
2012-12-01 00:00:00 | 0.4432024241699725 | 4.18 | 0.155 |  | 0.395 | 0.155 | 0.3075 | 0.155