Home Depot

HD · NYSE · Home improvement retail
Close · 2026-11-17
As of 2026-11-18PDF

Fair value · base case

Range –
Above our whole range

Shares trade above the model’s bull-case fair value.

Price vs. our range

Bear $94Base $172Bull $292Price $339.01
Market cap
P/E
FY2026 diluted EPS
FCF yield
Free cash flow divided by market cap
Net debt
Cash, investments and debt

What matters

Select an underlined figure or citation to see its source.

Operating margin weakened

Operating margin fell to from as revenue growth slowed and costs weighed.

Payout burden eased materially

Shareholder payout as a share of free cash flow declined to from , leaving more cash inside the business.

Price and base fair value

Shares trade at , with a base fair value of .

Key risks can erode value

Housing downturns and supply chain disruptions can lower demand and raise costs, reducing expected cash flows .
298 reported figures6 assumptionsConfidence Medium

Business and products

Home Depot sells home improvement products, building materials, garden and décor goods, and MRO products in stores and online . It also offers installation services and tool rental .

  • Consumers include do-it-yourself homeowners and do-it-for-me homeowners who hire Pros .
  • Pros are professional renovators, contractors, homebuilders, maintenance workers, and specialty tradespeople .
Show allShow less
  • The company invests in an interconnected shopping experience across stores, online, mobile, and job sites .
  • It seeks growth with Pros through tailored digital tools, delivery, credit, and loyalty offerings .
  • Supply chain and store investments aim to improve product availability and delivery speed .

Valuation ranges

Each bar shows the range a method supports.

Supported rangePriceBase case
$100$200$300$400Price $339.01DCFBear to bull$94$292Closing pricesPrice history$281.15$391.05

· of explicit projections

How we got the discount rate

Risk-free rate · Live Treasury
Beta
Equity risk premium
WACC

How sensitive is it?

Fair value per share under different discount rates and long-run growth.

Rate ↓ Growth →2.0%2.5%3.0%3.5%4.0%9.0%$175$188$202$219$2399.4%$163$174$186$201$2189.8%$152$161$172$185$19910.2%$142$150$160$171$18310.6%$133$140$149$158$169
Below priceAbove priceOutlined = current case

Build your own view

Adjust the assumptions to see how they change fair value.

Base case: Modest comparable sales and GMS contribution support growth, with margin steady as tariff mitigation offsets cost pressure .
Five-year revenue CAGR
Historical growth anchor
Starts from and reaches the target in year five.
Higher = you demand more return for the risk
Projection horizon
Your fair value
$172
49% below the close of
What the market is betting on

The closing price implies 13.9% revenue growth next year.

Show the math
Starting cash flow
Year-five cash-flow margin8.79%
Present value of 20 years of cash flow$159.71B
Present value of cash flow after year 20$62.02B
Net debt
Shares outstanding
Fair value per share$172

Financial history

Annual figures from SEC filings.

Revenue

FY2026
FY2022FY2026

Operating margin

FY2026
FY2022FY2026

Free cash flow (levered, simple)

FY2026
FY2022FY2026

Diluted EPS

FY2026
FY2022FY2026

The numbers

Select a figure to see where it came from.

Net debt
MetricFY2022FY2023FY2024FY2025FY2026
Revenue
Operating income
Net income
Operating cash flow
Capital expenditure
Share repurchases
Dividends
Free cash flow

Key risks

Ranked by impact on fair value. Tap to expand.

HighHousing downturn can reduce demand and fair value
Weak housing and home improvement markets can cut customer confidence and demand, lowering sales and earnings .

Lower demand can reduce expected cash flows and fair value.

HighSupply chain disruptions can raise costs
Supply chain disruptions and tariffs can delay inventory, raise costs, and hurt sales and margins .

Higher costs and lost sales can lower expected cash flows.

ElevatedCompetition can pressure prices and market share
Highly fragmented retail competition can pressure prices, demand, and market share, weakening revenue and margins .

Price pressure can shrink margins and fair value.

ElevatedTechnology failures can disrupt sales and trust
Technology outages or cyber attacks can disrupt sales, payments, and data, raising costs and damaging reputation .

Outages can reduce sales and raise repair costs.

ElevatedBrand damage can hurt traffic and hiring
Damage to brand or reputation can hurt customer traffic, hiring, supplier ties, and stock price .

Reputation damage can reduce traffic and cash generation.

ModerateLabor pressure can raise costs and hurt service
Labor shortages and wage pressure can raise training costs and weaken customer service, hurting sales .

Higher labor costs can pressure margins and cash generation.

Where this comes from

Numbers are calculated by code from these sources. The AI writes explanations only.

Source
HOME DEPOT, INC. Form 10-K filed 2026-03-18
Accession
0001628280-26-019436
Open source ↗
Source
Yahoo Finance (HD) — development-only price feed; not for redistribution
Locator
2026-11-17
Open source ↗
Source
U.S. Treasury Daily Par Yield Curve Rates
Locator
2026-11-17, 10 Yr
Open source ↗
Source
Aswath Damodaran, NYU Stern — Monthly U.S. implied equity risk premiums (2026-11-01)
Locator
Historical ERP / ERP (T12 m with sustainable payout)
Open source ↗
Source
Aswath Damodaran, NYU Stern — Monthly U.S. implied equity risk premiums (2026-11-01)
Locator
Historical ERP / T.Bond Rate
Open source ↗
Source
Aswath Damodaran, NYU Stern — U.S. industry betas (2026-01-05)
Locator
Industry Averages / Retail (Building Supply) / Unlevered beta corrected for cash
Open source ↗

What this report checked

Standard report

Company lookupDone
Annual filingDone
Filing figuresDone
Filing textDone
Market priceDone
Price historyDone
Treasury yieldDone
Equity risk premiumDone
Industry betaDone
Peer multiplesSkipped
Business and productsDone
Risk factorsDone
Financial qualityDone
Valuation assumptionsDone
ValuationDone
Report synthesisDone