The Home Depot Inc (HD)

Rating: HOLD

HOLD (5-tier) · quality defensive · conviction: low

EPS basis for the forward P/E and all scenario multiples: consensus forward EPS (broker-adjusted, non-GAAP).

Methodology: Valuation triangulated across five independent anchors — Monte Carlo (Student-t + regime switching), an independent DCF, peer re-rating, a sum-of-parts, and a scenario-weighted PWEV. Figures reconciled to Alpha Vantage 2026-06-26. Each chart below sits with the part of the thesis it evidences.

General research for a skeptical institutional reader. Not personalised investment advice; no position sizing or trade instructions. Figures as of the analysis date; verify before acting.

Investment Committee Summary

📎 Download the full model (Excel) — DCF line items, scenarios, sensitivity, assumptions, and extended fundamentals.

Rating Bridge

Rating = HOLD because:

• Probability-weighted scenario value implies +2% vs spot
• Monte Carlo median implies -8% vs spot
• DCF fair value implies -32% vs spot
• Bear case (Structural — Housing-Turnover Reset) downside is -59% vs spot
• Net: reward/risk of 0.3× is not asymmetric enough for a Buy and not impaired enough for a Sell — hence Hold.

Investment Thesis

At $352.68 on a forward multiple near 23.6x, the market prices Home Depot as a durable quality retailer whose earnings normalise off the current housing trough rather than reset structurally lower. The engine largely agrees but stops short of endorsing the tape. Its base case pins fair value near $357 on 4% comp normalisation and a 12.1% operating margin, while the probability-weighted target of $344 sits marginally below spot; the independent DCF anchors lower still, at roughly $244 per share, because incremental ROIC of about 10.7% only modestly exceeds an 8.5% WACC. That gap between the multiple-based and cash-flow anchors is why the rating is HOLD and not a buy: the price already embeds the mid-cycle recovery. Segment volatility flows almost entirely through gross margin, which drives the bulk of Monte-Carlo variance. Management tone screened unusually candid this quarter, supporting the honest-normalisation read. The single most damaging risk is a housing-turnover reset in which comps and the multiple compress together, dragging value toward the low-$150s.

The dashboard below is the whole argument on one page: spot ($345) against each valuation anchor, the scenario tree, technicals and the options-implied move.

Anti-Thesis (The Real Bear Case)

The highest-probability bear is the housing-turnover reset, at 20%. Its mechanism is not a single weak quarter but a regime: rate-lock keeps existing-home turnover depressed for years, big-ticket and project demand stays soft, and Home Depot's fixed store and supply-chain base deleverages. Comps run negative, the operating margin slips toward 9%, and the equity de-rates to a deep-cyclical multiple near 13x as investors stop paying a quality premium for a business whose end-market has structurally shrunk. On the engine's own path that combination lands around $143, below the 52-week low of $286.95. The Pro offset, the load-bearing part of the bull view, fades precisely when housing activity is weakest, removing the mechanism relied on to defend earnings.

Key Debate

Gross Margin explains 64% of Monte Carlo outcome variance — the single variable that decides which side is right.

Earnings-Call Disconfirmation & Sentiment

Derived signals from the MCH market-data store (Alpha Vantage transcripts + news). Quantitative tone only — a disconfirmation flag, not a substitute for reading the call.

Management vs analyst tone (2026Q1): management +0.21 vs analyst floor +0.00 → delta +0.21 (n=30 mgmt / 16 Q&A; 15th pctile across the S&P book, z -1.1).

Flag: CANDID — management unusually candid/cautious vs peers (relatively low spin).

News (last 365d, 1000 articles): avg ticker sentiment +0.14 (bullish 14% / bearish 2%)

Scenario Analysis

The tree runs from a structural 'Structural — Housing-Turnover Reset' downside ($143) to a 'Bull — Re-Rate' bull case ($612); the probability-weighted blend (PWEV $352) is +2% versus spot.

Scenario rationale — what each probability buys (the driver path behind every target):

