Question

What is the beta for Home Depot, Inc. (HD)?

Date S&P S00 Ad dose Price BBY Ad Cose Price HD Ad Close Price MSFT Ad Close Price FB Ad Cose Price COST Ad dose Price Source: Yahoo! Finance website 1/1/15 $ 1994.99 $ 30.34 $ 3639 $ 75.91 $ 126.33 The Adj Close Price is adjusted for dividends and stock splits 94.43 2/1/15 $ 2,104.50 $ 39 50 129.84 32.84 103.78 78.97 2,067.89 32.58 S 3/1/15 102.75 $ 82.22 3689 138.62 4/1/15 $ 3041 $ 97.25 $ 101 28 130 88 2,085 51 $ 44.13 78.77 30.45 $ 42 51 5/1/15 $ 2,107.39 79.19 130.82 40 31 $ 6/1/15 $ 2,063.11 $ 28.62 $ 28 53 85.77 $ 101.02 123.91 7/1/15 106.95 $ 94.01 $ 133.31 2,103.84 42.64 8/1/15 $ 1972.18 $ 106.43 S 39.74 89.73 3246 128.49 9/1/15 1,920.03 2,079.36 3280 $ 105.54 89.90 4068 133.00 10/1/15 $ 48.38 $ 3114 113.56 10197 145.47 122 97 $ 148 50 11/1/15 $ 2,080.41 $ 28.25 49.96 104.24 S 12/1/15 2,04394 1940 24 1,932.23 $1 34 $ 121.47 $ 27.07 104.66 14896 1/1/16 $ 25.02 116.02 $ 50.98 $ 112.21 139.39 2/1/16 $ 106.92 $ 29.01 114.51 47.08 138.38 3/1/16 $ 2,059.74 29.06 $ 123.10 $ 114.10 $ 5147 145.74 4/1/16 $ 2,065.30 $ 2938 $ 124.20 $ 46.48 117.58 $ 137.00 122 56 5/1/16 $ 2,09695 $ 29.46 $ 49.39 118.81$ 138.00 2,098.86 6/1/16 $ 48.02 $ 114.28 $ 123 94 S 28.02 119.06 145.67 128.90 $ 7/1/16 31.06 2,173.60 53.19 155.11 8/1/16 $ 3557 $ 125.06 $ 126.12 $ 150.35 2,170.95 53.93 120.60 S 9/1/16 2,168 27 35.29 5439 128.27 14185 10/1/16 $ 114.35 $ 130.99 $ 137.53 2,126.15 3623 5659 11/1/16 $ 42.55 121 28 $ 118.42 139.62 2,198.81 56.91 2,238.83 2,278 87 12/1/16 $ 39.73 149.37 126.33 59.08 115.05 130 32 $ 1/1/17 4171 $ 41 34 129.63 $ 152.96 6146 136 53 $ 138 34 2/1/17 2,363.64 $ 6083 135.54 165.30 3/1/17 $ 2362.72 2384.20 $ 4604 62.99 $ 142.05 $ 156.87 4/1/17 $ 4890 14797 65.48 150.25 166.05 145 52 5/1/17 $ $6.05 $ 6680 151.46 2,41180 168.79 6/1/17 $ S4.11 $ 146.25 $ 150.98 $ 2,423.41 6631 156.11 2470.30 7/1/17 $ s5.39 $ 142.63 $ 142 89 $ 69.94 169.25 154.72 8/1/17 $ 5152 7193 $ 2,47165 17197 152.99 9/1/17 2,519.36 54.08 $ 156.86 $ 72.04 170.87 160.88 10/1/17 2,575.26 $ $3.46 158.99 $ 80.44 $ 180.06 157.73 11/1/17 $ 172.46 $ 8140 180.60 2,584.84 56.93 177.18 12/1/17 $ 2,673.61 $ 182.69 $ 83.14 $ 182.79 65.39 176.46 1/1/18 $ 193.65 92.35 186.89 2,823.81 70.16 19139 2/1/18 69.56 $ 175.69 $ 2,713.83 9114 178.32 187.49 3/1/18 $ 89.13 $ 2,64087 67.21 17181 159.79 185.56 4/1/18 $ 2,648.05 $ 73.96 $ 179.15 $ 194.15 9132 172.00 5/1/18 $ 2,705.27 $ 65.96 96 52 19178 $ 180.84 195.22 6/1/18 $ 190.19 $ 192 55 $ 2,718.37 72.08 96.71 194.32 206.39 2,816 29 172 58 7/1/18 $ 72.96 $ 104.04 216.00 230 24 8/1/18 $ 2,90152 $ 7736 $ 110.17 $ 175.73 $ 195.72 202 97 $ 9/1/18 164.46 $ 2,913.98 77.17 112.60 232.55 10/1/18 $ 2,71174 68.62 172.33 105.16 15179 226.36 11/1/18 176.68 $ 109.17 140.61 $ 228.98 2,760.17 63.17 2,506.85 202 17 12/1/18 $ 131.09 $ $179 169.36 100.43 180 90 $ 1/1/19 $ 2,704.10 $ 103.26 $ 166.69 58.37 213.00 2,784.49 2/1/19 $ 67.83 $ 16145 $ 166.69 $ 18249 110.77 217.08 3/1/19 $ 70.02 $ 189.14 2,834.40 $ 117.12 240.95 202 28 $ 2,945.83 2,752.06 4/1/19 $ 73.84 129.69 193.40 $ 24433 188 53 5/1/19 $ 62.19 238.41 12281 177.47 133 52 $ 6/1/19 2,94176 $ 263.68 69.20 205.52 193.00 2,980 38 7/1/19 76.53 $ 213.69 135.82 194.23 275.02

