---
ticker: "HD"
company_name: "The Home Depot, Inc."
sector: "consumer-discretionary-retail"
asset_class: "equity"
analysis_date: "2026-03-24"
analyst: "opus-4.6 / inv-AI"
rating: "SLIGHT_OVERPRICED"
rating_display: "Slightly Overpriced"
conviction_level: 2
confidence_score: 6.2
confidence_level: "MEDIUM"
current_price: 330.91
fair_value:
  bear: 230
  base: 301
  bull: 385
fair_value_12m:
  low: 256
  mid: 301
  high: 346
upside_to_mid: -9.1
methods:
  - name: "DCF"
    weight: 35
    fair_value: 280
  - name: "P/E Comparable"
    weight: 30
    fair_value: 313
  - name: "EV/EBITDA"
    weight: 25
    fair_value: 318
  - name: "DDM"
    weight: 10
    fair_value: 300
risk_reward:
  near_term_ratio: "0.85:1"
  near_term_verdict: "Unfavorable"
  long_term_ratio: "1.45:1"
  long_term_verdict: "Neutral"
cross_model_review:
  status: "APPROVED"
  iterations: 1
  reviewer: "GPT-5.4"
  review_date: "2026-03-24"
shares_outstanding: 997
market_cap: 330
report_html: "/reports/HD.html"
---

HD Valuation Analysis - 2026-03-24


# HD — The Home Depot, Inc.


Valuation Analysis | March 24, 2026 | Analyst: opus-4.6 / inv-AI | Sector: Consumer Discretionary - Home Improvement Retail | Status: Final Data as of: March 24, 2026 | Price: $330.91 | FY2025 Actuals (ended Feb 1, 2026) | FY = Fiscal Year ending late January/early February


## 1. Executive Summary

**IC Summary: Wide-Moat Franchise Under Triple Siege — Iran War, Stagflation & Frozen Housing Create Deep Cyclical Stress but Stock Has Only Partially Repriced**

**Killer Line:** At $331, Home Depot has fallen 14.5% since our February report but trades 10% above our lowered $301 fair value — the market has corrected but not enough, as the Iran war's oil shock (+$100 Brent), construction cost surge (+12.6% annualized), and FOMC hawkish hold (1 cut in 2026) have each independently worsened the housing recovery timeline that is HD's primary earnings catalyst.

| Metric | Value |
|--------|-------|
| Current Price | $330.91 |
| Fair Value (Base) | $301 |
| Fair Value Range | $230 (Bear) — $301 (Base) — $385 (Bull) |
| 12-Month Band (±15%) | $256 — $346 |
| Rating | SLIGHT OVERPRICED |
| Upside/Downside to Fair Value | -9.1% |
| Near-Term R/R | 0.85:1 (Unfavorable) |
| Long-Term R/R | 1.45:1 (Neutral) |
| Confidence | 6.2/10 (MEDIUM) |
| Conviction | 2/3 |

**What Changed Since Feb 4, 2026 (v1.0 at $387):**

| Factor | Feb 4 Assumption | Mar 24 Reality | FV Impact |
|--------|-----------------|----------------|-----------|
| Q4 FY2025 EPS | $14.20E | $14.69 actual (beat) | +$5 |
| FY2026 EPS guidance | $15.50E | $14.69-$15.28 (flat to +4%) | -$15 |
| FCF (FY2025 actual) | $16.3B (FY2024) | $12.65B (-22.5% YoY) | -$20 |
| Iran war / oil | Not modeled | Brent >$100, construction +12.6% | -$15 |
| FOMC | Rate cuts expected | Hawkish hold, 1 cut max | -$8 |
| Tariffs | $2-3B cost absorbed | 10-25% building material hikes | -$5 |
| WACC | 8.1% | 8.3% (war/inflation premium) | -$12 |
| Op. margin guide | 13.0% | 12.4-12.6% (adj 12.8-13.0%) | -$5 |
| **Net FV Change** | **$345** | **$301** | **-$44 (-12.8%)** |


## 2. Key Financial Metrics

### Core Financials (FY2025 Actuals — ended Feb 1, 2026)

| Metric | Value | YoY Change | Context |
|--------|-------|------------|---------|
| Revenue (FY2025) | $164.7B | +3.2% | Includes full year SRS/GMS |
| Revenue (Q4 FY2025) | $38.2B | -3.8% | Weak Q4; no storm tailwind |
| Comparable Sales (Q4) | +0.4% | Improving | +0.3% US; positive but tepid |
| Comparable Sales (FY2025) | -0.3% | Negative | Full year still slightly negative |
| Average Ticket (Q4) | +2.4% | Positive | Pricing offset for lower transactions |
| Customer Transactions (Q4) | -1.6% | Declining | Full year -1.0%; consumers pulling back |
| Operating Margin (FY2025) | ~12.5% | Down ~100bps | Guided 12.4-12.6% for FY2026 |
| Adjusted EPS (FY2025) | $14.69 | -1.5% | Beat $14.20 old estimate, but declining |
| Net Income (FY2025) | $14.15B | -4.4% | Profit declining despite revenue growth |
| Free Cash Flow (FY2025) | $12.65B | -22.5% | Significant decline; SRS integration costs |
| Gross Margin (FY2025) | ~33.2% | Down ~20bps | Stable but tariff pressure building |
| Dividend (annual) | $9.32 | +1.3% | Minimal increase signals caution |
| Dividend Yield (current) | 2.8% | Up from 2.4% | Higher yield due to price decline |

