Stock Analysis on Net

Illinois Tool Works Inc. (NYSE:ITW)

This company has been moved to the archive! The financial data has not been updated since February 11, 2022.

Analysis of Profitability Ratios
Quarterly Data

Microsoft Excel

Profitability Ratios (Summary)

Illinois Tool Works Inc., profitability ratios (quarterly data)

Microsoft Excel
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
Return on Sales
Gross profit margin 41.27% 41.77% 42.07% 41.48% 41.35% 41.14% 41.18% 41.97% 41.97% 41.91% 41.83% 41.81% 41.74% 41.74% 41.76% 41.82% 41.95%
Operating profit margin 24.05% 24.74% 24.78% 23.48% 22.92% 22.46% 22.78% 24.11% 24.11% 24.18% 24.10% 24.15% 24.27% 24.12% 24.60% 24.60% 24.41%
Net profit margin 18.64% 19.14% 19.07% 17.18% 16.77% 16.77% 17.16% 18.06% 17.87% 17.49% 17.17% 17.21% 17.36% 12.69% 12.70% 12.36% 11.79%
Return on Investment
Return on equity (ROE) 74.32% 78.09% 75.85% 67.62% 66.30% 78.19% 92.75% 109.07% 83.31% 83.85% 79.75% 78.47% 78.76% 53.08% 49.72% 43.35% 36.79%
Return on assets (ROA) 16.76% 17.57% 17.14% 14.14% 13.51% 14.11% 15.33% 17.60% 16.73% 16.62% 16.23% 16.36% 17.24% 12.27% 12.12% 11.16% 10.05%

Based on: 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).

Profitability ratio Description The company
Gross profit margin Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures. Illinois Tool Works Inc. gross profit margin ratio deteriorated from Q2 2021 to Q3 2021 and from Q3 2021 to Q4 2021.
Operating profit margin A profitability ratio calculated as operating income divided by revenue. Illinois Tool Works Inc. operating profit margin ratio deteriorated from Q2 2021 to Q3 2021 and from Q3 2021 to Q4 2021.
Net profit margin An indicator of profitability, calculated as net income divided by revenue. Illinois Tool Works Inc. net profit margin ratio improved from Q2 2021 to Q3 2021 but then deteriorated significantly from Q3 2021 to Q4 2021.

Profitability ratio Description The company
ROE A profitability ratio calculated as net income divided by shareholders’ equity. Illinois Tool Works Inc. ROE improved from Q2 2021 to Q3 2021 but then deteriorated significantly from Q3 2021 to Q4 2021.
ROA A profitability ratio calculated as net income divided by total assets. Illinois Tool Works Inc. ROA improved from Q2 2021 to Q3 2021 but then deteriorated significantly from Q3 2021 to Q4 2021.

Gross Profit Margin

Illinois Tool Works Inc., gross profit margin calculation (quarterly data)

Microsoft Excel
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)
Gross profit 1,488 1,460 1,513 1,505 1,475 1,397 970 1,357 1,447 1,472 1,510 1,493 1,484 1,517 1,600 1,563 1,505 1,521 1,512 1,467
Operating revenue 3,679 3,556 3,676 3,544 3,475 3,307 2,564 3,228 3,469 3,479 3,609 3,552 3,580 3,613 3,831 3,744 3,629 3,615 3,599 3,471
Profitability Ratio
Gross profit margin1 41.27% 41.77% 42.07% 41.48% 41.35% 41.14% 41.18% 41.97% 41.97% 41.91% 41.83% 41.81% 41.74% 41.74% 41.76% 41.82% 41.95%
Benchmarks
Gross Profit Margin, Competitors2
Boeing Co. 4.84% -0.25% -1.35% -7.82% -9.78% -1.31% 1.83% 0.47% 5.83%
Caterpillar Inc. 26.30% 27.08% 26.83% 25.98% 25.47% 25.52% 26.43% 27.22% 27.83%
Cummins Inc. 23.71% 23.91% 24.51% 24.34% 24.70% 24.78% 24.70% 25.43% 25.37%
Eaton Corp. plc 32.28% 32.14% 32.23% 30.80% 30.52% 30.54% 30.99% 32.61% 32.97%
General Electric Co. 24.19% 24.97% 22.43% 18.80% 17.26% 15.53% 16.78% 19.21% 19.96%
Honeywell International Inc. 31.98% 32.34% 32.06% 31.52% 32.07% 32.23% 32.87% 33.88% 33.70%
Lockheed Martin Corp. 13.52% 13.34% 13.00% 13.26% 13.23% 13.33% 13.49% 13.53% 13.99%
RTX Corp. 19.40% 17.59% 15.79% 13.98% 15.08% 18.75% 22.86% 25.86% 25.93%

