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

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

b. 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)

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

~~~~In Excel~~~~