You should use Excel to solve this. Please give a detailed solution and provide a screenshot of what you did in the excel function.

a. What is the average of the 60 monthly returns for each stock and the WILSHIRE 5000 3 index over the entire time period? Convert each this monthly average into an APR (annualized rate) by multiplying your monthly average for each stocks by 12 for each stock and the index. Please convert your answers to percentages.

b. Calculate the population standard deviation of monthly returns for each stock and the index using Excel.

c. Now calculate the beta for each stock using Excels Slope or Linest function to use estimate the slope of the linear regression line, which is beta. Use the WILSHIRE 5000 index as the market portfolio in finding beta.

d. Now use the CAPM/SML Equation to estimate each stocks required return. Use 10% as the required market return and the recent 1-year Treasury rate of 2.65% as the riskfree rate. Would you recommend buying ACTIVISION and/or Walmart if your APR average for each stock from #2 is your expected return? Explain your answer.

1, First download into Excel the ACTIVISION (ATVI), Walmart (WMT), and WILSHIRE 5000 Stock Index (AW5000) monthly price data for the 5-year period from the Sept 1, 2013 to Sept. 30, 2018 using the instructions outlined above. Using the Close (regular Close not Adj Close) price data for each month (the date given is the first trading day for that month: i.e. close price for the end of the month) to calculate the monthly percentage holding period returns for each stock and index where the previous month's Close price is the beginning of the month price and each month's Close price is the end of the month price. You can get rid of the other data provided for each month. In addition, you will need to include dividend payments for each stock to calculate monthly returns for the months that they made a dividend payment (the index doesn't have dividend payments). For example, September's monthly return is (Sept Close - Aug Close t any Sept Div)/Aug Close. You should have 60 monthly returns for each stock and index from Oct. 2013 to Sept. 2018. Helpful Hint: I strongly urge creating a table of the appropriate opening & closing prices and dividends for each stock along with opening and closing prices for the Wilshire Index on a separate worksheet and then do your calculations on this "fresh" worksheet. 1, First download into Excel the ACTIVISION (ATVI), Walmart (WMT), and WILSHIRE 5000 Stock Index (AW5000) monthly price data for the 5-year period from the Sept 1, 2013 to Sept. 30, 2018 using the instructions outlined above. Using the Close (regular Close not Adj Close) price data for each month (the date given is the first trading day for that month: i.e. close price for the end of the month) to calculate the monthly percentage holding period returns for each stock and index where the previous month's Close price is the beginning of the month price and each month's Close price is the end of the month price. You can get rid of the other data provided for each month. In addition, you will need to include dividend payments for each stock to calculate monthly returns for the months that they made a dividend payment (the index doesn't have dividend payments). For example, September's monthly return is (Sept Close - Aug Close t any Sept Div)/Aug Close. You should have 60 monthly returns for each stock and index from Oct. 2013 to Sept. 2018. Helpful Hint: I strongly urge creating a table of the appropriate opening & closing prices and dividends for each stock along with opening and closing prices for the Wilshire Index on a separate worksheet and then do your calculations on this "fresh" worksheet