Stock Analysis on Net

Sherwin-Williams Co. (NYSE:SHW)

Analysis of Debt

Microsoft Excel

Total Debt (Carrying Amount)

Sherwin-Williams Co., balance sheet: debt

US$ in thousands

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Short-term borrowings 374,200 978,100 763,500 100 204,700
Current portion of long-term debt 1,098,800 600 260,600 25,100 429,800
Long-term debt, excluding current portion 8,377,900 9,591,000 8,590,900 8,266,900 8,050,700
Total debt (carrying amount) 9,850,900 10,569,700 9,615,000 8,292,100 8,685,200

Based on: 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), 10-K (reporting date: 2019-12-31).

Debt item Description The company
Total debt (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 increased from 2021 to 2022 but then slightly decreased from 2022 to 2023 not reaching 2021 level.

Total Debt (Fair Value)

Microsoft Excel
Dec 31, 2023
Selected Financial Data (US$ in thousands)
Short-term borrowings 374,200
Publicly traded debt 8,615,100
Non-traded debt 800
Total long-term debt, including current portion (fair value) 8,615,900
Total debt (fair value) 8,990,100
Financial Ratio
Debt, fair value to carrying amount ratio 0.91

Based on: 10-K (reporting date: 2023-12-31).


Weighted-average Interest Rate on Debt

Weighted average interest rate on debt: 3.63%

Interest rate Debt amount1 Interest rate × Debt amount Weighted-average interest rate2
3.45% 1,493,900 51,540
4.50% 1,233,000 55,485
2.95% 794,600 23,441
4.05% 598,800 24,251
3.80% 543,600 20,657
3.13% 499,700 15,616
2.30% 497,100 11,433
2.20% 494,800 10,886
3.30% 494,300 16,312
2.90% 491,900 14,265
3.45% 399,400 13,779
4.25% 398,600 16,941
4.55% 395,200 17,982
3.95% 353,100 13,947
4.00% 297,000 11,880
3.30% 249,900 8,247
4.40% 240,900 10,600
8.00% 900 72
5.50% 347,700 19,124
3.60% 26,500 954
Total 9,850,900 357,410
3.63%

Based on: 10-K (reporting date: 2023-12-31).

1 US$ in thousands

2 Weighted-average interest rate = 100 × 357,410 ÷ 9,850,900 = 3.63%