Based on: 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 Q4 2021 Calculation
Gross profit margin = 100 × (Gross profitQ4 2021 + Gross profitQ3 2021 + Gross profitQ2 2021 + Gross profitQ1 2021) ÷ (Operating revenueQ4 2021 + Operating revenueQ3 2021 + Operating revenueQ2 2021 + Operating revenueQ1 2021)
= 100 × (1,488 + 1,460 + 1,513 + 1,505) ÷ (3,679 + 3,556 + 3,676 + 3,544) = 41.27%

2 Click competitor name to see calculations.

Profitability ratio Description The company
Gross profit margin Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures. Illinois Tool Works Inc. gross profit margin ratio deteriorated from Q2 2021 to Q3 2021 and from Q3 2021 to Q4 2021.

Operating Profit Margin

Illinois Tool Works Inc., operating profit margin calculation (quarterly data)

Microsoft Excel
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)
Operating income 834 845 893 905 883 789 449 761 824 868 871 839 860 889 932 903 850 961 874 809
Operating revenue 3,679 3,556 3,676 3,544 3,475 3,307 2,564 3,228 3,469 3,479 3,609 3,552 3,580 3,613 3,831 3,744 3,629 3,615 3,599 3,471
Profitability Ratio
Operating profit margin1 24.05% 24.74% 24.78% 23.48% 22.92% 22.46% 22.78% 24.11% 24.11% 24.18% 24.10% 24.15% 24.27% 24.12% 24.60% 24.60% 24.41%
Benchmarks
Operating Profit Margin, Competitors2
Boeing Co. -4.66% -10.80% -12.18% -20.36% -21.95% -11.39% -7.90% -8.05% -2.58%
Caterpillar Inc. 14.27% 14.56% 13.82% 12.32% 11.67% 12.30% 13.90% 15.62% 16.33%
Cummins Inc. 11.27% 11.83% 12.28% 11.70% 11.45% 10.19% 10.01% 11.23% 11.45%
Eaton Corp. plc 15.69% 15.50% 12.54% 10.81% 11.45% 11.39% 11.87% 13.86% 13.38%
General Electric Co. 8.58% 7.86% 6.82% 4.72% 5.49% 7.26% 9.19% 12.10% 12.85%
Honeywell International Inc. 18.03% 18.36% 17.95% 16.90% 17.45% 17.20% 17.83% 19.01% 18.66%
Lockheed Martin Corp. 13.61% 13.50% 13.19% 13.19% 13.22% 13.24% 13.45% 13.72% 14.29%
RTX Corp. 7.70% 5.93% 4.61% -3.59% -3.34% -0.30% 2.90% 11.73% 11.64%

Based on: 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 Q4 2021 Calculation
Operating profit margin = 100 × (Operating incomeQ4 2021 + Operating incomeQ3 2021 + Operating incomeQ2 2021 + Operating incomeQ1 2021) ÷ (Operating revenueQ4 2021 + Operating revenueQ3 2021 + Operating revenueQ2 2021 + Operating revenueQ1 2021)
= 100 × (834 + 845 + 893 + 905) ÷ (3,679 + 3,556 + 3,676 + 3,544) = 24.05%

