Question

In: Finance

The following information is available on the percentage rates of return on various assets for the...

The following information is available on the percentage rates of return on various assets for the last three years. You determine that this is a sample which is representative of the data population for these securities.

Security Year 1

Security Year 1 Year 2 Year 3
Stock A 6% 18% 60%
Stock B 32% 22% 32%
Market 50% 12% 20%
Government Bonds 10% 10% 10%

(a) Consider only shares A and B for this part. Compute the portfolio weights that yield the portfolio of A and B which has the lowest possible standard deviation. Then compute that portfolio’s expected return and standard deviation. Hint: Write down the formula for this, then compute all the ingredients you require.

Solutions

Expert Solution

Answer )

Security Year 1 Year 2 Year 3 Average return Std dev (Std dev)^2
Stock A 6% 18% 60% 28% 0.283549 0.0804
Stock B 32% 22% 32% 29% 0.057735 0.003333
Market 50% 12% 20% 27% 0.200333
Government Bonds 10% 10% 10% 10%
Correlation Matrix
Stock A Stock B Market
Stock A 1
Stock B 0.305424 1
Market -0.51053 0.662849 1

For portfolio
Rp = WARA + WBRB , WA =WB = weight of stock A/B and RA =RB = return of stock A/B.

p2 =  WA2A2 + WB2B2 + 2 WA * WB *A *B * rAB , where , A =B + standard deviation of A/B , and rAB = correlation between A/B.

WA = 1- WB.

Below table indicate the standard deviation of portfolio at different level (value of ) WA and WB

Situation WA WB p2 p RP
1 0.01 0.99 0.003374 0.058086 28.66%
2 0.02 0.98 0.003429 0.058562 28.65%
3 0.05 0.95 0.003684 0.060699 28.63%
4 0.25 0.75 0.008775 0.093675 28.50%
5 0.5 0.5 0.023433 0.15308 28.33%
6 0.75 0.25 0.047308 0.217505 28.17%
7 0.8 0.2 0.053189 0.230628 28.13%
8 0.9 0.1 0.066057 0.257016 28.07%

From the above table , situation 1 has the minimum value of risk ( p) . and return at calculated .


Related Solutions

