9. A stock is selling today for $40. The stock has an annual volatility of 60 percent and the annual risk-free rate is 10 percent.

a.Use Excels data table feature to construct a One-Way Data Table to demonstrate the impact of the stock price on both the price and intrinsic value for a 9 month European call option with an exercise price of $35. Use stock prices ranging from $10 to $150 in increments of $10.

i. Based on your data table, construct a graph that demonstrates the impact of the stock price on both the price and intrinsic value of this call option.

ii. How is the intrinsic value of the call option impacted as the stock price changes?

iii. How is the time value of the call option impacted as the stock price changes?