Stock Analysis on Net

Illinois Tool Works Inc. (NYSE:ITW)

$22.49

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
Quarterly Data

Microsoft Excel

Paying user area

The data is hidden behind: . Unhide it.

This is a one-time payment. There is no automatic renewal.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Two-Component Disaggregation of ROE

Illinois Tool Works Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
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 = ×

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


The analysis of the quarterly financial data reveals significant trends and fluctuations in key performance ratios over the observed periods.

Return on Assets (ROA)
From its first recorded value in March 2018 at 10.05%, ROA demonstrated a steady upward trajectory reaching a peak of 17.6% in June 2020. Following this peak, there was a gradual decline, with values decreasing to 14.11% in September 2020 and further to 13.51% in December 2020. However, ROA recovered somewhat in 2021, returning to higher levels around 17.14% to 17.57% between March and June 2021, before starting a slight decrease again toward the end of the year.
Financial Leverage
Financial leverage showed an increasing trend over the period up to March 2020, climbing from 3.46 in March 2017 to a notable peak of 6.2 in March 2020. After this peak, leverage began to decrease progressively, falling to 4.91 by December 2020 and stabilizing in the range of 4.43 to 4.78 throughout 2021. This pattern indicates a period of increased debt or equity structure adjustments prior to a deliberate reduction in leverage post-March 2020.
Return on Equity (ROE)
The ROE exhibits significant volatility with an overall increasing trend from 36.79% in March 2018 to an extremely high peak of 109.07% in June 2020. Post this peak, the ratio sharply declined to 78.19% by September 2020 and continued trending lower to 66.3% by March 2021. Subsequently, a moderate recovery occurred, with ROE increasing again to around 75.85% to 78.09% from September to December 2021. The extreme peak in mid-2020 followed by marked decline may reflect exceptional earnings or capital structure changes influenced by macroeconomic factors during that timeframe.

Overall, the data indicates strong profitability improvements through 2018 and into early 2020, concurrent with rising leverage. The period around March to June 2020 marks significant performance peaks across all metrics, followed by corrections and adjustments in leverage and returns. Throughout 2021, the company appears to stabilize with moderately high profitability and reduced financial leverage compared to the peak levels observed in 2020.


Three-Component Disaggregation of ROE

Illinois Tool Works Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
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 = × ×

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


Net Profit Margin
The net profit margin was first reported in the quarter ending March 31, 2018, starting at 11.79%. It showed a general upward trend over the subsequent quarters, reaching a peak of 19.14% in June 30, 2021. Although there were minor fluctuations, the margin remained robust and relatively stable above 16% from March 31, 2019, onward, indicating improving profitability over time.
Asset Turnover
The asset turnover ratio was also first provided in the quarter ending March 31, 2018, beginning at 0.85. This ratio increased gradually until December 31, 2018, peaking near 0.99, suggesting more efficient use of assets during that period. Afterward, there was a declining trend noted through to December 31, 2020, with a low point of 0.81. The ratio then rebounded through 2021, reaching 0.92 in September 30, 2021, suggesting an improvement in asset utilization after a dip during the pandemic period.
Financial Leverage
The financial leverage started at 3.46 in the earliest available quarter of March 31, 2017 and showed a steady increase until March 31, 2020, peaking at 6.20. This indicates the company was increasingly utilizing debt financing during this period. Following this peak, leverage declined steadily through to December 31, 2021, settling around 4.44. This reduction implies a strategic deleveraging or balance sheet strengthening in more recent periods.
Return on Equity (ROE)
Return on equity figures were first available on March 31, 2018, at 36.79%. The ROE exhibited a strong upward trajectory, reaching very high levels peaking at 109.07% on June 30, 2020. After this peak, there was a notable decline, though figures remained substantially elevated relative to the initial reporting period. By December 31, 2021, ROE stood at 74.32%, indicating sustained high profitability relative to shareholders' equity despite the pullback from peak levels.
Overall Observations
The financial data reveals a pattern where net profit margins improved progressively and stabilized at a higher level. Asset turnover demonstrated cyclical behavior, rising initially, then dipping around the 2020 period, likely reflecting operational challenges, before recovering. The increase in financial leverage until early 2020 followed by a reduction suggests active management of capital structure, potentially to mitigate risk. The ROE trend closely mirrors leverage and profitability improvements, peaking during the 2020 period and remaining strong thereafter, highlighting high efficiency in generating returns for shareholders despite market fluctuations.

