Stock Analysis on Net

Caterpillar Inc. (NYSE:CAT)

Common-Size Income Statement 
Quarterly Data

Caterpillar Inc., common-size consolidated income statement (quarterly data)

Microsoft Excel
3 months ended: 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
Sales of Machinery, Energy & Transportation 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00
Cost of goods sold -67.85 -66.19 -66.88 -66.91 -73.18 -71.45 -73.68 -74.18 -76.38 -73.61 -72.84 -71.59 -73.64 -74.98 -76.40 -73.29 -73.61 -71.56 -72.72 -70.76
Gross margin 32.15% 33.81% 33.12% 33.09% 26.82% 28.55% 26.32% 25.82% 23.62% 26.39% 27.16% 28.41% 26.36% 25.02% 23.60% 26.71% 26.39% 28.44% 27.28% 29.24%
Revenues of Financial Products 5.13 5.14 4.67 5.05 4.57 5.01 5.23 5.46 5.35 5.89 5.71 6.22 6.29 7.08 7.38 7.27 6.12 6.55 5.57 5.83
Selling, general and administrative expenses -10.81 -10.16 -9.24 -9.69 -9.32 -9.81 -10.53 -10.45 -10.86 -11.45 -11.19 -11.07 -11.50 -12.20 -12.66 -11.31 -10.36 -10.45 -9.58 -10.37
Research and development expenses -3.41 -3.47 -3.19 -3.13 -2.53 -3.33 -3.55 -3.55 -3.35 -3.65 -3.66 -3.34 -3.54 -3.73 -3.66 -3.59 -3.12 -3.60 -3.23 -3.42
Interest expense of Financial Products -1.77 -1.75 -1.48 -1.44 -1.18 -1.06 -0.89 -0.82 -0.79 -0.95 -0.95 -1.12 -1.21 -1.48 -1.60 -1.77 -1.48 -1.58 -1.40 -1.49
Goodwill impairment charge 0.00 0.00 0.00 0.00 -5.83 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Other operating income (expenses) -1.98 -2.00 -1.81 -5.80 -1.95 -2.37 -2.24 -2.06 -1.68 -2.03 -2.40 -2.89 -3.34 -4.01 -4.63 -3.16 -2.62 -2.49 -2.46 -2.45
Operating profit 19.30% 21.57% 22.07% 18.09% 10.59% 16.98% 14.36% 14.40% 12.30% 14.21% 14.67% 16.21% 13.06% 10.67% 8.42% 14.16% 14.94% 16.87% 16.19% 17.35%
Interest expense excluding Financial Products -0.78 -0.81 -0.77 -0.85 -0.74 -0.76 -0.80 -0.85 -0.86 -0.97 -0.98 -1.27 -1.23 -1.47 -1.45 -1.14 -0.90 -0.86 -0.75 -0.81
Other income (expense) 1.48 1.22 0.77 0.21 3.38 1.69 1.92 1.96 8.12 1.92 1.65 2.90 -2.92 0.15 0.31 2.24 -3.01 0.73 0.50 1.26
Consolidated profit before taxes 20.01% 21.99% 22.07% 17.44% 13.23% 17.92% 15.48% 15.51% 19.56% 15.16% 15.34% 17.84% 8.90% 9.35% 7.28% 15.26% 11.02% 16.74% 15.93% 17.79%
Provision for income taxes -3.62 -4.59 -4.55 -4.69 -4.06 -3.69 -3.15 -3.64 -3.28 -3.14 -3.85 -4.24 -1.58 -2.03 -2.44 -4.29 -2.23 -4.33 -4.13 -3.04
Profit of consolidated companies 16.39% 17.39% 17.53% 12.76% 9.17% 14.22% 12.33% 11.87% 16.29% 12.02% 11.48% 13.60% 7.32% 7.33% 4.84% 10.97% 8.79% 12.42% 11.80% 14.75%
Equity in profit (loss) of unconsolidated affiliated companies 0.07 0.08 0.15 0.11 -0.01 0.06 0.03 0.05 -0.10 0.18 0.11 0.08 0.06 -0.05 0.09 0.05 0.06 0.06 0.04 0.06
Profit of consolidated and affiliated companies 16.46% 17.47% 17.67% 12.86% 9.16% 14.29% 12.36% 11.93% 16.19% 12.20% 11.60% 13.68% 7.38% 7.27% 4.93% 11.02% 8.86% 12.48% 11.84% 14.81%
(Profit) loss attributable to noncontrolling interests 0.02 0.01 -0.01 0.01 0.00 0.01 0.00 0.00 0.00 -0.02 -0.01 -0.01 0.00 -0.03 -0.01 -0.01 0.01 0.00 0.01 -0.02
Profit attributable to common stockholders 16.48% 17.48% 17.66% 12.87% 9.16% 14.29% 12.36% 11.93% 16.19% 12.18% 11.59% 13.67% 7.38% 7.24% 4.92% 11.01% 8.86% 12.48% 11.85% 14.78%

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).

Income statement item Description The company
Operating profit The net result for the period of deducting operating expenses from operating revenues. Caterpillar Inc. operating profit as a percentage of sales of Machinery, Energy & Transportation decreased from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.
Consolidated profit before taxes Amount of income (loss) from continuing operations, including income (loss) from equity method investments, before deduction of income tax expense (benefit), and income (loss) attributable to noncontrolling interest. Caterpillar Inc. consolidated profit before taxes as a percentage of sales of Machinery, Energy & Transportation decreased from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.
Profit attributable to common stockholders The portion of profit or loss for the period, net of income taxes, which is attributable to the parent. Caterpillar Inc. profit attributable to common stockholders as a percentage of sales of Machinery, Energy & Transportation decreased from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.