Use the table for the question(s) below . Consider the following expected returns, volatilities, and correlations:...

Use the table for the question(s) below . Consider the following expected returns, volatilities, and correlations: Stock Expected Return Standard Deviation Correlation with Duke Energy Correlation with Microsoft Correlation with Wal Mart − Duke Energy 14% 6% 1.0 1.0 − 0.0 Microsoft 44% 24% 1.0 − 1.0 0.7 Wal Mart − 23% 14% 0.0 0.7 1.0 Which of the following combinations of two stocks would give you the biggest reduction in risk? A. Microsoft and Duke Energy B. Duke Energy and Wal Mart − C. Wal Mart and Microsoft − D. No combination will reduce risk.

Expert Solution

B. Duke Energy and Walmart

Reduction in risk of Portfolio depends upon the correlation between stocks. Correlation values lies between -1.00 to + 1.00. If correlation is 1.00 i.e positively perfectly correlated then there would be no reduction in risk of portfolio it will be same as weighted average of risk. As correlation reduces the reduction in portfolio risk also reduces.

In above case, Duke and Walmart has lowest correlation i.e 0 (uncorrelated) Thus, this combination would give biggest reduction in risk.

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

Hope this will help, please do comment if you need any further explanation. Your feedback would be appreciated.

jeff jeffy answered 1 year ago

Consider the following expected returns, volatilities, and correlations: Stock Expected Return Standard Deviation Correlation with duke...

Consider the following expected returns, volatilities, and correlations: Stock Expected Return Standard Deviation Correlation with duke energy Correlation With Microsoft Correlation With Walmart Duke Energy 15% 5% 1 -1 0 Microsoft 44% 24% -1 1 0.7 Walmart 23% 14% 0 0.7 1 a. Consider a portfolio consisting of only Duke Energy and Microsoft. What is the percentage of your investment (portfolio weight) that you would place in Duke Energy stock to achieve a risk-free investment? b. What is the expected...

Use the table for the question(s) below. Consider the following three individuals portfolios consisting of investments...

Use the table for the question(s) below. Consider the following three individuals portfolios consisting of investments in four stocks: Stock Beta Peter's Investment Paul's Investment Mary's Investment Eenie 1.3 2500 5000 10,000 Meenie 1.0 2500 5000 10,000 Minie 0.8 2500 5000 minus 5000 Moe minus 0.5 2500 minus 5000 minus 5000 Assuming that the risk-free rate is 4% and the expected return on the market is 12%, then required return on Peter's Portfolio is closest to: A. 8% B. 12%...

Suppose Johnson & Johnson and the Walgreen Company have the expected returns and volatilities shown below,...

Suppose Johnson & Johnson and the Walgreen Company have the expected returns and volatilities shown below, with a correlation of 21.8%. Upper E left bracket Upper R right bracketE [R] SD left bracket Upper R right bracketSD [R] Johnson & Johnson 7.2% 15.6% Walgreen Company 10.3% 19.4% For a portfolio that is equally invested in Johnson & Johnson's and Walgreen's stock, calculate: a. The expected return. b. The volatility (standard deviation).

Use the following table to answer the question below. Expected ret. std. dev. S&P500 13% 25%...

Use the following table to answer the question below. Expected ret. std. dev. S&P500 13% 25% ABC Fund 20% 29% T-bill 4% Borrow 8% What is the highest fee that a client who is currently borrowing would be willing to pay to invest in ABC fund instead of S&P500? Round your answer to 4 decimal places. For example, if your answer is 3.205%, then please write down 0.0321.

Consider stocks of two companies A and B, the table below gives their expected returns and...

Consider stocks of two companies A and B, the table below gives their expected returns and standard deviation Expected return for Stock A 10% Expected return for Stock B 25% Standard deviation for Stock A 12% Standard deviation for Stock B 30% Plot the risk and expected return of portfolio of these two stocks for the following correlation coefficient : -1.0,-0.5,0.0,0.5,1.0

Use the following table of states of the economy and stock returns to calculate the expected...

Use the following table of states of the economy and stock returns to calculate the expected return on a portfolio of 50 percent Roten and the rest in Bradley. Security if State Returns Occurs Prob of State of Economy Roten Bradley Bust 0.3 -7% 31% Boom ? 49 13

Use the data given below to answer the following question(s). The following table exhibits the age...

Use the data given below to answer the following question(s). The following table exhibits the age of second-hand furniture and the corresponding prices. Use the table to answer the following question(s). (Hint: Use scatter diagram and XLMiner where necessary.) Number of Years Values 2 1856 14 348 7 1020 5 1530 10 349 8 780 9 653 3 1830 10 750 6 1300 Q1. What is the relationship between the age of the furniture and their values? _ _________________ Q2....

Use the table below to answer the following question(s). Bolton Computer's Laptop Pricing Decision ...

Use the table below to answer the following question(s). Bolton Computer's Laptop Pricing Decision Inputs Price Model Sales -3.85 × price + 1150.9 Outputs Total revenue sales × price Bolton Computers are planning to release a new line of low-end laptops. Using Excel's Solver, develop a nonlinear model to calculate the optimal price for the laptops, given that sales = -3.85 × price...

QUESTION 2 MONTHLY Expected Returns, Standard Deviations, and Correlations July 1990 through December 2014, 294 months,...

QUESTION 2 MONTHLY Expected Returns, Standard Deviations, and Correlations July 1990 through December 2014, 294 months, returns are total stock market returns for the region) Correlation with: Asset Class Expected Return Std. Deviation US Japan Asia (non-Japan) Europe US 0.89% 4.34% 1.00 0.41 0.71 0.79 Japan 0.21% 5.97% 0.41 1.00 0.47 0.50 Asia (non-Japan) 0.96% 6.01% 0.71 0.47 1.00 0.75 Europe 0.74% 5.04% 0.79 0.50 0.75 1.00 4. Suppose you are currently invested 100% in U.S. stocks and you CANNOT...

Consider two stocks, D and E, with expected returns and volatilities given by E[rD]=15%, sD=20%, E[rE]=20%,...

Consider two stocks, D and E, with expected returns and volatilities given by E[rD]=15%, sD=20%, E[rE]=20%, sE=40%. The riskless rate is 2%. Consider now two portfolios P and Q with the following expected returns and standard deviations: E[rP]=16.2%, sP=18.77% and E[rQ]=16%, sQ=19.23%. These portfolios are formed by investing in stocks D and E and the riskless asset. It is known that one of these portfolios is a tangency portfolio for the efficient frontier constructed by investing in stocks D and...

Question