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
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 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017
Net fixed asset turnover 4.62 4.36 4.18 3.99 3.84 3.59 3.32 3.15 3.34 3.53 3.84 3.93 4.05 4.01 3.95 3.82 3.70 3.51 3.28 3.01
Total asset turnover 0.66 0.63 0.61 0.58 0.57 0.53 0.50 0.50 0.53 0.57 0.63 0.65 0.67 0.67 0.67 0.66 0.64 0.61 0.59 0.55
Equity turnover 3.45 3.26 2.92 2.92 2.74 2.57 2.43 2.55 2.73 3.17 3.38 3.48 3.48 3.56 3.39 3.69 3.18 3.25 3.01 3.12

Based on: 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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-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 Q1 2022 to Q2 2022 and from Q2 2022 to Q3 2022.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Caterpillar Inc. total asset turnover ratio improved from Q1 2022 to Q2 2022 and from Q2 2022 to Q3 2022.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Caterpillar Inc. equity turnover ratio improved from Q1 2022 to Q2 2022 and from Q2 2022 to Q3 2022.

Net Fixed Asset Turnover

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

Microsoft Excel
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 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017
Selected Financial Data (US$ in millions)
Sales of Machinery, Energy & Transportation 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 13,630 12,763 13,279 12,150 12,194 10,713 10,639 9,130
Property, plant and equipment, net 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 13,574 13,607 13,752 13,912 14,155 14,187 14,420 14,727
Long-term Activity Ratio
Net fixed asset turnover1 4.62 4.36 4.18 3.99 3.84 3.59 3.32 3.15 3.34 3.53 3.84 3.93 4.05 4.01 3.95 3.82 3.70 3.51 3.28 3.01
Benchmarks
Net Fixed Asset Turnover, Competitors2
Boeing Co. 5.85 5.72 5.68 5.70 5.65 5.44 4.85 4.92 5.08 5.47 5.69 6.12 6.94 7.31 7.99 8.00 7.81 7.72 7.59 7.37
General Electric Co. 5.04 4.83 4.73 4.55 4.53 4.45 4.33 1.63 1.72 1.77 1.87 1.89 2.06 1.86 1.97 2.24 2.25 2.27 2.14 2.10
Honeywell International Inc. 6.54 6.45 6.27 6.18 6.28 6.15 5.88 5.86 6.13 6.48 6.96 6.89 7.05 7.34 7.64 7.89 7.19 7.08 6.81 6.84
Lockheed Martin Corp. 8.48 8.48 8.70 8.83 9.05 9.17 9.15 9.07 9.44 9.44 9.25 9.07 9.35 9.32 9.20 8.78
Northrop Grumman Corp. 4.23 4.30 4.40 4.52 5.12 5.25 5.26 5.20 4.91 4.91 4.93 4.90 5.03 5.04 4.91 4.72
Raytheon Technologies Corp. 4.50 4.43 4.37 4.30 4.39 4.25 4.10 3.78 4.05 4.35 5.61 6.04 6.19 5.90 5.70 5.41 6.27 6.20 5.96 5.87

Based on: 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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).

1 Q3 2022 Calculation
Net fixed asset turnover = (Sales of Machinery, Energy & TransportationQ3 2022 + Sales of Machinery, Energy & TransportationQ2 2022 + Sales of Machinery, Energy & TransportationQ1 2022 + Sales of Machinery, Energy & TransportationQ4 2021) ÷ Property, plant and equipment, net
= (14,278 + 13,539 + 12,886 + 13,097) ÷ 11,643 = 4.62

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 Q1 2022 to Q2 2022 and from Q2 2022 to Q3 2022.

Total Asset Turnover

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

