Total Debt (Carrying Amount)
Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).
Debt item | Description | The company |
---|---|---|
Total debt and finance lease liabilities (carrying amount) | Sum of the carrying values as of the balance sheet date of all debt plus capital lease obligations. | Sherwin-Williams Co. total debt decreased from 2022 to 2023 but then slightly increased from 2023 to 2024. |
Total Debt (Fair Value)
Dec 31, 2024 | |
---|---|
Selected Financial Data (US$ in thousands) | |
Short-term borrowings | 662,400) |
Publicly traded debt | 8,172,800) |
Non-traded debt | 200) |
Total long-term debt, including current portion (fair value) | 8,173,000) |
Finance lease liabilities | 189,300) |
Total debt and finance lease liabilities (fair value) | 9,024,700) |
Financial Ratio | |
Debt, fair value to carrying amount ratio | 0.90 |
Based on: 10-K (reporting date: 2024-12-31).
Weighted-average Interest Rate on Debt
Weighted average interest rate on debt and finance lease liabilities: 3.76%
Interest rate | Debt amount1 | Interest rate × Debt amount | Weighted-average interest rate2 |
---|---|---|---|
3.45% | 1,495,700) | 51,602) | |
4.50% | 1,233,700) | 55,517) | |
2.95% | 795,500) | 23,467) | |
3.80% | 543,700) | 20,661) | |
2.30% | 497,600) | 11,445) | |
2.20% | 495,500) | 10,901) | |
3.30% | 494,600) | 16,322) | |
2.90% | 492,100) | 14,271) | |
4.80% | 445,000) | 21,360) | |
3.45% | 399,800) | 13,793) | |
4.25% | 399,500) | 16,979) | |
4.55% | 395,400) | 17,991) | |
4.55% | 397,600) | 18,091) | |
3.95% | 351,600) | 13,888) | |
4.00% | 297,200) | 11,888) | |
3.30% | 250,000) | 8,250) | |
4.40% | 241,300) | 10,617) | |
8.00% | 200) | 16) | |
4.70% | 655,600) | 30,813) | |
3.10% | 6,800) | 211) | |
5.50% | 189,300) | 10,412) | |
Total | 10,077,700) | 378,493) | |
3.76% |
Based on: 10-K (reporting date: 2024-12-31).
1 US$ in thousands
2 Weighted-average interest rate = 100 × 378,493 ÷ 10,077,700 = 3.76%
Interest Costs Incurred
Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).
Debt item | Description | The company |
---|---|---|
Interest expense | Amount of the cost of borrowed funds accounted for as interest expense for debt. | Sherwin-Williams Co. interest expense increased from 2022 to 2023 but then slightly decreased from 2023 to 2024. |
Capitalized interest | Amount of interest costs capitalized disclosed as an adjusting item to interest costs incurred. | Sherwin-Williams Co. capitalized interest increased from 2022 to 2023 and from 2023 to 2024. |
Interest costs incurred | Total interest costs incurred during the period and either capitalized or charged against earnings. | Sherwin-Williams Co. interest costs incurred increased from 2022 to 2023 and from 2023 to 2024. |
Adjusted Interest Coverage Ratio
Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).
2024 Calculations
1 Interest coverage ratio (without capitalized interest) = EBIT ÷ Interest expense
= 3,867,500 ÷ 415,700 = 9.30
2 Adjusted interest coverage ratio (with capitalized interest) = EBIT ÷ Interest costs incurred
= 3,867,500 ÷ 475,300 = 8.14
Solvency ratio | Description | The company |
---|---|---|
Adjusted interest coverage ratio | A solvency ratio calculated as EBIT divided by interest payments (including capitalized interest). | Sherwin-Williams Co. adjusted interest coverage ratio improved from 2022 to 2023 and from 2023 to 2024. |