Question

Stocks A and B have the following historical returns: Year 2012 -20.10% -12.60% 2013 20.50 24.30...

Stocks A and B have the following historical returns:

Year
2012 -20.10% -12.60%
2013 20.50 24.30
2014 17.25 30.90
2015 -3.25 -10.10
2016 29.50 11.40
  1. Calculate the average rate of return for each stock during the 5-year period. Round your answers to two decimal places.
    Stock A %
    Stock B %
  2. Assume that someone held a portfolio consisting of 50% of Stock A and 50% of Stock B. What would have been the realized rate of return on the portfolio in each year? What would have been the average return on the portfolio during this period? Round your answers to two decimal places.
    Year Portfolio
    2012 %
    2013 %
    2014 %
    2015 %
    2016 %
    Average return %
  3. Calculate the standard deviation of returns for each stock and for the portfolio. Round your answers to two decimal places.
    rA rB Portfolio
    Std. Dev. % % %
0 0
Add a comment Improve this question Transcribed image text
Answer #1

A Average rate of return for each stock during 5 years will be aa follows :-

Stock A = -20.10+20.50+17.25+(-3.25)+29.50/5

= 43.90/5 ,= 8.78%

Stock B = -12.60+24.30+30.90+(-10.10)+11.40/5

= 43.9/5 = 8.78%

Stock A 8.78%
Stock B 8.78%

B. Following will be the Return of portfolio each year and average return :-

Year Portfolio
2012 -16.35% (-20.10x0.5+-12.60x0.5)
2013 22.40% (20.50x0.50+24.30x0.50)
2014 24.075% (17.25x0.5+30.90x0.5)
2015 -6.675% (-3.25x0.5+-10.10x0.5)
2016 20.45% (29.50x0.5+11.40x0.5)
Average return 8.78% {(-16.35+22.40+24.075+-6.675+20.45)/5}

C . Standard deviation of returns of each stock and portfolio is as follows

rA rB portfolio
Standard deviation 40.21% 39.38% 37.76%

Working note :-

1. Standard deviation for sotck A

m = average return

Year return (x) x-m (here m = 8.78) (x-m)2
2012 -20.10 -28.88 (-20.10-8.78) 834.05
2013 20.50 11.72 (20.50-8.78) 137.36
2014 17.25 8.47 (17.25-8.78) 71.74
2015 -3.25 -12.03 (-3.25-8.78) 144.72
2016 29.50 20.72 (29.50-8.78) 429.32
Total m = 8.78 1617.19

Standard deviation of stock A = √1617.19 = 40.21%.

Calculation of standard deviation of stock B

Year return (x) (x-m) (x-m)2
2012 -12.60 -21.38 (-12.60-8.78) 457.10
2013 24.30 15.52 (24.30-8.78) 240.87
2014 30.90

22.12 (30.90-8.78)

489.29
2015 -10.10 -18.88 (-10.10-8.78) 356.45
2016 11.40 2.62 (11.40-8.78) 6.86
Total m = 8.78 1550.59

Standard deviation of stock B = √1550.59 = 39.38%.

Calculation of is standard deviation of portfolio

Year return (x) (x-m) (x-m)2
2012 -16.35 -25.13 (-16.35-8.78) 631.52
2013 22.40 13.62 (22.40-8.78) 185.50
2014 24.075 15.295 (24.075-8.78) 233.94
2015 -6.675 -15.454 (-6.675-8.78) 238.83
2016 20.45 11.67 (20.45-8.78) 136.19
total m = 8.78 1425.97

Standard deviation of portfolio = √1425.97 = 37.76%