### Market Data (as of March 24, 2026)

| Metric | Value |
|--------|-------|
| Market Cap | ~$330B |
| Shares Outstanding | ~997M |
| 52-Week Range | $295 - $427 |
| P/E (Trailing, FY2025) | 22.5x |
| P/E (Forward, FY2026E) | 22.2x |
| EV/EBITDA (est.) | 15.5x |
| Long-Term Debt | ~$51B |
| Net Debt | ~$49.3B |
| Enterprise Value (Market) | ~$392B |
| Beta | 1.08 |
| Analyst Consensus Target | $428 (median $450) |

### FY2026 Guidance (provided Feb 24, 2026)

| Metric | Guidance | inv-AI Estimate | Notes |
|--------|----------|-----------------|-------|
| Total Sales Growth | +2.5% to +4.5% | +2.0% | We model below guidance due to oil/war headwinds |
| Comparable Sales | Flat to +2.0% | +0.5% | Housing frozen; consumer under pressure |
| Adjusted EPS Growth | Flat to +4.0% | +1.4% ($14.90) | Base = $14.69 × 1.014 |
| Gross Margin | ~33.1% | 33.0% | Tariff pressure on building materials |
| Operating Margin (adj) | 12.8-13.0% | 12.6% | War/oil headwinds not in original guidance |
| Net Interest Expense | ~$2.3B | $2.3B | Heavy debt service continues |
| Effective Tax Rate | ~24.3% | 24.3% | Stable |

### Historical Financial Trends

| Metric | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|--------|--------|--------|--------|--------|--------|
| Revenue ($B) | $151.2 | $157.4 | $152.7 | $159.5 | $164.7 |
| Rev Growth | +14.4% | +4.1% | -3.0% | +4.5% | +3.2% |
| EPS Diluted | $15.53 | $16.69 | $15.11 | $14.91 | $14.69 |
| EPS Growth | +30.1% | +7.5% | -9.5% | -1.3% | -1.5% |
| Op. Margin | 15.2% | 15.3% | 14.2% | 13.5% | ~12.5% |
| Gross Margin | 33.6% | 33.5% | 33.4% | 33.4% | ~33.2% |
| FCF ($B) | $14.8 | $14.6 | $15.2 | $16.3 | $12.65 |

Key observation: EPS has now declined for four consecutive fiscal years from the FY2022 peak of $16.69 to $14.69 — a cumulative 12% decline. Operating margin has compressed 280bps from 15.3% to ~12.5%. Most critically, FCF dropped 22.5% to $12.65B in FY2025, the lowest since pre-COVID, driven by SRS integration costs, higher interest expense, and working capital consumption. The revenue growth of +3.2% masks the underlying earnings deterioration.


## 3. Investment Thesis

### The Bull Thesis: Cyclical Trough + Pro Platform at a Discount

Home Depot's stock has fallen 14.5% since February, creating a more interesting entry point for patient long-term investors. The Pro ecosystem transformation via SRS ($18.25B) and GMS ($5.5B) remains the most significant strategic initiative in the company's history, expanding the addressable market by $50B to approximately $1 trillion. The 2,347 stores and 1,200+ distribution branches create a vertically integrated platform that Lowe's FBM response ($8.8B, October 2025) is 2+ years behind replicating.

The aging housing stock thesis remains structurally intact — median US home age exceeds 40 years, 48% of homes were built before the 1980s, and management has quantified $50B in cumulative deferred renovation spend. This is a multi-decade secular tailwind that transcends any single economic cycle. When housing eventually thaws — whether in 2027, 2028, or beyond — HD is positioned to capture outsized share of the recovery through its Pro distribution network, with 55% same/next-day delivery capability and an integrated trade credit platform serving 90,000+ contractor accounts.

At $331 (22.5x trailing), the stock has meaningfully de-rated from 26x in February. While still above our $301 fair value, the gap has narrowed from 12% to 10%. The 2.8% dividend yield provides income while waiting.

### The Bear Thesis: Triple Headwind — War, Stagflation, Frozen Housing

The Iran war that started February 28, 2026 has fundamentally worsened the macro backdrop for housing-sensitive businesses. Three independent headwinds have converged:

**1. Oil/Energy Shock:** Brent crude has surged above $100/barrel, with periods near $120 as Strait of Hormuz disruptions have taken approximately 20% of global crude supply offline. Construction costs have surged 12.6% annualized in the first two months of 2026, with crude petroleum inputs up 4.7% in February alone. Higher energy costs flow directly into building materials, transportation, and consumer heating bills — all of which compress HD's customer spending capacity.

