solve in excel Suppose you and your spouse are thinking of combining your investment portfolios. Both portfolios have two assets (A and B) with the following covariance matrix.

0.09 0.03

0.03 0.04

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. The value of your portfolio is $35,000 and the value of your spouses portfolio is $30,000.

a.What is the value of investments in both assets after combining the assets?

b.What is the expected return and the standard deviation of the combined portfolio? Use the matrix multiplication method to answer this part. Show all steps. (Use of other methods will result in no points for this part)

c.What is the correlation between assets A and B?