In: Finance
Use a 2-step binomial tree to price an american style put option when the current stock price is $50 and the stock price will move up or down by 20 percent at each time(that is, the ending stock price are $72,$48, and $32). The strike price on the option is $52 and the risk-free interest rate is 5 percent per step. Please report your answer to two decimal places.
Using excel to derive call option
| Call option | ||||||||||||||
| Stock Value | 50 | |||||||||||||
| Excerise Value(X) | 52 | |||||||||||||
| Risk free Rate | 5% | |||||||||||||
| Up Factor | 1.2 | |||||||||||||
| Down factor | 0.8 | |||||||||||||
| Probability of Up | 0.625 | (Formula = (1+Risk free rate- Down Factor)/(Up factor - Down Factor) | ||||||||||||
| Probability of Down | 0.375 | Formula = (1-Probability of up) | ||||||||||||
| S2+ | 72.00 | Formula = S1+*Up Factor | ||||||||||||
| C2+ | 20.00 | (Max Value of (0,S2-X) | ||||||||||||
| S1+ | 60.00 | Formula = Stock Value*Up Factor | ||||||||||||
| C1+ | 11.90 | (Formula= (C2+*Probability of Up + C2+*Probability of Down fact)/(1+5%) | ||||||||||||
| S2- | 48.00 | Formula = S1+* Downfactor Factor | ||||||||||||
| Stock Value(S0) | 50 | C2- | 0.00 | (Max Value of (0,S2-X) | ||||||||||
| S1- | 40.00 | Formula = Stock Value*Down Factor | ||||||||||||
| C1- | 0 | |||||||||||||
| S2- | 32.00 | Formula = S1+*Up Factor | ||||||||||||
| C2- | 0.00 | (Max Value of (0,S2-X) | ||||||||||||
| Call option in Year 0 | 7.09 | (Formula = Probability of Up*C1 + Probability of Down * C1-)/1.05 | ||||||||||||
Call Option price = 7.09