AI Tokens
Stock Analysis on Net

Qualcomm Inc. (NASDAQ:QCOM)

Capital Asset Pricing Model (CAPM)

Microsoft Excel

Rates of Return

Qualcomm Inc., monthly rates of return

Microsoft Excel
Qualcomm Inc. (QCOM) Standard & Poor’s 500 (S&P 500)
t Date PriceQCOM,t1 DividendQCOM,t1 RQCOM,t2 PriceS&P 500,t RS&P 500,t3
Oct 31, 2020 $123.36 3,269.96
1. Nov 30, 2020 $147.17 19.30% 3,621.63 10.75%
2. Dec 31, 2020 $152.34 $0.65 3.95% 3,756.07 3.71%
3. Jan 31, 2021 $156.28 2.59% 3,714.24 -1.11%
. . . . . . .
. . . . . . .
. . . . . . .
68. Jun 30, 2026 $184.79 $0.92 -26.02% 7,499.36 -1.06%
69. Jul 31, 2026 $147.61 -20.12% 7,489.72 -0.13%
Average (R): 1.14% 1.31%
Standard deviation: 12.37% 4.48%
Qualcomm Inc. (QCOM) Standard & Poor’s 500 (S&P 500)
t Date PriceQCOM,t1 DividendQCOM,t1 RQCOM,t2 PriceS&P 500,t RS&P 500,t3
Oct 31, 2020 $123.36 3,269.96
1. Nov 30, 2020 $147.17 19.30% 3,621.63 10.75%
2. Dec 31, 2020 $152.34 $0.65 3.95% 3,756.07 3.71%
3. Jan 31, 2021 $156.28 2.59% 3,714.24 -1.11%
4. Feb 28, 2021 $136.19 -12.86% 3,811.15 2.61%
5. Mar 31, 2021 $132.59 $0.65 -2.17% 3,972.89 4.24%
6. Apr 30, 2021 $138.80 4.68% 4,181.17 5.24%
7. May 31, 2021 $134.54 -3.07% 4,204.11 0.55%
8. Jun 30, 2021 $142.93 $0.68 6.74% 4,297.50 2.22%
9. Jul 31, 2021 $149.80 4.81% 4,395.26 2.27%
10. Aug 31, 2021 $146.69 -2.08% 4,522.68 2.90%
11. Sep 30, 2021 $128.98 $0.68 -11.61% 4,307.54 -4.76%
12. Oct 31, 2021 $133.04 3.15% 4,605.38 6.91%
13. Nov 30, 2021 $180.56 35.72% 4,567.00 -0.83%
14. Dec 31, 2021 $182.87 $0.68 1.66% 4,766.18 4.36%
15. Jan 31, 2022 $175.76 -3.89% 4,515.55 -5.26%
16. Feb 28, 2022 $171.99 -2.14% 4,373.94 -3.14%
17. Mar 31, 2022 $152.82 $0.68 -10.75% 4,530.41 3.58%
18. Apr 30, 2022 $139.69 -8.59% 4,131.93 -8.80%
19. May 31, 2022 $143.22 2.53% 4,132.15 0.01%
20. Jun 30, 2022 $127.74 $0.75 -10.28% 3,785.38 -8.39%
21. Jul 31, 2022 $145.06 13.56% 4,130.29 9.11%
22. Aug 31, 2022 $132.27 $0.75 -8.30% 3,955.00 -4.24%
23. Sep 30, 2022 $112.98 -14.58% 3,585.62 -9.34%
24. Oct 31, 2022 $117.66 4.14% 3,871.98 7.99%
25. Nov 30, 2022 $126.49 $0.75 8.14% 4,080.11 5.38%
26. Dec 31, 2022 $109.94 -13.08% 3,839.50 -5.90%
27. Jan 31, 2023 $133.21 21.17% 4,076.60 6.18%
28. Feb 28, 2023 $123.53 -7.27% 3,970.15 -2.61%
29. Mar 31, 2023 $127.58 $0.75 3.89% 4,109.31 3.51%
30. Apr 30, 2023 $116.80 -8.45% 4,169.48 1.46%
31. May 31, 2023 $113.41 $0.80 -2.22% 4,179.83 0.25%
32. Jun 30, 2023 $119.04 4.96% 4,376.86 4.71%
33. Jul 31, 2023 $132.17 11.03% 4,588.96 4.85%
34. Aug 31, 2023 $114.53 $0.80 -12.74% 4,507.66 -1.77%
35. Sep 30, 2023 $111.06 -3.03% 4,288.05 -4.87%
36. Oct 31, 2023 $108.99 -1.86% 4,193.80 -2.20%
37. Nov 30, 2023 $129.05 $0.80 19.14% 4,567.80 8.92%
38. Dec 31, 2023 $144.63 12.07% 4,769.83 4.42%
39. Jan 31, 2024 $148.51 2.68% 4,845.65 1.59%
40. Feb 29, 2024 $157.79 $0.80 6.79% 5,096.27 5.17%
41. Mar 31, 2024 $169.30 7.29% 5,254.35 3.10%
42. Apr 30, 2024 $165.85 -2.04% 5,035.69 -4.16%
43. May 31, 2024 $204.05 $0.85 23.55% 5,277.51 4.80%
44. Jun 30, 2024 $199.18 -2.39% 5,460.48 3.47%
45. Jul 31, 2024 $180.95 -9.15% 5,522.30 1.13%
46. Aug 31, 2024 $175.30 -3.12% 5,648.40 2.28%
47. Sep 30, 2024 $170.05 $0.85 -2.51% 5,762.48 2.02%
48. Oct 31, 2024 $162.77 -4.28% 5,705.45 -0.99%
49. Nov 30, 2024 $158.53 -2.60% 6,032.38 5.73%
50. Dec 31, 2024 $153.62 $0.85 -2.56% 5,881.63 -2.50%
51. Jan 31, 2025 $172.93 12.57% 6,040.53 2.70%
52. Feb 28, 2025 $157.17 -9.11% 5,954.50 -1.42%
53. Mar 31, 2025 $153.61 $0.85 -1.72% 5,611.85 -5.75%
54. Apr 30, 2025 $148.46 -3.35% 5,569.06 -0.76%
55. May 31, 2025 $145.20 -2.20% 5,911.69 6.15%
56. Jun 30, 2025 $159.26 $0.89 10.30% 6,204.95 4.96%
57. Jul 31, 2025 $146.76 -7.85% 6,339.39 2.17%
58. Aug 31, 2025 $160.73 9.52% 6,460.26 1.91%
59. Sep 30, 2025 $166.36 $0.89 4.06% 6,688.46 3.53%
60. Oct 31, 2025 $180.90 8.74% 6,840.20 2.27%
61. Nov 30, 2025 $168.09 -7.08% 6,849.09 0.13%
62. Dec 31, 2025 $171.05 $0.89 2.29% 6,845.50 -0.05%
63. Jan 31, 2026 $151.59 -11.38% 6,939.03 1.37%
64. Feb 28, 2026 $142.36 -6.09% 6,878.88 -0.87%
65. Mar 31, 2026 $128.78 $0.89 -8.91% 6,528.52 -5.09%
66. Apr 30, 2026 $179.58 39.45% 7,209.01 10.42%
67. May 31, 2026 $251.02 39.78% 7,580.06 5.15%
68. Jun 30, 2026 $184.79 $0.92 -26.02% 7,499.36 -1.06%
69. Jul 31, 2026 $147.61 -20.12% 7,489.72 -0.13%
Average (R): 1.14% 1.31%
Standard deviation: 12.37% 4.48%

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

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


