Question: Question 2 Design an Excel spreadsheet to compute the price of a European call option with strike price K to be exercised at time step
Question 2 Design an Excel spreadsheet to compute the price of a European call option with strike price K to be exercised at time step T = 10 in a binomial model with initial stock price S(0) and parameters U, D, R. The spreadsheet should allow the end user to enter all these parameters as input data, and to perform the following computations: (a) To compute the option price at time 0 by the CRR (Cox-RossRubinstein) formula; (b) To compute the option prices at all nodes of the binomial tree by backward recursion starting with the payoff at time step T = 10. The formulae and algorithms used in the spreadsheet should be explained in the lyx file. Present the Excel spreadsheet with input data S(0) = 100, K = 100, U = 20%, D = 10% and R = 10%.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
