Paying users zone. Data is covered by hidden.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Apple Pay Google Pay
Verified by Visa MasterCard SecureCode American Express SafeKey

Walmart Inc. (WMT)


Long-term Debt and Solvency Analysis
Quarterly Data

Difficulty: Beginner


Ratios (Summary)

Walmart Inc., debt and solvency ratios (quarterly data)

Microsoft Excel LibreOffice Calc
Apr 30, 2019 Jan 31, 2019 Oct 31, 2018 Jul 31, 2018 Apr 30, 2018 Jan 31, 2018 Oct 31, 2017 Jul 31, 2017 Apr 30, 2017 Jan 31, 2017 Oct 31, 2016 Jul 31, 2016 Apr 30, 2016 Jan 31, 2016 Oct 31, 2015 Jul 31, 2015 Apr 30, 2015 Jan 31, 2015 Oct 31, 2014 Jul 31, 2014 Apr 30, 2014 Jan 31, 2014 Oct 31, 2013 Jul 31, 2013 Apr 30, 2013
Debt to equity hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Debt to capital hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Interest coverage hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden

Based on: 10-Q (filing date: 2019-06-07), 10-K (filing date: 2019-03-28), 10-Q (filing date: 2018-11-30), 10-Q (filing date: 2018-09-06), 10-Q (filing date: 2018-06-04), 10-K (filing date: 2018-03-30), 10-Q (filing date: 2017-12-01), 10-Q (filing date: 2017-08-31), 10-Q (filing date: 2017-06-02), 10-K (filing date: 2017-03-31), 10-Q (filing date: 2016-12-01), 10-Q (filing date: 2016-08-31), 10-Q (filing date: 2016-06-03), 10-K (filing date: 2016-03-30), 10-Q (filing date: 2015-12-02), 10-Q (filing date: 2015-09-09), 10-Q (filing date: 2015-06-05), 10-K (filing date: 2015-04-01), 10-Q (filing date: 2014-12-01), 10-Q (filing date: 2014-09-05), 10-Q (filing date: 2014-06-06), 10-K (filing date: 2014-03-21), 10-Q (filing date: 2013-12-06), 10-Q (filing date: 2013-09-05), 10-Q (filing date: 2013-06-07).

Ratio Description The company
Debt-to-equity ratio A solvency ratio calculated as total debt divided by total shareholders’ equity. Walmart Inc.’s debt-to-equity ratio improved from Q3 2019 to Q4 2019 and from Q4 2019 to Q1 2020.
Debt-to-capital ratio A solvency ratio calculated as total debt divided by total debt plus shareholders’ equity. Walmart Inc.’s debt-to-capital ratio improved from Q3 2019 to Q4 2019 and from Q4 2019 to Q1 2020.

Ratio Description The company
Interest coverage ratio A solvency ratio calculated as EBIT divided by interest payments. Walmart Inc.’s interest coverage ratio improved from Q3 2019 to Q4 2019 and from Q4 2019 to Q1 2020.

Debt to Equity

Walmart Inc., debt to equity calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Apr 30, 2019 Jan 31, 2019 Oct 31, 2018 Jul 31, 2018 Apr 30, 2018 Jan 31, 2018 Oct 31, 2017 Jul 31, 2017 Apr 30, 2017 Jan 31, 2017 Oct 31, 2016 Jul 31, 2016 Apr 30, 2016 Jan 31, 2016 Oct 31, 2015 Jul 31, 2015 Apr 30, 2015 Jan 31, 2015 Oct 31, 2014 Jul 31, 2014 Apr 30, 2014 Jan 31, 2014 Oct 31, 2013 Jul 31, 2013 Apr 30, 2013
Selected Financial Data (USD $ in millions)
Short-term borrowings hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Long-term debt due within one year hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Capital lease and financing obligations due within one year hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Long-term debt, excluding due within one year hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Long-term capital lease and financing obligations, excluding due within one year hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Total debt hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Total Walmart shareholders’ equity hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Ratio
Debt to equity1 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden

Based on: 10-Q (filing date: 2019-06-07), 10-K (filing date: 2019-03-28), 10-Q (filing date: 2018-11-30), 10-Q (filing date: 2018-09-06), 10-Q (filing date: 2018-06-04), 10-K (filing date: 2018-03-30), 10-Q (filing date: 2017-12-01), 10-Q (filing date: 2017-08-31), 10-Q (filing date: 2017-06-02), 10-K (filing date: 2017-03-31), 10-Q (filing date: 2016-12-01), 10-Q (filing date: 2016-08-31), 10-Q (filing date: 2016-06-03), 10-K (filing date: 2016-03-30), 10-Q (filing date: 2015-12-02), 10-Q (filing date: 2015-09-09), 10-Q (filing date: 2015-06-05), 10-K (filing date: 2015-04-01), 10-Q (filing date: 2014-12-01), 10-Q (filing date: 2014-09-05), 10-Q (filing date: 2014-06-06), 10-K (filing date: 2014-03-21), 10-Q (filing date: 2013-12-06), 10-Q (filing date: 2013-09-05), 10-Q (filing date: 2013-06-07).

Q1 2020 Calculations

1 Debt to equity = Total debt ÷ Total Walmart shareholders’ equity
= hidden ÷ hidden = hidden

Ratio Description The company
Debt-to-equity ratio A solvency ratio calculated as total debt divided by total shareholders’ equity. Walmart Inc.’s debt-to-equity ratio improved from Q3 2019 to Q4 2019 and from Q4 2019 to Q1 2020.