Variance and Covariance

Qualcomm Inc., calculation of variance and covariance of returns

Microsoft Excel
t Date RQCOM,t RS&P 500,t (RQCOM,t–RQCOM)2 (RS&P 500,t–RS&P 500)2 (RQCOM,t–RQCOM)×(RS&P 500,t–RS&P 500)
1. Nov 30, 2020 19.30% 10.75% 329.77 89.26 171.57
2. Dec 31, 2020 3.95% 3.71% 7.91 5.79 6.77
3. Jan 31, 2021 2.59% -1.11% 2.09 5.86 -3.50
. . . . . . .
. . . . . . .
. . . . . . .
68. Jun 30, 2026 -26.02% -1.06% 737.64 5.62 64.41
69. Jul 31, 2026 -20.12% -0.13% 452.06 2.06 30.52
Total (Σ): 10,404.40 1,362.09 2,224.25
t Date RQCOM,t RS&P 500,t (RQCOM,t–RQCOM)2 (RS&P 500,t–RS&P 500)2 (RQCOM,t–RQCOM)×(RS&P 500,t–RS&P 500)
1. Nov 30, 2020 19.30% 10.75% 329.77 89.26 171.57
2. Dec 31, 2020 3.95% 3.71% 7.91 5.79 6.77
3. Jan 31, 2021 2.59% -1.11% 2.09 5.86 -3.50
4. Feb 28, 2021 -12.86% 2.61% 195.91 1.70 -18.23
5. Mar 31, 2021 -2.17% 4.24% 10.94 8.63 -9.72
6. Apr 30, 2021 4.68% 5.24% 12.55 15.49 13.94
7. May 31, 2021 -3.07% 0.55% 17.73 0.57 3.19
8. Jun 30, 2021 6.74% 2.22% 31.36 0.84 5.12
9. Jul 31, 2021 4.81% 2.27% 13.43 0.94 3.55
10. Aug 31, 2021 -2.08% 2.90% 10.35 2.54 -5.12
11. Sep 30, 2021 -11.61% -4.76% 162.59 36.77 77.32
12. Oct 31, 2021 3.15% 6.91% 4.02 31.45 11.25
13. Nov 30, 2021 35.72% -0.83% 1,195.57 4.58 -74.00
14. Dec 31, 2021 1.66% 4.36% 0.26 9.33 1.57
15. Jan 31, 2022 -3.89% -5.26% 25.30 43.10 33.02
16. Feb 28, 2022 -2.14% -3.14% 10.80 19.74 14.60
17. Mar 31, 2022 -10.75% 3.58% 141.43 5.16 -27.00
18. Apr 30, 2022 -8.59% -8.80% 94.74 102.06 98.33
19. May 31, 2022 2.53% 0.01% 1.92 1.69 -1.80
20. Jun 30, 2022 -10.28% -8.39% 130.57 94.07 110.82
21. Jul 31, 2022 13.56% 9.11% 154.19 60.92 96.91
22. Aug 31, 2022 -8.30% -4.24% 89.14 30.81 52.41
23. Sep 30, 2022 -14.58% -9.34% 247.29 113.34 167.42
24. Oct 31, 2022 4.14% 7.99% 9.00 44.62 20.04
25. Nov 30, 2022 8.14% 5.38% 49.01 16.55 28.48
26. Dec 31, 2022 -13.08% -5.90% 202.37 51.90 102.48
27. Jan 31, 2023 21.17% 6.18% 400.98 23.70 97.49
28. Feb 28, 2023 -7.27% -2.61% 70.70 15.35 32.94
29. Mar 31, 2023 3.89% 3.51% 7.53 4.83 6.03
30. Apr 30, 2023 -8.45% 1.46% 91.99 0.02 -1.51
31. May 31, 2023 -2.22% 0.25% 11.28 1.12 3.56
32. Jun 30, 2023 4.96% 4.71% 14.61 11.61 13.02
33. Jul 31, 2023 11.03% 4.85% 97.78 12.53 35.00
34. Aug 31, 2023 -12.74% -1.77% 192.73 9.48 42.74
35. Sep 30, 2023 -3.03% -4.87% 17.40 38.18 25.77
36. Oct 31, 2023 -1.86% -2.20% 9.03 12.28 10.53
37. Nov 30, 2023 19.14% 8.92% 323.92 57.93 136.98
38. Dec 31, 2023 12.07% 4.42% 119.49 9.71 34.06
39. Jan 31, 2024 2.68% 1.59% 2.37 0.08 0.44
40. Feb 29, 2024 6.79% 5.17% 31.87 14.94 21.82
41. Mar 31, 2024 7.29% 3.10% 37.86 3.22 11.04
42. Apr 30, 2024 -2.04% -4.16% 10.11 29.90 17.39
43. May 31, 2024 23.55% 4.80% 501.93 12.22 78.31
44. Jun 30, 2024 -2.39% 3.47% 12.45 4.67 -7.62
45. Jul 31, 2024 -9.15% 1.13% 105.97 0.03 1.80
46. Aug 31, 2024 -3.12% 2.28% 18.18 0.95 -4.16
47. Sep 30, 2024 -2.51% 2.02% 13.33 0.51 -2.60
48. Oct 31, 2024 -4.28% -0.99% 29.41 5.27 12.45
49. Nov 30, 2024 -2.60% 5.73% 14.04 19.57 -16.57
50. Dec 31, 2024 -2.56% -2.50% 13.71 14.48 14.09
51. Jan 31, 2025 12.57% 2.70% 130.61 1.95 15.94
52. Feb 28, 2025 -9.11% -1.42% 105.17 7.46 28.01
53. Mar 31, 2025 -1.72% -5.75% 8.21 49.86 20.24
54. Apr 30, 2025 -3.35% -0.76% 20.20 4.28 9.30
55. May 31, 2025 -2.20% 6.15% 11.14 23.48 -16.17
56. Jun 30, 2025 10.30% 4.96% 83.81 13.35 33.45
57. Jul 31, 2025 -7.85% 2.17% 80.83 0.74 -7.73
58. Aug 31, 2025 9.52% 1.91% 70.18 0.36 5.03
59. Sep 30, 2025 4.06% 3.53% 8.50 4.95 6.49
60. Oct 31, 2025 8.74% 2.27% 57.74 0.93 7.31
61. Nov 30, 2025 -7.08% 0.13% 67.62 1.38 9.68
62. Dec 31, 2025 2.29% -0.05% 1.32 1.85 -1.56
63. Jan 31, 2026 -11.38% 1.37% 156.71 0.00 -0.75
64. Feb 28, 2026 -6.09% -0.87% 52.28 4.72 15.72
65. Mar 31, 2026 -8.91% -5.09% 101.12 40.96 64.36
66. Apr 30, 2026 39.45% 10.42% 1,467.31 83.11 349.21
67. May 31, 2026 39.78% 5.15% 1,493.06 14.75 148.39
68. Jun 30, 2026 -26.02% -1.06% 737.64 5.62 64.41
69. Jul 31, 2026 -20.12% -0.13% 452.06 2.06 30.52
Total (Σ): 10,404.40 1,362.09 2,224.25

