Stock Analysis on Net

Thermo Fisher Scientific Inc. (NYSE:TMO)

Capital Asset Pricing Model (CAPM)

Microsoft Excel

Rates of Return

Thermo Fisher Scientific Inc., monthly rates of return

Microsoft Excel
Thermo Fisher Scientific Inc. (TMO) Standard & Poor’s 500 (S&P 500)
t Date PriceTMO,t1 DividendTMO,t1 RTMO,t2 PriceS&P 500,t RS&P 500,t3
Jan 31, 2020 $313.19 3,225.52
1. Feb 29, 2020 $290.80 -7.15% 2,954.22 -8.41%
2. Mar 31, 2020 $283.60 $0.22 -2.40% 2,584.59 -12.51%
3. Apr 30, 2020 $334.68 18.01% 2,912.43 12.68%
. . . . . . .
. . . . . . .
. . . . . . .
58. Nov 30, 2024 $529.63 -3.05% 6,032.38 5.73%
59. Dec 31, 2024 $520.23 $0.39 -1.70% 5,881.63 -2.50%
Average (R): 1.11% 1.16%
Standard deviation: 6.85% 5.28%
Thermo Fisher Scientific Inc. (TMO) Standard & Poor’s 500 (S&P 500)
t Date PriceTMO,t1 DividendTMO,t1 RTMO,t2 PriceS&P 500,t RS&P 500,t3
Jan 31, 2020 $313.19 3,225.52
1. Feb 29, 2020 $290.80 -7.15% 2,954.22 -8.41%
2. Mar 31, 2020 $283.60 $0.22 -2.40% 2,584.59 -12.51%
3. Apr 30, 2020 $334.68 18.01% 2,912.43 12.68%
4. May 31, 2020 $349.19 4.34% 3,044.31 4.53%
5. Jun 30, 2020 $362.34 $0.22 3.83% 3,100.29 1.84%
6. Jul 31, 2020 $413.95 14.24% 3,271.12 5.51%
7. Aug 31, 2020 $428.98 3.63% 3,500.31 7.01%
8. Sep 30, 2020 $441.52 $0.22 2.97% 3,363.00 -3.92%
9. Oct 31, 2020 $473.12 7.16% 3,269.96 -2.77%
10. Nov 30, 2020 $464.98 -1.72% 3,621.63 10.75%
11. Dec 31, 2020 $465.78 $0.22 0.22% 3,756.07 3.71%
12. Jan 31, 2021 $509.70 9.43% 3,714.24 -1.11%
13. Feb 28, 2021 $450.08 -11.70% 3,811.15 2.61%
14. Mar 31, 2021 $456.38 $0.26 1.46% 3,972.89 4.24%
15. Apr 30, 2021 $470.23 3.03% 4,181.17 5.24%
16. May 31, 2021 $469.50 -0.16% 4,204.11 0.55%
17. Jun 30, 2021 $504.47 $0.26 7.50% 4,297.50 2.22%
18. Jul 31, 2021 $540.01 7.05% 4,395.26 2.27%
19. Aug 31, 2021 $554.95 2.77% 4,522.68 2.90%
20. Sep 30, 2021 $571.33 $0.26 3.00% 4,307.54 -4.76%
21. Oct 31, 2021 $633.07 10.81% 4,605.38 6.91%
22. Nov 30, 2021 $632.83 -0.04% 4,567.00 -0.83%
23. Dec 31, 2021 $667.24 $0.26 5.48% 4,766.18 4.36%
24. Jan 31, 2022 $581.30 -12.88% 4,515.55 -5.26%
25. Feb 28, 2022 $544.00 -6.42% 4,373.94 -3.14%
26. Mar 31, 2022 $590.65 $0.30 8.63% 4,530.41 3.58%
27. Apr 30, 2022 $552.92 -6.39% 4,131.93 -8.80%
28. May 31, 2022 $567.57 2.65% 4,132.15 0.01%
29. Jun 30, 2022 $543.28 $0.30 -4.23% 3,785.38 -8.39%
30. Jul 31, 2022 $598.41 10.15% 4,130.29 9.11%
31. Aug 31, 2022 $545.32 -8.87% 3,955.00 -4.24%
32. Sep 30, 2022 $507.19 $0.30 -6.94% 3,585.62 -9.34%
33. Oct 31, 2022 $513.97 1.34% 3,871.98 7.99%
34. Nov 30, 2022 $560.22 9.00% 4,080.11 5.38%
35. Dec 31, 2022 $550.69 $0.30 -1.65% 3,839.50 -5.90%
36. Jan 31, 2023 $570.33 3.57% 4,076.60 6.18%
37. Feb 28, 2023 $541.76 -5.01% 3,970.15 -2.61%
38. Mar 31, 2023 $576.37 $0.35 6.45% 4,109.31 3.51%
39. Apr 30, 2023 $554.90 -3.73% 4,169.48 1.46%
40. May 31, 2023 $508.46 -8.37% 4,179.83 0.25%
41. Jun 30, 2023 $521.75 $0.35 2.68% 4,376.86 4.71%
42. Jul 31, 2023 $548.66 5.16% 4,588.96 4.85%
43. Aug 31, 2023 $557.10 1.54% 4,507.66 -1.77%
44. Sep 30, 2023 $506.17 $0.35 -9.08% 4,288.05 -4.87%
45. Oct 31, 2023 $444.77 -12.13% 4,193.80 -2.20%
46. Nov 30, 2023 $495.76 11.46% 4,567.80 8.92%
47. Dec 31, 2023 $530.79 $0.35 7.14% 4,769.83 4.42%
48. Jan 31, 2024 $538.98 1.54% 4,845.65 1.59%
49. Feb 29, 2024 $570.18 5.79% 5,096.27 5.17%
50. Mar 31, 2024 $581.21 $0.39 2.00% 5,254.35 3.10%
51. Apr 30, 2024 $568.72 -2.15% 5,035.69 -4.16%
52. May 31, 2024 $567.98 -0.13% 5,277.51 4.80%
53. Jun 30, 2024 $553.00 $0.39 -2.57% 5,460.48 3.47%
54. Jul 31, 2024 $613.34 10.91% 5,522.30 1.13%
55. Aug 31, 2024 $615.07 0.28% 5,648.40 2.28%
56. Sep 30, 2024 $618.57 $0.39 0.63% 5,762.48 2.02%
57. Oct 31, 2024 $546.32 -11.68% 5,705.45 -0.99%
58. Nov 30, 2024 $529.63 -3.05% 6,032.38 5.73%
59. Dec 31, 2024 $520.23 $0.39 -1.70% 5,881.63 -2.50%
Average (R): 1.11% 1.16%
Standard deviation: 6.85% 5.28%

