Stock Analysis on Net

Sherwin-Williams Co. (NYSE:SHW)

$22.49

This company has been moved to the archive! The financial data has not been updated since July 27, 2022.

Adjustments to Financial Statements

Microsoft Excel

Paying users 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 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, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
As Reported
Current assets
Adjustments
Add: Allowance for doubtful accounts
Add: Excess of FIFO over LIFO1
After Adjustment
Adjusted current assets

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 Excess of FIFO over LIFO. See details »


Adjustments to Total Assets

Sherwin-Williams Co., adjusted total assets

US$ in thousands

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

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 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, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
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
After Adjustment
Adjusted total liabilities

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 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, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
As Reported
Shareholders’ equity
Adjustments
Less: Net deferred tax assets (liabilities)1
Add: Allowance for doubtful accounts
Add: Excess of FIFO over LIFO2
Add: Accrual for product warranty claims
After Adjustment
Adjusted shareholders’ equity

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 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, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
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 doubtful accounts
Add: Excess of FIFO over LIFO5
Add: Accrual for product warranty claims
Adjusted shareholders’ equity
After Adjustment
Adjusted total 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 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, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
As Reported
Net income
Adjustments
Add: Deferred income tax expense (benefit)1
Add: Increase (decrease) in allowance for doubtful accounts
Add: Increase (decrease) in LIFO reserve2
Add: Increase (decrease) in accrual for product warranty claims
Less: Net loss from discontinued operations
Add: Other comprehensive income (loss), net of tax
After Adjustment
Adjusted net income

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 Deferred income tax expense (benefit). See details »

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