Knowstox

Fundamentals snapshot

The Home Depot, Inc.

HD · NYQ · Consumer Cyclical · Home Improvement Retail

Current price

$309.71

52-week range

$289.10 - $426.75

Market cap

$308.82B

One-glance verdict

Overvalued

$216.15 vs market $309.71

Fair-value range $200.38 – $259.52 (cautious → optimistic — tap the ? for the math)

Wall Street consensus: $370.18 (71.3% higher than our fair-value estimate)

Buy below $172.92 for a 20% safety cushion

Balance sheet

Distressed

8.66x Adequate

Net debt $62.13B. Interest coverage shows how many times profit covers the interest bill.

What this company does

The Home Depot, Inc.

The Home Depot is a giant home improvement store where people buy everything from lumber and paint to kitchen appliances and garden supplies. It makes money from both everyday homeowners working on weekend projects and professional contractors who buy materials in bulk for their businesses. The company's success is often tied to the housing market, as more people buy and fix up homes when the economy is strong.

Price history

How the share price has moved

Loading price history…

Earnings history

Last 8 quarters — what happened

Click any quarter to read the call summary and what the numbers say.

Free cash flow by quarter (oldest to newest)
FY2025 Q2 $4.69B FY2025 Q3 $3.42B FY2025 Q4 $3.57B FY2026 Q1 $3.52B FY2026 Q2 $3.73B FY2026 Q3 $3.11B FY2026 Q4 $2.29B FY2027 Q1 $5.19B
Revenue $41.77B
Net income $3.29B
Diluted EPS 3.30
Operating cash flow $6.03B
Free cash flow $5.19B
Revenue $38.20B
Net income $2.57B
Diluted EPS 2.58
Operating cash flow $3.35B
Free cash flow $2.29B
Revenue $41.35B
Net income $3.60B
Diluted EPS 3.62
Operating cash flow $4.01B
Free cash flow $3.11B
Revenue $45.28B
Net income $4.55B
Diluted EPS 4.58
Operating cash flow $4.64B
Free cash flow $3.73B
Revenue $39.86B
Net income $3.43B
Diluted EPS 3.45
Operating cash flow $4.33B
Free cash flow $3.52B
Revenue $39.70B
Net income $3.00B
Diluted EPS 3.01
Operating cash flow $4.67B
Free cash flow $3.57B
Revenue $40.22B
Net income $3.65B
Diluted EPS 3.67
Operating cash flow $4.23B
Free cash flow $3.42B
Revenue $43.17B
Net income $4.56B
Diluted EPS 4.60
Operating cash flow $5.41B
Free cash flow $4.69B

Is it cheap or expensive?

Fair value $216.15 vs current price $309.71

Wall Street consensus is the average analyst price target: $370.18 (71.3% higher than our fair-value estimate).

Buy below $172.92 for a 20% safety cushion. That means buying at least 20% below our fair value, as a buffer in case our estimate turns out too rosy.

Our most-likely fair value is $216.15 a share — about 30.2% below today's price of $309.71, so the stock currently looks expensive (overvalued).

overvalued

We estimate the cash this business should generate over the next 10 years and beyond, then convert it to today's money for a fair value per share, in its trading currency. Cautious, middle and optimistic growth cases give a range. Not for banks/insurers.

Base

Growth 3.5% · Discount 8.0% · Terminal 2.5%

$216.15

Bear

Growth 2.5% · Discount 8.0% · Terminal 2.5%

$200.38

Bull

Growth 6.0% · Discount 8.0% · Terminal 2.5%

$259.52

Is it drowning in debt?

Distressed

Net debt $62.1B. Interest coverage 8.7x.

Net debt $62.13B
Interest coverage 8.66x

The Home Depot, Inc.'s profit covers its interest bill about 8.7 times over. which is stronger than most peers shown here.

Distressed
Worse cushion Baseline Better cushion
HD BASELINE The Home Depot, Inc.

Total debt $63.73B Interest coverage 8.66x This is the baseline the peer rows are being compared against.

Total debt $42.56B Interest coverage 6.65x -23% vs HD Carries about 1.3x less debt cushion than HD.

Total debt $14.60B Interest coverage 8.16x -6% vs HD Has roughly the same debt cushion as HD.

Total debt $2.01B Interest coverage 23.97x +177% vs HD Carries about 2.8x more debt cushion than HD.

Total debt $5.29B Interest coverage 2.87x -67% vs HD Carries about 3.0x less debt cushion than HD.

What you should know

The case for and against HD

3 Rewards 3 Risks

Rewards

  • Revenue grew 1.2% last year.
  • Returns 128.4% on equity, ahead of 75% of its peers.
  • Free cash flow was positive in 10/10 years.

Risks

  • Net debt grew 34.4% over 3 years.
  • Operating margin compressed from 15.3% to 11.9% over 3 years.
  • Insider ownership is only 0.1% (peer median: 2.0%).

The numbers

All the key metrics, grouped by purpose

Tap any ? icon to learn what it means.

Valuation

How expensive the stock looks

P/E (TTM)
22.00x
Forward P/E
19.23x
P/B
22.26x
P/S
1.85x
EV/EBITDA
14.91x
PEG ratio
1.75x

Profitability

How much profit each dollar creates

Gross margin
33.1%
Operating margin
11.9%
Net margin
8.4%
ROE
128.4%
ROA
12.5%

Health

Liquidity and balance-sheet strength

Debt / equity
4.59x
Current ratio
1.04x
Quick ratio
0.23x
Total debt
$63.73B
Total cash
$1.60B

Growth

How the business has been compounding

Revenue TTM
$166.59B
Revenue 5Y CAGR
2.2%
EPS TTM
14.08
EPS 5Y CAGR
-5.2%

Cash flow

How much cash the business throws off

Operating CF TTM
$18.03B
Free CF TTM
$12.65B
FCF margin
7.6%

Dividend

Shareholder payout

Yield
3.0%
Payout ratio
65.5%
Last ex-div date
2026-06-04