Stock Analysis on Net

Salesforce Inc. (NYSE:CRM)

Capital Asset Pricing Model (CAPM)

Microsoft Excel

Rates of Return

Salesforce Inc., monthly rates of return

Microsoft Excel
Salesforce Inc. (CRM) Standard & Poor’s 500 (S&P 500)
t Date PriceCRM,t1 DividendCRM,t1 RCRM,t2 PriceS&P 500,t RS&P 500,t3
Feb 29, 2020 $170.40 2,954.22
1. Mar 31, 2020 $143.98 -15.50% 2,584.59 -12.51%
2. Apr 30, 2020 $161.95 12.48% 2,912.43 12.68%
3. May 31, 2020 $174.79 7.93% 3,044.31 4.53%
. . . . . . .
. . . . . . .
. . . . . . .
70. Dec 31, 2025 $264.91 $0.416 15.09% 6,845.50 -0.05%
71. Jan 31, 2026 $212.29 -19.86% 6,939.03 1.37%
Average (R): 0.89% 1.33%
Standard deviation: 10.97% 4.83%
Salesforce Inc. (CRM) Standard & Poor’s 500 (S&P 500)
t Date PriceCRM,t1 DividendCRM,t1 RCRM,t2 PriceS&P 500,t RS&P 500,t3
Feb 29, 2020 $170.40 2,954.22
1. Mar 31, 2020 $143.98 -15.50% 2,584.59 -12.51%
2. Apr 30, 2020 $161.95 12.48% 2,912.43 12.68%
3. May 31, 2020 $174.79 7.93% 3,044.31 4.53%
4. Jun 30, 2020 $187.33 7.17% 3,100.29 1.84%
5. Jul 31, 2020 $194.85 4.01% 3,271.12 5.51%
6. Aug 31, 2020 $272.65 39.93% 3,500.31 7.01%
7. Sep 30, 2020 $251.32 -7.82% 3,363.00 -3.92%
8. Oct 31, 2020 $232.27 -7.58% 3,269.96 -2.77%
9. Nov 30, 2020 $245.80 5.83% 3,621.63 10.75%
10. Dec 31, 2020 $222.53 -9.47% 3,756.07 3.71%
11. Jan 31, 2021 $225.56 1.36% 3,714.24 -1.11%
12. Feb 28, 2021 $216.50 -4.02% 3,811.15 2.61%
13. Mar 31, 2021 $211.87 -2.14% 3,972.89 4.24%
14. Apr 30, 2021 $230.32 8.71% 4,181.17 5.24%
15. May 31, 2021 $238.10 3.38% 4,204.11 0.55%
16. Jun 30, 2021 $244.27 2.59% 4,297.50 2.22%
17. Jul 31, 2021 $241.93 -0.96% 4,395.26 2.27%
18. Aug 31, 2021 $265.27 9.65% 4,522.68 2.90%
19. Sep 30, 2021 $271.22 2.24% 4,307.54 -4.76%
20. Oct 31, 2021 $299.69 10.50% 4,605.38 6.91%
21. Nov 30, 2021 $284.96 -4.92% 4,567.00 -0.83%
22. Dec 31, 2021 $254.13 -10.82% 4,766.18 4.36%
23. Jan 31, 2022 $232.63 -8.46% 4,515.55 -5.26%
24. Feb 28, 2022 $210.53 -9.50% 4,373.94 -3.14%
25. Mar 31, 2022 $212.32 0.85% 4,530.41 3.58%
26. Apr 30, 2022 $175.94 -17.13% 4,131.93 -8.80%
27. May 31, 2022 $160.24 -8.92% 4,132.15 0.01%
28. Jun 30, 2022 $165.04 3.00% 3,785.38 -8.39%
29. Jul 31, 2022 $184.02 11.50% 4,130.29 9.11%
30. Aug 31, 2022 $156.12 -15.16% 3,955.00 -4.24%
31. Sep 30, 2022 $143.84 -7.87% 3,585.62 -9.34%
32. Oct 31, 2022 $162.59 13.04% 3,871.98 7.99%
33. Nov 30, 2022 $160.25 -1.44% 4,080.11 5.38%
34. Dec 31, 2022 $132.59 -17.26% 3,839.50 -5.90%
35. Jan 31, 2023 $167.97 26.68% 4,076.60 6.18%
36. Feb 28, 2023 $163.61 -2.60% 3,970.15 -2.61%
37. Mar 31, 2023 $199.78 22.11% 4,109.31 3.51%
38. Apr 30, 2023 $198.37 -0.71% 4,169.48 1.46%
39. May 31, 2023 $223.38 12.61% 4,179.83 0.25%
40. Jun 30, 2023 $211.26 -5.43% 4,376.86 4.71%
41. Jul 31, 2023 $225.01 6.51% 4,588.96 4.85%
42. Aug 31, 2023 $221.46 -1.58% 4,507.66 -1.77%
43. Sep 30, 2023 $202.78 -8.43% 4,288.05 -4.87%
44. Oct 31, 2023 $200.83 -0.96% 4,193.80 -2.20%
45. Nov 30, 2023 $251.90 25.43% 4,567.80 8.92%
46. Dec 31, 2023 $263.14 4.46% 4,769.83 4.42%
47. Jan 31, 2024 $281.09 6.82% 4,845.65 1.59%
48. Feb 29, 2024 $308.82 9.87% 5,096.27 5.17%
49. Mar 31, 2024 $301.18 $0.40 -2.34% 5,254.35 3.10%
50. Apr 30, 2024 $268.94 -10.70% 5,035.69 -4.16%
51. May 31, 2024 $234.44 -12.83% 5,277.51 4.80%
52. Jun 30, 2024 $257.10 9.67% 5,460.48 3.47%
53. Jul 31, 2024 $258.80 $0.40 0.82% 5,522.30 1.13%
54. Aug 31, 2024 $252.90 -2.28% 5,648.40 2.28%
55. Sep 30, 2024 $273.71 $0.40 8.39% 5,762.48 2.02%
56. Oct 31, 2024 $291.37 6.45% 5,705.45 -0.99%
57. Nov 30, 2024 $329.99 13.25% 6,032.38 5.73%
58. Dec 31, 2024 $334.33 $0.40 1.44% 5,881.63 -2.50%
59. Jan 31, 2025 $341.70 2.20% 6,040.53 2.70%
60. Feb 28, 2025 $297.85 -12.83% 5,954.50 -1.42%
61. Mar 31, 2025 $268.36 -9.90% 5,611.85 -5.75%
62. Apr 30, 2025 $268.71 $0.416 0.29% 5,569.06 -0.76%
63. May 31, 2025 $265.37 -1.24% 5,911.69 6.15%
64. Jun 30, 2025 $272.69 $0.416 2.92% 6,204.95 4.96%
65. Jul 31, 2025 $258.33 -5.27% 6,339.39 2.17%
66. Aug 31, 2025 $256.25 -0.81% 6,460.26 1.91%
67. Sep 30, 2025 $237.00 $0.416 -7.35% 6,688.46 3.53%
68. Oct 31, 2025 $260.41 9.88% 6,840.20 2.27%
69. Nov 30, 2025 $230.54 -11.47% 6,849.09 0.13%
70. Dec 31, 2025 $264.91 $0.416 15.09% 6,845.50 -0.05%
71. Jan 31, 2026 $212.29 -19.86% 6,939.03 1.37%
Average (R): 0.89% 1.33%
Standard deviation: 10.97% 4.83%

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

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


