Stock Analysis on Net

Walmart Inc. (NYSE:WMT)

Analysis of Debt

Microsoft Excel

Total Debt (Carrying Amount)

Walmart Inc., balance sheet: debt

US$ in millions

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Short-term borrowings 878 372 410 224 575 5,225
Long-term debt due within one year 3,447 4,191 2,803 3,115 5,362 1,876
Finance lease obligations due within one year 725 567 511 491 511 729
Long-term debt, excluding due within one year 36,132 34,649 34,864 41,194 43,714 43,520
Long-term finance lease obligations, excluding due within one year 5,709 4,843 4,243 3,847 4,307 6,683
Total debt and finance lease obligations (carrying amount) 46,891 44,622 42,831 48,871 54,469 58,033

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

Debt item Description The company
Total debt and finance lease obligations (carrying amount) Sum of the carrying values as of the balance sheet date of all debt plus capital lease obligations. Walmart Inc. total debt increased from 2022 to 2023 and from 2023 to 2024.

Total Debt (Fair Value)

Microsoft Excel
Jan 31, 2024
Selected Financial Data (US$ in millions)
Short-term borrowings 878
Long-term debt, including amounts due within one year 38,431
Finance lease obligations 6,434
Total debt and finance lease obligations (fair value) 45,743
Financial Ratio
Debt, fair value to carrying amount ratio 0.98

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


Weighted-average Interest Rate on Debt

Weighted-average stated interest rate on debt and finance lease obligations: 4.28%

Interest rate Debt amount1 Interest rate × Debt amount Weighted-average interest rate2
7.70% 878 68
3.70% 34,527 1,277
4.00% 1,789 72
5.40% 3,412 184
0.40% 677 3
6.80% 6,434 438
Total 47,717 2,041
4.28%

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

1 US$ in millions

2 Weighted-average interest rate = 100 × 2,041 ÷ 47,717 = 4.28%