FREE TOOL · LIVE DATA

HD DCF Calculator

Run your own discounted cash flow valuation for The Home Depot. The calculator is pre-filled with real data — $12.6B free cash flow (FY2025) and the live share price — so you only adjust the assumptions.

SEARCH STOCK

Search to auto-fill real company data

COMPANY DATA

Annual, in billions
$B
In billions
B
Per share
$

YOUR ASSUMPTIONS

Projected
%
Required return
%
yrs
Perpetuity
%

YOUR DCF RESULT

CALCULATED FAIR VALUE

$293.51

19.5% downsideOVERVALUED

MARKET

$350.66

YOUR DCF

$293.51

MARGIN

$57.15

VALUE BREAKDOWN

PV of Projected Cash Flows$126.5B
PV of Terminal Value
$172.9B58% of total
Total Enterprise Value$299.4B
÷ Shares Outstanding1.02B
Fair Value Per Share$293.51

SENSITIVITY CHECK

Try adjusting growth rate by ±2% and discount rate by ±1% to see how sensitive your fair value is to assumptions.

COMPARE WITH FPI FAIR VALUE

Your DCF reflects your assumptions. As an independent reference, here is Fair Price Index's daily blended fair value for The Home Depot — DCF (50%), relative valuation (30%), and analyst consensus (20%):

HD · FPI MODELLIVE DATA · UPDATED DAILY
HDThe Home Depot
$350.66fair $244.08+43.7% above fair value
See the full HD valuation breakdown →

Frequently Asked Questions

What is HD's free cash flow?

The Home Depot generated $12.6 billion of free cash flow in fiscal year 2025. That figure is pre-filled in the calculator above and refreshed daily.

How do I calculate HD's fair value with a DCF?

Project The Home Depot's free cash flow forward at your assumed growth rate, discount each year back at your required return (WACC), add a terminal value, and divide by shares outstanding. The calculator above does all of this instantly as you adjust the assumptions.

What growth rate should I use for HD?

Anchor on history and sector reality: look at The Home Depot's revenue and cash flow growth over the past five to ten years, then ask what is sustainable going forward. Testing a conservative and an optimistic scenario matters more than any single number.

Is HD undervalued right now?

That depends on the assumptions you feed the model — that is the point of running your own DCF. For an independent reference, Fair Price Index publishes a daily fair value for The Home Depot blending DCF, relative valuation, and analyst consensus.

GET ALERTS

Track HD's fair value daily

Download Fair Price Index and get notified when The Home Depot's valuation shifts.

Download on the App StoreGet it on Google Play

Free tier available · PRO $2.99/month

RELATED

STOCK

HD Stock Analysis

Full fair value breakdown, FPI Rating, and fundamentals for The Home Depot.

Open →

TOOL

DCF Calculator

The general-purpose version — search any of 37,000+ stocks.

Open →

ARTICLE

DCF Model Explained

How discounted cash flow works, step by step, with worked examples.

Read →

This calculator is for educational purposes only and does not constitute investment advice. Pre-filled figures come from the latest reported financials and may differ from other sources. Always verify against the company's filings.