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, 2018 $62.89 2,711.74
1. Nov 30, 2018 $58.26 -7.36% 2,760.17 1.79%
2. Dec 31, 2018 $56.91 $0.62 -1.25% 2,506.85 -9.18%
3. Jan 31, 2019 $49.52 -12.99% 2,704.10 7.87%
. . . . . . .
. . . . . . .
. . . . . . .
70. Aug 31, 2024 $175.30 -3.12% 5,648.40 2.28%
71. Sep 30, 2024 $170.05 $0.85 -2.51% 5,762.48 2.02%
Average (R): 2.27% 1.20%
Standard deviation: 11.90% 5.15%
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, 2018 $62.89 2,711.74
1. Nov 30, 2018 $58.26 -7.36% 2,760.17 1.79%
2. Dec 31, 2018 $56.91 $0.62 -1.25% 2,506.85 -9.18%
3. Jan 31, 2019 $49.52 -12.99% 2,704.10 7.87%
4. Feb 28, 2019 $53.39 7.82% 2,784.49 2.97%
5. Mar 31, 2019 $57.03 $0.62 7.98% 2,834.40 1.79%
6. Apr 30, 2019 $86.13 51.03% 2,945.83 3.93%
7. May 31, 2019 $66.82 -22.42% 2,752.06 -6.58%
8. Jun 30, 2019 $76.07 $0.62 14.77% 2,941.76 6.89%
9. Jul 31, 2019 $73.16 -3.83% 2,980.38 1.31%
10. Aug 31, 2019 $77.77 6.30% 2,926.46 -1.81%
11. Sep 30, 2019 $76.28 $0.62 -1.12% 2,976.74 1.72%
12. Oct 31, 2019 $80.44 5.45% 3,037.56 2.04%
13. Nov 30, 2019 $83.55 3.87% 3,140.98 3.40%
14. Dec 31, 2019 $88.23 $0.62 6.34% 3,230.78 2.86%
15. Jan 31, 2020 $85.31 -3.31% 3,225.52 -0.16%
16. Feb 29, 2020 $78.30 -8.22% 2,954.22 -8.41%
17. Mar 31, 2020 $67.65 $0.62 -12.81% 2,584.59 -12.51%
18. Apr 30, 2020 $78.67 16.29% 2,912.43 12.68%
19. May 31, 2020 $80.88 2.81% 3,044.31 4.53%
20. Jun 30, 2020 $91.21 $0.65 13.58% 3,100.29 1.84%
21. Jul 31, 2020 $105.61 15.79% 3,271.12 5.51%
22. Aug 31, 2020 $119.10 12.77% 3,500.31 7.01%
23. Sep 30, 2020 $117.68 $0.65 -0.65% 3,363.00 -3.92%
24. Oct 31, 2020 $123.36 4.83% 3,269.96 -2.77%
25. Nov 30, 2020 $147.17 19.30% 3,621.63 10.75%
26. Dec 31, 2020 $152.34 $0.65 3.95% 3,756.07 3.71%
27. Jan 31, 2021 $156.28 2.59% 3,714.24 -1.11%
28. Feb 28, 2021 $136.19 -12.86% 3,811.15 2.61%
29. Mar 31, 2021 $132.59 $0.65 -2.17% 3,972.89 4.24%
30. Apr 30, 2021 $138.80 4.68% 4,181.17 5.24%
31. May 31, 2021 $134.54 -3.07% 4,204.11 0.55%
32. Jun 30, 2021 $142.93 $0.68 6.74% 4,297.50 2.22%
33. Jul 31, 2021 $149.80 4.81% 4,395.26 2.27%
34. Aug 31, 2021 $146.69 -2.08% 4,522.68 2.90%
35. Sep 30, 2021 $128.98 $0.68 -11.61% 4,307.54 -4.76%
36. Oct 31, 2021 $133.04 3.15% 4,605.38 6.91%
37. Nov 30, 2021 $180.56 35.72% 4,567.00 -0.83%
38. Dec 31, 2021 $182.87 $0.68 1.66% 4,766.18 4.36%
39. Jan 31, 2022 $175.76 -3.89% 4,515.55 -5.26%
40. Feb 28, 2022 $171.99 -2.14% 4,373.94 -3.14%
41. Mar 31, 2022 $152.82 $0.68 -10.75% 4,530.41 3.58%
42. Apr 30, 2022 $139.69 -8.59% 4,131.93 -8.80%
43. May 31, 2022 $143.22 2.53% 4,132.15 0.01%
44. Jun 30, 2022 $127.74 $0.75 -10.28% 3,785.38 -8.39%
45. Jul 31, 2022 $145.06 13.56% 4,130.29 9.11%
46. Aug 31, 2022 $132.27 $0.75 -8.30% 3,955.00 -4.24%
47. Sep 30, 2022 $112.98 -14.58% 3,585.62 -9.34%
48. Oct 31, 2022 $117.66 4.14% 3,871.98 7.99%
49. Nov 30, 2022 $126.49 $0.75 8.14% 4,080.11 5.38%
50. Dec 31, 2022 $109.94 -13.08% 3,839.50 -5.90%
51. Jan 31, 2023 $133.21 21.17% 4,076.60 6.18%
52. Feb 28, 2023 $123.53 -7.27% 3,970.15 -2.61%
53. Mar 31, 2023 $127.58 $0.75 3.89% 4,109.31 3.51%
54. Apr 30, 2023 $116.80 -8.45% 4,169.48 1.46%
55. May 31, 2023 $113.41 $0.80 -2.22% 4,179.83 0.25%
56. Jun 30, 2023 $119.04 4.96% 4,376.86 4.71%
57. Jul 31, 2023 $132.17 11.03% 4,588.96 4.85%
58. Aug 31, 2023 $114.53 $0.80 -12.74% 4,507.66 -1.77%
59. Sep 30, 2023 $111.06 -3.03% 4,288.05 -4.87%
60. Oct 31, 2023 $108.99 -1.86% 4,193.80 -2.20%
61. Nov 30, 2023 $129.05 $0.80 19.14% 4,567.80 8.92%
62. Dec 31, 2023 $144.63 12.07% 4,769.83 4.42%
63. Jan 31, 2024 $148.51 2.68% 4,845.65 1.59%
64. Feb 29, 2024 $157.79 $0.80 6.79% 5,096.27 5.17%
65. Mar 31, 2024 $169.30 7.29% 5,254.35 3.10%
66. Apr 30, 2024 $165.85 -2.04% 5,035.69 -4.16%
67. May 31, 2024 $204.05 $0.85 23.55% 5,277.51 4.80%
68. Jun 30, 2024 $199.18 -2.39% 5,460.48 3.47%
69. Jul 31, 2024 $180.95 -9.15% 5,522.30 1.13%
70. Aug 31, 2024 $175.30 -3.12% 5,648.40 2.28%
71. Sep 30, 2024 $170.05 $0.85 -2.51% 5,762.48 2.02%
Average (R): 2.27% 1.20%
Standard deviation: 11.90% 5.15%

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,tRQCOM)2 (RS&P 500,tRS&P 500)2 (RQCOM,tRQCOM)×(RS&P 500,tRS&P 500)
1. Nov 30, 2018 -7.36% 1.79% 92.74 0.34 -5.65
2. Dec 31, 2018 -1.25% -9.18% 12.40 107.68 36.54
3. Jan 31, 2019 -12.99% 7.87% 232.66 44.48 -101.73
. . . . . . .
. . . . . . .
. . . . . . .
70. Aug 31, 2024 -3.12% 2.28% 29.06 1.18 -5.85
71. Sep 30, 2024 -2.51% 2.02% 22.83 0.67 -3.92
Total (Σ): 9,914.88 1,855.59 2,373.43
t Date RQCOM,t RS&P 500,t (RQCOM,tRQCOM)2 (RS&P 500,tRS&P 500)2 (RQCOM,tRQCOM)×(RS&P 500,tRS&P 500)
1. Nov 30, 2018 -7.36% 1.79% 92.74 0.34 -5.65
2. Dec 31, 2018 -1.25% -9.18% 12.40 107.68 36.54
3. Jan 31, 2019 -12.99% 7.87% 232.66 44.48 -101.73
4. Feb 28, 2019 7.82% 2.97% 30.77 3.15 9.84
5. Mar 31, 2019 7.98% 1.79% 32.62 0.35 3.39
6. Apr 30, 2019 51.03% 3.93% 2,377.33 7.47 133.22
7. May 31, 2019 -22.42% -6.58% 609.47 60.48 191.99
8. Jun 30, 2019 14.77% 6.89% 156.33 32.42 71.19
9. Jul 31, 2019 -3.83% 1.31% 37.13 0.01 -0.69
10. Aug 31, 2019 6.30% -1.81% 16.27 9.05 -12.13
11. Sep 30, 2019 -1.12% 1.72% 11.47 0.27 -1.76
12. Oct 31, 2019 5.45% 2.04% 10.15 0.71 2.69
13. Nov 30, 2019 3.87% 3.40% 2.55 4.87 3.53
14. Dec 31, 2019 6.34% 2.86% 16.61 2.76 6.77
15. Jan 31, 2020 -3.31% -0.16% 31.11 1.85 7.60
16. Feb 29, 2020 -8.22% -8.41% 109.94 92.35 100.76
17. Mar 31, 2020 -12.81% -12.51% 227.34 187.99 206.73
18. Apr 30, 2020 16.29% 12.68% 196.61 131.91 161.05
19. May 31, 2020 2.81% 4.53% 0.29 11.08 1.80
20. Jun 30, 2020 13.58% 1.84% 127.86 0.41 7.24
21. Jul 31, 2020 15.79% 5.51% 182.79 18.59 58.29
22. Aug 31, 2020 12.77% 7.01% 110.37 33.73 61.01
23. Sep 30, 2020 -0.65% -3.92% 8.49 26.23 14.93
24. Oct 31, 2020 4.83% -2.77% 6.55 15.73 -10.15
25. Nov 30, 2020 19.30% 10.75% 290.13 91.31 162.76
26. Dec 31, 2020 3.95% 3.71% 2.84 6.32 4.24
27. Jan 31, 2021 2.59% -1.11% 0.10 5.35 -0.74
28. Feb 28, 2021 -12.86% 2.61% 228.71 1.99 -21.33
29. Mar 31, 2021 -2.17% 4.24% 19.66 9.27 -13.50
30. Apr 30, 2021 4.68% 5.24% 5.84 16.35 9.77
31. May 31, 2021 -3.07% 0.55% 28.48 0.42 3.47
32. Jun 30, 2021 6.74% 2.22% 20.01 1.05 4.57
33. Jul 31, 2021 4.81% 2.27% 6.44 1.16 2.73
34. Aug 31, 2021 -2.08% 2.90% 18.87 2.89 -7.39
35. Sep 30, 2021 -11.61% -4.76% 192.58 35.47 82.65
36. Oct 31, 2021 3.15% 6.91% 0.77 32.67 5.03
37. Nov 30, 2021 35.72% -0.83% 1,118.95 4.13 -67.98
38. Dec 31, 2021 1.66% 4.36% 0.37 10.00 -1.94
39. Jan 31, 2022 -3.89% -5.26% 37.90 41.70 39.75
40. Feb 28, 2022 -2.14% -3.14% 19.47 18.79 19.13
41. Mar 31, 2022 -10.75% 3.58% 169.48 5.66 -30.96
42. Apr 30, 2022 -8.59% -8.80% 117.93 99.89 108.54
43. May 31, 2022 2.53% 0.01% 0.07 1.42 -0.31
44. Jun 30, 2022 -10.28% -8.39% 157.57 91.99 120.39
45. Jul 31, 2022 13.56% 9.11% 127.48 62.61 89.34
46. Aug 31, 2022 -8.30% -4.24% 111.68 29.63 57.52
47. Sep 30, 2022 -14.58% -9.34% 283.98 111.06 177.59
48. Oct 31, 2022 4.14% 7.99% 3.51 46.07 12.72
49. Nov 30, 2022 8.14% 5.38% 34.51 17.44 24.53
50. Dec 31, 2022 -13.08% -5.90% 235.68 50.36 108.94
51. Jan 31, 2023 21.17% 6.18% 357.14 24.76 94.04
52. Feb 28, 2023 -7.27% -2.61% 90.91 14.52 36.33
53. Mar 31, 2023 3.89% 3.51% 2.62 5.32 3.73
54. Apr 30, 2023 -8.45% 1.46% 114.87 0.07 -2.84
55. May 31, 2023 -2.22% 0.25% 20.12 0.90 4.26
56. Jun 30, 2023 4.96% 4.71% 7.27 12.35 9.48
57. Jul 31, 2023 11.03% 4.85% 76.77 13.30 31.95
58. Aug 31, 2023 -12.74% -1.77% 225.27 8.82 44.59
59. Sep 30, 2023 -3.03% -4.87% 28.07 36.86 32.16
60. Oct 31, 2023 -1.86% -2.20% 17.07 11.54 14.04
61. Nov 30, 2023 19.14% 8.92% 284.65 59.58 130.23
62. Dec 31, 2023 12.07% 4.42% 96.14 10.39 31.61
63. Jan 31, 2024 2.68% 1.59% 0.17 0.15 0.16
64. Feb 29, 2024 6.79% 5.17% 20.43 15.79 17.96
65. Mar 31, 2024 7.29% 3.10% 25.27 3.62 9.57
66. Apr 30, 2024 -2.04% -4.16% 18.54 28.73 23.08
67. May 31, 2024 23.55% 4.80% 452.73 12.98 76.67
68. Jun 30, 2024 -2.39% 3.47% 21.67 5.14 -10.56
69. Jul 31, 2024 -9.15% 1.13% 130.43 0.00 0.76
70. Aug 31, 2024 -3.12% 2.28% 29.06 1.18 -5.85
71. Sep 30, 2024 -2.51% 2.02% 22.83 0.67 -3.92
Total (Σ): 9,914.88 1,855.59 2,373.43

