Risk & Return Assignment - Individual Submission via dropbox (20 points) Obtain monthly stock-price data for the following stocks from Yahoo Finance Firm Name Amazon McDonald's Delta Air Lines Ticker Symbol AMZN MCD DAL Retrieve the data for the period of 1 December 2015 to 31 May 2018. Open all of the data files in Excel and copy and paste the data into one file - you will only need the adjusted closing price data for your analysis. Make sure you save your file as an Excel workbook (not CSV). In addition to the stocks listed above, also download monthly values for the S&P 500 Index for the same time period (from the main Yahoo Finance page go down to Markets Summary and select S&P 500 Index _ the Yahoo Finance ticker is GSPC). Include the S&P 500 index in your Excel files with the stock prices. Calculate monthly returns for each stock and the S&P 500 Index. a. Calculate the average monthly return and standard deviation of returns for all stocks and the S&P 500 index. b. Calculate the covariance and correlation between the returns for all pairs of stocks and between each stock and the S&P 500. c. Calculate the average monthly return and standard deviation of returns for an equally- weighted portfolio of the five stocks (i.e., the weight of each stock is 1/3 or 33.33 percent). Note: the best way to do this is to find the return to the portfolio for each month and then use the Excel AVERAGE and STDEV functions to find the average and standard deviation of the portfolio return series. The return to the portfolio in each month is just the weighted average of the returns for each stock for the month: Rpi -w1Ri + w2R2 + w3R3 (where Rpi is the return to the portfolio in month i) d. Find the beta for each of the stocks. Use the S&P 500 index as the market index