In 2011-2015, mutual fund manager, Diana Sauros produced the following percentage rates of return for the...
In 2011-2015, mutual fund manager, Diana Sauros produced the following percentage rates of return for the Mesozoic Fund. Rates of return on the market index are given for comparison. 2011 2012 2013 2014 2015 Fund ?1.4 +24.3 +40.3 +11.3 +0.5 Market index ?0.8 +15.0 +31.3 +10.6 ?0.6 Calculate (a) the average return on both the Fund and the index, and (b) the standard deviation of the returns on each. (Do not round intermediate calculations. Round your answers to 2 decimal...
In 2011-2015, mutual fund manager, Diana Sauros produced the following percentage rates of return for the...
In 2011-2015, mutual fund manager, Diana Sauros produced the following percentage rates of return for the Mesozoic Fund. Rates of return on the market index are given for comparison. 2011 2012 2013 2014 2015 Fund −1.3 +25.0 +41.0 +12.0 +0.4 Market index −1.0 +17.0 +32.0 +11.3 −0.8 Calculate (a) the average return on both the Fund and the index, and (b) the standard deviation of the returns on each. (Do not round intermediate calculations. Round your answers to 2 decimal...
In 2011-2015, mutual fund manager, Diana Sauros produced the following percentage rates of return for the...
In 2011-2015, mutual fund manager, Diana Sauros produced the following percentage rates of return for the Mesozoic Fund. Rates of return on the market index are given for comparison. 2011 2012 2013 2014 2015 Fund −1.3 +24.2 +40.2 +11.2 +0.4 Market index −0.7 +14.0 +31.2 +10.5 −0.5 Calculate (a) the average return on both the Fund and the index, and (b) the standard deviation of the returns on each.
In 2011-2015, mutual fund manager, Diana Sauros produced the following percentage rates of return for the...
In 2011-2015, mutual fund manager, Diana Sauros produced the following percentage rates of return for the Mesozoic Fund. Rates of return on the market index are given for comparison. 2011 2012 2013 2014 2015 Fund −1.5 +23.7 +41.6 +10.6 +0.6 Market index −0.6 +18.0 +31.1 +11.9 −0.4 Calculate (a) the average return on both the Fund and the index, and (b) the standard deviation of the returns on each. (Do not round intermediate calculations. Round your answers to 2 decimal...
Computing Return on Equity and Return on Assets The following table contains financial statment information for...
Computing Return on Equity and Return on Assets The following table contains financial statment information for Walmart Stores Inc. $ millions Total Assets Net Income Sales Equity 2015 199,581 14,694 478,614 80,546 2014 203,490 16,363 482,229 81,394 2013 204,751 16,022 473,076 76,255 Questions A. Compute the return on euqity (ROE) for 2014 and 2015. What trend, if any, is evident? How does Wal-Mart's ROE compare with approximately 18.9% ROE for companies in the Dow Jones INdustrial average of 2015? B....
Computing Return on Equity and Return on Assets The following table contains financial statement information for...
Computing Return on Equity and Return on Assets The following table contains financial statement information for Wal-Mart Stores, Inc. $ millions Total Assets Net Income Sales Equity 2015 $199,581 $14,694 $478,614 $80,546 2014 203,490 16,363 482,229 81,394 2013 204,751 16,022 473,076 76,255 (a) Compute the return on equity (ROE) for 2014 and 2015. (Round your answers to one decimal place.) 2015 ROE =Answer % 2014 ROE =Answer % What trend, if any, is evident? How does Wal-Mart's ROE compare with...
You are given the following information on probabilities of events happening, and rates for return for...
You are given the following information on probabilities of events happening, and rates for return for possible projects A and B. Prob A B 0.2 2% 8% 0.2 9% 9% 0.2 10% 10% 0.2 11% 16% 0.2 13% 18% Calculate the expected returns of A (E[rA]) and B (E[rB]) . Calculate the absolute risk levels of A and B. Calculate the relative risk levels of A and B. If you have to invest in one asset which asset would you...
The following information is available for the New York Giants Rental.             Assets at December 31,...
The following information is available for the New York Giants Rental.             Assets at December 31, 2004........................................ $152,000 2004 Cash inflows from operating activities.................. 105,000 2004 Cash outflows from financing activities................ (44,000) 2004 Cash outflows from investing activities................ (84,000) 2004 Expenses.............................................................. 43,000 Equity at December 31, 2003........................................ 62,000 Liabilities at December 31, 2004................................... 28,000 2004 Revenues.............................................................. 135,000 2004 Withdrawals......................................................... (30,000)                         Using the above information prepare an Income Statement, Statement of Owner's Equity, and Statement of Cash Flows for the...
You have the following assets available to you to invest in: Asset Expected Return Standard Deviation...
You have the following assets available to you to invest in: Asset Expected Return Standard Deviation Risky debt 6% 0.25 Equity 10% .60 Riskless debt 4.5% 0 The coefficient of correlation between the returns on the risky debt and equity is 0.72 2A. Using the Markowitz portfolio optimization method, what would the composition of the optimal risky portfolio of these assets be? 2B. What would the expected return be on this optimal portfolio? 2C. What would the standard deviation of...
You have the following assets available to you to invest in: Asset Expected Return Standard Deviation...
You have the following assets available to you to invest in: Asset Expected Return Standard Deviation Risky debt 6% 0.25 Equity 10% .60 Riskless debt 4.5% 0 given =The coefficient of correlation between the returns on the risky debt and equity is 0.72, previously solved = the composition of the optimal risky portfolio of these assets is -0.42, the expected return on this portfolio is 11.663796% and the standard deviation on this portfolio is 78.10% 2D. Hector has a coefficient...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT