Stock Analysis on Net

Analog Devices Inc. (NASDAQ:ADI)

Capital Asset Pricing Model (CAPM) 

Microsoft Excel

Rates of Return

Analog Devices Inc., monthly rates of return

Microsoft Excel
Analog Devices Inc. (ADI) Standard & Poor’s 500 (S&P 500)
t Date PriceADI,t1 DividendADI,t1 RADI,t2 PriceS&P 500,t RS&P 500,t3
Nov 30, 2019 $112.95 3,140.98
1. Dec 31, 2019 $118.84 $0.54 5.69% 3,230.78 2.86%
2. Jan 31, 2020 $109.75 -7.65% 3,225.52 -0.16%
3. Feb 29, 2020 $109.05 $0.62 -0.07% 2,954.22 -8.41%
. . . . . . .
. . . . . . .
. . . . . . .
70. Sep 30, 2025 $245.70 $0.99 -1.84% 6,688.46 3.53%
71. Oct 31, 2025 $234.13 -4.71% 6,840.20 2.27%
Average (R): 1.50% 1.22%
Standard deviation: 8.09% 4.97%
Analog Devices Inc. (ADI) Standard & Poor’s 500 (S&P 500)
t Date PriceADI,t1 DividendADI,t1 RADI,t2 PriceS&P 500,t RS&P 500,t3
Nov 30, 2019 $112.95 3,140.98
1. Dec 31, 2019 $118.84 $0.54 5.69% 3,230.78 2.86%
2. Jan 31, 2020 $109.75 -7.65% 3,225.52 -0.16%
3. Feb 29, 2020 $109.05 $0.62 -0.07% 2,954.22 -8.41%
4. Mar 31, 2020 $89.65 -17.79% 2,584.59 -12.51%
5. Apr 30, 2020 $109.60 22.25% 2,912.43 12.68%
6. May 31, 2020 $112.95 $0.62 3.62% 3,044.31 4.53%
7. Jun 30, 2020 $122.64 8.58% 3,100.29 1.84%
8. Jul 31, 2020 $114.85 -6.35% 3,271.12 5.51%
9. Aug 31, 2020 $116.88 $0.62 2.31% 3,500.31 7.01%
10. Sep 30, 2020 $116.74 -0.12% 3,363.00 -3.92%
11. Oct 31, 2020 $118.53 1.53% 3,269.96 -2.77%
12. Nov 30, 2020 $139.08 17.34% 3,621.63 10.75%
13. Dec 31, 2020 $147.73 $0.62 6.67% 3,756.07 3.71%
14. Jan 31, 2021 $147.33 -0.27% 3,714.24 -1.11%
15. Feb 28, 2021 $155.82 $0.69 6.23% 3,811.15 2.61%
16. Mar 31, 2021 $155.08 -0.47% 3,972.89 4.24%
17. Apr 30, 2021 $153.16 -1.24% 4,181.17 5.24%
18. May 31, 2021 $164.60 $0.69 7.92% 4,204.11 0.55%
19. Jun 30, 2021 $172.16 4.59% 4,297.50 2.22%
20. Jul 31, 2021 $167.42 -2.75% 4,395.26 2.27%
21. Aug 31, 2021 $162.95 $0.69 -2.26% 4,522.68 2.90%
22. Sep 30, 2021 $167.48 2.78% 4,307.54 -4.76%
23. Oct 31, 2021 $173.49 3.59% 4,605.38 6.91%
24. Nov 30, 2021 $180.25 3.90% 4,567.00 -0.83%
25. Dec 31, 2021 $175.77 $0.69 -2.10% 4,766.18 4.36%
26. Jan 31, 2022 $163.97 -6.71% 4,515.55 -5.26%
27. Feb 28, 2022 $160.29 $0.76 -1.78% 4,373.94 -3.14%
28. Mar 31, 2022 $165.18 3.05% 4,530.41 3.58%
29. Apr 30, 2022 $154.38 -6.54% 4,131.93 -8.80%
30. May 31, 2022 $168.40 $0.76 9.57% 4,132.15 0.01%
31. Jun 30, 2022 $146.09 -13.25% 3,785.38 -8.39%
32. Jul 31, 2022 $171.96 17.71% 4,130.29 9.11%
33. Aug 31, 2022 $151.53 $0.76 -11.44% 3,955.00 -4.24%
34. Sep 30, 2022 $139.34 -8.04% 3,585.62 -9.34%
35. Oct 31, 2022 $142.62 2.35% 3,871.98 7.99%
36. Nov 30, 2022 $171.91 20.54% 4,080.11 5.38%
37. Dec 31, 2022 $164.03 $0.76 -4.14% 3,839.50 -5.90%
38. Jan 31, 2023 $171.47 4.54% 4,076.60 6.18%
39. Feb 28, 2023 $183.47 $0.86 7.50% 3,970.15 -2.61%
40. Mar 31, 2023 $197.22 7.49% 4,109.31 3.51%
41. Apr 30, 2023 $179.88 -8.79% 4,169.48 1.46%
42. May 31, 2023 $177.69 -1.22% 4,179.83 0.25%
43. Jun 30, 2023 $194.81 $0.86 10.12% 4,376.86 4.71%
44. Jul 31, 2023 $199.53 2.42% 4,588.96 4.85%
45. Aug 31, 2023 $181.78 -8.90% 4,507.66 -1.77%
46. Sep 30, 2023 $175.09 $0.86 -3.21% 4,288.05 -4.87%
47. Oct 31, 2023 $157.33 -10.14% 4,193.80 -2.20%
48. Nov 30, 2023 $183.38 16.56% 4,567.80 8.92%
49. Dec 31, 2023 $198.56 $0.86 8.75% 4,769.83 4.42%
50. Jan 31, 2024 $192.36 -3.12% 4,845.65 1.59%
51. Feb 29, 2024 $191.82 -0.28% 5,096.27 5.17%
52. Mar 31, 2024 $197.79 $0.92 3.59% 5,254.35 3.10%
53. Apr 30, 2024 $200.61 1.43% 5,035.69 -4.16%
54. May 31, 2024 $234.49 16.89% 5,277.51 4.80%
55. Jun 30, 2024 $228.26 $0.92 -2.26% 5,460.48 3.47%
56. Jul 31, 2024 $231.38 1.37% 5,522.30 1.13%
57. Aug 31, 2024 $234.84 1.50% 5,648.40 2.28%
58. Sep 30, 2024 $230.17 $0.92 -1.60% 5,762.48 2.02%
59. Oct 31, 2024 $223.11 -3.07% 5,705.45 -0.99%
60. Nov 30, 2024 $218.05 -2.27% 6,032.38 5.73%
61. Dec 31, 2024 $212.46 $0.92 -2.14% 5,881.63 -2.50%
62. Jan 31, 2025 $211.89 -0.27% 6,040.53 2.70%
63. Feb 28, 2025 $230.06 8.58% 5,954.50 -1.42%
64. Mar 31, 2025 $201.67 $0.99 -11.91% 5,611.85 -5.75%
65. Apr 30, 2025 $194.92 -3.35% 5,569.06 -0.76%
66. May 31, 2025 $213.98 9.78% 5,911.69 6.15%
67. Jun 30, 2025 $238.02 $0.99 11.70% 6,204.95 4.96%
68. Jul 31, 2025 $224.63 -5.63% 6,339.39 2.17%
69. Aug 31, 2025 $251.31 11.88% 6,460.26 1.91%
70. Sep 30, 2025 $245.70 $0.99 -1.84% 6,688.46 3.53%
71. Oct 31, 2025 $234.13 -4.71% 6,840.20 2.27%
Average (R): 1.50% 1.22%
Standard deviation: 8.09% 4.97%

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 ADI during period t

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


