What is the associated 5 year annual return on the equally weighted portfolio of a) your 2 sector stocks, and b) a portfolio of your 2 stocks and one stock from the healthcare sector, and c) a portfolio of your 2 stocks and the other stock from the healthcare sector?

What are the standard deviations of each of the 2 sector stocks, a 2 stock equally weighted portfolio of your sector stocks, an equally weighted portfolio of all 4 stocks. Provide commentary in 2-3 sentences.

Repeat the correlations tab for all stocks. Provide commentary in 2-3 sentences.

Adding which 1 stock to your 2 stock portfolio (equal weights) provides the greatest diversification benefit? What is the resulting average return and portfolio standard deviation? Which stock would provide the least diversification benefit? Provide 3-4 sentences of commentary.

 

5-YEAR ANNUAL RETURNS 2018 2019 2020 2021 2022 Industry: Sector: Adobe ADBE 25.57% 46.86% 49.54% 16.84% -40.37% Health Care: Large Pharma Autodesk ADSK 18.77% 42.14% 59.40% 42.14% -10.69% Health Care: Large Pharma Pfizer PFE US 19.79% 9.41% -0.79% 60.42% -9.55% Tech: Application Software AstraZeneca AZN Tech: 132.42% 28.87% -4.39% 16.92% 32.40% Application Software