Stock Analysis on Net

Sherwin-Williams Co. (NYSE:SHW)

$24.99

Adjustments to Financial Statements

Microsoft Excel

Paying user area


We accept:

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

Adjustments to Current Assets

Sherwin-Williams Co., adjusted current assets

US$ in thousands

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
As Reported
Current assets
Adjustments
Add: Allowance for current expected credit losses
Add: Excess of FIFO over LIFO1
After Adjustment
Adjusted current assets

Based on: 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), 10-K (reporting date: 2019-12-31).

1 Excess of FIFO over LIFO. See details »


Adjustments to Total Assets

Sherwin-Williams Co., adjusted total assets

US$ in thousands

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
As Reported
Total assets
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1
Add: Allowance for current expected credit losses
Add: Excess of FIFO over LIFO2
Less: Deferred tax assets3
After Adjustment
Adjusted total assets

Based on: 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), 10-K (reporting date: 2019-12-31).

1 Operating lease right-of-use asset (before adoption of FASB Topic 842). See details »

2 Excess of FIFO over LIFO. See details »

3 Deferred tax assets. See details »


Adjustments to Total Liabilities

Sherwin-Williams Co., adjusted total liabilities

US$ in thousands

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
As Reported
Total liabilities
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1
Less: Deferred tax liabilities2
Less: Accrual for product warranty claims
Less: Restructuring Plan
After Adjustment
Adjusted total liabilities

Based on: 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), 10-K (reporting date: 2019-12-31).

1 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Deferred tax liabilities. See details »


Adjustments to Stockholders’ Equity

Sherwin-Williams Co., adjusted shareholders’ equity

US$ in thousands

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
As Reported
Shareholders’ equity
Adjustments
Less: Net deferred tax assets (liabilities)1
Add: Allowance for current expected credit losses
Add: Excess of FIFO over LIFO2
Add: Accrual for product warranty claims
Add: Restructuring Plan
After Adjustment
Adjusted shareholders’ equity

Based on: 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), 10-K (reporting date: 2019-12-31).

1 Net deferred tax assets (liabilities). See details »

2 Excess of FIFO over LIFO. See details »


Adjustments to Capitalization Table

Sherwin-Williams Co., adjusted capitalization table

US$ in thousands

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
As Reported
Short-term borrowings
Current portion of long-term debt
Long-term debt, excluding current portion
Total reported debt
Shareholders’ equity
Total reported capital
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1
Add: Current portion of operating lease liabilities2
Add: Long-term operating lease liabilities, excluding current portion3
Adjusted total debt
Adjustments to Equity
Less: Net deferred tax assets (liabilities)4
Add: Allowance for current expected credit losses
Add: Excess of FIFO over LIFO5
Add: Accrual for product warranty claims
Add: Restructuring Plan
Adjusted shareholders’ equity
After Adjustment
Adjusted total capital

Based on: 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), 10-K (reporting date: 2019-12-31).

1 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Current portion of operating lease liabilities. See details »

3 Long-term operating lease liabilities, excluding current portion. See details »

4 Net deferred tax assets (liabilities). See details »

5 Excess of FIFO over LIFO. See details »


Adjustments to Reported Income

Sherwin-Williams Co., adjusted net income

US$ in thousands

Microsoft Excel
12 months ended: Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
As Reported
Net income
Adjustments
Add: Deferred income tax expense (benefit)1
Add: Increase (decrease) in allowance for current expected credit losses
Add: Increase (decrease) in LIFO reserve2
Add: Increase (decrease) in accrual for product warranty claims
Add: Increase (decrease) in restructuring Plan
Add: Other comprehensive income (loss), net of tax
After Adjustment
Adjusted net income

Based on: 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), 10-K (reporting date: 2019-12-31).

1 Deferred income tax expense (benefit). See details »

2 Increase (decrease) in LIFO reserve. See details »