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.

Economic Value Added (EVA)

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

Economic Profit

Illinois Tool Works Inc., economic profit calculation

US$ in millions

Microsoft Excel
12 months ended: Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Net operating profit after taxes (NOPAT)1
Cost of capital2
Invested capital3
 
Economic profit4

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

1 NOPAT. See details »

2 Cost of capital. See details »

3 Invested capital. See details »

4 2021 Calculation
Economic profit = NOPAT – Cost of capital × Invested capital
= × =


Net Operating Profit After Taxes (NOPAT)
The NOPAT exhibited a general upward trajectory from 2017 to 2021, beginning at $1,924 million in 2017 and reaching $2,907 million by 2021. A notable increase occurred between 2017 and 2018, rising sharply to $2,774 million. There was a slight decline in 2019 followed by a more pronounced drop in 2020, which coincides with the period of global economic challenges. However, recovery is apparent in 2021 with NOPAT surpassing previous highs.
Cost of Capital
The cost of capital exhibited a modest upward trend over the five-year period, increasing from 13.99% in 2017 to 14.38% in 2021. This gradual rise suggests a slight increase in the company’s required return or risk profile during this timeframe.
Invested Capital
Invested capital demonstrated relative stability with minor fluctuations, moving from $14,406 million in 2017 down to $12,895 million in 2018, suggesting a divestment or capital reduction phase. Subsequently, invested capital increased steadily each year through 2021, reaching $13,555 million. This reflects a cautious but consistent reinvestment strategy post-2018.
Economic Profit
Economic profit showed a significant improvement from a negative figure of -$91 million in 2017 to a positive and elevated level of $961 million in 2018. After a slight decline in 2019 and a further reduction in 2020 to $369 million, economic profit rebounded strongly to $958 million in 2021. This pattern correlates with changes in NOPAT and suggests enhanced value creation despite some volatility during the period.
Summary
Overall, the financial metrics indicate that the company has improved its operational profitability and economic value generation over the five-year period, notwithstanding some interim declines likely influenced by external factors. The gradual increase in cost of capital suggests rising market requirements or risk considerations, while the cautious management of invested capital demonstrates responsiveness to changing conditions. The recovery patterns in NOPAT and economic profit in 2021 highlight a resilient performance trajectory.

Net Operating Profit after Taxes (NOPAT)

Illinois Tool Works Inc., NOPAT calculation

US$ in millions

Microsoft Excel
12 months ended: Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Net income
Deferred income tax expense (benefit)1
Increase (decrease) in allowance for doubtful accounts2
Increase (decrease) in LIFO reserve3
Increase (decrease) in deferred revenue and customer deposits4
Increase (decrease) in accrued product warranties5
Increase (decrease) in equity equivalents6
Interest expense
Interest expense, operating lease liability7
Adjusted interest expense
Tax benefit of interest expense8
Adjusted interest expense, after taxes9
Interest income
Investment income, before taxes
Tax expense (benefit) of investment income10
Investment income, after taxes11
Net operating profit after taxes (NOPAT)

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

1 Elimination of deferred tax expense. See details »

2 Addition of increase (decrease) in allowance for doubtful accounts.

3 Addition of increase (decrease) in LIFO reserve. See details »

4 Addition of increase (decrease) in deferred revenue and customer deposits.

5 Addition of increase (decrease) in accrued product warranties.

6 Addition of increase (decrease) in equity equivalents to net income.

7 2021 Calculation
Interest expense on capitalized operating leases = Operating lease liability × Discount rate
= × =

8 2021 Calculation
Tax benefit of interest expense = Adjusted interest expense × Statutory income tax rate
= × 21.00% =

9 Addition of after taxes interest expense to net income.

10 2021 Calculation
Tax expense (benefit) of investment income = Investment income, before tax × Statutory income tax rate
= × 21.00% =

11 Elimination of after taxes investment income.


Net Income
The net income exhibited an overall upward trend from 2017 to 2021, starting at 1,687 million US dollars in 2017 and rising to 2,694 million US dollars by 2021. There was a significant increase between 2017 and 2018, followed by a slight decline in 2019. A more noticeable decrease occurred in 2020, likely reflecting challenging conditions during that year. Nevertheless, the net income rebounded strongly in 2021, reaching its highest value in the period analyzed.
Net Operating Profit After Taxes (NOPAT)
Similar to net income, the NOPAT also demonstrated positive growth over the five-year span. It increased from 1,924 million US dollars in 2017 to 2,907 million US dollars in 2021. The data shows a peak in 2018, followed by a gradual decline in 2019 and 2020, before recovering substantially in 2021. The pattern aligns closely with the net income trend, indicating consistent operational performance and profitability improvements toward the end of the period.
Summary of Trends
Both net income and NOPAT reveal a pattern of growth with intermittent setbacks. The declines observed in 2019 and 2020 suggest external or internal challenges impacting profitability during those years. The recovery in 2021 indicates resilience and potential operational improvements or favorable market conditions. Overall, the financial results over the period reflect strong profitability with transient fluctuations rather than a continuous trend of increase or decrease.