• Structural — Housing-Turnover Reset (20%, $143). Structural impairment — housing-turnover reset / big-ticket weakness: earnings AND the multiple compress together. Target sits below the 52-week low by construction. Drivers — implied_target: 151.5; probability: 0.2.
• Consumer / Big-Ticket Recession (17%, $259). Cyclical downturn — home-improvement spend (housing turnover, home equity, Pro demand) + rates weakens for 1–2 years before normalising. Drivers — implied_target: 257.27; probability: 0.17.
• Base — Repair-Remodel + Pro (35%, $379). Mid-cycle — normalised home-improvement spend (housing turnover, home equity, Pro demand) + rates; disciplined capital allocation; steady returns. Drivers — implied_target: 357.32; probability: 0.35.
• Growth — Pro / Housing Recovery (20%, $488). Upside — Pro + housing recovery lifts earnings above mid-cycle; the multiple expands modestly. Drivers — implied_target: 482.38; probability: 0.2.
• Bull — Re-Rate (8%, $612). Upside tail — sustained tight conditions or a structural re-rate on Pro + housing recovery. Drivers — implied_target: 609.23; probability: 0.08.

Valuation Triangulation

Five anchors — but read them with their basis in mind. The Monte Carlo, the DCF terminal, and the peer re-rate all key off a market multiple, so they are not fully independent; only the discounted cash flows themselves are genuinely multiple-free. The discipline is to read the spread and weight the cash-based view, not to treat five numbers as five independent votes.

Peer EV/Revenue re-rate — 0% weight: it duplicates the peer-multiple information already carried by the Peer P/E anchor while ignoring margin mix; weighting both would double-count the peer view. Shown as a cross-check.

Rating vs blend — the key debate. The rating tracks the multiple-discipline fair value (Monte Carlo $318 + scenario PWEV $352, ≈ spot); the weighted blend $291 (-16%) sits below it because the cash-flow DCF ($236) is materially more conservative than the market multiple. Whether the current multiple is justified is the central question for this name — and the principal downside risk to the rating.

Monte Carlo — the distribution, not a point

10,000 paths, Student-t shocks (fat tails) with a regime-switching overlay. The median lands at $318 and 44% of paths finish above spot. The variance decomposition shows the gross margin is the dominant swing factor (64% of variance). The fundamental driver, not the multiple, sets the spread — a cleaner setup.

DCF — the cash-flow anchor

Independent of the market multiple: a 5-year path, WACC 8.5%, 20x terminal FCF multiple → $236. This anchor is deliberately the heaviest (41%): it is the valuation least hostage to the current multiple regime.

Peer benchmarking — relative value

Against the peer cohort, re-rating to the peer-median forward multiple (P/E 19.385x) implies $290. A premium is only justified by superior growth/margins; otherwise it is multiple risk. Weighted just 12% so the market's mood does not drive the fair value.

Across all anchors the spread is 124% of the median — wide (genuine disagreement — the blend carries low valuation confidence).

Revenue-Segment Breakdown

The company-specific drivers behind the valuation — each segment carries its own growth, margin, multiple and capex intensity. (Tags: FACT reported · ESTIMATE from disclosures · INFERENCE judgment.)

Named Exposures

Demand & pricing cycle (FACT/ESTIMATE)

Capital intensity & shareholder returns (ESTIMATE)

Structural risk vs optionality (INFERENCE)

Industry Context — Consumer Discretionary — Housing

This name sits in the Consumer Discretionary — Housing as a home_improvement. home-improvement spend (housing turnover, home equity, Pro demand) + rates Its scenarios are not guessed in isolation — they inherit a single, shared view of the cluster's driver cycle, so the names that depend on the same event are mutually consistent.

Value chain: HD (home_improvement) · LOW (home_improvement) · DHI (homebuilders) · PHM (homebuilders) · LEN (homebuilders) · NVR (homebuilders)

Mapping note: name-level 'Structural — Housing-Turnover Reset' (20%) + 'Consumer / Big-Ticket Recession' (17%) map to cluster Housing Downturn — Affordability / Rate Lock (37%); name-level 'Growth — Pro / Housing Recovery' (20%) + 'Bull — Re-Rate' (8%) map to cluster Recovery — Rate Cuts / Volume (28%) — the cluster row is the SUM of the mapped scenario probabilities, not a different estimate.