Variance and Covariance

Analog Devices Inc., calculation of variance and covariance of returns

Microsoft Excel
t Date RADI,t RS&P 500,t (RADI,tRADI)2 (RS&P 500,tRS&P 500)2 (RADI,tRADI)×(RS&P 500,tRS&P 500)
1. Dec 31, 2019 5.69% 2.86% 17.57 2.67 6.85
2. Jan 31, 2020 -7.65% -0.16% 83.73 1.93 12.70
3. Feb 29, 2020 -0.07% -8.41% 2.48 92.85 15.17
. . . . . . .
. . . . . . .
. . . . . . .
70. Sep 30, 2025 -1.84% 3.53% 11.16 5.32 -7.71
71. Oct 31, 2025 -4.71% 2.27% 38.57 1.09 -6.48
Total (Σ): 4,582.01 1,731.31 1,841.10
t Date RADI,t RS&P 500,t (RADI,tRADI)2 (RS&P 500,tRS&P 500)2 (RADI,tRADI)×(RS&P 500,tRS&P 500)
1. Dec 31, 2019 5.69% 2.86% 17.57 2.67 6.85
2. Jan 31, 2020 -7.65% -0.16% 83.73 1.93 12.70
3. Feb 29, 2020 -0.07% -8.41% 2.48 92.85 15.17
4. Mar 31, 2020 -17.79% -12.51% 372.17 188.70 265.00
5. Apr 30, 2020 22.25% 12.68% 430.63 131.32 237.81
6. May 31, 2020 3.62% 4.53% 4.50 10.91 7.01
7. Jun 30, 2020 8.58% 1.84% 50.09 0.38 4.35
8. Jul 31, 2020 -6.35% 5.51% 61.68 18.36 -33.66
9. Aug 31, 2020 2.31% 7.01% 0.65 33.43 4.66
10. Sep 30, 2020 -0.12% -3.92% 2.63 26.50 8.35
11. Oct 31, 2020 1.53% -2.77% 0.00 15.93 -0.13
12. Nov 30, 2020 17.34% 10.75% 250.77 90.82 150.91
13. Dec 31, 2020 6.67% 3.71% 26.66 6.19 12.84
14. Jan 31, 2021 -0.27% -1.11% 3.14 5.47 4.14
15. Feb 28, 2021 6.23% 2.61% 22.37 1.92 6.55
16. Mar 31, 2021 -0.47% 4.24% 3.91 9.11 -5.97
17. Apr 30, 2021 -1.24% 5.24% 7.51 16.14 -11.01
18. May 31, 2021 7.92% 0.55% 41.19 0.46 -4.34
19. Jun 30, 2021 4.59% 2.22% 9.56 0.99 3.08
20. Jul 31, 2021 -2.75% 2.27% 18.10 1.10 -4.47
21. Aug 31, 2021 -2.26% 2.90% 14.13 2.80 -6.29
22. Sep 30, 2021 2.78% -4.76% 1.63 35.78 -7.65
23. Oct 31, 2021 3.59% 6.91% 4.36 32.37 11.87
24. Nov 30, 2021 3.90% -0.83% 5.74 4.24 -4.93
25. Dec 31, 2021 -2.10% 4.36% 12.99 9.84 -11.30
26. Jan 31, 2022 -6.71% -5.26% 67.48 42.03 53.26
27. Feb 28, 2022 -1.78% -3.14% 10.77 19.02 14.31
28. Mar 31, 2022 3.05% 3.58% 2.40 5.53 3.64
29. Apr 30, 2022 -6.54% -8.80% 64.64 100.41 80.56
30. May 31, 2022 9.57% 0.01% 65.16 1.49 -9.84
31. Jun 30, 2022 -13.25% -8.39% 217.56 92.48 141.85
32. Jul 31, 2022 17.71% 9.11% 262.66 62.20 127.82
33. Aug 31, 2022 -11.44% -4.24% 167.45 29.91 70.77
34. Sep 30, 2022 -8.04% -9.34% 91.13 111.61 100.85
35. Oct 31, 2022 2.35% 7.99% 0.73 45.72 5.76
36. Nov 30, 2022 20.54% 5.38% 362.35 17.23 79.01
37. Dec 31, 2022 -4.14% -5.90% 31.85 50.72 40.19
38. Jan 31, 2023 4.54% 6.18% 9.21 24.51 15.02
39. Feb 28, 2023 7.50% -2.61% 35.98 14.72 -23.01
40. Mar 31, 2023 7.49% 3.51% 35.91 5.20 13.67
41. Apr 30, 2023 -8.79% 1.46% 105.96 0.06 -2.46
42. May 31, 2023 -1.22% 0.25% 7.39 0.95 2.66
43. Jun 30, 2023 10.12% 4.71% 74.26 12.17 30.07
44. Jul 31, 2023 2.42% 4.85% 0.85 13.11 3.34
45. Aug 31, 2023 -8.90% -1.77% 108.11 8.98 31.16
46. Sep 30, 2023 -3.21% -4.87% 22.17 37.17 28.71
47. Oct 31, 2023 -10.14% -2.20% 135.60 11.72 39.86
48. Nov 30, 2023 16.56% 8.92% 226.68 59.18 115.83
49. Dec 31, 2023 8.75% 4.42% 52.49 10.23 23.17
50. Jan 31, 2024 -3.12% 1.59% 21.38 0.13 -1.69
51. Feb 29, 2024 -0.28% 5.17% 3.18 15.58 -7.04
52. Mar 31, 2024 3.59% 3.10% 4.37 3.52 3.92
53. Apr 30, 2024 1.43% -4.16% 0.01 29.01 0.41
54. May 31, 2024 16.89% 4.80% 236.76 12.80 55.04
55. Jun 30, 2024 -2.26% 3.47% 14.18 5.03 -8.44
56. Jul 31, 2024 1.37% 1.13% 0.02 0.01 0.01
57. Aug 31, 2024 1.50% 2.28% 0.00 1.12 -0.01
58. Sep 30, 2024 -1.60% 2.02% 9.60 0.63 -2.46
59. Oct 31, 2024 -3.07% -0.99% 20.87 4.90 10.12
60. Nov 30, 2024 -2.27% 5.73% 14.21 20.30 -16.98
61. Dec 31, 2024 -2.14% -2.50% 13.27 13.87 13.57
62. Jan 31, 2025 -0.27% 2.70% 3.13 2.18 -2.61
63. Feb 28, 2025 8.58% -1.42% 50.04 7.02 -18.74
64. Mar 31, 2025 -11.91% -5.75% 179.87 48.71 93.60
65. Apr 30, 2025 -3.35% -0.76% 23.51 3.95 9.64
66. May 31, 2025 9.78% 6.15% 68.51 24.28 40.78
67. Jun 30, 2025 11.70% 4.96% 103.95 13.96 38.09
68. Jul 31, 2025 -5.63% 2.17% 50.80 0.89 -6.71
69. Aug 31, 2025 11.88% 1.91% 107.66 0.46 7.07
70. Sep 30, 2025 -1.84% 3.53% 11.16 5.32 -7.71
71. Oct 31, 2025 -4.71% 2.27% 38.57 1.09 -6.48
Total (Σ): 4,582.01 1,731.31 1,841.10

