Q1: (6’) List dates, Adj. close prices, and monthly holding period returns for the three companies. Q2: (6’) Compute monthly holding period return using Adj. close prices for each stock. Q3: (6’) Use the EXCEL statistical functions to compute mean (AVERAGE) and standard deviation (STDEV) of the monthly return for each stock. Assume that historical mean returns are good estimates of expected returns. To achieve diversification, John invests in APPLE and WALMART. Q4: What are the weights on the two stocks to achieve the optimal risky portfolio for John (4’)? What are the mean and standard deviation of returns on his optimal risky portfolio (4’)? Must show your calculation by including the formulas you used (4’). Mary instead invests in APPLE and GOLDMAN SACHS.