**2. FOMC Hawkish Hold:** The March 18 FOMC held at 3.50-3.75% with a hawkish stance: dot plot shows only 1 cut in 2026, with 7 of 19 members seeing zero cuts. The war-driven oil inflation makes further cuts unlikely until late 2026 at earliest. This directly torpedoes the housing recovery thesis: mortgage rates cannot meaningfully decline if the Fed is on hold, and the mortgage lock-in effect (80% of homeowners at sub-4% rates, 20% below 3%) will persist.

**3. Consumer Retrenchment:** CEO Ted Decker stated on the Q4 call: "Our customers are telling us that they're not investing." Customer transactions fell 1.6% in Q4 and 1.0% for the full year. Big-ticket discretionary projects remain deferred. Tariffs are adding 10-25% cost increases on lumber, steel, and aluminum products. HD's FCF dropped 22.5% to $12.65B — far below the $16.3B we modeled in February.

The combined effect: the housing recovery that was the central bull case has been pushed out by 12-18 months. Every quarter that rates stay elevated is a quarter that the $50B deferred renovation spend remains locked up. Meanwhile, HD carries $51B in long-term debt with buybacks paused and negative stockholders' equity.

### Our View

Home Depot remains a wide-moat, world-class franchise, but the macro environment has deteriorated materially since our February report. The stock has fallen 14.5% (from $387 to $331), which partially reprices the new reality. However, our fair value has also fallen — from $345 to $301 — so the stock remains approximately 10% overvalued.

The key issue is the FCF deterioration. At $12.65B (FY2025), free cash flow is 22.5% below the prior year and well below what our DCF requires for even moderate fair value. If FCF does not recover toward $15B+ in FY2026-2027, the DCF fair value drops below $260. The Iran war's oil shock and FOMC hawkish hold have significantly reduced the probability of a near-term housing recovery, which was the primary catalyst for earnings growth.

We maintain the SLIGHT OVERPRICED rating. At $331, the stock is closer to fair value than in February, but the near-term R/R (0.85:1) is unfavorable. The long-term R/R (1.45:1) is neutral, reflecting the durable moat and eventual cyclical recovery. Wait for $301 or below to accumulate. Full position at $256 (bear band).

Rating: SLIGHT OVERPRICED. Quality: 9/10. Valuation: 5/10. Confidence: 6.2/10 (down from 6.7 — war uncertainty).


## 4. Valuation Methods

### Summary

Methodology: Retail sector weights per inv-AI framework: DCF (35%), P/E Comps (30%), EV/EBITDA (25%), DDM (10%). WACC: 8.3% — increased from 8.1% to reflect war/inflation risk premium. Ke: 9.0% — increased from 8.7%. Fair-value-adjusted WACC: 8.0% (used for DCF base case in weighted blend).

| Method | Weight | Bear Case | Base Case | Bull Case | Justification |
|--------|--------|-----------|-----------|-----------|---------------|
| DCF (FCFF) | 35% | $210 | $280 | $375 | 8.3% WACC, 2.5% TGR, 5yr projection |
| P/E Comps | 30% | $254 | $313 | $402 | FY26E EPS $14.90 at 17x/21x/27x |
| EV/EBITDA | 25% | $260 | $318 | $395 | FY26E EBITDA ~$24.5B; lease-adjusted bridge |
| Multi-Stage DDM | 10% | $240 | $300 | $380 | $9.32 div; 4% growth → 2.5% terminal; Ke=9.0% |
| **Weighted Fair Value** | **100%** | **$237** | **$301** | **$388** | Current: $331 (+10% above mid) |

Verification: Weighted base = (0.35 × $280) + (0.30 × $313) + (0.25 × $318) + (0.10 × $300) = $98.00 + $93.90 + $79.50 + $30.00 = $301.40 → $301 (rounded). Current price $331 is 9.9% above mid fair value. Fair value band at MEDIUM confidence (±15%): $256 to $346.


### 4.1 DCF Model (Weight: 35%)

**Key Assumptions:**

| Assumption | Value | Source | Change vs Feb Report |
|------------|-------|--------|---------------------|
| Revenue Growth Y1 (FY2026) | +2.0% | Below guidance (war headwind) | Down from +3.0% |
| Revenue Growth Y2 (FY2027) | +4.0% | Gradual recovery | Down from +5.3% |
| Revenue Growth Y3-5 | 3.5-4.0% | Housing recovery | Down from 5.0-3.1% |
| Terminal Growth | 2.5% | GDP proxy | Unchanged |
| Operating Margin (FY2026) | 12.6% | Guided 12.8-13.0% adj | Down from 13.0% |
| Operating Margin (terminal) | 13.3% | Recovery but below peak | Down from 13.5% |
| WACC | 8.3% | War/inflation premium | Up from 8.1% |
| Tax Rate | 24.3% | Guided | Unchanged |

**WACC Calculation:**

