Stock Analysis on Net
Stock Analysis on Net
Microsoft Excel LibreOffice Calc

Sherwin-Williams Co. (NYSE:SHW)

Paying users zone. Data is hidden behind: .

  • Get 1-month access to Sherwin-Williams Co. for $15.99, or

  • get full access to the entire website for at least 3 months from $49.99.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Apple Pay Google Pay
Verified by Visa MasterCard SecureCode American Express SafeKey

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

Adjustments to Financial Statements

Advanced level


Adjustments to Current Assets

Sherwin-Williams Co., adjusted current assets

US$ in thousands

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
As Reported
Current assets
Adjustments
Add: Allowance for doubtful accounts
Add: Excess of FIFO over LIFO1
Less: Deferred income taxes2
After Adjustment
Adjusted current assets

Based on: 10-K (filing date: 2020-02-21), 10-K (filing date: 2019-02-22), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-22), 10-K (filing date: 2016-02-24).

1 Excess of FIFO over LIFO. See details »

2 Deferred income taxes. See details »


Adjustments to Total Assets

Sherwin-Williams Co., adjusted total assets

US$ in thousands

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
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 income taxes3
After Adjustment
Adjusted total assets

Based on: 10-K (filing date: 2020-02-21), 10-K (filing date: 2019-02-22), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-22), 10-K (filing date: 2016-02-24).

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 income taxes. See details »


Adjustments to Total Liabilities

Sherwin-Williams Co., adjusted total liabilities

US$ in thousands

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
As Reported
Total liabilities
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1
Less: Deferred income taxes2
Less: Accrual for product warranty claims
Less: Liabilities associated with qualified exit costs
After Adjustment
Adjusted total liabilities

Based on: 10-K (filing date: 2020-02-21), 10-K (filing date: 2019-02-22), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-22), 10-K (filing date: 2016-02-24).

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

2 Deferred income taxes. See details »


Adjustments to Stockholders’ Equity

Sherwin-Williams Co., adjusted shareholders’ equity

US$ in thousands

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
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
Add: Liabilities associated with qualified exit costs
After Adjustment
Adjusted shareholders’ equity

Based on: 10-K (filing date: 2020-02-21), 10-K (filing date: 2019-02-22), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-22), 10-K (filing date: 2016-02-24).

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 LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
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
Add: Liabilities associated with qualified exit costs
Adjusted shareholders’ equity
After Adjustment
Adjusted total capital

Based on: 10-K (filing date: 2020-02-21), 10-K (filing date: 2019-02-22), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-22), 10-K (filing date: 2016-02-24).

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 LibreOffice Calc
12 months ended: Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
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
Add: Increase (decrease) in liabilities associated with qualified exit costs
Less: Net loss from discontinued operations
Add: Other comprehensive (loss) income, net of tax
After Adjustment
Adjusted net income

Based on: 10-K (filing date: 2020-02-21), 10-K (filing date: 2019-02-22), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-22), 10-K (filing date: 2016-02-24).

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

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