Date | Stock Monthly Price (Adjusted Price) | Index Monthly Price (Close) | Stock Returns | Market Index Returns. | Risk Free Rate of Return | Excess Stock Returns | Excess Market Returns | |
A | B | C | D | E | F | G | H | |
1 | 09/12/2019 | 19.50 | 966.06 | -6.25% | 0.70% | 5% | -11.25% | -4.30% |
2 | 02/12/2019 | 20.80 | 959.31 | 2.46% | -1.75% | 5% | -2.54% | -6.75% |
3 | 25/11/2019 | 20.30 | 976.35 | -0.49% | -2.65% | 5% | -5.49% | -7.65% |
4 | 18/11/2019 | 20.40 | 1,002.91 | -0.78% | -1.36% | 5% | -5.78% | -6.36% |
5 | 11/11/2019 | 20.56 | 1,016.75 | -0.72% | -0.56% | 5% | -5.72% | -5.56% |
6 | 04/11/2019 | 20.71 | 1,022.43 | 1.87% | 2.60% | 5% | -3.13% | -2.40% |
7 | 28/10/2019 | 20.33 | 996.48 | -1.83% | 1.31% | 5% | -6.83% | -3.69% |
8 | 21/10/2019 | 20.71 | 983.56 | -0.86% | -1.01% | 5% | -5.86% | -6.01% |
9 | 14/10/2019 | 20.89 | 993.57 | 2.30% | 1.07% | 5% | -2.70% | -3.93% |
10 | 07/10/2019 | 20.42 | 983.09 | 1.64% | -1.35% | 5% | -3.36% | -6.35% |
11 | 30/09/2019 | 20.09 | 996.56 | -1.62% | 1.10% | 5% | -6.62% | -3.90% |
12 | 23/09/2019 | 20.42 | 985.75 | -4.45% | -0.42% | 5% | -9.45% | -5.42% |
13 | 16/09/2019 | 21.37 | 989.86 | -0.65% | 1.62% | 5% | -5.65% | -3.38% |
14 | 09/09/2019 | 21.51 | 974.12 | -0.65% | -0.54% | 5% | -5.65% | -5.54% |
15 | 03/09/2019 | 21.65 | 979.36 | -4.58% | -0.36% | 5% | -9.58% | -5.36% |
16 | 26/08/2019 | 22.69 | 982.88 | -0.44% | 0.19% | 5% | -5.44% | -4.81% |
17 | 19/08/2019 | 22.79 | 981.03 | -3.60% | 0.59% | 5% | -8.60% | -4.41% |
18 | 12/08/2019 | 23.64 | 975.31 | -2.52% | 0.22% | 5% | -7.52% | -4.78% |
19 | 05/08/2019 | 24.25 | 973.15 | -0.57% | -2.48% | 5% | -5.57% | -7.48% |
20 | 29/07/2019 | 24.39 | 997.94 | -1.18% | 1.62% | 5% | -6.18% | -3.38% |
21 | 22/07/2019 | 24.68 | 982.04 | -2.41% | -0.01% | 5% | -7.41% | -5.01% |
22 | 16/07/2019 | 25.29 | 982.11 | -0.94% | 1.63% | 5% | -5.94% | -3.37% |
23 | 08/07/2019 | 25.53 | 966.35 | -1.47% | 0.08% | 5% | -6.47% | -4.92% |
24 | 01/07/2019 | 25.91 | 965.61 | 0% | 0.29% | 5% | -5% | -4.71% |
25 | 24/06/2019 | 25.91 | 962.85 | -0.15% | 1.68% | 5% | -5.15% | -3.32% |
26 | 17/06/2019 | 25.95 | 946.95 | 2.21% | -1.66% | 5% | -2.79% | -6.66% |
27 | 10/06/2019 | 25.39 | 962.90 | -0.90% | 1.74% | 5% | -5.90% | -3.26% |
28 | 03/06/2019 | 25.62 | 946.47 | -0.39% | -2.94% | 5% | -5.39% | -7.94% |
29 | 27/05/2019 | 25.72 | 975.14 | -1.04% | -1.21% | 5% | -6.04% | -6.21% |
30 | 20/05/2019 | 25.99 | 987.13 | -2.70% | 2.98% | 5% | -7.70% | -2.02% |
31 | 13/05/2019 | 26.71 | 958.54 | -3.29% | 0.06% | 5% | -8.29% | -4.94% |
32 | 06/05/2019 | 27.62 | 957.97 | -1.92% | -2.10% | 5% | -6.92% | -7.10% |
33 | 02/05/2019 | 28.16 | 978.50 | 1.62% | 1.31% | 5% | -3.38% | -3.69% |
34 | 22/04/2019 | 27.71 | 965.86 | -3.01% | -1.16% | 5% | -8.01% | -6.16% |
35 | 16/04/2019 | 28.57 | 977.17 | 3.44% | -2.04% | 5% | -1.56% | -7.04% |
36 | 08/04/2019 | 27.62 | 997.56 | 3.06% | 0.91% | 5% | -1.94% | -4.09% |
37 | 01/04/2019 | 26.80 | 988.53 | -0.67% | 1.90% | 5% | -5.67% | -3.10% |
38 | 25/03/2019 | 26.98 | 970.07 | 0.67% | -4.13% | 5% | -4.33% | -9.13% |
39 | 18/03/2019 | 26.80 | 1,011.86 | 3.47% | 2.77% | 5% | -1.53% | -2.23% |
40 | 11/03/2019 | 25.90 | 984.60 | -2.70% | -0.94% | 5% | -7.70% | -5.94% |
41 | 04/03/2019 | 26.62 | 993.99 | 4.23% | -0.04% | 5% | -0.77% | -5.04% |
42 | 25/02/2019 | 25.54 | 994.43 | -1.39% | 3.45% | 5% | -6.39% | -1.55% |
43 | 18/02/2019 | 25.90 | 961.30 | 9.19% | 3.80% | 5% | 4.19% | -1.20% |
44 | 11/02/2019 | 23.72 | 926.10 | 1.15% | 1.53% | 5% | -3.85% | -3.47% |
45 | 28/01/2019 | 23.45 | 912.18 | 1.16% | 0.12% | 5% | -3.84% | -4.88% |
46 | 21/01/2019 | 23.18 | 911.05 | -1.53% | 1.03% | 5% | -6.53% | -3.97% |
47 | 14/01/2019 | 23.54 | 901.80 | -1.18% | 1.37% | 5% | -6.18% | -3.63% |
48 | 07/01/2019 | 23.82 | 889.64 | -0.38% | -0.24% | 5% | -5.38% | -5.24% |
49 | 02/01/2019 | 23.91 | 891.75 | -1.85% | -1.85% | 5% | -6.85% | -6.85% |
50 | 24/12/2018 | 24.36 | 908.56 | 0.37% | -2.69% | 5% | -4.63% | -7.69% |
51 | 17/12/2018 | 24.27 | 933.65 | -2.88% | -2.33% | 5% | -7.88% | -7.33% |
52 | 10/12/2018 | 24.99 | 955.89 | 0% | 0% | 5% | 0% | 0% |