Excel Formulated Sheet.

Margarita is investing in three different shares, or creating three investment portfolios from two shares. Margarita considers herself a conservative investor. According to your analysis, the three financial instruments you have reviewed would provide you, in the 2019-2025 period, the returns indicated in the following table.

In any of the portfolios of two shares, the presence of each of them will be 60%. The three possible combinations for the creation of portfolios are AB, AC and BC.

Perform:

Create a spreadsheet.

1. Calculate the expected performance of each individual action.

2. Calculate the standard deviation of each individual action.

3. Calculate the expected patches of the AB, AC and BC portfolios.

4. Calculate the standard deviations of the AB, AC and BC portfolios.

5. Would you recommend that Margarita only in portfolio A or in a portfolio made up of shares A and B? Explain your answer from a risk-return point of view.

6. Would you recommend that Margarita invest only in B or in a portfolio made up of shares B and C? Explain your answer from a risk-return point of view.

Ao 2019 2020 2021 2022 2023 2024 Acciones A Acciones B Acciones C 11% 11% 13% 14% 12% 15% 16% 10% 11% 15% 13% 13% 17% 11% 11% 14% 16% 11% 13% 17% 12% 10/ 2025 Ao 2019 2020 2021 2022 2023 2024 Acciones A Acciones B Acciones C 11% 11% 13% 14% 12% 15% 16% 10% 11% 15% 13% 13% 17% 11% 11% 14% 16% 11% 13% 17% 12% 10/ 2025