Pricing Log in Create free account
Friday 6 November 2026 Export HD’s income statement to Excel — free account

The Home Depot, Inc.

HD Consumer Cyclical Home Improvement Retail

The Home Depot, Inc.’s revenue for fiscal 2026 (year ended January 2026) was $164.7 billion, up 3.24% from fiscal 2025.

Revenue
+5.71%
EPS
+4.36%
Free cash flow
+21.0%
Total debt
+1.11%

Quarter to July 2026, against a year earlier

349.34 6.10 −1.72%
Market cap
$349.1B
P/E
24.4×
Fwd P/E
22.7×
Dividend yield
2.66%
F-score
4/9
Altman Z
5.92
Beneish M
−2.42
Dividend safety
64/100
Overview Business Profile Earnings & Analysis
Financials
Income Statement Balance Sheet Cash Flow Metrics & Ratios
Segments Valuation Filings

The Home Depot, Inc. (HD) valuation and DCF model

What the price implies · reverse DCF

At $349.34 the price implies free cash flow after share-based pay growing 9.8% a year for ten years.

Free cash flow after share-based pay grew 6.7% a year over the last ten years, −1.4% over the last five. The price asks for close to its ten-year rate. The industry’s median company is priced for 9.6%.

In January 2017 the price assumed 7.8% a year; The Home Depot, Inc. went on to grow free cash flow after share-based pay 4.8% a year to FY2026.

Price implies
9.8%
Last 5 years, reported
−1.4%
Last 10 years, reported
6.7%
Industry median implies
9.6%

The headline discounts the last twelve months’ free cash flow after share-based pay at 9.0% for ten years and grows it 2.5% a year after that, the same for every company, so the figure compares across the market (how a reverse DCF works).

The other way round · DCF
The price needs
9.8% a year for ten years
$349.34
today’s price
Its base case
6.7% a year for five years, then 4.0%
$238.81
31.6% below today’s price

Both are growth in free cash flow after share-based pay, discounted at 9.0%, with 2.5% a year after year ten.

Base case on its own ten-year record The Home Depot, Inc.’s own growth, carried forward

Its assumptions

Powerpack lets you start from a scenario and type over any of them.

The base case’s inputs, which Powerpack lets you change
1 · Cash flow to equity
the four quarters to July 2026, from the 10-Q and 10-K filings, before share-based pay

Yearly growth in cash flow. It usually slows as the company matures.

Today’s price implies free cash flow after share-based pay growing 9.8% a year for ten years.

2 · Rates

Cost of equity is the yearly return shareholders require, typically 8–11%. Terminal growth is growth forever after year 10, usually near long-run inflation, 2–3%.

3 · Per share

Diluted shares outstanding. Net debt, under Advanced inputs, is taken off before dividing.

Advanced inputs
Free cash flow Revenue and margin
negative is net cash
new shares the cash flow does not pay for

Against The Home Depot, Inc.’s own cost of capital: risk-free 4.3% + beta 0.95 × equity premium 4.5% = 8.6% cost of equity; weighted, 8.6%.

Use 8.6%
Equity value $237.73b ▼ below market cap $347.77b
Base case value per share $238.81 equity value ÷ 995.50m shares
Current price $349.34 market price per share
Below today’s price 31.6% downside at the base case’s assumptions

How we got there$125.23b 10 years of cash to equity+$163.32b terminal value−$50.81b net debt=$237.73b equity value÷995.50m shares=$238.81 per share

Valuation against its own history

Today’s multiple against its 5- and 10-year averages and the industry median (Home Improvement Retail).

Multiple Current 5Y avg 10Y avg vs 10Y avg Industry median vs industry 10Y range
P/E 24.40× 24.22× 23.56× 4% above 20.64× 18% above
P/FCF 23.00× 25.23× 23.68× 3% below 16.05× 43% above
P/B 20.90× 132.29× 118.90× 82% below 1.40× 1392% above
EV/EBITDA 15.71× 16.12× 15.66× 0% above 9.57× 64% above
EV/Sales 2.35× 2.56× 2.53× 7% below 0.55× 329% above
P/E P/FCF P/B EV/EBITDA EV/Sales
56.20×141.47×226.73×312.00×10Y avg 118.90×20172018202120232024202520262026

HD trades at 20.90× P/B, against a 10-year average of 118.90× (range 20.90×–337.75×). That is cheaper than 100% of the last 7 year-end readings; re-rating to the average implies $1,987.65 per share.

Every growth rate on this page is the business’s — its cash flow, FFO or dividend — never its share price’s. A discounted-cash-flow model is only as good as its assumptions. Figures from the 10-K and 10-Q filings. Not investment advice.