I need help figuring out questions 3), and 4) that is to the right of the table shown on the excel.

15 Excel File Edit View Insert Format Tools Data Window Help 26%D Thu 9:21 AM a FIN3312-summer2020-Ch567-stu Q Search Sheet Home Page Layout Formulas Data Review View + Share Insert * Cut Copy Arial 10 AutoSum A- A General Wrap Text X 49 Fill Paste U - A - E Merge & Center $ - % % ) 4.0 .00 .00 0 Insert Delete Format Format Conditional Format Formatting as Table Cell Styles Clear Sort & Filter R38 fx A B D E F G H J K L N M O - Q R S V T W 2 3 E[0] 4 o US REIT Equity mutual Fund fund 0.075 0.100 0.180 0.250 ri 0.015 Correlations Bond Stock 5 reward-to- risk ratio opor) E[Roord 6 7 olport) Bond Stock 1 0.15 8 1 0.1000 0.0988 9 0.25000 0.23902 0.22839 1) Code the necessary formulas in columns G, H, I, and K 1 1 1 1 0.0975 0.0966 0.0952 2) Create a graph of the frontier with your set of risky portfolios 1 0.0946 10 11 12 13 14 15 16 17 0.0937 0.06250 0.05713 0.05216 0.04873 0.04404 0.04234 0.03959 0.03637 0.03191 0.02843 0.02681 3) 1 1 Weight in US Fund 0.00% 5.00% 10.00% 13.73% 11 19.26% 21.44% 25.18% Wor 30.01% 37.94% 27040 46.01% 51.00% 57.49% *** 69.72% 75.84% 82.53% 89.82% 94.96% 100.00% Weight in REIT Fund 100.00% 95.00% 90.00% 86.27% 80.74% 20 78.56% 74.82% 69.99% 62.06% 53.99% 49.00% 42.51% 30.28% 24.16% 17.47% 10.18% 5.04% 0.00% Identify which one in the list is the optimal portfolio of the US Equity Fund and the REIT Fund ---> Explain why you selected the one you did: 1 0.0925 0.0905 0.0885 0.0872 0.34000 0.35040 0.36122 0.36952 0.38207 0.38706 0.39558 0.40637 0.42271 0.43589 0.44128 0.44401 0.43320 0.41972 0.39979 0.37364 0.35356 0.33333 0.22074 0.20987 0.20576 0.19896 0.19071 0.17864 0.16861 0.16373 0.15907 0.15598 0.15734 0.16100 0.16740 0.17327 4) 1 1 1 1 1 1 18 19 20 21 22 23 Suppose you do an investment process analysis and determine that you need an expected return of 6.35% to meet your objective. 0.0856 0.0826 0.0810 0.0794 0.02530 0.02433 0.02476 a) Find the combination of the optimal risky portfolio and Treasuries you would use. Show ALL work! Round to xx.yy% 0.02592 1 0.02802 1 0.0775 0.0763 0.0750 24 25 0.03002 1 0.03240 0.18000 Chart Title b) Determine the weights in all 3 assets. Round to xx.yy%. Show ALL work! 26 27 28 29 30 31 32 33 34 35 36 37 38 5) 39 40 41 0.3 0.25 0.2 0.15 0.1 0.05 0 c) If you have $10,000 to invest, determine the amount you would allocate to each asset. 0.22074 0.20987 0.23902 0.2282 0.20576 0.19896 0.19071 0.17864 0.16861 0.15907 0.16740 0.17327 0.18000 0.25000 0.16373 0.15598 0.16100 What CAL portfolio would you use instead of the frontier portfolio on row 24 ... 94.96% in US and 5.04% in REIT? (8 points) bookch6 Sheet1 + Ready B + 100% 15 Excel File Edit View Insert Format Tools Data Window Help 26%D Thu 9:21 AM a FIN3312-summer2020-Ch567-stu Q Search Sheet Home Page Layout Formulas Data Review View + Share Insert * Cut Copy Arial 10 AutoSum A- A General Wrap Text X 49 Fill Paste U - A - E Merge & Center $ - % % ) 4.0 .00 .00 0 Insert Delete Format Format Conditional Format Formatting as Table Cell Styles Clear Sort & Filter R38 fx A B D E F G H J K L N M O - Q R S V T W 2 3 E[0] 4 o US REIT Equity mutual Fund fund 0.075 0.100 0.180 0.250 ri 0.015 Correlations Bond Stock 5 reward-to- risk ratio opor) E[Roord 6 7 olport) Bond Stock 1 0.15 8 1 0.1000 0.0988 9 0.25000 0.23902 0.22839 1) Code the necessary formulas in columns G, H, I, and K 1 1 1 1 0.0975 0.0966 0.0952 2) Create a graph of the frontier with your set of risky portfolios 1 0.0946 10 11 12 13 14 15 16 17 0.0937 0.06250 0.05713 0.05216 0.04873 0.04404 0.04234 0.03959 0.03637 0.03191 0.02843 0.02681 3) 1 1 Weight in US Fund 0.00% 5.00% 10.00% 13.73% 11 19.26% 21.44% 25.18% Wor 30.01% 37.94% 27040 46.01% 51.00% 57.49% *** 69.72% 75.84% 82.53% 89.82% 94.96% 100.00% Weight in REIT Fund 100.00% 95.00% 90.00% 86.27% 80.74% 20 78.56% 74.82% 69.99% 62.06% 53.99% 49.00% 42.51% 30.28% 24.16% 17.47% 10.18% 5.04% 0.00% Identify which one in the list is the optimal portfolio of the US Equity Fund and the REIT Fund ---> Explain why you selected the one you did: 1 0.0925 0.0905 0.0885 0.0872 0.34000 0.35040 0.36122 0.36952 0.38207 0.38706 0.39558 0.40637 0.42271 0.43589 0.44128 0.44401 0.43320 0.41972 0.39979 0.37364 0.35356 0.33333 0.22074 0.20987 0.20576 0.19896 0.19071 0.17864 0.16861 0.16373 0.15907 0.15598 0.15734 0.16100 0.16740 0.17327 4) 1 1 1 1 1 1 18 19 20 21 22 23 Suppose you do an investment process analysis and determine that you need an expected return of 6.35% to meet your objective. 0.0856 0.0826 0.0810 0.0794 0.02530 0.02433 0.02476 a) Find the combination of the optimal risky portfolio and Treasuries you would use. Show ALL work! Round to xx.yy% 0.02592 1 0.02802 1 0.0775 0.0763 0.0750 24 25 0.03002 1 0.03240 0.18000 Chart Title b) Determine the weights in all 3 assets. Round to xx.yy%. Show ALL work! 26 27 28 29 30 31 32 33 34 35 36 37 38 5) 39 40 41 0.3 0.25 0.2 0.15 0.1 0.05 0 c) If you have $10,000 to invest, determine the amount you would allocate to each asset. 0.22074 0.20987 0.23902 0.2282 0.20576 0.19896 0.19071 0.17864 0.16861 0.15907 0.16740 0.17327 0.18000 0.25000 0.16373 0.15598 0.16100 What CAL portfolio would you use instead of the frontier portfolio on row 24 ... 94.96% in US and 5.04% in REIT? (8 points) bookch6 Sheet1 + Ready B + 100%