2 Click competitor name to see calculations.

Profitability ratio Description The company
Operating profit margin A profitability ratio calculated as operating income divided by revenue. Illinois Tool Works Inc. operating profit margin ratio deteriorated from Q2 2021 to Q3 2021 and from Q3 2021 to Q4 2021.

Net Profit Margin

Illinois Tool Works Inc., net profit margin calculation (quarterly data)

Microsoft Excel
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)
Net income 609 639 775 671 642 582 319 566 641 660 623 597 607 638 666 652 (76) 640 587 536
Operating revenue 3,679 3,556 3,676 3,544 3,475 3,307 2,564 3,228 3,469 3,479 3,609 3,552 3,580 3,613 3,831 3,744 3,629 3,615 3,599 3,471
Profitability Ratio
Net profit margin1 18.64% 19.14% 19.07% 17.18% 16.77% 16.77% 17.16% 18.06% 17.87% 17.49% 17.17% 17.21% 17.36% 12.69% 12.70% 12.36% 11.79%
Benchmarks
Net Profit Margin, Competitors2
Boeing Co. -6.75% -13.50% -14.30% -20.87% -20.42% -7.34% -4.27% -4.84% -0.83%
Caterpillar Inc. 13.47% 11.28% 10.17% 8.53% 7.68% 8.12% 9.50% 11.06% 12.00%
Cummins Inc. 8.87% 9.32% 9.52% 9.00% 9.03% 8.12% 8.46% 9.34% 9.59%
Eaton Corp. plc 10.92% 10.60% 9.86% 8.05% 7.90% 7.53% 8.03% 10.19% 10.34%
General Electric Co. -9.17% -0.06% -3.39% -4.68% 7.81% 4.92% -5.55% -2.75% -5.69%
Honeywell International Inc. 16.11% 15.80% 14.65% 14.17% 14.64% 14.99% 16.94% 17.38% 16.73%
Lockheed Martin Corp. 9.42% 9.13% 10.69% 10.53% 10.45% 10.18% 10.25% 10.21% 10.42%
RTX Corp. 6.00% 5.20% 3.51% -4.44% -6.22% -4.20% -2.52% 5.87% 7.19%

Based on: 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 Q4 2021 Calculation
Net profit margin = 100 × (Net incomeQ4 2021 + Net incomeQ3 2021 + Net incomeQ2 2021 + Net incomeQ1 2021) ÷ (Operating revenueQ4 2021 + Operating revenueQ3 2021 + Operating revenueQ2 2021 + Operating revenueQ1 2021)
= 100 × (609 + 639 + 775 + 671) ÷ (3,679 + 3,556 + 3,676 + 3,544) = 18.64%

2 Click competitor name to see calculations.

Profitability ratio Description The company
Net profit margin An indicator of profitability, calculated as net income divided by revenue. Illinois Tool Works Inc. net profit margin ratio improved from Q2 2021 to Q3 2021 but then deteriorated significantly from Q3 2021 to Q4 2021.

Return on Equity (ROE)

Illinois Tool Works Inc., ROE calculation (quarterly data)