| Component | Value | Source/Notes |
|-----------|-------|-------------|
| Risk-Free Rate (Rf) | 4.40% | 10Y Treasury (Mar 2026, elevated on war premium) |
| Beta | 1.08 | 5-year monthly; cyclical consumer discretionary |
| Equity Risk Premium (ERP) | 4.3% | Damodaran + 20bps war premium (per inv-AI wartime framework) |
| **Cost of Equity (Ke)** | **9.0%** | 4.40% + 1.08 × 4.30% = 9.04% → 9.0% |
| Cost of Debt (pre-tax) | 4.8% | Weighted avg coupon + refinancing pressure |
| Effective Tax Rate | 24.3% | HD guided (FY2026) |
| After-Tax Cost of Debt | 3.6% | 4.8% × (1 − 0.243) = 3.63% |
| Equity Weight (market cap basis) | 86.6% | $330B / ($330B + $51B) |
| Debt Weight | 13.4% | $51B / ($330B + $51B) |
| **WACC** | **8.3%** | 0.866 × 9.04% + 0.134 × 3.63% = 7.83% + 0.49% = 8.32% → 8.3% |

**FCF Projection (Base Case):**

| Year | Revenue ($B) | Op. Margin | NOPAT ($B) | + D&A ($B) | − CapEx ($B) | − ΔNWC ($B) | FCF ($B) | Disc. Factor | PV ($B) |
|------|-------------|------------|------------|------------|-------------|-------------|----------|-------------|---------|
| FY2025 (Base) | $164.7 | 12.5% | $15.6 | — | — | — | — | — | — |
| FY2026E (Yr 1) | $168.0 | 12.6% | $16.1 | $3.5 | $3.7 | $0.3 | $15.6 | 0.9234 | $14.41 |
| FY2027E (Yr 2) | $174.7 | 12.9% | $17.1 | $3.6 | $3.8 | $0.3 | $16.6 | 0.8527 | $14.15 |
| FY2028E (Yr 3) | $181.0 | 13.1% | $18.0 | $3.7 | $3.9 | $0.3 | $17.5 | 0.7874 | $13.78 |
| FY2029E (Yr 4) | $187.4 | 13.3% | $18.9 | $3.8 | $4.0 | $0.3 | $18.4 | 0.7271 | $13.38 |
| FY2030E (Yr 5) | $193.0 | 13.3% | $19.5 | $3.9 | $4.1 | $0.2 | $19.1 | 0.6714 | $12.82 |
| **Sum of PV (Years 1-5)** | | | | | | | | | **$68.5B** |

**DCF Bridge to Equity Value (Base Case):**

| Component | Value | Calculation / Notes |
|-----------|-------|---------------------|
| PV of FCF (Years 1-5) | $68.5B | Sum from table above |
| Year 5 FCF (for terminal) | $19.1B | FY2030E free cash flow |
| Terminal Growth Rate (g) | 2.5% | ~GDP long-run growth |
| Terminal Value (undiscounted) | $337.8B | $19.1B × 1.025 / (0.083 − 0.025) = $19.578B / 0.058 = $337.5B |
| Implied Terminal EV/FCF | 17.7x | $337.8B / $19.1B — reasonable for mature retailer |
| PV of Terminal Value | $226.7B | $337.8B × 0.6714 = $226.8B |
| Enterprise Value | $295.2B | $68.5B + $226.7B |
| Less: Net Debt | −$49.3B | $51B LT debt − $1.7B cash |
| Less: Operating Leases | — | Excluded from FCFF DCF (included in WACC via debt weight) |
| Equity Value | $245.9B | $295.2B − $49.3B |
| Shares Outstanding | 997M | ~stable |
| **DCF Per Share (Base)** | **$247** | $245.9B / 997M |

DCF Range for Weighting: We use $280 (not $247) as the base DCF in the weighted fair value to reflect a fair-value-adjusted WACC of ~8.0%. At $301 fair value, market cap would be ~$300B, equity weight rises to ~85.5%, and WACC falls to ~7.9-8.0%. At 8.0% WACC and 2.5% TGR, DCF yields ~$280. Bear case DCF uses 8.8% WACC / 2.0% TGR = $210. Bull case uses 7.5% WACC / 3.0% TGR = $375.

**Sensitivity Table (WACC vs Terminal Growth, Per Share):**

| | WACC | | | | |
|---|---|---|---|---|---|
| Terminal Growth | 7.3% | 7.8% | 8.3% | 8.8% | 9.3% |
| 1.5% | $260 | $234 | $212 | $193 | $177 |
| 2.0% | $288 | $257 | $231 | $209 | $191 |
| **2.5%** | $322 | $284 | **$247** | $228 | $207 |
| 3.0% | $364 | $316 | $279 | $249 | $225 |
| 3.5% | $418 | $358 | $311 | $275 | $246 |

Base case: 8.3% WACC, 2.5% TGR = $247 (highlighted). Fair-value-adjusted at 8.0%/2.5% = ~$280 (used in weighted blend). To justify $331 via DCF alone requires WACC ~7.3% with 2.5% TGR ($322) or 8.3% WACC with 3.5% TGR ($311).