Show all

1 Data in US$ per share of common stock, adjusted for splits and stock dividends.

2 Rate of return on common stock of TMO during period t

3 Rate of return on S&P 500 (the market portfolio proxy) during period t


Variance and Covariance

Thermo Fisher Scientific Inc., calculation of variance and covariance of returns

Microsoft Excel
t Date RTMO,t RS&P 500,t (RTMO,tRTMO)2 (RS&P 500,tRS&P 500)2 (RTMO,tRTMO)×(RS&P 500,tRS&P 500)
1. Feb 29, 2020 -7.15% -8.41% 68.28 91.63 79.10
2. Mar 31, 2020 -2.40% -12.51% 12.35 186.96 48.05
3. Apr 30, 2020 18.01% 12.68% 285.52 132.78 194.71
. . . . . . .
. . . . . . .
. . . . . . .
58. Nov 30, 2024 -3.05% 5.73% 17.38 20.87 -19.05
59. Dec 31, 2024 -1.70% -2.50% 7.92 13.40 10.30
Total (Σ): 2,720.47 1,618.62 1,244.30
t Date RTMO,t RS&P 500,t (RTMO,tRTMO)2 (RS&P 500,tRS&P 500)2 (RTMO,tRTMO)×(RS&P 500,tRS&P 500)
1. Feb 29, 2020 -7.15% -8.41% 68.28 91.63 79.10
2. Mar 31, 2020 -2.40% -12.51% 12.35 186.96 48.05
3. Apr 30, 2020 18.01% 12.68% 285.52 132.78 194.71
4. May 31, 2020 4.34% 4.53% 10.38 11.34 10.85
5. Jun 30, 2020 3.83% 1.84% 7.37 0.46 1.84
6. Jul 31, 2020 14.24% 5.51% 172.39 18.91 57.10
7. Aug 31, 2020 3.63% 7.01% 6.34 34.17 14.71
8. Sep 30, 2020 2.97% -3.92% 3.46 25.85 -9.46
9. Oct 31, 2020 7.16% -2.77% 36.52 15.43 -23.74
10. Nov 30, 2020 -1.72% 10.75% 8.03 92.03 -27.19
11. Dec 31, 2020 0.22% 3.71% 0.80 6.51 -2.28
12. Jan 31, 2021 9.43% -1.11% 69.15 5.18 -18.92
13. Feb 28, 2021 -11.70% 2.61% 164.12 2.10 -18.55
14. Mar 31, 2021 1.46% 4.24% 0.12 9.50 1.06
15. Apr 30, 2021 3.03% 5.24% 3.69 16.66 7.84
16. May 31, 2021 -0.16% 0.55% 1.61 0.38 0.78
17. Jun 30, 2021 7.50% 2.22% 40.83 1.12 6.77
18. Jul 31, 2021 7.05% 2.27% 35.18 1.24 6.60
19. Aug 31, 2021 2.77% 2.90% 2.73 3.02 2.87
20. Sep 30, 2021 3.00% -4.76% 3.55 35.02 -11.15
21. Oct 31, 2021 10.81% 6.91% 93.94 33.10 55.76
22. Nov 30, 2021 -0.04% -0.83% 1.33 3.98 2.30
23. Dec 31, 2021 5.48% 4.36% 19.05 10.24 13.97
24. Jan 31, 2022 -12.88% -5.26% 195.83 41.21 89.84
25. Feb 28, 2022 -6.42% -3.14% 56.71 18.47 32.36
26. Mar 31, 2022 8.63% 3.58% 56.50 5.84 18.16
27. Apr 30, 2022 -6.39% -8.80% 56.28 99.14 74.69
28. May 31, 2022 2.65% 0.01% 2.36 1.34 -1.78
29. Jun 30, 2022 -4.23% -8.39% 28.52 91.26 51.02
30. Jul 31, 2022 10.15% 9.11% 81.61 63.21 71.82
31. Aug 31, 2022 -8.87% -4.24% 99.71 29.22 53.98
32. Sep 30, 2022 -6.94% -9.34% 64.82 110.27 84.54
33. Oct 31, 2022 1.34% 7.99% 0.05 46.58 1.52
34. Nov 30, 2022 9.00% 5.38% 62.17 17.76 33.23
35. Dec 31, 2022 -1.65% -5.90% 7.63 49.82 19.49
36. Jan 31, 2023 3.57% 6.18% 6.02 25.14 12.30
37. Feb 28, 2023 -5.01% -2.61% 37.49 14.23 23.10
38. Mar 31, 2023 6.45% 3.51% 28.51 5.49 12.51
39. Apr 30, 2023 -3.73% 1.46% 23.42 0.09 -1.47
40. May 31, 2023 -8.37% 0.25% 89.93 0.83 8.66
41. Jun 30, 2023 2.68% 4.71% 2.46 12.62 5.57
42. Jul 31, 2023 5.16% 4.85% 16.35 13.58 14.90
43. Aug 31, 2023 1.54% -1.77% 0.18 8.60 -1.24
44. Sep 30, 2023 -9.08% -4.87% 103.90 36.40 61.50
45. Oct 31, 2023 -12.13% -2.20% 175.41 11.28 44.49
46. Nov 30, 2023 11.46% 8.92% 107.13 60.17 80.29
47. Dec 31, 2023 7.14% 4.42% 36.27 10.64 19.64
48. Jan 31, 2024 1.54% 1.59% 0.18 0.18 0.18
49. Feb 29, 2024 5.79% 5.17% 21.85 16.09 18.75
50. Mar 31, 2024 2.00% 3.10% 0.79 3.77 1.73
51. Apr 30, 2024 -2.15% -4.16% 10.65 28.33 17.37
52. May 31, 2024 -0.13% 4.80% 1.55 13.26 -4.53
53. Jun 30, 2024 -2.57% 3.47% 13.56 5.32 -8.49
54. Jul 31, 2024 10.91% 1.13% 95.99 0.00 -0.29
55. Aug 31, 2024 0.28% 2.28% 0.69 1.26 -0.93
56. Sep 30, 2024 0.63% 2.02% 0.23 0.74 -0.41
57. Oct 31, 2024 -11.68% -0.99% 163.69 4.63 27.52
58. Nov 30, 2024 -3.05% 5.73% 17.38 20.87 -19.05
59. Dec 31, 2024 -1.70% -2.50% 7.92 13.40 10.30
Total (Σ): 2,720.47 1,618.62 1,244.30

