Stock Analysis on Net

Sherwin-Williams Co. (NYSE:SHW)

$24.99

Economic Value Added (EVA)

Microsoft Excel

EVA is registered trademark of Stern Stewart.

Economic value added or economic profit is the difference between revenues and costs,where costs include not only expenses, but also cost of capital.

Paying user area


We accept:

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

Economic Profit

Sherwin-Williams Co., economic profit calculation

US$ in thousands

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

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 NOPAT. See details »

2 Cost of capital. See details »

3 Invested capital. See details »

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


Net Operating Profit After Taxes (NOPAT)
The NOPAT shows a consistent upward trend over the five-year period, increasing from approximately $2.19 billion in 2020 to nearly $2.96 billion in 2024. This represents a notable cumulative growth, with particularly strong increments observed after 2022, indicating improved operational efficiency or profitability in recent years.
Cost of Capital
The cost of capital remained relatively stable across the period, fluctuating slightly around the mid-14% to mid-15% range. Starting at 14.85% in 2020, it saw a minor decline through 2022 before rising again to 15.44% in 2024. This suggests a generally steady financing environment with a slight uptick in capital costs in the final year.
Invested Capital
Invested capital increased over the observed period with some variability. It grew from roughly $15.49 billion in 2020 to a peak of about $17.35 billion in 2022, then decreased in 2023 to approximately $16.41 billion before rising slightly again in 2024 to about $16.71 billion. This pattern may reflect strategic adjustments in asset deployment or capital investment decisions.
Economic Profit
The economic profit exhibited volatility throughout the period. Starting negative in 2020 at around -$109 million, it swung to a positive $15.75 million in 2021, then fell back to a negative $68.3 million in 2022. The figure approached breakeven in 2023 and surged significantly to a positive $382 million in 2024. This trajectory indicates fluctuating value creation relative to capital costs, with marked improvement in the most recent year.

Net Operating Profit after Taxes (NOPAT)

Sherwin-Williams Co., NOPAT calculation

US$ in thousands

Microsoft Excel
12 months ended: Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Net income
Deferred income tax expense (benefit)1
Increase (decrease) in allowance for current expected credit losses2
Increase (decrease) in LIFO reserve3
Increase (decrease) in accrual for product warranty claims4
Increase (decrease) in restructuring Plan5
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: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 Elimination of deferred tax expense. See details »

2 Addition of increase (decrease) in allowance for current expected credit losses.

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

4 Addition of increase (decrease) in accrual for product warranty claims.

5 Addition of increase (decrease) in restructuring Plan.

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

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

8 2024 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 2024 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 Trend Analysis
The net income shows a fluctuating yet overall upward trend over the five-year period. Beginning in 2020 at approximately 2.03 billion US dollars, there is a noticeable decline in 2021 to about 1.86 billion US dollars. However, this decline appears temporary as net income recovers in 2022 to just over 2.02 billion US dollars. The upward trajectory continues more strongly in the subsequent years, with net income rising to nearly 2.39 billion in 2023 and further to approximately 2.68 billion in 2024. These figures suggest improving profitability and potential operational efficiency gains or favorable market conditions beginning in 2022 and sustaining growth through 2024.
Net Operating Profit After Taxes (NOPAT) Analysis
NOPAT exhibits a consistent and steady increase throughout the five-year span. Starting from about 2.19 billion US dollars in 2020, it increases each year without decline, reaching around 2.36 billion in 2021, then 2.48 billion in 2022, 2.51 billion in 2023, and culminating at nearly 2.96 billion in 2024. This steady growth indicates progressively efficient core operations and suggests successful management of operating expenses and taxes. The more pronounced increase in later years aligns with the increasing net income, reinforcing the positive operational and financial performance trend.
Comparative Insights
While net income experienced a dip in 2021, the continual growth of NOPAT during this period underscores that the core operational profitability remained robust, indicating that the net income downturn may have resulted from non-operational factors or extraordinary items. The consistent rise in NOPAT emphasizes improved operational effectiveness, which appears to translate into increasing net income from 2022 onwards. Overall, the financial data reflect strengthening company profitability and operational efficiency, particularly evident from 2022 through 2024.

Cash Operating Taxes

Sherwin-Williams Co., cash operating taxes calculation

