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
Unlock

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

Sherwin-Williams Co. pages available today for free:

Analysis of Solvency Ratios
Quarterly Data

Beginner level

Solvency ratios also known as long-term debt ratios measure a company’s ability to meet long-term obligations.

Solvency Ratios (Summary)

Sherwin-Williams Co., solvency ratios (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Debt Ratios
Debt to equity
Debt to equity (including operating lease liability)
Debt to capital
Debt to capital (including operating lease liability)
Debt to assets
Debt to assets (including operating lease liability)
Financial leverage
Coverage Ratios
Interest coverage

Based on: 10-Q (filing date: 2020-10-27), 10-Q (filing date: 2020-07-28), 10-Q (filing date: 2020-04-29), 10-K (filing date: 2020-02-21), 10-Q (filing date: 2019-10-22), 10-Q (filing date: 2019-07-24), 10-Q (filing date: 2019-04-25), 10-K (filing date: 2019-02-22), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-02-23), 10-Q (filing date: 2017-10-25), 10-Q (filing date: 2017-07-26), 10-Q (filing date: 2017-04-21), 10-K (filing date: 2017-02-22), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-02-24), 10-Q (filing date: 2015-10-29), 10-Q (filing date: 2015-07-22), 10-Q (filing date: 2015-04-22).

Solvency ratio Description The company
Debt to equity ratio A solvency ratio calculated as total debt divided by total shareholders’ equity. Sherwin-Williams Co.’s debt to equity ratio improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.
Debt to equity (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total shareholders’ equity. Sherwin-Williams Co.’s debt to equity ratio (including operating lease liability) improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.
Debt to capital ratio A solvency ratio calculated as total debt divided by total debt plus shareholders’ equity. Sherwin-Williams Co.’s debt to capital ratio improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.
Debt to capital (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total debt (including operating lease liability) plus shareholders’ equity. Sherwin-Williams Co.’s debt to capital ratio (including operating lease liability) improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.
Debt to assets ratio A solvency ratio calculated as total debt divided by total assets. Sherwin-Williams Co.’s debt to assets ratio improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.
Debt to assets (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total assets. Sherwin-Williams Co.’s debt to assets ratio (including operating lease liability) improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.
Financial leverage ratio A solvency ratio calculated as total assets divided by total shareholders’ equity. Sherwin-Williams Co.’s financial leverage ratio decreased from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.
Solvency ratio Description The company
Interest coverage ratio A solvency ratio calculated as EBIT divided by interest payments. Sherwin-Williams Co.’s interest coverage ratio improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.

Debt to Equity

Sherwin-Williams Co., debt to equity calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Selected Financial Data (US$ in thousands)
Short-term borrowings
Current portion of long-term debt
Long-term debt, excluding current portion
Total debt
 
Shareholders’ equity
Solvency Ratio
Debt to equity1

Based on: 10-Q (filing date: 2020-10-27), 10-Q (filing date: 2020-07-28), 10-Q (filing date: 2020-04-29), 10-K (filing date: 2020-02-21), 10-Q (filing date: 2019-10-22), 10-Q (filing date: 2019-07-24), 10-Q (filing date: 2019-04-25), 10-K (filing date: 2019-02-22), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-02-23), 10-Q (filing date: 2017-10-25), 10-Q (filing date: 2017-07-26), 10-Q (filing date: 2017-04-21), 10-K (filing date: 2017-02-22), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-02-24), 10-Q (filing date: 2015-10-29), 10-Q (filing date: 2015-07-22), 10-Q (filing date: 2015-04-22).

1 Q3 2020 Calculation
Debt to equity = Total debt ÷ Shareholders’ equity
= ÷ =

Solvency ratio Description The company
Debt to equity ratio A solvency ratio calculated as total debt divided by total shareholders’ equity. Sherwin-Williams Co.’s debt to equity ratio improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.

Debt to Equity (including Operating Lease Liability)

Sherwin-Williams Co., debt to equity (including operating lease liability) calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Selected Financial Data (US$ in thousands)
Short-term borrowings
Current portion of long-term debt
Long-term debt, excluding current portion
Total debt
Current portion of operating lease liabilities
Long-term operating lease liabilities, excluding current portion
Total debt (including operating lease liability)
 
Shareholders’ equity
Solvency Ratio
Debt to equity (including operating lease liability)1

Based on: 10-Q (filing date: 2020-10-27), 10-Q (filing date: 2020-07-28), 10-Q (filing date: 2020-04-29), 10-K (filing date: 2020-02-21), 10-Q (filing date: 2019-10-22), 10-Q (filing date: 2019-07-24), 10-Q (filing date: 2019-04-25), 10-K (filing date: 2019-02-22), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-02-23), 10-Q (filing date: 2017-10-25), 10-Q (filing date: 2017-07-26), 10-Q (filing date: 2017-04-21), 10-K (filing date: 2017-02-22), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-02-24), 10-Q (filing date: 2015-10-29), 10-Q (filing date: 2015-07-22), 10-Q (filing date: 2015-04-22).

