I need help figuring out question 4 in the excel. the question is to the right of the table

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