Answered You can hire a professional tutor to get the answer.

QUESTION

Can someone show me how to solve this in Excel?

Can someone show me how to solve this in Excel?

25-3) Stock A has an expected return of 12% and a standard deviation of 40%. Stock B has an expected return of 18% and a standard deviation of 60%. The correlation coefficient between Stock A and B is 0.2. What are the expected return and standard deviation of a portfolio invested 30% in Stock A and 70% in Stock B?

Weight of Stock A (WA) = 30% = 0.30Weight of Stock B (WB) = 70% = 0.70Expected return of Stock A (ERA) = 12% = 0.12Expected return of stock B (ERB) = 18% = 0.18Standard deviation of stock A...
Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question