The Home Depot, Inc. (HD) Stock Analysis — Fair Value, Risk & Moat Rating
NYQ · Consumer Cyclical · Home Improvement Retail
Is The Home Depot, Inc. a safe investment right now?
The Home Depot, Inc.'s Altman Z-Score of 6.02 places it in the safe zone. Our DCF model estimates intrinsic value at $244.73, suggesting the stock is overvalued by 43%. Moat rating: 4.1/5 stars.
Could The Home Depot, Inc. go bankrupt? Altman Z-Score analysis
Z-Score of 6.02 is above 3.0, indicating the company is financially healthy by this metric.
- Below 1.8 — Distress Zone (high bankruptcy risk)
- 1.8 to 3.0 — Gray Zone (elevated uncertainty)
- Above 3.0 — Safe Zone (financially healthy)
What drives HD's Z-Score?
| Component | Formula | Value | Weight | Contribution |
|---|---|---|---|---|
| A · Working Capital / Total Assets | WC / TA | 0.0314 | 1.2 | 0.04 |
| B · Retained Earnings / Total Assets | RE / TA | 0.9315 | 1.4 | 1.3 |
| C · EBIT / Total Assets | EBIT / TA | 0.2256 | 3.3 | 0.74 |
| D · Market Cap / Total Liabilities | MCap / TL | 3.907 | 0.6 | 2.34 |
| E · Revenue / Total Assets | Rev / TA | 1.5883 | 1.0 | 1.59 |
How has HD's financial health changed over time?
| Year | Z-Score | Zone |
|---|---|---|
| 2016 | 7.85 | Safe |
| 2017 | 7.59 | Safe |
| 2018 | 9.32 | Safe |
| 2019 | 9.49 | Safe |
| 2020 | 8.42 | Safe |
| 2021 | 6.66 | Safe |
| 2022 | 6.85 | Safe |
| 2023 | 7.33 | Safe |
| 2024 | 7.52 | Safe |
| 2025 | 6.02 | Safe |
Source: Calculated from HD's latest 10-K filing on SEC EDGAR.
What is The Home Depot, Inc. actually worth?
Fair value range: $91.05 — $384.68
Valuation Methods
| Method | Fair Value | Weight | Detail |
|---|---|---|---|
| Historical PE × Forward EPS | $384.68 | 50% | 23.6x avg PE (3 years) × $16.30 forward EPS |
| DCF (Discounted Cash Flow) | $113.94 | 30% | Two-stage DCF: $8.6B TTM FCF, 7.7% growth, 9.3% WACC |
| EV/FCF Multiple | $91.05 | 20% | TTM FCF × 18x multiple + net cash |
Assumptions & Data Sources
| Parameter | Value | Source |
|---|---|---|
| FCF Growth Rate (Stage 1) | 7.7% | 70% analyst consensus + 30% historical |
| Analyst EPS Growth (This Year) | 2.5% | Consensus (33 analysts) |
| Analyst EPS Growth (Next Year) | 8.3% | Consensus |
| Historical 5Y FCF CAGR | 13.0% | SEC EDGAR |
| Terminal Growth Rate | 2.5% | Long-term GDP proxy |
| Discount Rate (WACC) | 9.3% | CAPM (Rf=4.3% + 1.08*5.5%) |
| Net Cash / (Debt) | $-64,520M | Balance sheet |
| Base FCF (TTM) | $8.6B | Trailing 12 months |
| Shares Outstanding | 996,027,658 | Latest |
Sensitivity Analysis
| Growth Rate | 8% WACC | 10% WACC | 9.3% WACC | 13% WACC |
|---|---|---|---|---|
| 0% | $139.36 | $102.99 | $113.29 | $74.31 |
| 2.5% | $161.34 | $118.31 | $130.49 | $84.51 |
| 5.0% | $186.55 | $135.83 | $150.18 | $96.10 |
| 7.5% | $220.95 | $159.34 | $176.74 | $111.30 |
Free Cash Flow History
| Year | FCF | Growth |
|---|---|---|
| 2016 | $6.8B | — |
| 2017 | $7.9B | +15.7% |
| 2018 | $8.2B | +3.7% |
| 2019 | $10.1B | +24.2% |
| 2020 | $10.7B | +5.8% |
| 2021 | $11.0B | +2.7% |
| 2022 | $16.4B | +48.8% |
| 2023 | $14.0B | +-14.5% |
| 2024 | $11.5B | +-17.9% |
| 2025 | $17.9B | +56.1% |
Source: FCF data from SEC EDGAR filings. Price via Yahoo Finance.
Does The Home Depot, Inc. have a durable competitive advantage?
Moat rating: 4.1/5.
What makes up HD's moat score?
ROIC Stability
ROIC variability over the past decade. Score: 5/5.
Gross Margin Trend
Gross margin trajectory over the past decade. Score: 4/5.
Switching Costs
Estimated customer lock-in based on margin level. Score: 3/5.
How stable is HD's return on invested capital?
| Year | ROIC | Trend |
|---|---|---|
| 2016 | 35.5% | — |
| 2017 | 40.8% | Rising |
| 2018 | 47.4% | Rising |
| 2019 | 53.8% | Rising |
| 2020 | 47.3% | Declining |
| 2021 | 33.4% | Declining |
| 2022 | 42.3% | Rising |
| 2023 | 43.2% | Stable |
| 2024 | 44.1% | Stable |
| 2025 | 32.1% | Declining |
Source: ROIC calculated from SEC EDGAR filings.
Is The Home Depot, Inc.'s dividend safe?
Can The Home Depot, Inc. afford its dividend?
Payout ratio is 64.6%. FCF covers the dividend 3.2x. 40 consecutive years of payments.
The Home Depot, Inc.'s key financial metrics
| Metric | Latest | 1Y Ago | 3Y Ago | Trend |
|---|---|---|---|---|
| Revenue | $152.7B | $157.4B | $132.1B | Rising |
| Net Income | $15.1B | $17.1B | $12.9B | Rising |
| Free Cash Flow | $17.9B | $11.5B | $16.4B | Rising |
| Gross Margin | 33.4% | 33.5% | 34.0% | Stable |
Common questions about The Home Depot, Inc.
Is The Home Depot, Inc. at risk of going bankrupt?
The Home Depot, Inc.'s Altman Z-Score of 6.02 places it in the safe zone. This metric uses balance sheet ratios to predict bankruptcy probability within 2 years. A score below 1.8 signals distress, while above 3.0 indicates safety.
What is The Home Depot, Inc.'s intrinsic value based on DCF?
Our DCF model estimates The Home Depot, Inc.'s intrinsic value at $244.73 per share. The current margin of safety is -43.4%. This estimate is based on historical free cash flow trends and a risk-adjusted discount rate.
Does The Home Depot, Inc. have a competitive moat?
The Home Depot, Inc. receives a moat rating of 4.1 out of 5 stars, based on ROIC stability, gross margin trends, and estimated switching costs. A rating above 3.5 suggests a durable competitive advantage.
Is The Home Depot, Inc.'s dividend safe?
Our dividend safety analysis examines payout ratio, free cash flow coverage, and the company's streak of consecutive dividend payments to determine whether the current payout is sustainable.
Before you invest in The Home Depot, Inc., make sure you truly understand it.
A deep understanding of a company's fundamentals, risk profile, and competitive position dramatically increases your investment accuracy and odds of success.
Pass the quiz to earn the HD Certified Value Investor badge.
FairValueLabs Disclaimer
All valuations, scores, ratings, and classifications on this page are produced by the FairValueLabs internal valuation system. They do not represent actual market value, guaranteed outcomes, or professional investment advice. These are analytical estimates for educational and research purposes only.
This is not financial advice. All data is sourced from SEC EDGAR public filings. Always consult a qualified financial advisor before making investment decisions.
Last updated: Apr 20, 2026. Data sources: SEC EDGAR (financial statements), Yahoo Finance (market data, analyst consensus). Data may not reflect the most recent quarter.
HD analysis methodology: How we calculate fair value, Z-Scores, and moat ratings