US$ in thousands

Microsoft Excel
12 months ended: Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Provisions 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: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).


The analysis of the financial data reveals significant trends relating to the provisions for income taxes and cash operating taxes over the five-year period from 2020 to 2024.

Provisions for Income Taxes
The provisions for income taxes exhibited notable fluctuations throughout the years. Starting at 488,800 thousand US dollars in 2020, there was a decrease in 2021 to 384,200 thousand US dollars, representing a drop of approximately 21.4%. However, this was followed by a substantial increase in 2022, reaching 553,000 thousand US dollars, which is roughly a 44% rise from the previous year. The upward trend continued into 2023 and 2024, with values rising to 721,100 and 770,400 thousand US dollars respectively. Between 2022 and 2024, the provisions grew by about 39.3%, indicating increasing tax liabilities or adjustments potentially tied to revenue or profit growth.
Cash Operating Taxes
Cash operating taxes displayed a similar upward trajectory, despite some fluctuations. The value started at 717,833 thousand US dollars in 2020 and decreased in 2021 to 545,605 thousand US dollars, a reduction of approximately 24%. In 2022, cash operating taxes increased sharply to 791,620 thousand US dollars, exceeding the 2020 level by roughly 10.3%. This growth continued, with values rising to 908,014 in 2023 and 948,147 thousand US dollars in 2024. From 2022 to 2024, there was an incremental increase of around 19.8%, reflecting higher tax payments possibly associated with improved operational results or changes in tax regulations.

Overall, both provisions for income taxes and cash operating taxes show a pattern of initial decline between 2020 and 2021, followed by a consistent and significant increase through 2024. This suggests a possible recovery or expansion phase after 2021, with increasing taxable income or shifts in tax policies impacting the tax expenses.


Invested Capital

Sherwin-Williams Co., invested capital calculation (financing approach)

US$ in thousands

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Short-term borrowings
Current portion of long-term debt
Current portion of finance lease liabilities
Long-term debt, excluding current portion
Long-term finance lease liabilities, excluding current portion
Operating lease liability1
Total reported debt & leases
Shareholders’ equity
Net deferred tax (assets) liabilities2
Allowance for current expected credit losses3
Excess of FIFO over LIFO4
Accrual for product warranty claims5
Restructuring Plan6
Equity equivalents7
Accumulated other comprehensive (income) loss, net of tax8
Adjusted shareholders’ equity
Construction in progress9
Invested capital

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-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 accrual for product warranty claims.

6 Addition of restructuring Plan.

7 Addition of equity equivalents to shareholders’ equity.

8 Removal of accumulated other comprehensive income.

9 Subtraction of construction in progress.


Total reported debt & leases
The total reported debt and leases have generally increased over the years, starting from approximately $10.11 billion in 2020 and reaching about $12.10 billion by 2024. Notably, there was a steady rise from 2020 to 2022, peaking at around $12.51 billion. Following this peak, a slight decrease was observed in 2023, with a minor uptick again in 2024. This pattern suggests a tendency toward increasing leverage, with some adjustments made after 2022.
Shareholders’ equity
Shareholders’ equity exhibited volatility during the period analyzed. It decreased markedly from approximately $3.61 billion in 2020 to $2.44 billion in 2021, indicating a significant reduction in net assets. However, from 2021 onwards, equity increased steadily, rising to about $4.05 billion by 2024. This recovery and growth imply a restoration of financial strength and potentially improved profitability or capital infusion after the initial decline.
Invested capital
The invested capital demonstrated an overall upward trend, increasing from around $15.49 billion in 2020 to approximately $16.71 billion in 2024. There was a peak in 2022 at $17.35 billion, followed by a decline in 2023, and a slight recovery in 2024. The fluctuations in invested capital reflect changes in the company's operational investments and financing structure, consistent with the movements seen in debt and equity during the same periods.

Cost of Capital

Sherwin-Williams Co., cost of capital calculations

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

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

1 US$ in thousands

2 Equity. See details »

3 Debt and finance lease liabilities. See details »

4 Operating lease liability. See details »

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

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

1 US$ in thousands

2 Equity. See details »

3 Debt and finance lease liabilities. See details »

4 Operating lease liability. See details »

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

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

1 US$ in thousands