On the cluster's key downside — Housing Downturn — Affordability / Rate Lock () — this name implies 37% vs the cluster house view of 39% (in line with the house). The cluster's full cross-stock reconciliation governs that the names which ride the same capex cycle assign it comparable odds.

Structure: Shared State — The disc_housing cycle is the shared macro driver. Driver — housing turnover & new-home demand + interest rates + repair-remodel Dispersion — Members differ by cyclicality (quality compounders vs deep cyclicals).

Model Appendix

DCF — line items

FCF is bridged: NOPAT + D&A − Capex − ΔNWC (capex intensity 3% of revenue, weighted from the segments) — not a single conversion fudge.

WACC 8.5% · Σ PV(FCF) $62B + PV(terminal) $232B = EV $293B; + net cash → equity $237B ÷ diluted shares 1.00B = $236/share (exit-multiple terminal).

• Gordon (perpetuity-growth) terminal at 2.5% → $202/share — a genuinely non-multiple, cash-based cross-check; the exit-multiple and Gordon values bracket the terminal-value risk.
• Incremental ROIC on the forecast capex ≈ 10% vs WACC 8% → above WACC — the build is value-creative.

Peer set

Peer-median fwd P/E → $290; EV/Rev → $631.

Weighted fair-value math

Sensitivity

DCF/share — WACC × terminal multiple

DCF/share — revenue CAGR Δ × op-margin Δ

Tornado — DCF/share swing by driver (widest first)

Company lever — SoP/share vs Home-Improvement Retail multiple (AI re-rating) (base 23x)

Consensus & Market Expectations

_Consensus figures: Alpha Vantage sell-side aggregates. Where the house view sits materially above or below the street, the divergence is itself a datum — see the thesis.

Balance Sheet & Liquidity

Balance-sheet data as of 2026-01-31 (Alpha Vantage).

Capital Allocation

Free-Cash-Flow Quality

Accounting quality: SBC 0.3% of revenue; cash conversion (OCF/NI) 115% — cash-backed.

Catalyst Calendar

• 2026-08-18 (~41d) — Quarterly earnings — est. EPS $4.71 (AV EARNINGS_CALENDAR)
• 2026-09-18 (~72d) — FOMC decision on the rate path (authored)
• 2026-12-09 (~154d) — Investor/analyst update on Pro ecosystem + SRS integration (authored)
• 2027-02-15 (~222d) — FY2026 guidance for comparable sales and operating margin (authored)

Forecast Track Record

• EPS surprise: beat 50.0% of the last 8 quarters; average surprise +0.7%.

Competitive Moat

Wide moat. HD's moat is scale-driven: dense big-box + supply-chain footprint, the leading Pro ecosystem (amplified by the SRS/interline acquisitions), and vendor buying power that a distant #2 cannot replicate. That supports a premium terminal multiple in the low-20s; if Pro share gains stall and the business proves to be a cyclical housing derivative rather than a share-compounder, the terminal multiple should compress toward the ~16x market/retail-staple level.

Moat sources:

• #1 US home-improvement retailer with unmatched big-box density and one-day/same-day supply chain
• Leading Pro/contractor ecosystem, deepened by SRS Distribution and specialty trade distribution
• Vendor scale and private-brand buying power
• High switching cost for Pro accounts via credit, delivery, and job-site fulfillment

Regulatory & Legal Risk

Probabilities and sensitivities are analyst estimates, not market-implied.

Scenario Macro & Key Risks

What the Market Is Pricing In

At the current price, the market pays 21.5× forward EPS, vs the house DCF terminal 20.0×, and a peer median 19.385×. The house DCF sits 32% below spot, so the market is pricing in more than the house case — roughly 2.8pp of revenue CAGR.

Variant perception: the house view is below-consensus, and the thesis is primarily event-driven.

Peer Quality & Weighting

Quality-weighted forward P/E: 20.6× (simple median 19.385×). Direct peers count 100%, segment 50%, broad 25%.