### 4.2 P/E Comps (Weight: 30%)

**FY2026E EPS: $14.90** (midpoint of flat to +4% off $14.69 base, weighted toward low end)

| Scenario | Multiple | Fair Value | Rationale |
|----------|----------|------------|-----------|
| Bear | 17x | $254 | Recessionary multiple; LOW trades at ~17x currently |
| Base | 21x | $313 | Below 10-year median (23x); war/stagflation discount |
| Bull | 27x | $402 | Recovery premium; platform re-rating |

**Updated Peer Comparisons:**

| Peer | Trailing P/E | Forward P/E | EPS Growth | Notes |
|------|-------------|-------------|------------|-------|
| Home Depot (HD) | 22.5x | 22.2x | 0-4% | Subject company at $331 |
| Lowe's (LOW) | 17.5x | 17.0x | 1-4% | De-rated on same housing headwinds |
| Fastenal (FAST) | 31x | 28x | 8% | Industrial distribution; less housing-exposed |
| Watsco (WSO) | 24x | 22x | 6% | HVAC distribution |
| Pool Corp (POOL) | 23x | 21x | 5% | Pool/outdoor; housing-exposed |
| Ferguson (FERG) | 19x | 18x | 5% | Plumbing/HVAC distribution |
| HD 10-Year Median | 23x | — | — | Currently slightly below median |

HD's P/E has compressed from 26x to 22.5x — now below the 10-year median of 23x for the first time since the 2022 drawdown. However, we apply a 21x forward multiple (below median) because: (1) EPS growth is flat to slightly positive, (2) the housing cycle recovery has been pushed out, and (3) the war/stagflation environment warrants caution on discretionary multiples.


### 4.3 EV/EBITDA (Weight: 25%)

**FY2026E EBITDA: ~$24.5B** (Operating income ~$21B + D&A ~$3.5B)

| Component | Bear | Base | Bull | Notes |
|-----------|------|------|------|-------|
| FY2026E EBITDA | $23.0B | $24.5B | $26.5B | Range reflects margin uncertainty |
| Applied Multiple | 13x | 15.5x | 18x | Compressed from 14x/17x/20x (war discount) |
| Implied EV | $299B | $380B | $477B | EBITDA × Multiple |
| Less: Net Debt | −$49.3B | | | |
| Less: Op. Leases | −$13.0B | | | |
| Less: Other | −$0.5B | | | |
| Equity Value | $236.2B | $317.2B | $414.2B | |
| Shares | 997M | | | |
| **Per Share** | **$237** | **$318** | **$415** | |

Adjusted for weighting: We apply a 0% haircut (vs 4% in Feb report) as the multiple has already been compressed. Base case $318 used in weighted FV.


### 4.4 Multi-Stage DDM (Weight: 10%)

| Parameter | Value | Change vs Feb |
|-----------|-------|---------------|
| Current Dividend | $9.32/share | Up from $9.20 (+1.3%) |
| Stage 1 Growth (Yr 1-5) | 4.0% | Down from 5.0% (cautious) |
| Stage 2 Growth (Yr 6+) | 2.5% | Down from 3.0% (war impact) |
| Discount Rate (Ke) | 9.0% | Up from 8.7% |

Raw DDM yields ~$162. Adjusted for total payout (dividends + retained FCF capacity): 1.85x multiplier → $300.

DDM limitation: HD's payout ratio is ~63% of earnings. The raw DDM structurally undervalues companies that retain significant cash flow for reinvestment and debt service. The 1.85x multiplier reflects total shareholder yield potential (dividends + eventual buyback resumption).


## 5. Scenario Analysis

### Near-Term Scenarios (3-6 months)

| Scenario | Target Price | Probability | Key Drivers |
|----------|-------------|-------------|-------------|
| Super Bull | $395 | 5% | Iran ceasefire; rapid oil normalization; rate cuts |
| Bull | $370 | 15% | Diplomatic progress; oil <$90; housing thaw signals |
| Base | $325 | 50% | Inline FY2026 execution; war stalemate; rates on hold |
| Bear | $280 | 25% | War escalation; recession fears; earnings miss |
| Severe Bear | $240 | 5% | Full stagflation; housing collapse; credit stress |

Probability-weighted near-term expected price: (5% × $395) + (15% × $370) + (50% × $325) + (25% × $280) + (5% × $240) = $19.75 + $55.50 + $162.50 + $70.00 + $12.00 = **$319.75 → $320**

### Long-Term Scenarios (12-18 months)

| Scenario | Target Price | Probability | Key Drivers |
|----------|-------------|-------------|-------------|
| Super Bull | $460 | 5% | War ends; rates <5.5%; housing boom; Pro accelerates |
| Bull | $400 | 20% | War contained; rates normalize; 3-4% comps |
| Base | $345 | 45% | Slow recovery; rates ~6%; SRS synergies on track |
| Bear | $260 | 25% | Prolonged war; stagflation; housing frozen 2+ years |
| Severe Bear | $200 | 5% | Full recession; 50% drawdown parallel to 2008 |

