Question

Using the data in the following table, calculate: A. Average return and standard deviation for each...

Using the data in the following table, calculate:

A. Average return and standard deviation for each stock

B. Covariance between the stocks

C. Correlation between the stocks

D. Compute average return and standard deviation of the portfolio that maintains a 50% weight in Stock A and 50% in stock B

Year 2010 2011 2012 2013 2014 2015
Stock A -10.0% 20.0% 5.0% -5.0% 2.0% 9.0%
Stock B 21.0% 7.0% 30.0% -3.0% -8.0% 25.0%
0 0
Add a comment Improve this question Transcribed image text
Answer #1

ALL WITH STATISTICAL FORMULA, NO EXCEL FUNCTION IS USED

Add a comment
Know the answer?
Add Answer to:
Using the data in the following table, calculate: A. Average return and standard deviation for each...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 1. Using the data in the following table, calculate: A. Average return and standard deviation for...

    1. Using the data in the following table, calculate: A. Average return and standard deviation for each stock (4 points) B. Covariance between the stocks (2 points) C. Correlation between the stocks (2 points) D. Compute average return and standard deviation of the portfolio that maintains a 50% weight in Stock A and 50% in stock B (2 points) Year 2010 2011 2012 2013 2014 2015 Stock A -10.0% 20.0% 5.0% -5.0% 2.0% 9.0% Stock B 21.0% 7.0% 30.0% -3.0%...

  • Using the data in the following table, 2. estimate the: a. Average return and volatility for...

    Using the data in the following table, 2. estimate the: a. Average return and volatility for each stock. b. Covariance between the stocks. c. Correlation between these two stocks, a. Estimate the average return and volatility for each stock. The average return of stock A is _______ %. (Round to two decimal places.)Year201020112012201320142015Stock A-3%16%7%-3%4%6%Stock B16%19%28%-1%-11%25%

  • Using the data in the following table, estimate the:

    Using the data in the following table, estimate the:a. Average return and volatility for each stock b. Correlation between these two stocks. c. The average return of stock A is %. Year201020112012201320142015Stock A-13%20%9%-6%1%10%Stock B21%33%45%-8%-7%33%

  • Use the following yearly rate of return valoes for Questions 1, 2, 3, and4. Market Risk-frre...

    Use the following yearly rate of return valoes for Questions 1, 2, 3, and4. Market Risk-frre Year Stock A Stock B Stock C retura return 2008 9.0% 8.0% 11.0% 10.0% 1.0% 2009 10.0% 11.0% 3.0% 9.0% 10% 2010 -3.0% 6.0% -6.0% 8.0% 10% 2011 -3.0% -110% -11.0% -15.0% 1.0n% 2012 9.0 % 3.0% 6.% 6.0% 10% 2013 -8.0% -4.0% -2.0% 20% 10% 2014 11.0% 15.% 13.0% 6.0% 10% -2.0% 10% 2015 -9.0% -5.0% -5.0% 2016 3.0% 1.0% 10.0% 14.0% 14.0%...

  • Consider the following information about 2 stocks: Year Stock Price Stock Price 2010 136.07 517.56 2011 138.97 525....

    Consider the following information about 2 stocks: Year Stock Price Stock Price 2010 136.07 517.56 2011 138.97 525.17 2012 139.57 515.05 2013 142.13 532.76 2014 140.26 540.12 2015 143.89 544.32 2016 144.07 527.05 2017 142.67 557.43 2018 145.46 558.09 Calculate: -expected return and standard deviation for stock A; -expected return and standard deviation for stock B; -correlation, covariance, and beta between stocks A and B; -portfolio return and standard deviation, assuming 40% is invested in stock A

  • A) What is the variance of each stock? B) What is the coefficient of correlation between...

    A) What is the variance of each stock? B) What is the coefficient of correlation between stock A and B? C) If you invest 80% of your money in A and 20% in B, what would be your portfolio's expected rate of return and standard deviation? Consider the following probability distribution for stocks A and B: State Probability Return on Stock A Return on Stock B 0.20 5.0% 8.0% 0.15 7.0% 5.0% 0.40 -8.0% 9.0% 0.10 6.0% -15.0% 0.15 9.0%...

  • 2. Using the data in the following table, estimate the average return and volatility for each...

    2. Using the data in the following table, estimate the average return and volatility for each stock. Realized Returns Year Stock A Stock B 2008 4% 22% 2009 18% 25% 2010 8% 4% 2011 7% 10% 2012 3% 3% 2013 7%

  • Using the data in the following table, and the fact that the correlation of A and...

    Using the data in the following table, and the fact that the correlation of A and B is 0.35, calculate the volatility (standard deviation) of a portfolio that is 50% invested in stock A and 50% invested in stock B Realized Returns Year 2008 2009 2010 2011 2012 2013 Stock A -2% 10% 5% -4% 2% 7% Stock B 28% 26% 5% 18% The standard deviation of the portfolio is Џ96 (Round to two decimal places)

  • Using the data in the following table, and the fact that the correlation of A and...

    Using the data in the following table, and the fact that the correlation of A and B is 0.35 calculate the volatility standard deviation of a portfolio thatis 50% ınvested in stock A and 50% invested in stock B Realized Returns Year 2008 2009 2010 2011 2012 2013 Stock A -2% 10% 5% -4% 2% 7% Stock B 28% 26% 5% 1% 18% The standard deviation of the portfolio is「% (Round to two decimal places )

  • Annual and Average Returns for Stocks, Bonds, and T-Bills, 1950 to 2015 Long-Term Treasury B onds...

    Annual and Average Returns for Stocks, Bonds, and T-Bills, 1950 to 2015 Long-Term Treasury B onds 6.6% .0 1.6 5.7 13.5 Stocks 12.6% 9 28. 8.7 7.5 18.2 19.0 0.9 15.1 2.1 16. 32.4 13.7 1.4 1950 to 2015 Average 1950 to 1959 Average 1960 to 1969 Average 1970 to 1979 Average 1980 to 1989 Average 1990 to 1999 Average 2009 to 2009 Average 2010 Annual Return 2011 Annual Return 2012 Annual Return al Return 2013 Annual Return 2014 Annual...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT