Paying users zone. Data is covered by hidden.

  • Get to Home Depot Inc. for $19.99, or

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

Microsoft Excel LibreOffice Calc


Price to FCFE (P/FCFE)

Difficulty: Intermediate


Free Cash Flow to Equity (FCFE)

Home Depot Inc., FCFE calculation

USD $ in millions

Microsoft Excel LibreOffice Calc
12 months ended Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015 Feb 2, 2014 Feb 3, 2013
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
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
Proceeds from short-term debt, net hidden hidden hidden hidden hidden hidden
Proceeds from long-term debt, net of discounts hidden hidden hidden hidden hidden hidden
Repayments of long-term debt hidden hidden hidden hidden hidden hidden
Free cash flow to equity (FCFE) hidden hidden hidden hidden hidden hidden

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

Item Description The company
FCFE Free cash flow to equity is the cash flow available to Home Depot Inc.’s equity holders after all operating expenses, interest, and principal payments have been paid and necessary investments in working and fixed capital have been made. Home Depot Inc.’s FCFE declined from 2016 to 2017 but then increased from 2017 to 2018 exceeding 2016 level.

Price to FCFE Ratio, Current

Home Depot Inc., current P/FCFE calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
No. shares of common stock outstanding hidden
Selected Financial Data (USD $)
Free cash flow to equity (FCFE) (in millions) hidden
FCFE per share hidden
Current share price (P) hidden
Ratio
P/FCFE hidden
Benchmarks
P/FCFE, Competitors
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
P/FCFE, Sector
General Retailers hidden
P/FCFE, Industry
Consumer Services hidden

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

If company P/FCFE is lower then the P/FCFE of benchmark then company is relatively undervalued.

Otherwise, if company P/FCFE is higher then the P/FCFE of benchmark then company is relatively overvalued.


Price to FCFE Ratio, Historical

Home Depot Inc., historical P/FCFE calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015 Feb 2, 2014 Feb 3, 2013
No. shares of common stock outstanding1 hidden hidden hidden hidden hidden hidden
Selected Financial Data (USD $)
Free cash flow to equity (FCFE) (in millions)2 hidden hidden hidden hidden hidden hidden
FCFE per share4 hidden hidden hidden hidden hidden hidden
Share price1, 3 hidden hidden hidden hidden hidden hidden
Ratio
P/FCFE5 hidden hidden hidden hidden hidden hidden
Benchmarks
P/FCFE, 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
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
P/FCFE, Sector
General Retailers hidden hidden hidden hidden hidden hidden
P/FCFE, Industry
Consumer Services hidden hidden hidden hidden hidden hidden

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

1 Data adjusted for splits and stock dividends.

2 See Details »

3 Close price on the filing date of Home Depot Inc.’s Annual Report.

2018 Calculations

4 FCFE per share = FCFE ÷ No. shares of common stock outstanding
= hidden ÷ hidden = hidden

5 P/FCFE = Share price ÷ FCFE per share
= hidden ÷ hidden = hidden

Ratio Description The company
P/FCFE Price to free cash flow to equity is cash valuation indicator of stockholders’ equity. Home Depot Inc.’s P/FCFE ratio increased from 2016 to 2017 but then slightly declined from 2017 to 2018 not reaching 2016 level.