1) Code the necessary formulas in Columns G,H,I, and K

2)Create a graph of the frontier with your set of risky portfolios

3) Identify which one in the list is the optimal portfolio of U.S. equity Fund and REIT fund. Explain why you selected the one that you did

1) Code the necessary formulas in columns G,H,I and K

2) Creat a graph of the frontier with your set of risky portfolios

3) Identify which one in the list is the optimal portfolio of the US equity fund and the REIT fund. explain why

Review View Data Tell me what you Formulas File Insert Honte Page Layout Cut Be Wrap Text Arial * 10 AA BI U 1. Q. A Paste Merge & Center Format Painter Clipboard Font Alignment Q7 fi A B D 1 2. US REIT Equity mutual Fund fund 0.075 0.100 0.180 0.250 0.015 3 E[] 40 5 EIR perd oport) oleore) reward-to nisk ratio 6 7 8 9 10 10.009 11 12 13 80.74% 14 15 Weight in Weight in US Fund REIT Fund 0.00% 100.00% 5.00% 95.00% 90.00% 13.73% 86.27 19.26% 21.44% 78.56% 25.18% 74.82% 30.01% 69.99% 37.94% 62.06% 46.01% 53.9906 51.00% 49.000 57.49% 42.51% 69.72% 30.28% 75.84% 24.16% 82.53% 17.47% 89.82% 10.18% 94.96% 5.04% 100.00% 0.00% 16 17 18 19 20 21 22 24 25 26 27 bookch6 Sheet1 Ready O Type here to search