Use excel and show your excel workbook with the formulas in each cell. A stock is selling today for $$50.$ The stock has an annual volatility of $45$ percent, and the annual nominal risk$-$free interest rate is $4$ percent. A $15-$month European call option with an exercise price of $$46$ is available to an investor.

a$.$ Use Excel's data table feature to construct a Two$-$Way Data Table to demonstrate the impact of the exercise price and the option's duration on the price of this call option:

i$.$ Option durations of $2$ months, $5$ months, $8$ months, $11$ months, and $14$ months.

ii$.$ Exercise prices of $$40,$$$45,$$$50,$ and $$55.$

b$.$ How is the call option price impacted by varying the exercise price?

c$.$ How is the call option price impacted by varying the duration of the option?