Home Depot (HD) valuation

Run six valuation models on Home Depot with live data: DCF, Reverse DCF, Graham number, Monte Carlo, scenarios and sum-of-the-parts (NAV).

HD
HD

Home Depot

HD · Consumer Cyclical

Current price

337,59 USD

𝕏 Share on X
You're trying every model for free, no account needed. Sign up to save your analyses →

Valuation

Market cap
336.81 B USD
PE (TTM | NTM | +1y)
23.62 | 21.23 | 21.23
Price / Sales
2.00
EV / EBITDA
16.55
Price / Book
20.28

Cash flow

FCF yield(10.79 / 337.59)
+3.2%
SBC-adjusted FCF yield
—
SBC impact
—

Margins & growth

Profit margin
+8.41%
Operating margin
+12.02%
Quarterly earnings (YoY)
+4.72%
Quarterly revenue (YoY)
+5.71%

Balance

Cash
2.08 B USD
Debt
63.19 B USD
Net position
-61.10 B USD

Dividend

Dividend yield
+2.68%
Payout ratio
+64.8%
Next payout
9/17/2026

Price (5 years)

-16.86%
431.37 USD

What the market paid for its earnings

P/E (TTM)23.8×
202530Its own median 23.1×Its own mean 22.5×20212026

Each week's price divided by the earnings per share already reported by that date — four quarters where a company reports them, its last full year otherwise. Loss-making weeks are not drawn. Both lines are the company's own: the median is where it traded in half its weeks, the mean is where the extremes pull that average to. A mean well above the median means the high ratings were occasional rather than usual.

What the market paid for the year ahead

Forward P/E21.4×
202530Its own median 22.3×Its own mean 22.8×20212026

Each week's price divided by the earnings of the year still ahead of it. Those years have since happened, so this is the multiple paid against the figure that landed: nobody records what analysts expected at the time. The most recent stretch uses today's consensus. Both lines are the company's own: the median is where it traded in half its weeks, the mean is where the extremes pull that average to. A mean well above the median means the high ratings were occasional rather than usual.

What analysts expect

Consensus revenue and earnings per share for the periods not yet reported.

Revenue forecast

ReportedEstimate
020B40BQ4 25: 41.35 B USDQ4 25Q1 26: 38.20 B USDQ1 26Q2 26: 41.77 B USDQ2 26Q3 26: 47.86 B USDQ3 26Q4 26 · Estimate: 42.78 B USD (41.96 B USD – 43.69 B USD)Q4 26Q1 27 · Estimate: 39.13 B USD (38.39 B USD – 39.58 B USD)Q1 27USD

Consensus of 27 analysts for Q4 26 · +3.45% year on year

EPS forecast

ReportedEstimate
024Q4 25: 3.74 · expected 3.83 (-2.45%)Q4 25Q1 26: 2.72 · expected 2.52 (+7.8%)Q1 26Q2 26: 3.43 · expected 3.41 (+0.69%)Q2 26Q3 26: 4.92 · expected 4.73 (+3.97%)Q3 26Q4 26 · Estimate: 3.84 (3.71 – 4.05)Q4 26Q1 27 · Estimate: 2.82 (2.70 – 2.94)Q1 27

Consensus of 30 analysts for Q4 26 · +2.62% year on year · adjusted earnings

Analyst consensus from Yahoo Finance. The dashed bar is the average and the whisker runs from the lowest analyst to the highest. On periods already reported, the green or red line marks what had been expected: below the bar means the company beat it. EPS is measured on an adjusted basis, which is what analysts forecast against and is not the accounting profit in the statements.

Revenue

estimate
020B40BQ2 23: 37.26 B USDQ2 23Q3 23: 42.92 B USDQ4 23: 37.71 B USDQ1 24: 34.79 B USDQ1 24Q2 24: 36.42 B USDQ3 24: 43.18 B USDQ4 24: 40.22 B USDQ4 24Q1 25: 39.70 B USDQ3 25: 45.28 B USDQ4 25: 41.35 B USDQ4 25Q1 26: 38.20 B USDQ2 26: 41.77 B USDQ3 26: 47.86 B USDQ3 26Q4 26 · estimate: 42.78 B USDQ4 26USD

EBITDA

03B5B8BQ2 23: 6.34 B USDQ2 23Q3 23: 7.24 B USDQ4 23: 6.09 B USDQ1 24: 4.93 B USDQ1 24Q2 24: 5.86 B USDQ3 24: 7.27 B USDQ4 24: 6.21 B USDQ4 24Q1 25: 5.51 B USDQ3 25: 7.58 B USDQ4 25: 6.43 B USDQ4 25Q1 26: 4.97 B USDQ2 26: 6.07 B USDQ3 26: 8.01 B USDQ3 26USD

Net income

