Today is October 30, 2020, and you have just started your new job with a financial planning firm. You have been asked to review a portion of a clients stock portfolio to determine the risk/return profiles of 6 stocks in the portfolio. Unfortunately, your small firm cannot afford the expensive databases that would provide all this information with a few simple keystrokes, but thats why they hired you.

Specifically, you have been asked to determine the monthly average returns and standard deviations for the 6 stocks for the past five years.

4. Add a column in your Excel worksheet with the monthly return to an equally weighted portfolio of these stocks. Compute the mean and standard deviation of monthly returns for the equally weighted portfolio. Double-check that the average return on this equally weighted portfolio is equal to the average return of all of the individual stocks. Convert these monthly statistics to annual statistics (as described in step 3) for interpretation.

- WBA, Walgreens Boots Alliance, inc.

- ARNA, Arena Pharmaceuticals, inc.

- LUV, Southwest Airlines Co.

- ACAD, ACADIA Pharmaceuticals Inc.

- PANW, Palo Alto Networks, Inc.

- AMD, Advanced Micro Devices, Inc

please show the steps