454 Chapter 17
An explanation for the preceding spreadsheet follows. For each termi-
nal option payoff, we consider these questions:
How was this terminal
payoff reached? How many
“up” steps did the stock
make, and how many
“down” steps did it make?
Example: The terminal payoff of 14.5535
arises when the stock price is 64.5535.
This result occurs when the stock price
goes up three times and down once.
What is the price per dollar
of the payoff in the
particular state?
State price =
q
U
#up
steps
q
D
#down steps
Example: The value at time 0 of the
terminal payoff considered in the same
example is 0.6531
3
*
0.2903
1
= 0.0809
How many paths are there
with the same terminal
payoff?
The answer is given by the
binomial coeffi cient
Number of periods
Number of up steps“”
⎛
⎝
⎜
⎞
⎠
⎟
Example: There are
4
3
4
⎛
⎝
⎜
⎞
⎠
⎟
=
paths which
give the terminal stock price of 64.5535.
The Excel function Combin(4,3) gives
this binomial coeffi cient.
What is the value at time 0
of a particular terminal
payoff?
The answer is the product
of the payoff times the
price times the number of
paths.
Example: 14.5535
*
0.0809
*
4 = 4.7078
What is the value at time 0
of the option?
The sum of the values of
each payoff.
Total value: 10.4360. This is the
multiperiod call option value in the fi ve-
date (four-period) binomial model.
European puts can be priced either by using the preceding logic or—as
in cell G16—by using put-call parity.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
ABCDEFGH
Up, U 1.10
Down, D 0.97
State prices
Interest rate, R 1.06
q
U
0.6531 <-- =(B4-B3)/(B4*(B2-B3))
Initial stock price, S 50.00
q
D
0.2903 <-- =(B2-B4)/(B4*(B2-B3))
Option exercise price, X 50.00
Number of "up" steps
at terminal date
Number of
"down" steps
at terminal date
Terminal stock
price
= S*U^(# up)
*D^(# down)
Option payoff
at terminal
state
State price for
terminal date
= q
U
^(# up)
*q
D
^(# down)
Number of
paths to
terminal state
Value
=payoff*state
price*#paths
4 0 73.2050 23.2050 0.1820 1 4.2224
3 1 64.5535 14.5535 0.0809 4 4.7078
2 2 56.9245 6.9245 0.0359 6 1.4933
1 3 50.1970 0.1970 0.0160 4 0.0126
0 4 44.2646 0.0000 0.0071 1 0.0000
Call price 10.4360 <-- =SUM(G10:G14)
Put price 0.0407 <-- =G15+B6/B4^4-B5
Notes
There are 5 dates in this model (0, 1, ... , 5) but only 4 periods and thus only 4 possible "up" or "down" steps.
The put price in cell G16 is computed using put-call parity: put = call + PV(X) - stock
BINOMIAL OPTION PRICING WITH STATE PRICES
IN A FOUR-PERIOD (FIVE-DATE) MODEL