Today you bought one call option (i.e., long call) on LuckyCorp stock. The option price is $6 with an expiration date in 2 months and an exercise price of $20. The current stock price is $25.

a.) What is the Intrinsic Value of this option? What is its Time Value? Is this option At-The-Money, In-The-Money or Out-of-The-Money?

b.) LuckyCorp can have a stock price between $0 to $50 in 2 months, with increments of $5. In other words, LuckyCorps stock price can be $0, $5, $10$45 or $50 in 2 months. Decide if you are you going to exercise the call option under each of these possible stock prices.

c.) Calculate the Payoff of this long call position at expiration for each possible stock price.

d.) Calculate the Profit of this long call position at expiration for each possible stock price.

e.) Plot your results from (3) and (4) together on one scatter chart to display Payoff and Profit functions of this long call position.

Please Show formulas on excel