Question

In: Finance

Use the following returns for X and Y. Returns Year X Y 1 21.9 % 26.7...

Use the following returns for X and Y.

Returns
Year X Y
1 21.9 % 26.7 %
2 16.9 –3.9
3 9.9 28.7
4 19.8 –14.8
5 4.9 32.7


Calculate the average returns for X and Y. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)

Average returns
X %
Y %

  
Calculate the variances for X and Y. (Do not round intermediate calculations and round your answers to 6 decimal places, e.g., 32.161616.)
  

Variances
X
Y

  
Calculate the standard deviations for X and Y. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)
  

Standard deviations
X %
Y %

rev: 04_07_2017_QC_CS-85233

Solutions

Expert Solution

The following are the data inputs in spreadsheet:

The following are the obtained results in spreadsheet:


Related Solutions

Use the following returns for X and Y. Returns Year X Y 1 22.0 % 27.0...
Use the following returns for X and Y. Returns Year X Y 1 22.0 % 27.0 % 2 – 17.0 – 4.0 3 10.0 29.0 4 20.0 – 15.0 5 5.0 33.0 Requirement 1: Calculate the average returns for X and Y. (Do not round intermediate calculations. Enter your answers as a percentage rounded to 2 decimal places (e.g., 32.16).) Average returns X % Y % Requirement 2: Calculate the variances for X and Y. (Do not round intermediate calculations....
Stocks X and Y have the following probability distributions of expected future returns: Probability      X      Y            0.3 &nb
Stocks X and Y have the following probability distributions of expected future returns: Probability      X      Y            0.3      2%      25%       0.4      12%      20%       0.3      20%      0%       One investor invests 40% in stock X and 60% in stock Y. Calculate the expected return, standard deviation, and coefficient of variation Stocks X and Y. Compute the expected rate of return for the portfolio.
Stocks X and Y have the following probability distributions of expected future returns: Probability      X      Y            0.3 &nb
Stocks X and Y have the following probability distributions of expected future returns: Probability      X      Y            0.3      2%      25%       0.4      12%      20%       0.3      20%      0%       One investor invests 40% in stock X and 60% in stock Y. Calculate the expected return, standard deviation, and coefficient of variation Stocks X and Y. Compute the expected rate of return for the portfolio.
You have observed the following returns over time:    Year Stock X Stock Y Market 2015...
You have observed the following returns over time:    Year Stock X Stock Y Market 2015 15% 14% 13% 2016 18 5 9 2017 -16 -3 -11 2018 2 2 2 2019 20 12 17 Assume that the risk-free rate is 6% and the market risk premium is 4%. a. What are the betas of Stocks X and Y? Stock X: 1.3 Stock Y: b. What are the required rates of return on Stocks X and Y? Stock X:  11.2 %...
Using the following returns, calculate the expected returns, the variance, standard deviations and coefficient of variation for X and Y.
Using the following returns, calculate the expected returns, the variance, standard deviations and coefficient of variation for X and Y.ProbRxRy0.3512.29.650.30-20.356.512.5Show All in Excel.
x*y' '+y'-x*y=0 1> use Frobenious series solution to solve the ODE.
x*y' '+y'-x*y=0 1> use Frobenious series solution to solve the ODE.
Consider the following five utility functions. G(x,y) = (x)1/2 + y H(x,y) = (x+1)1/2 + y...
Consider the following five utility functions. G(x,y) = (x)1/2 + y H(x,y) = (x+1)1/2 + y + 1 L(x,y) = ln(x) + y U(x,y) = x ey W(x,y) = 100 x - 4x2 + 3 y Z(x,y) = -(100 - x)2 -3 (y-200)2 Which function or functions represent the same preferences as U?   a.G b.U c.None. d.W e.Z f.L g.H
1. use back substitution to solve for x and y in the following equation: 417x +...
1. use back substitution to solve for x and y in the following equation: 417x + 362y = 1 2. Use contradiction to show that there is no integer that is both even and odd 3. For all integers a, b, c, and d, if a/c and b/d then ab/cd 4. For all integrrs a, b, and c, if a/b and b/c then ab/c
You have observed the following returns over time: Year Stock X Stock Y Market 2011 15...
You have observed the following returns over time: Year Stock X Stock Y Market 2011 15 % 14 % 12 % 2012 20 7 8 2013 -13 -4 -12 2014 3 1 1 2015 21 11 14 Assume that the risk-free rate is 4% and the market risk premium is 6%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. What is the beta...
You have observed the following returns over time: Year Stock X Stock Y Market 2011 13...
You have observed the following returns over time: Year Stock X Stock Y Market 2011 13 % 11 % 10 % 2012 20 7 9 2013 -13 -6 -10 2014 3 1 1 2015 20 11 17 Assume that the risk-free rate is 4% and the market risk premium is 6%. What is the beta of Stock X? Do not round intermediate calculations. Round your answer to two decimal places. What is the beta of Stock Y? Do not round...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT