Stock Analysis on Net

Starbucks Corp. (NASDAQ:SBUX)

Capital Asset Pricing Model (CAPM) 

Microsoft Excel

Rates of Return

Starbucks Corp., monthly rates of return

Microsoft Excel
Starbucks Corp. (SBUX) Standard & Poor’s 500 (S&P 500)
t Date PriceSBUX,t1 DividendSBUX,t1 RSBUX,t2 PriceS&P 500,t RS&P 500,t3
Oct 31, 2019 $84.56 3,037.56
1. Nov 30, 2019 $85.43 $0.41 1.51% 3,140.98 3.40%
2. Dec 31, 2019 $87.92 2.91% 3,230.78 2.86%
3. Jan 31, 2020 $84.83 -3.51% 3,225.52 -0.16%
. . . . . . .
. . . . . . .
. . . . . . .
70. Aug 31, 2025 $88.19 $0.61 -0.40% 6,460.26 1.91%
71. Sep 30, 2025 $84.60 -4.07% 6,688.46 3.53%
Average (R): 0.54% 1.24%
Standard deviation: 8.51% 4.98%
Starbucks Corp. (SBUX) Standard & Poor’s 500 (S&P 500)
t Date PriceSBUX,t1 DividendSBUX,t1 RSBUX,t2 PriceS&P 500,t RS&P 500,t3
Oct 31, 2019 $84.56 3,037.56
1. Nov 30, 2019 $85.43 $0.41 1.51% 3,140.98 3.40%
2. Dec 31, 2019 $87.92 2.91% 3,230.78 2.86%
3. Jan 31, 2020 $84.83 -3.51% 3,225.52 -0.16%
4. Feb 29, 2020 $78.43 $0.41 -7.06% 2,954.22 -8.41%
5. Mar 31, 2020 $65.74 -16.18% 2,584.59 -12.51%
6. Apr 30, 2020 $76.73 16.72% 2,912.43 12.68%
7. May 31, 2020 $77.99 $0.41 2.18% 3,044.31 4.53%
8. Jun 30, 2020 $73.59 -5.64% 3,100.29 1.84%
9. Jul 31, 2020 $76.53 4.00% 3,271.12 5.51%
10. Aug 31, 2020 $84.47 $0.41 10.91% 3,500.31 7.01%
11. Sep 30, 2020 $85.92 1.72% 3,363.00 -3.92%
12. Oct 31, 2020 $86.96 1.21% 3,269.96 -2.77%
13. Nov 30, 2020 $98.02 $0.45 13.24% 3,621.63 10.75%
14. Dec 31, 2020 $106.98 9.14% 3,756.07 3.71%
15. Jan 31, 2021 $96.81 -9.51% 3,714.24 -1.11%
16. Feb 28, 2021 $108.03 $0.45 12.05% 3,811.15 2.61%
17. Mar 31, 2021 $109.27 1.15% 3,972.89 4.24%
18. Apr 30, 2021 $114.49 4.78% 4,181.17 5.24%
19. May 31, 2021 $113.88 $0.45 -0.14% 4,204.11 0.55%
20. Jun 30, 2021 $111.81 -1.82% 4,297.50 2.22%
21. Jul 31, 2021 $121.43 8.60% 4,395.26 2.27%
22. Aug 31, 2021 $117.49 $0.45 -2.87% 4,522.68 2.90%
23. Sep 30, 2021 $110.31 -6.11% 4,307.54 -4.76%
24. Oct 31, 2021 $106.07 -3.84% 4,605.38 6.91%
25. Nov 30, 2021 $109.64 $0.49 3.83% 4,567.00 -0.83%
26. Dec 31, 2021 $116.97 6.69% 4,766.18 4.36%
27. Jan 31, 2022 $98.32 -15.94% 4,515.55 -5.26%
28. Feb 28, 2022 $91.79 $0.49 -6.14% 4,373.94 -3.14%
29. Mar 31, 2022 $90.97 -0.89% 4,530.41 3.58%
30. Apr 30, 2022 $74.64 -17.95% 4,131.93 -8.80%
31. May 31, 2022 $78.50 $0.49 5.83% 4,132.15 0.01%
32. Jun 30, 2022 $76.39 -2.69% 3,785.38 -8.39%
33. Jul 31, 2022 $84.78 10.98% 4,130.29 9.11%
34. Aug 31, 2022 $84.07 $0.49 -0.26% 3,955.00 -4.24%
35. Sep 30, 2022 $84.26 0.23% 3,585.62 -9.34%
36. Oct 31, 2022 $86.59 2.77% 3,871.98 7.99%
37. Nov 30, 2022 $102.20 $0.53 18.64% 4,080.11 5.38%
38. Dec 31, 2022 $99.20 -2.94% 3,839.50 -5.90%
39. Jan 31, 2023 $109.14 10.02% 4,076.60 6.18%
40. Feb 28, 2023 $102.09 $0.53 -5.97% 3,970.15 -2.61%
41. Mar 31, 2023 $104.13 2.00% 4,109.31 3.51%
42. Apr 30, 2023 $114.29 9.76% 4,169.48 1.46%
43. May 31, 2023 $97.64 $0.53 -14.10% 4,179.83 0.25%
44. Jun 30, 2023 $99.06 1.45% 4,376.86 4.71%
45. Jul 31, 2023 $101.57 2.53% 4,588.96 4.85%
46. Aug 31, 2023 $97.44 $0.53 -3.54% 4,507.66 -1.77%
47. Sep 30, 2023 $91.27 -6.33% 4,288.05 -4.87%
48. Oct 31, 2023 $92.24 1.06% 4,193.80 -2.20%
49. Nov 30, 2023 $99.30 $0.57 8.27% 4,567.80 8.92%
50. Dec 31, 2023 $96.01 -3.31% 4,769.83 4.42%
51. Jan 31, 2024 $93.03 -3.10% 4,845.65 1.59%
52. Feb 29, 2024 $94.90 $0.57 2.62% 5,096.27 5.17%
53. Mar 31, 2024 $91.39 -3.70% 5,254.35 3.10%
54. Apr 30, 2024 $88.49 -3.17% 5,035.69 -4.16%
55. May 31, 2024 $80.22 $0.57 -8.70% 5,277.51 4.80%
56. Jun 30, 2024 $77.85 -2.95% 5,460.48 3.47%
57. Jul 31, 2024 $77.95 0.13% 5,522.30 1.13%
58. Aug 31, 2024 $94.57 $0.57 22.05% 5,648.40 2.28%
59. Sep 30, 2024 $97.49 3.09% 5,762.48 2.02%
60. Oct 31, 2024 $97.70 0.22% 5,705.45 -0.99%
61. Nov 30, 2024 $102.46 $0.61 5.50% 6,032.38 5.73%
62. Dec 31, 2024 $91.25 -10.94% 5,881.63 -2.50%
63. Jan 31, 2025 $107.68 18.01% 6,040.53 2.70%
64. Feb 28, 2025 $115.81 $0.61 8.12% 5,954.50 -1.42%
65. Mar 31, 2025 $98.09 -15.30% 5,611.85 -5.75%
66. Apr 30, 2025 $80.05 -18.39% 5,569.06 -0.76%
67. May 31, 2025 $83.95 $0.61 5.63% 5,911.69 6.15%
68. Jun 30, 2025 $91.63 9.15% 6,204.95 4.96%
69. Jul 31, 2025 $89.16 -2.70% 6,339.39 2.17%
70. Aug 31, 2025 $88.19 $0.61 -0.40% 6,460.26 1.91%
71. Sep 30, 2025 $84.60 -4.07% 6,688.46 3.53%
Average (R): 0.54% 1.24%
Standard deviation: 8.51% 4.98%

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

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


