# Question: Using the model in File C11 rework Problem 11 27 assuming

Using the model in File C11, rework Problem 11-27, assuming that a third stock, Stock C, is available for inclusion in the portfolio. Stock C has the following historical returns:

Year Stock C’s Return, ¨rC

2011 ......... 32.00%000

2012 ......... 11.75000%

2013 ......... 10.75000%

2014 ......... 32.25000%

2015 ......... 6.75%000

a. Calculate (or read from the computer screen) the average return, standard deviation, and coefficient of variation for Stock C.

b. Assume that the portfolio now consists of 33.33 percent Stock A, 33.33 percent Stock B, and 33.33 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?

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

d. In Problem 11-27, the standard deviation of the portfolio decreased only slightly because Stocks A and B were highly positively correlated with each other. In this problem, the addition of Stock C causes the standard deviation of the portfolio to decline dramatically, even though σC = σA = σB. What does this change indicate about the correlation between Stock C and Stocks A and B?

e. Would you prefer to hold the portfolio described in Problem 11-27 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?

Year Stock C’s Return, ¨rC

2011 ......... 32.00%000

2012 ......... 11.75000%

2013 ......... 10.75000%

2014 ......... 32.25000%

2015 ......... 6.75%000

a. Calculate (or read from the computer screen) the average return, standard deviation, and coefficient of variation for Stock C.

b. Assume that the portfolio now consists of 33.33 percent Stock A, 33.33 percent Stock B, and 33.33 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?

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

d. In Problem 11-27, the standard deviation of the portfolio decreased only slightly because Stocks A and B were highly positively correlated with each other. In this problem, the addition of Stock C causes the standard deviation of the portfolio to decline dramatically, even though σC = σA = σB. What does this change indicate about the correlation between Stock C and Stocks A and B?

e. Would you prefer to hold the portfolio described in Problem 11-27 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?

**View Solution:**## Answer to relevant Questions

The financial manager of a large national firm was overheard making the following statement: “We try to use as much retained earnings as possible for investment purposes because there is no explicit cost to these funds, ...Why is there a cost to the firm for retaining earnings to fund investments?You are given the following information about a firm:The firm expects to retain $160,000 in earnings this year to invest in investment projects. If the firm’s capital budget is expected to equal $180,000, what required ...The Mason Corporation’s present capital structure, which is also its target capital structure, calls for 50 percent debt and 50 percent common equity. The firm has only one potential project, an expansion program with a ...Ezzell Enterprises has the following capital structure, which it considers to be optimal under present and forecasted conditions:Debt (long-term only) ........ 45%Common equity .......... 55Total liabilities and equity ...Post your question