Instructions You are supposed to do this assignment self-guided, I will not reply to emails asking me to provide more information. It is all clear in the questions. You can do this assignment alone or in groups of 2-3 people. Each person should submit an excel file on My courses and include their team members names in the name of the file. At the completion of your assignment please make sure you have the answers on a summary sheet(sheet 1) in your excel file as mentioned.

Question 1: Compute the average annualized return and standard deviation on each stock (need to see these on summary page) (this part overlooking dividends) a) Find the equity tickers on Bloomberg (or other) for the following 5 stocks: put them horizontally in the excel file; (example: Amazons ticker is: AMZN US equity). The stocks are: Alibaba Group Holding Ltd., Walt Disney Co, Align Technology Inc., Apple Inc., and Facebook > sheet 2 b) Copy paste the description of these stocks in sheet 3 (it is usually a little paragraph describing the company and its business; on Bloomberg: (you can use other than Bloomberg) c) Also in sheet 3, list at least three comparables for each stock d) Download the 5 year (if available) daily historical prices for the 5 stocks (in sheet 2): Under each stock ticker copy paste the historical Prices. Column a should contain the dates

Question 2: Create a Correlation and Covariance Matrix between every two stocks considered in this study in order to calculate the standard deviation of the portfolio of 5 stocks. (provide a copy of the matrix on the sheet called summary, please paste one under the other)

Question 3: Compute the E(r) and standard deviation of a portfolio: include results in summary sheet a) Equally weighted b) Invested 20%, 10%, 15%, 25%, 30%, respectively in the stocks: Alibaba Group Holding Ltd., Walt Disney Co, Align Technology Inc., Apple Inc., and Facebook.

Question 4: a) Find the minimum variance portfolio (use solver on excel). Defined by the weights. (a26, b26, c26, d26, e26)

Question 5: Choose your optimal portfolio according to your willingness to take risk. Basically, specify the weights you chose in every stock and tell me your thinking (you can use efficient frontier as a tool) summary page

Question 6: a) Identify the sectors in your portfolio (can find on Bloomberg, e.g: financials, retail, etc) and draw a pie chart showing me the breakdown summary page b) Using the chosen optimal portfolio. Assume you bought these stocks on Wednesday January 27th (the day we pitched the stocks); as of March 10th, 2021, what would have been your holding period return? (dont forget dividends here) c) Compare this return to S&P500 over the same period - (what was alpha?) Question 7: Consider I am your client. Explain to me the return vs the S&P500 index. What was your overperformance or underperformance attributed to?

Please get data from yahoofinance

and any parts you solve i will give good vote