Show all

VarianceQCOM = Σ(RQCOM,tRQCOM)2 ÷ (71 – 1)
= 9,914.88 ÷ (71 – 1)
= 141.64

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

CovarianceQCOM, S&P 500 = Σ(RQCOM,tRQCOM)×(RS&P 500,tRS&P 500) ÷ (71 – 1)
= 2,373.43 ÷ (71 – 1)
= 33.91


Systematic Risk (β) Estimation

Microsoft Excel
VarianceQCOM 141.64
VarianceS&P 500 26.51
CovarianceQCOM, S&P 500 33.91
Correlation coefficientQCOM, S&P 5001 0.55
βQCOM2 1.28
αQCOM3 0.73%

Calculations

1 Correlation coefficientQCOM, S&P 500
= CovarianceQCOM, S&P 500 ÷ (Standard deviationQCOM × Standard deviationS&P 500)
= 33.91 ÷ (11.90% × 5.15%)
= 0.55

2 βQCOM
= CovarianceQCOM, S&P 500 ÷ VarianceS&P 500
= 33.91 ÷ 26.51
= 1.28

3 αQCOM
= AverageQCOM – βQCOM × AverageS&P 500
= 2.27%1.28 × 1.20%
= 0.73%


Expected Rate of Return

Microsoft Excel
Assumptions
Rate of return on LT Treasury Composite1 RF 4.79%
Expected rate of return on market portfolio2 E(RM) 13.79%
Systematic risk (β) of Qualcomm Inc. common stock βQCOM 1.28
 
Expected rate of return on Qualcomm Inc. common stock3 E(RQCOM) 16.31%

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]
= 4.79% + 1.28 [13.79%4.79%]
= 16.31%