Consumer Cyclical / Home Improvement Retail

The Home Depot, Inc. (HD)

$311.52
+0.27%
$316.2B
Market Cap
22.5
P/E Ratio
1.00
Beta
2.94%
Dividend Yield
Piotroski 4/9Altman Z 5.7 SafeBeneish M -2.42 CleanROIC−WACC +12.3%

Quantitative Summary

Deterministic

At 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-Generated

The 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

Interactive
Market Price
$311.52
Fair Value
$92
Implied Upside
-70.5%
$92IMPLIED FAIR VALUEOVERVALUEDOVERUNDER
Growth Rate (Y1–5)-2%
-10%20%50%
Discount Rate (WACC)10.6%
5%12.5%20%

5-year two-stage DCF. Terminal growth 3%. Default sliders match the pre-computed base case. Drag to explore scenarios. Not investment advice.

Reverse DCFMarket-Implied
21.5%annual FCF growth priced in at $311.52

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

22.5x
HD P/E
35.0x
Sector Avg
43.9x
5Y Avg P/E
-36%
vs Sector

Currently trading 46% below its 5-year average P/E of 43.9x.

Price Chart with Moving Averages

Loading chart...
SMA 50 SMA 200

Technical Setup

AI Generated

The 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.

RSI (14)
SMA 50
SMA 200

Quant Health Deep Dive

4/9
Piotroski F-Score
Average — mixed operational signals
5.7
Altman Z-Score
Safe Zone — above 3.0 threshold per academic model. Thresholds: >3 safe, 1.8–3 grey, <1.8 distress.
-2.42
Beneish M-Score
Below threshold — no statistical earnings quality concern per Beneish model. Threshold: <-2.22 = below threshold.

Profitability & Value Creation

33.3%
Gross Margin
8.6%
Net Margin
22.8%
ROIC
10.6%
WACC
ROIC − WACC Spread: +12.3%— Positive value creation spread.
+3.2%
Revenue Growth (YoY)
-4.4%
Earnings Growth (YoY)
12.6B
Free Cash Flow
72%
FCF Payout Ratio

✅ Conservative payout — room for dividend increases.

Balance Sheet Health

7.20x
Debt / Equity
1.06x
Current Ratio
8.7x
Interest Coverage
1.8x
Net Debt / EBITDA
3.32%
FCF Yield
25.1B
EBITDA

Insider Activity (Last 90 Days)

Net Insider Flow
-$2M
Net Selling
0
Buy Transactions
2
Sale Transactions
2026-03-25DEATON JOHN A.Sold 2/8 qtrsGrant2,467 shares
2026-03-25BASTEK WILLIAM DSold 2/8 qtrsGrant3,518 shares
2026-03-25BROGGI JORDANGrant3,022 shares
2026-03-25ROWE MICHAEL FGrant2,255 shares
2026-03-25DECKER EDWARD P.Sold 1/8 qtrsGrant11,548 shares

Open-market buys vs sells by company insiders. Source: yfinance.

Earnings Surprise History

Q4
✗ Miss
Est: $3.59
Act: $3.56
-0.8%
Q3
✗ Miss
Est: $4.69
Act: $4.68
-0.3%
Q2
✗ Miss
Est: $3.83
Act: $3.74
-2.5%
Q1
✓ Beat
Est: $2.52
Act: $2.72
+7.8%

EPS estimates vs actuals for the most recent reported quarters. Source: yfinance.

Dividend History

$2.3300
Latest Dividend
$9.20
2025 Total
+2.2%
YoY Growth
9 yrs
Consecutive Increases
Annual Dividends per Share
$2.07
2016
$3.56
2017
$4.12
2018
$5.44
2019
$6.00
2020
$6.60
2021
$7.60
2022
$8.36
2023
$9.00
2024
$9.20
2025
$2.33
2026
DateAmountChange
2026-03-12$2.3300+1.3%
2025-12-04$2.30000.0%
2025-09-04$2.30000.0%
2025-06-05$2.30000.0%
2025-03-13$2.3000+2.2%
2024-11-27$2.25000.0%
2024-08-29$2.25000.0%
2024-05-30$2.25000.0%
2024-03-06$2.2500+7.7%
2023-11-29$2.09000.0%
2023-08-30$2.09000.0%
2023-05-31$2.09000.0%
Stock Splits
1999-12-31: 1.5:11998-07-06: 2:11997-07-07: 1.5:11993-04-14: 1.333333:11992-07-02: 1.5:11991-06-26: 1.5:11990-07-06: 1.5:11989-07-03: 1.5:11987-09-22: 1.5:11983-06-09: 2:1

