Question: Please post in excel format thank you. Question 2 Suppose you and your spouse are thinking of combining your investment portfolios. Both portfolios have two

Please post in excel format thank you.

Question 2 Suppose you and your spouse are thinking of combining your investment portfolios. Both portfolios have two assets (A and B). Variance of the asset A and B are 0.09 and 0.04, respectively, and covariance between the assets is 0.03. The expected return of asset A is 10% and the expected return of asset B is 7%. Suppose the riskless asset has an expected return of 3%. You have 75% invested in asset A, while your spouse has 55% invested in asset A. Value of your portfolio is $35,000 and value of your spouses portfolio is $30,000. What is the value of investments in both assets after combining the assets? (6 points) What is the expected return and the standard deviation of the combined portfolio? Use matrix multiplication method to answer this part. Show all steps. (12 Points) What is the correlation between assets A and B? (2 points)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!