Variance and Covariance

Salesforce Inc., calculation of variance and covariance of returns

Microsoft Excel
t Date RCRM,t RS&P 500,t (RCRM,tRCRM)2 (RS&P 500,tRS&P 500)2 (RCRM,tRCRM)×(RS&P 500,tRS&P 500)
1. Mar 31, 2020 -15.50% -12.51% 268.92 191.48 226.92
2. Apr 30, 2020 12.48% 12.68% 134.26 129.02 131.61
3. May 31, 2020 7.93% 4.53% 49.48 10.26 22.53
. . . . . . .
. . . . . . .
. . . . . . .
70. Dec 31, 2025 15.09% -0.05% 201.50 1.90 -19.56
71. Jan 31, 2026 -19.86% 1.37% 430.87 0.00 -0.84
Total (Σ): 8,420.78 1,636.00 2,159.89
t Date RCRM,t RS&P 500,t (RCRM,tRCRM)2 (RS&P 500,tRS&P 500)2 (RCRM,tRCRM)×(RS&P 500,tRS&P 500)
1. Mar 31, 2020 -15.50% -12.51% 268.92 191.48 226.92
2. Apr 30, 2020 12.48% 12.68% 134.26 129.02 131.61
3. May 31, 2020 7.93% 4.53% 49.48 10.26 22.53
4. Jun 30, 2020 7.17% 1.84% 39.44 0.26 3.22
5. Jul 31, 2020 4.01% 5.51% 9.74 17.51 13.06
6. Aug 31, 2020 39.93% 7.01% 1,523.67 32.27 221.75
7. Sep 30, 2020 -7.82% -3.92% 75.99 27.55 45.75
8. Oct 31, 2020 -7.58% -2.77% 71.81 16.75 34.68
9. Nov 30, 2020 5.83% 10.75% 24.32 88.91 46.50
10. Dec 31, 2020 -9.47% 3.71% 107.35 5.70 -24.73
11. Jan 31, 2021 1.36% -1.11% 0.22 5.95 -1.14
12. Feb 28, 2021 -4.02% 2.61% 24.11 1.65 -6.30
13. Mar 31, 2021 -2.14% 4.24% 9.20 8.52 -8.85
14. Apr 30, 2021 8.71% 5.24% 61.06 15.34 30.61
15. May 31, 2021 3.38% 0.55% 6.17 0.60 -1.93
16. Jun 30, 2021 2.59% 2.22% 2.88 0.80 1.52
17. Jul 31, 2021 -0.96% 2.27% 3.43 0.90 -1.76
18. Aug 31, 2021 9.65% 2.90% 76.62 2.48 13.77
19. Sep 30, 2021 2.24% -4.76% 1.82 37.00 -8.21
20. Oct 31, 2021 10.50% 6.91% 92.22 31.23 53.67
21. Nov 30, 2021 -4.92% -0.83% 33.74 4.66 12.54
22. Dec 31, 2021 -10.82% 4.36% 137.19 9.22 -35.56
23. Jan 31, 2022 -8.46% -5.26% 87.50 43.35 61.59
24. Feb 28, 2022 -9.50% -3.14% 108.04 19.91 46.37
25. Mar 31, 2022 0.85% 3.58% 0.00 5.07 -0.10
26. Apr 30, 2022 -17.13% -8.80% 325.03 102.44 182.47
27. May 31, 2022 -8.92% 0.01% 96.38 1.74 12.96
28. Jun 30, 2022 3.00% -8.39% 4.42 94.43 -20.42
29. Jul 31, 2022 11.50% 9.11% 112.49 60.62 82.58
30. Aug 31, 2022 -15.16% -4.24% 257.77 31.02 89.42
31. Sep 30, 2022 -7.87% -9.34% 76.73 113.75 93.42
32. Oct 31, 2022 13.04% 7.99% 147.41 44.37 80.87
33. Nov 30, 2022 -1.44% 5.38% 5.44 16.40 -9.45
34. Dec 31, 2022 -17.26% -5.90% 329.59 52.17 131.13
35. Jan 31, 2023 26.68% 6.18% 665.11 23.52 125.07
36. Feb 28, 2023 -2.60% -2.61% 12.18 15.50 13.74
37. Mar 31, 2023 22.11% 3.51% 450.01 4.75 46.24
38. Apr 30, 2023 -0.71% 1.46% 2.56 0.02 -0.22
39. May 31, 2023 12.61% 0.25% 137.21 1.16 -12.62
40. Jun 30, 2023 -5.43% 4.71% 39.94 11.48 -21.41
41. Jul 31, 2023 6.51% 4.85% 31.52 12.39 19.77
42. Aug 31, 2023 -1.58% -1.77% 6.11 9.59 7.66
43. Sep 30, 2023 -8.43% -4.87% 87.03 38.41 57.82
44. Oct 31, 2023 -0.96% -2.20% 3.44 12.42 6.54
45. Nov 30, 2023 25.43% 8.92% 601.99 57.64 186.28
46. Dec 31, 2023 4.46% 4.42% 12.73 9.59 11.05
47. Jan 31, 2024 6.82% 1.59% 35.14 0.07 1.56
48. Feb 29, 2024 9.87% 5.17% 80.48 14.80 34.51
49. Mar 31, 2024 -2.34% 3.10% 10.49 3.16 -5.75
50. Apr 30, 2024 -10.70% -4.16% 134.53 30.11 63.64
51. May 31, 2024 -12.83% 4.80% 188.30 12.09 -47.71
52. Jun 30, 2024 9.67% 3.47% 76.94 4.59 18.78
53. Jul 31, 2024 0.82% 1.13% 0.01 0.04 0.01
54. Aug 31, 2024 -2.28% 2.28% 10.07 0.92 -3.04
55. Sep 30, 2024 8.39% 2.02% 56.14 0.48 5.20
56. Oct 31, 2024 6.45% -0.99% 30.89 5.36 -12.87
57. Nov 30, 2024 13.25% 5.73% 152.79 19.40 54.44
58. Dec 31, 2024 1.44% -2.50% 0.29 14.63 -2.07
59. Jan 31, 2025 2.20% 2.70% 1.72 1.89 1.80
60. Feb 28, 2025 -12.83% -1.42% 188.43 7.56 37.75
61. Mar 31, 2025 -9.90% -5.75% 116.53 50.13 76.43
62. Apr 30, 2025 0.29% -0.76% 0.37 4.36 1.27
63. May 31, 2025 -1.24% 6.15% 4.57 23.30 -10.31
64. Jun 30, 2025 2.92% 4.96% 4.09 13.21 7.35
65. Jul 31, 2025 -5.27% 2.17% 37.95 0.71 -5.18
66. Aug 31, 2025 -0.81% 1.91% 2.89 0.34 -0.99
67. Sep 30, 2025 -7.35% 3.53% 67.96 4.87 -18.19
68. Oct 31, 2025 9.88% 2.27% 80.71 0.89 8.47
69. Nov 30, 2025 -11.47% 0.13% 152.88 1.43 14.78
70. Dec 31, 2025 15.09% -0.05% 201.50 1.90 -19.56
71. Jan 31, 2026 -19.86% 1.37% 430.87 0.00 -0.84
Total (Σ): 8,420.78 1,636.00 2,159.89

