Stock Analysis on Net
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.

DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin

Microsoft Excel

Two-Component Disaggregation of ROE

Illinois Tool Works Inc., decomposition of ROE

Microsoft Excel
ROE = ROA × Financial Leverage
Dec 31, 2021 74.32% = 16.76% × 4.44
Dec 31, 2020 66.30% = 13.51% × 4.91
Dec 31, 2019 83.31% = 16.73% × 4.98
Dec 31, 2018 78.76% = 17.24% × 4.57
Dec 31, 2017 36.79% = 10.05% × 3.66

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).


The return on equity exhibited significant growth and volatility between 2017 and 2021, characterized by a sharp ascent in the early part of the period, a contraction in 2020, and a subsequent recovery. This performance is the result of the interaction between operational asset efficiency and the strategic use of financial leverage.

Return on Assets (ROA)
A substantial increase in asset productivity is observed between 2017 and 2018, with the ratio rising from 10.05% to 17.24%. Following this surge, the ratio remained relatively stable through 2019 before experiencing a decline to 13.51% in 2020. A recovery followed in 2021, bringing the ROA back to 16.76%.
Financial Leverage
The leverage ratio demonstrates a consistent upward trend from 2017 to 2019, increasing from 3.66 to a peak of 4.98. This indicates a heightened use of debt to amplify returns on equity during this timeframe. A gradual reduction in leverage occurred thereafter, resulting in a ratio of 4.44 by the end of 2021.
Return on Equity (ROE)
ROE experienced a dramatic expansion from 36.79% in 2017 to a peak of 83.31% in 2019. This growth was compounded by the simultaneous improvement in ROA and the increase in financial leverage. The decline to 66.30% in 2020 was primarily driven by the reduction in asset returns, while the 2021 increase to 74.32% reflects a restoration of operational efficiency despite a lower leverage ratio compared to the 2019 peak.

The overall analysis indicates that the surge in shareholder returns through 2019 was achieved through a dual strategy of increasing asset profitability and expanding financial gearing. While the 2020 downturn suggests a temporary sensitivity to operational headwinds, the 2021 recovery confirms a resilient ability to generate high equity returns even with a slightly reduced leverage profile.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.

How can I help you?


Three-Component Disaggregation of ROE

Illinois Tool Works Inc., decomposition of ROE

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Dec 31, 2021 74.32% = 18.64% × 0.90 × 4.44
Dec 31, 2020 66.30% = 16.77% × 0.81 × 4.91
Dec 31, 2019 83.31% = 17.87% × 0.94 × 4.98
Dec 31, 2018 78.76% = 17.36% × 0.99 × 4.57
Dec 31, 2017 36.79% = 11.79% × 0.85 × 3.66

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).


The Return on Equity (ROE) exhibited significant growth and volatility over the five-year period, increasing from 36.79% in 2017 to 74.32% in 2021. A sharp escalation is observed between 2017 and 2019, where ROE peaked at 83.31%, followed by a contraction in 2020 and a subsequent recovery in 2021.

Net Profit Margin
A general upward trend in operational profitability is evident, with the margin expanding from 11.79% in 2017 to 18.64% in 2021. The most substantial improvement occurred between 2017 and 2018, indicating a marked increase in the percentage of revenue retained as net income. A slight dip to 16.77% in 2020 was followed by the highest margin in the analyzed period by 2021.
Asset Turnover
Efficiency in asset utilization showed a fluctuating pattern, peaking at 0.99 in 2018 before declining to a period low of 0.81 in 2020. This suggests a temporary reduction in the company's ability to generate sales from its asset base during 2020, though a recovery to 0.90 was achieved by 2021.
Financial Leverage
The equity multiplier increased significantly from 3.66 in 2017 to a peak of 4.98 in 2019, indicating an increased reliance on debt to finance assets and amplify returns to shareholders. This trend reversed slightly after 2019, with the ratio moderating to 4.44 by 2021, suggesting a slight reduction in financial risk or a restructuring of the capital base.

The analysis indicates that the primary drivers of the ROE expansion between 2017 and 2019 were the simultaneous increases in net profit margin and financial leverage. While asset turnover remained relatively stable, the combination of higher profitability and increased leverage significantly magnified the return on equity. The decline in ROE observed in 2020 is attributable to a simultaneous contraction in both asset turnover and profit margins, which outweighed the impact of the high financial leverage maintained during that year.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.

