Paying users zone. Data is covered by hidden.

  • Get to Walmart Inc. for $19.99, or

  • get to entire website for at least 3 months from $49.99.

Microsoft Excel LibreOffice Calc


Enterprise Value to FCFF (EV/FCFF)

Difficulty: Intermediate


Free Cash Flow to The Firm (FCFF)

Walmart Inc., FCFF calculation

USD $ in millions

Microsoft Excel LibreOffice Calc
12 months ended Jan 31, 2018 Jan 31, 2017 Jan 31, 2016 Jan 31, 2015 Jan 31, 2014 Jan 31, 2013
Consolidated net income attributable to Walmart hidden hidden hidden hidden hidden hidden
Consolidated net income attributable to noncontrolling interest hidden hidden hidden hidden hidden hidden
Net noncash charges hidden hidden hidden hidden hidden hidden
Changes in certain assets and liabilities, net of effects of acquisitions hidden hidden hidden hidden hidden hidden
Net cash provided by operating activities hidden hidden hidden hidden hidden hidden
Interest paid, net of tax1 hidden hidden hidden hidden hidden hidden
Payments for property and equipment hidden hidden hidden hidden hidden hidden
Proceeds from the disposal of property and equipment hidden hidden hidden hidden hidden hidden
Free cash flow to the firm (FCFF) hidden hidden hidden hidden hidden hidden

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

Item Description The company
FCFF Free cash flow to the firm is the cash flow available to the Walmart Inc.’s suppliers of capital after all operating expenses have been paid and necessary investments in working and fixed capital have been made. Walmart Inc.’s FCFF increased from 2016 to 2017 but then slightly declined from 2017 to 2018 not reaching 2016 level.

Interest Paid, Net of Tax

Walmart Inc., interest paid, net of tax calculation

USD $ in millions

Microsoft Excel LibreOffice Calc
12 months ended Jan 31, 2018 Jan 31, 2017 Jan 31, 2016 Jan 31, 2015 Jan 31, 2014 Jan 31, 2013
Effective Income Tax Rate (EITR)
EITR1 hidden hidden hidden hidden hidden hidden
Interest Paid, Net of Tax
Interest paid, before tax hidden hidden hidden hidden hidden hidden
Less: Interest paid, tax2 hidden hidden hidden hidden hidden hidden
Interest paid, net of tax hidden hidden hidden hidden hidden hidden

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

2018 Calculations

2 Interest paid, tax = Interest paid × EITR
= hidden × hidden = hidden


Enterprise Value to FCFF Ratio, Current

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

Microsoft Excel LibreOffice Calc
Selected Financial Data (USD $ in millions)
Enterprise value (EV) hidden
Free cash flow to the firm (FCFF) hidden
Ratio
EV/FCFF hidden
Benchmarks
EV/FCFF, 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/FCFF, Sector
General Retailers hidden
EV/FCFF, Industry
Consumer Services hidden

Based on: 10-K (filing date: 2018-03-30).

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

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


Enterprise Value to FCFF Ratio, Historical

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

Microsoft Excel LibreOffice Calc
Jan 31, 2018 Jan 31, 2017 Jan 31, 2016 Jan 31, 2015 Jan 31, 2014 Jan 31, 2013
Selected Financial Data (USD $ in millions)
Enterprise value (EV)1 hidden hidden hidden hidden hidden hidden
Free cash flow to the firm (FCFF)2 hidden hidden hidden hidden hidden hidden
Ratio
EV/FCFF3 hidden hidden hidden hidden hidden hidden
Benchmarks
EV/FCFF, 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/FCFF, Sector
General Retailers hidden hidden hidden hidden hidden hidden
EV/FCFF, Industry
Consumer Services hidden hidden hidden hidden hidden hidden

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

2018 Calculations

3 EV/FCFF = EV ÷ FCFF
= hidden ÷ hidden = hidden

Ratio Description The company
EV/FCFF Enterprise value to free cash flow to the firm is whole company valuation indicator. Walmart Inc.’s EV/FCFF ratio declined from 2016 to 2017 but then increased from 2017 to 2018 exceeding 2016 level.