Please help me with this problem and show your work on excel. Econ Stats please and thank you. Please show what to fill in the template and how you got that answer.

Part A$.$ The underlying stock has a price of $\backslash (\backslash$$ $180\backslash ),$ a strike price of $\backslash (\backslash$$ $200\backslash ),$ a dividend yield of $\backslash (0\mathrm{.}5\backslash \%\backslash ),$ and $\backslash (40\backslash \%\backslash )$ volatility. If the risk$-$free interest rate is $\backslash (6\backslash \%\backslash ),$ find the six$-$month call option price$/$value $(2\mathrm{.}5$ pts $),$ six$-$month put option value $(2\mathrm{.}5$ pts $),$ and draw the expiration payoff diagrams $($stock price vs$.$ profit$)$ for both long$/$short call and long$/$short put $($two sets of diagrams: one for call one for put$)$ using MSExcel line graph$(5$ pts$).$ What is the spread? Explain the reason for the magnitude of the difference in one sentence $($no more than $30$ words$).$ In other words, why is one price much higher than the other? What is the bet$/$expectation here? $(5$ pts $)$

Part B$.$ The underlying stock has a price of $\backslash (\backslash$$ $35\backslash ),$ a strike price of $\backslash (\backslash$$ $37\backslash ),$ a dividend yield of $\backslash (5\backslash \%\backslash ),$ and $\backslash (30\backslash \%\backslash )$ volatility. If the risk$-$free interest rate is $\backslash (10\backslash \%\backslash ),$ find the nine$-$month call option price$/$value $(2\mathrm{.}5$ pts $),$ nine$-$month put option value $(2\mathrm{.}5$ pts $),$ and draw the expiration payoff diagrams $($stock price vs$.$ profit$)$ for both long$/$short call and long$/$short put $($two sets of diagrams: one for call one for put$)$ using MSExcel line graph$(5$ pts$).$ What is the spread? Explain the reason for the magnitude of the difference in one sentence $($no more than $30$ words$).$ In other words, why is one price much higher than the other? What is the bet$/$expectation here? $(5$ pts$)$

Upload Put Value

Spread $($Absolute Value of The Difference between Call Option Price and Put Option Price$)$