The Home Depot Inc

$ 193.59 1.59 (0.83%)
Volume: 3,795,088 Avg Vol (1m): 3,855,726
Market Cap $: 213.48 Bil Enterprise Value $: 239.86 Bil
P/E (TTM): 19.52 P/B: 0.00
Earnings Power Value 81.43
Net Current Asset Value -29.93
Tangible Book -3.97
Projected FCF 110.08
Median P/S Value 139.72
Graham Number 0
Peter Lynch Value 144.93
DCF (FCF Based) 226.23
DCF (Earnings Based) 282.41
1Y (-%)

Financial Strength : 6/10

GuruFocus Financial Strength Rank measures how strong a company's financial situation is . It is based on these factors
1. The debt burden that the company has as measured by its Interest coverage (current year).
2. Debt to revenue ratio. The lower, the better
3. Altman Z-score.
A company ranks high with financial strength is likely to withstand any business slowdowns and recessions.
Current vs industry vs history
Cash-to-Debt 0.07
Cash-To-Debt ranked lower than
82.94% of 979 companies
in the Home Improvement Stores industry.
Industry Max: 17286.44, Med: 0.99, Min: 0.01
HD: 0.07
Ranked among companies with meaningful Cash-To-Debt only.
Cash-To-Debt range over the past 10 years
Min: 0, Med: 0.25, Max: 4.51
Current: 0.07
0
4.51
Equity-to-Asset -0.04
Equity-to-Asset ranked lower than
96.15% of 961 companies
in the Home Improvement Stores industry.
Industry Max: 1, Med: 0.49, Min: -1.74
HD: -0.04
Ranked among companies with meaningful Equity-to-Asset only.
Equity-to-Asset range over the past 10 years
Min: -0.04, Med: 0.53, Max: 0.72
Current: -0.04
-0.04
0.72
Debt-to-Equity -13.19
Debt-to-Equity ranked lower than
99.06% of 744 companies
in the Home Improvement Stores industry.
Industry Max: 112.3, Med: 0.43, Min: 0.01
HD: -13.19
Ranked among companies with meaningful Debt-to-Equity only.
Debt-to-Equity range over the past 10 years
Min: -15.55, Med: 0.34, Max: 19.53
Current: -13.19
-15.55
19.53
Debt-to-EBITDA 1.57
Debt-to-EBITDA ranked higher than
62.39% of 662 companies
in the Home Improvement Stores industry.
Industry Max: 377.27, Med: 2.5, Min: 0.01
HD: 1.57
Ranked among companies with meaningful Debt-to-EBITDA only.
Debt-to-EBITDA range over the past 10 years
Min: 1.13, Med: 1.43, Max: 1.64
Current: 1.57
1.13
1.64
Interest Coverage 14.84
Interest Coverage ranked lower than
59.58% of 814 companies
in the Home Improvement Stores industry.
Industry Max: 53385.22, Med: 27.47, Min: 0.01
HD: 14.84
Ranked among companies with meaningful Interest Coverage only.
Interest Coverage range over the past 10 years
Min: 7.11, Med: 12.71, Max: 15.01
Current: 14.84
7.11
15.01
Piotroski F-Score 7
0
1
2
3
4
5
6
7
8
9
Altman Z-Score 5.55
DISTRESS
GREY
SAFE
Beneish M-Score -2.16
Not Manipulator
Manipulator
WACC vs ROIC %
ROIC 49.53%
WACC 8.92%

Profitability & Growth : 9/10

