Analysis of Solvency Ratios
Quarterly Data
Solvency ratios also known as long-term debt ratios measure a company ability to meet long-term obligations.
Solvency Ratios (Summary)
Sherwin-Williams Co., solvency ratios (quarterly data)
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-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 Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
| 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. debt to equity ratio (including operating lease liability) deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
| 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 Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
| 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. debt to capital ratio (including operating lease liability) deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
| Debt to assets ratio | A solvency ratio calculated as total debt divided by total assets. | Sherwin-Williams Co. debt to assets ratio deteriorated from Q4 2021 to Q1 2022 but then slightly improved from Q1 2022 to Q2 2022. |
| 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. debt to assets ratio (including operating lease liability) deteriorated from Q4 2021 to Q1 2022 but then slightly improved from Q1 2022 to Q2 2022. |
| Financial leverage ratio | A solvency ratio calculated as total assets divided by total shareholders’ equity. | Sherwin-Williams Co. financial leverage ratio increased from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
| Solvency ratio | Description | The company |
|---|---|---|
| Interest coverage ratio | A solvency ratio calculated as EBIT divided by interest payments. | Sherwin-Williams Co. interest coverage ratio deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
Debt to Equity
Sherwin-Williams Co., debt to equity calculation (quarterly data)
| Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | |||||||||||||||||||||||||||||
| Short-term borrowings | 2,012,000) | 1,739,700) | 763,500) | 709,400) | 762,100) | 818,100) | 100) | 200) | 559,500) | 1,051,500) | 204,700) | 435,699) | 808,800) | 824,833) | 328,403) | 650,134) | 650,718) | 920,010) | 633,731) | 164,133) | 51,904) | 41,909) | |||||||
| Current portion of long-term debt | 600) | 260,700) | 260,600) | 662,100) | 687,100) | 428,500) | 25,100) | 24,100) | 700) | 429,500) | 429,800) | 429,569) | 1,437,812) | 303,896) | 307,191) | 310,561) | 1,179) | 1,179) | 1,179) | 701,419) | 701,101) | 700,786) | |||||||
| Long-term debt, excluding current portion | 8,593,600) | 8,592,300) | 8,590,900) | 7,604,900) | 7,603,800) | 7,862,400) | 8,266,900) | 8,266,900) | 8,289,400) | 8,289,200) | 8,050,700) | 8,043,030) | 7,209,481) | 8,702,630) | 8,708,057) | 8,710,831) | 9,722,918) | 9,891,017) | 9,885,745) | 10,083,828) | 10,751,284) | 1,211,512) | |||||||
| Total debt | 10,606,200) | 10,592,700) | 9,615,000) | 8,976,400) | 9,053,000) | 9,109,000) | 8,292,100) | 8,291,200) | 8,849,600) | 9,770,200) | 8,685,200) | 8,908,298) | 9,456,093) | 9,831,359) | 9,343,651) | 9,671,526) | 10,374,815) | 10,812,206) | 10,520,655) | 10,949,380) | 11,504,289) | 1,954,207) | |||||||
| Shareholders’ equity | 2,224,600) | 2,234,300) | 2,437,200) | 2,690,300) | 2,840,400) | 3,078,700) | 3,610,800) | 4,207,300) | 3,869,900) | 3,289,100) | 4,123,300) | 4,022,860) | 3,747,482) | 3,460,061) | 3,730,745) | 3,974,839) | 3,747,089) | 3,690,046) | 3,692,188) | 2,740,989) | 2,391,260) | 2,065,350) | |||||||
| Solvency Ratio | |||||||||||||||||||||||||||||
| Debt to equity1 | 4.77 | 4.74 | 3.95 | 3.34 | 3.19 | 2.96 | 2.30 | 1.97 | 2.29 | 2.97 | 2.11 | 2.21 | 2.52 | 2.84 | 2.50 | 2.43 | 2.77 | 2.93 | 2.85 | 3.99 | 4.81 | 0.95 | |||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Debt to Equity, Competitors2 | |||||||||||||||||||||||||||||
| Linde plc | 0.40 | 0.38 | 0.32 | 0.38 | 0.34 | 0.34 | 0.34 | 0.39 | 0.38 | 0.38 | 0.28 | 0.27 | 0.28 | 0.28 | — | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q2 2022 Calculation
Debt to equity = Total debt ÷ Shareholders’ equity
= 10,606,200 ÷ 2,224,600 = 4.77
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 Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
Debt to Equity (including Operating Lease Liability)
Sherwin-Williams Co., debt to equity (including operating lease liability) calculation (quarterly data)
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q2 2022 Calculation
Debt to equity (including operating lease liability) = Total debt (including operating lease liability) ÷ Shareholders’ equity
= 12,507,400 ÷ 2,224,600 = 5.62
| 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. debt to equity ratio (including operating lease liability) deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
Debt to Capital
Sherwin-Williams Co., debt to capital calculation (quarterly data)
| Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | |||||||||||||||||||||||||||||
| Short-term borrowings | 2,012,000) | 1,739,700) | 763,500) | 709,400) | 762,100) | 818,100) | 100) | 200) | 559,500) | 1,051,500) | 204,700) | 435,699) | 808,800) | 824,833) | 328,403) | 650,134) | 650,718) | 920,010) | 633,731) | 164,133) | 51,904) | 41,909) | |||||||
| Current portion of long-term debt | 600) | 260,700) | 260,600) | 662,100) | 687,100) | 428,500) | 25,100) | 24,100) | 700) | 429,500) | 429,800) | 429,569) | 1,437,812) | 303,896) | 307,191) | 310,561) | 1,179) | 1,179) | 1,179) | 701,419) | 701,101) | 700,786) | |||||||
| Long-term debt, excluding current portion | 8,593,600) | 8,592,300) | 8,590,900) | 7,604,900) | 7,603,800) | 7,862,400) | 8,266,900) | 8,266,900) | 8,289,400) | 8,289,200) | 8,050,700) | 8,043,030) | 7,209,481) | 8,702,630) | 8,708,057) | 8,710,831) | 9,722,918) | 9,891,017) | 9,885,745) | 10,083,828) | 10,751,284) | 1,211,512) | |||||||
| Total debt | 10,606,200) | 10,592,700) | 9,615,000) | 8,976,400) | 9,053,000) | 9,109,000) | 8,292,100) | 8,291,200) | 8,849,600) | 9,770,200) | 8,685,200) | 8,908,298) | 9,456,093) | 9,831,359) | 9,343,651) | 9,671,526) | 10,374,815) | 10,812,206) | 10,520,655) | 10,949,380) | 11,504,289) | 1,954,207) | |||||||
| Shareholders’ equity | 2,224,600) | 2,234,300) | 2,437,200) | 2,690,300) | 2,840,400) | 3,078,700) | 3,610,800) | 4,207,300) | 3,869,900) | 3,289,100) | 4,123,300) | 4,022,860) | 3,747,482) | 3,460,061) | 3,730,745) | 3,974,839) | 3,747,089) | 3,690,046) | 3,692,188) | 2,740,989) | 2,391,260) | 2,065,350) | |||||||
| Total capital | 12,830,800) | 12,827,000) | 12,052,200) | 11,666,700) | 11,893,400) | 12,187,700) | 11,902,900) | 12,498,500) | 12,719,500) | 13,059,300) | 12,808,500) | 12,931,158) | 13,203,575) | 13,291,420) | 13,074,396) | 13,646,365) | 14,121,904) | 14,502,252) | 14,212,843) | 13,690,369) | 13,895,549) | 4,019,557) | |||||||
| Solvency Ratio | |||||||||||||||||||||||||||||
| Debt to capital1 | 0.83 | 0.83 | 0.80 | 0.77 | 0.76 | 0.75 | 0.70 | 0.66 | 0.70 | 0.75 | 0.68 | 0.69 | 0.72 | 0.74 | 0.71 | 0.71 | 0.73 | 0.75 | 0.74 | 0.80 | 0.83 | 0.49 | |||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Debt to Capital, Competitors2 | |||||||||||||||||||||||||||||
| Linde plc | 0.29 | 0.28 | 0.24 | 0.27 | 0.25 | 0.25 | 0.25 | 0.28 | 0.28 | 0.27 | 0.22 | 0.21 | 0.22 | 0.22 | — | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q2 2022 Calculation
Debt to capital = Total debt ÷ Total capital
= 10,606,200 ÷ 12,830,800 = 0.83
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 Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
Debt to Capital (including Operating Lease Liability)
Sherwin-Williams Co., debt to capital (including operating lease liability) calculation (quarterly data)
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q2 2022 Calculation
Debt to capital (including operating lease liability) = Total debt (including operating lease liability) ÷ Total capital (including operating lease liability)
= 12,507,400 ÷ 14,732,000 = 0.85
| 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. debt to capital ratio (including operating lease liability) deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
Debt to Assets
Sherwin-Williams Co., debt to assets calculation (quarterly data)
| Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | |||||||||||||||||||||||||||||
| Short-term borrowings | 2,012,000) | 1,739,700) | 763,500) | 709,400) | 762,100) | 818,100) | 100) | 200) | 559,500) | 1,051,500) | 204,700) | 435,699) | 808,800) | 824,833) | 328,403) | 650,134) | 650,718) | 920,010) | 633,731) | 164,133) | 51,904) | 41,909) | |||||||
| Current portion of long-term debt | 600) | 260,700) | 260,600) | 662,100) | 687,100) | 428,500) | 25,100) | 24,100) | 700) | 429,500) | 429,800) | 429,569) | 1,437,812) | 303,896) | 307,191) | 310,561) | 1,179) | 1,179) | 1,179) | 701,419) | 701,101) | 700,786) | |||||||
| Long-term debt, excluding current portion | 8,593,600) | 8,592,300) | 8,590,900) | 7,604,900) | 7,603,800) | 7,862,400) | 8,266,900) | 8,266,900) | 8,289,400) | 8,289,200) | 8,050,700) | 8,043,030) | 7,209,481) | 8,702,630) | 8,708,057) | 8,710,831) | 9,722,918) | 9,891,017) | 9,885,745) | 10,083,828) | 10,751,284) | 1,211,512) | |||||||
| Total debt | 10,606,200) | 10,592,700) | 9,615,000) | 8,976,400) | 9,053,000) | 9,109,000) | 8,292,100) | 8,291,200) | 8,849,600) | 9,770,200) | 8,685,200) | 8,908,298) | 9,456,093) | 9,831,359) | 9,343,651) | 9,671,526) | 10,374,815) | 10,812,206) | 10,520,655) | 10,949,380) | 11,504,289) | 1,954,207) | |||||||
| Total assets | 22,052,800) | 21,730,400) | 20,666,700) | 20,736,600) | 20,519,600) | 20,435,000) | 20,401,600) | 20,809,700) | 20,494,500) | 20,570,300) | 20,496,200) | 20,864,339) | 21,186,136) | 20,961,641) | 19,134,279) | 19,980,696) | 20,154,732) | 20,367,686) | 19,958,427) | 20,779,657) | 20,717,398) | 6,988,903) | |||||||
| Solvency Ratio | |||||||||||||||||||||||||||||
| Debt to assets1 | 0.48 | 0.49 | 0.47 | 0.43 | 0.44 | 0.45 | 0.41 | 0.40 | 0.43 | 0.47 | 0.42 | 0.43 | 0.45 | 0.47 | 0.49 | 0.48 | 0.51 | 0.53 | 0.53 | 0.53 | 0.56 | 0.28 | |||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Debt to Assets, Competitors2 | |||||||||||||||||||||||||||||
| Linde plc | 0.21 | 0.20 | 0.17 | 0.20 | 0.18 | 0.19 | 0.18 | 0.20 | 0.20 | 0.20 | 0.16 | 0.16 | 0.16 | 0.15 | — | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q2 2022 Calculation
Debt to assets = Total debt ÷ Total assets
= 10,606,200 ÷ 22,052,800 = 0.48
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 deteriorated from Q4 2021 to Q1 2022 but then slightly improved from Q1 2022 to Q2 2022. |
Debt to Assets (including Operating Lease Liability)
Sherwin-Williams Co., debt to assets (including operating lease liability) calculation (quarterly data)
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q2 2022 Calculation
Debt to assets (including operating lease liability) = Total debt (including operating lease liability) ÷ Total assets
= 12,507,400 ÷ 22,052,800 = 0.57
| 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. debt to assets ratio (including operating lease liability) deteriorated from Q4 2021 to Q1 2022 but then slightly improved from Q1 2022 to Q2 2022. |
Financial Leverage
Sherwin-Williams Co., financial leverage calculation (quarterly data)
| Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | |||||||||||||||||||||||||||||
| Total assets | 22,052,800) | 21,730,400) | 20,666,700) | 20,736,600) | 20,519,600) | 20,435,000) | 20,401,600) | 20,809,700) | 20,494,500) | 20,570,300) | 20,496,200) | 20,864,339) | 21,186,136) | 20,961,641) | 19,134,279) | 19,980,696) | 20,154,732) | 20,367,686) | 19,958,427) | 20,779,657) | 20,717,398) | 6,988,903) | |||||||
| Shareholders’ equity | 2,224,600) | 2,234,300) | 2,437,200) | 2,690,300) | 2,840,400) | 3,078,700) | 3,610,800) | 4,207,300) | 3,869,900) | 3,289,100) | 4,123,300) | 4,022,860) | 3,747,482) | 3,460,061) | 3,730,745) | 3,974,839) | 3,747,089) | 3,690,046) | 3,692,188) | 2,740,989) | 2,391,260) | 2,065,350) | |||||||
| Solvency Ratio | |||||||||||||||||||||||||||||
| Financial leverage1 | 9.91 | 9.73 | 8.48 | 7.71 | 7.22 | 6.64 | 5.65 | 4.95 | 5.30 | 6.25 | 4.97 | 5.19 | 5.65 | 6.06 | 5.13 | 5.03 | 5.38 | 5.52 | 5.41 | 7.58 | 8.66 | 3.38 | |||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Financial Leverage, Competitors2 | |||||||||||||||||||||||||||||
| Linde plc | 1.96 | 1.93 | 1.85 | 1.90 | 1.84 | 1.84 | 1.86 | 1.89 | 1.89 | 1.88 | 1.76 | 1.72 | 1.72 | 1.79 | — | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q2 2022 Calculation
Financial leverage = Total assets ÷ Shareholders’ equity
= 22,052,800 ÷ 2,224,600 = 9.91
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 Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
Interest Coverage
Sherwin-Williams Co., interest coverage calculation (quarterly data)
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q2 2022 Calculation
Interest coverage
= (EBITQ2 2022
+ EBITQ1 2022
+ EBITQ4 2021
+ EBITQ3 2021)
÷ (Interest expenseQ2 2022
+ Interest expenseQ1 2022
+ Interest expenseQ4 2021
+ Interest expenseQ3 2021)
= (832,800 + 549,500 + 393,800 + 694,600)
÷ (92,900 + 88,400 + 84,900 + 83,100)
= 7.07
| Solvency ratio | Description | The company |
|---|---|---|
| Interest coverage ratio | A solvency ratio calculated as EBIT divided by interest payments. | Sherwin-Williams Co. interest coverage ratio deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |