1) The following table contains the covariance matrix for five assets. The mean returns are also given. D no 00D B 0.030 0.000 0.000 0.000 0.000 0.000 0.055 0.000 0.000 0.000 0.000 0.000 0.110 0.000 0.000 E 0.000 0.000 0.000 0.230 0.000 0.000 0.000 0.000 0.000 0.270 Mean Returns 0.032 0.041 0.053 0.061 0.074 Build a model using Excel's Solver functionality to find the optimal portfolio (no short sales permitted) when the risk-free rate is equal to a) 0% b) 1% c) 2% d) 3% e) 4% 1) The following table contains the covariance matrix for five assets. The mean returns are also given. D no 00D B 0.030 0.000 0.000 0.000 0.000 0.000 0.055 0.000 0.000 0.000 0.000 0.000 0.110 0.000 0.000 E 0.000 0.000 0.000 0.230 0.000 0.000 0.000 0.000 0.000 0.270 Mean Returns 0.032 0.041 0.053 0.061 0.074 Build a model using Excel's Solver functionality to find the optimal portfolio (no short sales permitted) when the risk-free rate is equal to a) 0% b) 1% c) 2% d) 3% e) 4%