GuruFocus Profitability Rank ranks how profitable a company is and how likely the company's business will stay that way.
Current vs industry vs history
Operating Margin % 14.59
Operating Margin ranked higher than
89.67% of 978 companies
in the Home Improvement Stores industry.
Industry Max: 222.6, Med: 3.64, Min: -411042.03
HD: 14.59
Ranked among companies with meaningful Operating Margin only.
Operating Margin range over the past 10 years
Min: 7.26, Med: 12.11, Max: 14.58
Current: 14.59
7.26
14.58
Net Margin % 10.24
Net Margin ranked higher than
85.20% of 980 companies
in the Home Improvement Stores industry.
Industry Max: 239.44, Med: 2.32, Min: -410659.42
HD: 10.24
Ranked among companies with meaningful Net Margin only.
Net Margin range over the past 10 years
Min: 4.02, Med: 7.23, Max: 10.28
Current: 10.24
4.02
10.28
ROE % 5643.22
ROE ranked higher than
99.58% of 962 companies
in the Home Improvement Stores industry.
Industry Max: 1239.7, Med: 6.49, Min: -1044.55
HD: 5643.22
Ranked among companies with meaningful ROE only.
ROE range over the past 10 years
Min: 14.32, Med: 35.55, Max: 298.25
Current: 5643.22
14.32
298.25
ROA % 24.04
ROA ranked higher than
96.65% of 986 companies
in the Home Improvement Stores industry.
Industry Max: 1572.62, Med: 2.9, Min: -2744.19
HD: 24.04
Ranked among companies with meaningful ROA only.
ROA range over the past 10 years
Min: 6.49, Med: 14.49, Max: 25.12
Current: 24.04
6.49
25.12
ROC (Joel Greenblatt) % 67.28
ROC (Joel Greenblatt) ranked higher than
87.68% of 982 companies
in the Home Improvement Stores industry.
Industry Max: 33213.77, Med: 13.8, Min: -32126.98
HD: 67.28
Ranked among companies with meaningful ROC (Joel Greenblatt) only.
ROC (Joel Greenblatt) range over the past 10 years
Min: 16.51, Med: 38.44, Max: 64.84
Current: 67.28
16.51
64.84
3-Year Total Revenue Growth Rate 6.90
3-Year Revenue Growth Rate ranked higher than
78.83% of 874 companies
in the Home Improvement Stores industry.
Industry Max: 1040.6, Med: 2.2, Min: -100
HD: 11.1
Ranked among companies with meaningful 3-Year Revenue Growth Rate only.
3-Year Revenue Growth Rate range over the past 10 years
Min: -0.5, Med: 13, Max: 30.7
Current: 11.1
-0.5
30.7
3-Year Total EBITDA Growth Rate 8.80
3-Year EBITDA Growth Rate ranked higher than
75.00% of 764 companies
in the Home Improvement Stores industry.
Industry Max: 1002.8, Med: 3.9, Min: -359.7
HD: 13
Ranked among companies with meaningful 3-Year EBITDA Growth Rate only.
3-Year EBITDA Growth Rate range over the past 10 years
Min: -9.9, Med: 19.5, Max: 35.9
Current: 13
-9.9
35.9
3-Year EPS w/o NRI Growth Rate 21.20
3-Year EPS w/o NRI Growth Rate ranked higher than
69.69% of 673 companies
in the Home Improvement Stores industry.
Industry Max: 958.1, Med: 4.9, Min: -260
HD: 21.2
Ranked among companies with meaningful 3-Year EPS w/o NRI Growth Rate only.
3-Year EPS w/o NRI Growth Rate range over the past 10 years
Min: -19.5, Med: 21.5, Max: 39.5
Current: 21.2
-19.5
39.5

» HD's 30-Y Financials

Financials (Next Earnings Date: 2019-08-20)

Guru Trades Click for details

» Details

Insider Trades

SEC Filings

Gurus Latest Trades with NYSE:HD

» Interactive Chart

Peter Lynch Chart

Business Description

Industry Retail - Apparel & Specialty » Home Improvement Stores    NAICS : 444110    SIC : 5211
Compare NYSE:LOW ASX:WES TSE:9843 LSE:KGF BKK:HMPRO NYSE:FND BKK:GLOBAL OHEL:FSKRS TSE:3050 PHS:WLCON JSE:ITE TSE:8218 TSE:3191 TSE:7516 SAU:4008 TSE:3564 NYSE:HVT JSE:CSB NYSE:LL TPE:2908
Traded in other countries HOME34.Brazil HDI.Germany 0R1G.UK
Address 2455 Paces Ferry Road, Atlanta, GA, USA, 30339
The Home Depot Inc is the world's largest home improvement specialty retailer, operating nearly 2,300 warehouse-format stores throughout the United States, Canada, and Mexico. The firm's stores offer products and services for home construction, renovation, remodeling, and maintenance. The acquisition of distributor Interline Brands in 2015 allowed the company to enter the maintenance, repair, and operations sector, while the tie up with the Company Store brought textile expertise to the brand.

Ratios

