Stock Analysis on Net

Caterpillar Inc. (NYSE:CAT)

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Microsoft Excel

Long-term Activity Ratios (Summary)

Caterpillar Inc., long-term (investment) activity ratios (quarterly data)

Microsoft Excel
Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Net fixed asset turnover 5.04 5.17 5.10 4.91 4.70 4.62 4.36 4.18 3.99 3.84 3.59 3.32 3.15 3.34 3.53 3.84 3.93
Total asset turnover 0.73 0.73 0.72 0.70 0.69 0.66 0.63 0.61 0.58 0.57 0.53 0.50 0.50 0.53 0.57 0.63 0.65
Equity turnover 3.28 3.10 3.39 3.24 3.57 3.45 3.26 2.92 2.92 2.74 2.57 2.43 2.55 2.73 3.17 3.38 3.48

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Caterpillar Inc. net fixed asset turnover ratio improved from Q2 2023 to Q3 2023 but then deteriorated significantly from Q3 2023 to Q4 2023.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Caterpillar Inc. total asset turnover ratio improved from Q2 2023 to Q3 2023 but then slightly deteriorated from Q3 2023 to Q4 2023.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Caterpillar Inc. equity turnover ratio deteriorated from Q2 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 not reaching Q2 2023 level.

Net Fixed Asset Turnover

Caterpillar Inc., net fixed asset turnover calculation (quarterly data)

Microsoft Excel
Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Sales of Machinery, Energy & Transportation 16,237 15,988 16,545 15,099 15,871 14,278 13,539 12,886 13,097 11,707 12,193 11,191 10,570 9,228 9,310 9,914 12,386 11,974 13,671 12,724
Property, plant and equipment, net 12,680 12,287 12,124 11,973 12,028 11,643 11,744 11,932 12,090 11,904 12,014 12,132 12,401 12,232 12,357 12,488 12,904 12,842 13,172 13,259
Long-term Activity Ratio
Net fixed asset turnover1 5.04 5.17 5.10 4.91 4.70 4.62 4.36 4.18 3.99 3.84 3.59 3.32 3.15 3.34 3.53 3.84 3.93
Benchmarks
Net Fixed Asset Turnover, Competitors2
Boeing Co. 7.30 7.23 7.04 6.72 6.31 5.85 5.72 5.68 5.70 5.65 5.44 4.85 4.92 5.08 5.47 5.69 6.12
Cummins Inc. 5.45 5.74 5.63 5.39 5.08 5.03 5.65 5.55 5.43 5.74 5.55 4.98 4.66 4.79 4.97 5.47 5.55
Eaton Corp. plc 6.57 6.77 6.75 6.67 6.59 6.80 6.50 6.38 6.41 6.45 6.25 6.08 6.02 6.31 6.61 7.10 6.12
General Electric Co. 5.17 5.50 5.58 5.84 5.08 5.04 4.83 4.73 4.55 4.53 4.45 4.33 1.63 1.72 1.77 1.87 1.89
Honeywell International Inc. 6.48 6.64 6.59 6.57 6.48 6.54 6.45 6.27 6.18 6.28 6.15 5.88 5.86 6.13 6.48 6.96 6.89
Lockheed Martin Corp. 8.07 8.41 8.46 8.33 8.27 8.48 8.48 8.70 8.83 9.05 9.17 9.15 9.07 9.44 9.44 9.25 9.07
RTX Corp. 4.38 4.37 4.61 4.53 4.42 4.50 4.43 4.37 4.30 4.39 4.25 4.10 3.78 4.05 4.35 5.61 6.04

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q4 2023 Calculation
Net fixed asset turnover = (Sales of Machinery, Energy & TransportationQ4 2023 + Sales of Machinery, Energy & TransportationQ3 2023 + Sales of Machinery, Energy & TransportationQ2 2023 + Sales of Machinery, Energy & TransportationQ1 2023) ÷ Property, plant and equipment, net
= (16,237 + 15,988 + 16,545 + 15,099) ÷ 12,680 = 5.04

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Caterpillar Inc. net fixed asset turnover ratio improved from Q2 2023 to Q3 2023 but then deteriorated significantly from Q3 2023 to Q4 2023.

Total Asset Turnover

Caterpillar Inc., total asset turnover calculation (quarterly data)

