Except for charts and answers that must be written only Excelformulas that use c

Except for charts and answers that must be written only Excelformulas that use cell references or functions will be accepted forcredit. Numeric answers in cells will not be accepted. You havebeen given the following information on a call option on the stockof Puckett Industries: P = $65 X = $70 t = 0.5 rRF = 4% s = 50.00%a. Using the Black-Scholes Option Pricing Model what is the valueof the call option? First we will use formulas from the text tosolve for d1 and d2. Hint: use the NORMSDIST function. (d1) = N(d1)= (d2) = N(d2) = Using the formula for option value and the valuesof N(d) from above we can find the call option value. VC = b.Suppose there is a put option on Pucketts stock with exactly thesame inputs as the call option. What is the value of the put?