Question

In: Finance

F-I is the answers I need Stock A and Stock B produced the following returns during...

F-I is the answers I need

Stock A and Stock B produced the following returns during the past five years (Year -1 is one year ago, Year -2 is two years ago, and so forth):

Year                            Stock A’s Returns,   Stock B’s Returns,

-1                                        –18.00%                                   –14.50%

-2                                          33.00                                         21.80

-3                                          15.00                                         30.50

-4                                          –0.50                                         –7.60

-5                                          27.00                                         26.30

  1. Calculate the average rate of return for each stock during the past five years.
  2. 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 for the past five years? What would have been the average return on the portfolio during this period?
  3. Calculate the standard deviation of returns for each stock and for the portfolio.
  4. Calculate the coefficient of variation for each stock and for the portfolio. If you are a risk-averse investor, would you prefer to hold Stock A, Stock B, or the portfolio? Why?
  5. Assume a third stock, Stock C, is available for inclusion in the portfolio. Stock C produced the following returns during the past five years:

Year                               Stock C’s Return, σ

-1                                            32.00%

-2                                          –11.75

-3                                            10.75

-4                                            32.25

-5                                            –6.75

Input these values and calculate the average return, standard deviation, and coefficient of variation for Stock C.

  1. Assume that the portfolio now consists of 33.33 percent Stock A, 33.33 percent Stock B, and 33.34 percent Stock C. How does this composition affect the portfolio return, standard deviation, and coefficient of variation versus when 50 percent was invested in A and in B?
  2. Make some other changes in the portfolio, making sure that the percentages sum to 100 percent. For example, enter 25 percent for Stock A, 25 percent for Stock B, and 50 percent for Stock C. Notice that remains constant and that sp changes. Why do these results occur?
  3. In part b, you should see that the standard deviation of the portfolio decreased only slightly because Stocks A and B were highly positively correlated with each other. The addition of Stock C causes the standard deviation of the portfolio to decline dramatically, even though sC = sA = sB. What does this change indicate about the correlation between Stock C and Stocks A and B?
  4. Would you prefer to hold a portfolio consisting only of Stocks A and B or a portfolio that also includes Stock C? If others react similarly, how might this fact affect the stocks’ prices and rates of return?

Solutions

Expert Solution

a) Average rate of return for the past 5 years = Sum of Returns/ 5

Therefore, Average return of A = (-18+33+15-0.5+27) / 5 = 11.30%

Therefore, Average return of B = (-14.5+21.8+30.5-7.6+26.30) / 5 = 11.30%

b) If someone had 50% stock A and 50% stock B in their portfolio, then every year the returns would be

For year -1 , the return would be (-18%+ (-14.5%))/2 = -16.25%

For year -2 , the return would be (33%+ 21.8%)/2 = 27.4%

For year -3 , the return would be (15%+ 30.5%)/2 = 22.75%

For year -4 , the return would be (-0.5%+ (-7.6%))/2 = -4.05%

For year -5 , the return would be (27%+ 26.30%)/2 = 26.65%

The Average return on the portfolio = (-16.25+27.4+22.75-4.05+26.65)/5 = 11.30%

c) Standard Deviation is calculated by

where Ri is the Return in period i and is the average return

