Question 4 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 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%.