IN EXCEL ONLY - Be sure to show each input and result in a separate cell. 1. Assume that you have been given the following information on Purcell Industries: Current stock price = $15 Strike price of option = $15 Time to maturity of option = 6 months Risk-free rate = 6% Variance of stock return = 0.12 d1 = 0.24495 N(d1) = 0.59675 d2 = 0.00000 N(d2) = 0.50000 2. The current price of a stock is $20. In 1 year, the price will be either $26 or $16. The annual risk-free rate is 5%. Find the price of a call option on the stock that has a strike price of $21 and that expires in 1 year. (Hint: Use daily compounding.)