Cash Operating Taxes

Illinois Tool Works Inc., cash operating taxes calculation

US$ in millions

Microsoft Excel
12 months ended: Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Provision for income taxes
Less: Deferred income tax expense (benefit)
Add: Tax savings from interest expense
Less: Tax imposed on investment income
Cash operating taxes

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 financial data reveals trends in the provision for income taxes and cash operating taxes over a five-year period ending in 2021.

Provision for Income Taxes
The provision for income taxes shows a clear downward trend from 2017 through 2020, starting at $1,583 million in 2017 and declining significantly to $595 million in 2020. This represents a decrease of approximately 62.4% over three years. In 2021, the provision for income taxes experienced a slight increase to $632 million, indicating a minor reversal of the prior years’ declining trend but still remaining well below the initial 2017 level.
Cash Operating Taxes
Cash operating taxes followed a similar pattern to the provision for income taxes but with less pronounced variability. Beginning at $1,597 million in 2017, cash operating taxes decreased to $666 million in 2020. This decline of roughly 58.3% over four years suggests effective cash tax management or changes in taxable income. Unlike the provision for income taxes, cash operating taxes increased notably in 2021 to $821 million, representing a larger rebound compared to the provision figure but still below 2017 values.

Overall, both tax-related expenses exhibit a significant downward trend during the initial four years, which may reflect changes in earnings, tax planning strategies, or tax rate adjustments. The partial recovery in both measures in 2021 suggests a stabilization or potential increase in taxable earnings or adjustments in tax liabilities. The gap between provision and cash operating taxes is relatively narrow throughout the period, indicating consistency between accrued and actual cash tax payments.


Invested Capital

Illinois Tool Works Inc., invested capital calculation (financing approach)

US$ in millions

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Short-term debt
Long-term debt
Operating lease liability1
Total reported debt & leases
Stockholders’ equity attributable to ITW
Net deferred tax (assets) liabilities2
Allowance for doubtful accounts3
LIFO reserve4
Deferred revenue and customer deposits5
Accrued product warranties6
Equity equivalents7
Accumulated other comprehensive (income) loss, net of tax8
Noncontrolling interest
Adjusted stockholders’ equity attributable to ITW
Construction in progress9
Invested capital

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

1 Addition of capitalized operating leases.

2 Elimination of deferred taxes from assets and liabilities. See details »

3 Addition of allowance for doubtful accounts receivable.

4 Addition of LIFO reserve. See details »

5 Addition of deferred revenue and customer deposits.

6 Addition of accrued product warranties.

7 Addition of equity equivalents to stockholders’ equity attributable to ITW.

8 Removal of accumulated other comprehensive income.

9 Subtraction of construction in progress.


Total reported debt & leases
The total reported debt and leases exhibit some variability over the analyzed period. Starting at $8,612 million in 2017, the figure declines to a low of $7,583 million in 2018, before experiencing a gradual increase, reaching $8,310 million in 2020, and then decreasing again to $7,881 million in 2021. Overall, the debt level fluctuates within a relatively narrow range, indicating some active management of debt levels without significant long-term increases or decreases.
Stockholders’ equity attributable to ITW
Stockholders' equity shows a declining trend from 2017 through 2019, dropping from $4,585 million to $3,026 million. In 2020, there is a slight recovery to $3,181 million, followed by a more substantial increase to $3,625 million in 2021. This pattern suggests that the company faced equity reductions initially, with a partial rebound in the later years of the period under review.
Invested capital
Invested capital declines from $14,406 million in 2017 to $12,895 million in 2018, then experiences a steady increase each year to $13,033 million in 2019, $13,434 million in 2020, and $13,555 million in 2021. This trend indicates growing investment in the company's operations or assets after an initial drop, reflecting possibly increased capital expenditures or acquisition activity post-2018.

Cost of Capital

Illinois Tool Works Inc., cost of capital calculations

Capital (fair value)1 Weights Cost of capital
Equity2 ÷ = × =
Debt3 ÷ = × × (1 – 21.00%) =
Operating lease liability4 ÷ = × × (1 – 21.00%) =
Total:

Based on: 10-K (reporting date: 2021-12-31).

1 US$ in millions

2 Equity. See details »

3 Debt. See details »

4 Operating lease liability. See details »

Capital (fair value)1 Weights Cost of capital
Equity2 ÷ = × =
Debt3 ÷ = × × (1 – 21.00%) =
Operating lease liability4 ÷ = × × (1 – 21.00%) =
Total:

Based on: 10-K (reporting date: 2020-12-31).

1 US$ in millions

2 Equity. See details »

3 Debt. See details »

4 Operating lease liability. See details »

Capital (fair value)1 Weights Cost of capital
Equity2 ÷ = × =
Debt3 ÷ = × × (1 – 21.00%) =
Operating lease liability4 ÷ = × × (1 – 21.00%) =
Total:

Based on: 10-K (reporting date: 2019-12-31).

1 US$ in millions

2 Equity. See details »

3 Debt. See details »

4 Operating lease liability. See details »

Capital (fair value)1 Weights Cost of capital
Equity2 ÷ = × =
Debt3 ÷ = × × (1 – 21.00%) =
Operating lease liability4 ÷ = × × (1 – 21.00%) =
Total:

Based on: 10-K (reporting date: 2018-12-31).

1 US$ in millions

2 Equity. See details »

3 Debt. See details »

4 Operating lease liability. See details »

Capital (fair value)1 Weights Cost of capital
Equity2 ÷ = × =
Debt3 ÷ = × × (1 – 35.00%) =
Operating lease liability4 ÷ = × × (1 – 35.00%) =
Total:

Based on: 10-K (reporting date: 2017-12-31).

1 US$ in millions

2 Equity. See details »

3 Debt. See details »

4 Operating lease liability. See details »


Economic Spread Ratio

Illinois Tool Works Inc., economic spread ratio calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in millions)
Economic profit1
Invested capital2
Performance Ratio
Economic spread ratio3
Benchmarks
Economic Spread Ratio, Competitors4
Boeing Co.
Caterpillar Inc.
Eaton Corp. plc
GE Aerospace
Honeywell International Inc.
Lockheed Martin Corp.
RTX Corp.

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

1 Economic profit. See details »

2 Invested capital. See details »

3 2021 Calculation
Economic spread ratio = 100 × Economic profit ÷ Invested capital
= 100 × ÷ =

4 Click competitor name to see calculations.


Economic Profit
The economic profit exhibited significant volatility over the analyzed period. It started with a notable negative value of -91 million US dollars at the end of 2017, followed by a marked increase to 961 million in 2018. In 2019, economic profit slightly decreased to 824 million, then sharply declined to 369 million in 2020. By 2021, it rebounded strongly to 958 million. This pattern indicates substantial fluctuations but generally a positive trend after the initial negative figure.
Invested Capital
Invested capital experienced relative stability with slight fluctuations throughout the period. It decreased from 14,406 million US dollars in 2017 to 12,895 million in 2018, then gradually increased each subsequent year to reach 13,555 million by the end of 2021. Overall, the invested capital shows a mild recovery after an initial dip, suggesting cautious capital allocation or divestiture followed by moderate reinvestment.
Economic Spread Ratio
The economic spread ratio followed a pattern similar to economic profit but with more pronounced variation. It showed a negative return of -0.63% in 2017, then increased substantially to 7.46% in 2018. It decreased slightly to 6.32% in 2019, dropped notably to 2.74% in 2020, and rebounded to 7.07% in 2021. This trend suggests fluctuating profitability relative to capital costs, with a temporary decline in 2020 likely due to external or operational factors, followed by recovery in 2021.

Economic Profit Margin

Illinois Tool Works Inc., economic profit margin calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in millions)
Economic profit1
 
Operating revenue
Add: Increase (decrease) in deferred revenue and customer deposits
Adjusted operating revenue
Performance Ratio
Economic profit margin2
Benchmarks
Economic Profit Margin, Competitors3
Boeing Co.
Caterpillar Inc.
Eaton Corp. plc
GE Aerospace
Honeywell International Inc.
Lockheed Martin Corp.
RTX Corp.

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

1 Economic profit. See details »

2 2021 Calculation
Economic profit margin = 100 × Economic profit ÷ Adjusted operating revenue
= 100 × ÷ =

3 Click competitor name to see calculations.


Economic Profit
The economic profit showed significant fluctuations over the analyzed periods. It started negative in 2017 at -91 million US dollars, then experienced a substantial increase in 2018 reaching 961 million US dollars. This positive trend continued in 2019 with 824 million US dollars, but there was a notable decline in 2020 to 369 million US dollars, before rebounding again in 2021 to 958 million US dollars. This indicates a volatile but generally improving capacity to generate profit above the cost of capital after an initial loss.
Adjusted Operating Revenue
Adjusted operating revenue remained relatively stable but showed some variation. It increased slightly from 14,339 million US dollars in 2017 to a peak of 14,778 million US dollars in 2018, followed by a decline to 14,082 million US dollars in 2019 and a further drop in 2020 to 12,608 million US dollars. However, the revenue recovered in 2021 to 14,627 million US dollars, approaching the levels seen in the earlier years. This pattern suggests some resilience in revenue generation despite temporary setbacks.
Economic Profit Margin
The economic profit margin reflected changes in economic profit relative to revenue. It was negative in 2017 at -0.63%, then sharply increased to 6.51% in 2018 and slightly declined to 5.85% in 2019. The margin fell to 2.92% in 2020, indicating weaker profitability relative to revenue, but rose again to 6.55% in 2021. These fluctuations mirror the trends in economic profit and suggest a recovery in operational efficiency and value creation post-2020 downturn.