Show all

VarianceQCOM = Σ(RQCOM,t–RQCOM)2 ÷ (69 – 1)
= 10,404.40 ÷ (69 – 1)
= 153.01

VarianceS&P 500 = Σ(RS&P 500,t–RS&P 500)2 ÷ (69 – 1)
= 1,362.09 ÷ (69 – 1)
= 20.03

CovarianceQCOM, S&P 500 = Σ(RQCOM,t–RQCOM)×(RS&P 500,t–RS&P 500) ÷ (69 – 1)
= 2,224.25 ÷ (69 – 1)
= 32.71


Systematic Risk (β) Estimation

Microsoft Excel
VarianceQCOM 153.01
VarianceS&P 500 20.03
CovarianceQCOM, S&P 500 32.71
Correlation coefficientQCOM, S&P 5001 0.59
βQCOM2 1.63
αQCOM3 -0.99%

Calculations

1 Correlation coefficientQCOM, S&P 500
= CovarianceQCOM, S&P 500 ÷ (Standard deviationQCOM × Standard deviationS&P 500)
= 32.71 ÷ (12.37% × 4.48%)
= 0.59

2 βQCOM
= CovarianceQCOM, S&P 500 ÷ VarianceS&P 500
= 32.71 ÷ 20.03
= 1.63

3 αQCOM
= AverageQCOM – βQCOM × AverageS&P 500
= 1.14% – 1.63 × 1.31%
= -0.99%


Expected Rate of Return

Microsoft Excel
Assumptions
Rate of return on LT Treasury Composite1 RF 5.30%
Expected rate of return on market portfolio2 E(RM) 17.45%
Systematic risk (β) of Qualcomm Inc. common stock βQCOM 1.63
 
Expected rate of return on Qualcomm Inc. common stock3 E(RQCOM) 25.14%

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(RQCOM) = RF + βQCOM [E(RM) – RF]
= 5.30% + 1.63 [17.45% – 5.30%]
= 25.14%