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?

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.

Calculate Stock's Beta: Required Rate of Return & Risk Free Rate. ... See attached file. This solution calculates the stock's beta given the required rate of ...

... Using the CAPM / SML methodology, calculate the required returns for Asset A and ... Finally, the beta for each asset is calculated, and the expected return...

Calculating a Stock's Beta and Required Rate of Return. ... Open attachment for solution. The solution is a step-by-step calculation of the stock's beta and the ...

Calculate the fund's beta and required rate of return. ... Solution describes the steps to calculate the beta and required rate of return for the given fund. ...

Calculate Stock Beta & Required Rate to Return. ... a. Calculate Stock A's beta. b. If stock A's beta were 2.0, what would be A's new required rate of return? ...

Calculation of Required Rate of Return on a Stock. ...rate of return on a stock with a beta of .7? Here are the terms and the formula for calculating the expected ...

Calculate Beta and rate of return for a stock. ... The required rate of return will decrease when risk premium ... The solution calculates beta and rate of return for a ...

... Information for Visa for the following: Beta: 0.86 Current annual ... the information you recorded, use the CAPM to calculate XYZ's required rate of return...

Calculate Expected stock return, required rate of return, beta, portfolio return, CAPM. See attached file. 8- 1 EXPECTED RETURN. A stock's returns have the ...