Saturday, June 21, 2008

Hedging the gas price - the cost of insurance

I was wondering lately what it would cost to hedge my fuel costs by buying options on oil futures. Chrysler offered something similar with its $2.99 per gallon deal a few weeks ago - I already estimated that cost in a previous post. So I set out this afternoon and did some research, i.e. collecting data from the Energy Information Administration, doing some (dull) regressions, and analyzing option prices. The result is a neat little table (see below) that contains rough estimates for the insurance costs depending on maturity (of the underlying future) and level of protection above which the "insurance" kicks in.

The insurance itself works as follows: You buy call options on oil futures (see below) and when the gas price rises above our protection level the value of the options we bought will have increased and will offset the additional fuel cost (by selling them). Note, that I do not consider transaction costs here which might be significant (especially if you only sell a small volume). Neither, did I consider discounting of the future contracts or convenience yield effects as their impact here is limited although they are important for longer maturities in general.

So how do we come up with some reasonable numbers for costs? The idea is pretty straightforward:

a) Relate gas prices to oil prices: Since a barrel of oil contains 42 gallons the relation should be straightforward from the theoretical point of view. Doing a regression, depending on the grade and the region in the US we obtain that approximately

gas-price-per-gallon (y) = 1.45 + 0.024 oil-price (x)

I actually adjusted the coefficients a bit to reflect the fact that "1/42 * price-per-barrel" is a lower bound for the price of a gallon.

b) Assume that an option is $1 in-the-money. According to the above formula the gas price p.g. increased by $0.024. Therefore we need 0.024 options to offset that increase by selling off the option.

Combining that with latest quotes for call options on oil futures we can calculate:

1) The expected gas price given the underlying oil price. That is the information in the top rows and is the strike price for the option and our protection level.

2) We can calculate the hedging cost for a gallon depending on the maturity of the underlying future contract. Implicitly that determines the expiration of the option as well as it usually expires a few weeks earlier.

The two tables below contain the absolute and the relative (to the protection level) hedging costs.



For example insuring with a protection level of $4.66 a gallon would cost us $0.22 or 4.62% extra (per gallon) if we want this protection for buying fuel until 08/2009. If we want to buy protection for a later point in time, say until 02/2009 we would pay $0.42 or 9.05% premium.

In order to use this strategy more efficiently for hedging exposure we could buy a mix of options to reflect the fact that if we want to fill up the car next week we do not need options with expiration in 05/2009 which are almost twice as expensive as the ones that expire in 08/2009 as we pay a higher time value.

Or we could just drive less... ;-)

2 Comments:

Anonymous said...

Price of oil is $136 - price of gas $3.92 in Texas - according to the following site anyway...(http://www.torontogasprices.com/retail_price_chart.aspx).

Your model suggests that at $130/barrell price of gas is $4.66

--- said...

Yes indeed. It seems to be (partly!) due to the data from the Energy Information Administration. For example on June 16th, 2008 the reported avg. prices (depending on grade and reformulation are) are somewhere between 400.7 and 444.8. though the oil price was below 130. And on 'gasbuddy':

http://www.gasbuddy.com/gb_gastemperaturemap.aspx

you will find prices of up to $5.00 in California for example. If you do not adjust the coefficients of the regression you get 1.48 + 0.019 * gas-price(x) which seems to be a better fit for the current prices but has a coefficient of less than 0.024 for the gas-price which - at a certain points - leads to negative premiums for the gas stations. The reason why the coefficient can be less than 0.024 could be that there is still enough old oil around so that we see a certain delay or the gas stations might be reluctant to following the gas prices immediately. Also, the gas price compared to the oil price 'seems' to be behaving like a moving average with a longer period (due to storage, mix calculation, etc.?) which would also explain this crossover and likely will catch up in the future.

You can actually see that effect on the website I cited above. They allow a comparison between oil and gas prices showing that since march the gas prices did not completely catch up with the oil prices (yet?)...

I therefore chose more conservative coefficients making the 'insurance' a bit more expensive.