Coefficient of variation=Standard deviation/Expected
returns
Required return=risk free rate+beta*market risk premium
1.
=40%/9.5%=4.21053
2.
=25%/12.5%=2.00000
3.
For diversified investors the relevant risk is measured by beta.
Therefore, the stock with the higher beta is riskier. Stock Y has
the higher beta so it is more risky than Stock X.
4.
=6%+0.8*5%
=10.00%
5.
=6%+1.2*5%
=12.00%
6.
Stock Y
7.
=(4500*10%+7000*12.00%)/11500
=11.22%
8.
Stock Y
Excel Online Structured Activity: Evaluating risk and return Stock X has a 9.5% expected return, a...
Excel Online Structured Activity: Evaluating risk and return Stock X has a 9.5% expected return, a beta coefficient of 0.8, and a 40% standard deviation of expected returns Stock Y has a 12.5% expected return, a beta coefficient of 1.2, and a 25.0% standard deviation. The risk-free rate is 6%, and the market risk premium is 5%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the...
Excel Online Structured Activity: Evaluating risk and return Stock X has a 10.0% expected return, a beta coeficient of 0.9, and a 30% standard deviation of expected returns. Stock Y has a 12.0% expected return, beta coefficient of 1.1, and a 20.0% standard deviation. The risk-free rate is 6%, and the market risk premium is 5%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions...
EVALUATING RISK AND RETURN Stock X has a 9.5% expected return, a beta coefficient of 0.8, and a 35% standard deviation of expected returns. Stock Y has a 12.5% expected return, a beta coefficient of 1.2, and a 20.0% standard deviation. The risk-free rate is 6%, and the market risk premium is 5%. Calculate each stock's coefficient of variation. Round your answers to two decimal places. Do not round intermediate calculations. CVx = CVy = Which stock is riskier for...
EVALUATING RISK AND RETURN Stock X has a 9.5% expected return, a beta coefficient of 0.8, and a 40% standard deviation of expected returns. Stock Y has a 12.5% expected return, a beta coefficient of 1.2, and a 20.0% standard deviation. The risk-free rate is 6%, and the market risk premium is 5%. a. Calculate each stock's coefficient of variation. Round your answers to two decimal places. Do not round intermediate calculations. CVx = ________ CVy = ________ b. Which...
Excel Online Activity: Evaluating risk and return Question 1 0/10 Submit Excel Online Structured Activity: Evaluating risk and return Stock X has a 9.5% expected return, a beta coefficient of 0.8, and a 35% standard deviation of expected returns. Stock Y has a 12.0% expected return, a beta coefficient of 1.1, and a 25.0% standard deviation. The risk-free rate is 6%, and the market risk premium is 5%. The data has been collected in the Microsoft Excel Online file below....
EVALUATING RISK AND RETURN Stock X has a 10.0% expected return, a beta coefficient of 0.9, and a 35% standard deviation of expected returns. Stock Y has a 12.0% expected return, a beta coefficient of 1.1, and a 25.0% standard deviation. The risk-free rate is 6%, and the market risk premium is 5%. a. Calculate each stock's coefficient of variation. Round your answers to two decimal places. Do not round intermediate calculations. CV, - CV- b. Which stock is riskler...
Stock X has a 9.5% expected return, - beta coefficient of 0.B, and a 40% standard deviation of expected returns. Stock Y has a 13.0% expected return, a beta coefficient of 1.3, and a 30.0% standard deviation. The risk-free rate is 6%, and the market risk premium is 5%. 2. Calculate each stock's coefficient of variation. Round your answers to two decimal places. Do not round intermediate calculations. CVX = X CV = 2.4 D. Which stock is riskier for...
Stock X has a 10.0% expected return, a beta coefficient of 0.9, and a 35% standard deviation of expected returns. Stock Y has a 12.0% expected return, a beta coefficient of 1.1, and a 30.0% standard deviation. The risk-free rate is 6%, and the market risk premium is 5%. Calculate each stock's coefficient of variation. Round your answers to two decimal places. Do not round intermediate calculations. CVx = CVy = Which stock is riskier for a diversified investor? For...
Stock X has a 9.5% expected return, a beta coefficient of 0.8, and a 35% standard deviation of expected returns. Stock Y has a 12.0% expected return, a beta coefficient of 1.1, and a 30% standard deviation. The risk-free rate is 6%, and the market risk premium is 5%. Calculate each stock's coefficient of variation. Do not round intermediate calculations. Round your answers to two decimal places. CVx = CVy = Which stock is riskier for a diversified investor? For...
alk-Through Stock X has a 9.5 % expected return, a beta coefficient of 0.8, and a 30 % standard deviation of expected returns. Stock Y has a 12.5 % expected return, a beta coefficient of 1.2, and a 25% standard deviation. The risk-free rate is 6 %, and the market risk premium is 5%. a. Calculate each stock's coefficient of variation. Do not round intermediate calculations. Round your answers to two decimal places. CV 3.16 CVy 2 b. Which stock...