Stock Analysis on Net

Home Depot Inc. (NYSE:HD)

Analysis of Debt

Microsoft Excel

Total Debt (Carrying Amount)

Home Depot Inc., balance sheet: debt

US$ in millions

Microsoft Excel
Jan 28, 2024 Jan 29, 2023 Jan 30, 2022 Jan 31, 2021 Feb 2, 2020 Feb 3, 2019
Short-term debt 1,035 974 1,339
Current installments of long-term debt 1,368 1,231 2,447 1,416 1,839 1,056
Long-term debt, excluding current installments 42,743 41,962 36,604 35,822 28,670 26,807
Total debt (carrying amount) 44,111 43,193 40,086 37,238 31,483 29,202

Based on: 10-K (reporting date: 2024-01-28), 10-K (reporting date: 2023-01-29), 10-K (reporting date: 2022-01-30), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-02-02), 10-K (reporting date: 2019-02-03).

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. Home Depot Inc. total debt increased from 2022 to 2023 and from 2023 to 2024.

Total Debt (Fair Value)

Microsoft Excel
Jan 28, 2024
Selected Financial Data (US$ in millions)
Commercial paper
Senior notes 38,495
Finance lease obligations 3,268
Total debt (fair value) 41,763
Financial Ratio
Debt, fair value to carrying amount ratio 0.95

Based on: 10-K (reporting date: 2024-01-28).


Weighted-average Interest Rate on Debt

Weighted-average interest rate on debt: 3.65%

Interest rate Debt amount1 Interest rate × Debt amount Weighted-average interest rate2
3.75% 1,100 41
2.70% 499 13
5.13% 498 26
3.35% 999 33
4.00% 749 30
3.00% 1,296 39
2.13% 995 21
4.95% 746 37
2.88% 745 21
2.50% 746 19
2.80% 979 27
0.90% 497 4
1.50% 994 15
3.90% 970 38
4.90% 743 36
2.95% 1,665 49
2.70% 1,346 36
1.38% 1,167 16
1.88% 936 18
3.25% 1,239 40
4.50% 1,243 56
5.88% 2,872 169
3.30% 1,057 35
5.40% 496 27
5.95% 991 59
4.20% 927 39
4.88% 982 48
4.40% 980 43
4.25% 1,586 67
3.90% 1,145 45
4.50% 1,465 66
3.13% 1,173 37
3.35% 1,472 49
2.38% 1,150 27
2.75% 983 27
3.63% 1,458 53
4.95% 980 49
3.50% 974 34
3.70% 3,268 121
Total 44,111 1,611
3.65%

Based on: 10-K (reporting date: 2024-01-28).

1 US$ in millions

2 Weighted-average interest rate = 100 × 1,611 ÷ 44,111 = 3.65%