How can I help you?


Five-Component Disaggregation of ROE

Illinois Tool Works Inc., decomposition of ROE

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Dec 31, 2021 74.32% = 0.81 × 0.94 × 24.41% × 0.90 × 4.44
Dec 31, 2020 66.30% = 0.78 × 0.93 × 23.14% × 0.81 × 4.91
Dec 31, 2019 83.31% = 0.77 × 0.94 × 24.87% × 0.94 × 4.98
Dec 31, 2018 78.76% = 0.76 × 0.93 × 24.72% × 0.99 × 4.57
Dec 31, 2017 36.79% = 0.52 × 0.93 × 24.66% × 0.85 × 3.66

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).


The Return on Equity (ROE) exhibited a substantial upward trend between 2017 and 2019, rising from 36.79% to 83.31%, followed by a contraction to 66.30% in 2020 and a subsequent recovery to 74.32% in 2021. The analysis indicates that this overall expansion was primarily driven by tax efficiency and increased financial leverage rather than fundamental shifts in operating margins.

Tax Burden
A significant increase is observed in the tax burden ratio, which rose from 0.52 in 2017 to 0.76 in 2018. This upward trajectory continued steadily to reach 0.81 by 2021, indicating a reduction in the effective tax rate that directly contributed to higher net income.
Interest Burden
The interest burden remained highly stable across the five-year period, fluctuating minimally between 0.93 and 0.94. This suggests that the cost of debt remained a consistent and manageable portion of operating profits.
EBIT Margin
Operating profitability remained resilient, with the EBIT margin generally maintaining a range between 24% and 25%. A temporary dip to 23.14% occurred in 2020, followed by a recovery to 24.41% in 2021, reflecting stable core operational efficiency.
Asset Turnover
Asset utilization showed cyclical volatility, peaking at 0.99 in 2018 before declining to a low of 0.81 in 2020. The subsequent increase to 0.90 in 2021 indicates a recovery in the efficiency of assets in generating revenue.
Financial Leverage
Financial leverage increased sharply from 3.66 in 2017 to a peak of 4.98 in 2019. While it moderately decreased to 4.44 by 2021, the sustained higher level of leverage compared to 2017 acted as a multiplier for the ROE.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.

How can I help you?


Two-Component Disaggregation of ROA

Illinois Tool Works Inc., decomposition of ROA

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Dec 31, 2021 16.76% = 18.64% × 0.90
Dec 31, 2020 13.51% = 16.77% × 0.81
Dec 31, 2019 16.73% = 17.87% × 0.94
Dec 31, 2018 17.24% = 17.36% × 0.99
Dec 31, 2017 10.05% = 11.79% × 0.85

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).


The Return on Assets (ROA) exhibited significant volatility between 2017 and 2021, characterized by a sharp increase in 2018, a contraction in 2020, and a subsequent recovery in 2021. The overall trajectory reflects a transition from a baseline of 10.05% in 2017 to 16.76% by the end of 2021, indicating a general improvement in the efficiency of asset utilization to generate profits over the five-year period.

Net Profit Margin
A consistent upward trend in profitability is observed, with the net profit margin rising from 11.79% in 2017 to a peak of 18.64% in 2021. The most substantial expansion occurred between 2017 and 2018, where the margin increased by 5.57 percentage points. Despite a minor decline to 16.77% in 2020, the margin remained significantly higher than the 2017 level, suggesting a sustained improvement in cost management or pricing power.
Asset Turnover
Asset utilization demonstrated greater instability compared to profit margins. The ratio peaked at 0.99 in 2018 before declining to a period low of 0.81 in 2020. This decline indicates a temporary reduction in the company's ability to generate revenue from its asset base during that year. A partial recovery to 0.90 was recorded in 2021, though it remained below the 2018 peak.
ROA Driver Analysis
The disaggregation of ROA reveals that profit margin expansion was the primary driver of the overall return increase. The sharp rise in ROA from 10.05% in 2017 to 17.24% in 2018 was a result of simultaneous improvements in both net profit margin and asset turnover. Conversely, the dip in ROA to 13.51% in 2020 was predominantly driven by the deterioration in asset turnover, as the net profit margin remained relatively stable. The 2021 recovery was fueled by the highest recorded net profit margin of the period, which offset the fact that asset turnover had not yet returned to its 2018 levels.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.

