USING EXCEL FORMULAS ONLY. ALSO, PLEASE SHOW ALL FORMULAS for Questions A-D THANK YOU

Portfolio analysis You have been given the expected return data shown in the first table on three assetsF, G, and IIover the period 20162019. Year 2016 2017 2018 2019 Asset F 17 18 19 Asset G 17% 16 15 14 Asset H 16 17 Using these assets, you have isolated the three investment alternatives shown in the following table. Alternative 2 3 Investment 100% of asset F 500/0 Of asset F and 500/0 Of asset G Of asset F and Of asset H a. Calculate the expected return over the 4-year period for each of the three alternatives. b. Calculate the standard deviation Of returns over the 4-year period for each Of the three alternatives. c. Use your findings in parts a and b to calculate the coefficient of variation for each of the three alternatives. d. On the basis Of your findings, which Of the three investment alternatives do you recommend? Why?