Debt to Capital

Walmart Inc., debt to capital calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Apr 30, 2019 Jan 31, 2019 Oct 31, 2018 Jul 31, 2018 Apr 30, 2018 Jan 31, 2018 Oct 31, 2017 Jul 31, 2017 Apr 30, 2017 Jan 31, 2017 Oct 31, 2016 Jul 31, 2016 Apr 30, 2016 Jan 31, 2016 Oct 31, 2015 Jul 31, 2015 Apr 30, 2015 Jan 31, 2015 Oct 31, 2014 Jul 31, 2014 Apr 30, 2014 Jan 31, 2014 Oct 31, 2013 Jul 31, 2013 Apr 30, 2013
Selected Financial Data (USD $ in millions)
Short-term borrowings hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Long-term debt due within one year hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Capital lease and financing obligations due within one year hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Long-term debt, excluding due within one year hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Long-term capital lease and financing obligations, excluding due within one year hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Total debt hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Total Walmart shareholders’ equity hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Total capital hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Ratio
Debt to capital1 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden

Based on: 10-Q (filing date: 2019-06-07), 10-K (filing date: 2019-03-28), 10-Q (filing date: 2018-11-30), 10-Q (filing date: 2018-09-06), 10-Q (filing date: 2018-06-04), 10-K (filing date: 2018-03-30), 10-Q (filing date: 2017-12-01), 10-Q (filing date: 2017-08-31), 10-Q (filing date: 2017-06-02), 10-K (filing date: 2017-03-31), 10-Q (filing date: 2016-12-01), 10-Q (filing date: 2016-08-31), 10-Q (filing date: 2016-06-03), 10-K (filing date: 2016-03-30), 10-Q (filing date: 2015-12-02), 10-Q (filing date: 2015-09-09), 10-Q (filing date: 2015-06-05), 10-K (filing date: 2015-04-01), 10-Q (filing date: 2014-12-01), 10-Q (filing date: 2014-09-05), 10-Q (filing date: 2014-06-06), 10-K (filing date: 2014-03-21), 10-Q (filing date: 2013-12-06), 10-Q (filing date: 2013-09-05), 10-Q (filing date: 2013-06-07).

Q1 2020 Calculations

1 Debt to capital = Total debt ÷ Total capital
= hidden ÷ hidden = hidden

Ratio Description The company
Debt-to-capital ratio A solvency ratio calculated as total debt divided by total debt plus shareholders’ equity. Walmart Inc.’s debt-to-capital ratio improved from Q3 2019 to Q4 2019 and from Q4 2019 to Q1 2020.

Interest Coverage

Walmart Inc., interest coverage calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Apr 30, 2019 Jan 31, 2019 Oct 31, 2018 Jul 31, 2018 Apr 30, 2018 Jan 31, 2018 Oct 31, 2017 Jul 31, 2017 Apr 30, 2017 Jan 31, 2017 Oct 31, 2016 Jul 31, 2016 Apr 30, 2016 Jan 31, 2016 Oct 31, 2015 Jul 31, 2015 Apr 30, 2015 Jan 31, 2015 Oct 31, 2014 Jul 31, 2014 Apr 30, 2014 Jan 31, 2014 Oct 31, 2013 Jul 31, 2013 Apr 30, 2013
Selected Financial Data (USD $ in millions)
Consolidated net income (loss) attributable to Walmart hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Add: Net income attributable to noncontrolling interest hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Less: Income from discontinued operations, net of income taxes hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Add: Income tax expense hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Add: Interest expense, debt, finance, capital lease and financing obligations hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Earnings before interest and tax (EBIT) hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Ratio
Interest coverage1 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden

Based on: 10-Q (filing date: 2019-06-07), 10-K (filing date: 2019-03-28), 10-Q (filing date: 2018-11-30), 10-Q (filing date: 2018-09-06), 10-Q (filing date: 2018-06-04), 10-K (filing date: 2018-03-30), 10-Q (filing date: 2017-12-01), 10-Q (filing date: 2017-08-31), 10-Q (filing date: 2017-06-02), 10-K (filing date: 2017-03-31), 10-Q (filing date: 2016-12-01), 10-Q (filing date: 2016-08-31), 10-Q (filing date: 2016-06-03), 10-K (filing date: 2016-03-30), 10-Q (filing date: 2015-12-02), 10-Q (filing date: 2015-09-09), 10-Q (filing date: 2015-06-05), 10-K (filing date: 2015-04-01), 10-Q (filing date: 2014-12-01), 10-Q (filing date: 2014-09-05), 10-Q (filing date: 2014-06-06), 10-K (filing date: 2014-03-21), 10-Q (filing date: 2013-12-06), 10-Q (filing date: 2013-09-05), 10-Q (filing date: 2013-06-07).

Q1 2020 Calculations

1 Interest coverage = (EBITQ1 2020 + EBITQ4 2019 + EBITQ3 2019 + EBITQ2 2019) ÷ (Interest expenseQ1 2020 + Interest expenseQ4 2019 + Interest expenseQ3 2019 + Interest expenseQ2 2019)
= (hidden + hidden + hidden + hidden) ÷ (hidden + hidden + hidden + hidden) = hidden

Ratio Description The company
Interest coverage ratio A solvency ratio calculated as EBIT divided by interest payments. Walmart Inc.’s interest coverage ratio improved from Q3 2019 to Q4 2019 and from Q4 2019 to Q1 2020.