Add a comment
Know the answer?
Add Answer to:
Stocks A and B have the following historical returns: Year 2012 -20.10% -12.60% 2013 20.50 24.30...
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
  • Historical Realized Rates of Return Stocks A and B have the following historical returns: Year 2012...

    Historical Realized Rates of Return Stocks A and B have the following historical returns: Year 2012 -23.00% -17.10% 2013 26.00 27.00 2014 10.75 20.80 2015 -2.25 -13.60 2016 31.50 25.90 Calculate the average rate of return for each stock during the 5-year period. Round your answers to two decimal places. Stock A % Stock B % Assume that someone held a portfolio consisting of 50% of Stock A and 50% of Stock B. What would have been the realized rate...

  • Stocks A and B have the following historical returns Year Stock A'sReturns, A Stock B's Returns,...

    Stocks A and B have the following historical returns Year Stock A'sReturns, A Stock B's Returns, rB 2011 2012 2013 2014 2015 23.00%, 26.75 15.75 3.50 29.50 1 7.50% 16,80 26.40 10.40 30.20 a. Calculate the average rate of retum for stock A during the period 2011 through 2015. Round your answer to two decimal places. Calculate the average rate of retum for stock 8 during the period 2011 through 2015. Round your answer to two decimal places, b Assume...

  • REALIZED RATES OF RETURN NEED TO BE DONE USING EXCEL!!!! Stocks A and B have the following historical returns: Year S...

    REALIZED RATES OF RETURN NEED TO BE DONE USING EXCEL!!!! Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's Returns, rB 2011 - 24.00% - 12.10% 2012 20.50 23.70 2013 17.75 31.90 2014 - 5.25 - 11.70 2015 25.75 2.95 Calculate the average rate of return for stock A during the period 2011 through 2015. Round your answer to two decimal places. % Calculate the average rate of return for stock B during...

  • 20. Problem 8.20 (Realized Rates of Return) eBook Stocks A and B have the following historical returns: Year Stock A's...

    20. Problem 8.20 (Realized Rates of Return) eBook Stocks A and B have the following historical returns: Year Stock A's Returns, A Stock B's Returns, rB 2013 - 23.30% - 15.50% 2014 20.10 20.00 10.00 2015 31.60 - 12.80 2016 - 2.50 2017 27.25 8.05 a. Calculate the average rate of return for stock A during the period 2013 through 2017. Round your answer to two decimal places. Calculate the average rate of return for stock B during the period...

  • Stocks A and B have the following historical returns: Year Stock A's Returns, A Stock B's...

    Stocks A and B have the following historical returns: Year Stock A's Returns, A Stock B's Returns, re 2011 - 23.40% 15.7094 2012 31.50 29.30 2013 17.75 28.40 2014 - 1.50 - 12.80 2015 29.00 24.15 .. Calculate the average rate of return for stock A during the period 2011 through 2015. Round your answer to two decimal places. Calculate the average rate of return for stock B during the period 2011 through 2015. Round your answer to two decimal...

  • REALIZED RATES OF RETURN Stocks A and B have the following historical returns: Stock B's Returns,...

    REALIZED RATES OF RETURN Stocks A and B have the following historical returns: Stock B's Returns, rs Stock A's Returns, rA Year - 13.50 % -15.00% 2011 19.60 31.75 2012 32.10 12.00 2013 -10.80 -4.00 2014 24.85 27.50 2015 a. Calculate the average rate of return for stock A during the period 2011 through 2015. Round your answer to two decimal places. % Calculate the average rate of return for stock B during the period 2011 through 2015. Round your...

  • Historical Realized Rates of Return You are considering an investment in either individual stocks or a...

    Historical Realized Rates of Return You are considering an investment in either individual stocks or a portfolio of stocks. The two stocks you are researching, Stock A and Stock B, have the following historical returns: Year 2014 2015 2016 2017 2018 a. Calculate the average rate of return for each stock during the 5-year period. Do not round intermediate calculations. Round your answers to two decimal places. 20.40 % 43.25 20.50 -8.50 20.00 8.90 % 16.40 -10.70 51.90 6.15 Stock...

  • Returns earned over a given time period are called realized returns. Historical data on realized returns...

    Returns earned over a given time period are called realized returns. Historical data on realized returns is often used to estimate future resu Analysts across companiess use realized stock returns to estimate the risk of a stock. Consider the case of Falcon Freight Inc. (FF): Five years of realized returns for FF are given in the following table. Remember: 1. While FF was started 40 years ago, its common stock has been publicly traded for the past 25 years. 2....

  • Please help with part C, D, and E. Thank you! Stocks A and B have the...

    Please help with part C, D, and E. Thank you! Stocks A and B have the following historical returns: Stock B's Returns, le (13.40%) Year Stock A's Returns, A 2014 (21.50%) 2015 39.75 2016 11.25 2017 (1.00) 2018 26.25 a. Calculate the average rate of return for each stock during the period 2014 through 2018. Round your answers to two decimal places. Stock A: 10.95 % Stock B: 10.95 % 26.30 25.80 (13.30) 29.35 b. Assume that someone held a...

  • Year 2014 2015 Stock A's Returns, ra (19.70%) 23.00 13.75 (2.25) 25.25 Stock B's Returns, le...

    Year 2014 2015 Stock A's Returns, ra (19.70%) 23.00 13.75 (2.25) 25.25 Stock B's Returns, le (14.80%) 17.40 36.20 (7.60) 8.85 2016 2017 2018 a. Calculate the average rate of return for each stock during the period 2014 through 2018. Round your answers to two decimal places. Stock A: % ol Stock B: b. Assume that someone held a portfolio consisting of 50% of Stock A and 50% of Stock B. What would the realized rate of return on the...

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