Browse By

Options pricing–Exotics Options–Pricing a Capped Call–Excel implementation – Binomial trees

Pricing Capped Calls with Automatic Exercise

A capped call with automatic exercise is an option where the payoff is capped at a given level L. The auto exercise feature further means that whenever the option’s intrinsic value touches or exceeds L, the option will automatically be exercised and the holder will be paid L. The following adjustments will be made in the basic option pricing procedure:

Step 2: The terminal payoff will be min{L, max[(ST-K),0]}.

Step 3: The following condition will be added to the formula at non-terminal nodes. If the underlying asset’s price at the node, S, is greater than or equal to K+L then the option will be exercised immediately and the option value at that node, C, will be equal to L. If S is less than K+L then the option will not be exercised and the option value at that node, C, will be the expected present value of the values at the successive nodes as given by formula (2). For time step, n=2 this is given below:

ColumnABC
RowSTCTT-1?t
1=u2S0min[L, max{(A1-K),0}]=if[A1>=K+L, L, exp(-r?t)*{p*B1+(1-p)*B2}]
2=A1*dmin[L, max{(A2-K),0}]= if[A2>=K+L, L, exp(-r?t)*{p*B1+(1-p)*B3}]
3=A2*dmin[L, max{(A3-K) ,0}]= if[A3>=K+L, L, exp(-r?t)*{p*B2+(1-p)*B4}]
4=A3*dmin[L, max{(A4-K) ,0}]= if[A4>=K+L, L, exp(-r?t)*{p*B3+(1-p)*B5}]
5=A4*dmin[L, max{(A5-K),0}]= if[A5>=K+L, L, exp(-r?t)*{p*B4+(1-p)*B5}]

Figure 90: Formulas for spreadsheet implementation of binomial tree for capped calls with automatic exercise

The adjusted formulas in this column will then be copied to D and later columns depending on the number of steps employed.

For the following parameters the numerical example is given below:

n4T0.1x0.9988L5u1.0486
r0.05?t0.025K45S047
?0.3d0.9537p0.5013q0.4987
ColumnABCDEF
RowSTCTT-1?tT-2?tT-3?tT-4?t
156.8205.0005.0005.0005.0005.000
254.1875.0005.0005.0005.0005.000
351.6775.0005.0005.0005.0005.000
449.2834.2833.5003.5723.6253.661
547.0002.0002.1452.2512.3232.501
644.8231.0011.0741.3771.431
742.7460.5010.5380.814
840.7660.2510.269
938.8770.126

Figure 91: Spreadsheet for capped calls with automatic exercise example

The price of the option is 2.501.

One thought on “Options pricing–Exotics Options–Pricing a Capped Call–Excel implementation – Binomial trees”

  1. Pingback: Options Pricing Training Binomial Trees | Learning Corporate Finance
  2. Trackback: Options Pricing Training Binomial Trees | Learning Corporate Finance

Comments are closed.

Comodo SSL