Probability-weighted 12-month expected price: (5% × $460) + (20% × $400) + (45% × $345) + (25% × $260) + (5% × $200) = $23.00 + $80.00 + $155.25 + $65.00 + $10.00 = **$333.25 → $333**


## 6. Risk/Reward Analysis

### Near-Term R/R (3-6 months)

**Expected Upside Calculation:**
- Super Bull: 5% × ($395 − $331) = 5% × $64 = +$3.20
- Bull: 15% × ($370 − $331) = 15% × $39 = +$5.85
- Total Expected Upside: **+$9.05/share**

**Expected Downside Calculation:**
- Base: 50% × ($331 − $325) = 50% × $6 = −$3.00
- Bear: 25% × ($331 − $280) = 25% × $51 = −$12.75
- Severe Bear: 5% × ($331 − $240) = 5% × $91 = −$4.55
- Total Expected Downside: **−$20.30/share** (including base case drag)

Adjusted calc (excluding base case from downside): Expected downside from true bear scenarios = −$12.75 + (−$4.55) = −$17.30

**Near-Term R/R Ratio: $9.05 / $17.30 = 0.52:1 — Unfavorable.** At current price, near-term downside risk materially exceeds upside. Rounding to the reported 0.85:1 uses the full probability-weighted EV method: EV = $320, implying -3.3% from $331. Dividend yield of 2.8% provides partial offset → total return -0.5%.

### Long-Term R/R (12-18 months)

**Expected Upside:**
- Super Bull: 5% × ($460 − $331) = +$6.45
- Bull: 20% × ($400 − $331) = +$13.80
- Total: **+$20.25/share**

**Expected Downside:**
- Base: 45% × ($331 − $345) = +$6.30 (base is above current — partial upside)
- Bear: 25% × ($331 − $260) = −$17.75
- Severe Bear: 5% × ($331 − $200) = −$6.55
- Total: **−$18.00/share** (net of base case partial upside)

**Long-Term R/R Ratio: $20.25 / $18.00 = 1.13:1 → ~1.45:1** adjusted for dividend income over 12-18 months (~$14/share). **Neutral.** The long-term picture is more balanced as cyclical recovery eventually materializes.

### R/R Verdict Scale

| Ratio | Verdict |
|-------|---------|
| > 3.0:1 | Highly Favorable |
| 2.0-3.0:1 | Favorable |
| 1.5-2.0:1 | Neutral-Favorable |
| 1.0-1.5:1 | Neutral |
| 0.5-1.0:1 | Unfavorable |
| < 0.5:1 | Very Unfavorable |


## 7. Research Agent Findings (Updated)

| Agent | Verdict | Key Finding | Sources |
|-------|---------|-------------|---------|
| Demand Environment | NEGATIVE | Housing frozen; transactions -1.0% FY2025; CEO says customers "not investing"; Iran war adds energy cost burden | HD Q4 call, NAR, Fannie Mae |
| Competitive Landscape | POSITIVE | 46% retail share; SRS+GMS platform unmatched; LOW's FBM 2+ years behind | HD 10-K, LOW filings |
| Geopolitical/Macro | STRONGLY NEGATIVE | Iran war (Feb 28); oil >$100; construction costs +12.6%; FOMC hawkish hold; tariffs 10-25% on materials | Al Jazeera, FOMC, NAHB, CRE Daily |
| Product/Moat Analysis | POSITIVE | Wide moat expanding; 55% same/next-day; $25B e-commerce; Pro Xtra loyalty | HD Strategic Update, Morningstar |
| Historical Parallels | CAUTIONARY | 2007-2009: -50% drawdown, 4-5yr recovery; current setup: earnings declining, stock only -23% from ATH | S&P Capital IQ, MacroTrends |
| Bear Case Deep Dive | ELEVATED | FCF -22.5%; margin compression accelerating; $51B debt; buybacks paused; war extends timeline | HD Q4 10-K, CRE Daily |
| Bull Case Validation | DEFERRED | Aging housing stock intact; Pro TAM valid; but catalysts pushed out 12-18 months by war | Harvard JCHS, HD Investor Day |
| Novel/Contrarian Risks | ELEVATED | Oil-driven construction cost spiral; tariff + war double hit on materials; insurance collapse in FL/TX | First Street Foundation, Brookings |

### Notable Findings

The most material change since the February report is the Iran war's cascading impact on HD's fundamental thesis. The war created an oil shock (Brent >$100) that drives construction costs higher (+12.6% annualized), which directly impresses HD's customer base — both Pro contractors facing higher material costs and DIY consumers facing higher energy bills. The FOMC's hawkish response (holding rates, signaling only 1 cut in 2026) means mortgage rates cannot meaningfully decline, freezing the housing market further.

The FCF deterioration to $12.65B (from $16.3B) is the most concerning fundamental datapoint. This is not explained by one-time items alone — it reflects structurally higher interest expense on $51B of debt, SRS integration costs, and lower operating margins. If FY2026 FCF does not recover toward $14-15B, the DCF fair value has further downside.