Variance and Covariance

Starbucks Corp., calculation of variance and covariance of returns

Microsoft Excel
t Date RSBUX,t RS&P 500,t (RSBUX,tRSBUX)2 (RS&P 500,tRS&P 500)2 (RSBUX,tRSBUX)×(RS&P 500,tRS&P 500)
1. Nov 30, 2019 1.51% 3.40% 0.94 4.68 2.10
2. Dec 31, 2019 2.91% 2.86% 5.63 2.62 3.84
3. Jan 31, 2020 -3.51% -0.16% 16.45 1.97 5.69
. . . . . . .
. . . . . . .
. . . . . . .
70. Aug 31, 2025 -0.40% 1.91% 0.89 0.44 -0.63
71. Sep 30, 2025 -4.07% 3.53% 21.28 5.25 -10.57
Total (Σ): 5,074.03 1,734.96 1,811.15
t Date RSBUX,t RS&P 500,t (RSBUX,tRSBUX)2 (RS&P 500,tRS&P 500)2 (RSBUX,tRSBUX)×(RS&P 500,tRS&P 500)
1. Nov 30, 2019 1.51% 3.40% 0.94 4.68 2.10
2. Dec 31, 2019 2.91% 2.86% 5.63 2.62 3.84
3. Jan 31, 2020 -3.51% -0.16% 16.45 1.97 5.69
4. Feb 29, 2020 -7.06% -8.41% 57.81 93.16 73.38
5. Mar 31, 2020 -16.18% -12.51% 279.62 189.14 229.97
6. Apr 30, 2020 16.72% 12.68% 261.65 130.96 185.11
7. May 31, 2020 2.18% 4.53% 2.67 10.81 5.37
8. Jun 30, 2020 -5.64% 1.84% 38.24 0.36 -3.70
9. Jul 31, 2020 4.00% 5.51% 11.93 18.23 14.74
10. Aug 31, 2020 10.91% 7.01% 107.51 33.24 59.78
11. Sep 30, 2020 1.72% -3.92% 1.38 26.66 -6.07
12. Oct 31, 2020 1.21% -2.77% 0.45 16.06 -2.68
13. Nov 30, 2020 13.24% 10.75% 161.14 90.51 120.77
14. Dec 31, 2020 9.14% 3.71% 73.95 6.11 21.25
15. Jan 31, 2021 -9.51% -1.11% 100.97 5.54 23.66
16. Feb 28, 2021 12.05% 2.61% 132.54 1.87 15.75
17. Mar 31, 2021 1.15% 4.24% 0.37 9.02 1.82
18. Apr 30, 2021 4.78% 5.24% 17.94 16.01 16.95
19. May 31, 2021 -0.14% 0.55% 0.46 0.48 0.47
20. Jun 30, 2021 -1.82% 2.22% 5.57 0.96 -2.31
21. Jul 31, 2021 8.60% 2.27% 65.00 1.07 8.34
22. Aug 31, 2021 -2.87% 2.90% 11.67 2.75 -5.66
23. Sep 30, 2021 -6.11% -4.76% 44.26 35.97 39.90
24. Oct 31, 2021 -3.84% 6.91% 19.23 32.19 -24.88
25. Nov 30, 2021 3.83% -0.83% 10.80 4.30 -6.82
26. Dec 31, 2021 6.69% 4.36% 37.75 9.74 19.17
27. Jan 31, 2022 -15.94% -5.26% 271.79 42.24 107.15
28. Feb 28, 2022 -6.14% -3.14% 44.69 19.16 29.26
29. Mar 31, 2022 -0.89% 3.58% 2.06 5.46 -3.35
30. Apr 30, 2022 -17.95% -8.80% 341.98 100.73 185.60
31. May 31, 2022 5.83% 0.01% 27.94 1.53 -6.53
32. Jun 30, 2022 -2.69% -8.39% 10.43 92.79 31.11
33. Jul 31, 2022 10.98% 9.11% 109.02 61.95 82.18
34. Aug 31, 2022 -0.26% -4.24% 0.64 30.08 4.40
35. Sep 30, 2022 0.23% -9.34% 0.10 111.94 3.34
36. Oct 31, 2022 2.77% 7.99% 4.94 45.50 15.00
37. Nov 30, 2022 18.64% 5.38% 327.53 17.09 74.83
38. Dec 31, 2022 -2.94% -5.90% 12.09 50.95 24.82
39. Jan 31, 2023 10.02% 6.18% 89.84 24.35 46.77
40. Feb 28, 2023 -5.97% -2.61% 42.46 14.84 25.10
41. Mar 31, 2023 2.00% 3.51% 2.12 5.13 3.30
42. Apr 30, 2023 9.76% 1.46% 84.92 0.05 2.06
43. May 31, 2023 -14.10% 0.25% 214.51 0.99 14.54
44. Jun 30, 2023 1.45% 4.71% 0.83 12.06 3.17
45. Jul 31, 2023 2.53% 4.85% 3.97 13.00 7.18
46. Aug 31, 2023 -3.54% -1.77% 16.70 9.07 12.31
47. Sep 30, 2023 -6.33% -4.87% 47.25 37.37 42.02
48. Oct 31, 2023 1.06% -2.20% 0.27 11.82 -1.79
49. Nov 30, 2023 8.27% 8.92% 59.75 58.94 59.35
50. Dec 31, 2023 -3.31% 4.42% 14.86 10.13 -12.27
51. Jan 31, 2024 -3.10% 1.59% 13.29 0.12 -1.27
52. Feb 29, 2024 2.62% 5.17% 4.33 15.46 8.18
53. Mar 31, 2024 -3.70% 3.10% 17.98 3.46 -7.89
54. Apr 30, 2024 -3.17% -4.16% 13.80 29.18 20.07
55. May 31, 2024 -8.70% 4.80% 85.44 12.68 -32.92
56. Jun 30, 2024 -2.95% 3.47% 12.22 4.96 -7.78
57. Jul 31, 2024 0.13% 1.13% 0.17 0.01 0.04
58. Aug 31, 2024 22.05% 2.28% 462.71 1.09 22.43
59. Sep 30, 2024 3.09% 2.02% 6.48 0.61 1.98
60. Oct 31, 2024 0.22% -0.99% 0.11 4.97 0.73
61. Nov 30, 2024 5.50% 5.73% 24.55 20.15 22.24
62. Dec 31, 2024 -10.94% -2.50% 131.85 13.99 42.94
63. Jan 31, 2025 18.01% 2.70% 304.98 2.13 25.51
64. Feb 28, 2025 8.12% -1.42% 57.38 7.10 -20.19
65. Mar 31, 2025 -15.30% -5.75% 250.99 48.93 110.82
66. Apr 30, 2025 -18.39% -0.76% 358.46 4.01 37.93
67. May 31, 2025 5.63% 6.15% 25.93 24.12 25.01
68. Jun 30, 2025 9.15% 4.96% 74.07 13.84 32.02
69. Jul 31, 2025 -2.70% 2.17% 10.48 0.86 -3.00
70. Aug 31, 2025 -0.40% 1.91% 0.89 0.44 -0.63
71. Sep 30, 2025 -4.07% 3.53% 21.28 5.25 -10.57
Total (Σ): 5,074.03 1,734.96 1,811.15