1 Q3 2020 Calculation
Debt to equity (including operating lease liability) = Total debt (including operating lease liability) ÷ Shareholders’ equity
= ÷ =

Solvency ratio Description The company
Debt to equity (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total shareholders’ equity. Sherwin-Williams Co.’s debt to equity ratio (including operating lease liability) improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.

Debt to Capital

Sherwin-Williams Co., debt to capital calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Selected Financial Data (US$ in thousands)
Short-term borrowings
Current portion of long-term debt
Long-term debt, excluding current portion
Total debt
Shareholders’ equity
Total capital
Solvency Ratio
Debt to capital1

Based on: 10-Q (filing date: 2020-10-27), 10-Q (filing date: 2020-07-28), 10-Q (filing date: 2020-04-29), 10-K (filing date: 2020-02-21), 10-Q (filing date: 2019-10-22), 10-Q (filing date: 2019-07-24), 10-Q (filing date: 2019-04-25), 10-K (filing date: 2019-02-22), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-02-23), 10-Q (filing date: 2017-10-25), 10-Q (filing date: 2017-07-26), 10-Q (filing date: 2017-04-21), 10-K (filing date: 2017-02-22), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-02-24), 10-Q (filing date: 2015-10-29), 10-Q (filing date: 2015-07-22), 10-Q (filing date: 2015-04-22).

1 Q3 2020 Calculation
Debt to capital = Total debt ÷ Total capital
= ÷ =

Solvency ratio Description The company
Debt to capital ratio A solvency ratio calculated as total debt divided by total debt plus shareholders’ equity. Sherwin-Williams Co.’s debt to capital ratio improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.

Debt to Capital (including Operating Lease Liability)

Sherwin-Williams Co., debt to capital (including operating lease liability) calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Selected Financial Data (US$ in thousands)
Short-term borrowings
Current portion of long-term debt
Long-term debt, excluding current portion
Total debt
Current portion of operating lease liabilities
Long-term operating lease liabilities, excluding current portion
Total debt (including operating lease liability)
Shareholders’ equity
Total capital (including operating lease liability)
Solvency Ratio
Debt to capital (including operating lease liability)1

Based on: 10-Q (filing date: 2020-10-27), 10-Q (filing date: 2020-07-28), 10-Q (filing date: 2020-04-29), 10-K (filing date: 2020-02-21), 10-Q (filing date: 2019-10-22), 10-Q (filing date: 2019-07-24), 10-Q (filing date: 2019-04-25), 10-K (filing date: 2019-02-22), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-02-23), 10-Q (filing date: 2017-10-25), 10-Q (filing date: 2017-07-26), 10-Q (filing date: 2017-04-21), 10-K (filing date: 2017-02-22), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-02-24), 10-Q (filing date: 2015-10-29), 10-Q (filing date: 2015-07-22), 10-Q (filing date: 2015-04-22).

1 Q3 2020 Calculation
Debt to capital (including operating lease liability) = Total debt (including operating lease liability) ÷ Total capital (including operating lease liability)
= ÷ =

Solvency ratio Description The company
Debt to capital (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total debt (including operating lease liability) plus shareholders’ equity. Sherwin-Williams Co.’s debt to capital ratio (including operating lease liability) improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.

Debt to Assets

Sherwin-Williams Co., debt to assets calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Selected Financial Data (US$ in thousands)
Short-term borrowings
Current portion of long-term debt
Long-term debt, excluding current portion
Total debt
 
Total assets
Solvency Ratio
Debt to assets1

Based on: 10-Q (filing date: 2020-10-27), 10-Q (filing date: 2020-07-28), 10-Q (filing date: 2020-04-29), 10-K (filing date: 2020-02-21), 10-Q (filing date: 2019-10-22), 10-Q (filing date: 2019-07-24), 10-Q (filing date: 2019-04-25), 10-K (filing date: 2019-02-22), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-02-23), 10-Q (filing date: 2017-10-25), 10-Q (filing date: 2017-07-26), 10-Q (filing date: 2017-04-21), 10-K (filing date: 2017-02-22), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-02-24), 10-Q (filing date: 2015-10-29), 10-Q (filing date: 2015-07-22), 10-Q (filing date: 2015-04-22).

