Edwyn

Edwyn Search companies, tickers, CIKs…⌘K

HOME DEPOT, INC.

HDCIK 0000354950Retail

Compare:LOW FAST GWW SWK WHR TSCO

Compare HD

Intrinsic Value

HD Intrinsic Valuation

Review the filing-backed discounted cash flow baseline, scenario range, and capital structure context for a fundamentals-first fair value read.

Intrinsic Value

HD Intrinsic Valuation

Review the filing-backed discounted cash flow baseline, scenario range, and capital structure context for a fundamentals-first fair value read.

Intrinsic value

Filing-backed DCF baseline

Automated free-cash-flow DCF baseline for HOME DEPOT, INC., derived from annual filing data.

Read the DCF guide

DCF fair value

$131.79

Implied equity value $131B

Current price

$302.47

Latest available quote for the primary listing.

Margin of safety

-56.4%

Base case against the live quote.

Fair value range

$103.62 – $172.10

Bear

$103.62

Base

$131.79

Bull

$172.10

Current

$302.47

Model assumptions

Cash flow base

$13B

Basis

Operating cash flow less capex (firm-value proxy)

Growth

1.5%

Discount

9.5%

Terminal

2.5%

Horizon

Assumption sensitivity

vs base per share

Base case$131.79Baseline

Growth +1 pt$136.08+$4.29

Intrinsic value

Filing-backed DCF baseline

Automated free-cash-flow DCF baseline for HOME DEPOT, INC., derived from annual filing data.

Read the DCF guide

DCF fair value

$131.79

Implied equity value $131B

Current price

$302.47

Latest available quote for the primary listing.

Margin of safety

-56.4%

Base case against the live quote.

Fair value range

$103.62 – $172.10

Bear

$103.62

Base

$131.79

Bull

$172.10

Current

$302.47

Model assumptions

Cash flow base

$13B

Basis

Operating cash flow less capex (firm-value proxy)

Growth

1.5%

Discount

9.5%

Terminal

2.5%

Horizon

Assumption sensitivity

vs base per share

Base case$131.79Baseline

Growth +1 pt$136.08+$4.29

What the market is pricing in

At $302.47 the market is pricing in roughly 18.2% annual growth under this model.
Growth anchor: Median of 3Y revenue CAGR, 5Y revenue CAGR, and 5Y free cash flow CAGR. Scenario-derived from +/-2 pts growth and +/-1 pt discount.
Net debt reduces equity value relative to firm value before the per-share target is calculated.

Intrinsic EV-to-equity bridge

Enterprise value

Discounted free cash flows

$181B

Less total debt

− $51B

Plus cash and equivalents

+ $1B

Equity value

After the bridge

$131B

Diluted shares

995,000,000

Fair value / share

$131.79