The Home Depot, Inc. (HD)
Quantitative Summary
DeterministicAt 22.5x earnings — a 36% discount to the sector average of 35.0x — HD is in the lower valuation range. Financial health is average: Piotroski 4/9, Altman Z 5.7. DCF fair value of $93 implies 73% downside based on model assumptions.
Generated deterministically from quant metrics and financial statements. Not a recommendation.
Algorithmic Teardown
AI-GeneratedThe fundamental economics of this consumer cyclical leader demonstrate a robust capacity to generate capital, evidenced by an ROIC-WACC spread of +12.2%, indicating that the firm creates significant value above its cost of equity. This efficiency is underpinned by strong profitability metrics, including a 33.3% gross margin and an 8.6% net margin, which aligns with the Robust Margins factor score (RMW) of 0.839. However, the quality signal from the Piotroski F-Score of 4/9 suggests moderate financial stability relative to historical standards, while the Altman Z-Score of 5.7 and Beneish M-Score of -2.42 confirm a low probability of distress or earnings manipulation. Despite these operational strengths, revenue growth has decelerated to just 3.2% year-over-year, signaling that top-line expansion is currently muted even as capital efficiency remains high.
Valuation metrics present a distinct divergence between current market pricing and intrinsic value models derived from cash flow assumptions. The stock trades at a P/E of 23.7x, which represents a significant compression relative to both the sector average of 34.6x and its own five-year historical mean of 42.4x, reflecting a -44% discount over the past half-decade. In contrast, discounted cash flow analysis incorporating an implied ten-year free cash flow growth rate of 21.4% yields a fair value estimate that implies substantial downside risk relative to current prices. This discrepancy suggests the market may be pricing in slower future expansion or heightened cyclical headwinds not fully captured by the static DCF inputs, resulting in a calculated upside gap of -88.9%.
Risk-adjusted performance indicators further contextualize this valuation setup through factor-based analysis and insider behavior. The stock exhibits negative exposure to value characteristics with an HML tilt of -0.145, while simultaneously delivering a Fama-French alpha of -5.86% annually, indicating underperformance relative to its risk profile over the measured period. Compounding these technical signals is notable net insider selling activity totaling $1,602,287 over the last ninety days, which often precedes or accompanies periods of elevated uncertainty regarding future earnings visibility. Collectively, the data paints a picture of a high-quality operator trading at a steep discount to intrinsic models but burdened by recent alpha drag and active insider distribution.
Generated by LLM from quantitative data inputs. May contain inaccuracies. Not investment advice.
DCF Sandbox
Interactive5-year two-stage DCF. Terminal growth 3%. Default sliders match the pre-computed base case. Drag to explore scenarios. Not investment advice.
The growth rate the market implicitly expects over the next 10 years to justify today's price. Compare with historical growth of 3% YoY revenue.
Sensitivity Matrix
| TG ↓ / WACC → | 8.6% | 10.6% | 12.6% |
|---|---|---|---|
| 2% | $116 | $83 | $62 |
| 3% | $137 | $93 | $68 |
| 4% | $166 | $107 | $76 |
Center = base case. Green = >10% upside, Red = >10% downside vs $311.52.
Pre-computed DCF: WACC=10.6%, terminal growth 3%. Fair value $93 (-72.7%). Not investment advice.
Valuation Context
Currently trading 46% below its 5-year average P/E of 43.9x.
Price Chart with Moving Averages
Technical Setup
AI GeneratedThe Home Depot shares are currently trading at $313.78, a position that requires contextualization against its moving average envelope to assess relative value dynamics. Without specific band boundaries or historical volatility metrics provided in the dataset, it is impossible to definitively classify whether this price point represents an extreme deviation from the mean or a consolidation zone within normal parameters. In technical analysis frameworks relying on mean reversion, prices trading significantly below the upper band often signal potential upward pressure toward equilibrium, while those near the lower boundary might suggest limited downside support but also constrained upside momentum until a catalyst occurs. The absence of explicit distance measurements between the current price and the moving averages prevents a conclusive determination of overbought or oversold conditions based solely on this snapshot. If $313.78 resides in the outer regions of the calculated envelope, statistical probabilities might favor a return toward the central tendency; conversely, if it remains comfortably within the middle third of the band, the asset may simply be exhibiting steady trend continuation rather than seeking equilibrium. Market participants must weigh this static price level against broader sector trends and volume profiles to gauge whether the current valuation aligns with historical norms or represents an anomaly warranting further observation before drawing conclusions on future directional bias.
Quant Health Deep Dive
Profitability & Value Creation
✅ Conservative payout — room for dividend increases.
Balance Sheet Health
Insider Activity (Last 90 Days)
Open-market buys vs sells by company insiders. Source: yfinance.
Earnings Surprise History
EPS estimates vs actuals for the most recent reported quarters. Source: yfinance.
Dividend History
| Date | Amount | Change |
|---|---|---|
| 2026-03-12 | $2.3300 | +1.3% |
| 2025-12-04 | $2.3000 | 0.0% |
| 2025-09-04 | $2.3000 | 0.0% |
| 2025-06-05 | $2.3000 | 0.0% |
| 2025-03-13 | $2.3000 | +2.2% |
| 2024-11-27 | $2.2500 | 0.0% |
| 2024-08-29 | $2.2500 | 0.0% |
| 2024-05-30 | $2.2500 | 0.0% |
| 2024-03-06 | $2.2500 | +7.7% |
| 2023-11-29 | $2.0900 | 0.0% |
| 2023-08-30 | $2.0900 | 0.0% |
| 2023-05-31 | $2.0900 | 0.0% |
Dividend and split data from SEC filings and market data. Amounts are per share, not adjusted for splits. Source: yfinance.
Risk Profile
Sharpe = risk-adjusted return (higher is better). Max drawdown = largest peak-to-trough decline. 1,200+ trading days.
Underwater (Drawdown from Peak)
How far below the all-time high the price has been over time. Deeper = more pain for holders.
Rolling 60-Day Beta vs S&P 500 (VOO)
How the stock's sensitivity to market moves changes over time. β > 1 = more volatile than the market.
Fama-French 5-Factor Exposure
Academic factor model decomposition — what's really driving this stock's returns.
Fama-French 5-Factor Model. Data: Kenneth French Data Library. Regression over 3 years of daily returns.
Fundamentals
10-K Risk Factor Expansion
Word count of Item 1A (Risk Factors) across annual filings. Rising counts often signal new regulatory, competitive, or operational risks.
Passive Flow Attribution
ETF Draft EffectWhen investors buy or sell ETFs like XLY or VCR, the fund manager is mechanically forced to buy or sell HD shares regardless of The Home Depot, Inc.'s individual fundamentals. We estimate $43.1B of passive capital is structurally linked to HD through 8 tracked ETFs. This substantial passive exposure means that ETF inflows and outflows — not company fundamentals — can dominate daily volume on this stock.
Passive exposure = Σ (ETF AUM × stock weight in ETF) across 8 tracked ETFs. Actual passive ownership is larger (includes mutual funds). Not investment advice.
ETF Contagion Visualizer
Simulate a price drop in The Home Depot, Inc. to visualize passive redemption contagion across ETFs and collateral stocks.
If The Home Depot, Inc. (HD) experiences a significant drawdown, ETF redemptions can create collateral selling pressure on co-held stocks. Our model identifies AMAZON.COM INC (AMZN) as the most exposed collateral stock, sharing 2 ETFs with HD. This is the "Passive Contagion" effect described in the Inelastic Market Hypothesis.
Contagion model based on shared ETF exposure and constituent weights across 35 tracked ETFs. Estimated selling pressure is a simplified model — actual impact depends on market liquidity, ETF redemption mechanics, and market-maker activity.
HD Ownership Dynamics
Passive funds hold 1 in every 7 HD shares, reducing daily market volatility.
The Home Depot, Inc. (HD) exerts measurable gravity on the passive index market, currently representing 5.2% of the State Street Consumer Discretionary Select Sector SPDR ETF (XLY) and 4.8% of the VCR (VCR). Across 34 tracked ETFs, approximately 137M shares (13.7% of float) are held by passive funds and rarely trade on the open market. This level of passive ownership means index rebalances can create outsized volume events.
ETFs with Highest HD Exposure
Float lock-up computed from 34 ETFs tracked by SecuritiesDB. Actual passive ownership is higher (includes mutual funds, pension funds, etc.).
HD Institutional Volume Profile
252-day volume distribution by price level. The Point of Control (POC) marks — the price where the most institutional volume transacted — an implicit support/resistance floor.
The highest-volume price zone for The Home Depot, Inc. over the past year sits near $353.18 (10% of 252-day volume). The current price of $311.52 sits 11.8% below the POC — suggesting potential mean-reversion upside if institutional demand reasserts at this level.
Volume Profile computed from 252 trading days of OHLCV data. Volume allocated to price bins proportionally based on daily high-low range. Not investment advice.
HD Capital Efficiency
How efficiently does The Home Depot, Inc. convert operating profits into free cash? The FCF Conversion ratio measures the gap between accounting earnings and real cash generation.
The Home Depot, Inc. converts 50% of its EBITDA into free cash flow, a healthy conversion rate indicating efficient capital management — the business generates substantial cash after reinvestment. The positive ROIC-WACC spread of 12.3% confirms that reinvested capital creates shareholder value.
Capital efficiency = Free Cash Flow ÷ EBITDA. Reinvestment = (EBITDA − FCF) ÷ EBITDA. Metrics from latest annual filings. Not investment advice.
Fails-to-Deliver (FTD) History
SEC-reported settlement failures. Elevated FTDs can indicate high short-selling pressure, operational settlement issues, or naked shorting activity.
| Date | Failed Shares | Close Price | Notional Value |
|---|---|---|---|
| 2026-05-08 | 5,296 | $322.64 | $1.7M |
| 2026-05-07 | 175 | $323.05 | $56,533.75 |
| 2026-05-06 | 23 | $315.42 | $7,254.66 |
| 2026-05-05 | 2,269 | $312.42 | $708,880.98 |
| 2026-04-23 | 287 | $339.50 | $97,436.5 |
| 2026-04-21 | 236 | $350.99 | $82,833.64 |
| 2026-04-20 | 17,101 | $349.40 | $6.0M |
| 2026-04-17 | 323 | $337.15 | $108,899.45 |
| 2026-04-15 | 6 | $342.71 | $2,056.26 |
| 2026-04-14 | 237 | $341.16 | $80,854.92 |
| 2026-04-13 | 11,642 | $337.34 | $3.9M |
| 2026-04-10 | 135 | $339.58 | $45,843.3 |
| 2026-04-09 | 378 | $336.16 | $127,068.48 |
| 2026-04-07 | 80 | $326.65 | $26,132 |
| 2026-04-06 | 925 | $321.63 | $297,507.75 |
| 2026-04-02 | 688 | $329.56 | $226,737.28 |
| 2026-03-31 | 228 | $323.50 | $73,758 |
| 2026-03-30 | 522 | $321.65 | $167,901.3 |
| 2026-03-27 | 10,606 | $328.43 | $3.5M |
| 2026-03-26 | 6,836 | $332.51 | $2.3M |
| 2026-03-25 | 49 | $330.91 | $16,214.59 |
| 2026-03-23 | 79,904 | $320.75 | $25.6M |
| 2026-03-20 | 20 | $328.21 | $6,564.2 |
| 2026-03-18 | 1,476 | $341.43 | $503,950.68 |
| 2026-03-17 | 232 | $342.58 | $79,478.56 |
| 2026-03-16 | 1,864 | $339.03 | $631,951.92 |
| 2026-03-13 | 521 | $338.93 | $176,582.53 |
| 2026-03-11 | 505 | $357.15 | $180,360.75 |
| 2026-03-06 | 8,009 | $361.68 | $2.9M |
| 2026-03-03 | 67 | $370.81 | $24,844.27 |
Source: SEC Regulation SHO FTD data. Data is reported with a ~30 day delay. High FTD quantities relative to average daily volume may indicate settlement stress.
Price Correlations
Statistical correlation of daily returns with other stocks. High correlations indicate stocks that move together; negative correlations can offer diversification.
| Peer | 252-Day (1Y) | 126-Day (6M) | Direction |
|---|---|---|---|
| WTGXX | NaN | NaN | |
| LOW | 0.890 | 0.864 | High co-movement |
| PHM | 0.712 | 0.740 | High co-movement |
| KBH | 0.709 | 0.712 | High co-movement |
| TOL | 0.708 | 0.708 | High co-movement |
| SHW | 0.699 | 0.673 | Moderate |
| MAS | 0.694 | 0.655 | Moderate |
| TMHC | 0.693 | 0.714 | Moderate |
| MTH | 0.682 | 0.676 | Moderate |
| NVR | 0.652 | 0.606 | Moderate |
Pearson correlation of daily log returns. 252d ≈ 1 trading year. Computed from price history. Not investment advice.
Compare HD to Peers
Quant metrics computed deterministically from financial statements and price data. Updated: 2026-06-02.
SecuritiesDB provides programmatic data aggregation for informational purposes only. None of the metrics, summaries, or algorithmic flags constitute a recommendation to buy or sell any security.