Use the Homework $4-$Template file to do the following two problems. Q$1.$ Today you bought one call option $($i$.$e$.,$ long call$)$ on LuckyCorp stock. The option price is $\backslash (\backslash$$ $6\backslash )$ with an expiration date in $2$ months and an exercise price of $\backslash (\backslash$$ $20\backslash ).$ The current stock price is $\backslash (\backslash$$ $25\backslash ).(1)$ What is the Intrinsic Value of this option? What is its Time Value? Is this option At$-$TheMoney, In$-$The$-$Money or Out$-$of$-$The$-$Money? $(1$point$)(2)$ LuckyCorp can have a stock price between $\backslash (\backslash$$ $0\backslash )$ to $\backslash (\backslash$$ $50\backslash )$ in $2$ months, with increments of $\backslash (\backslash$$ $5\backslash ).$ In other words, LuckyCorp's stock price can be $\backslash (\backslash$$ $0,\backslash$$ $5,\backslash$$ $10\backslash$ldots $\backslash$ldots $.\backslash$$ $45\backslash )$ or $\backslash (\backslash$$ $50\backslash )$ in $2$ months. Decide if you are you going to exercise the call option under each of these possible stock prices. $(1$ point$)(3)$ Calculate the Payoff of this long call position at expiration for each possible stock price. $(1$ point$)$

$(4)$ Calculate the Profit of this long call position at expiration for each possible stock price. $(1$

point$)$

$(5)$ Plot your results from $(3)$ and $(4)$ together on one scatter chart to display Payoff and Profit

functions of this long call position. $(1$ point$)$

Need excel functions too