Stock Analysis on Net
Stock Analysis on Net
Microsoft Excel LibreOffice Calc

Walmart Inc. (NYSE:WMT)

Analysis of Debt

Advanced level

Total Debt (Carrying Amount)

Walmart Inc., balance sheet: debt

US$ in millions

Microsoft Excel LibreOffice Calc
Jan 31, 2020 Jan 31, 2019 Jan 31, 2018 Jan 31, 2017 Jan 31, 2016 Jan 31, 2015
Short-term borrowings 575  5,225  5,257  1,099  2,708  1,592 
Long-term debt due within one year 5,362  1,876  3,738  2,256  2,745  4,810 
Finance lease obligations due within one year 511  —  —  —  —  — 
Capital lease and financing obligations due within one year —  729  667  565  551  287 
Long-term debt, excluding due within one year 43,714  43,520  30,045  36,015  38,214  41,086 
Long-term finance lease obligations, excluding due within one year 4,307  —  —  —  —  — 
Long-term capital lease and financing obligations, excluding due within one year —  6,683  6,780  6,003  5,816  2,606 
Total debt and finance lease obligations (carrying amount) 54,469  58,033  46,487  45,938  50,034  50,381 

Based on: 10-K (filing date: 2020-03-20), 10-K (filing date: 2019-03-28), 10-K (filing date: 2018-03-30), 10-K (filing date: 2017-03-31), 10-K (filing date: 2016-03-30), 10-K (filing date: 2015-04-01).

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.’s total debt increased from 2018 to 2019 but then slightly decreased from 2019 to 2020.

Total Debt (Fair Value)

Microsoft Excel LibreOffice Calc
Jan 31, 2020
Selected Financial Data (US$ in millions)
Short-term borrowings 575 
Long-term debt, including amounts due within one year 57,769 
Finance lease obligations 4,818 
Capital lease and financing obligations — 
Total debt and finance lease obligations (fair value) 63,162 
Financial Ratio
Debt, fair value to carrying amount ratio 1.16

Based on: 10-K (filing date: 2020-03-20).

Weighted-average Interest Rate on Debt

Weighted-average stated interest rate on debt: 4.16%

Interest Rate Debt Amount1 Interest Rate × Debt Amount Weighted-average Interest Rate2
3.80% 39,752  1,511 
2.10% 1,500  32 
3.30% 2,758  91 
5.40% 3,518  190 
0.40% 1,652  7 
5.00% 575  29 
8.60% 4,818  414 
Total 54,573  2,273 
4.16%

Based on: 10-K (filing date: 2020-03-20).

1 US$ in millions

2 Weighted-average interest rate = 100 × 2,273 ÷ 54,573 = 4.16%