So Standard Deviation (A) = sqrt {[{ (-18 -11.30)2 + (33-11.30)2+(15-11.30)2+(-0.5-11.30)2+(27-11.30)2}/4]

=sqrt [{(-29.30)2 + 21.72 +3.72 + (-11.8)2 + 15.72}/4]

=20.79%

& Standard Deviation (B) = sqrt {[{ (-14.5 -11.30)2 + (21.8-11.30)2+(30.5-11.30)2+(-7.6-11.30)2+(26.30-11.30)2}/4]

=sqrt [{(-25.80)2 + 10.52 +19.202 + (-18.9)2 + 152}/4]

=20.78%

& Standard Deviation (portfolio) = sqrt {[{ (-16.25 -11.30)2 + (27.4-11.30)2+(22.75-11.30)2+(-4.05-11.30)2+(26.65-11.30)2}/4]

   =20.13%

d) CV (A) = standard Deviation (A) / Average return of A

= 20.79%/11.3% = 1.8398

CV (B) = 20.78%/11.3% = 1.8387

& CV(port) = 20.13%/11.30% = 1.7812

If I am a risk averse investor, I would prefer the portfolio over A or B because of lower Coefficient of Variation (CV)


Related Solutions

NEED ANSWERS TO (e) and (f ) only: (Common stock​ valuation)  Assume the​ following:    the​ investor's...
NEED ANSWERS TO (e) and (f ) only: (Common stock​ valuation)  Assume the​ following:    the​ investor's required rate of return is ​13.5percent,    the expected level of earnings at the end of this year ​(E1​) is ​$​8    the retention ratio is 45 ​percent,    the return on equity ​(ROE​) is 15 percent​ (that is, it can earn 15 percent on reinvested​ earnings), and   similar shares of stock sell at multiples of 8.149 times earnings per share. ​Questions: a.  Determine the expected growth...
Stocks A and B have the following​ returns: Stock A     Stock B 1 0.11    ...
Stocks A and B have the following​ returns: Stock A     Stock B 1 0.11     0.06 2 0.06     0.04 3 0.15     0.04 4 0.03       0.01 5    0.07                     -0.03 a. What are the expected returns of the two​ stocks? b. What are the standard deviations of the returns of the two​ stocks? c. If their correlation is 0.48​, what is the expected return and standard deviation of a portfolio of 56​% stock A and 44​%...
Stocks A and B have the following? returns:         Stock A        Stock B 1         0.11        &nb
Stocks A and B have the following? returns:         Stock A        Stock B 1         0.11           0.05 2         0.06            0.02 3        0.15            0.05 4        -0.04           0.02 5        0.08            -0.04 a. What are the expected returns of ?stock A and Stock B? b. What are the standard deviations of the returns of stock A and stock B? c. If their correlation is 0.43?, what is the expected return and standard deviation of a portfolio of 55?% stock A and 45?% stock? B?
Can someone explain a,b and c? The answers are correct I believe but I just need...
Can someone explain a,b and c? The answers are correct I believe but I just need a more clear explenation on the formulas and final answers If 2 cards are drawn from a well-shuffled deck of 52 playing cards, what are the probabilities of getting Answer: Total no of ways of drawing 2 cards from a well-shuffled deck of 52 playing cards = 52C2 = 1326 (a)        two spades; Number of ways getting 2 spades / total number of ways...
Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's...
Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's Returns, rB 2011 - 22.40% - 15.60% 2012 27.75 19.70 2013 10.00 37.00 2014 - 5.00 - 9.90 2015 23.75 2.90 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 answer to...
Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's...
Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's Returns, rB 2014 (16.20 %) (13.00 %) 2015 33.50 24.10 2016 15.00 30.90 2017 (1.75 ) (9.60 ) 2018 27.25 25.40 Calculate the average rate of return for each stock during the period 2014 through 2018. 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....
Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's...
Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's Returns, rB 2013 - 19.40% - 17.90% 2014 37.75 23.80 2015 15.25 35.70 2016 - 5.50 - 6.70 2017 26.25 19.45 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 2013 through 2017. Round your answer to...
Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's...
Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's Returns, rB 2014 (18.50 %) (13.50%) 2015 32.50 19.90 2016 16.75 25.50 2017 (5.00 ) (12.70 ) 2018 27.50 34.05 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: % Stock B: % b. Assume that someone held a portfolio consisting of 50% of Stock A and 50%...
Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's...
Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's Returns, rB 2013 - 23.10% - 16.70% 2014 39.25 28.30 2015 16.50 37.90 2016 - 1.75 - 7.70 2017 26.25 15.35 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 2013 through 2017. Round your answer to...
Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's...
Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's Returns, rB 2011 - 23.90% - 12.00% 2012 24.75 27.40 2013 11.75 38.40 2014 - 1.25 - 6.50 2015 24.75 -11.20 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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT