Stock Analysis on Net

Caterpillar Inc. (NYSE:CAT)

Capital Asset Pricing Model (CAPM) 

Microsoft Excel

Rates of Return

Caterpillar Inc., monthly rates of return

Microsoft Excel
Caterpillar Inc. (CAT) Standard & Poor’s 500 (S&P 500)
t Date PriceCAT,t1 DividendCAT,t1 RCAT,t2 PriceS&P 500,t RS&P 500,t3
Jan 31, 2021 $182.84 3,714.24
1. Feb 28, 2021 $215.88 18.07% 3,811.15 2.61%
2. Mar 31, 2021 $231.87 7.41% 3,972.89 4.24%
3. Apr 30, 2021 $228.11 $1.03 -1.18% 4,181.17 5.24%
. . . . . . .
. . . . . . .
. . . . . . .
58. Nov 30, 2025 $575.76 -0.26% 6,849.09 0.13%
59. Dec 31, 2025 $572.87 -0.50% 6,845.50 -0.05%
Average (R): 2.57% 1.14%
Standard deviation: 9.95% 4.37%
Caterpillar Inc. (CAT) Standard & Poor’s 500 (S&P 500)
t Date PriceCAT,t1 DividendCAT,t1 RCAT,t2 PriceS&P 500,t RS&P 500,t3
Jan 31, 2021 $182.84 3,714.24
1. Feb 28, 2021 $215.88 18.07% 3,811.15 2.61%
2. Mar 31, 2021 $231.87 7.41% 3,972.89 4.24%
3. Apr 30, 2021 $228.11 $1.03 -1.18% 4,181.17 5.24%
4. May 31, 2021 $241.08 5.69% 4,204.11 0.55%
5. Jun 30, 2021 $217.63 -9.73% 4,297.50 2.22%
6. Jul 31, 2021 $206.75 $1.11 -4.49% 4,395.26 2.27%
7. Aug 31, 2021 $210.87 1.99% 4,522.68 2.90%
8. Sep 30, 2021 $191.97 -8.96% 4,307.54 -4.76%
9. Oct 31, 2021 $204.01 $1.11 6.85% 4,605.38 6.91%
10. Nov 30, 2021 $193.35 -5.23% 4,567.00 -0.83%
11. Dec 31, 2021 $206.74 6.93% 4,766.18 4.36%
12. Jan 31, 2022 $201.56 $1.11 -1.97% 4,515.55 -5.26%
13. Feb 28, 2022 $187.58 -6.94% 4,373.94 -3.14%
14. Mar 31, 2022 $222.82 18.79% 4,530.41 3.58%
15. Apr 30, 2022 $210.54 $1.11 -5.01% 4,131.93 -8.80%
16. May 31, 2022 $215.85 2.52% 4,132.15 0.01%
17. Jun 30, 2022 $178.76 -17.18% 3,785.38 -8.39%
18. Jul 31, 2022 $198.25 $1.20 11.57% 4,130.29 9.11%
19. Aug 31, 2022 $184.71 -6.83% 3,955.00 -4.24%
20. Sep 30, 2022 $164.08 -11.17% 3,585.62 -9.34%
21. Oct 31, 2022 $216.46 $1.20 32.65% 3,871.98 7.99%
22. Nov 30, 2022 $236.41 9.22% 4,080.11 5.38%
23. Dec 31, 2022 $239.56 1.33% 3,839.50 -5.90%
24. Jan 31, 2023 $252.29 $1.20 5.81% 4,076.60 6.18%
25. Feb 28, 2023 $239.55 -5.05% 3,970.15 -2.61%
26. Mar 31, 2023 $228.84 -4.47% 4,109.31 3.51%
27. Apr 30, 2023 $218.80 $1.20 -3.86% 4,169.48 1.46%
28. May 31, 2023 $205.75 -5.96% 4,179.83 0.25%
29. Jun 30, 2023 $246.05 19.59% 4,376.86 4.71%
30. Jul 31, 2023 $265.17 $1.30 8.30% 4,588.96 4.85%
31. Aug 31, 2023 $281.13 6.02% 4,507.66 -1.77%
32. Sep 30, 2023 $273.00 -2.89% 4,288.05 -4.87%
33. Oct 31, 2023 $226.05 $1.30 -16.72% 4,193.80 -2.20%
34. Nov 30, 2023 $250.72 10.91% 4,567.80 8.92%
35. Dec 31, 2023 $295.67 17.93% 4,769.83 4.42%
36. Jan 31, 2024 $300.31 $1.30 2.01% 4,845.65 1.59%
37. Feb 29, 2024 $333.96 11.21% 5,096.27 5.17%
38. Mar 31, 2024 $366.43 9.72% 5,254.35 3.10%
39. Apr 30, 2024 $334.57 $1.30 -8.34% 5,035.69 -4.16%
40. May 31, 2024 $338.52 1.18% 5,277.51 4.80%
41. Jun 30, 2024 $333.10 -1.60% 5,460.48 3.47%
42. Jul 31, 2024 $346.20 $1.41 4.36% 5,522.30 1.13%
43. Aug 31, 2024 $356.10 2.86% 5,648.40 2.28%
44. Sep 30, 2024 $391.12 9.83% 5,762.48 2.02%
45. Oct 31, 2024 $376.20 $1.41 -3.45% 5,705.45 -0.99%
46. Nov 30, 2024 $406.11 7.95% 6,032.38 5.73%
47. Dec 31, 2024 $362.76 -10.67% 5,881.63 -2.50%
48. Jan 31, 2025 $371.44 $1.41 2.78% 6,040.53 2.70%
49. Feb 28, 2025 $343.95 -7.40% 5,954.50 -1.42%
50. Mar 31, 2025 $329.80 -4.11% 5,611.85 -5.75%
51. Apr 30, 2025 $309.27 $1.41 -5.80% 5,569.06 -0.76%
52. May 31, 2025 $348.03 12.53% 5,911.69 6.15%
53. Jun 30, 2025 $388.21 11.54% 6,204.95 4.96%
54. Jul 31, 2025 $438.02 $1.51 13.22% 6,339.39 2.17%
55. Aug 31, 2025 $419.04 -4.33% 6,460.26 1.91%
56. Sep 30, 2025 $477.15 13.87% 6,688.46 3.53%
57. Oct 31, 2025 $577.26 $1.51 21.30% 6,840.20 2.27%
58. Nov 30, 2025 $575.76 -0.26% 6,849.09 0.13%
59. Dec 31, 2025 $572.87 -0.50% 6,845.50 -0.05%
Average (R): 2.57% 1.14%
Standard deviation: 9.95% 4.37%

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

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


