QUESTION 1 THIS QUESTION SHOULD BE ANSWERED IN AN EXCEL FILE

QUESTION 1 THIS QUESTION SHOULD BE ANSWERED IN AN EXCEL FILE. WHEN YOU HAVE ANSWERED THE QUESTION, NAME YOUR FILE YOUR LAST NAME#1 AND UPLOAD IT TO BLACKBOARD. 1) An investor is considering an investment in Coca Cola stock. The risk free rate of return is 0.4%, the market risk premium is 6.0% and Coke\'s beta is 0.85. a) Based on the CAPM, what is the investor\'s required rate of return on the stock? Show all calculations using Excel formulas. b) Coca cola stocks is currently selling at a price of $42 a share. The investor strongly believes that a year from now the stock will be worth $44 a share. The investor also expects that Coke will pay a dividend of $1.20 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.

Solution

a. Investor\'s required rate of return on the stock ra = rf + Beta (rm - rf) Where: rf = Risk free rate Beta = Beta of the security rm = Expected market rate ra = 0.4% + 0.85 (6% - 0.4%)      = 5.16% b. Holding Period Return Holding period return = Earnings + Asset Appreciation Intial Investment HPR = 1.20 + 2 42          = 7.62% c. Based on the above calculations, it is suggested to invest in Coca cola at this time     Holding period return is higher then the market rate and the required rate of return.