Please, use Excel for all your computations.\ Assume that on November 27 the ABC stock price was

$20.5

. Assume that the option on

ABC

stock expires in 2 months and the risk-free rate is

2%

p.a.\ a) Compute European call price with strike

x=20

using Black Scholes closed form solution. To compute the call price you will need the estimate of volatility. Calculate historical volatility based on two months of data. Data is provided in HW5_data.xls file.\ b) Assume that the price of the call option on November 27 is

$1.69

. Back out the implied volatility from the Black and Scholes formula.\ c) Compute European put price with strike

x=20

using Black Scholes closed form solution. For the estimate of volatility use implied volatility from part

b

.\ d) Approximate prices of the European put option with

x=20

and European call option with

x=20

using 5-step binomial trees. For the estimate of volatility use implied volatility from part b. Please, provide your

u,d,p

, stock tree, and option trees.\ e) Approximate prices of American put option with

x=20

and American call option with

x=20

using 5-step binomial trees. For the estimate of volatility use implied volatility from part

b

. Please, provide your

u,d,p

, stock tree, and option trees.

Please, use Excel for all your computations. Assume that on November 27 the ABC stock price was $20.5. Assume that the option on ABC stock expires in 2 months and the risk-free rate is 2% p.a. a) Compute European call price with strike X=20 using Black Scholes closed form solution. To compute the call price you will need the estimate of volatility. Calculate historical volatility based on two months of data. Data is provided in HW5_data.xls file. b) Assume that the price of the call option on November 27 is $1.69. Back out the implied volatility from the Black and Scholes formula. c) Compute European put price with strike X=20 using Black Scholes closed form solution. For the estimate of volatility use implied volatility from part b. d) Approximate prices of the European put option with X=20 and European call option with X=20 using 5-step binomial trees. For the estimate of volatility use implied volatility from part b. Please, provide your u,d,p, stock tree, and option trees. e) Approximate prices of American put option with X=20 and American call option with X=20 using 5-step binomial trees. For the estimate of volatility use implied volatility from part b. Please, provide your u, d, p, stock tree, and option trees