Calculating Differentials

The data, opinions, interpretations, and guidance provided herein are for general information purposes only. NSAI accepts no responsibility for the accuracy of any such information or for any reliance made on it. The precision of estimated differentials depends on a number of factors, including the data available, the experience and judgment of the evaluators, and the methodology used.

Terminology

Benchmark or Index Price – Reference price of oil or gas, chosen because it is both familiar in the industry and relevant to the properties being evaluated.

Spot Price – “The price for a one-time open market transaction for immediate delivery of a specific quantity of product at a specific location where the commodity is purchased ‘on the spot’ at current market rates.” [EIA]

Posted Price – An established price for which a buyer is willing to purchase oil or gas for a period of time, usually at a major oil or gas pipeline interconnect location or at a refinery.

Futures Price – A price established on a futures exchange based on trading of contracts to buy/sell oil or gas for delivery at a future date; generally refers to the “near-month” futures price.  The “Futures Strip Price” is the price of futures in sequential delivery months, e.g., a 12-month strip price is the average futures price over the next 12 months.

Field Price or Realized Price – The price actually received for oil or gas sold from a given lease or field (sometimes referred to as the “wellhead price”).

Price Differential – The difference in price between an established benchmark and what is actually received at the lease or field (inclusive of adjustments for quality, energy content, transportation fees, and regional/local differentials).

Common Industry Benchmarks

TermOilGas
FuturesNYMEX Light Sweet Crude

IPE (London) Brent Crude

(generally near-month, or front-month, trading)
NYMEX Henry Hub Natural Gas
IPE (London) Natural Gas

(generally near-month trading)
SpotSpot trading as documented by Platts Oilgram or Oil Daily is typically not for outright sales but for trading for near-month delivery so it is not the same as posting data.

Some daily spot trading is identified as same/next day trading, but prices are much higher than equivalent day posted prices.
Numerous pipeline companies in many different gas-producing or pipeline interconnect locations, reported in Platts Gas Daily
• Daily Spot Prices
• Monthly Index Prices
e.g., Houston Ship Channel, Dominion South Point
PostingsNumerous refining companies in many different oil-producing locations
e.g., Plains Marketing WTI Posting (West Texas delivery)
Most people consider the Gas Daily daily spot prices to be equivalent to oil postings.

Calculating Differentials Compliant with SEC Regulations

It is our understanding that the SEC’s intent is for the prices used in an evaluation to be the prices the Company could have received if it marketed/sold its gas/oil on the first day of each month within the 12-month period prior to the end of the reporting period.

Data Used

  • Gas/oil sales and transportation contracts (or summaries of contract terms) that cover the 12-month period.
  • Monthly lease operating statements (LOS) showing prices and revenue, by production month, for the 12-month period.
  • The previous 12 months of monthly index prices. The monthly index prices are different than the first-day-of-the-month SEC prices.
  • The 12-month unweighted average of first-day-of-the-month prices for the appropriate regional index.

Shown below is an example of both monthly index prices and first-day-of-the-month prices for the most commonly used indices.