Five-Component Disaggregation of ROE

Illinois Tool Works Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
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 = × × × ×

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


Tax Burden
The tax burden ratio exhibits a steady upward trend from 0.52 in March 2018 to approximately 0.81 by December 2021. This suggests an increasing retention of earnings after taxes over the observed period.
Interest Burden
The interest burden ratio remains remarkably stable throughout the periods, fluctuating marginally between 0.93 and 0.94. This indicates consistent interest expense management relative to earnings before interest and taxes.
EBIT Margin
The EBIT margin percentage experiences slight fluctuations, generally oscillating around the mid-20s. It peaks near 25% in late 2017 and early 2019, but dips to around 23% during the latter half of 2020, recovering slightly thereafter. Overall, profitability from operations remains relatively stable with minor variances.
Asset Turnover
Asset turnover displays a rising trend from 0.85 in early 2017 to a high near 0.99 in early 2019, followed by a decline during 2020 reaching a low around 0.81 in late 2020. Recovery is noted in 2021 when the ratio moves back towards 0.9. This indicates variations in asset utilization efficiency, possibly influenced by external economic factors during 2020.
Financial Leverage
Financial leverage ratios steadily increase from 3.25 in late 2017 to a peak of 6.2 in March 2020, then decrease gradually to approximately 4.44 by the end of 2021. This signifies an elevated use of debt financing around early 2020 followed by deleveraging efforts.
Return on Equity (ROE)
The ROE demonstrates significant volatility with a pronounced increase from around 37% in early 2018 to a peak exceeding 109% in March 2020. After this peak, ROE declines but remains elevated, fluctuating around 74% to 79% through the end of 2021. This pattern suggests amplified profitability possibly driven by financial leverage and operational factors, particularly notable during early 2020.
Summary
The overall financial trends depict a company maintaining stable operational margins and interest cost control, while experiencing fluctuations in asset efficiency and leverage. The substantial rise and subsequent moderation in ROE, coupled with increased financial leverage, point toward strategic borrowing to enhance returns which was later tempered. The decline in asset turnover and EBIT margin during 2020 likely reflect external disruptions, with recovery visible in 2021. The increasing tax burden ratio suggests improved post-tax earnings retention. Collectively, the data indicates a firm navigating through economic challenges with adjustments in financial structure and operational performance.

Two-Component Disaggregation of ROA

Illinois Tool Works Inc., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
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 = ×

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


Net Profit Margin
The net profit margin exhibits an overall upward trend starting from 11.79% at the end of Q1 2018, gradually increasing to a peak of 19.14% in Q3 2021. The margin maintains a relatively stable range between approximately 12% and 13% during 2018, before a significant improvement begins in Q1 2019. This upward momentum continues with minor fluctuations through 2019 and 2020, reaching levels above 17%. After a slight decline in late 2020, the margin recovers and peaks in the second half of 2021, indicating enhanced profitability over the period analyzed.
Asset Turnover
Asset turnover shows modest variation across the observed periods. Starting at 0.85 in Q1 2018, it rises steadily to near 0.99 by Q1 2019, indicating improved efficiency in using assets to generate sales. However, this upward trend reverses in late 2019 and 2020, with asset turnover declining to lows around 0.81 by Q4 2020. A gradual recovery follows in 2021, with the ratio increasing to approximately 0.9, though it does not reach previous peak levels. This pattern suggests fluctuations in asset utilization efficiency with periods of improvement followed by some contractions and partial recovery.
Return on Assets (ROA)
ROA trends closely mirror those of net profit margin, reflecting underlying profitability dynamics. It begins at 10.05% in Q1 2018 and climbs steadily to over 17% in Q1 2019. The ratio remains relatively stable near this high level throughout 2019 and into early 2020, followed by a decline to approximately 13.5% by the end of 2020. The subsequent period in 2021 reveals a recovery with ROA increasing again towards 17%, demonstrating improved asset profitability. Despite the fluctuations, the general trajectory indicates enhanced capacity to generate returns from assets over the time frame considered.

