A) Create a portfolio by choosing 12 different stocks listed on stock exchange market representing 6 different industries (As mentioned in class try to choose opponents representing the same industry such Apple and Samsung), Download daily share price data for all companies along with S&P 500 for most recent five years (Please make sure you start from 1st of January 2016 and end on 31st of December 2020) Using close price, calculate the return series for each stock along with the average return, standard deviation and coefficient of variation.

B) Calculate the beta for each company. In this section you are expected to use two different approaches: the Analysis Toolpak of Excel and CAPM.

C) Calculate the correlation and variance-covariance matrix for your portfolio and discuss the risk and return findings of equally weighted and optimized portfolios formed in the Stock|Trak Based on your results, which companies would you choose for your portfolio? Explain with your empirical evidence along with conclusion and the written report