What is the beta for Microsoft Corporation (MSFT)? Source: Yahool Finance website The Adj Close Price...

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

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


	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)

.

What is the beta for Microsoft Corporation (MSFT)? Source: Yahool Finance website The Adj Close Price...

Question:

Answers

Similar Solved Questions

Describe the skewness and kurtosis with the distribution graph. X (income) No. of persons Cumulative frequency...

6. Write a part of the CUDA program which can calculate the time of execution of CUDA kernel. . W...

,

What could you do to boost Net Income in the current period? a. Increase the expected...

A parallelogram has sides with lengths of #24 # and #9 #. If the parallelogram's area is #96 #, what is the length of its longest diagonal?

Conduct a financial review of Nike's company. This review must include an analysis of key financial...

(1 pts) 16) Figure 9-9 Price Domestic Supply World Price Domestic Refer to Figure 9-9. Consumer surplus in this market...

What items will you include in the bargaining items? why did you select these items?

18) People in a group may interact differently. It is important to gain knowledge and skills in...

If yellow light shines on a green object, what color will the object appear to be?

Uestions Completed 27 out of 53 02 55 - HR MIN SEC The Ksp of cobalt(II)...

Just need to see if #1 is correct and need #2 answered Income Statement and Statement...

Which of the compounds can exist as optical isomers（enantiomers）

Please full calculation and explanation. depreciation-subsequent capital expenditure LO.q 0S 3 13 Revised Ctering Com rtable...

Brief Exercise 5-06 Pharoah Company provides this information for the month ended October 31, 2022: sales...

CHAPTER 9 (10 pts) Alkynes are very similar in reactivity to alkenes. What product is obtained...