Question: 4. The Excel file Stock Data contains monthly price data for eight (8) stocks. a. Use continuous returns and the Matrix of Excess Returns to

4. The Excel file Stock Data contains monthly price data for eight (8) stocks. a. Use continuous returns and the Matrix of Excess Returns to compute the Variance- Covariance Matrix for these eight (8) stocks. (Do not use the varcovar VBA function) b. Use the Variance - Covariance Matrix for these eight (8) stocks to compute the individual stock proportions for the Global Minimum Variance Portfolio (GMVP). Calculate the Expected Return and Risk (Standard Deviation) for the Global Minimum Variance Portfolio (GMVP). C. C A 1 Stock Data 2 PRICES FOR 8 STOCKS 3 4 5 6 7 3 Month 1 2 3 4 0 1 2 3 5 6 7 8 9 10 11 12 13 14 15 16 17 MCD 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 62.97 66.66 70.36 71.76 MSFT 19.74 22.46 22.22 23.42 24.44 26.34 28.06 29.09 26.89 27.49 28.08 29.28 24.85 22.16 24.86 22.72 23.71 AAPL 135.81 142.43 163.39 168.21 185.35 188.50 199.91 210.73 192.06 204.62 235.00 261.09 256.88 251.53 257.25 243.10 283.75 GE 12.41 10.88 12.44 12.90 15.33 13.32 14.96 14.22 15.11 15.19 17.21 17.84 15.46 13.72 15.34 13.78 15.58 BAC 11.16 13.08 14.66 17.43 16.78 14.46 15.72 14.94 15.06 16.53 17.72 17.70 PFE 13.58 13.41 14.24 15.08 14.94 15.37 16.56 16.58 17.01 16.15 15.78 15.38 14.16 13.26 13.95 14.96 16.14 XOM 64.83 65.35 65.80 - 65.03 64.53 67.40 71.01 64.50 60.95 61.89 63.77 64.52 57.96 54.71 57.21 57.07 59.65 IBM 919.14 919.32 987.48 1020.62 1057.08 1036.19 1095.63 1115.10 1073.87 1104.49 1169.43 1186.69 1089.41 1030.71 1101.60 1049.33 1141.20 15.63 14.28 13.95 12.38 13.03 4. The Excel file Stock Data contains monthly price data for eight (8) stocks. a. Use continuous returns and the Matrix of Excess Returns to compute the Variance- Covariance Matrix for these eight (8) stocks. (Do not use the varcovar VBA function) b. Use the Variance - Covariance Matrix for these eight (8) stocks to compute the individual stock proportions for the Global Minimum Variance Portfolio (GMVP). Calculate the Expected Return and Risk (Standard Deviation) for the Global Minimum Variance Portfolio (GMVP). C. C A 1 Stock Data 2 PRICES FOR 8 STOCKS 3 4 5 6 7 3 Month 1 2 3 4 0 1 2 3 5 6 7 8 9 10 11 12 13 14 15 16 17 MCD 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 62.97 66.66 70.36 71.76 MSFT 19.74 22.46 22.22 23.42 24.44 26.34 28.06 29.09 26.89 27.49 28.08 29.28 24.85 22.16 24.86 22.72 23.71 AAPL 135.81 142.43 163.39 168.21 185.35 188.50 199.91 210.73 192.06 204.62 235.00 261.09 256.88 251.53 257.25 243.10 283.75 GE 12.41 10.88 12.44 12.90 15.33 13.32 14.96 14.22 15.11 15.19 17.21 17.84 15.46 13.72 15.34 13.78 15.58 BAC 11.16 13.08 14.66 17.43 16.78 14.46 15.72 14.94 15.06 16.53 17.72 17.70 PFE 13.58 13.41 14.24 15.08 14.94 15.37 16.56 16.58 17.01 16.15 15.78 15.38 14.16 13.26 13.95 14.96 16.14 XOM 64.83 65.35 65.80 - 65.03 64.53 67.40 71.01 64.50 60.95 61.89 63.77 64.52 57.96 54.71 57.21 57.07 59.65 IBM 919.14 919.32 987.48 1020.62 1057.08 1036.19 1095.63 1115.10 1073.87 1104.49 1169.43 1186.69 1089.41 1030.71 1101.60 1049.33 1141.20 15.63 14.28 13.95 12.38 13.03

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Refer to the problem and compute the Federal income tax payable. 41. Saanvi Patel (Social Security number 123-45-6785), single and age 32, lives at 3218 Columbia Drive, Spokane, WA 99210. She is...

4. The Excel file Stock Data contains monthly price data for eight (8) stocks. a. use continuous returns and the Matrix of Excess Returns to compute the Variance- Covariance Matrix for these eight...

The Excel file Stock Data contains monthly price data for eight (8) stocks. a. Use continuous returns and the Matrix of Excess Returns to compute the Variance- Covariance Matrix for these eight (8)...

I need step by step instructions on how to do the following: The Excel file Stock Data contains monthly return data for eight (8) stocks. a. Use these returns and the Matrix of Excess Returns to...

4. The Excel file Stock Data contains monthly return data for seven (7) stocks. a. Use these returns and the Matrix of Excess Returns to compute the Variance-Covariance Matrix for these seven (7)...

4. The Excel file Stock Data contains monthly return data for five (5) stocks. a. Use these returns and the Matrix of Excess Returns to compute the Variance-Covariance Matrix for these five (5)...

The Excel file Stock Data contains monthly price data for eight (8) stocks. Use continuous returns and the Matrix of Excess Returns to compute the Variance-Covariance Matrix for these eight (8)...

please show work in excel 4. The Excel file Stock Data contains monthly return data for seven (7) stocks. a. Use these returns and the Matrix of Excess Returns to compute the Variance-Covariance...

4. The Excel file Stock Data contains monthly return data for seven (7) stocks. a. Use these returns and the Matrix of Excess Returns to compute the Variance-Covariance Matrix for these seven (7)...

The Excel file Stock Data con ta ins monthly return data for seven ( 7 ) stoc ks . a. Us e these returns and the Matrix of Excess Returns to compute the Varianc e- Covariance Matrix for these seven (...

The Excel file Stock Data contains monthly return data for four ( 4 ) stocks. a . Use these returns and the Matrix of Excess Returns to compute the Variance - Covariance Matrix for these four ( 4 )...

Five cards are dealt from a well-shuffled pack of 52 cards. Calculate the probability of getting : (i) Three of a kind i.e five cards of one rank, the other two being of a different rank and unequal...

Exercise 2.12. Let F(x) = r+. For each to ER find lim In = F"(xo) if it exists.

Cash flow is the _ _ _ _ _ _ _ _ that allows to pay the bills, including in a timely manner. Question 1 5 options: Revenue Liquidity Profit

Fox Co. is considering an investment that will have the following sales, variable costs, and fixed operating costs: Year 1 Year 2 Year 3 Year 4 5,820 $42.57 $43.55 $44.76 $46.79 $22.83 $22.97 $23.45...