1 answer

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

Answers

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/
.

Similar Solved Questions

1 answer
Describe the skewness and kurtosis with the distribution graph. X (income) No. of persons Cumulative frequency...
describe the skewness and kurtosis with the distribution graph. X (income) No. of persons Cumulative frequency (cf) 180 16 16 200 24 40 250 26 66 280 30 96...
1 answer
6. Write a part of the CUDA program which can calculate the time of execution of CUDA kernel. . W...
6. Write a part of the CUDA program which can calculate the time of execution of CUDA kernel. . Write a OpenCL kermel for transpose of a square matrix. The transpose has to be placed in the same input matrix variable. What is the global work size you have' considered? 6. Write a part of the CUD...
1 answer
,
,...
1 answer
What could you do to boost Net Income in the current period? a. Increase the expected...
What could you do to boost Net Income in the current period? a. Increase the expected long-term rate of return on plan assets b. Delay cash distributions to the pension. c. Contribute more cash to pension....
1 answer
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?
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?...
1 answer
Conduct a financial review of Nike's company. This review must include an analysis of key financial...
Conduct a financial review of Nike's company. This review must include an analysis of key financial ratios over the past 3-5 years to examine any important trends. You must also compare the company’s financial performance to its competitors and the overall sector/industry in which it compe...
1 answer
(1 pts) 16) Figure 9-9 Price Domestic Supply World Price Domestic Refer to Figure 9-9. Consumer surplus in this market...
(1 pts) 16) Figure 9-9 Price Domestic Supply World Price Domestic Refer to Figure 9-9. Consumer surplus in this market before trade A+B. A+B+...
1 answer
What items will you include in the bargaining items? why did you select these items?
what items will you include in the bargaining items? why did you select these items?...
1 answer
18)   People in a group may interact differently. It is important to gain knowledge and skills in...
18)   People in a group may interact differently. It is important to gain knowledge and skills in leading small group discussions in the workplace. 18.1)   How could you as the chair of the meeting respond when you observe a participant dominating the discussion? 18.2)&...
1 answer
If yellow light shines on a green object, what color will the object appear to be?
If yellow light shines on a green object, what color will the object appear to be?...
1 answer
Uestions Completed 27 out of 53 02 55 - HR MIN SEC The Ksp of cobalt(II)...
uestions Completed 27 out of 53 02 55 - HR MIN SEC The Ksp of cobalt(II) hydroxide, Co(OH)2, is 5.92 x 10-'5. Calculate the molar solubility, s, of this compound. about us Careers privacy policy terms of use contact us help...
1 answer
Just need to see if #1 is correct and need #2 answered Income Statement and Statement...
Just need to see if #1 is correct and need #2 answered Income Statement and Statement of Retained Earnings Background: Husky Sports Inc. started its business in January 2018. At the beginning of its 2020 calendar-year accounting period, Husky, Inc. had retained earnings of $1,500,000. During 2020 (y...
1 answer
Which of the compounds can exist as optical isomers(enantiomers)
which of the compounds can exist as optical isomers(enantiomers)...
1 answer
Please full calculation and explanation. depreciation-subsequent capital expenditure LO.q 0S 3 13 Revised Ctering Com rtable...
Please full calculation and explanation. depreciation-subsequent capital expenditure LO.q 0S 3 13 Revised Ctering Com rtable barbecue with a book value of $7,000 at its electronic rotisserie unit costing S1,000 was on January 3 and the revised de barbecue The barbecue had an estimated remain ats yea...
1 answer
Brief Exercise 5-06 Pharoah Company provides this information for the month ended October 31, 2022: sales...
Brief Exercise 5-06 Pharoah Company provides this information for the month ended October 31, 2022: sales on credit $305,800; cash sales $156,000; sales discounts $5,160; and sales returns and allowances $23,490. Prepare the sales section of the multiple-step income statement based on this informati...
1 answer
CHAPTER 9 (10 pts) Alkynes are very similar in reactivity to alkenes. What product is obtained...
CHAPTER 9 (10 pts) Alkynes are very similar in reactivity to alkenes. What product is obtained when the following reagents are added to 1-hexyne? 1. (a) molecular hydrogen/Pd/CaCOs (Lindlar's catalyst) (b) 1 mol HBr/peroxides (e cold, dilute KMnO4 (d) H2O, HgSO/H2SO4 (e) Sia BH, NaOH and H2O2...