Stock Analysis on Net
Stock Analysis on Net

Walmart Inc. (NYSE:WMT)

Analysis of Debt 

Microsoft Excel LibreOffice Calc

Total Debt (Carrying Amount)

Walmart Inc., balance sheet: debt

US$ in millions

Microsoft Excel LibreOffice Calc
Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019 Jan 31, 2018 Jan 31, 2017
Short-term borrowings 410  224  575  5,225  5,257  1,099 
Long-term debt due within one year 2,803  3,115  5,362  1,876  3,738  2,256 
Finance lease obligations due within one year 511  491  511  —  —  — 
Capital lease and financing obligations due within one year —  —  —  729  667  565 
Long-term debt, excluding due within one year 34,864  41,194  43,714  43,520  30,045  36,015 
Long-term finance lease obligations, excluding due within one year 4,243  3,847  4,307  —  —  — 
Long-term capital lease and financing obligations, excluding due within one year —  —  —  6,683  6,780  6,003 
Total debt and finance lease obligations (carrying amount) 42,831  48,871  54,469  58,033  46,487  45,938 

Based on: 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), 10-K (reporting date: 2018-01-31), 10-K (reporting date: 2017-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 decreased from 2020 to 2021 and from 2021 to 2022.

Total Debt (Fair Value)

Microsoft Excel LibreOffice Calc
Jan 31, 2022
Selected Financial Data (US$ in millions)
Short-term borrowings 410 
Long-term debt, including amounts due within one year 42,381 
Finance lease obligations 4,754 
Capital lease and financing obligations — 
Total debt and finance lease obligations (fair value) 47,545 
Financial Ratio
Debt, fair value to carrying amount ratio 1.11

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

Weighted-average Interest Rate on Debt

Weighted-average stated interest rate on debt: 3.86%

Interest rate Debt amount1 Interest rate × Debt amount Weighted-average interest rate2
2.90% 410  12 
3.50% 29,957  1,048 
3.30% 2,787  92 
5.40% 3,601  194 
0.30% 1,475  4 
6.50% 4,754  309 
Total 42,984  1,660 
3.86%

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

1 US$ in millions

2 Weighted-average interest rate = 100 × 1,660 ÷ 42,984 = 3.86%