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
Feb 2, 2025 Jan 28, 2024 Jan 29, 2023 Jan 30, 2022 Jan 31, 2021 Feb 2, 2020
Short-term debt 316 1,035 974
Current installments of long-term debt 4,582 1,368 1,231 2,447 1,416 1,839
Long-term debt, excluding current installments 48,485 42,743 41,962 36,604 35,822 28,670
Total debt (carrying amount) 53,383 44,111 43,193 40,086 37,238 31,483

Based on: 10-K (reporting date: 2025-02-02), 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).

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 2023 to 2024 and from 2024 to 2025.

Total Debt (Fair Value)

Microsoft Excel
Feb 2, 2025
Selected Financial Data (US$ in millions)
Commercial paper 316
Senior notes 45,499
Finance lease obligations 3,021
Other long-term debt 315
Total debt (fair value) 49,151
Financial Ratio
Debt, fair value to carrying amount ratio 0.92

Based on: 10-K (reporting date: 2025-02-02).


Weighted-average Interest Rate on Debt

Weighted-average interest rate on debt: 3.90%

Interest rate Debt amount1 Interest rate × Debt amount Weighted-average interest rate2
4.40% 316 14
2.70% 500 14
5.13% 500 26
3.35% 999 33
4.00% 749 30
5.10% 898 46
3.00% 1,297 39
5.15% 1,496 77
2.13% 997 21
4.95% 747 37
2.88% 747 21
2.50% 747 19
4.88% 995 49
2.80% 984 28
0.90% 497 4
1.50% 995 15
3.90% 972 38
4.90% 744 36
2.95% 1,672 49
4.75% 1,239 59
2.70% 1,359 37
1.38% 1,173 16
4.85% 989 48
1.88% 939 18
3.25% 1,240 40
4.50% 1,244 56
4.95% 1,725 85
5.88% 2,879 169
3.30% 1,071 35
5.40% 496 27
5.95% 991 59
4.20% 937 39
4.88% 982 48
4.40% 981 43
4.25% 1,587 67
3.90% 1,145 45
4.50% 1,466 66
3.13% 1,176 37
3.35% 1,473 49
2.38% 1,152 27
2.75% 984 27
3.63% 1,459 53
4.95% 980 49
5.30% 1,466 78
3.50% 974 34
5.40% 489 26
3.70% 3,021 112
Total 52,469 2,045
3.90%

Based on: 10-K (reporting date: 2025-02-02).

1 US$ in millions

2 Weighted-average interest rate = 100 × 2,045 ÷ 52,469 = 3.90%