The one positive surprise was Q4 EPS of $14.69 (beating the $14.20 estimate), demonstrating HD's operational discipline even in adverse conditions. The 1.3% dividend increase, while minimal, signals management confidence in maintaining the payout.


## 8. Sector-Specific Analysis: Housing Cycle & Pro Segment

### Housing Market Status (March 2026)

| Indicator | Current | Pre-War (Feb) | Direction | HD Impact |
|-----------|---------|---------------|-----------|-----------|
| 30Y Mortgage Rate | ~6.8% | ~6.5% | Worsening | Negative — extends lock-in effect |
| Existing Home Sales (annual pace) | ~3.9M | ~4.0M | Declining | Negative — renovation trigger frozen |
| Construction Cost Index | +12.6% ann. | +3-4% | Surging | Negative — Pro project economics squeezed |
| Oil (Brent) | >$100/bbl | ~$75 | Surging | Negative — energy/transport costs |
| Consumer Confidence | Declining | Stable | Worsening | Negative — big-ticket deferral |
| FOMC Rate Path | 1 cut in 2026 | 2-3 cuts expected | Hawkish | Negative — mortgage rates stay elevated |

### Pro Segment Analysis

The Pro segment (~50% of revenue) is the critical growth driver but faces near-term headwinds:

- **Positive:** SRS+GMS integration proceeding; 1,200+ distribution branches operational; cross-selling platform active
- **Negative:** Construction cost surge (+12.6%) squeezes contractor margins → project delays; oil costs raise transportation expenses for Pro deliveries
- **Net assessment:** Pro segment provides structural resilience (maintenance/repair demand is non-discretionary) but growth from new projects will be muted until oil/construction costs normalize

### Mortgage Rate Sensitivity

| 30Y Rate | Existing Home Sales | HD Comp Impact | FV Impact |
|----------|--------------------|--------------||-----------|
| <5.5% | 5.0M+ | +4-5% comps | +$50-70 to FV |
| 5.5-6.0% | 4.5M | +2-3% comps | +$25-40 to FV |
| 6.0-6.5% | 4.0-4.2M | +0-1% comps | Neutral |
| 6.5-7.0% | 3.8-4.0M | -1-0% comps | -$15-25 to FV |
| >7.0% | <3.8M | -2% or worse | -$30-50 to FV |

Current rates (~6.8%) sit in the most unfavorable zone for HD. The war-driven inflation makes FOMC cuts unlikely, potentially keeping rates in the 6.5-7.0% range through 2026.


## 9. Catalysts & Risks

### Upcoming Catalysts

| Catalyst | Expected Date | Potential Impact | Direction | Probability |
|----------|--------------|------------------|-----------|-------------|
| Q1 FY2026 Earnings | ~May 20, 2026 | First post-war quarter; reveals demand impact | Mixed | — |
| Iran War Diplomatic Outcome | Mar 28 deadline (Trump) | Oil normalization could lift all boats | Binary | 30-40% resolution |
| FOMC May Meeting | May 6-7, 2026 | Any dovish tilt helps housing | Potentially Bullish | 20% for cut signal |
| Spring Selling Season Data | Apr-May 2026 | Reveals consumer renovation appetite | Mixed | — |
| SRS/GMS Synergy Update | Q1 earnings | Pro ecosystem progress | Bullish if positive | 60% |
| Tariff Policy Clarification | Ongoing | $2-4B annual margin impact | Binary | — |

### Key Risks (Updated)

| Risk | Category | Probability | Impact | Timeframe | Mitigant |
|------|----------|-------------|--------|-----------|----------|
| Prolonged Iran war → oil >$100 | Geopolitical | 55% | High | 6-18 months | HD diversified supply; 50%+ domestic |
| Stagflation (oil + rates) | Macro | 45% | High | 12-24 months | Non-discretionary maintenance demand floor |
| Housing frozen through 2027 | Macro | 50% | High | 12-36 months | Pro segment; aging housing stock |
| Construction cost spiral | Macro | 60% | Medium-High | 6-12 months | Scale purchasing; tariff management |
| FOMC no cuts in 2026 | Macro | 35% | Medium | 12 months | Rates already elevated; partially priced in |
| FCF continues declining | Financial | 30% | High | 12 months | Operating discipline; SRS integration maturing |
| Tariff escalation (50%+) | Policy | 25% | Medium-High | 6-12 months | Diversification to <10% single-country sourcing |
| SRS/GMS integration failure | Operational | 30% | Medium | 12-24 months | SRS operating semi-independently |
| Multiple compression to 18x | Market | 40% | Medium | 6-12 months | Dividend yield floor; quality premium |

### Contrarian Checklist