Monthly Index Prices and First-Day-of-the-Month Prices
Oil Prices ($/Barrel) - WTI PostingOil Prices ($/Barrel) - WTI SpotGas Prices ($/MMBTU) - Henry Hub
Monthly1st-Day-of-MonthMonthly1st-Day-of-MonthMonthly1st-Day-of-MonthSEC Reference
Mo-YrIndex PricePosting DatePrice12-month AverageIndex PriceTransaction DatePrice12-month AverageIndex PriceFlow DatePrice12-month AveragePrice as of:
Oct-2177.6210-01-202172.3657.2681.4810-01-202176.0160.775.85010-01-20215.5453.269
Nov-2174.5710-31-202180.5361.2979.1510-31-202184.0864.816.22011-01-20215.3553.462
Dec-2167.9712-01-202162.0563.0471.7112-01-202165.4466.555.46012-01-20214.5053.59812-31-2021
Jan-2179.1612-31-202171.6965.2783.2212-31-202175.3368.804.01001-01-20223.7003.708
Feb-2288.2001-30-202284.6868.1591.6401-30-202288.2271.696.31002-01-20225.5753.950
Mar-22105.4202-27-202299.8971.72108.5002-27-2022103.6675.284.56003-01-20224.2804.08603-31-2022
Apr-2298.4004-01-202295.7574.87101.7804-01-202299.3278.445.32004-01-20225.4804.335
May-22106.5205-01-2022101.1778.29109.5505-01-2022104.5981.867.27005-01-20226.8454.666
June-22110.6206-01-2022111.7482.26114.6306-01-2022115.2685.828.91006-01-20228.4555.13306-30-2022
July-2296.6207-01-2022104.9185.02101.6207-01-2022110.3088.736.56007-01-20226.4605.362
Aug-2287.9007-31-202290.3786.6893.6707-31-202296.5990.628.71008-01-20228.3655.735
Sept-2280.5409-01-202283.0988.1984.2609-01-202287.0992.169.34009-01-20228.9506.12609-30-2022
Oct-2283.2210-01-202275.9788.4987.5610-01-202279.9192.486.88010-01-20226.2906.188
Nov-2280.6810-30-202284.8588.8584.3710-30-202288.3692.845.20011-01-20225.0806.165
Dec-2273.1412-01-202277.7090.1576.4412-01-202281.0694.146.71012-01-20226.8006.35712-31-2022

 

Methodology

It is the SEC’s intent, although it is difficult in practice, for the prices used in an evaluation to be the prices the Company could have received at the well or field if it marketed/sold its gas/oil on the first day of each month. Said another way, what happens in February or later should not affect the well- or field-level SEC price for January 1st. In practice, there are a few different methods to determine this price, including but not limited to:

  1. Obtain gas/oil sales and transportation contracts that cover the 12-month period prior to the end of the reporting period and use the differentials set out in those contracts with the appropriate regional hub spot/posted price index.
    • Recognize it is not always possible, or practical, to get contracts for every property.
    • Assumes that month-to-month contract terms are representative of the “price the Company could receive”.
    • Note that often times not all of the contractual arrangements that affect the net price received are well known or documented (which is why it is best practice to validate contract data with actual LOS).
  2. Use the monthly index prices and the monthly LOS to determine the average differential to the indices and then apply that average differential to the 12-month average SEC index price (average of first-day-of-the-month prices).
    • Assumes that the 12 months of the monthly differential is a close approximation of the differential in effect on the first day of each of the 12 months.
    • Used to verify contracts/contract terms or as a proxy or in lieu of obtaining month-to-month gas/oil sales contracts.
    • Recognize that LOS data over the same period as the SEC pricing indices may not be available, so you may be limited to using the average for the first 9 or 10 months rather than the 12-month average. The evaluator should use good judgment to determine the appropriate differential, reflecting his/her estimate for the missing months.

Example

Calculating Differentials Example

Cautionary Notes

  1. Be careful to use the appropriate index prices when determining differentials for your price case.
    • The above example uses WTI posted oil prices. If using a WTI NYMEX or spot price forecast for a non-SEC report, be sure to factor in the difference between NYMEX and posted prices. For example, if you use the Bloomberg spot oil price with differentials determined from comparing historical received oil prices to posted oil prices, you will calculate a price that is too high. For 2015, the NYMEX vs. posted delta is $3.45 ($48.80 – $45.35).
    • Note that the difference between first-day-of-the-month prices and monthly index prices can make a difference in the differential calculation. For instance, for 2015 the average Plains WTI Posting oil price was $45.35, whereas the first-day-of-the-month average price for 2015 was $46.79, which if used incorrectly could lead to using a SEC wellhead/lease price that is $1.44 too high.
  2. Gas is typically sold on a $/MMBTU basis, so the example above assumes the BTU factor is known and is factored in before the differential is calculated. In some cases, where the BTU factor is not known, gas differentials are expressed as a % (or multiplier) of the index price rather than a $/MCF difference.
  3. The example shows differential calculations for the 12 prior months where LOS data are available at the time the estimates are made; some estimators limit the differentials to just the current calendar year and some estimators use the current year plus estimate the differentials for the missing months. For SEC reports, the estimators use their judgment to determine which differential best represents the full 12 months prior to the as-of date. For non-SEC reports, the estimators use their judgment to determine which differential best represents the expected future differential.