Question
Please help me answer this question using excel. Thank you 1. An investor is considering an investment in Coca Cola stock. The risk free rate
Please help me answer this question using excel. Thank you
1. An investor is considering an investment in Coca Cola stock. The risk free rate of return is 1.5%, the market rate of return is 9% and Cokes beta is 0.57.
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 stock is currently selling at a price of $44 a share. The investor strongly believes that a year from now the stock will be worth $50 a share. The investor also expects that Coke will pay a dividend of $1.56 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.
d) Pier 1 Imports has a beta of 2.3. Would a rational investor require a higher or lower return from an investment in Pier 1 as opposed to Coke? Why?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started