02B4BQ2 23: 3.87 B USDQ2 23Q3 23: 4.66 B USDQ4 23: 3.81 B USDQ1 24: 2.80 B USDQ1 24Q2 24: 3.60 B USDQ3 24: 4.56 B USDQ4 24: 3.65 B USDQ4 24Q1 25: 3.00 B USDQ3 25: 4.55 B USDQ4 25: 3.60 B USDQ4 25Q1 26: 2.57 B USDQ2 26: 3.29 B USDQ3 26: 4.77 B USDQ3 26USD

Free cash flow

02B4BQ2 23: 4.71 B USDQ2 23Q3 23: 5.80 B USDQ4 23: 3.56 B USDQ1 24: 3.88 B USDQ1 24Q2 24: 4.65 B USDQ3 24: 4.69 B USDQ4 24: 3.42 B USDQ4 24Q1 25: 3.57 B USDQ3 25: 3.73 B USDQ4 25: 3.11 B USDQ4 25Q1 26: 2.29 B USDQ2 26: 5.19 B USDQ3 26: 4.51 B USDQ3 26USD

EPS

024Q2 23: 3.82Q2 23Q3 23: 4.65Q4 23: 3.81Q1 24: 2.83Q1 24Q2 24: 3.63Q3 24: 4.60Q4 24: 3.67Q4 24Q1 25: 3.01Q3 25: 4.58Q4 25: 3.62Q4 25Q1 26: 2.58Q2 26: 3.30Q3 26: 4.79Q3 26

Cash & debt

CashDebt
020B40B60BQ2 23 · Cash: 1.26 B USDQ2 23Q3 23 · Cash: 2.81 B USDQ4 23 · Cash: 2.06 B USDQ1 24 · Cash: 3.76 B USDQ1 24Q2 24 · Cash: 4.26 B USDQ3 24 · Cash: 1.61 B USDQ4 24 · Cash: 1.53 B USDQ4 24Q1 25 · Cash: 1.66 B USDQ3 25 · Cash: 2.80 B USDQ3 25 · Debt: 61.32 B USDQ4 25 · Cash: 1.68 B USDQ4 25 · Debt: 65.42 B USDQ4 25Q1 26 · Cash: 1.39 B USDQ1 26 · Debt: 65.35 B USDQ2 26 · Cash: 1.60 B USDQ2 26 · Debt: 63.16 B USDQ3 26 · Cash: 2.09 B USDQ3 26 · Debt: 62.57 B USDQ3 26USD

Return of capital

DividendsBuybacks
02B4BQ2 23 · Dividends: 2.12 B USDQ2 23 · Buybacks: 2.89 B USDQ2 23Q3 23 · Dividends: 2.10 B USDQ3 23 · Buybacks: 2.07 B USDQ4 23 · Dividends: 2.09 B USDQ4 23 · Buybacks: 1.51 B USDQ1 24 · Dividends: 2.08 B USDQ1 24 · Buybacks: 1.49 B USDQ1 24Q2 24 · Dividends: 2.23 B USDQ2 24 · Buybacks: 649.00 M USDQ3 24 · Dividends: 2.23 B USDQ3 24 · Buybacks: 0.00 USDQ4 24 · Dividends: 2.23 B USDQ4 24 · Buybacks: 0.00 USDQ4 24Q1 25 · Dividends: 2.24 B USDQ1 25 · Buybacks: 0.00 USDQ3 25 · Dividends: 2.29 B USDQ4 25 · Dividends: 2.29 B USDQ4 25Q1 26 · Dividends: 2.29 B USDQ2 26 · Dividends: 2.32 B USDQ3 26 · Dividends: 2.32 B USDQ3 26USD

Stock-based compensation

050M100M150MQ2 23: 124.00 M USDQ2 23Q3 23: 91.00 M USDQ4 23: 85.00 M USDQ1 24: 80.00 M USDQ1 24Q2 24: 124.00 M USDQ3 24: 98.00 M USDQ4 24: 106.00 M USDQ4 24Q1 25: 114.00 M USDQ3 25: 118.00 M USDQ4 25: 120.00 M USDQ4 25Q1 26: 114.00 M USDQ2 26: 178.00 M USDQ3 26: 148.00 M USDQ3 26USD

Operating expenses

R&DSG&A
03B5B8BQ2 23 · SG&A: 6.36 B USDQ2 23Q3 23 · SG&A: 6.92 B USDQ4 23 · SG&A: 6.65 B USDQ1 24 · SG&A: 6.68 B USDQ1 24Q2 24 · SG&A: 6.67 B USDQ3 24 · SG&A: 7.14 B USDQ4 24 · SG&A: 7.21 B USDQ4 24Q1 25 · SG&A: 7.73 B USDQ3 25 · SG&A: 7.76 B USDQ4 25 · SG&A: 7.64 B USDQ4 25Q1 26 · SG&A: 7.77 B USDQ2 26 · SG&A: 7.96 B USDQ3 26 · SG&A: 8.42 B USDQ3 26USD

Source: Yahoo Finance. Quarterly history grows automatically over time as new quarters are published.

Popular companies