Answer 1

	B	C	D	E	F	G	H
2			Stocks Prices (Adjusted Close)			% Returns
3		Date	S&P Adj Close Price	Hd Adj Close Price		S&P 500	HD
4		01-01-2015	1944.99	94.43
5		02-01-2015	2104.50	103.78		0.082	0.099
6		03-01-2015	2067.89	102.75		-0.017	-0.010
7		04-01-2015	2085.51	97.25		0.009	-0.054
8		05-01-2015	2107.39	101.28		0.010	0.041
9		06-01-2015	2063.11	101.02		-0.021	-0.003
10		07-01-2015	2103.84	106.95		0.020	0.059
11		08-01-2015	1972.18	106.43		-0.063	-0.005
12		09-01-2015	1920.03	105.54		-0.026	-0.008
13		10-01-2015	2079.36	113.56		0.083	0.076
14		11-01-2015	2080.41	122.97		0.001	0.083
15		12-01-2015	2043.94	121.47		-0.018	-0.012
16		01-01-2016	1940.24	116.02		-0.051	-0.045
17		02-01-2016	1932.23	114.51		-0.004	-0.013
18		03-01-2016	2059.74	123.10		0.066	0.075
19		04-01-2016	2065.30	124.20		0.003	0.009
20		05-01-2016	2096.95	122.56		0.015	-0.013
21		06-01-2016	2098.86	119.06		0.001	-0.029
22		07-01-2016	2173.60	128.90		0.036	0.083
23		08-01-2016	2170.95	125.06		-0.001	-0.030
24		09-01-2016	2168.27	120.60		-0.001	-0.036
25		10-01-2016	2126.15	114.35		-0.019	-0.052
26		11-01-2016	2198.81	121.28		0.034	0.061
27		12-01-2016	2238.83	126.33		0.018	0.042
28		01-01-2017	2278.87	129.63		0.018	0.026
29		02-01-2017	2363.64	136.53		0.037	0.053
30		03-01-2017	2362.72	138.34		0.000	0.013
31		04-01-2017	2384.20	147.97		0.009	0.070
32		05-01-2017	2411.80	145.52		0.012	-0.017
33		06-01-2017	2423.41	146.25		0.005	0.005
34		07-01-2017	2470.30	142.63		0.019	-0.025
35		08-01-2017	2471.65	142.89		0.001	0.002
36		09-01-2017	2519.36	156.86		0.019	0.098
37		10-01-2017	2575.26	158.99		0.022	0.014
38		11-01-2017	2584.84	172.46		0.004	0.085
39		12-01-2017	2673.61	182.69		0.034	0.059
40		01-01-2018	2823.81	193.65		0.056	0.060
41		02-01-2018	2713.83	175.69		-0.039	-0.093
42		03-01-2018	2640.87	171.81		-0.027	-0.022
43		04-01-2018	2648.05	179.15		0.003	0.043
44		05-01-2018	2705.27	180.94		0.022	0.010
45		06-01-2018	2718.37	190.19		0.005	0.051
46		07-01-2018	2816.29	192.55		0.036	0.012
47		08-01-2018	2901.52	195.72		0.030	0.016
48		09-01-2018	2913.98	202.97		0.004	0.037
49		10-01-2018	2711.74	172.33		-0.069	-0.151
50		11-01-2018	2760.17	176.68		0.018	0.025
51		12-01-2018	2506.85	169.36		-0.092	-0.041
52		01-01-2019	2704.10	180.90		0.079	0.068
53		02-01-2019	2784.49	182.49		0.030	0.009
54		03-01-2019	2834.40	189.14		0.018	0.036
55		04-01-2019	2945.83	202.28		0.039	0.069
56		05-01-2019	2752.06	188.53		-0.066	-0.068
57		06-01-2019	2941.76	206.52		0.069	0.095
58		07-01-2019	2980.38	213.69		0.013	0.035
			Stock Beta	0.5238
			Stock Beta =	COVARIANCE.S(H5:H58,G5:G58)/VAR.S(H5:H58)