Question
Please, use Excel for all your computations. Assume that on April 9 the ABC stock price was $20.69. Assume that the option on ABC stock
Please, use Excel for all your computations.
Assume that on April 9 the ABC stock price was $20.69. Assume that the option on ABC stock expires in 1 month and the risk-free rate is 2.7% p.a.
a) Compute European call price with strike X=19 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 April 9 is $2.12. Back out the implied volatility from the Black and Scholes formula.
c) Compute European put price with strike X=19 using Black Scholes closed form solution. For the estimate of volatility use implied volatility from part b.
d) Approximate prices of European put option with X=19 and European call option with X=19 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=19 and American call option with X=19 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.
Excel file
Day | Close |
1 | 20.69 |
2 | 21.24 |
3 | 22.08 |
4 | 21.42 |
5 | 21.08 |
6 | 21.75 |
7 | 21.87 |
8 | 21.93 |
9 | 21.85 |
10 | 21.97 |
11 | 21.18 |
12 | 20.79 |
13 | 21.09 |
14 | 21.86 |
15 | 22.27 |
16 | 22.13 |
17 | 21.75 |
18 | 21.09 |
19 | 21.75 |
20 | 20.85 |
21 | 20.66 |
22 | 21.28 |
23 | 21.12 |
24 | 21.2 |
25 | 20.12 |
26 | 20.07 |
27 | 19.87 |
28 | 20.2 |
29 | 20 |
30 | 20.01 |
31 | 19.97 |
32 | 20.49 |
33 | 20.77 |
34 | 20.69 |
35 | 19.94 |
36 | 19.82 |
37 | 20.3 |
38 | 20.38 |
39 | 20.16 |
40 | 20.11 |
41 | 20.46 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started