Microsoft Excel
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 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017
Selected Financial Data (US$ in millions)
Sales of Machinery, Energy & Transportation 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 13,630 12,763 13,279 12,150 12,194 10,713 10,639 9,130
Total assets 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 78,509 78,209 78,987 78,014 76,962 78,560 78,510 77,549
Long-term Activity Ratio
Total asset turnover1 0.66 0.63 0.61 0.58 0.57 0.53 0.50 0.50 0.53 0.57 0.63 0.65 0.67 0.67 0.67 0.66 0.64 0.61 0.59 0.55
Benchmarks
Total Asset Turnover, Competitors2
Boeing Co. 0.45 0.45 0.45 0.45 0.43 0.41 0.38 0.38 0.38 0.41 0.49 0.57 0.66 0.73 0.84 0.86 0.86 0.86 0.84 1.01
General Electric Co. 0.40 0.39 0.37 0.36 0.30 0.30 0.29 0.29 0.30 0.31 0.33 0.33 0.36 0.32 0.34 0.37 0.36 0.34 0.32 0.30
Honeywell International Inc. 0.58 0.55 0.54 0.53 0.54 0.53 0.51 0.51 0.52 0.54 0.63 0.63 0.61 0.67 0.69 0.72 0.69 0.71 0.68 0.68
Lockheed Martin Corp. 1.24 1.24 1.28 1.32 1.28 1.28 1.28 1.29 1.27 1.27 1.24 1.26 1.18 1.20 1.18 1.20
Northrop Grumman Corp. 0.82 0.83 0.84 0.84 0.88 0.89 0.90 0.83 0.79 0.80 0.79 0.82 0.82 0.83 0.79 0.80
Raytheon Technologies Corp. 0.42 0.41 0.41 0.40 0.40 0.39 0.38 0.35 0.37 0.40 0.50 0.55 0.54 0.52 0.51 0.50 0.56 0.62 0.62 0.62

Based on: 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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).

1 Q3 2022 Calculation
Total asset turnover = (Sales of Machinery, Energy & TransportationQ3 2022 + Sales of Machinery, Energy & TransportationQ2 2022 + Sales of Machinery, Energy & TransportationQ1 2022 + Sales of Machinery, Energy & TransportationQ4 2021) ÷ Total assets
= (14,278 + 13,539 + 12,886 + 13,097) ÷ 80,907 = 0.66

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 Q1 2022 to Q2 2022 and from Q2 2022 to Q3 2022.

Equity Turnover

Caterpillar Inc., equity turnover calculation (quarterly data)

Microsoft Excel
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 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017
Selected Financial Data (US$ in millions)
Sales of Machinery, Energy & Transportation 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 13,630 12,763 13,279 12,150 12,194 10,713 10,639 9,130
Shareholders’ equity attributable to common shareholders 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 14,039 15,850 14,879 15,206 13,697 15,627 14,009 13,588
Long-term Activity Ratio
Equity turnover1 3.45 3.26 2.92 2.92 2.74 2.57 2.43 2.55 2.73 3.17 3.38 3.48 3.48 3.56 3.39 3.69 3.18 3.25 3.01 3.12
Benchmarks
Equity Turnover, Competitors2
Boeing Co. 805.30 298.31 78.39 263.08
General Electric Co. 2.29 2.06 1.82 1.76 1.92 2.15 2.10 2.05 2.32 2.40 2.44 3.09 3.37 2.80 3.04 3.66 3.62 2.10 2.05 1.76
Honeywell International Inc. 1.97 1.96 1.87 1.85 1.94 1.89 1.81 1.86 1.84 1.90 2.06 1.98 2.04 2.16 2.15 2.30 2.35 2.40 2.35 2.35
Lockheed Martin Corp. 5.41 5.61 6.57 6.12 6.89 10.24 10.46 10.87 12.97 16.77 17.74 19.13 14.99 20.17 22.91 38.57
Northrop Grumman Corp. 2.53 2.56 2.66 2.76 3.26 3.37 3.55 3.48 3.37 3.57 3.78 3.84 3.42 3.57 3.61 3.68
Raytheon Technologies Corp. 0.94 0.93 0.89 0.88 0.89 0.88 0.84 0.78 0.87 0.96 1.78 1.84 1.87 1.78 1.75 1.73 2.00 2.00 2.01 2.02

Based on: 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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).

1 Q3 2022 Calculation
Equity turnover = (Sales of Machinery, Energy & TransportationQ3 2022 + Sales of Machinery, Energy & TransportationQ2 2022 + Sales of Machinery, Energy & TransportationQ1 2022 + Sales of Machinery, Energy & TransportationQ4 2021) ÷ Shareholders’ equity attributable to common shareholders
= (14,278 + 13,539 + 12,886 + 13,097) ÷ 15,591 = 3.45

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 improved from Q1 2022 to Q2 2022 and from Q2 2022 to Q3 2022.