PLEASE, THIS MUST BE DONE IN EXCEL SO THAT I KNOW HOW TO DO THE FORMULAS AND HOW TO SOLVE THEM AND SEE THE CALCULATIONS.

1) An investor is considering an investment in Coca Cola stock. The risk free rate of return is 0.75%, the market risk premium is 5.0% and Cokes beta is 0.70.

a) Based on the CAPM, what is the investors required rate of return on the stock? Show all calculations using Excel formulas.

b) Coca cola stocks is currently selling at a price of $55 a share. The investor strongly believes that a year from now the stock will be worth $59 a share. The investor also expects that Coke will pay a dividend of $1.60 a share during the coming year. If the investor buys the stock today and holds if for a year, what will her holding period return for the year be if her predictions come true? Show all work using Excel formulas.

c) If the investor is absolutely convinced that her predictions in part b will come true, based on solely your calculations in parts a and b, above, does it make sense for the investor to invest in Coke stock at this time? Explain your reasoning.