Stock Analysis on Net

Sherwin-Williams Co. (NYSE:SHW)

This company has been moved to the archive! The financial data has not been updated since July 27, 2022.

Analysis of Debt 

Microsoft Excel

Total Debt (Carrying Amount)

Sherwin-Williams Co., balance sheet: debt

US$ in thousands

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Short-term borrowings 763,500 100 204,700 328,403 633,731
Current portion of long-term debt 260,600 25,100 429,800 307,191 1,179
Long-term debt, excluding current portion 8,590,900 8,266,900 8,050,700 8,708,057 9,885,745
Total debt (carrying amount) 9,615,000 8,292,100 8,685,200 9,343,651 10,520,655

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

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 decreased from 2019 to 2020 but then increased from 2020 to 2021 exceeding 2019 level.

Total Debt (Fair Value)

Microsoft Excel
Dec 31, 2021
Selected Financial Data (US$ in thousands)
Short-term borrowings 763,500
Publicly traded debt 9,777,400
Non-traded debt 1,900
Total long-term debt, including current portion (fair value) 9,779,300
Total debt (fair value) 10,542,800
Financial Ratio
Debt, fair value to carrying amount ratio 1.10

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


Weighted-average Interest Rate on Debt

Weighted average interest rate on debt: 3.29%

Interest rate Debt amount1 Interest rate × Debt amount Weighted-average interest rate2
3.45% 1,490,400 51,419
4.50% 1,231,600 55,422
2.95% 792,600 23,382
3.80% 543,000 20,634
3.13% 498,300 15,572
2.30% 496,200 11,413
3.30% 493,900 16,299
2.20% 493,600 10,859
2.90% 491,300 14,248
3.45% 398,700 13,755
4.55% 394,700 17,959
3.95% 356,200 14,070
4.00% 296,700 11,868
2.75% 260,000 7,150
3.30% 249,600 8,237
4.40% 240,000 10,560
7.38% 119,200 8,791
7.45% 3,500 261
8.00% 2,000 160
0.30% 739,900 2,220
9.50% 23,600 2,242
Total 9,615,000 316,519
3.29%

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

1 US$ in thousands

2 Weighted-average interest rate = 100 × 316,519 ÷ 9,615,000 = 3.29%