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.

Analysis of Solvency Ratios

Microsoft Excel

Paying user 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

Solvency Ratios (Summary)

Sherwin-Williams Co., solvency ratios

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
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
Fixed charge coverage

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).

Solvency ratio Description The company
Debt to equity ratio A solvency ratio calculated as total debt divided by total shareholders’ equity. Sherwin-Williams Co. debt to equity ratio deteriorated from 2019 to 2020 and from 2020 to 2021.
Debt to equity ratio (including operating lease liability) A solvency ratio calculated as total debt (including operating lease liability) divided by total shareholders’ equity. Sherwin-Williams Co. debt to equity ratio (including operating lease liability) deteriorated from 2019 to 2020 and from 2020 to 2021.
Debt to capital ratio A solvency ratio calculated as total debt divided by total debt plus shareholders’ equity. Sherwin-Williams Co. debt to capital ratio deteriorated from 2019 to 2020 and from 2020 to 2021.
Debt to capital ratio (including operating lease liability) 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. debt to capital ratio (including operating lease liability) deteriorated from 2019 to 2020 and from 2020 to 2021.
Debt to assets ratio A solvency ratio calculated as total debt divided by total assets. Sherwin-Williams Co. debt to assets ratio improved from 2019 to 2020 but then deteriorated significantly from 2020 to 2021.
Debt to assets ratio (including operating lease liability) A solvency ratio calculated as total debt (including operating lease liability) divided by total assets. Sherwin-Williams Co. debt to assets ratio (including operating lease liability) improved from 2019 to 2020 but then deteriorated significantly from 2020 to 2021.
Financial leverage ratio A solvency ratio calculated as total assets divided by total shareholders’ equity. Sherwin-Williams Co. financial leverage ratio increased from 2019 to 2020 and from 2020 to 2021.

Solvency ratio Description The company
Interest coverage ratio A solvency ratio calculated as EBIT divided by interest payments. Sherwin-Williams Co. interest coverage ratio improved from 2019 to 2020 but then slightly deteriorated from 2020 to 2021.
Fixed charge coverage ratio A solvency ratio calculated as earnings before fixed charges and tax divided by fixed charges. Sherwin-Williams Co. fixed charge coverage ratio improved from 2019 to 2020 but then slightly deteriorated from 2020 to 2021 not reaching 2019 level.

Debt to Equity

Sherwin-Williams Co., debt to equity calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
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
Benchmarks
Debt to Equity, Competitors2
Linde plc
Debt to Equity, Industry
Materials

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 2021 Calculation
Debt to equity = Total debt ÷ Shareholders’ equity
= ÷ =

2 Click competitor name to see calculations.

Solvency ratio Description The company
Debt to equity ratio A solvency ratio calculated as total debt divided by total shareholders’ equity. Sherwin-Williams Co. debt to equity ratio deteriorated from 2019 to 2020 and from 2020 to 2021.

Debt to Equity (including Operating Lease Liability)

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

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
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
Benchmarks
Debt to Equity (including Operating Lease Liability), Competitors2
Linde plc
Debt to Equity (including Operating Lease Liability), Industry
Materials

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 2021 Calculation
Debt to equity (including operating lease liability) = Total debt (including operating lease liability) ÷ Shareholders’ equity
= ÷ =

2 Click competitor name to see calculations.

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

Debt to Capital

Sherwin-Williams Co., debt to capital calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
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
Benchmarks
Debt to Capital, Competitors2
Linde plc
Debt to Capital, Industry
Materials

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 2021 Calculation
Debt to capital = Total debt ÷ Total capital
= ÷ =

2 Click competitor name to see calculations.

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. debt to capital ratio deteriorated from 2019 to 2020 and from 2020 to 2021.

Debt to Capital (including Operating Lease Liability)

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

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
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
Benchmarks
Debt to Capital (including Operating Lease Liability), Competitors2
Linde plc
Debt to Capital (including Operating Lease Liability), Industry
Materials

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 2021 Calculation
Debt to capital (including operating lease liability) = Total debt (including operating lease liability) ÷ Total capital (including operating lease liability)
= ÷ =

2 Click competitor name to see calculations.

Solvency ratio Description The company
Debt to capital ratio (including operating lease liability) 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. debt to capital ratio (including operating lease liability) deteriorated from 2019 to 2020 and from 2020 to 2021.

Debt to Assets

Sherwin-Williams Co., debt to assets calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
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
Benchmarks
Debt to Assets, Competitors2
Linde plc
Debt to Assets, Industry
Materials

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 2021 Calculation
Debt to assets = Total debt ÷ Total assets
= ÷ =

2 Click competitor name to see calculations.

Solvency ratio Description The company
Debt to assets ratio A solvency ratio calculated as total debt divided by total assets. Sherwin-Williams Co. debt to assets ratio improved from 2019 to 2020 but then deteriorated significantly from 2020 to 2021.

Debt to Assets (including Operating Lease Liability)

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

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
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
Benchmarks
Debt to Assets (including Operating Lease Liability), Competitors2
Linde plc
Debt to Assets (including Operating Lease Liability), Industry
Materials

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 2021 Calculation
Debt to assets (including operating lease liability) = Total debt (including operating lease liability) ÷ Total assets
= ÷ =

2 Click competitor name to see calculations.

Solvency ratio Description The company
Debt to assets ratio (including operating lease liability) A solvency ratio calculated as total debt (including operating lease liability) divided by total assets. Sherwin-Williams Co. debt to assets ratio (including operating lease liability) improved from 2019 to 2020 but then deteriorated significantly from 2020 to 2021.

Financial Leverage

Sherwin-Williams Co., financial leverage calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Total assets
Shareholders’ equity
Solvency Ratio
Financial leverage1
Benchmarks
Financial Leverage, Competitors2
Linde plc
Financial Leverage, Industry
Materials

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 2021 Calculation
Financial leverage = Total assets ÷ Shareholders’ equity
= ÷ =

2 Click competitor name to see calculations.

Solvency ratio Description The company
Financial leverage ratio A solvency ratio calculated as total assets divided by total shareholders’ equity. Sherwin-Williams Co. financial leverage ratio increased from 2019 to 2020 and from 2020 to 2021.

Interest Coverage

Sherwin-Williams Co., interest coverage calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
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
Benchmarks
Interest Coverage, Competitors2
Linde plc
Interest Coverage, Industry
Materials

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 2021 Calculation
Interest coverage = EBIT ÷ Interest expense
= ÷ =

2 Click competitor name to see calculations.

Solvency ratio Description The company
Interest coverage ratio A solvency ratio calculated as EBIT divided by interest payments. Sherwin-Williams Co. interest coverage ratio improved from 2019 to 2020 but then slightly deteriorated from 2020 to 2021.

Fixed Charge Coverage

Sherwin-Williams Co., fixed charge coverage calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
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)
Add: Operating lease cost
Earnings before fixed charges and tax
 
Interest expense
Operating lease cost
Fixed charges
Solvency Ratio
Fixed charge coverage1
Benchmarks
Fixed Charge Coverage, Competitors2
Linde plc
Fixed Charge Coverage, Industry
Materials

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 2021 Calculation
Fixed charge coverage = Earnings before fixed charges and tax ÷ Fixed charges
= ÷ =

2 Click competitor name to see calculations.

Solvency ratio Description The company
Fixed charge coverage ratio A solvency ratio calculated as earnings before fixed charges and tax divided by fixed charges. Sherwin-Williams Co. fixed charge coverage ratio improved from 2019 to 2020 but then slightly deteriorated from 2020 to 2021 not reaching 2019 level.