Chapter 16 – Option Valuation
INPUTS OUTPUTS FORMULA FOR OUTPUT IN COLUMN E
Standard deviation (annual) 0.3213 d1 0.0089 (LN(B5/B6)+(B4-B7+.5*B2^2)*B3)/(B2*SQRT(B3))
Maturity (in years) 0.5 d2 –0.2183 E2-B2*SQRT(B3)
Risk–free rate (annual) 0.05 N(d1) 0.5036 NORMSDIST(E2)
Stock Price 100 N(d2) 0.4136 NORMSDIST(E3)
Exercise price 105 B/S call value 8.0000 B5*EXP(-B7*B3)*E4 – B6*EXP(-B4*B3)*E5
Dividend yield (annual) 0 B/S put value 10.4075 B6*EXP(-B4*B3)*(1-E5) – B5*EXP(–B7*B3)*(1-E4)
The implied standard deviation is .3213.
b. The spreadsheet below shows the standard deviation has increased to: .3568
INPUTS OUTPUTS FORMULA FOR OUTPUT IN COLUMN E
Standard deviation (annual) 0.3568 d1 0.0318 (LN(B5/B6)+(B4-B7+.5*B2^2)*B3)/(B2*SQRT(B3))
Maturity (in years) 0.5 d2 –0.2204 E2-B2*SQRT(B3)
Risk–free rate (annual) 0.05 N(d1) 0.5127 NORMSDIST(E2)
Stock Price 100 N(d2) 0.4128 NORMSDIST(E3)
Exercise price 105 B/S call value 9.0000 B5*EXP(-B7*B3)*E4 – B6*EXP(-B4*B3)*E5
Dividend yield (annual) 0 B/S put value 11.4075 B6*EXP(-B4*B3)*(1–E5) – B5*EXP(-B7*B3)*(1–E4)
Implied volatility has increased because the value of an option increases with greater volatility.
c. Implied volatility increases to .4087 when maturity decreases to four months.
The shorter maturity decreases the value of the option; therefore, in order for the
option price to remain unchanged at $8, implied volatility must increase.
INPUTS OUTPUTS FORMULA FOR OUTPUT IN COLUMN E
Standard deviation (annual) 0.4087 d1 –0.0182 (LN(B5/B6)+(B4-B7+.5*B2^2)*B3)/(B2*SQRT(B3))
Maturity (in years) 0.3333 d2 -0.2541 E2–B2*SQRT(B3)
Risk–free rate (annual) 0.05 N(d1) 0.4927 NORMSDIST(E2)
Stock Price 100 N(d2) 0.3997 NORMSDIST(E3)
Exercise price 105 B/S call value 8.0000 B5*EXP(–B7*B3)*E4 – B6*EXP(-B4*B3)*E5
Dividend yield (annual) 0 B/S put value 11.2645 B6*EXP(–B4*B3)*(1–E5) – B5*EXP(–B7*B3)*(1–E4)
d. Implied volatility decreases to .2406 when exercise price decreases to $100.
The decrease in exercise price increases the value of the call, so that in order for
the option price to remain at $8, implied volatility decreases.
INPUTS OUTPUTS FORMULA FOR OUTPUT IN COLUMN E
Standard deviation (annual) 0.2406 d1 0.2320 (LN(B5/B6)+(B4-B7+.5*B2^2)*B3)/(B2*SQRT(B3))
Maturity (in years) 0.5 d2 0.0619 E2-B2*SQRT(B3)
Risk–free rate (annual) 0.05 N(d1) 0.5917 NORMSDIST(E2)
Stock Price 100 N(d2) 0.5247 NORMSDIST(E3)
Exercise price 100 B/S call value 8.0010 B5*EXP(–B7*B3)*E4 – B6*EXP(–B4*B3)*E5
Dividend yield (annual) 0 B/S put value 5.5320 B6*EXP(–B4*B3)*(1–E5) – B5*EXP(–B7*B3)*(1–E4)