Microsoft Excel
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)
Net income 609 639 775 671 642 582 319 566 641 660 623 597 607 638 666 652 (76) 640 587 536
Stockholders’ equity attributable to ITW 3,625 3,492 3,520 3,274 3,181 2,696 2,357 2,283 3,026 2,966 3,091 3,196 3,254 3,542 3,785 4,159 4,585 5,023 4,771 4,493
Profitability Ratio
ROE1 74.32% 78.09% 75.85% 67.62% 66.30% 78.19% 92.75% 109.07% 83.31% 83.85% 79.75% 78.47% 78.76% 53.08% 49.72% 43.35% 36.79%
Benchmarks
ROE, Competitors2
Boeing Co.
Caterpillar Inc. 39.37% 30.90% 26.09% 20.73% 19.56% 22.18% 30.16% 37.36% 41.77%
Cummins Inc. 25.15% 27.69% 28.03% 23.20% 22.19% 20.62% 23.76% 29.82% 30.11%
Eaton Corp. plc 13.06% 12.95% 12.23% 9.54% 9.44% 9.58% 10.87% 14.93% 13.75%
General Electric Co. -16.17% -0.11% -7.29% -9.82% 16.04% 11.41% -13.31% -6.71% -17.58%
Honeywell International Inc. 29.85% 30.67% 27.73% 25.71% 27.23% 27.56% 32.23% 35.75% 33.22%
Lockheed Martin Corp. 57.62% 62.90% 109.51% 110.16% 113.60% 132.02% 171.93% 181.17% 199.23%
RTX Corp. 5.29% 4.65% 3.07% -3.74% -4.88% -3.67% -2.42% 10.42% 13.25%

Based on: 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 Q4 2021 Calculation
ROE = 100 × (Net incomeQ4 2021 + Net incomeQ3 2021 + Net incomeQ2 2021 + Net incomeQ1 2021) ÷ Stockholders’ equity attributable to ITW
= 100 × (609 + 639 + 775 + 671) ÷ 3,625 = 74.32%

2 Click competitor name to see calculations.

Profitability ratio Description The company
ROE A profitability ratio calculated as net income divided by shareholders’ equity. Illinois Tool Works Inc. ROE improved from Q2 2021 to Q3 2021 but then deteriorated significantly from Q3 2021 to Q4 2021.

Return on Assets (ROA)

Illinois Tool Works Inc., ROA calculation (quarterly data)

Microsoft Excel
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)
Net income 609 639 775 671 642 582 319 566 641 660 623 597 607 638 666 652 (76) 640 587 536
Total assets 16,077 15,517 15,580 15,663 15,612 14,940 14,263 14,149 15,068 14,960 15,187 15,326 14,870 15,319 15,523 16,163 16,780 16,314 15,922 15,529
Profitability Ratio
ROA1 16.76% 17.57% 17.14% 14.14% 13.51% 14.11% 15.33% 17.60% 16.73% 16.62% 16.23% 16.36% 17.24% 12.27% 12.12% 11.16% 10.05%
Benchmarks
ROA, Competitors2
Boeing Co. -3.03% -5.77% -5.92% -7.85% -7.80% -2.77% -1.75% -2.39% -0.48%
Caterpillar Inc. 7.84% 6.37% 5.37% 4.26% 3.83% 4.32% 5.41% 6.99% 7.77%
Cummins Inc. 8.99% 9.70% 9.75% 8.19% 7.91% 7.36% 8.41% 10.50% 11.45%
Eaton Corp. plc 6.30% 6.06% 5.12% 4.20% 4.43% 4.48% 5.08% 6.90% 6.74%
General Electric Co. -3.28% -0.02% -1.03% -1.34% 2.25% 1.49% -1.75% -0.90% -1.87%
Honeywell International Inc. 8.60% 8.53% 7.78% 7.28% 7.40% 7.85% 9.19% 10.99% 10.47%
Lockheed Martin Corp. 12.41% 11.69% 13.71% 13.52% 13.47% 12.88% 13.00% 12.68% 13.11%
RTX Corp. 2.39% 2.09% 1.37% -1.67% -2.17% -1.55% -1.01% 2.94% 3.96%

Based on: 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 Q4 2021 Calculation
ROA = 100 × (Net incomeQ4 2021 + Net incomeQ3 2021 + Net incomeQ2 2021 + Net incomeQ1 2021) ÷ Total assets
= 100 × (609 + 639 + 775 + 671) ÷ 16,077 = 16.76%

2 Click competitor name to see calculations.

Profitability ratio Description The company
ROA A profitability ratio calculated as net income divided by total assets. Illinois Tool Works Inc. ROA improved from Q2 2021 to Q3 2021 but then deteriorated significantly from Q3 2021 to Q4 2021.