The Home Depot Inc

XTER : HDI
USA·Consumer Cyclical·Retail - Cyclical·Ordinary Shares
€308.25
−4.90 (−1.56%)latest daily quote
Market Cap
€306.87B
Enterprise Value
€361.97B
P/E (TTM)
25.15
P/B
27.81
Net Cash / (Debt)
−€54.43B
52-Week Range
—
5-Year Range
—
Avg Volume (3M)
245

Home Depot sells home improvement materials, building supplies, tools, appliances, lawn and garden products, and décor through ~2,300 large-format retail stores across the US, Canada, and Mexico, plus an online store with roughly 1 million SKUs. Customers are a mix of DIY homeowners and professional contractors. Revenue comes from direct product sales and, to a lesser extent, installation services and tool/equipment rentals. Through acquisitions of HD Supply, SRS Distribution, and GMS, the company has expanded beyond retail into wholesale distribution of maintenance/repair supplies and specialty building products (roofing, pools, landscaping, wallboard) sold primarily to professional contractors through distribution centers.

Employees470,100IPOOct 28, 1999SIC5211HQ2455 Paces Ferry Road, Atlanta, GA, USA, 30339
to

Financials (EUR)

Profitability

Metric
Current
Margins
Gross Margin
33.3%
Operating Margin
12.7%
EBITDA Margin
15.3%
Net Margin
8.6%
OCF Margin
9.9%
FCF Margin
7.7%
Returns on Capital
ROE
141.0%
ROA
14.0%
ROIC
19.9%
ROCE
30.1%
ROC (Greenblatt)
46.6%
3Y ROIIC
−7.1%
Consistency
Years Profitable / 10Y
10

Valuation

Metric
Current
Earnings Multiples
P/E (TTM)
25.15
Forward P/E
24.04
P/E ex-NRI
24.35
Shiller P/E (CAPE)
25.32
Cash Flow Multiples
P/FCF
28.15
P/OCF
21.80
P/Owner Earnings
28.12
FCF Yield
3.55%
Enterprise Value Multiples
EV / EBIT
19.99
EV / Forward EBIT
19.08
EV / EBITDA
16.71
EV / Forward EBITDA
16.52
EV / Revenue
2.55
EV / Forward Revenue
2.46
Asset / Sales
P/S
2.16
P/B
27.81
P/Tangible Book
—
Growth-Adjusted
PEG
5.94

Capital Returns

Metric
Current
Dividends
Dividend Yield (TTM)
2.61%
Forward Dividend Yield
2.55%
3Y Dividend Growth
6.6%
Payout Ratio
0.63
5Y Yield on Cost
4.11%
Buybacks & Dilution
3Y Buyback Ratio
0.70%
Combined
Shareholder Yield
1.63%

Balance Sheet

Metric
Current
Leverage
Debt / Equity
5.10
Gross Debt / EBITDA
2.60
Cash / Debt
0.02
Equity / Assets
0.12
Coverage
Interest Coverage
8.66
Short-Term Liquidity
Current Ratio
1.06
Quick Ratio
0.26
Cash Ratio
0.04
Composite Scores
Piotroski F-Score
5
Altman Z-Score
4.57

5-Step DuPont Analysis

ROE %
141.32%
Net Margin %
8.60%
Operating Margin %
12.69%
Operating Income
€18.06B
÷
Revenue
€142.30B
×
Tax Burden
0.7609
Net Income
€12.24B
÷
Pretax Income
€16.08B
×
Interest Burden
0.8905
Pretax Income
€16.08B
÷
Operating Income
€18.06B
×
Asset Turnover
1.56
Revenue
€142.30B
÷
Average Total Assets
€91.14B
Begin Total Assets
€92.85B
End Total Assets
€89.44B
×
Equity Multiplier
10.53
Avg Total Assets
€91.14B
÷
Avg Stockholders Equity
€8.66B
Begin Equity
€6.41B
End Equity
€10.90B