2 Equity. See details »

3 Debt and finance lease liabilities. See details »

4 Operating lease liability. See details »

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

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

1 US$ in thousands

2 Equity. See details »

3 Debt and finance lease liabilities. See details »

4 Operating lease liability. See details »

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

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

1 US$ in thousands

2 Equity. See details »

3 Debt and finance lease liabilities. See details »

4 Operating lease liability. See details »


Economic Spread Ratio

Sherwin-Williams Co., economic spread ratio calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in thousands)
Economic profit1
Invested capital2
Performance Ratio
Economic spread ratio3
Benchmarks
Economic Spread Ratio, Competitors4
Linde plc

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 Economic profit. See details »

2 Invested capital. See details »

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

4 Click competitor name to see calculations.


The financial data reveals notable fluctuations across the examined periods, reflecting variability in the company's economic performance.

Economic Profit
Economic profit exhibited significant volatility over the years. Initially, there was a substantial negative figure at the end of 2020, indicating a loss of economic value. This shifted to a positive value in 2021, signaling an improvement. However, the trend reversed again in 2022 with another negative economic profit, albeit less severe compared to 2020. The years 2023 and 2024 show a remarkable recovery, culminating in a substantial positive economic profit by the end of 2024, suggesting enhanced profitability and value creation.
Invested Capital
Invested capital demonstrated a general upward trend over the five years. Starting from approximately 15.5 billion USD at the end of 2020, it increased steadily to over 17.3 billion USD by the end of 2022. Despite a minor decrease in 2023, the invested capital resumed growth in 2024, reaching around 16.7 billion USD. This pattern indicates ongoing capital deployment with some variability, potentially reflecting strategic investments or asset management decisions.
Economic Spread Ratio
The economic spread ratio, which measures returns relative to the cost of capital, fluctuated closely around zero in the initial years. It started with a negative value in 2020, improved slightly to a positive rate in 2021, declined again in 2022, and returned to a neutral position in 2023. In 2024, there was a notable increase to 2.29%, indicating a stronger spread and suggesting that the returns on invested capital significantly exceeded the cost of capital during this final period.

Overall, the data reflects challenges and recoveries in economic profitability, with invested capital gradually expanding. The culmination in an improved economic spread ratio and positive economic profit in 2024 illustrates a strengthening in financial performance and efficient capital utilization towards the end of the timeframe.


Economic Profit Margin

Sherwin-Williams Co., economic profit margin calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in thousands)
Economic profit1
Net sales
Performance Ratio
Economic profit margin2
Benchmarks
Economic Profit Margin, Competitors3
Linde plc

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 Economic profit. See details »

2 2024 Calculation
Economic profit margin = 100 × Economic profit ÷ Net sales
= 100 × ÷ =

3 Click competitor name to see calculations.


Economic profit
Economic profit showed significant volatility over the observed periods. In 2020, the figure was deeply negative at -109,045 thousand US dollars, indicating substantial economic losses. It improved sharply in 2021 to a positive 15,750 thousand US dollars, reflecting a turnaround. However, this gain was short-lived as economic profit declined again in 2022 to -68,335 thousand US dollars. In 2023, the economic profit returned to near zero at 441 thousand US dollars, suggesting stabilization. The most notable increase occurred in 2024, with economic profit rising dramatically to 382,401 thousand US dollars, indicating a substantial enhancement in value creation during the year.
Net sales
Net sales exhibited a consistent upward trend throughout the five-year period. Starting from approximately 18.36 billion US dollars in 2020, sales increased each year: to 19.94 billion in 2021, 22.15 billion in 2022, 23.05 billion in 2023, and marginally higher to 23.10 billion in 2024. The steady growth suggests a stable expansion in the company's revenue-generating activities, although the growth rate slightly decelerated in the final year.
Economic profit margin
The economic profit margin followed a pattern closely aligned with economic profit developments. It started from a negative margin of -0.59% in 2020, turned positive at 0.08% in 2021, but dropped back into negative territory at -0.31% in 2022. In 2023, the margin improved to break even at 0%, and then rose notably to 1.66% in 2024. This progression illustrates an overall recovery in profitability relative to sales, with the highest margin recorded in the final period, correlating with the surge in economic profit.