Variance and Covariance

Caterpillar Inc., calculation of variance and covariance of returns

Microsoft Excel
t Date RCAT,t RS&P 500,t (RCAT,tRCAT)2 (RS&P 500,tRS&P 500)2 (RCAT,tRCAT)×(RS&P 500,tRS&P 500)
1. Feb 28, 2021 18.07% 2.61% 240.16 2.17 22.83
2. Mar 31, 2021 7.41% 4.24% 23.36 9.66 15.02
3. Apr 30, 2021 -1.18% 5.24% 14.07 16.86 -15.40
. . . . . . .
. . . . . . .
. . . . . . .
58. Nov 30, 2025 -0.26% 0.13% 8.03 1.01 2.85
59. Dec 31, 2025 -0.50% -0.05% 9.46 1.41 3.66
Total (Σ): 5,736.56 1,108.23 1,737.35
t Date RCAT,t RS&P 500,t (RCAT,tRCAT)2 (RS&P 500,tRS&P 500)2 (RCAT,tRCAT)×(RS&P 500,tRS&P 500)
1. Feb 28, 2021 18.07% 2.61% 240.16 2.17 22.83
2. Mar 31, 2021 7.41% 4.24% 23.36 9.66 15.02
3. Apr 30, 2021 -1.18% 5.24% 14.07 16.86 -15.40
4. May 31, 2021 5.69% 0.55% 9.69 0.35 -1.83
5. Jun 30, 2021 -9.73% 2.22% 151.30 1.18 -13.35
6. Jul 31, 2021 -4.49% 2.27% 49.88 1.30 -8.04
7. Aug 31, 2021 1.99% 2.90% 0.34 3.11 -1.02
8. Sep 30, 2021 -8.96% -4.76% 133.08 34.73 67.98
9. Oct 31, 2021 6.85% 6.91% 18.29 33.39 24.71
10. Nov 30, 2021 -5.23% -0.83% 60.82 3.88 15.36
11. Dec 31, 2021 6.93% 4.36% 18.94 10.40 14.04
12. Jan 31, 2022 -1.97% -5.26% 20.63 40.89 29.04
13. Feb 28, 2022 -6.94% -3.14% 90.42 18.25 40.62
14. Mar 31, 2022 18.79% 3.58% 262.87 5.96 39.58
15. Apr 30, 2022 -5.01% -8.80% 57.55 98.64 75.35
16. May 31, 2022 2.52% 0.01% 0.00 1.28 0.06
17. Jun 30, 2022 -17.18% -8.39% 390.32 90.79 188.24
18. Jul 31, 2022 11.57% 9.11% 81.02 63.61 71.79
19. Aug 31, 2022 -6.83% -4.24% 88.42 28.95 50.59
20. Sep 30, 2022 -11.17% -9.34% 188.85 109.74 143.96
21. Oct 31, 2022 32.65% 7.99% 904.90 46.93 206.07
22. Nov 30, 2022 9.22% 5.38% 44.13 17.97 28.16
23. Dec 31, 2022 1.33% -5.90% 1.54 49.47 8.73
24. Jan 31, 2023 5.81% 6.18% 10.51 25.39 16.33
25. Feb 28, 2023 -5.05% -2.61% 58.11 14.04 28.57
26. Mar 31, 2023 -4.47% 3.51% 49.62 5.61 -16.69
27. Apr 30, 2023 -3.86% 1.46% 41.42 0.11 -2.11
28. May 31, 2023 -5.96% 0.25% 72.89 0.79 7.58
29. Jun 30, 2023 19.59% 4.71% 289.46 12.80 60.87
30. Jul 31, 2023 8.30% 4.85% 32.79 13.76 21.24
31. Aug 31, 2023 6.02% -1.77% 11.87 8.46 -10.02
32. Sep 30, 2023 -2.89% -4.87% 29.87 36.10 32.83
33. Oct 31, 2023 -16.72% -2.20% 372.29 11.12 64.33
34. Nov 30, 2023 10.91% 8.92% 69.56 60.56 64.90
35. Dec 31, 2023 17.93% 4.42% 235.78 10.80 50.47
36. Jan 31, 2024 2.01% 1.59% 0.32 0.21 -0.26
37. Feb 29, 2024 11.21% 5.17% 74.51 16.29 34.84
38. Mar 31, 2024 9.72% 3.10% 51.12 3.86 14.05
39. Apr 30, 2024 -8.34% -4.16% 119.10 28.06 57.81
40. May 31, 2024 1.18% 4.80% 1.94 13.44 -5.11
41. Jun 30, 2024 -1.60% 3.47% 17.43 5.43 -9.73
42. Jul 31, 2024 4.36% 1.13% 3.18 0.00 -0.01
43. Aug 31, 2024 2.86% 2.28% 0.08 1.32 0.33
44. Sep 30, 2024 9.83% 2.02% 52.72 0.78 6.42
45. Oct 31, 2024 -3.45% -0.99% 36.33 4.52 12.81
46. Nov 30, 2024 7.95% 5.73% 28.92 21.10 24.70
47. Dec 31, 2024 -10.67% -2.50% 175.50 13.21 48.16
48. Jan 31, 2025 2.78% 2.70% 0.04 2.45 0.33
49. Feb 28, 2025 -7.40% -1.42% 99.48 6.56 25.54
50. Mar 31, 2025 -4.11% -5.75% 44.72 47.48 46.08
51. Apr 30, 2025 -5.80% -0.76% 70.07 3.60 15.89
52. May 31, 2025 12.53% 6.15% 99.19 25.16 49.96
53. Jun 30, 2025 11.54% 4.96% 80.49 14.63 34.31
54. Jul 31, 2025 13.22% 2.17% 113.35 1.06 10.97
55. Aug 31, 2025 -4.33% 1.91% 47.70 0.59 -5.32
56. Sep 30, 2025 13.87% 3.53% 127.56 5.74 27.06
57. Oct 31, 2025 21.30% 2.27% 350.59 1.28 21.21
58. Nov 30, 2025 -0.26% 0.13% 8.03 1.01 2.85
59. Dec 31, 2025 -0.50% -0.05% 9.46 1.41 3.66
Total (Σ): 5,736.56 1,108.23 1,737.35

