# Stock X's beta coefficient

**This content was STOLEN from BrainMass.com - View the original, and get the solution, here!**

You are given the following data:

HISTORICAL RATES OF RETURN

YEAR NYSE Stock X

1 (26.5%) (14.0%)

2 37.2 23.0

3 23.8 17.5

4 (7.2) 2.0

5 6.6 8.1

6 20.5 19.4

7 30.6 18.2

a. Use a spreadsheet (or calculator with a linear regression function) to determine stock X's beta coefficient.

b. Determine the arithmetic average rates of return for Stock X and the NYSE over the period given. Calculate the standard deviations of returns for both Stock X and the NYSE.

c. Assuming (1) that the situation during Years 1 to 7 is expected to hold true in the future (that is r(x) = r(x); r(m); and both o(x) and b(x) in the future will equal their past values), and (2) that Stock X is in equilibrium (that is, its plots on the Security Market Line), what is the risk-free rate?

d. Plot the Security Market Line.

E. Suppose you hold a large, well-diversified portfolio and are considering adding to the portfolio either Stock X or another stock, Stock Y, that has the same beta as Stock X but a higher standard deviation of returns. Stocks X and Y have the same expected returns; that is r(x) = r(y) = 10.6%. Which stock should you choose?

© BrainMass Inc. brainmass.com September 20, 2018, 1:16 pm ad1c9bdddf - https://brainmass.com/business/capital-asset-pricing-model/28350#### Solution Summary

Spreadsheet (Microsoft Excel) is used to determine stock X's beta coefficient - by using slope of the linear regression function. The arithmetic average rates of return for Stock X and the NYSE over the period given are calculated. Also, the standard deviations of returns for both Stock X and the NYSE are calculated. Risk free rate is calculated assuming that the stock returns are in equilibrium- than plot on Security Market Line. The Security Market Line is also plotted.