PLEASE SOLVE USING EXCEL AND INCLUDE BONUS QUESTIONS TOO, THANK YOU!!!

Consider the following two funds and their estimated returns under different states of the economy:

Probability Asset A Asset B

25% 10% 20%

30% 14% 18%

15% 18% 14%

30% 20% 10%

Calculate the following:

a. Expected return for fund A and for fund B

b. Standard deviation of returns for fund A and fund B

c. Covariance between returns of fund A and fund B

d. Correlation between returns of fund A and fund B

e. Construct the complete covariance and correlation matrixes for A & B

If you invest $4,000 in Fund A and $6,000 in Fund B, Calculate the following:

f. Portfolios Expected Return

g. Portfolios Standard Deviation

Bonus:

Graph the attainable set of portfolios, then use solver to Find the minimum variance portfolio Make sure you label and highlight all required values.

Make sure you label and highlight all required values.