RETURNS Year Return A Return BReturn C 10% 10% 10% 20% -10% 20% 40% -40% 2...

Question

Question

RETURNS Year Return A Return BReturn C 10% 10% 10% 20% -10% 20% 40% -40% 2 Average 12 Volatility 13

business finance

Answer 1

Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

AS NOTHING WAS MENTIONED, EXCEL IS USED. CELL REFERENCES AND EXCEL FORMULAS ARE SHOWN.

Answer 2

Similar Homework Help Questions

7-20. Historical Returns: Expected and Required Rates of Return You have observed the following returns over...

7-20. Historical Returns: Expected and Required Rates of Return You have observed the following returns over time: Year 2011 2012 2013 2014 2015 Stock X Stock Y Market 14% 13% 12% 19 7 10 - 16 -5 -12 3 s11 20 11 15 - Assume that the risk-free rate is 4%, the market risk premium is 5%, the beta for Stock X is 1.50, and the beta for Stock Y is 0.46: a. What are the required rates of return...
Year Return 2014 -30% 2015 -25% 2016 40% 2017 -10% 2018 15% Mean of Returns= -2%...

Year Return 2014 -30% 2015 -25% 2016 40% 2017 -10% 2018 15% Mean of Returns= -2% Standard deviation of the returns= 29.28 % What is VaR at 1% level? (without using excel)
2 Homework Returns Year 20% 2 3 4 5 16% 19 10 8 10 - 21...

2 Homework Returns Year 20% 2 3 4 5 16% 19 10 8 10 - 21 Using the returns shown above, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. (Do not round intermediate calculations. Enter your average return and standard deviation as a percent rounded to 2 decimal places, e.g., 32.16, and round the variance to 5 decimal places, e.g...16161.) ences X Y % Average returns Variances Standard deviations | %

What is the expected return given the following information? Probability 20% Possible Returns 8% 10% 12%...

What is the expected return given the following information? Probability 20% Possible Returns 8% 10% 12% 15% 10% 40% 20% 10% 60% 12.2% 12% 12% 18.2% No new data to sav
If the returns on Stock A are as follows: Year 1 return 37 %, Year 2...

If the returns on Stock A are as follows: Year 1 return 37 %, Year 2 return-_8 %, Year 3 return 12 %, Year 4 return-12 %, and Year 5 return-7 %, what is the average return for Stock A over this 5 year period? (Record your answer as a percent rounded to 1 decimal place. If your answer is negative, place a minus sign before your number with no space between the sign and the number. For example, record...
The last four years of returns for a stock are as follows: Year Return 1 -...

The last four years of returns for a stock are as follows: Year Return 1 - 4.0% 120% 40% 28.0% 12.0% 4.0% a. What is the average annual return? b. What is the variance of the stock's returns? c. What is the standard deviation of the stock's returns? a. What is the average annual return? The average return is %. (Round to two decimal places.)

Suppose Ford Motor stock has an cxpcctcd return of 20% and a volatility of 40%, and...

Suppose Ford Motor stock has an cxpcctcd return of 20% and a volatility of 40%, and Molson Coors Brewing has an expected return of 10% and a volatility of 30%. If thc two stocks are a. What is the expected return and volatility of an equally weighted portfolio of the two b. Given your answer to part a, is investing all of your moncy in Molson Coors stock an c. Is investing all of your moncy in Ford Motor an...
The last four years of returns for a stock are as follows: Year 2 Return -3.6%...

The last four years of returns for a stock are as follows: Year 2 Return -3.6% 28.5% 11.8% 3.8% a. What is the average annual return? b. What is the variance of the stock's returns? c. What is the standard deviation of the stock's returns? a. What is the average annual return? The average return is%. (Round to two decimal places.)
2. Given the following historical returns, calculate the average return and the standard deviation: Year Return...

2. Given the following historical returns, calculate the average return and the standard deviation: Year Return 14% 10% 15% 11%

The last four years of returns for a stock are as follows: Year 1 2 Return...

The last four years of returns for a stock are as follows: Year 1 2 Return -3.6% 28.1% 12.3% 3.8% a. What is the average annual return? b. What is the variance of the stock's returns? c. What is the standard deviation of the stock's returns? a. What is the average annual return? The average return is%. (Round to two decimal places.) b. What is the variance of the stock's returns? The variance of the returns is (Round to five...