You have been given the following retum data, on three assets-A, 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.) Alternative 2 % (Round to two decimal places.) Alternative 3: % (Round to two decimal places.) b. Calculate the standard deviation of returns over the 4-year period for each of the 3 alternatives. Alternative 1: % (Round to three decimal places.) Alternative 2: % (Round to three decimal places.) Alternative 3: % (Round to three decimal places.) c. On the basis of your findings in parts a and b, which of the 3 investment alternatives would you recommend? Why? (Select the best choice below.) O A. Alternative 3 has positively correlated assets; therefore, it is the least risky. OB. Alternative 1 has the highest average retum; therefore, it is the most attractive altemative. O C. Alternative 2 is the best choice: it is perfectly negatively correlated and has the least risk O D. Alternative 3 is the best choice: it is perfectly negatively correlated and has the least risk. Time Remaining: 02:15:15 Next three alternatives. of the three alternatives of the three inv For each of the 3 4-year period fo of the 3 investn Data table (Click on the icon here a spreadsheet.) Year 2021 2022 2023 2024 in order to copy its contents of the data table below into Expected Return Asset A Asset B Asset C 6% 11% 5% 8% 9% 7% 10% 7% 9% 12% 5% 11% Print Done X data,, on three assets-A, B, and C-over the period 2021-2024. Using these assets, you have isolated three investment alternatives: or each of the three alternatives. urns for each of the three alternatives. and b, which of the three investment alternatives would you recommend? Why? - X Data table --year period for each of the 3 al places.) (Click on the icon here in order to copy its contents of the data table below into a spreadsheet.) al places.) Alternative Investment 1 100% of asset A al places.) 2 60% of asset A and 40% of asset B urns over the 4-year period fo 3 60% of asset A and 40% of asset C mal places.) mal places.) Print Done mal places.) and b, which of the 3 investn ated assets; therefore, it is the least risky. age return; therefore, it is the most attractive alternative. is perfectly negatively correlated and has the least risk. is perfectly negatively correlated and has the least risk