Question: Appendix 1.1: Table 1.1 - Weekly discrete rate of returns Week Date Apple Inc. (AAPL) McDonald's Corporation (MCD) Southwest Airlines Co. (LUV) S&P 500 Index
| Appendix 1.1: Table 1.1 - Weekly discrete rate of returns | |||||
| Week | Date | Apple Inc. (AAPL) | McDonald's Corporation (MCD) | Southwest Airlines Co. (LUV) | S&P 500 Index (GSPC) |
| 1 | 30-Oct-17 | ||||
| 2 | 6-Nov-17 | 1.2549% | -1.8187% | -1.1872% | -0.2141% |
| 3 | 13-Nov-17 | -2.2355% | 0.6847% | 2.2714% | -0.1336% |
| 4 | 20-Nov-17 | 2.8316% | 1.4330% | 0.7893% | 0.9140% |
| 5 | 27-Nov-17 | -2.2409% | 2.2269% | 8.6687% | 1.5293% |
| 6 | 4-Dec-17 | -0.9841% | 0.7554% | 5.6980% | 0.3512% |
| 7 | 11-Dec-17 | 2.7198% | 0.5289% | 2.3625% | 0.9168% |
| 8 | 18-Dec-17 | 0.5968% | -1.5205% | 1.9672% | 0.2814% |
| 9 | 25-Dec-17 | -3.3001% | 0.4109% | -0.7899% | -0.3626% |
| 10 | 1-Jan-18 | 3.4068% | 1.1225% | -1.7302% | 2.6010% |
| 11 | 8-Jan-18 | 1.1923% | -0.2775% | 1.6204% | 1.5708% |
| 12 | 15-Jan-18 | 0.7741% | 1.4668% | -0.4753% | 0.8635% |
| 13 | 22-Jan-18 | -3.8916% | 1.2742% | -6.5013% | 2.2265% |
| 14 | 29-Jan-18 | -6.4234% | -5.0327% | -3.4767% | -3.8547% |
| 15 | 5-Feb-18 | -2.5435% | -5.0677% | -5.4626% | -5.1620% |
| 16 | 12-Feb-18 | 10.6908% | -1.8712% | 5.0018% | 4.3011% |
| 17 | 19-Feb-18 | 1.7815% | 3.3355% | -0.4815% | 0.5519% |
| 18 | 26-Feb-18 | 0.4004% | -9.0662% | -0.3110% | -2.0402% |
| 19 | 5-Mar-18 | 2.1421% | 6.7192% | 3.2588% | 3.5418% |
| 20 | 12-Mar-18 | -1.0876% | 3.2562% | 2.2327% | -1.2402% |
| 21 | 19-Mar-18 | -7.3475% | -4.5455% | -6.8637% | -5.9502% |
| 22 | 26-Mar-18 | 1.7224% | 0.9033% | 0.9873% | 2.0326% |
| 23 | 2-Apr-18 | 0.3530% | 3.1142% | -3.4742% | -1.3783% |
| 24 | 9-Apr-18 | 3.7739% | 0.2977% | -0.3979% | 1.9900% |
| 25 | 16-Apr-18 | -5.1591% | -1.8302% | -0.5448% | 0.5210% |
| 26 | 23-Apr-18 | -2.0475% | -0.2960% | -2.2640% | -0.0086% |
| 27 | 30-Apr-18 | 13.2468% | 4.2514% | -1.4011% | -0.2431% |
| 28 | 7-May-18 | 2.5939% | 0.2181% | -0.6063% | 2.4142% |
(i) Compute the weekly rate of return and the variance of an equally weighted portfolio formed from the three stocks
(ii) Examine and compare the pattern of the returns of your portfolio with those of the individual stocks, and the stock index. Compare the corresponding variances. Comment on your observations
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help