complete in excel and show how you derive each answer.

dow Help Document Desa e (8-2) Options The exercise price on one of Flanagan Company's call options is $15, its exercise value is $22, and its time value is $5. What are the option's market value and the price of the stock? (8-3) Black-Scholes Model INTERMEDIATE PROBLEMS 3-4 Assume that you have been given the following information on Purcell Corporation's call options: Strike price of option = $15 Risk-free rate = 6% Current stock price = $15 Time to maturity of option = 6 months Variance of stock return = 0.12 d = 0.24495 d, = 0.00000 N(d) =0.59675 N(d) = 0.50000 (8-4) Put-Call Parity According to the Black-Scholes option pricing model, what is the option's value? The current price of a stock is $33, and the annual risk-free rate is 6%. A call option with a strike price of $32 and with 1 year until expiration has a current value of $6.56. What is the value of a put option written on the stock with the same exercise price and expiration date as the call option? CHALLENGING PROBLEMS 5-7