YYES WE CAN USE EXCEL

You have been given the following return data, E, on three assetsA, B, and C-over the period 2021-2024. Using these assets, you have isolated three investment alternatives: :: a. Calculate the average portfolio return for each of the three alternatives. b. Calculate the standard deviation of returns for each of the three alternatives. c. On the basis of your findings in parts a and b, which of the three investment alternatives would you recommend? Why? a. Calculate the portfolio return over the 4-year period for each of the 3 alternatives. Alternative 1: % (Round to two decimal places.) i Data Table i Data Table in order to copy its contents of the data table below into (Click on the icon here a spreadsheet.) in order to copy its contents of the data table below into (Click on the icon here a spreadsheet.) 9% Alternative Investment 100% of asset A 2 55% of asset A and 45% of asset B 3 55% of asset A and 45% of asset C Year 2021 2022 2023 2024 Expected Return Asset A Asset B Asset C 6% 3% 8% 5% 10% 7% 12% 9% 7% go 3% You have been given the following return data, E, on three assetsA, B, and C-over the period 2021-2024. Using these assets, you have isolated three investment alternatives: :: a. Calculate the average portfolio return for each of the three alternatives. b. Calculate the standard deviation of returns for each of the three alternatives. c. On the basis of your findings in parts a and b, which of the three investment alternatives would you recommend? Why? a. Calculate the portfolio return over the 4-year period for each of the 3 alternatives. Alternative 1: % (Round to two decimal places.) i Data Table i Data Table in order to copy its contents of the data table below into (Click on the icon here a spreadsheet.) in order to copy its contents of the data table below into (Click on the icon here a spreadsheet.) 9% Alternative Investment 100% of asset A 2 55% of asset A and 45% of asset B 3 55% of asset A and 45% of asset C Year 2021 2022 2023 2024 Expected Return Asset A Asset B Asset C 6% 3% 8% 5% 10% 7% 12% 9% 7% go 3%