Question

show work in excel please An investor can design a risky portfolio based on two stocks,...

show work in excel please

An investor can design a risky portfolio based on two stocks, A and B. Stock A has an expected return of 15% and a standard deviation of return of 29%. Stock B has an expected return of 10% and a standard deviation of return of 14%. The correlation coefficient between the returns of A and B is .5. The risk-free rate of return is 5%. The proportion of the optimal risky portfolio that should be invested in stock B is approximately _________.

Homework Answers

Answer #1

Correlation of stock A and stock B = 0.5
SD of Stock A = 29%
SD of stock B = 14%
Covariance of the stock A and stock B = Correlation of (stock A, stock B) * SD of stock A* SD of stock B
= 0.5 * 29 * 14 = 203

Weight of stock A = [Expected Return of the stock A – Risk free rate]* Variance of Stock B – [Expected Return of the Stock B – Risk Free rate]* Covariance of the stock A & stock B/ [Expected Return of the stock A – Risk free rate]* Variance of Stock B + [Expected Return of the stock B – Risk Free rate]* Variance of the stock A – [Expected Return of the stock A – Risk free rate + Expected Return of the stock B – Risk Free rate]* Covariance of the stock A & stock B

= [0.15-0.05]*196 – [0.10-0.05]*203/ [0.15-0.05]*196 + [0.10 – 0.05]* 841 – [0.15- 0.05 + 0.10 – 0.05] * 203

Weights of the stock A = 9.45/ 31.20 = 30% (Approx Weight)

Weight of the stock B = 1- weight of the stock = 1-0.30 = 0.70 Or 70%.

The proportion of optimal risky portfolio invested in stock B is approximately 70%.

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
An investor can design a risky portfolio based on two stocks, A and B. Stock A...
An investor can design a risky portfolio based on two stocks, A and B. Stock A has an expected return of 17% and a standard deviation of return of 29%. Stock B has an expected return of 12% and a standard deviation of return of 14%. The correlation coefficient between the returns of A and B is .4. The risk-free rate of return is 6%. The proportion of the optimal risky portfolio that should be invested in stock B is...
An investor can design a risky portfolio based on two stocks, A and B. Stock A...
An investor can design a risky portfolio based on two stocks, A and B. Stock A has an expected return of 14% and a standard deviation of return of 26%. Stock B has an expected return of 9% and a standard deviation of return of 11%. The correlation coefficient between the returns of A and B is .5. The risk-free rate of return is 5%. The proportion of the optimal risky portfolio that should be invested in stock B is...
An investor can design a risky portfolio based on two stocks, A and B. Stock A...
An investor can design a risky portfolio based on two stocks, A and B. Stock A has an expected return of 16% and a standard deviation of return of 30%. Stock B has an expected return of 11% and a standard deviation of return of 15%. The correlation coefficient between the returns of A and B is .5. The risk-free rate of return is 5%. The proportion of the optimal risky portfolio that should be invested in stock B is...
An investor can design a risky portfolio based on two stocks, A and B. Stock A...
An investor can design a risky portfolio based on two stocks, A and B. Stock A has an expected return of 12% and a standard deviation of return of 28%. Stock B has an expected return of 9% and a standard deviation of return of 13%. The correlation coefficient between the returns of A and B is .5. The risk-free rate of return is 5%. The proportion of the optimal risky portfolio that should be invested in stock B is...
An investor can design a risky portfolio based on two stocks, A and B. Stock A...
An investor can design a risky portfolio based on two stocks, A and B. Stock A has an expected return of 25% and a standard deviation of return of 35%. Stock B has an expected return of 18% and a standard deviation of return of 28%. The correlation coefficient between the returns of A and B is .5. The risk-free rate of return is 6%. The proportion of the optimal risky portfolio that should be invested in stock B is...
An investor can design a risky portfolio based on two stocks, A and B. Stock A...
An investor can design a risky portfolio based on two stocks, A and B. Stock A has an expected return of 26% and a standard deviation of return of 39%. Stock B has an expected return of 15% and a standard deviation of return of 25%. The correlation coefficient between the returns of A and B is .5. The risk-free rate of return is 6%. The proportion of the optimal risky portfolio that should be invested in stock B is...
An investor can design a risky portfolio based on two stocks, A and B. Stock A...
An investor can design a risky portfolio based on two stocks, A and B. Stock A has an expected return of 21% and a standard deviation of return of 37%. Stock B has an expected return of 16% and a standard deviation of return of 22%. The correlation coefficient between the returns of A and B is .5. The risk-free rate of return is 6%. The proportion of the optimal risky portfolio that should be invested in stock B is...
An investor can design a risky portfolio based on two stocks, A and B. Stock A...
An investor can design a risky portfolio based on two stocks, A and B. Stock A has an expected return of 18% and a standard deviation of return of 34%. Stock B has an expected return of 13% and a standard deviation of return of 19%. The correlation coefficient between the returns of A and B is .5. The risk-free rate of return is 9%. The proportion of the optimal risky portfolio that should be invested in stock B is...
2. An investor can design a risky portfolio based on two stocks, S and B. Stock...
2. An investor can design a risky portfolio based on two stocks, S and B. Stock S has an expected return of 12% and a standard deviation of return of 25%. Stock B has an expected return of 10% and a standard deviation of return of 20%. The correlation coefficient between the returns of S and B is 0.4. The risk-free rate of return is 5% a. The proportion of the optimal risky portfolio that should be invested in stock...
An investor can design a risky portfolio based on two stocks, A and B. Stock A...
An investor can design a risky portfolio based on two stocks, A and B. Stock A has an expected return of 20% and a standard deviation of return of 18%. Stock B has an expected return of 11% and a standard deviation of return of 7%. The correlation coefficient between the returns of A and B is .29. The risk-free rate of return is 8%. The proportion of the optimal risky portfolio that should be invested in stock A is...