Show all

VarianceCAT = Σ(RCAT,tRCAT)2 ÷ (59 – 1)
= 5,736.56 ÷ (59 – 1)
= 98.91

VarianceS&P 500 = Σ(RS&P 500,tRS&P 500)2 ÷ (59 – 1)
= 1,108.23 ÷ (59 – 1)
= 19.11

CovarianceCAT, S&P 500 = Σ(RCAT,tRCAT)×(RS&P 500,tRS&P 500) ÷ (59 – 1)
= 1,737.35 ÷ (59 – 1)
= 29.95


Systematic Risk (β) Estimation

Microsoft Excel
VarianceCAT 98.91
VarianceS&P 500 19.11
CovarianceCAT, S&P 500 29.95
Correlation coefficientCAT, S&P 5001 0.69
βCAT2 1.57
αCAT3 0.79%

Calculations

1 Correlation coefficientCAT, S&P 500
= CovarianceCAT, S&P 500 ÷ (Standard deviationCAT × Standard deviationS&P 500)
= 29.95 ÷ (9.95% × 4.37%)
= 0.69

2 βCAT
= CovarianceCAT, S&P 500 ÷ VarianceS&P 500
= 29.95 ÷ 19.11
= 1.57

3 αCAT
= AverageCAT – βCAT × AverageS&P 500
= 2.57%1.57 × 1.14%
= 0.79%


Expected Rate of Return

Microsoft Excel
Assumptions
Rate of return on LT Treasury Composite1 RF 4.94%
Expected rate of return on market portfolio2 E(RM) 17.36%
Systematic risk (β) of Caterpillar Inc. common stock βCAT 1.57
 
Expected rate of return on Caterpillar Inc. common stock3 E(RCAT) 24.41%

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(RCAT) = RF + βCAT [E(RM) – RF]
= 4.94% + 1.57 [17.36%4.94%]
= 24.41%