Paying users zone. Data is hidden behind hidden.

  • Get 1-month access to Home Depot Inc. for $19.99, or

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


We accept:

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

This is a one-time payment. There is no automatic renewal.

Microsoft Excel LibreOffice Calc

Home Depot Inc. (HD)


Enterprise Value to FCFF (EV/FCFF)

Medium level of difficulty


Free Cash Flow to The Firm (FCFF)

Home Depot Inc., FCFF calculation

US$ in millions

Microsoft Excel LibreOffice Calc
12 months ended Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015 Feb 2, 2014
Net earnings hidden hidden hidden hidden hidden hidden
Net noncash charges hidden hidden hidden hidden hidden hidden
Changes in assets and liabilities, net of acquisition effects hidden hidden hidden hidden hidden hidden
Net cash provided by operating activities hidden hidden hidden hidden hidden hidden
Cash paid for interest, net of interest capitalized, net of tax1 hidden hidden hidden hidden hidden hidden
Interest capitalized, net of tax2 hidden hidden hidden hidden hidden hidden
Capital expenditures, net of non-cash capital expenditures hidden hidden hidden hidden hidden hidden
Proceeds from sales of property and equipment hidden hidden hidden hidden hidden hidden
Non-cash capital expenditures 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: 2019-03-28), 10-K (filing date: 2018-03-22), 10-K (filing date: 2017-03-23), 10-K (filing date: 2016-03-24), 10-K (filing date: 2015-03-26), 10-K (filing date: 2014-03-27).

Item Description The company
FCFF Free cash flow to the firm is the cash flow available to the Home Depot Inc.’s suppliers of capital after all operating expenses have been paid and necessary investments in working and fixed capital have been made. Home Depot Inc.’s FCFF increased from 2017 to 2018 and from 2018 to 2019.

Interest Paid, Net of Tax

Home Depot Inc., interest paid, net of tax calculation

US$ in millions

Microsoft Excel LibreOffice Calc
12 months ended Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015 Feb 2, 2014
Effective Income Tax Rate (EITR)
EITR1 hidden hidden hidden hidden hidden hidden
Interest Paid, Net of Tax
Cash paid for interest, net of interest capitalized, before tax hidden hidden hidden hidden hidden hidden
Less: Cash paid for interest, net of interest capitalized, tax2 hidden hidden hidden hidden hidden hidden
Cash paid for interest, net of interest capitalized, net of tax hidden hidden hidden hidden hidden hidden
Interest Costs Capitalized, Net of Tax
Interest capitalized, before tax hidden hidden hidden hidden hidden hidden
Less: Interest capitalized, tax3 hidden hidden hidden hidden hidden hidden
Interest capitalized, net of tax hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-03-28), 10-K (filing date: 2018-03-22), 10-K (filing date: 2017-03-23), 10-K (filing date: 2016-03-24), 10-K (filing date: 2015-03-26), 10-K (filing date: 2014-03-27).

1 See details »

2 2019 Calculation
Cash paid for interest, net of interest capitalized, tax = Cash paid for interest, net of interest capitalized × EITR
= hidden × hidden = hidden

3 2019 Calculation
Interest capitalized, tax = Interest capitalized × EITR
= hidden × hidden = hidden


Enterprise Value to FCFF Ratio, Current

Home Depot Inc., current EV/FCFF calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Selected Financial Data (US$ in millions)
Enterprise value (EV) hidden
Free cash flow to the firm (FCFF) hidden
Valuation Ratio
EV/FCFF hidden
Benchmarks
EV/FCFF, Competitors1
Amazon.com Inc. hidden
Costco Wholesale Corp. hidden
eBay Inc. hidden
Lowe’s Cos. Inc. hidden
Netflix Inc. hidden
Target Corp. hidden
TJX Cos. Inc. hidden
Walmart Inc. hidden
EV/FCFF, Sector
General Retailers hidden
EV/FCFF, Industry
Consumer Services hidden

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

1 Click competitor name to see calculations.

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


Enterprise Value to FCFF Ratio, Historical

Home Depot Inc., historical EV/FCFF calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015 Feb 2, 2014
Selected Financial Data (US$ 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
Valuation Ratio
EV/FCFF3 hidden hidden hidden hidden hidden hidden
Benchmarks
EV/FCFF, Competitors4
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
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
Walmart 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: 2019-03-28), 10-K (filing date: 2018-03-22), 10-K (filing date: 2017-03-23), 10-K (filing date: 2016-03-24), 10-K (filing date: 2015-03-26), 10-K (filing date: 2014-03-27).

1 See details »

2 See details »

3 2019 Calculation
EV/FCFF = EV ÷ FCFF
= hidden ÷ hidden = hidden

4 Click competitor name to see calculations.

Valuation ratio Description The company
EV/FCFF Enterprise value to free cash flow to the firm is whole company valuation indicator. Home Depot Inc.’s EV/FCFF ratio declined from 2017 to 2018 and from 2018 to 2019.