4: 20 Points Investment company, PMBA Inc, intends to invest a given amount of money in four stocks (Stock A, Stock B, Stock C, and Stock D). From the past data, the means and standard deviations of annual returns have been estimated. The correlations among the annual returns on the stocks are also calculated. Stock Data A B C D Mean return 0.12 0.15 0.11 0.13 StDev of return () 0.07 0.06 0.09 0.07 Correlations (R) A B C D A 1 0.6 0.4 0.4 B 0.6 1 0.7 0.7 C 0.4 0.7 1 0.5 D 0.4 0.7 0.5 1 The company wants to find a minimum variance portfolio that yields an expected annual return of at least 10%. Answer A-C Below (A) Formulate the problem as a Nonlinear programming spreadsheet model. Use next worksheet tab "Q4 SS Model" to develop your formulation. (10 pts) Use tab "Q4 SS Model" (B) Solve the formulated model using Excel Solver.(5 pts) Use tab "Q4 SS Model" (C) What is the mix of stocks (percentage of each stock) that minimizes portfolio variance? (5 pts) Stock Fraction or % Stock A Stock B Stock C Stock D