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

Microsoft Excel LibreOffice Calc

Walmart Inc. (WMT)


Enterprise Value to EBITDA (EV/EBITDA)

Difficulty: Intermediate


Earnings before Interest, Tax, Depreciation and Amortization (EBITDA)

Walmart Inc., EBITDA calculation

USD $ in millions

Microsoft Excel LibreOffice Calc
12 months ended Jan 31, 2019 Jan 31, 2018 Jan 31, 2017 Jan 31, 2016 Jan 31, 2015 Jan 31, 2014
Consolidated net income attributable to Walmart hidden hidden hidden hidden hidden hidden
Add: Net income attributable to noncontrolling interest hidden hidden hidden hidden hidden hidden
Less: Income from discontinued operations, net of income taxes hidden hidden hidden hidden hidden hidden
Add: Income tax expense hidden hidden hidden hidden hidden hidden
Earnings before tax (EBT) hidden hidden hidden hidden hidden hidden
Add: Interest expense, debt, capital lease and financing obligations hidden hidden hidden hidden hidden hidden
Earnings before interest and tax (EBIT) hidden hidden hidden hidden hidden hidden
Add: Depreciation and amortization hidden hidden hidden hidden hidden hidden
Earnings before interest, tax, depreciation and amortization (EBITDA) hidden hidden hidden hidden hidden hidden

Based on: 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), 10-K (filing date: 2014-03-21).

Item Description The company
EBITDA To calculate EBITDA analysts start with net earnings. To that earnings number, interest, taxes, depreciation, and amortization are added. EBITDA as a pre-interest number is a flow to all providers of capital. Walmart Inc.’s EBITDA declined from 2017 to 2018 and from 2018 to 2019.

Enterprise Value to EBITDA Ratio, Current

Walmart Inc., current EV/EBITDA calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Selected Financial Data (USD $ in millions)
Enterprise value (EV) hidden
Earnings before interest, tax, depreciation and amortization (EBITDA) hidden
Ratio
EV/EBITDA hidden
Benchmarks
EV/EBITDA, Competitors
Amazon.com Inc. hidden
Costco Wholesale Corp. hidden
eBay Inc. hidden
Home Depot Inc. hidden
Lowe’s Cos. Inc. hidden
Netflix Inc. hidden
Target Corp. hidden
TJX Cos. Inc. hidden
EV/EBITDA, Sector
General Retailers hidden
EV/EBITDA, Industry
Consumer Services hidden

Based on: 10-K (filing date: 2019-03-28).

If company EV/EBITDA is lower then the EV/EBITDA of benchmark then company is relatively undervalued.

Otherwise, if company EV/EBITDA is higher then the EV/EBITDA of benchmark then company is relatively overvalued.


Enterprise Value to EBITDA Ratio, Historical

Walmart Inc., historical EV/EBITDA calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Jan 31, 2019 Jan 31, 2018 Jan 31, 2017 Jan 31, 2016 Jan 31, 2015 Jan 31, 2014
Selected Financial Data (USD $ in millions)
Enterprise value (EV)1 hidden hidden hidden hidden hidden hidden
Earnings before interest, tax, depreciation and amortization (EBITDA)2 hidden hidden hidden hidden hidden hidden
Ratio
EV/EBITDA3 hidden hidden hidden hidden hidden hidden
Benchmarks
EV/EBITDA, Competitors
Amazon.com Inc. hidden hidden hidden hidden hidden hidden
Costco Wholesale Corp. hidden hidden hidden hidden hidden hidden
eBay Inc. hidden hidden hidden hidden hidden hidden
Home Depot Inc. hidden hidden hidden hidden hidden hidden
Lowe’s Cos. Inc. hidden hidden hidden hidden hidden hidden
Netflix Inc. hidden hidden hidden hidden hidden hidden
Target Corp. hidden hidden hidden hidden hidden hidden
TJX Cos. Inc. hidden hidden hidden hidden hidden hidden
EV/EBITDA, Sector
General Retailers hidden hidden hidden hidden hidden hidden
EV/EBITDA, Industry
Consumer Services hidden hidden hidden hidden hidden hidden

Based on: 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), 10-K (filing date: 2014-03-21).

2019 Calculations

3 EV/EBITDA = EV ÷ EBITDA
= hidden ÷ hidden = hidden

Ratio Description The company
EV/EBITDA EV/EBITDA is a valuation indicator for the overall company rather than common stock. Walmart Inc.’s EV/EBITDA ratio increased from 2017 to 2018 and from 2018 to 2019.