a.
INPUTS OUTPUTS FORMULA FOR OUTPUT IN COLUMN E
Standard deviation (annual) 0.4000 PV(Ex. Price) 48.077 B6/(1+B4)^B3
Maturity (in years) 1.000 d1 0.298 (LN(B5/E2)+(0.5*B2^2)*B3)/(B2*SQRT(B3))
Risk-free rate (effective annual
rate) 0.04 d2 -0.102 E3-B2*SQRT(B3)
b. and c.
INPUTS OUTPUTS FORMULA FOR OUTPUT IN COLUMN E
Standard deviation (annual) 0.4000 PV(Ex. Price) 46.228 B6/(1+B4)^B3
Maturity (in years) 2.000 d1 0.422 (LN(B5/E2)+(0.5*B2^2)*B3)/(B2*SQRT(B3))
Risk-free rate (effective annual
The value of the call rises with an increase in the time to expiration.
INPUTS OUTPUTS FORMULA FOR OUTPUT IN COLUMN E
Standard deviation (annual) 0.5000 PV(Ex. Price) 48.077 B6/(1+B4)^B3
Maturity (in years) 1.000 d1 0.328 (LN(B5/E2)+(0.5*B2^2)*B3)/(B2*SQRT(B3))
Risk-free rate (effective annual
The value of the call rises with an increase in volatility (standard deviation).
INPUTS OUTPUTS FORMULA FOR OUTPUT IN COLUMN E
Standard deviation (annual) 0.4000 PV(Ex. Price) 57.692 B6/(1+B4)^B3
Maturity (in years) 1.000 d1 -0.158 (LN(B5/E2)+(0.5*B2^2)*B3)/(B2*SQRT(B3))
Risk-free rate (effective annual
The value of the call falls with an increase in the exercise price.
23-8
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of
McGraw-Hill Education.