Current vs industry vs history
PE Ratio (TTM) 19.52
PE Ratio ranked lower than
62.85% of 724 companies
in the Home Improvement Stores industry.
Industry Max: 1496, Med: 19.95, Min: 0.07
HD: 19.52
Ranked among companies with meaningful PE Ratio only.
PE Ratio range over the past 10 years
Min: 10.34, Med: 20.94, Max: 28.47
Current: 19.52
10.34
28.47
Forward PE Ratio 19.16
Forward P/E ranked lower than
59.49% of 195 companies
in the Home Improvement Stores industry.
Industry Max: 1428.57, Med: 17.89, Min: 1.41
HD: 19.16
Ranked among companies with meaningful Forward P/E only.
N/A
PE Ratio without NRI 19.52
PE without NRI ranked lower than
62.72% of 727 companies
in the Home Improvement Stores industry.
Industry Max: 1496, Med: 19.89, Min: 0.07
HD: 19.52
Ranked among companies with meaningful PE without NRI only.
PE without NRI range over the past 10 years
Min: 10.34, Med: 20.95, Max: 28.47
Current: 19.52
10.34
28.47
Price-to-Owner-Earnings 18.85
Price-to-Owner-Earnings ranked lower than
57.73% of 440 companies
in the Home Improvement Stores industry.
Industry Max: 27795.98, Med: 19.71, Min: 0.13
HD: 18.85
Ranked among companies with meaningful Price-to-Owner-Earnings only.
Price-to-Owner-Earnings range over the past 10 years
Min: 5.92, Med: 19.44, Max: 48.98
Current: 18.85
5.92
48.98
PS Ratio 2.00
PS Ratio ranked lower than
82.33% of 951 companies
in the Home Improvement Stores industry.
Industry Max: 1625, Med: 0.68, Min: 0.01
HD: 2
Ranked among companies with meaningful PS Ratio only.
PS Ratio range over the past 10 years
Min: 0.42, Med: 1.44, Max: 2.43
Current: 2
0.42
2.43
Price-to-Free-Cash-Flow 19.72
Price-to-Free-Cash-Flow ranked lower than
62.24% of 437 companies
in the Home Improvement Stores industry.
Industry Max: 2398.33, Med: 18.2, Min: 0.28
HD: 19.72
Ranked among companies with meaningful Price-to-Free-Cash-Flow only.
Price-to-Free-Cash-Flow range over the past 10 years
Min: 8.23, Med: 18.69, Max: 24.85
Current: 19.72
8.23
24.85
Price-to-Operating-Cash-Flow 16.00
Price-to-Operating-Cash-Flow ranked lower than
73.91% of 552 companies
in the Home Improvement Stores industry.
Industry Max: 3448.11, Med: 10.71, Min: 0.07
HD: 16
Ranked among companies with meaningful Price-to-Operating-Cash-Flow only.
Price-to-Operating-Cash-Flow range over the past 10 years
Min: 5.49, Med: 15.15, Max: 20.51
Current: 16
5.49
20.51
EV-to-EBIT 15.17
EV-to-EBIT ranked lower than
60.03% of 758 companies
in the Home Improvement Stores industry.
Industry Max: 2564.52, Med: 14.76, Min: 0.01
HD: 15.17
Ranked among companies with meaningful EV-to-EBIT only.
EV-to-EBIT range over the past 10 years
Min: 8, Med: 13.6, Max: 18
Current: 15.17
8
18
EV-to-EBITDA 13.34
EV-to-EBITDA ranked lower than
61.84% of 794 companies
in the Home Improvement Stores industry.
Industry Max: 2564.52, Med: 11.82, Min: 0.01
HD: 13.34
Ranked among companies with meaningful EV-to-EBITDA only.
EV-to-EBITDA range over the past 10 years
Min: 6, Med: 11.4, Max: 15.8
Current: 13.34
6
15.8
EV-to-Revenue 2.19
EV-to-Revenue ranked lower than
82.31% of 961 companies
in the Home Improvement Stores industry.
Industry Max: 371655.07, Med: 0.77, Min: 0.01
HD: 2.19
Ranked among companies with meaningful EV-to-Revenue only.
EV-to-Revenue range over the past 10 years
Min: 0.6, Med: 1.5, Max: 2.6
Current: 2.19
0.6
2.6
PEG Ratio 1.28
PEG Ratio ranked higher than
62.19% of 320 companies
in the Home Improvement Stores industry.
Industry Max: 187.5, Med: 2.07, Min: 0.03
HD: 1.28
Ranked among companies with meaningful PEG Ratio only.
PEG Ratio range over the past 10 years
Min: 0.99, Med: 1.26, Max: 24.51
Current: 1.28
0.99
24.51
Shiller PE Ratio 37.58
Shiller PE Ratio ranked lower than
87.54% of 321 companies
in the Home Improvement Stores industry.
Industry Max: 5921.05, Med: 18.09, Min: 0.06
HD: 37.58
Ranked among companies with meaningful Shiller PE Ratio only.
Shiller PE Ratio range over the past 10 years
Min: 8.86, Med: 29.33, Max: 51.68
Current: 37.58
8.86
51.68
Current Ratio 1.04
Current Ratio ranked lower than
70.58% of 972 companies
in the Home Improvement Stores industry.
Industry Max: 2533.92, Med: 1.63, Min: 0.01
HD: 1.04
Ranked among companies with meaningful Current Ratio only.
Current Ratio range over the past 10 years
Min: 1.04, Med: 1.44, Max: 2.35
Current: 1.04
1.04
2.35
Quick Ratio 0.26
Quick Ratio ranked lower than
83.54% of 972 companies
in the Home Improvement Stores industry.
Industry Max: 2533.92, Med: 0.94, Min: -1.65
HD: 0.26
Ranked among companies with meaningful Quick Ratio only.
Quick Ratio range over the past 10 years
Min: 0.2, Med: 0.41, Max: 1.27
Current: 0.26
0.2
1.27
Days Inventory 73.58
Days Inventory ranked higher than
55.97% of 938 companies
in the Home Improvement Stores industry.
Industry Max: 12045, Med: 83.79, Min: 0.03
HD: 73.58
Ranked among companies with meaningful Days Inventory only.
Days Inventory range over the past 10 years
Min: 68.52, Med: 75.15, Max: 86.99
Current: 73.58
68.52
86.99
Days Sales Outstanding 7.71
Days Sales Outstanding ranked higher than
66.74% of 932 companies
in the Home Improvement Stores industry.
Industry Max: 958.18, Med: 16.1, Min: 0.02
HD: 7.71
Ranked among companies with meaningful Days Sales Outstanding only.
Days Sales Outstanding range over the past 10 years
Min: 5.53, Med: 6.47, Max: 7.79
Current: 7.71
5.53
7.79
Days Payable 52.22
Days Payable ranked higher than
50.81% of 925 companies
in the Home Improvement Stores industry.
Industry Max: 376278.5, Med: 52.44, Min: 0.01
HD: 52.22
Ranked among companies with meaningful Days Payable only.
Days Payable range over the past 10 years
Min: 38.42, Med: 39.98, Max: 41.13
Current: 52.22
38.42
41.13

