PLEASE ANSWER THIS IN EXCEL!!!!!!!!!

. Assignment 10 Portfolios and Diversification Submit using Assignment tab in eLearning by uploading your completed excel file. Open a new (fresh) excel workbook to perform you work and make sure you highlight each answer and submit the same file you performed your calculations in. Your excel file has to be named to reflect your name and the assignment number (for example I may name my file: elashmawiamalA9) You are allowed only one submission, so please make sure it is the correct one. Work independently and do not use class exercise template (or any other template) This assignment is due before midnight on 7/23 The deadline for late submission and partial credit is midnight 7/24. No submission will be accepted beyond that date and time. . . Consider the following two funds and their estimated returns under different states of the economy State of Probability Estimated Return (Fund A) Estimated Return (Fund B) economy Great 30% 10% 25% Average 30% 15% 11% Poor 40% 20% 15% 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 If you invest $2,000 in Fund A and $8,000 in Fund B, Calculate the following: e. Portfolios' Expected Return f. Portfolio's Standard Deviation Bonus (1) Construct the complete covariance and correlation matrixes for A & B Bonus (2) Find the minimum variance portfolio using solver and report its variance, Standard Deviation and Expected Return