Show all

VarianceSBUX = Σ(RSBUX,tRSBUX)2 ÷ (71 – 1)
= 5,074.03 ÷ (71 – 1)
= 72.49

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

CovarianceSBUX, S&P 500 = Σ(RSBUX,tRSBUX)×(RS&P 500,tRS&P 500) ÷ (71 – 1)
= 1,811.15 ÷ (71 – 1)
= 25.87


Systematic Risk (β) Estimation

Microsoft Excel
VarianceSBUX 72.49
VarianceS&P 500 24.79
CovarianceSBUX, S&P 500 25.87
Correlation coefficientSBUX, S&P 5001 0.61
βSBUX2 1.04
αSBUX3 -0.75%

Calculations

1 Correlation coefficientSBUX, S&P 500
= CovarianceSBUX, S&P 500 ÷ (Standard deviationSBUX × Standard deviationS&P 500)
= 25.87 ÷ (8.51% × 4.98%)
= 0.61

2 βSBUX
= CovarianceSBUX, S&P 500 ÷ VarianceS&P 500
= 25.87 ÷ 24.79
= 1.04

3 αSBUX
= AverageSBUX – βSBUX × AverageS&P 500
= 0.54%1.04 × 1.24%
= -0.75%


Expected Rate of Return

Microsoft Excel
Assumptions
Rate of return on LT Treasury Composite1 RF 4.76%
Expected rate of return on market portfolio2 E(RM) 15.13%
Systematic risk (β) of Starbucks Corp. common stock βSBUX 1.04
 
Expected rate of return on Starbucks Corp. common stock3 E(RSBUX) 15.59%

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(RSBUX) = RF + βSBUX [E(RM) – RF]
= 4.76% + 1.04 [15.13%4.76%]
= 15.59%