Show all

VarianceTMO = Σ(RTMO,tRTMO)2 ÷ (59 – 1)
= 2,720.47 ÷ (59 – 1)
= 46.90

VarianceS&P 500 = Σ(RS&P 500,tRS&P 500)2 ÷ (59 – 1)
= 1,618.62 ÷ (59 – 1)
= 27.91

CovarianceTMO, S&P 500 = Σ(RTMO,tRTMO)×(RS&P 500,tRS&P 500) ÷ (59 – 1)
= 1,244.30 ÷ (59 – 1)
= 21.45


Systematic Risk (β) Estimation

Microsoft Excel
VarianceTMO 46.90
VarianceS&P 500 27.91
CovarianceTMO, S&P 500 21.45
Correlation coefficientTMO, S&P 5001 0.59
βTMO2 0.77
αTMO3 0.22%

Calculations

1 Correlation coefficientTMO, S&P 500
= CovarianceTMO, S&P 500 ÷ (Standard deviationTMO × Standard deviationS&P 500)
= 21.45 ÷ (6.85% × 5.28%)
= 0.59

2 βTMO
= CovarianceTMO, S&P 500 ÷ VarianceS&P 500
= 21.45 ÷ 27.91
= 0.77

3 αTMO
= AverageTMO – βTMO × AverageS&P 500
= 1.11%0.77 × 1.16%
= 0.22%


Expected Rate of Return

Microsoft Excel
Assumptions
Rate of return on LT Treasury Composite1 RF 4.78%
Expected rate of return on market portfolio2 E(RM) 14.43%
Systematic risk (β) of Thermo Fisher Scientific Inc. common stock βTMO 0.77
 
Expected rate of return on Thermo Fisher Scientific Inc. common stock3 E(RTMO) 12.19%

1 Unweighted average of bid yields on all outstanding fixed-coupon U.S. Treasury bonds neither due or callable in less than 10 years (risk-free rate of return proxy).

2 See details »

3 E(RTMO) = RF + βTMO [E(RM) – RF]
= 4.78% + 0.77 [14.43%4.78%]
= 12.19%