Exchange Options – Introduction and Pricing Spreadsheet

This article introduces European Exchange Options, developed by Margrabe in 1978,  and offers a free a pricing spreadsheet.

They are a generalization of the Black-Scholes model and give the holder the right to exchange one asset for another. An exchange options can be considered a variant of a rainbow option with a zero strike.

Consider two assets with prices S1(t) and S2(t). A European-style option which gives the holder the to exchange asset 2 for asset 1 has a payoff of max(0,S1(T) – S2(T)), where T is the time to maturity

The option can exercised at maturity (European-style), or at any time at or before maturity (American-style). Margrabe (1978) asserted that European and American exchange options are equal in value. However, Bjerksund & Stensland (1993) proved that American exchange options are more valuable than their European counterparts.

Pricing Exchange Options in Excel

Exchange options require the volatility, price and dividend yield for both assets, together with their correlation coefficient.

European Exchange Option Excel

Margrabe (1978) gives the following analytical equations for pricing exchange options.

European Exchange Option Equations

Download Excel Spreadsheet to Price European Exchange Options

One thought on “Exchange Options – Introduction and Pricing Spreadsheet

  1. Very useful spreadsheet – thanks.
    There just seems to be a typo, in the above formula for d1: rho^2 should be replaced by sigma^2.

Leave a Reply

Your email address will not be published. Required fields are marked *

What is 5 + 9 ?
Please leave these two fields as-is:
IMPORTANT! To be able to proceed, you need to solve the following simple math (so we know that you are a human) :-)