Microsoft Excel
Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Sales of Machinery, Energy & Transportation 16,237 15,988 16,545 15,099 15,871 14,278 13,539 12,886 13,097 11,707 12,193 11,191 10,570 9,228 9,310 9,914 12,386 11,974 13,671 12,724
Total assets 87,476 86,791 85,427 83,649 81,943 80,907 81,107 82,276 82,793 80,784 81,697 80,729 78,324 76,741 76,566 75,894 78,453 77,993 79,187 78,726
Long-term Activity Ratio
Total asset turnover1 0.73 0.73 0.72 0.70 0.69 0.66 0.63 0.61 0.58 0.57 0.53 0.50 0.50 0.53 0.57 0.63 0.65
Benchmarks
Total Asset Turnover, Competitors2
Boeing Co. 0.57 0.56 0.55 0.52 0.49 0.45 0.45 0.45 0.45 0.43 0.41 0.38 0.38 0.38 0.41 0.49 0.57
Cummins Inc. 1.06 1.04 1.01 0.96 0.93 0.88 1.01 1.01 1.01 1.04 1.02 0.91 0.88 0.91 0.99 1.12 1.19
Eaton Corp. plc 0.60 0.61 0.60 0.60 0.59 0.59 0.56 0.56 0.58 0.57 0.52 0.52 0.56 0.59 0.63 0.68 0.65
General Electric Co. 0.40 0.43 0.42 0.43 0.39 0.40 0.39 0.37 0.36 0.30 0.30 0.29 0.29 0.30 0.31 0.33 0.33
Honeywell International Inc. 0.60 0.59 0.58 0.60 0.57 0.58 0.55 0.54 0.53 0.54 0.53 0.51 0.51 0.52 0.54 0.63 0.63
Lockheed Martin Corp. 1.29 1.19 1.18 1.21 1.25 1.24 1.24 1.28 1.32 1.28 1.28 1.28 1.29 1.27 1.27 1.24 1.26
RTX Corp. 0.43 0.41 0.44 0.42 0.42 0.42 0.41 0.41 0.40 0.40 0.39 0.38 0.35 0.37 0.40 0.50 0.55

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q4 2023 Calculation
Total asset turnover = (Sales of Machinery, Energy & TransportationQ4 2023 + Sales of Machinery, Energy & TransportationQ3 2023 + Sales of Machinery, Energy & TransportationQ2 2023 + Sales of Machinery, Energy & TransportationQ1 2023) ÷ Total assets
= (16,237 + 15,988 + 16,545 + 15,099) ÷ 87,476 = 0.73

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Caterpillar Inc. total asset turnover ratio improved from Q2 2023 to Q3 2023 but then slightly deteriorated from Q3 2023 to Q4 2023.

Equity Turnover

Caterpillar Inc., equity turnover calculation (quarterly data)

Microsoft Excel
Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Sales of Machinery, Energy & Transportation 16,237 15,988 16,545 15,099 15,871 14,278 13,539 12,886 13,097 11,707 12,193 11,191 10,570 9,228 9,310 9,914 12,386 11,974 13,671 12,724
Shareholders’ equity attributable to common shareholders 19,494 20,489 18,235 18,149 15,869 15,591 15,727 17,065 16,484 16,665 16,833 16,573 15,331 14,949 13,734 14,197 14,588 14,952 14,837 15,437
Long-term Activity Ratio
Equity turnover1 3.28 3.10 3.39 3.24 3.57 3.45 3.26 2.92 2.92 2.74 2.57 2.43 2.55 2.73 3.17 3.38 3.48
Benchmarks
Equity Turnover, Competitors2
Boeing Co.
Cummins Inc. 3.85 3.12 3.11 3.13 3.13 3.12 2.84 2.88 2.83 2.97 2.94 2.58 2.46 2.54 2.81 3.19 3.14
Eaton Corp. plc 1.22 1.23 1.23 1.23 1.22 1.26 1.21 1.19 1.20 1.22 1.24 1.18 1.20 1.27 1.35 1.47 1.33
General Electric Co. 2.36 2.34 2.21 2.24 2.02 2.29 2.06 1.82 1.76 1.92 2.15 2.10 2.05 2.32 2.40 2.44 3.09
Honeywell International Inc. 2.31 2.11 2.09 2.13 2.12 1.97 1.96 1.87 1.85 1.94 1.89 1.81 1.86 1.84 1.90 2.06 1.98
Lockheed Martin Corp. 9.89 7.30 7.29 6.86 7.12 5.41 5.61 6.57 6.12 6.89 10.24 10.46 10.87 12.97 16.77 17.74 19.13
RTX Corp. 1.15 0.96 0.97 0.94 0.92 0.94 0.93 0.89 0.88 0.89 0.88 0.84 0.78 0.87 0.96 1.78 1.84

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q4 2023 Calculation
Equity turnover = (Sales of Machinery, Energy & TransportationQ4 2023 + Sales of Machinery, Energy & TransportationQ3 2023 + Sales of Machinery, Energy & TransportationQ2 2023 + Sales of Machinery, Energy & TransportationQ1 2023) ÷ Shareholders’ equity attributable to common shareholders
= (16,237 + 15,988 + 16,545 + 15,099) ÷ 19,494 = 3.28

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Caterpillar Inc. equity turnover ratio deteriorated from Q2 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 not reaching Q2 2023 level.