Hurdle Test
The Home Depot Inc
HD|Consumer Cyclical|Home Improvement Retail|Fiscal year ends January|Latest annual filing FY2026, the year ended Jan 31, 2026
$295.47
Staying power
Discipline
Revenue growthNot cleared
6.4%
a year, FY2017 to FY2026
Rule: 10-year CAGR at or above 8%
EBITDA growthNot cleared
5.5%
a year, operating income plus D&A
Rule: 10-year CAGR at or above 8%
Free cash flowNot cleared
4.9%
a year after stock comp; 3-year margin 9.6%
Rule: growth at or above 5%, margin at or above 10%
LeverageCleared
2.18x
net debt to EBITDA; 54.5B net debt
Rule: below 3.0x
Share countCleared
-2.3%
a year, FY2017 to FY2026; buybacks at least offset issuance
Rule: flat or falling over the period
Cash marginNot cleared
7.4%
latest free cash flow margin; 3-year average 9.6%
Rule: no more than 2% below the three-year average
Not clearedClears 1 of the four staying-power checks.FY2017 to FY2026Discipline 1 of 2Fundamentals Rating 57 (Solid)Methodology 2026-10-01.1Full analysis in Wealth Engine
Ten years of price against the hurdleMonth-end closes as traded, restated for splits
Price per shareHurdle price at the 16x exit, drawn flat from todayHurdle price at the last fiscal year-end multiple
Hurdle priceAn exhibit, not a check
$315price that returns 10% a year
over ten years, 16x exit
over ten years, 16x exit
Price vs hurdle6% below $295.47 last close
Modeled IRR at $295.4710.9%
Exit EV/EBITDA15.5x 10-yr median 15.6x, last FYE 17.1x
EBITDA growth path4% to 4% lesser of 5-yr 3.8% and 10-yr 5.5%, capped at 12%
Base cash flow per share$15.87 3-yr FCF margin on the latest revenue
Year-10 sale value$514/sh less $54.5B net debt
Shares1.00B, held flat
Multiple vs own history1.10x the last fiscal year-end EV/EBITDA against the ten-year median
Read this as arithmetic, not advice. The hurdle price is what the stated inputs imply, and the back-test found that buying below it did not sort winners from losers. Change the exit multiple and it moves; the grid below shows by how much.
Capital allocation, FY2017 to FY2026$ billions, except shares, per-share figures and yield; fiscal years end in January
| Fiscal year | Operating cash flow | Stock comp | Capex | Free cash flow | Net borrowing | FCFE | Shares (B) | FCF per share | Year-end price | FCF yield |
|---|---|---|---|---|---|---|---|---|---|---|
| 2017 | 9.8 | 0.3 | 1.6 | 7.9 | +1.6 | 9.5 | 1.23 | $6.40 | $137.58 | 4.7% |
| 2018 | 12.0 | 0.3 | 1.9 | 9.9 | +1.9 | 11.8 | 1.18 | $8.33 | $200.90 | 4.1% |
| 2019 | 13.2 | 0.3 | 2.4 | 10.4 | +2.5 | 13.0 | 1.14 | $9.13 | $183.53 | 5.0% |
| 2020 | 13.7 | 0.3 | 2.7 | 10.8 | +1.9 | 12.7 | 1.10 | $9.84 | $228.10 | 4.3% |
| 2021 | 18.8 | 0.3 | 2.5 | 16.1 | +7.2 | 23.2 | 1.08 | $14.90 | $270.82 | 5.5% |
| 2022 | 16.6 | 0.4 | 2.6 | 13.6 | +0.8 | 14.4 | 1.06 | $12.86 | $366.98 | 3.5% |
| 2023 | 14.6 | 0.4 | 3.1 | 11.1 | +5.4 | 16.5 | 1.03 | $10.86 | $324.17 | 3.3% |
| 2024 | 21.2 | 0.4 | 3.2 | 17.6 | +0.8 | 18.3 | 1.00 | $17.53 | $352.96 | 5.0% |
| 2025 | 19.8 | 0.4 | 3.5 | 15.9 | +5.7 | 21.6 | 0.99 | $16.00 | $411.98 | 3.9% |
| 2026 | 16.3 | 0.5 | 3.7 | 12.1 | -2.1 | 10.0 | 1.00 | $12.16 | $374.59 | 3.2% |
| 9-yr CAGR | 5.9% | 7.7% | 9.5% | 4.9% | n/a | 0.6% | -2.3% | 7.4% | 11.8% | avg 4.3% |
Valuation, FY2017 to FY2026$ billions; market cap uses the fiscal year-end price
| Fiscal year | Revenue | EBITDA | EBITDA margin | Debt incl. leases | Cash & securities | Market cap | Enterprise value | EV / EBITDA | Net debt / EBITDA |
|---|---|---|---|---|---|---|---|---|---|
| 2017 | 94.6 | 15.4 | 16.3% | 22.3 | 2.5 | 170 | 190 | 12.3x | 1.29x |
| 2018 | 100.9 | 16.7 | 16.6% | 24.3 | 3.6 | 238 | 259 | 15.4x | 1.23x |
| 2019 | 108.2 | 17.7 | 16.3% | 26.8 | 1.8 | 210 | 235 | 13.3x | 1.42x |
| 2020 | 110.2 | 18.1 | 16.5% | 34.6 | 2.1 | 250 | 283 | 15.6x | 1.79x |
| 2021 | 132.1 | 20.8 | 15.7% | 42.0 | 7.9 | 292 | 326 | 15.7x | 1.64x |
| 2022 | 151.2 | 25.9 | 17.1% | 42.8 | 2.3 | 388 | 429 | 16.6x | 1.56x |
| 2023 | 157.4 | 27.0 | 17.2% | 49.1 | 2.8 | 332 | 379 | 14.0x | 1.72x |
| 2024 | 152.7 | 24.9 | 16.3% | 50.9 | 3.8 | 354 | 401 | 16.1x | 1.89x |
| 2025 | 159.5 | 25.3 | 15.9% | 57.4 | 1.7 | 409 | 465 | 18.4x | 2.20x |
| 2026 | 164.7 | 25.0 | 15.2% | 55.9 | 1.4 | 373 | 428 | 17.1x | 2.18x |
| 9-yr CAGR | 6.4% | 5.5% | avg 16.3% | 10.7% | -6.5% | 9.2% | 9.5% | median 15.6x | avg 1.69x |
How much depends on the exit multipleTen-year modeled IRR by purchase price and exit EV/EBITDA
| Purchase price | 10.5x | 13x | 15.5x median | 17x last FYE | 20.5x |
|---|---|---|---|---|---|
| $222 | 11.4% | 13.3% | 15.0% | 15.8% | 17.7% |
| $266 | 8.8% | 10.7% | 12.4% | 13.2% | 15.0% |
| $295 last close | 7.4% | 9.3% | 10.9% | 11.8% | 13.6% |
| $315 | 6.5% | 8.4% | 10.0% | 10.9% | 12.7% |
| $340 | 5.5% | 7.4% | 9.0% | 9.9% | 11.7% |
Clears the 10% hurdleWithin 3 pointsBelowGrowth path and base cash flow held constant across the grid
For put sellers
$315Strikes at or below this price are at or below the model's 10% return price at the 16x exit, before any premium collected. The back-test found no edge in that line; the staying-power record above is what sorted outcomes.
$338The same hurdle if the market keeps paying the last fiscal year-end multiple of 17.1x at exit.
BetweenStrikes between the two prices are a bet that the multiple holds, not that the business grows.
Coming next. The monthly put strikes at or below the hurdle price, with premium, annualized yield and Zone Score from the options pipeline, for members. See plans
NotesWritten from the filings by rule; no forecasts
Revenue grew 6.4% a year and EBITDA 5.5% a year from FY2017 to FY2026, and free cash flow after stock compensation grew 4.9% a year. The share count fell 2.3% a year through buybacks. Net debt stood at 2.2x EBITDA at the last fiscal year-end. At 17x EBITDA at the last fiscal year-end against a ten-year median of 16x, the model prices the last close of $295 as a 10.9% ten-year return; the grid shows how that changes if the multiple holds.
Trend check
7.4%Latest free cash flow margin, against a three-year average of 9.6%. The latest year is below trend, so the cash margin check is not cleared.
2%Capital spending as a share of revenue in the latest year, from 2% in FY2017. Rising capital intensity holds free cash flow back even when operating cash flow grows.
-0.3BSpent on buybacks in the latest fiscal year, 9.2B on dividends; the share count fell 2.3% a year over the period.
57Wealth Engine Fundamentals Rating (Solid), as of Oct 9, 2026: Financial Health 60, Execution 75, Moat 8 of 15, Growth 6.7 of 15.
Definitions
- Free cash flow is operating cash flow less stock-based compensation less capital spending. Stock comp is treated as a real cost.
- Net borrowing is the year's change in long-term debt. FCFE adds it back to free cash flow, the classic one-page definition.
- EBITDA is operating income plus depreciation and amortization. Debt includes lease obligations; cash includes short-term investments.
- Market cap uses the fiscal year-end price as traded, restated for later splits but not for dividends; enterprise value adds debt and subtracts cash.
- Share count is the yearly change in shares outstanding over the period; flat or falling clears. Cash margin is the latest free cash flow margin against its three-year average; within two points clears.
- Hurdle price is the present value, at the hurdle rate, of ten years of modeled free cash flow per share plus a year-10 sale at the exit multiple. It is shown as an exhibit: the 2011 to 2021 back-test found that buying below it did not sort winners from losers, so it is not scored.
- Cleared on a check means the number clears the stated rule; Not cleared means it does not. Durable, Holding and First year say how many fiscal years running the company has cleared all four staying-power checks (four or more, two or three, one); Partial and Not cleared count the checks it clears today. All of it is fact about the filings, not a rating of the stock.