Question
Please show work. It can be done in excel if needed.
Expected Return Standard Deviation Correlation with Stock A Stock A Stock B 20% 25% 0% 10% 15% 5% 0.2 | ТВ
If you need an expected return of 12% and you only have the access to the two stocks above (but no access to TB), what is you
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Cinen, Stooded Expected areluny doñolor Srock A 1090 2011 Stock B 1510 . 2590 r(A,B) 10.2 Desired expected return from the po- J (0.6) (2013+ (0.4)(254+2(0.6) (0.43x0.2x 20x25 =J144+ 100+ 48 z 17.0990 Seatted-with- CamScanner

Add a comment
Know the answer?
Add Answer to:
Please show work. It can be done in excel if needed. Expected Return Standard Deviation Correlation...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • dont use excel solve using any equations 1. An investor has a risk aversion of 4....

    dont use excel solve using any equations 1. An investor has a risk aversion of 4. If she wants to invest all her wealth in the stock market that has a standard deviation of 16%. What is the implied risk premium of the market? What is the market risk premium if she has a risk aversion of only 2? 2. There are two stocks: A and B, and Treasury Bill (TB). The parameters of these securities are following: Expected Return...

  • Ad A z 1 Fonts 5 Paragraph Styles AD11423456 Voice LE TRAIL 5. (35 pts) There...

    Ad A z 1 Fonts 5 Paragraph Styles AD11423456 Voice LE TRAIL 5. (35 pts) There are two stocks: A and B, and Treasury Bill (TB). The parameters of these securities are following: Expected Return Standard Deviation Correlation with Stock A Stock A 10% 20% Stock B 15% 0.2 TB 0% 25% (20 pts. If you need an expected retum of 12% and you only have the access to the three securities above, what is your optimal portfolio composition? What...

  • You have a portfolio with a standard deviation of 24 % and an expected return of...

    You have a portfolio with a standard deviation of 24 % and an expected return of 18 % You are considering adding one of the two stocks in the following table. If after adding the stock you will have 20 % of your money in the new stock and 80 % of your money in your existing​ portfolio, which one should you​ add? Expected Return Standard Deviation Correlation with Your​ Portfolio's Returns Stock A 13 24 0.2 Stock B 13...

  • Please show work on excel with equations. Thank you 16 #5 Expected 17 Stock 18 Correlation...

    Please show work on excel with equations. Thank you 16 #5 Expected 17 Stock 18 Correlation with Standard Correlation with Correlation with Duke Energy Return Deviation Microsoft Wal-Mart 19 Duke Energy 14% 6% -1 20 Microsoft 44% 24% -1 0.7 21 Wal-Mart 23% 14% 0.7 22 23 (a) Usin above table, calculate the volatility of a portfolio that is equally invested in Duke Energy and Microsoft. 24 (b) Usin above table, calculate the volatility of a portfolio that is equally...

  • 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 19% and a standard deviation of return of 15.0%. Stock B has an expected return of 15% and a standard deviation of return of 6%. The correlation coefficient between the returns of A and B is 0.80. The risk-free rate of return is 11%. The proportion of the optimal risky portfolio that should be...

  • 3. Consider Table 3 Table 3 Stock Expected Return 10% 5% Standard Deviation 12% 8% Correlation...

    3. Consider Table 3 Table 3 Stock Expected Return 10% 5% Standard Deviation 12% 8% Correlation Coefficient 0.40 (a) Consider Table 3. Compute the expected return and standard deviation of return of an equally-weighted portfolio of stocks A and B (b) Consider Table 3. Solve for the composition, expected return and standard deviation of the minimum variance portfolio (c) Consider Table 3. Sketch the set of portfolios comprised of stocks A and B (d) Consider Table 3. Suppose that a...

  • You have a portfolio with a standard deviation of 26 % and an expected return of...

    You have a portfolio with a standard deviation of 26 % and an expected return of 17 %. You are considering adding one of the two stocks in the following table. If after adding the stock you will have 20 % of your money in the new stock and 80 % of your money in your existing​ portfolio, which one should you​ add? Expected Return Standard Deviation Correlation with your portfolios return Stock A          13%            25%                               0.3...

  • P 12-18 (similar to) 8 You have a portfolio with a standard deviation of 28% and an expected return of 20%. You are...

    P 12-18 (similar to) 8 You have a portfolio with a standard deviation of 28% and an expected return of 20%. You are considering adding one of the two stocks in the following table. If after adding the stock you will have 25% of your money in the new stock and 75% of your money in your existing portfolio, which one should you add? Expected Return Standard Correlation with Your Portfolio's Returns Deviation Stock A 16% 21% 0.2 Stock B...

  • You have a portfolio with a standard deviation of 30 % and .an expected return of...

    You have a portfolio with a standard deviation of 30 % and .an expected return of 15 %. You are considering adding one of the two stocks in the following table. If after adding the stock you will have 30 % of your money in the new stock and 70 % of your money in your existing​ portfolio, which one should you​ add? Expected Return: (ER) Standard Deviation:(STNDDEV) Correlation with Your​ Portfolio's Returns(Corr) Stock A (ER) 15​% (STNDDEV)25​% (Corr)0.3 Stock...

  • You have a portfolio with a standard deviation of 20% and an expected return of 20%....

    You have a portfolio with a standard deviation of 20% and an expected return of 20%. You are considering adding one of the two stocks in the following table. If after adding the stock you will have 20% of your money in the new stock and 80% of your money in your existing​ portfolio, which one should you​ add? Expected Return Standard Deviation Correlation with Your​ Portfolio's Returns Stock A 15​% 22​% 0.4 Stock B 15​% 18​% 0.6 Standard deviation...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT