Question

What is the beta for Microsoft Corporation (MSFT)?

Source: Yahool Finance website The Adj Close Price is adjusted for dividends and stock splits Date S&P 500 Ad Close Price BEY Ad Close Price HD Ad Close Price MSFT Adi Clase Price FB Adj Close Price COST Adi Clase Price 1/1/2015 $ 1,994.99 $ 30.34 $ 94.43 $ 36.39 $ 75.91 $ 126.33 2/1/2015 $ 2,104.50 $ 32.84 $ 103.78 $ 39.50 $ 78.97 $ 129.84 3/1/2015 $ 2,067.89 $ 32.58 $ 102.75 $ 36.89 $ 82.22 $ 138.62 4/1/2015 $ 2,085.51 $ 30.41 $ 97.25 $ 44.13 $ 78.77 $ 130.88 5/1/2015 $ 2,107.39 $ 30.45 $ 101.28 $ 42.51 $ 79.19 $ 130.82 6/1/2015 $ 2,063.11 $ 28.62 $ 101.02 $ 40.31 $ 85.77 $ 123.91 7/1/2015 $ 2.103,84 $ 28.53 5 106.95 $ 42.64 $ 94,01 $ 133.31 8/1/2015 S 1.972.18 $ 32 46 $ 106.43 $ 39.74 $ 89.73 $ 128.49 9/1/2015 $ 1.920,03 $ 32.80 $ 105.54 $ 40.68 $ 89.90 $ 133,00 10/1/2015 $ 2,079.36 $ 31.14 $ 113 56 S 48,38 $ 101.97 $ 145.47 11/1/2015 $ 2.080.41 $ 28.25 $ 122.97 $ 49.95 $ 104.24 5 148.50 12/1/2015 $ 2,043,94 $ 27.07 $ 121.47 $ 51.34 $ 104 66 $ 148.96 1/1/2016 $ 1,940,24 $ 25.02 $ 116.02 $ 50.98 S 112.215 139.39 2/1/2016 $ 1,932.23 $ 29.01$ 114 51 47.08 $ 106 92 $ 139.38 3/1/2016 $ 2,059.74 $ 29.06 $ 123.10 $ 51.47 $ 114.10 $ 145.74 4/1/2016 $ 2,065,30 $ 29 38 $ 124 20 $ 46.48 $ 117.58 $ 137.00 5/1/2016 $ 2,095.95 $ 29.46 $ 122.56 $ 49.39 $ 118.81 $ 138.00 6/1/2016 S 2,098.86 $ 28.02 $ 119.06 $ 48.02 $ 114.28 $ 145.67 7/1/2016 S 2,173.60 $ 31.06 $ 128 90 $ 123.94 $ 155.11 8/1/2016 $ 2,170.95 35.57 $ 125.06 $ 126.12 $ 150.35 9/1/2016 $ 2,168.27 $ 35.29 $ 120.60 $ 128.27 $ 141.85 10/1/2016 $ 2,126.15 $ 36.23 $ 114.35 $ 130.99 $ 137.53 11/1/2016 $ 2,198,81 $ 42.55 $ 121.28 $ 118.42 $ 139.62 12/1/2016 $ 2,238.83 $ 39.73 $ 126.33 $ 115.05 $ 149.37 1/1/2017 $ 2.278.87 $ 41.71 $ 129.63 $ 130.32 $ 152.96 2/1/2017 $ 2,363.64 $ 41.34 $ 135.53 $ 50.83 $ 135.54 $ 165,30 3/1/2017 $ 2,362.72 $ 46.04 $ 138.34 $ 62.99 $ 142.05 $ 156.87 4/1/2017 $ 2.384.20 $ 48.90 $ 147.97 $ 65.48 $ 150.25 $ 166,06 5/1/2017 S 2.411.80 $ 56.05 $ 145 52 $ 66.80 $ 151.46 $ 168.79 6/1/2017 $ 2,423,41 $ 54.11 $ 146.25 $ 66.31 $ 150.98 $ 156.11 7/1/2017 $ 2,470.30 $ 55.39 $ 142.53 $ 69.94 $ 169.25 $ 154.72 8/1/2017 $ 2,471.65 $ 51 52 $ 142.89 $ 71.93 171.97 $ 152.99 9/1/2017 $ 2.519.36 $ 54.08 $ 156 86 $ 72.04 $ 170.87 $ 160.88 10/1/2017 $ 2.575.26 $ 53.46 $ 158.99 $ 80.44 $ 180.06 $ 157.73 11/1/2017 $ 2,584.84 $ 56.93 $ 172.46 $ 81,40 $ 177.18 $ 180.60 12/1/2017 5 2,673.61 $ 65.39 $ 182 59 $ 83.14 $ 176.46 $ 182.79 1/1/2018 $ 2,823.81 $ 70.16 $ 193.65 $ 92.35 $ 186.89 $ 191.39 2/1/2018 S 2,713.83 $ 69.56 $ 175.69 $ 91.14 $ 178.32 $ 187.49 3/1/2018 2,640,87 s 67 21 $ 171.81 $ 89.13 S 159.79 $ 185.56 4/1/2018 $ 2,648.05 $ 73.96 $ 179.15 $ 91.32 $ 172.00 $ 194.15 5/1/2018 $ 2,705.27 $ 65.96 $ 180.84 $ 96.52 $ 191.78 $ 195.22 6/1/2018 $ 2,718.37 $ 72.08 $ 190.19 $ 96.71 $ 194.32 $ 205.39 7/1/2018 $ 2,816.29 $ 72.96 $ 192.55 $ 104.04 $ 172.58 $ 216.00 8/1/2018 $ 2,901.52 $ 77.36 $ 195.72 $ 110.17 $ 175.73 $ 230.24 9/1/2018 $ 2,913.98 $ 77.17 $ 202.97 $ 112.60 $ 164.46 $ 232.55 10/1/2018 $ 2,711.74 $ 68 62 $ 172.335 105.16 $ 151.79 $ 226.36 11/1/2018 $ 2,760.17 $ 63.17 $ 176.68 $ 109.17 $ 140.51 $ 228.98 12/1/2018 S 2,505,85 $ 51.79 $ 169 36 $ 100.43 $ 13109 $ 202.17 1/1/2019 $ 2,704.10 $ 58.37 $ 180.90 $ 103.26 $ 166.69 $ 213.00 2/1/2019 $ 2.784,49 $ 67.83 182.49 $ 110.77 $ 161.45 S 217.08 3/1/2019 $ 2,834,40 $ 70.02 $ 189.14 $ 117.12 s 166.59 $ 240.95 4/1/2019 $ 2,945,83 $ 73.84 $ 202 28 $ 129.69 $ 193.40 $ 244.33 5/1/2019 $ 2.752.06 $ 62.19 $ 188 53 $ 122.81 $ 177 47 5 23.41 6/1/2019 $ 2,941.76 $ 69.20 $ 206.52 $ 133.52 $ 193.00 $ 263.68 7/1/2019 $ 2.980.38 $ 76.53 $ 213.69 $ 135.82 $ 194.23 $ 275.02

