Final Calculation

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 8

1 2

Date Adj Close Return for stock Date Adj Close Return for stock
9/1/2020 16.97816 9/1/2020 15.957186
9/2/2020 17.2341 1.496% 9/2/2020 16.259075 1.874%
9/3/2020 16.7696 -2.732% 9/3/2020 15.554661 -4.429%
9/4/2020 16.65584 -0.681% 9/4/2020 15.382152 -1.115%
9/8/2020 16.50417 -0.915% 9/8/2020 14.864622 -3.422%
9/9/2020 16.6274 0.744% 9/9/2020 15.202455 2.247%
9/10/2020 16.45677 -1.032% 9/10/2020 14.984267 -1.446%
9/11/2020 16.87387 2.503% 9/11/2020 14.919241 -0.435%
9/14/2020 17.01607 0.839% 9/14/2020 15.121532 1.347%
9/15/2020 16.8644 -0.895% 9/15/2020 15.323825 1.329%
9/16/2020 17.12035 1.506% 9/16/2020 15.338278 0.094%
9/17/2020 17.4711 2.028% 9/17/2020 15.114309 -1.471%
9/18/2020 17.81237 1.935% 9/18/2020 14.991489 -0.816%
9/21/2020 17.40474 -2.315% 9/21/2020 14.933689 -0.386%
9/22/2020 17.29098 -0.656% 9/22/2020 15.063735 0.867%
9/23/2020 16.83596 -2.667% 9/23/2020 14.774746 -1.937%
9/24/2020 17.02555 1.120% 9/24/2020 14.738622 -0.245%
9/25/2020 17.05399 0.167% 9/25/2020 15.063735 2.182%
9/28/2020 16.94023 -0.669% 9/28/2020 15.489999 2.790%
9/29/2020 17.06347 0.725% 9/29/2020 15.464712 -0.163%
9/30/2020 17.16775 0.609% 9/30/2020 15.591149 0.814%
10/1/2020 16.98764 -1.055% 10/1/2020 15.822339 1.472%
10/2/2020 17.57537 3.401% 10/2/2020 15.778996 -0.274%
10/5/2020 17.61329 0.216% 10/5/2020 15.909042 0.821%
10/6/2020 17.68913 0.430% 10/6/2020 16.017412 0.679%
10/7/2020 17.77445 0.481% 10/7/2020 16.407549 2.407%
10/8/2020 18.42855 3.614% 10/8/2020 16.718218 1.876%
10/9/2020 18.31479 -0.619% 10/9/2020 16.669584 -0.291%
10/12/2020 18.50439 1.030% 10/12/2020 16.847424 1.061%
10/13/2020 18.53282 0.154% 10/13/2020 16.76758 -0.475%
10/14/2020 18.60866 0.408% 10/14/2020 16.753061 -0.087%
10/15/2020 18.8267 1.165% 10/15/2020 16.52804 -1.352%
10/16/2020 18.86461 0.201% 10/16/2020 16.716764 1.135%
10/19/2020 18.86461 0.000% 10/19/2020 16.535303 -1.091%
10/20/2020 18.95941 0.501% 10/20/2020 16.571592 0.219%
10/21/2020 19.15849 1.045% 10/21/2020 16.477232 -0.571%
10/22/2020 19.34808 0.985% 10/22/2020 16.281246 -1.197%
10/23/2020 19.57559 1.169% 10/23/2020 16.52804 1.504%
10/26/2020 19.50924 -0.340% 10/26/2020 16.056231 -2.896%
10/27/2020 19.28172 -1.173% 10/27/2020 16.070742 0.090%
10/28/2020 18.48543 -4.217% 10/28/2020 15.511823 -3.540%
10/29/2020 18.65064 0.890% 10/29/2020 15.787651 1.763%
10/30/2020 18.62199 -0.154% 10/30/2020 15.30132 -3.129%
11/2/2020 19.09947 2.532% 11/2/2020 15.294064 -0.047%
11/3/2020 19.35732 1.341% 11/3/2020 15.671514 2.438%
11/4/2020 19.04218 -1.641% 11/4/2020 16.281246 3.817%
11/5/2020 20.0258 5.036% 11/5/2020 16.702244 2.553%
11/6/2020 19.49101 -2.707% 11/6/2020 16.76758 0.390%
11/9/2020 20.0258 2.707% 11/9/2020 16.636921 -0.782%
11/10/2020 19.88255 -0.718% 11/10/2020 16.540651 -0.580%
11/11/2020 20.33139 2.232% 11/11/2020 16.679222 0.834%
11/12/2020 19.61516 -3.586% 11/12/2020 16.58441 -0.570%
11/13/2020 19.9303 1.594% 11/13/2020 16.737568 0.919%
11/16/2020 20.36959 2.180% 11/16/2020 17.029289 1.728%
11/17/2020 20.38869 0.094% 11/17/2020 17.029289 0.000%
11/18/2020 20.40779 0.094% 11/18/2020 16.956362 -0.429%
11/19/2020 19.93985 -2.320% 11/19/2020 17.080338 0.728%
11/20/2020 19.50056 -2.228% 11/20/2020 17.07305 -0.043%
11/23/2020 19.53876 0.196% 11/23/2020 17.13139 0.341%
11/24/2020 20.19769 3.317% 11/24/2020 17.321007 1.101%
11/25/2020 20.03535 -0.807% 11/25/2020 17.452282 0.755%
11/27/2020 20.09265 0.286% 11/27/2020 17.466871 0.084%
11/30/2020 19.51967 -2.893% 11/30/2020 17.496044 0.167%
12/1/2020 19.67246 0.780% 12/1/2020 17.722122 1.284%
12/2/2020 20.20724 2.682% 12/2/2020 17.751301 0.165%
12/3/2020 20.20724 0.000% 12/3/2020 17.853407 0.574%
12/4/2020 20.12129 -0.426% 12/4/2020 18.225351 2.062%
12/7/2020 19.9303 -0.954% 12/7/2020 18.342039 0.638%
12/8/2020 20.2359 1.522% 12/8/2020 18.531658 1.028%
12/9/2020 19.9112 -1.618% 12/9/2020 18.349333 -0.989%
12/10/2020 19.9112 0.000% 12/10/2020 18.281944 -0.368%
12/11/2020 20.19769 1.429% 12/11/2020 18.472382 1.036%
12/14/2020 20.34094 0.707% 12/14/2020 18.845936 2.002%
12/15/2020 21.27681 4.498% 12/15/2020 18.823957 -0.117%
12/16/2020 20.91392 -1.720% 12/16/2020 19.219484 2.079%
12/17/2020 21.09537 0.864% 12/17/2020 19.607679 2.000%
12/18/2020 21.52511 2.017% 12/18/2020 19.71179 0.530%
12/21/2020 21.60151 0.354% 12/21/2020 19.497448 -1.093%
Market
Date Adj Close Return for market
9/1/2020 3,526.65
9/2/2020 3,580.84 1.52%
9/3/2020 3,455.06 -3.58%
9/4/2020 3,426.96 -0.82% AR WWD
9/5/2020 3,331.84 -2.81% Beta 0.687 1.018
9/6/2020 3,398.96 1.99% Risk free 0.046% 0.046%
9/7/2020 3,339.19 -1.77% R(M) daily 0.0605% 0.0605%
9/8/2020 3,340.97 0.05% R(M) Annual 24.717% 24.717%
9/9/2020 3,383.54 1.27%
9/10/2020 3,401.20 0.52%
9/11/2020 3,385.49 -0.46%
9/12/2020 3,357.01 -0.84% Er 0.06% 0.06%
9/13/2020 3,319.47 -1.12%
9/14/2020 3,281.06 -1.16%
9/15/2020 3,315.57 1.05%
9/16/2020 3,236.92 -2.40%
9/17/2020 3,246.59 0.30%
9/18/2020 3,298.46 1.59%
9/19/2020 3,351.60 1.60%
9/20/2020 3,335.47 -0.48%
9/21/2020 3,363.00 0.82%
9/22/2020 3,380.80 0.53%
9/23/2020 3,348.42 -0.96%
9/24/2020 3,408.60 1.78%
9/25/2020 3,360.97 -1.41%
9/26/2020 3,419.44 1.72%
9/27/2020 3,446.83 0.80%
9/28/2020 3,477.14 0.88%
9/29/2020 3,534.22 1.63%
9/30/2020 3,511.93 -0.63%
10/1/2020 3,488.67 -0.66%
10/2/2020 3,483.34 -0.15%
10/3/2020 3,483.81 0.01%
10/4/2020 3,426.92 -1.65%
10/5/2020 3,443.12 0.47%
10/6/2020 3,435.56 -0.22%
10/7/2020 3,453.49 0.52%
10/8/2020 3,465.39 0.34%
10/9/2020 3,400.97 -1.88%
10/10/2020 3,390.68 -0.30%
10/11/2020 3,271.03 -3.59%
10/12/2020 3,310.11 1.19%
10/13/2020 3,269.96 -1.22%
10/14/2020 3,310.24 1.22%
10/15/2020 3,369.16 1.76%
10/16/2020 3,443.44 2.18%
10/17/2020 3,510.45 1.93%
10/18/2020 3,509.44 -0.03%
10/19/2020 3,550.50 1.16%
10/20/2020 3,545.53 -0.14%
10/21/2020 3,572.66 0.76%
10/22/2020 3,537.01 -1.00%
10/23/2020 3,585.15 1.35%
10/24/2020 3,626.91 1.16%
10/25/2020 3,609.53 -0.48%
10/26/2020 3,567.79 -1.16%
10/27/2020 3,581.87 0.39%
10/28/2020 3,557.54 -0.68%
10/29/2020 3,577.59 0.56%
10/30/2020 3,635.41 1.60%
10/31/2020 3,629.65 -0.16%
11/1/2020 3,638.35 0.24%
11/2/2020 3,621.63 -0.46%
11/3/2020 3,662.45 1.12%
11/4/2020 3,669.01 0.18%
11/5/2020 3,666.72 -0.06%
11/6/2020 3,699.12 0.88%
11/7/2020 3,691.96 -0.19%
11/8/2020 3,702.25 0.28%
11/9/2020 3,672.82 -0.80%
11/10/2020 3,668.10 -0.13%
11/11/2020 3,663.46 -0.13%
11/12/2020 3,647.49 -0.44%
11/13/2020 3,694.62 1.28%
11/14/2020 3,701.17 0.18%
11/15/2020 3,722.48 0.57%
11/16/2020 3,709.41 -0.35%
11/17/2020 3,694.92 -0.39%
3 4
Date Adj Close Return for stock Date Adj Close Return for stock
9/1/2020 2.18 9/1/2020 13.71
9/2/2020 2.12 -2.791% 9/2/2020 13.68 -0.219%
9/3/2020 2.1 -0.948% 9/3/2020 13.32 -2.667%
9/4/2020 2.1 0.000% 9/4/2020 13.52 1.490%
9/8/2020 2.09 -0.477% 9/8/2020 12.83 -5.238%
9/9/2020 2.18 4.216% 9/9/2020 13.2 2.843%
9/10/2020 2.05 -6.149% 9/10/2020 13.18 -0.152%
9/11/2020 2.04 -0.489% 9/11/2020 13.38 1.506%
9/14/2020 2.06 0.976% 9/14/2020 13.34 -0.299%
9/15/2020 2.1 1.923% 9/15/2020 13.34 0.000%
9/16/2020 2.12 0.948% 9/16/2020 13.29 -0.376%
9/17/2020 2.07 -2.387% 9/17/2020 13.29 0.000%
9/18/2020 2.04 -1.460% 9/18/2020 13.18 -0.831%
9/21/2020 2.03 -0.491% 9/21/2020 13.2 0.152%
9/22/2020 1.99 -1.990% 9/22/2020 13.04 -1.220%
9/23/2020 1.87 -6.220% 9/23/2020 13.21 1.295%
9/24/2020 1.93 3.158% 9/24/2020 13.18 -0.227%
9/25/2020 1.9 -1.567% 9/25/2020 13.08 -0.762%
9/28/2020 1.89 -0.528% 9/28/2020 13.62 4.045%
9/29/2020 1.89 0.000% 9/29/2020 13.49 -0.959%
9/30/2020 1.92 1.575% 9/30/2020 13.34 -1.118%
10/1/2020 1.93 0.519% 10/1/2020 13.53 1.414%
10/2/2020 2 3.563% 10/2/2020 13.38 -1.115%
10/5/2020 2.02 0.995% 10/5/2020 13.63 1.851%
10/6/2020 2 -0.995% 10/6/2020 13.54 -0.662%
10/7/2020 2.01 0.499% 10/7/2020 13.86 2.336%
10/8/2020 2.05 1.971% 10/8/2020 13.94 0.576%
10/9/2020 2.06 0.487% 10/9/2020 14.19 1.778%
10/12/2020 2.05 -0.487% 10/12/2020 13.71 -3.441%
10/13/2020 2.23 8.416% 10/13/2020 13.86 1.088%
10/14/2020 2.04 -8.905% 10/14/2020 14.12 1.859%
10/15/2020 2.07 1.460% 10/15/2020 14.1 -0.142%
10/16/2020 2.1 1.439% 10/16/2020 13.63 -3.390%
10/19/2020 2.06 -1.923% 10/19/2020 13.63 0.000%
10/20/2020 2.02 -1.961% 10/20/2020 13.37 -1.926%
10/21/2020 2.03 0.494% 10/21/2020 13.35 -0.150%
10/22/2020 2.08 2.433% 10/22/2020 13.2 -1.130%
10/23/2020 2.03 -2.433% 10/23/2020 13.26 0.454%
10/26/2020 1.97 -3.000% 10/26/2020 13.46 1.497%
10/27/2020 1.94 -1.535% 10/27/2020 13.35 -0.821%
10/28/2020 1.82 -6.385% 10/28/2020 13.46 0.821%
10/29/2020 1.9 4.302% 10/29/2020 13.25 -1.572%
10/30/2020 1.88 -1.058% 10/30/2020 13.82 4.212%
11/2/2020 1.82 -3.244% 11/2/2020 13.22 -4.439%
11/3/2020 1.85 1.635% 11/3/2020 13.29 0.528%
11/4/2020 1.81 -2.186% 11/4/2020 13.21 -0.604%
11/5/2020 1.83 1.099% 11/5/2020 13.72 3.788%
11/6/2020 1.83 0.000% 11/6/2020 12.8 -6.941%
11/9/2020 1.86 1.626% 11/9/2020 12.82 0.156%
11/10/2020 1.9 2.128% 11/10/2020 12.8 -0.156%
11/11/2020 1.94 2.083% 11/11/2020 13.25 3.455%
11/12/2020 2.09 7.448% 11/12/2020 12.96 -2.213%
11/13/2020 2.08 -0.480% 11/13/2020 13.08 0.922%
11/16/2020 2.06 -0.966% 11/16/2020 13.14 0.458%
11/17/2020 2.11 2.398% 11/17/2020 13.03 -0.841%
11/18/2020 2.07 -1.914% 11/18/2020 12.93 -0.770%
11/19/2020 2.11 1.914% 11/19/2020 13.18 1.915%
11/20/2020 2.16 2.342% 11/20/2020 13.29 0.831%
11/23/2020 2.5 14.618% 11/23/2020 13.47 1.345%
11/24/2020 2.84 12.751% 11/24/2020 13.45 -0.149%
11/25/2020 2.79 -1.776% 11/25/2020 13.36 -0.671%
11/27/2020 3.15 12.136% 11/27/2020 13.47 0.820%
11/30/2020 3.19 1.262% 11/30/2020 13.28 -1.421%
12/1/2020 3.12 -2.219% 12/1/2020 13.33 0.376%
12/2/2020 3.09 -0.966% 12/2/2020 13.45 0.896%
12/3/2020 3.15 1.923% 12/3/2020 13.5 0.371%
12/4/2020 3.32 5.256% 12/4/2020 13.62 0.885%
12/7/2020 4.07 20.368% 12/7/2020 13.92 2.179%
12/8/2020 3.72 -8.992% 12/8/2020 13.83 -0.649%
12/9/2020 3.88 4.211% 12/9/2020 13.83 0.000%
12/10/2020 3.82 -1.558% 12/10/2020 14.095 1.898%
12/11/2020 3.57 -6.768% 12/11/2020 13.865 -1.645%
12/14/2020 4.03 12.120% 12/14/2020 14.03 1.183%
12/15/2020 3.74 -7.468% 12/15/2020 13.97 -0.429%
12/16/2020 3.75 0.267% 12/16/2020 14.91 6.512%
12/17/2020 3.6 -4.082% 12/17/2020 14.55 -2.444%
12/18/2020 3.31 -8.399% 12/18/2020 14.35 -1.384%
12/21/2020 3.13 -5.592% 12/21/2020 14.93 3.962%
Market
Date Adj Close Return for market
9/1/2020 3,526.65
9/2/2020 3,580.84 1.52%
9/3/2020 3,455.06 -3.58%
9/4/2020 3,426.96 -0.82% AR WWD
9/5/2020 3,331.84 -2.81% Beta 0.678 0.256
9/6/2020 3,398.96 1.99% Risk free 0.046% 0.046%
9/7/2020 3,339.19 -1.77% R(M) daily 0.0605% 0.0605%
9/8/2020 3,340.97 0.05% R(M) Annual 24.717% 24.717%
9/9/2020 3,383.54 1.27%
9/10/2020 3,401.20 0.52%
9/11/2020 3,385.49 -0.46%
9/12/2020 3,357.01 -0.84% Er 0.06% 0.05%
9/13/2020 3,319.47 -1.12%
9/14/2020 3,281.06 -1.16%
9/15/2020 3,315.57 1.05%
9/16/2020 3,236.92 -2.40%
9/17/2020 3,246.59 0.30%
9/18/2020 3,298.46 1.59%
9/19/2020 3,351.60 1.60%
9/20/2020 3,335.47 -0.48%
9/21/2020 3,363.00 0.82%
9/22/2020 3,380.80 0.53%
9/23/2020 3,348.42 -0.96%
9/24/2020 3,408.60 1.78%
9/25/2020 3,360.97 -1.41%
9/26/2020 3,419.44 1.72%
9/27/2020 3,446.83 0.80%
9/28/2020 3,477.14 0.88%
9/29/2020 3,534.22 1.63%
9/30/2020 3,511.93 -0.63%
10/1/2020 3,488.67 -0.66%
10/2/2020 3,483.34 -0.15%
10/3/2020 3,483.81 0.01%
10/4/2020 3,426.92 -1.65%
10/5/2020 3,443.12 0.47%
10/6/2020 3,435.56 -0.22%
10/7/2020 3,453.49 0.52%
10/8/2020 3,465.39 0.34%
10/9/2020 3,400.97 -1.88%
10/10/2020 3,390.68 -0.30%
10/11/2020 3,271.03 -3.59%
10/12/2020 3,310.11 1.19%
10/13/2020 3,269.96 -1.22%
10/14/2020 3,310.24 1.22%
10/15/2020 3,369.16 1.76%
10/16/2020 3,443.44 2.18%
10/17/2020 3,510.45 1.93%
10/18/2020 3,509.44 -0.03%
10/19/2020 3,550.50 1.16%
10/20/2020 3,545.53 -0.14%
10/21/2020 3,572.66 0.76%
10/22/2020 3,537.01 -1.00%
10/23/2020 3,585.15 1.35%
10/24/2020 3,626.91 1.16%
10/25/2020 3,609.53 -0.48%
10/26/2020 3,567.79 -1.16%
10/27/2020 3,581.87 0.39%
10/28/2020 3,557.54 -0.68%
10/29/2020 3,577.59 0.56%
10/30/2020 3,635.41 1.60%
10/31/2020 3,629.65 -0.16%
11/1/2020 3,638.35 0.24%
11/2/2020 3,621.63 -0.46%
11/3/2020 3,662.45 1.12%
11/4/2020 3,669.01 0.18%
11/5/2020 3,666.72 -0.06%
11/6/2020 3,699.12 0.88%
11/7/2020 3,691.96 -0.19%
11/8/2020 3,702.25 0.28%
11/9/2020 3,672.82 -0.80%
11/10/2020 3,668.10 -0.13%
11/11/2020 3,663.46 -0.13%
11/12/2020 3,647.49 -0.44%
11/13/2020 3,694.62 1.28%
11/14/2020 3,701.17 0.18%
11/15/2020 3,722.48 0.57%
11/16/2020 3,709.41 -0.35%
11/17/2020 3,694.92 -0.39%

You might also like