2. Choose from the common shares, 10 of which you would include in a common portfolio. Put the separate portfolios of each in an excel spreadsheet and the finally selected ones in a summary excel spreadsheet.

3. Read Appendix A pg. 105 in your e-book about the portfolio diversification.

4. Input the selected shares in the excel spreadsheet.

5. Find their mean returns and standard deviations based on monthly data of the last 2 years.

6. Build the correlation matrix based on monthly data of the last 2 years. The variance covariance matrix will be automatically populated once you complete points 5 and 6.

7. Calculate the minimum variance portfolio using excel solver and then plot the efficient frontier.

8. Define the optimal risky portfolio of your combined data and state the return and risk of it.

9. Is any of you going to change the synthesis of the portfolio following the results?

10. Show all your steps of calculation and define who (namely) will make changes in the portfolio. Apply the changes until December 26th, 2024. Re-evaluate your position in one week time.