Dividend & Buy Back

Current vs industry vs history
Dividend Yield % 2.30
Trailing Dividend Yield ranked lower than
58.70% of 1058 companies
in the Home Improvement Stores industry.
Industry Max: 270.18, Med: 2.29, Min: 0.06
HD: 2.3
Ranked among companies with meaningful Trailing Dividend Yield only.
Trailing Dividend Yield range over the past 10 years
Min: 1.6, Med: 2.05, Max: 5
Current: 2.3
1.6
5
Dividend Payout Ratio 0.45
Dividend Payout Ratio ranked higher than
99.01% of 608 companies
in the Home Improvement Stores industry.
Industry Max: 125.93, Med: 0.4, Min: 0.01
HD: 0.45
Ranked among companies with meaningful Dividend Payout Ratio only.
Dividend Payout Ratio range over the past 10 years
Min: 0.39, Med: 0.43, Max: 0.58
Current: 0.45
0.39
0.58
3-Year Dividend Growth Rate (Per Share) 20.40
3-Year Dividend Growth Rate ranked higher than
84.37% of 416 companies
in the Home Improvement Stores industry.
Industry Max: 157.1, Med: 4.1, Min: -100
HD: 20.4
Ranked among companies with meaningful 3-Year Dividend Growth Rate only.
3-Year Dividend Growth Rate range over the past 10 years
Min: 1.6, Med: 24, Max: 152
Current: 20.4
1.6
152
Forward Dividend Yield % 2.81
Forward Dividend Yield ranked lower than
54.10% of 1037 companies
in the Home Improvement Stores industry.
Industry Max: 70.37, Med: 2.29, Min: 0.06
HD: 2.81
Ranked among companies with meaningful Forward Dividend Yield only.
N/A
Yield-on-Cost (5-Year) % 6.22
Yield-on-Cost (5y) ranked higher than
79.62% of 1055 companies
in the Home Improvement Stores industry.
Industry Max: 271.03, Med: 3.12, Min: 0.04
HD: 6.22
Ranked among companies with meaningful Yield-on-Cost (5y) only.
Yield-on-Cost (5y) range over the past 10 years
Min: 4.31, Med: 5.52, Max: 13.46
Current: 6.22
4.31
13.46
3-Year Share Buyback Rate 3.40
3-Year Share Buyback Rate ranked higher than
93.66% of 568 companies
in the Home Improvement Stores industry.
Industry Max: 100, Med: -0.7, Min: -1900
HD: 3.4
Ranked among companies with meaningful 3-Year Share Buyback Rate only.
3-Year Share Buyback Rate range over the past 10 years
Min: -8.7, Med: 2.3, Max: 8.2
Current: 3.4
-8.7
8.2