Historical-range cross-check: 52-week range $287–$418, centre $346 (+0% vs spot); spot sits at the 44th percentile of the range. Low-weight mean-reversion cross-check, not a fundamental anchor.

Risk / Reward & Margin of Safety

Reward/risk compares triangulated upside against the probability-weighted bear target, not the extreme tail. Bull case (Bull — Re-Rate): $612.

Assumption Register

Sensitivity-ranked drivers (widest fair-value swing first): Op margin ±3pp (152.0); Revenue CAGR ±3pp (81.0); Terminal × ±15% (69.0); Capex intensity ±15% (30.0); WACC ±1pp (25.0).

Inputs, Sources & Confidence

Every load-bearing input, labelled by type and confidence. (reported fact · company guidance · consensus estimate · market data · house estimate · inference.)

Source Log

Citation coverage: 13/14 mandated claims sourced. Filing URLs are not available via the market-data provider; company statements are cited as 10-K/10-Q via Alpha Vantage.

Load-Bearing Assumptions

DCF: WACC 8%, terminal multiple 20×, FY+5 revenue $197B. Triangulation leans 41% on DCF, 29% on PWEV.

Reasons the Thesis Could Fail (Falsifiable)

Pre-registered signals that would break the thesis — each polices a specific scenario boundary and is checked at every earnings update:

• US comparable sales (comps), year-on-year < -0.02 (2 consecutive prints → Housing Downturn — Affordability / Rate Lock). The base case assumes low-single-digit comp normalisation. Two consecutive prints below -2% signal the housing-turnover reset rather than a soft patch, invalidating the mid-cycle volume path.
• Operating margin (GAAP), trailing quarter < 0.114 (2 consecutive prints → Housing Downturn — Affordability / Rate Lock). Base op-margin is 12.1%; the recession path sits at 10.8%. A sustained print below the ~11.4% midpoint confirms fixed-cost deleverage is running ahead of the cyclical case.
• Pro-segment revenue growth, year-on-year < 0.0 (2 consecutive prints → Mid-Cycle — Repair-Remodel + Orders). The differentiated part of the thesis is Pro-led share gain. Pro turning negative for two prints removes the structural offset to weak DIY big-ticket demand.
• Full-year comparable-sales guidance revision at a print < 0.0 (single event → Housing Downturn — Affordability / Rate Lock). A cut of full-year comp guidance to a negative range at any print is a discrete signal that management has abandoned the normalisation assumption underpinning the base target.
• Capital expenditure, trailing twelve months > 6.5 (2 consecutive prints → Recovery — Rate Cuts / Volume). The DCF assumes capex around 3% of revenue with incremental ROIC near 10.7%. TTM capex sustained above ~$6.5B without a matching sales response would flag a value-dilutive build outrunning demand.

Fact / Inference / Speculation

• FACT: Spot $345; 52-week range $287–$418; engine rating HOLD; base-case target $344 (-0%). (source: Alpha Vantage 2026-06-26, 8 July 2026)
• INFERENCE: Triangulated FV $291 (-16% vs spot · triangulated FV); the rating tracks the Monte-Carlo + scenario-PWEV core; the cash-flow anchor sits below the multiple-discipline core.
• SPECULATION: At current prices the embedded bet is that Gross Margin keeps surprising favourably — an operating call the next two prints will test.

Recommendation: HOLD

Balanced: triangulated fair value $291 (-16% vs spot); the outcome hinges on Gross Margin. The debate is Gross Margin — a fundamental call.

Disclosures & Limitations

This report is for informational and research purposes only. It is not personalised investment advice and does not consider any investor's objectives, financial situation, risk tolerance, tax position, or liquidity needs.

• No suitability assessment has been performed for any individual.
• Market data may be delayed or inaccurate; figures are as of the analysis date.
• Model outputs (fair values, targets, scenario probabilities) are estimates and may be wrong.
• Forecasts are uncertain; past performance is not indicative of future returns.
• The author or publisher may hold positions in securities mentioned.
• Users should verify information against primary sources (company filings) before acting.
• Investing involves risk of loss; there is no guarantee any target price is achieved.
• Ratings follow a defined research methodology (12-month expected-return thresholds), not individual circumstances.