Stock Analysis on Net

Sherwin-Williams Co. (NYSE:SHW)

$24.99

Analysis of Debt

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 Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Total Debt (Carrying Amount)

Sherwin-Williams Co., balance sheet: debt

US$ in thousands

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Short-term borrowings
Current portion of long-term debt
Current portion of finance lease liabilities
Long-term debt, excluding current portion
Long-term finance lease liabilities, excluding current portion
Total debt and finance lease liabilities (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).


The data reflects the debt structure and changes over a five-year period. Several key trends emerge when analyzing the borrowings, current liabilities, long-term debt, and total debt positions.

Short-term borrowings
Starting from a minimal amount in 2020, short-term borrowings experienced a significant surge by the end of 2021, reaching a peak near 763.5 million. This upward trend continued in 2022, peaking further at approximately 978.1 million. However, in 2023, there was a marked reduction to 374.2 million, followed by a moderate increase again to 662.4 million in 2024. This volatility suggests adjustments in short-term financing needs or refinancing strategies within the period.
Current portion of long-term debt
This liability saw a relatively stable figure in 2020 and 2021, with values around 25 million and 260.6 million respectively. A dramatic decrease was observed in 2022, dropping to a mere 0.6 million, indicating either conversions, repayments, or reclassifications. However, 2023 and 2024 experienced substantial increases with over 1 billion reported each year, suggesting renewed short-term obligations or maturing portions of long-term debt being classified as current.
Current portion of finance lease liabilities
Data is unavailable for the initial four years, but in 2024 this liability appears as 3.7 million, indicating either new lease agreements or changes in reporting practices related to finance leases.
Long-term debt, excluding current portion
The long-term debt showed a gradual increase from approximately 8.27 billion in 2020 to around 9.59 billion in 2022, indicating growing reliance on long-term financing. However, a decline followed in 2023 and 2024, reducing to approximately 8.38 billion and then 8.18 billion respectively. This decrease could be indicative of repayments, refinancing, or strategic debt management reducing exposure to long-term liabilities.
Long-term finance lease liabilities, excluding current portion
No data was reported until 2024 when 185.6 million was recorded, likely reflecting a new lease reporting standard adoption or acquisitions of finance leases classified under long-term liabilities.
Total debt and finance lease liabilities (carrying amount)
Total debt increased systematically from about 8.29 billion in 2020 up to a peak of 10.57 billion in 2022. Subsequently, total debt decreased to approximately 9.85 billion in 2023, before rising slightly again to nearly 10.08 billion in 2024. This overall trend shows a pattern of rising indebtedness up to mid-period, followed by partial deleveraging, offset somewhat by new liabilities.

In summary, the data indicates dynamic shifts in the company’s debt profile, with peaks in short-term borrowings and current portions of long-term debt around 2022 followed by reductions. Long-term debt growth until 2022 reversed in subsequent years. The emergence of finance lease liabilities in 2024 adds a new component to the debt structure, suggesting evolving financing or reporting frameworks. The company’s total debt surged over the first three years, peaking in 2022, and then declined moderately, reflecting active management of financing sources and obligations over the analyzed period.


Total Debt (Fair Value)

Microsoft Excel
Dec 31, 2024
Selected Financial Data (US$ in thousands)
Short-term borrowings
Publicly traded debt
Non-traded debt
Total long-term debt, including current portion (fair value)
Finance lease liabilities
Total debt and finance lease liabilities (fair value)
Financial Ratio
Debt, fair value to carrying amount ratio

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:

Interest rate Debt amount1 Interest rate × Debt amount Weighted-average interest rate2
Total

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

1 US$ in thousands

2 Weighted-average interest rate = 100 × ÷ =


Interest Costs Incurred

Sherwin-Williams Co., interest costs incurred

US$ in thousands

Microsoft Excel
12 months ended: Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Interest expense
Capitalized interest
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).


Interest Expense
Interest expense exhibited a generally upward trend over the observed five-year period. Starting at 340,400 thousand US dollars in 2020, it slightly decreased to 334,700 thousand in 2021. However, from 2021 onwards, interest expense increased consistently, reaching 390,800 thousand in 2022, then 417,500 thousand in 2023, followed by a marginal decrease to 415,700 thousand in 2024. Overall, the expense rose by approximately 22% from 2020 to 2024, indicating increasing borrowing costs.
Capitalized Interest
Capitalized interest data were not recorded until 2023, where it appeared at 30,700 thousand US dollars, before nearly doubling to 59,600 thousand in 2024. The emergence and growth of capitalized interest suggest increased investment in capital projects where borrowing costs are being added to the asset cost rather than expensed immediately.
Interest Costs Incurred
Interest costs incurred, representing the sum of interest expense and capitalized interest, mirrored the trend of interest expense from 2020 through 2022, initially fluctuating slightly but then increasing notably from 390,800 thousand in 2022. With the introduction of capitalized interest in 2023, total interest costs increased more substantially, rising to 448,200 thousand and further growing to 475,300 thousand in 2024. This indicates higher overall borrowing costs, partly offset by capitalization practices.
Summary Insights
The data shows that while direct interest expense has increased moderately over the period, the addition of capitalized interest from 2023 onward has accelerated the growth of total interest costs incurred. This pattern suggests a shift in financing strategy possibly linked to increased capital expenditures. The trend of rising interest costs may impact profitability unless offset by corresponding growth in asset base or earnings.

Adjusted Interest Coverage Ratio

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in thousands)
Net income
Add: Income tax expense
Add: Interest expense
Earnings before interest and tax (EBIT)
 
Interest costs incurred
Financial Ratio With and Without Capitalized Interest
Interest coverage ratio (without capitalized interest)1
Adjusted interest coverage ratio (with capitalized interest)2

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
= ÷ =

2 Adjusted interest coverage ratio (with capitalized interest) = EBIT ÷ Interest costs incurred
= ÷ =


Interest Coverage Ratio (without capitalized interest)
The interest coverage ratio exhibited a moderate decline from 8.4 in 2020 to 7.58 by the end of 2022, indicating a slightly decreased ability to cover interest expenses during this period. However, this trend reversed subsequently, with the ratio rising to 8.45 in 2023 and further improving to 9.3 by 2024, suggesting a strengthening financial position and enhanced capacity to meet interest obligations in later years.
Adjusted Interest Coverage Ratio (with capitalized interest)
The adjusted interest coverage ratio followed a similar initial pattern, decreasing from 8.4 in 2020 to 7.58 in 2022. Unlike the unadjusted ratio, the adjusted ratio did not recover as strongly, showing a smaller increase to 7.87 in 2023 and then a marginal rise to 8.14 by 2024. This indicates that when considering capitalized interest, the company's ability to cover interest expenses improved but remained at a somewhat lower level compared to the unadjusted measure.
Overall Insights
The trends suggest that the company faced some challenges in its interest coverage capacity through 2022, but managed to strengthen this position in the following two years. The stronger improvement in the unadjusted ratio relative to the adjusted ratio highlights the impact of capitalized interest on the overall interest coverage assessment. The upward trend in both ratios in the latest years indicates improved earnings or reduced interest expense relative to previous years.