Show all

VarianceCRM = Σ(RCRM,tRCRM)2 ÷ (71 – 1)
= 8,420.78 ÷ (71 – 1)
= 120.30

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

CovarianceCRM, S&P 500 = Σ(RCRM,tRCRM)×(RS&P 500,tRS&P 500) ÷ (71 – 1)
= 2,159.89 ÷ (71 – 1)
= 30.86


Systematic Risk (β) Estimation

Microsoft Excel
VarianceCRM 120.30
VarianceS&P 500 23.37
CovarianceCRM, S&P 500 30.86
Correlation coefficientCRM, S&P 5001 0.58
βCRM2 1.32
αCRM3 -0.86%

Calculations

1 Correlation coefficientCRM, S&P 500
= CovarianceCRM, S&P 500 ÷ (Standard deviationCRM × Standard deviationS&P 500)
= 30.86 ÷ (10.97% × 4.83%)
= 0.58

2 βCRM
= CovarianceCRM, S&P 500 ÷ VarianceS&P 500
= 30.86 ÷ 23.37
= 1.32

3 αCRM
= AverageCRM – βCRM × AverageS&P 500
= 0.89%1.32 × 1.33%
= -0.86%


Expected Rate of Return

Microsoft Excel
Assumptions
Rate of return on LT Treasury Composite1 RF 4.84%
Expected rate of return on market portfolio2 E(RM) 17.37%
Systematic risk (β) of Salesforce Inc. common stock βCRM 1.32
 
Expected rate of return on Salesforce Inc. common stock3 E(RCRM) 21.38%

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(RCRM) = RF + βCRM [E(RM) – RF]
= 4.84% + 1.32 [17.37%4.84%]
= 21.38%