Answer 1

		Date	S&P Closing Price	Monthly Return on S&P	MSFT Closing Price	Monthly Return on MSFT
		1/1/2015	$1,994.99		$36.39
		2/1/2015	$2,104.50	0.0548925	$39.50	0.085463039
		3/1/2015	$2,067.89	(0.0173961)	$36.89	-0.066075949
		4/1/2015	$2,085.51	0.0085208	$44.13	0.196259149
		5/1/2015	$2,107.39	0.0104914	$42.51	-0.036709721
		6/1/2015	$2,063.11	(0.0210118)	$40.31	-0.051752529
		7/1/2015	$2,103.84	0.0197420	$42.64	0.057802034
		8/1/2015	$1,972.18	(0.0625808)	$39.74	-0.068011257
		9/1/2015	$1,920.03	(0.0264428)	$40.68	0.023653749
		10/1/2015	$2,079.36	0.0829831	$48.38	0.189282203
		11/1/2015	$2,080.41	0.0005050	$49.96	0.032658123
		12/1/2015	$2,043.94	(0.0175302)	$51.34	0.027622098
		1/1/2016	$1,940.24	(0.0507353)	$50.98	-0.007012076
		2/1/2016	$1,932.23	(0.0041284)	$47.08	-0.076500588
		3/1/2016	$2,059.74	0.0659911	$51.47	0.09324554
		4/1/2016	$2,065.30	0.0026994	$46.48	-0.096949679
		5/1/2016	$2,096.95	0.0153247	$49.39	0.062607573
		6/1/2016	$2,098.86	0.0009108	$48.02	-0.027738409
		7/1/2016	$2,173.60	0.0356098	$53.19	0.107663474
		8/1/2016	$2,170.95	(0.0012192)	$53.93	0.01391239
		9/1/2016	$2,168.27	(0.0012345)	$54.39	0.008529575
		10/1/2016	$2,126.15	(0.0194256)	$56.59	0.040448612
		11/1/2016	$2,198.81	0.0341744	$56.91	0.005654709
		12/1/2016	$2,238.83	0.0182008	$59.08	0.038130381
		1/1/2017	$2,278.87	0.0178843	$61.46	0.04028436
		2/1/2017	$2,263.64	(0.0066831)	$60.83	-0.010250569
		3/1/2017	$2,362.72	0.0437702	$62.99	0.035508795
		4/1/2017	$2,384.20	0.0090912	$65.48	0.039530084
		5/1/2017	$2,411.80	0.0115762	$66.80	0.020158827
		6/1/2017	$2,423.41	0.0048138	$66.31	-0.007335329
		7/1/2017	$2,470.30	0.0193488	$69.94	0.054742874
		8/1/2017	$2,471.65	0.0005465	$71.93	0.02845296
		9/1/2017	$2,519.36	0.0193029	$72.04	0.001529265
		10/1/2017	$2,575.26	0.0221882	$80.44	0.116601888
		11/1/2017	$2,584.84	0.0037200	$81.40	0.011934361
		12/1/2017	$2,673.61	0.0343426	$83.14	0.021375921
		1/1/2018	$2,823.81	0.0561787	$92.35	0.110777003
		2/1/2018	$2,713.83	(0.0389474)	$91.14	-0.013102328
		3/1/2018	$2,640.87	(0.0268845)	$89.13	-0.022053983
		4/1/2018	$2,648.05	0.0027188	$91.32	0.024570852
		5/1/2018	$2,705.27	0.0216084	$96.52	0.056942619
		6/1/2018	$2,718.37	0.0048424	$96.71	0.001968504
		7/1/2018	$2,816.29	0.0360216	$104.04	0.07579361
		8/1/2018	$2,901.52	0.0302632	$110.17	0.058919646
		9/1/2018	$2,913.98	0.0042943	$112.60	0.022056821
		10/1/2018	$2,711.74	(0.0694034)	$105.16	-0.0660746
		11/1/2018	$2,760.17	0.0178594	$109.17	0.03813237
		12/1/2018	$2,506.85	(0.0917770)	$100.43	-0.080058624
		1/1/2019	$2,704.10	0.0786844	$103.26	0.028178831
		2/1/2019	$2,784.49	0.0297289	$110.77	0.072729034
		3/1/2019	$2,834.40	0.0179243	$117.12	0.057325991
		4/1/2019	$2,945.83	0.0393134	$129.69	0.10732582
		5/1/2019	$2,752.06	(0.0657777)	$122.81	-0.05304958
		6/1/2019	$2,941.76	0.0689302	$133.52	0.087207882
		7/1/2019	$2,980.38	0.0131282	$135.82	0.017225884
	Monthly Return of S&P in Jan,2015	0.054893	(2104.50/1994.99)-1
	Monthly Return of MSFT in Jan,2016	0.085463	(39.50/36.39)-1
	SLOPE of Return of MSFT on S&P	1.189979	(X axis S&P Return, Y axis S&P return)
	Beta for Microsoft Corporation (MSFT)	1.19	(Rounded to two decimal places)
								D63 - X Fax =SLOPE(H5:H58,F5:F58) ДА В 12/1/2017 1/1/2018 2/1/2018 3/1/2018 4/1/2018 5/1/2018 6/1/2018 7/1/2018 8/1/2018 9/1/2018 10/1/2018 11/1/2018 12/1/2018 1/1/2019 2/1/2019 3/1/2019 4/1/2019 5/1/2019 6/1/2019 7/1/2019 $2,673.61 $2,823.81 $2,713.83 $2,640.87 $2,648.05 $2,705.27 $2,718.37 $2,816.29 $2,901.52 $2,913.98 $2,711.74 $2,760.17 $2,506.85 $2,704.10 $2,784.49 $2,834.40 $2,945.83 $2,752.06 $2,941.76 $2,980.38 0.0343426 0.0561787 (0.0389474) (0.0268845) 0.0027188 0.0216084 0.0048424 0.0360216 0.0302632 0.0042943 (0.0694034) 0.0178594 (0.0917770) 0.0786844 0.0297289 0.0179243 0.0393134 (0.0657777) 0.0689302 0.0131282 $83.14 0.021375921 $92.35 0.110777003 $91.14 -0.013102328 $89.13 -0.022053983 $91.32 0.024570852 $96.52 0.056942619 $96.71 0.001968504 $104.04 0.07579361 $110.17 0.058919646 $112.60 0.022056821 $105.16 -0.0660746 $109.17 0.03813237 $100.43 -0.080058624 $103.26 0.028178831 $110.77 0.072729034 $117.12 0.057325991 $129.69 0.10732582 $122.81 -0.05304958 $133.52 0.087207882 $135.82 0.017225884 Monthly Return of S&P in Jan,2015 Monthly Return of MSFT in Jan,2016 0.054893 (2104.50/1994.99)-1 0.085463 (39.50/36.39)-1 SLOPE of Return of MSFT on S&P 1.189979 lix axis S&P Return, Y axis S&P return)