HD · The Home Depot, Inc.

$348.862026-07-21

Sector: Consumer Cyclical; Industry: Home Improvement; Sub-Industry: Home Improvement Retail

Intrinsic Value Range Comparison · Mulya.ai

Leases factored

Bull

$324

-7.3% vs market

Base · active

$273

-21.8% vs market

Bear

$268

-23.2% vs market

Mulya.ai vs Analyst IV Comparison?

Bear $268

Base $273

Bull $324

Market $349

Median $369

Market Price $349

Mulya.ai Base $273

Analysts Median $369

Mulya.ai IV range ($268 · $324)

Analysts Range ($320 · $435)

Fundamentals · historical + forward · base

italics = DCF projection

Period	Revenue	Rev Gr ?	Ops M% ?	Tax Rate ?	NOPAT ?	Reinvest ?	FCFF ?	WACC% ?	PV FCFF ?	ROIC ?	Inv. Cap ?	EPS ?	P/E
2024.Q1	$152.7B	—	14.6%	23.6%	$17.1B	−$7.7B	$9.4B	8.3%	—	34.0%	$50.2B	$15.20	—
2024.Q4	$152.7B	0.0%	14.6%	23.7%	$17.0B	−$25.4B	−$8.4B	8.8%	—	28.7%	$68.4B	$15.20	—
2025.Q1	$159.5B	4.5%	13.9%	24.1%	$16.8B	−$26.5B	−$9.7B	8.8%	—	24.5%	$68.9B	$14.87	—
2025.Q4	$159.5B	0.0%	13.9%	23.9%	$16.9B	−$16.7B	$123MM	8.8%	—	23.1%	$77.3B	$14.87	—
2026.Q1	$166.6B	4.4%	12.8%	24.0%	$16.2B	−$15.0B	$1.2B	8.6%	—	22.0%	$70.5B	$14.07	16.3
italics below = DCF projection · 10yr Rev CAGR: 3.7%
2027.Q1	$166.2B	+-0.2%	14.7%	23.6%	$18.6B	$0MM	$18.6B	8.4%	$17.2B	26.4%	$70.5B	$18.17	19.2
2028.Q1	$172.6B	+3.9%	14.7%	23.2%	$19.4B	−$925MM	$18.5B	8.4%	$15.8B	27.4%	$71.4B	$18.97	18.4
2029.Q1	$179.4B	+3.9%	14.7%	22.8%	$20.3B	−$1.5B	$18.9B	8.4%	$14.8B	28.2%	$72.8B	$19.81	17.6
2030.Q1	$187.0B	+4.2%	14.7%	22.4%	$21.3B	−$10.5B	$10.7B	8.4%	$7.8B	27.3%	$83.4B	$20.76	16.8
2031.Q1	$194.9B	+4.2%	14.7%	22.0%	$22.3B	−$8.7B	$13.6B	8.5%	$9.1B	25.4%	$92.1B	$21.75	16.0

Term. Yr+	$248.6B	4.1%	13.6%	20.0%	$27.0B	−$5.1B	$21.9B	8.6%	$215.7B	21.8%	—	—	—

Active scenario IV: $273 (-21.8% vs market)