Show all

VarianceADI = Σ(RADI,tRADI)2 ÷ (71 – 1)
= 4,582.01 ÷ (71 – 1)
= 65.46

VarianceS&P 500 = Σ(RS&P 500,tRS&P 500)2 ÷ (71 – 1)
= 1,731.31 ÷ (71 – 1)
= 24.73

CovarianceADI, S&P 500 = Σ(RADI,tRADI)×(RS&P 500,tRS&P 500) ÷ (71 – 1)
= 1,841.10 ÷ (71 – 1)
= 26.30


Systematic Risk (β) Estimation

Microsoft Excel
VarianceADI 65.46
VarianceS&P 500 24.73
CovarianceADI, S&P 500 26.30
Correlation coefficientADI, S&P 5001 0.65
βADI2 1.06
αADI3 0.20%

Calculations

1 Correlation coefficientADI, S&P 500
= CovarianceADI, S&P 500 ÷ (Standard deviationADI × Standard deviationS&P 500)
= 26.30 ÷ (8.09% × 4.97%)
= 0.65

2 βADI
= CovarianceADI, S&P 500 ÷ VarianceS&P 500
= 26.30 ÷ 24.73
= 1.06

3 αADI
= AverageADI – βADI × AverageS&P 500
= 1.50%1.06 × 1.22%
= 0.20%


Expected Rate of Return

Microsoft Excel
Assumptions
Rate of return on LT Treasury Composite1 RF 4.75%
Expected rate of return on market portfolio2 E(RM) 14.88%
Systematic risk (β) of Analog Devices Inc. common stock βADI 1.06
 
Expected rate of return on Analog Devices Inc. common stock3 E(RADI) 15.53%

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(RADI) = RF + βADI [E(RM) – RF]
= 4.75% + 1.06 [14.88%4.75%]
= 15.53%