9. Herbert Investments wants to prepare a portfolio made up of five stocks. They would like to have at least 10% of the portfolio in each stock and earn at least a 9.7% return at lowest possible risk BBX GTR HCT MMC PLB MEAN RETURN 0.07 0.09 0.1 0.095 0.12 STDEV OF RETURN (0) 0.05 0.15 0.18 0.16 0.20 CORRELATIONS (R) BBX GTR HCT MMC PLB BBX 1 0.62 0.41 0.16 0.33 GTR 0.62 1 0.51 0.67 0.29 HCT 0.41 0.51 1 0.36 0.27 MMC 0.16 0.67 0.36 1 0.42 PLB 0.33 0.29 0.27 0.42 1 a. Find the optimal solution using an Excel spreadsheet model and Solver. Attach your spreadsheet model with the optimal solution. BBX: 96 GTR 96 HCT: 96 MMC 96 PLB: 96 Portfolio standard deviation: 9. Herbert Investments wants to prepare a portfolio made up of five stocks. They would like to have at least 10% of the portfolio in each stock and earn at least a 9.7% return at lowest possible risk BBX GTR HCT MMC PLB MEAN RETURN 0.07 0.09 0.1 0.095 0.12 STDEV OF RETURN (0) 0.05 0.15 0.18 0.16 0.20 CORRELATIONS (R) BBX GTR HCT MMC PLB BBX 1 0.62 0.41 0.16 0.33 GTR 0.62 1 0.51 0.67 0.29 HCT 0.41 0.51 1 0.36 0.27 MMC 0.16 0.67 0.36 1 0.42 PLB 0.33 0.29 0.27 0.42 1 a. Find the optimal solution using an Excel spreadsheet model and Solver. Attach your spreadsheet model with the optimal solution. BBX: 96 GTR 96 HCT: 96 MMC 96 PLB: 96 Portfolio standard deviation