This is the assignment:

Use Yahoo! Finance or another site to get monthly pricing for the S&P 500 ETF (SPY), Coca-Cola, and Netflix for the past five years. Then, calculate the following using Excel and the provided instructions PDF: . Monthly returns for each stock . Average monthly return for each stock . Annualized returns based on the monthly average return for each stock . Standard deviation of monthly returns for each stock . Annualized standard deviation based on standard deviation of monthly returns 8. Calculate the monthly returns for each month. Remember that the Adj Close prices that you downloaded from Yahoo! include all dividends. Therefore, you can simply take the percentage change between each month for each stock. You can create another tab for the monthly returns, but you may prefer to keep this data in the same tab as the price data, since they are so closely linked. This will also allow you to scan and review the sets of data sideby-side for accuracy checks. A 1 2 3 git; .1 6/1/2012 5 7/1/2012 6 8/1/2012 7 I 9/1/2012 3 10/1/2012 9 11/1/2012 10 12/1/2012 1 1 1 1'1 hn1 : B 531 135.100006 131710007 141.160004 143320001 141350005 142149994 142.410004 1 JCI FDOED'J C _K_g 39.095001 40.400002 37.400002 37.93 37.13 37.919993 35.25 '2'! wannn": NFLX D 9.734286 8.121423 8.531428 7.777143 11.32 11.672857 13.227143 '1) ENCf1 l: E Dividend Adjusted Monthly DatawYahoo Finance (Citation below) 6 H I Monthly Returns E 52 1.18% 3.34% 47.00% 2.51% -?.43% 5.05% 1.99% 1.42% 418.4% 4.82% 4.98% 45.55% 0.57% 1.99% 3.12% 0.18% 74.40% 13.32% I: 1"!\" '1 79M 70 JAM In a :(BS/B4-1) formula, BS is the more recent date and B4 is the older date. The :(35/34-1} formula can be dragged by hovering over the bottom right corner ofthe cell until you see +. Once you see +, you can hold your left mouse button and drag that formula to other cells. If the stock price went down, you will have a negative result. 9. Create the Summary Table: You will create a table in the Table tab where you can aggregate all of the summary statistics side-by-side so they are easily comparable to one another. You can determine your columns and rows by the number of stocks in the table compared to the number of summary statistics you are placing in the table. You typically want the larger number to go down the rows and the lesser number to go across the columns. Here we have five summary statistics and three stocks, so you should place statistics down the rows and stocks across the columns. Dividend Adjusted Monthly Data -Yahoo Finance Monthly Returns Date SPY KO NFLX SPY KO NFLX 6/1/2018 249.1179 37.45387 391.43 0.04170354 7/1/2018 259.507 40.17392 337.45 8/1/2018 267.7904 38.39914 367.68 9/1/2018 268.1686 39.79483 374.13 10/1/2018 250.7671 41.60173 301.78 11/1/2018 255.4186 43.7913 286.13