HD The Home Depot, Inc.
Consumer Cyclical
Price
$356.06
Intrinsic value
$66.89
Buy price
$53.51
Discount
-432.3%
DCF walkthrough
Near-term growth (g1)1.52%
Terminal growth (g2)3.50%
Years of g1 growth4
Discount rate9.00%
Margin of safety20.00%
- Operating CF
- $18,032,000,000.00
- Total debt
- $63,730,999,296.00
- Cash & STI
- $1,600,999,936.00
- Shares out.
- 996,000,000
Overvalued
Intrinsic value$66.90
Buy price (with MOS)$53.52
Current price$356.06
Discount to intrinsic value-432.3%
7-step quality scorecard
ROE quality
HIGH_DISTORTED- Average ROE
- 719.8%
- Current ROE
- 110.5%
- Minimum ROE
- 110.5%
Debt quality
LEVERAGED- Debt / Equity
- 4.97x
Moat proxy
WEAK_PROXYCash-flow reliability
OK- Operating CF / Net income
- 1.29x
Technical chart
Confluence: DOWNTREND (1/3)Weekly candles, ~3 years. Yellow line: 10-week EMA. Dashed lines: Fibonacci retracement of the last 52-week swing. Green arrow: an active DR1 support reclaim.
Assumptions & data quality
- Data source
- yfinance
- Growth (g1) source
- min(revenueCAGR,cfCAGR)
- Valuation model
- DCF_OCF
- Debt as % of DCF PV
- 49.5%
- Public economic interest
- 100.0%
These are model outputs built on assumptions (growth rate, discount rate, margin of safety), not facts - trust but verify, especially for LOW cash-flow-reliability or UNKNOWN-quality rows.