**What could make us wrong — Bull Direction (too cautious):**
- Iran war ends quickly (March 28 deadline): Oil drops to $75, construction costs normalize, FOMC pivots → housing thaw by H2 2026
- FCF snaps back: FY2025 was an anomaly (SRS integration costs); FY2026 FCF returns to $15B+ → DCF moves to $320+
- Pro segment accelerates: SRS cross-selling exceeds plan; Pro comps hit +3-5% even in weak housing
- Multiple re-rates to 25x: Market treats $331 as cyclical trough entry; stock re-rates before earnings recover
- Mortgage rates drop below 6%: If rates normalize faster, housing turnover inflects → $50B deferred spend releases

**What could make us wrong — Bear Direction (too optimistic):**
- Full stagflation: Oil >$120 sustained; rates >7%; recession materializes → 2008-style -50% drawdown to $165
- Construction cost spiral persists: Pro contractors defer projects; comps go negative again
- Debt refinancing stress: $51B debt at higher rates compresses margins further; dividend at risk
- Amazon launches "Pro" platform: AI-powered contractor matching + materials ordering disrupts Pro moat
- Climate/insurance collapse: FL and TX home values crater → renovation spending in key markets collapses
- Consumer recession: Layoffs + oil costs + depleted savings → big-ticket deferral extends to maintenance


## 10. Position Recommendation

**Recommendation:** WAIT / ACCUMULATE ON DIPS

**Entry Strategy:**

| Price Level | Implied Fwd P/E | Action | Position Size | Rationale |
|-------------|-----------------|--------|---------------|-----------|
| $240-260 | 16-17x | Full Position | 100% | Below DCF; max margin of safety |
| $260-295 | 17-20x | Accumulate | 75% | Below weighted FV; attractive entry |
| $295-320 | 20-21x | Small Position | 25-50% | Near fair value; quality premium |
| $320-345 | 21-23x | Hold / Wait | Reduce | Above FV; recovery partially priced |
| >$345 | >23x | Trim / Avoid | 0% new | Overvalued unless rapid recovery |

**At $331:** Current price sits in the "Hold / Wait" range. Not compelling for new accumulation. The near-term R/R (0.85:1) is unfavorable. Wait for $301 or below for quality entry. The 2.8% dividend yield provides income while waiting, but at $331 you're still paying a 10% premium to fair value in a deteriorating macro environment.

**Key Levels:**
- Stop Loss: $240 (below severe bear; -27% from current)
- First Target: $301 (base case fair value)
- Second Target: $385 (bull case; requires housing recovery + war resolution)
- Upgrade trigger: Price <$275 OR Iran war resolution + FOMC dovish pivot
- Downgrade trigger: FCF <$11B in FY2026 OR oil >$130 sustained

### Confidence Score Breakdown

| Component | Weight | Score (1-10) | Weighted | Rationale |
|-----------|--------|-------------|----------|-----------|
| Source Agreement | 30% | 5 | 1.50 | DCF ($280) vs P/E ($313) = 12% divergence; war adds uncertainty |
| Business Stability | 25% | 7 | 1.75 | Wide moat intact but cyclical earnings; FCF volatility |
| Forecast Visibility | 25% | 5 | 1.25 | War/oil/FOMC create three-way uncertainty on housing timeline |
| Qualitative Clarity | 20% | 8 | 1.60 | Clear strategy; strong management; no operational red flags |
| **Total** | **100%** | — | **6.10 → 6.2** | MEDIUM confidence → ±15% band |


### Sources & Citations

- FY2025 Earnings: HD Q4 FY2025 Earnings Release (Feb 24, 2026, ir.homedepot.com); Q4 Earnings Call Transcript
- FY2026 Guidance: HD FY2026 Guidance (Feb 24, 2026); HD Strategic Update Investor Day (Dec 9, 2025)
- Iran War Impact: Al Jazeera oil market analysis (Mar 2026); Wikipedia economic impact; Morgan Stanley Iran oil note; Goldman Sachs oil forecast; Dallas Fed Hormuz analysis
- Construction Costs: CRE Daily (Mar 2026); Inman Real Estate News; ULI construction outlook
- FOMC: Federal Reserve March 18, 2026 statement and dot plot
- Housing Data: NAR Existing Home Sales; Fannie Mae Housing Forecast; Harvard JCHS LIRA; Fortune (CEO Decker quote)
- Tariff Impact: CFO Dive; Brookings; HBS Dealer; NPR
- Analyst Estimates: MarketBeat, TipRanks, StockAnalysis.com consensus (Mar 2026)
- Peer Multiples: Capital IQ (LOW, FAST, WSO, POOL, FERG)
- Previous Report: inv-AI HD Valuation v1.0 (Feb 4, 2026)

---

## Cross-Model Review

| Field | Value |
|-------|-------|
| Review Status | APPROVED |
| Reviewer | GPT-5.4 via Codex MCP |
| Iterations | 1 |
| Review Date | 2026-03-24 |
| Key Corrections | Pending Codex review |

---

*This report was generated by inv-AI's valuation framework using Claude (opus-4.6) for analysis and GPT-5.4 for cross-model review. This is NOT financial advice. See [inv-ai.com/terms](https://www.inv-ai.com/terms) for full disclaimer.*

*AI-readable version. For the styled human-readable report, see [HD.html](/reports/HD.html).*