Include an Excel file which shows the detailed calculation and all your answers to the questions asked in the project

Part One: Portfolio Management Go to http://finance.yahoo.com, download monthly Adj. close prices (adjusted for dividend and stock split) from 01/01/2016 through 12/01/2021 for the following three companies. You can use a monthly risk free rate of 0.08% for related analysis.

Company Ticker APPLE AAPL WALMART WMT GOLDMAN SACHS GS

Q1: (6') List dates, Adj. close prices 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. Q5: What are the weights on the two stocks to achieve the optimal risky portfolio for Mary (4')? What are the mean and standard deviation of returns on her optimal risky portfolio (4')? Must show your calculation by including the formulas you used (2'). Q6: Discuss whose optimal portfolio performs better (John or Mary) (5'), and explain why (5').