3_mcd_beta.xlsx
Sheet1
| Date | Adj Close* | | Adj Close* | BETA | 0.320 | 0.677 |
| 9-Jun-10 | 56.13 | | 1,030.71 | | | 1/2 Half of data |
| 1-Jul-10 | 59.42 | 5.86% | 1,101.60 | 6.88% |
| 2-Aug-10 | 62.72 | 5.55% | 1,049.33 | -4.74% |
| 1-Sep-10 | 63.97 | 1.99% | 1,141.20 | 8.76% |
| 1-Oct-10 | 66.77 | 4.38% | 1,183.26 | 3.69% |
| 1-Nov-10 | 67.75 | 1.47% | 1,180.55 | -0.23% |
| 1-Dec-10 | 66.41 | -1.98% | 1,257.64 | 6.53% |
| 3-Jan-11 | 63.74 | -4.02% | 1,286.12 | 2.26% |
| 1-Feb-11 | 66.02 | 3.58% | 1,327.22 | 3.20% |
| 1-Mar-11 | 66.37 | 0.53% | 1,325.83 | -0.10% |
| 1-Apr-11 | 68.31 | 2.92% | 1,363.61 | 2.85% |
| 2-May-11 | 71.66 | 4.90% | 1,345.20 | -1.35% |
| 1-Jun-11 | 74.1 | 3.40% | 1,320.64 | -1.83% |
| 1-Jul-11 | 76 | 2.56% | 1,292.28 | -2.15% |
| 1-Aug-11 | 79.99 | 5.25% | 1,218.89 | -5.68% |
| 1-Sep-11 | 77.7 | -2.86% | 1,131.42 | -7.18% |
| 3-Oct-11 | 82.15 | 5.73% | 1,253.30 | 10.77% |
| 1-Nov-11 | 85.15 | 3.65% | 1,246.96 | -0.51% |
| 1-Dec-11 | 89.43 | 5.03% | 1,257.60 | 0.85% |
| 3-Jan-12 | 88.29 | -1.27% | 1,312.41 | 4.36% |
| 1-Feb-12 | 89.12 | 0.94% | 1,365.68 | 4.06% |
| 1-Mar-12 | 88.06 | -1.19% | 1,408.47 | 3.13% |
| 2-Apr-12 | 87.48 | -0.66% | 1,397.91 | -0.75% |
| 1-May-12 | 80.83 | -7.60% | 1,310.33 | -6.27% |
| 1-Jun-12 | 80.09 | -0.92% | 1,362.16 | 3.96% |
| 2-Jul-12 | 80.84 | 0.94% | 1,379.32 | 1.26% |
| 1-Aug-12 | 81.6 | 0.94% | 1,406.58 | 1.98% |
| 4-Sep-12 | 83.66 | 2.52% | 1,440.67 | 2.42% |
| 1-Oct-12 | 79.15 | -5.39% | 1,412.16 | -1.98% |
| 1-Nov-12 | 80.08 | 1.17% | 1,416.18 | 0.28% |
| 3-Dec-12 | 81.15 | 1.34% | 1,426.19 | 0.71% |
| 2-Jan-13 | 87.67 | 8.03% | 1,498.11 | 5.04% |
| 1-Feb-13 | 88.94 | 1.45% | 1,514.68 | 1.11% |
| 1-Mar-13 | 92.45 | 3.95% | 1,569.19 | 3.60% |
| 1-Apr-13 | 94.73 | 2.47% | 1,597.57 | 1.81% |
| 1-May-13 | 90.26 | -4.72% | 1,630.74 | 2.08% |
| 3-Jun-13 | 92.53 | 2.51% | 1,606.28 | -1.50% |
| 1-Jul-13 | 91.67 | -0.93% | 1,685.73 | 4.95% |
| 1-Aug-13 | 88.91 | -3.01% | 1,632.97 | -3.13% |
| 3-Sep-13 | 90.65 | 1.96% | 1,681.55 | 2.97% |
| 1-Oct-13 | 90.94 | 0.32% | 1,756.54 | 4.46% |
| 1-Nov-13 | 92.51 | 1.73% | 1,805.81 | 2.80% |
| 2-Dec-13 | 92.19 | -0.35% | 1,848.36 | 2.36% |
| 2-Jan-14 | 89.47 | -2.95% | 1,782.59 | -3.56% |
| 3-Feb-14 | 91.17 | 1.90% | 1,859.45 | 4.31% |
| 3-Mar-14 | 93.93 | 3.03% | 1,872.34 | 0.69% |
| 1-Apr-14 | 97.14 | 3.42% | 1,883.95 | 0.62% |
| 1-May-14 | 97.97 | 0.85% | 1,923.57 | 2.10% |
| 2-Jun-14 | 97.3 | -0.68% | 1,960.23 | 1.91% |
| 1-Jul-14 | 91.33 | -6.14% | 1,930.67 | -1.51% |
| 1-Aug-14 | 91.3 | -0.03% | 2,003.37 | 3.77% |
| 2-Sep-14 | 92.37 | 1.17% | 1,972.29 | -1.55% |
| 1-Oct-14 | 91.31 | -1.15% | 2,018.05 | 2.32% |
| 3-Nov-14 | 95.15 | 4.21% | 2,067.56 | 2.45% |
| 1-Dec-14 | 92.09 | -3.22% | 2,058.90 | -0.42% |
| 2-Jan-15 | 90.85 | -1.35% | 1,994.99 | -3.10% |
| 2-Feb-15 | 98.05 | 7.93% | 2,104.50 | 5.49% |
| 2-Mar-15 | 96.6 | -1.48% | 2,067.89 | -1.74% |
| 1-Apr-15 | 95.72 | -0.91% | 2,085.51 | 0.85% |
| 1-May-15 | 95.93 | 0.22% | 2,107.39 | 1.05% |
| 1-Jun-15 | 95.32 | -0.64% | 2,079.28 | -1.33% |
Coger01