How can I help you?


Four-Component Disaggregation of ROA

Illinois Tool Works Inc., decomposition of ROA

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Dec 31, 2021 16.76% = 0.81 × 0.94 × 24.41% × 0.90
Dec 31, 2020 13.51% = 0.78 × 0.93 × 23.14% × 0.81
Dec 31, 2019 16.73% = 0.77 × 0.94 × 24.87% × 0.94
Dec 31, 2018 17.24% = 0.76 × 0.93 × 24.72% × 0.99
Dec 31, 2017 10.05% = 0.52 × 0.93 × 24.66% × 0.85

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).


The return on assets (ROA) exhibited significant volatility over the five-year period, characterized by a sharp increase between 2017 and 2018, a contraction in 2020, and a subsequent recovery in 2021. The overall trend reflects a shift from 10.05% in 2017 to 16.76% in 2021, driven by a combination of tax efficiency and operational stability.

Tax Burden
A consistent and substantial upward trend is observed in the tax burden ratio, which increased from 0.52 in 2017 to 0.81 in 2021. The most dramatic rise occurred between 2017 and 2018, suggesting that a reduction in the effective tax rate was the primary catalyst for the initial surge in ROA.
Interest Burden
The interest burden remained exceptionally stable, fluctuating minimally between 0.93 and 0.94 throughout the entire period. This indicates that interest expenses had no material impact on the variability of the return on assets, reflecting a consistent debt service profile.
EBIT Margin
Operating profitability remained resilient, with margins generally staying within the 24% to 25% range. A moderate decline to 23.14% was recorded in 2020, which contributed to the overall dip in ROA for that year, followed by a recovery to 24.41% in 2021.
Asset Turnover
Asset efficiency demonstrated a cyclical pattern, peaking at 0.99 in 2018 before declining to a period low of 0.81 in 2020. The subsequent increase to 0.90 in 2021 indicates a recovery in the company's ability to generate sales relative to its asset base.

The analysis indicates that while the EBIT margin and interest burden provided a stable foundation, the fluctuations in ROA were predominantly driven by tax burden improvements and changes in asset turnover. The contraction observed in 2020 was a result of simultaneous declines in both the EBIT margin and asset turnover, both of which rebounded in 2021 to restore the ROA to levels seen in 2019.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.

How can I help you?


Disaggregation of Net Profit Margin

Illinois Tool Works Inc., decomposition of net profit margin ratio

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Dec 31, 2021 18.64% = 0.81 × 0.94 × 24.41%
Dec 31, 2020 16.77% = 0.78 × 0.93 × 23.14%
Dec 31, 2019 17.87% = 0.77 × 0.94 × 24.87%
Dec 31, 2018 17.36% = 0.76 × 0.93 × 24.72%
Dec 31, 2017 11.79% = 0.52 × 0.93 × 24.66%

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).


The Net Profit Margin exhibits a significant upward trajectory over the observed five-year period, rising from 11.79% in 2017 to 18.64% in 2021. Although a temporary contraction to 16.77% occurred in 2020, the overall trend indicates a substantial increase in the company's ability to convert revenue into net income.

Tax Burden
A marked improvement is observed in the tax burden ratio, which increased from 0.52 in 2017 to 0.81 by 2021. This consistent upward trend represents the primary driver of the expanded net profit margin, indicating a significant reduction in the effective tax rate over the period.
Interest Burden
The interest burden remained remarkably stable, fluctuating minimally between 0.93 and 0.94 throughout the entire period. This consistency suggests that interest expenses have exerted a negligible and steady influence on the conversion of operating income to pre-tax income.
EBIT Margin
Operating profitability remained relatively stable, generally fluctuating between 24% and 25%. A localized decline to 23.14% was recorded in 2020, which directly correlates with the simultaneous dip in the net profit margin, indicating a temporary period of operational pressure.

The disaggregation of the net profit margin reveals that the overall expansion of profitability was not driven by operational efficiency gains, as the EBIT margin remained relatively flat. Instead, the growth is predominantly attributable to a favorable shift in the tax burden, supported by a highly stable interest expense profile.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.

How can I help you?