1 Q3 2020 Calculation
Debt to assets = Total debt ÷ Total assets
= ÷ =

Solvency ratio Description The company
Debt to assets ratio A solvency ratio calculated as total debt divided by total assets. Sherwin-Williams Co.’s debt to assets ratio improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.

Debt to Assets (including Operating Lease Liability)

Sherwin-Williams Co., debt to assets (including operating lease liability) calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Selected Financial Data (US$ in thousands)
Short-term borrowings
Current portion of long-term debt
Long-term debt, excluding current portion
Total debt
Current portion of operating lease liabilities
Long-term operating lease liabilities, excluding current portion
Total debt (including operating lease liability)
 
Total assets
Solvency Ratio
Debt to assets (including operating lease liability)1

Based on: 10-Q (filing date: 2020-10-27), 10-Q (filing date: 2020-07-28), 10-Q (filing date: 2020-04-29), 10-K (filing date: 2020-02-21), 10-Q (filing date: 2019-10-22), 10-Q (filing date: 2019-07-24), 10-Q (filing date: 2019-04-25), 10-K (filing date: 2019-02-22), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-02-23), 10-Q (filing date: 2017-10-25), 10-Q (filing date: 2017-07-26), 10-Q (filing date: 2017-04-21), 10-K (filing date: 2017-02-22), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-02-24), 10-Q (filing date: 2015-10-29), 10-Q (filing date: 2015-07-22), 10-Q (filing date: 2015-04-22).

1 Q3 2020 Calculation
Debt to assets (including operating lease liability) = Total debt (including operating lease liability) ÷ Total assets
= ÷ =

Solvency ratio Description The company
Debt to assets (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total assets. Sherwin-Williams Co.’s debt to assets ratio (including operating lease liability) improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.

Financial Leverage

Sherwin-Williams Co., financial leverage calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Selected Financial Data (US$ in thousands)
Total assets
Shareholders’ equity
Solvency Ratio
Financial leverage1

Based on: 10-Q (filing date: 2020-10-27), 10-Q (filing date: 2020-07-28), 10-Q (filing date: 2020-04-29), 10-K (filing date: 2020-02-21), 10-Q (filing date: 2019-10-22), 10-Q (filing date: 2019-07-24), 10-Q (filing date: 2019-04-25), 10-K (filing date: 2019-02-22), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-02-23), 10-Q (filing date: 2017-10-25), 10-Q (filing date: 2017-07-26), 10-Q (filing date: 2017-04-21), 10-K (filing date: 2017-02-22), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-02-24), 10-Q (filing date: 2015-10-29), 10-Q (filing date: 2015-07-22), 10-Q (filing date: 2015-04-22).

1 Q3 2020 Calculation
Financial leverage = Total assets ÷ Shareholders’ equity
= ÷ =

Solvency ratio Description The company
Financial leverage ratio A solvency ratio calculated as total assets divided by total shareholders’ equity. Sherwin-Williams Co.’s financial leverage ratio decreased from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.

Interest Coverage

Sherwin-Williams Co., interest coverage calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Selected Financial Data (US$ in thousands)
Net income
Less: Net loss from discontinued operations
Add: Income tax expense
Add: Interest expense
Earnings before interest and tax (EBIT)
Solvency Ratio
Interest coverage1

Based on: 10-Q (filing date: 2020-10-27), 10-Q (filing date: 2020-07-28), 10-Q (filing date: 2020-04-29), 10-K (filing date: 2020-02-21), 10-Q (filing date: 2019-10-22), 10-Q (filing date: 2019-07-24), 10-Q (filing date: 2019-04-25), 10-K (filing date: 2019-02-22), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-02-23), 10-Q (filing date: 2017-10-25), 10-Q (filing date: 2017-07-26), 10-Q (filing date: 2017-04-21), 10-K (filing date: 2017-02-22), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-02-24), 10-Q (filing date: 2015-10-29), 10-Q (filing date: 2015-07-22), 10-Q (filing date: 2015-04-22).

1 Q3 2020 Calculation
Interest coverage = (EBITQ3 2020 + EBITQ2 2020 + EBITQ1 2020 + EBITQ4 2019) ÷ (Interest expenseQ3 2020 + Interest expenseQ2 2020 + Interest expenseQ1 2020 + Interest expenseQ4 2019)
= ( + + + ) ÷ ( + + + ) =

Solvency ratio Description The company
Interest coverage ratio A solvency ratio calculated as EBIT divided by interest payments. Sherwin-Williams Co.’s interest coverage ratio improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.