Investment opportunity set:

(a) Using the expected returns and volatility numbers from previous question, plot your assets on the expected return-risk space.

(b) Use Solver in Excel to find 5 portfolios on the minimum-variance frontier. Start by finding the global minimum variance portfolio. Next, find 3 portfolios on the efficient frontier (expected return higher than expected return on global minimum variance portfolio) and 1 portfolio with expected return below expected return on global minimum variance portfolio. You are using solver to find 5 different sets of weights (i.e. portfolios) in the four ETFs you selected that will minimize volatility for 5 different levels of expected returns. Include a table that consists of the weights, expected return, volatility, and Sharpe ratio for the 5 different portfolios on the minimum-variance frontier in the Word file.

(c) Add the minimum-variance frontier to your risk-return plot. Include this plot in the Word document.

Please explain by step how to get the mkt_Rf

Returns on Assets the Group Selected Date QQQ USO AGG VGK Mkt_Rf 12/31/09 5.03% 0.33% -2.19% 4.17% 1/31/10 -6.31% -9.27% 2.05% -2.67% 2/28/10 4.60% 8.92% -0.11% -0.55% 3/31/10 7.60% 3.79% 0.00% 6.11% 4/30/10 2.35% 2.58% 0.97% -3.95% 5/31/10 -7.39% -17.64% 1.09% -13.31% 6/30/10 -6.34% -0.24% 1.76% -1.67% 7/31/10 7.67% 4.06% 0.87% 12.42% 8/31/10 -5.13% -9.68% 1.31% -4.80% 9/30/10 12.91% 9.15% 0.01% 10.12% 10/31/10 6.59% 0.95% 0.18% 4.66% 11/30/10 -0.17% 2.47% -0.85% -8.47% 12/31/10 4.55% 8.21% -1.26% 4.03% 1/31/11 3.03% -1.00% 0.76% 7.92% 2/28/11 3.16% 1.50% -0.01% 3.03% 3/31/11 -0.59% 8.70% -0.19% -1.04% Returns on Assets the Group Selected Date QQQ USO AGG VGK Mkt_Rf 12/31/09 5.03% 0.33% -2.19% 4.17% 1/31/10 -6.31% -9.27% 2.05% -2.67% 2/28/10 4.60% 8.92% -0.11% -0.55% 3/31/10 7.60% 3.79% 0.00% 6.11% 4/30/10 2.35% 2.58% 0.97% -3.95% 5/31/10 -7.39% -17.64% 1.09% -13.31% 6/30/10 -6.34% -0.24% 1.76% -1.67% 7/31/10 7.67% 4.06% 0.87% 12.42% 8/31/10 -5.13% -9.68% 1.31% -4.80% 9/30/10 12.91% 9.15% 0.01% 10.12% 10/31/10 6.59% 0.95% 0.18% 4.66% 11/30/10 -0.17% 2.47% -0.85% -8.47% 12/31/10 4.55% 8.21% -1.26% 4.03% 1/31/11 3.03% -1.00% 0.76% 7.92% 2/28/11 3.16% 1.50% -0.01% 3.03% 3/31/11 -0.59% 8.70% -0.19% -1.04%