Your project submission will be graded based on accuracy and the extent to which it is professionally executed. You should imagine yourself as an analyst who will submit a report to your director or client. In addition to getting the answer right, you want to make a good impression. Be concise, straight to the point, yet thorough and professional in your report, and have the firepower in your Excel model to back it up.

Part 1 (30 points: 20 excel + 10 report)

Returns, Risk and Correlations

Go to finance.yahoo.com and obtain the daily prices for MSFT, AAPL, TGT, and WMT over the year MM/DD/2018 to MM/DD/2019, where MM/DD corresponds to your birthday. Compute daily return for each stock for the entire sample period. Merge the returns for these firms into a single excel workbook with the returns for each company properly aligned.

1. Using the Excel functions for Average and Standard Deviation, calculate the average return and standard deviation for each of the firms. (10 points)
2. Using the Correlation function construct the correlation matrix for the firms using the daily returns for the entire period. (5 points)
3. Which pair of firms has the highest correlation coefficient? The lowest? (2 points)
4. If you have to choose two stocks for your portfolio, which pair would give you the greatest benefit with regard to diversification? Explain. (3 points)

answer part 1, 1 thru 4.

it is a mathematical question. need to go to finance.yahoo.com and follow the steps to answer all 4 parts