Four-Component Disaggregation of ROA

Illinois Tool Works Inc., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
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 = × × ×

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


Tax Burden
The tax burden ratio demonstrates a consistent upward trend starting from 0.52 in the first observable quarter of 2018 to 0.81 by the end of 2021. This indicates an increasing portion of pre-tax income being retained after taxes over the period, suggesting more favorable tax conditions or improved tax efficiency.
Interest Burden
The interest burden ratio remains remarkably stable throughout the entire period analyzed, hovering around 0.93 to 0.94. This stability suggests that the company's interest expenses have been consistently managed relative to operating income, showing no significant fluctuations in debt-related costs.
EBIT Margin
The EBIT margin shows a relatively stable pattern, maintaining a level predominantly between 23% and 25%. Minor declines are noticeable during the middle of 2020, where it dips closer to 23.14% but recovers towards 25% by the end of 2021. This demonstrates sustained operational profitability, with some impact observed during 2020, potentially linked to external factors affecting margins temporarily.
Asset Turnover
Asset turnover starts at 0.85 and improves to a peak of 0.99 by early 2019, reflecting enhanced efficiency in utilizing assets to generate revenues. However, post 2019, there is a gradual decline to approximately 0.81 by the end of 2020, followed by a partial recovery up to around 0.92 by late 2021. This indicates a fluctuation in asset utilization efficiency, with a downturn around 2020 and recovery thereafter.
Return on Assets (ROA)
Return on assets increases significantly from 10.05% in early 2018 to a peak of approximately 17.6% in mid-2020, followed by a moderate decline to about 13.5% by late 2020. It then rebounds towards 17.57% by the end of 2021. This trend reflects overall improved profitability relative to the asset base, with some volatility coinciding with changes in asset turnover and EBIT margin, especially noticeable around the 2020 period.

Disaggregation of Net Profit Margin

Illinois Tool Works Inc., decomposition of net profit margin ratio (quarterly data)

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
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 = × ×

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


Tax Burden
The tax burden ratio demonstrates a noticeable upward trend starting from the first available data in March 2018. Initially, it hovered around 0.52 to 0.56 in early 2018 and then sharply increased to approximately 0.75-0.78 from March 2019 through December 2020. From March 2021 onward, the ratio moved further upward, stabilizing around 0.81, indicating a higher proportion of income retained after tax over the later periods.
Interest Burden
The interest burden ratio remained remarkably stable throughout the observed periods. It consistently maintained a level close to 0.93-0.94, showing minimal fluctuations. This stability suggests that the cost of interest relative to operating income has been stable, without significant changes in financial leverage or interest expenses impacting profit before tax.
EBIT Margin
The EBIT margin displayed moderate fluctuations over the periods. It started in the vicinity of 24.5% to 25% in 2017 and 2018, with a slight decline observed in mid to late 2020, dropping to a low of approximately 23.14% by September 2020. There is a subsequent recovery in 2021, returning close to previous levels around 24.4% to 25%. Overall, the EBIT margin reflects a generally steady operating profitability with a temporary dip likely attributable to external or operational challenges during 2020.
Net Profit Margin
Net profit margin shows a clear increasing trend over time. From values around 11.8%-12.7% in early 2018, there is a marked jump to the range of approximately 17%-18% from 2019 through 2020. The upward trend continues in 2021, reaching levels above 19%, suggesting improved overall profitability. This improvement is likely influenced by the higher tax burden ratio indicating enhanced post-tax earnings and stable interest expenses, allowing for better net income generation relative to sales.