Dividend and split data from SEC filings and market data. Amounts are per share, not adjusted for splits. Source: yfinance.

Risk Profile

24.1%
Annual Volatility
-0.20
Sharpe (1Y)
-24.2%
Max Drawdown (5Y)

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.

Loading drawdown chart...

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.

Loading beta chart...
Rolling Beta Market (β = 1.0)

Fama-French 5-Factor Exposure

Academic factor model decomposition — what's really driving this stock's returns.

0.69
Market β
Mkt-RF
+0.793
Size (SMB)
Small-cap tilt
-0.145
Value (HML)
Growth tilt
+0.839
Profit (RMW)
Robust
+0.587
Invest (CMA)
Conservative
Alpha (annual): -5.86%
R²: 48.7%of variance explained by 5 factors

Fama-French 5-Factor Model. Data: Kenneth French Data Library. Regression over 3 years of daily returns.

Fundamentals

19.7
Forward P/E
1.81
PEG Ratio
22.79
Price/Book
4M
Avg Volume
$426.75
52W High
$289.10
52W Low
16%
52W Range Position

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.

+4.7%
YoY Change (20252026)
17,276
Latest Word Count
+88%
6-Year Total
2021
2022
2023
2024
2025
2026

Passive Flow Attribution

ETF Draft Effect
$43.1B
Tracked Passive Exposure
8
ETFs Holding HD
0.67%
Avg Weight in ETFs
$6.4T
Total ETF AUM

When 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.

HD Shock
-0%
Est. Passive Redemption
$0
Systemic Risk
STABLE
HDEpicenterVTIETFVOOETFIVVETFAMZNLow RiskAMZNLow RiskTSLALow RiskTSLALow RiskAMZNLow Risk
HD Price Drop (%)0

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.

Ticker
HD
Total Shares
997M
ETF Lock-Up
13.7%
Display Mode
Total Float Impact
13.7%Locked Float

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.

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.

TICKER
HD
PRICE
$311.52
FLOOR (POC)
$353.18
STRENGTH
Medium
$292$299$306$313$311.52$319$326$333$340$3469%$353POC 10%$3608%$3678%$3738%$3809%$3877%$394$400$407$414$421
Focus Zone
Point of Control (POC) Support (below price) Resistance (above price) Current Price

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.

Free Cash Flow
$12.6B
EBITDA
$25.1B
FCF Conversion
50%
Reinvestment Rate
50%
50% of EBITDA → Free Cash
0% (cash burn)25% (low)50% (efficient)100% (pure cash)
ROIC
22.8%
ROIC − WACC Spread
12.3%

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.

DateFailed SharesClose PriceNotional Value
2026-05-085,296$322.64$1.7M
2026-05-07175$323.05$56,533.75
2026-05-0623$315.42$7,254.66
2026-05-052,269$312.42$708,880.98
2026-04-23287$339.50$97,436.5
2026-04-21236$350.99$82,833.64
2026-04-2017,101$349.40$6.0M
2026-04-17323$337.15$108,899.45
2026-04-156$342.71$2,056.26
2026-04-14237$341.16$80,854.92
2026-04-1311,642$337.34$3.9M
2026-04-10135$339.58$45,843.3
2026-04-09378$336.16$127,068.48
2026-04-0780$326.65$26,132
2026-04-06925$321.63$297,507.75
2026-04-02688$329.56$226,737.28
2026-03-31228$323.50$73,758
2026-03-30522$321.65$167,901.3
2026-03-2710,606$328.43$3.5M
2026-03-266,836$332.51$2.3M
2026-03-2549$330.91$16,214.59
2026-03-2379,904$320.75$25.6M
2026-03-2020$328.21$6,564.2
2026-03-181,476$341.43$503,950.68
2026-03-17232$342.58$79,478.56
2026-03-161,864$339.03$631,951.92
2026-03-13521$338.93$176,582.53
2026-03-11505$357.15$180,360.75
2026-03-068,009$361.68$2.9M
2026-03-0367$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.

Peer252-Day (1Y)126-Day (6M)Direction
WTGXXNaNNaN
LOW0.8900.864High co-movement
PHM0.7120.740High co-movement
KBH0.7090.712High co-movement
TOL0.7080.708High co-movement
SHW0.6990.673Moderate
MAS0.6940.655Moderate
TMHC0.6930.714Moderate
MTH0.6820.676Moderate
NVR0.6520.606Moderate

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.