Question

Question 2 (10 marks) Correlation Matrix Securities Expected Return E(Ri) Standard Deviation σi Google Microsoft Apple...

Question 2

Correlation Matrix

Securities

Expected

Return

E(Ri)

Standard Deviation

σi

Google

Microsoft

Apple

Market Portfolio

Google

19.2%

36%

1.0

0.7

0.6

0.5

Microsoft

21.9%

35%

1.0

0.5

0.6

Apple

12.0%

25%

1.0

0.4

Market

Portfolio

12.0%

10%

1.0

The risk-free interest rate is 3%.

  1. Given the correlation matrix, what is the covariance between Google and the Market?
  1. Given the correlation matrix, what is the beta of Microsoft?

  1. Show that Microsoft is priced according to the CAPM.
  1. What is the expected return and volatility of a portfolio that consists of a long position of $10,000 in Microsoft and a short position of $2,000 in Apple?        

Homework Answers

Answer #1

1.
=Correlation of stock with market*standard deviation of stock*standard deviation of market
=0.5*36%*10%=0.018

2.
=Correlation of stock with market*standard deviation of stock/standard deviation of market
=0.6*35%/10%=2.10

3.
required return=risk free rate+beta*(market return-risk free rate)=3%+2.10*(12%-3%)=21.9000%

As expected return is same as required return, Microsoft is correctly priced

4.
=sqrt((10000/8000*35%)^2+(-2000/8000*25%)^2+(10000/8000)*(-2000/8000)*35%*25%*0.5)
=42.6193%

Know the answer?
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
Similar Questions
Question 2(10 marks) Correlation Matrix Securities Expected Return Standard Deviation Google Microsoft Apple Market Portfolio Google...
Question 2 Correlation Matrix Securities Expected Return Standard Deviation Google Microsoft Apple Market Portfolio Google 19.2% 36% 1.0 0.7 0.6 0.5 Microsoft 21.9% 35% 1.0 0.5 0.6 Apple 12.0% 25% 1.0 0.4 Market Portfolio 12.0% 10% 1.0 The risk-free interest rate is 3%. Given the correlation matrix, what is the covariance between Google and the Market? Given the correlation matrix, what is the beta of Microsoft? Show that Microsoft is priced according to the CAPM. What is the expected return...
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 14% 6% 1.0 -1.0 0.0 Microsoft 44% 24% -1.0 1.0 0.7 Walmart 23% 14% 0.0 0.7 1.0 You create a 2 stock portfolio with $1,000,000. If you invest $600,000 in Walmart and the rest in Microsoft, what is the standard deviation of your portfolio? Group of answer choices 16.60% 18.75% 31.4% 2.76%
For this question, use the following data table: AT&T Microsoft Expected Return 0.10 0.21 Standard Deviation...
For this question, use the following data table: AT&T Microsoft Expected Return 0.10 0.21 Standard Deviation 0.15 0.25 a. What is the minimum-risk (standard deviation) portfolio allocation of AT&T and Microsoft if the correlation between the two stocks is 0? 0.5? 1? -1? What is the standard deviation of each of these minimum-risk portfolios? b. What is the optimal combination of these two securities in a portfolio for each of the four given values of the correlation coefficient, assuming the...
Asset E(R) Std. deviation A 17% 50% Market (M) 10% 20% Above is the expected return...
Asset E(R) Std. deviation A 17% 50% Market (M) 10% 20% Above is the expected return and standard deviation of a stock A and the market portfolio. The correlation coefficient between A and the market portfolio (M) is 0.5. The risk-free rate is 4% Based on CAPM, stock A is ____________ because it offers an alpha of ____________. A. underpriced; 7% B. underpriced; 5.5% C. overpriced; 5.5% D. underpriced; 0.5% E. overpriced; -0.5%
2. For this question, use the following data table: Expected Return Standard Deviation AT&T 0.10 0.15...
2. For this question, use the following data table: Expected Return Standard Deviation AT&T 0.10 0.15 Microsoft 0.21 0.25 What is the minimum-risk (standard deviation) portfolio allocation of AT&T and Microsoft if the correlation between the two stocks is 0? 0.5? 1?-1? What is the standard deviation of each of these minimum-risk portfolios?
Suppose Asset A has an expected return of 10% and a standard deviation of 20%. Asset...
Suppose Asset A has an expected return of 10% and a standard deviation of 20%. Asset B has an expected return of 16% and a standard deviation of 40%. If the correlation between A and B is 0.35, what are the expected return and standard deviation for a portfolio consisting of 30% Asset A and 70% Asset B? Plot the attainable portfolios for a correlation of 0.35. Now plot the attainable portfolios for correlations of +1.0 and −1.0. Suppose a...