Explore BrainMass

Explore BrainMass

    Calculating the Beta and Required Rate of Return

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    You have observed the following returns over time. Assume that the risk free rate is 6% and the market risk premium is 5%.

    Year Stock X Stock Y Market
    2006 14% 13% 12%
    2007 19% 7% 10%
    2008 -16% -5% -12%
    2009 3% 1% 1%
    2010 20% 11% 15%

    a. What are the betas for Stocks X and Y?
    b. What are the required rates of return on Stocks X and Y?
    c. What is the required rate of return on a portfolio consisting of 60% of Stock X and 40% of Stock Y?

    © BrainMass Inc. brainmass.com December 15, 2020, 9:52 pm ad1c9bdddf

    Solution Preview

    Please refer attached file for better understanding of formulas in MS Excel.

    a. What are the betas for Stocks X and Y?
    Beta can be found by using "SLOPE" function in MS Excel.
    Beta of stock X=b1=1.35
    Beta of stock ...

    Solution Summary

    Solution depicts the steps to estimate the betas and required rate of returns of the given stocks. Beta for each stock is calculated by using the suitable function in MS Excel.