Question

Stocks A and B have the following historical returns:

Year –rA   –r

2009 −18% −24%
2010 44 24
2011 −22 −4
2012 22 8
2013 34    56


a. Calculate the average rate of return for each stock during the 5-year period. 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 for the 5-year period?


b. Now calculate the standard deviation of returns for each stock and for the portfolio.
Use Equation 6-5.

2 Σ (Ft--Avg) t-l (6-5) Estimated σ n- 1

(6-4) rAvgー
c. Looking at the annual returns data on the two stocks, would you guess that
the correlation coefficient between returns on the two stocks is closer to 0.8
or to −0.8?


d. If you added more stocks at random to the portfolio, which of the following is
the most accurate statement of what would happen to σp?

(1) σp would remain constant.
(2) σp would decline to somewhere in the vicinity of 20%.
(3) σp would decline to zero if enough stocks were included.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

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

Home nert Page Layout Formulas Data Review View dd-Ins Cut E AutoSum ー E ゴWrap Text ta copy ▼ в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Edting Format Painter Clipboard EC80 DX Alignment Number Cells DY DZ EA EB EC ED EF EG EH El 63 64 65 year returns (rA) (rA rA b) (rA rA bar)A2 -18 30 32 34 10 1024 1156 100 484 3664 -22 67 68 69 70 71 72 73 74 75 76 4 average (rA bar) 12 RETURN ON STOCK A 12 standard deviation sqrt (sum of (x-xbar)A2)/n-1 standard deviation sqrt (3664/4) STANDARD DEVIATION- 30.27 78 79 80 81 DEAR Sheet2 TIME SERIES Corr REGRESSIONCAMERAEXP RETURN TREND MATRDX INTERVAL, NORMALHYPOTHESIS 01:23 31-01-2019Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text ta copy ▼ B า 프 . Ej-., Δ. : r_一 逻锂函Merge & Center. $, % , 弼,8 Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Edting Format Painter Clipboard Alignment Number Cells DX DY DZ EA EB EC ED EF EG EH El 78 79 80 81 82 83 84 85 86 87 returns (rB) (rB rB bar) (rB - rB bar)A2 1296 144 256 16 1936 3648 year 24 36 12 16 3 4 56 12 average (x bar) RETURN ON STOCK B 12 standard deviation -sqrt (sum of (x-xbar) 2)/n-1 standard deviation sqrt (3648/4) STANDARD DEVIATION= 89 91 92 93 94 95 4EMV MEAN STDV 30.20 DEAR Sheet2 TIME SERIES com REGRESSIONCAMERAEXP RETURNTREND freg MATRIXINTERVAL, NORMALHYPOTHESIS 01:24 31-01-2019Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text ta copy ▼ 9-A. .Es_函Merge & Center, $, % , 弼,8 C Conditional Format CeInsert Delete Format Formatting as Table Styles2 Clear B 1 u . :. Sort &Find & Format Painter Clipboard Alignment Number Cells Edting DX DY DZ EA EB EC ED EF EG EH El 92 93 94 95 96 97 98 PORTFOLIO RETURN & STANDARD DEVIATION rP 0.5(rA) +0.5(rB) returns (rP) year (rP rP bar) (rP rP bar)A2 -21 34 -13 15 45 12 1089 484 625 25 4 100 101 102 103 104 105 106 107 1089 3296 average (x bar) RETURN ON PORTFOLIO 12% standard deviation sqrt (sum of (x-xbar)A2)/n-1 standard deviation sqrt (3296/4) STANDARD DEVIATION- 28.71 108 109 110 4EMV MEAN STDV DEAR Sheet2 TIME SERIES com REGRESSIONCAMERAEXP RETURNTRENDfre MATRIX INTERVAL, NORMALHYPOTHESISS 01:28 31-01-2019Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text General ta copy ▼ в 1 프· ー· 鱼, Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Paste Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Edting Format Painter Clipboard EC125 DX Font Alignment Number Styles Cells DY DZ EA EB EC ED EF EG EH El 108 109 110 ANS 1 SEE IMAGE 1 AND 2 FOR RETURNS ON STOCK A AND STOCK B SEE IMAGE 3 : DARK FIGURES: RETURN ON PORTFOLIO FOR EACH YEAR SEE IMAGE: RED FONTS: RETURN ON PORTFOLIO FOR 5 YEAR PERIOD 112 113 114 115 116 ANS2 SEE IMAGE 1 FOR STANDARD DEVIATION STOCK A SEE IMAGE 2 FOR STANDARD DEVIATION STOCK B SEE IMAGE 3 FOR STANDARD DEVIATION PORTFOLIO ANS 3 CORRELATION WILL BE 0.8 118 119 120 121 122 123 124 125 126 ANS 4 SD ON PORTFOLIO WOULD DECLINE SOMEWHERE IN THE VICNITY OF 2096 DEAR / Sheet2 . COV , TIME SERIES corr REGRESSION . CAMERAEXP RETURN , TREND MATRDX INTERVAL, NORMALHYPOTHESIS 01:40 31-01-2019

Add a comment
Know the answer?
Add Answer to:
Stocks A and B have the following historical returns: Year –rA   –r 2009 −18% −24% 2010...
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 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 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 of return on the portfolio...

  • 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...

  • 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...

  • 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...

  • 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: 1. Calculate the arithmetic average return for each stock. 2. Calculate the standard deviation of returns for each stock. 3. Assume that 50% of y...

    Stocks A and B have the following historical returns: 1. Calculate the arithmetic average return for each stock. 2. Calculate the standard deviation of returns for each stock. 3. Assume that 50% of your portfolio is invested in Stock A and the rest is invested in Stock B. Based on this information, what is your portfolio’s realized return? 4. If 50% of your portfolio is invested in Stock A and the rest is invested in Stock B, what is the...

  • Year Stock A returns (%) -18 33 1998 1999 2000 2001 2002 Stock B returns (%)...

    Year Stock A returns (%) -18 33 1998 1999 2000 2001 2002 Stock B returns (%) -14.5 21.8 30.5 -7.6 26.3 15 -0.50 a) Calculate the average return for each stock during the period 1998 through 2002. (8 marks) b) Assume that someone held a portfolio consisting of 50 percent stock A and 50 percent stock B. What would have been the realized rate of return on the portfolio in each year from 1998 through 2002? What would have been...

  • 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...

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