Valuation & Return

Current vs industry vs history
Price-to-Projected-FCF 1.76
Price-to-Intrinsic-Value-Projected-FCF ranked lower than
72.04% of 558 companies
in the Home Improvement Stores industry.
Industry Max: 262.66, Med: 1.23, Min: 0.02
HD: 1.76
Ranked among companies with meaningful Price-to-Intrinsic-Value-Projected-FCF only.
Price-to-Intrinsic-Value-Projected-FCF range over the past 10 years
Min: 0.77, Med: 1.76, Max: 336.17
Current: 1.76
0.77
336.17
Price-to-DCF (Earnings Based) 0.69
Price-to-Intrinsic-Value-DCF (Earnings Based) ranked higher than
58.42% of 101 companies
in the Home Improvement Stores industry.
Industry Max: 13.97, Med: 1.16, Min: 0.26
HD: 0.69
Ranked among companies with meaningful Price-to-Intrinsic-Value-DCF (Earnings Based) only.
Price-to-Intrinsic-Value-DCF (Earnings Based) range over the past 10 years
Min: 0.44, Med: 0.74, Max: 2.18
Current: 0.69
0.44
2.18
Price-to-Median-PS-Value 1.39
Price-to-Median-PS-Value ranked lower than
83.96% of 854 companies
in the Home Improvement Stores industry.
Industry Max: 33.08, Med: 1, Min: 0.01
HD: 1.39
Ranked among companies with meaningful Price-to-Median-PS-Value only.
Price-to-Median-PS-Value range over the past 10 years
Min: 0.35, Med: 0.99, Max: 2.4
Current: 1.39
0.35
2.4
Price-to-Peter-Lynch-Fair-Value 1.34
Price-to-Peter-Lynch-Fair-Value ranked lower than
52.43% of 185 companies
in the Home Improvement Stores industry.
Industry Max: 31.27, Med: 1.36, Min: 0.06
HD: 1.34
Ranked among companies with meaningful Price-to-Peter-Lynch-Fair-Value only.
Price-to-Peter-Lynch-Fair-Value range over the past 10 years
Min: 0.6, Med: 1.21, Max: 3.72
Current: 1.34
0.6
3.72
Earnings Yield (Joel Greenblatt) % 6.59
Earnings Yield (Greenblatt) ranked higher than
53.95% of 988 companies
in the Home Improvement Stores industry.
Industry Max: 10000, Med: 5.31, Min: -1666.67
HD: 6.59
Ranked among companies with meaningful Earnings Yield (Greenblatt) only.
Earnings Yield (Greenblatt) range over the past 10 years
Min: 5.6, Med: 7.4, Max: 12.5
Current: 6.59
5.6
12.5
Forward Rate of Return (Yacktman) % 18.45
Forward Rate of Return ranked higher than
87.56% of 595 companies
in the Home Improvement Stores industry.
Industry Max: 421.03, Med: 5.78, Min: -16918.52
HD: 18.45
Ranked among companies with meaningful Forward Rate of Return only.
Forward Rate of Return range over the past 10 years
Min: -2, Med: 18.9, Max: 23.6
Current: 18.45
-2
23.6

More Statistics

Revenue (TTM) (Mil) $ 109,637
EPS (TTM) $ 9.92
Beta 1.24
Volatility % 20.54
52-Week Range $ 158.09 - 215.43
Shares Outstanding (Mil) 1,102.74

Analyst Estimate

Piotroski F-Score Details

Piotroski F-Score 7
Positive ROA Y
Positive CFROA Y
Higher ROA yoy Y
CFROA > ROA Y
Lower Leverage yoy N
Higher Current Ratio yoy N
Less Shares Outstanding yoy Y
Higher Gross Margin yoy Y
Higher Asset Turnover yoy Y