1. The Excel file Stock Data contains monthly price data for five (5) stocks.
2. 1. Compute the Matrix of Excess Returns for each of the five (5) stocks using continuous returns.
   2. Use the Matrix of Excess Returns to compute the Sample Variance-Covariance Matrix for these five (5) stocks. (Do not use the Varcovar VBA function)
   3. Use the Sample Variance - Covariance Matrix for these five (5) stocks to compute the Global Minimum Variance Portfolio (GMVP).
   4. Calculate the Expected Return and Risk for the Global Minimum Variance Portfolio (GMVP).

* Please show all work

PRICES FOR 5 STOCKS Month 1 2 2 3 4 5 6 MSFT 17.25 19.02 19.74 22.46 22.22 23.42 24.44 26.34 28.06 29.09 26.89 27.49 7 MCD 50.00 48.83 54.05 53.11 50.86 52.41 53.19 54.62 59.45 58.69 58.68 60.53 63.25 66.92 63.92 64.00 68.00 72.00 75.00 000 AAPL 105.12 125.83 135.81 142.43 163.39 168.21 185.35 188.50 199.91 210.73 192.06 204.62 235.00 261.09 260.00 275.00 278.00 280.00 285.00 GE 11.00 11.65 12.41 10.88 12.44 12.90 15.33 13.32 14.96 14.22 15.11 15.19 17.21 18.00 19.00 20.00 22.00 23.00 24.00 BAC 14.00 12.00 11.16 13.08 14.66 17.43 16.78 14.46 15.72 14.94 15.06 16.53 17.72 18.00 19.00 21.00 22.00 24.00 26.00 10 11 12 13 14 15 16 28.08 29.28 24.85 25.00 27.00 24.00 25.00 17 18 19 PRICES FOR 5 STOCKS Month 1 2 2 3 4 5 6 MSFT 17.25 19.02 19.74 22.46 22.22 23.42 24.44 26.34 28.06 29.09 26.89 27.49 7 MCD 50.00 48.83 54.05 53.11 50.86 52.41 53.19 54.62 59.45 58.69 58.68 60.53 63.25 66.92 63.92 64.00 68.00 72.00 75.00 000 AAPL 105.12 125.83 135.81 142.43 163.39 168.21 185.35 188.50 199.91 210.73 192.06 204.62 235.00 261.09 260.00 275.00 278.00 280.00 285.00 GE 11.00 11.65 12.41 10.88 12.44 12.90 15.33 13.32 14.96 14.22 15.11 15.19 17.21 18.00 19.00 20.00 22.00 23.00 24.00 BAC 14.00 12.00 11.16 13.08 14.66 17.43 16.78 14.46 15.72 14.94 15.06 16.53 17.72 18.00 19.00 21.00 22.00 24.00 26.00 10 11 12 13 14 15 16 28.08 29.28 24.85 25.00 27.00 24.00 25.00 17 18 19