MMarketMath

HD

Slow growerQuality: Medium (68/100)

Home Depot (The) · Consumer Discretionary · Home Improvement Retail

$337.43

52w 289.10 – 426.75

20y monthly, adjusted

Mkt cap

$336.5B

P/E

23.6

P/FCF

26.5

FCF yield

3.8%

ROE

110.5%

Shldr yield

2.7%

div 2.7% + bb 0.0%

What today's price assumes

At $336.5B, the market is pricing in 11.5% annual free-cash-flow growth for the next decade (10% discount rate, 2.5% terminal growth). Over the last ten years, FCF actually grew 4.9% per year — the price asks for acceleration beyond the historical record.

Simple DCF per-share range: $193 · $206 · $256 (4% / base / optimistic growth). An estimate, not a target.

Adjust the assumptions yourself →

Historical multiple lens

At its own median P/OCF of 13.3× across 19 years, HD would trade near $218/share (25th–75th percentile: $166–$260); it trades at 20.6× today.

Assumes the historical multiple regime persists — re-ratings can be permanent.

Growth record

Compound annual growth rates from as-filed 10-K data, split-adjusted

Rev 3y

+1.5%

Rev 5y

+4.5%

Rev 10y

+6.4%

EPS 5y

+3.6%

EPS 10y

+10.1%

FCF 5y

−5.0%

FCF 10y

+4.9%

Fundamentals

Fiscal 2008–2026, from SEC filings

Revenue

2008: $77.3B
2009: $71.3B
2010: $66.2B
2011: $68.0B
2012: $70.4B
2013: $74.8B
2014: $78.8B
2015: $83.2B
2016: $88.5B
2017: $94.6B
2018: $100.9B
2019: $108.2B
2020: $110.2B
2021: $132.1B
2022: $151.2B
2023: $157.4B
2024: $152.7B
2025: $159.5B
2026: $164.7B
$0$50.0B$100.0B$150.0B
08
12
16
20
24

Net income

2008: $4.4B
2009: $2.3B
2010: $2.7B
2011: $3.3B
2012: $3.9B
2013: $4.5B
2014: $5.4B
2015: $6.3B
2016: $7.0B
2017: $8.0B
2018: $8.6B
2019: $11.1B
2020: $11.2B
2021: $12.9B
2022: $16.4B
2023: $17.1B
2024: $15.1B
2025: $14.8B
2026: $14.2B
$0$5.0B$10.0B$15.0B
08
12
16
20
24

Free cash flow

2008: $2.2B
2009: $3.7B
2010: $4.2B
2011: $3.5B
2012: $5.4B
2013: $5.7B
2014: $6.2B
2015: $6.8B
2016: $7.9B
2017: $8.2B
2018: $10.1B
2019: $10.7B
2020: $11.0B
2021: $16.4B
2022: $14.0B
2023: $11.5B
2024: $17.9B
2025: $16.3B
2026: $12.6B
$0$5.0B$10.0B$15.0B
08
12
16
20
24

Diluted shares (lower is better)

2008: 1.9B
2009: 1.7B
2010: 1.7B
2011: 1.7B
2012: 1.6B
2013: 1.5B
2014: 1.4B
2015: 1.3B
2016: 1.3B
2017: 1.2B
2018: 1.2B
2019: 1.1B
2020: 1.1B
2021: 1.1B
2022: 1.1B
2023: 1.0B
2024: 1.0B
2025: 993.0M
2026: 995.0M
0500.0M1.0B1.5B
08
12
16
20
24

Margins

10%20%30%08111417202326
Net marginFCF marginGross margin

Capital returned (dividends + buybacks)

2008: $12.5B
2009: $1.6B
2010: $1.7B
2011: $4.2B
2012: $5.1B
2013: $5.7B
2014: $10.8B
2015: $9.5B
2016: $10.0B
2017: $10.3B
2018: $12.2B
2019: $14.7B
2020: $12.9B
2021: $7.2B
2022: $21.8B
2023: $14.5B
2024: $16.3B
2025: $9.6B
2026: $9.2B
$0$10.0B$20.0B
08
12
16
20
24

Cash vs long-term debt

$0$20.0B$40.0B08111417202326
CashLT debt

Quarterly

Discrete quarters from 10-Q filings; Q4 derived as fiscal year minus Q1–Q3. OCF is unwound from the year-to-date figures 10-Qs report. Compare to the same quarter a year ago — most businesses are seasonal.

Revenue by quarter

Q1'24: $37.3B
Q2'24: $42.9B
Q3'24: $37.7B
Q4'24: $34.8B
Q1'25: $36.4B
Q2'25: $43.2B
Q3'25: $40.2B
Q4'25: $39.7B
Q1'26: $39.9B
Q2'26: $45.3B
Q3'26: $41.4B
Q4'26: $38.2B
Q1'27: $41.8B
$0$20.0B$40.0B
24
24
25
26
27

Net income by quarter

Q1'24: $3.9B
Q2'24: $4.7B
Q3'24: $3.8B
Q4'24: $2.8B
Q1'25: $3.6B
Q2'25: $4.6B
Q3'25: $3.6B
Q4'25: $3.0B
Q1'26: $3.4B
Q2'26: $4.6B
Q3'26: $3.6B
Q4'26: $2.6B
Q1'27: $3.3B
$0$2.0B$4.0B
24
24
25
26
27
QuarterRevenueYoYNet incomeYoYEPSOCF
Q1'27$41.8B+4.8%$3.3B−4.2%3.30$6.0B
Q4'26 *$38.2B−3.8%$2.6B−14.2%2.58$3.3B
Q3'26$41.4B+2.8%$3.6B−1.3%3.62$4.0B
Q2'26$45.3B+4.9%$4.6B−0.2%4.58$4.6B
Q1'26$39.9B+9.4%$3.4B−4.6%3.45$4.3B
Q4'25 *$39.7B+14.1%$3.0B+7.0%3.01$4.7B
Q3'25$40.2B+6.6%$3.6B−4.3%3.67$4.2B
Q2'25$43.2B+0.6%$4.6B−2.1%4.60$5.4B
Q1'25$36.4B−2.3%$3.6B−7.0%3.63$5.5B
Q4'24 *$34.8B−2.9%$2.8B−16.7%2.83$4.7B
Q3'24$37.7B−3.0%$3.8B−12.2%3.81$4.2B
Q2'24$42.9B−2.0%$4.7B−9.9%4.65$6.6B
Q1'24$37.3B−4.2%$3.9B−8.5%3.82$5.6B

Track record

Compound annual growth by period. For debt and share count, negative is the good direction.

Series3y5y10y15y
Revenue+1.5%+4.5%+6.4%+6.1%
Operating cash flow+3.8%−2.8%+5.7%+8.8%
Free cash flow+3.2%−5.0%+4.9%+9.0%
EPS (diluted)−5.2%+3.6%+10.1%+13.9%
Equity+101.7%+31.2%+7.3%−2.6%
LT debt+6.3%+7.3%+9.0%+12.3%
Diluted shares−1.0%−1.6%−2.5%−3.3%
Stock price+3.1%+3.2%+12.3%+19.4%

$100, 3 years ago

$110vs $176 in SPY

3.1% vs 20.7%/yr

$100, 5 years ago

$117vs $181 in SPY

3.2% vs 12.6%/yr

$100, 10 years ago

$319vs $412 in SPY

12.3% vs 15.2%/yr

$100, 15 years ago

$1,425vs $813 in SPY

19.4% vs 15.0%/yr

The $1 test — market value created per $1 of earnings retained (Buffett's hurdle: at least $1)

Last 5 years

$3.58

$130.4B created / $36.4B retained

Last 10 years

$3.93

$249.8B created / $63.5B retained

Quality & capital discipline

Cash-based returns and how management deploys capital

Cash ROIC

26.2%

OCF ÷ (equity + debt)

OCF / EV yield

4.3%

MC vs 10× OCF

2.05

≤1 = priced under 10× OCF

Debt / FCF

3.9y

SBC / FCF

4.1%

Owner earnings

$12.1B

OCF − capex − SBC

OE yield

3.6%

Share count 5y

−3.4%

per year; negative = buybacks

Capital intensity

net PP&E ÷ revenue

Sales efficiency

$0.08

new PP&E per $1 new revenue, 5y

Growth engine (5y): reinvested 34.7% of operating cash flow at an incremental return of -8.2% — an organically fundable growth rate of about -2.8% per year (growth ≈ reinvestment rate × incremental ROIC).

Checklist

19 of 27 checks pass · 70%. Checks with structurally missing inputs are excluded.

Growth & Consistency

3/7

  • Revenue growth

    4.5% · 5y CAGR ≥ 5%

    fail
  • EPS growth

    3.6% · 5y CAGR ≥ 5%

    fail
  • FCF growth

    -5.0% · 5y CAGR ≥ 5%

    fail
  • Revenue rises consistently

    8 of 9 · up in ≥ 7 of last 10 years

    pass
  • FCF consistently positive

    10 of 10 · positive in ≥ 8 of last 10 years

    pass
  • Profitable every year

    10 of 10 · net income > 0 in ≥ 8 of last 10

    pass
  • Cash flow keeps up with sales

    -2.8% vs 4.5% · OCF CAGR ≥ 0.9× revenue CAGR

    fail

Profitability

7/7

  • Net margin

    8.6% · ≥ 8%

    pass
  • Operating margin

    12.7% · ≥ 10%

    pass
  • Gross margin stable or rising

    33.3% vs 33.5% · no drop > 2 pts over 3y

    pass
  • Return on equity

    110.5% · ≥ 12%

    pass
  • Cash ROIC

    26.2% · ≥ 12%

    pass
  • FCF margin

    7.7% · ≥ 5%

    pass
  • Earnings back their cash

    OCF $16.3B vs NI $14.2B · OCF ≥ net income (latest FY)

    pass

Balance Sheet

2/5

  • Debt payable from cash flow

    3.9y · LT debt ≤ 3× FCF

    fail
  • Cash cushion

    3% · cash ≥ 50% of LT debt

    fail
  • Leverage

    3.86 · LT debt ≤ 1.5× equity

    fail
  • Equity positive and compounding

    $12.8B · equity > 0 and grew over ~5y

    pass
  • Interest burden

    12% · interest ≤ 15% of operating income

    pass

Capital Allocation

4/4

  • Share count flat or shrinking

    -3.4% · ≤ +0.5%/yr over ~5y

    pass
  • Stock comp restrained

    4% · SBC ≤ 15% of FCF

    pass
  • Distributions funded by FCF

    72% · dividends + buybacks ≤ 100% of FCF

    pass
  • Repurchases are a habit

    9 of 10 · buybacks in ≥ 5 of last 10 years

    pass

Valuation Discipline

3/4

  • FCF yield

    3.8% · ≥ 3%

    pass
  • Earnings multiple

    23.6 · P/E ≤ 25

    pass
  • Price asks less than history delivered

    11.5% vs 4.9% · implied FCF growth ≤ historical FCF CAGR

    fail
  • Shareholder yield

    2.7% · dividends + buybacks ≥ 2% of market cap

    pass

Financial data

As filed in 10-Ks; per-share figures split-adjusted. $ in millions.

FYRevenueGross profitOp incomeNet incomeEPSOCFCapExFCFDividendsBuybacksSBCCashLT debtEquityShares
2026164,68354,86520,89014,15614.2316,3253,67912,6469,15205221,38949,39712,813995
2025159,51453,30821,52614,80614.9119,8103,48516,3258,9296494421,65951,3656,640993
2024152,66950,96021,68915,14315.1121,1723,22617,9468,3837,9513803,76042,1501,0441,002
2023157,40352,77824,03917,10516.6914,6153,11911,4967,7896,6963662,75741,1501,5621,025
2022151,15750,83223,04016,43315.5316,5712,56614,0056,98514,8093992,34336,400-1,6961,058
2021132,11044,85318,27812,86611.9418,8392,46316,3766,4517913107,89534,7503,2991,078
2020110,22537,57215,84311,24210.2513,6872,67811,0095,9586,9652512,13329,500-3,1161,097
2019108,20337,16015,53011,1219.7313,1652,44210,7234,7049,9632821,77826,807-1,8781,143
2018100,90434,35614,6818,6307.2912,0311,89710,1344,2128,0002733,59524,2671,4541,184
201794,59532,31313,4277,9576.459,7831,6218,1623,4046,8802672,53822,3494,3331,234
201688,51930,26511,7747,0095.469,3731,5037,8703,0317,0002442,21620,7896,3161,283
201583,17628,38910,4696,3454.718,2421,4426,8002,5307,0002252,21616,8699,3221,346
201478,81226,9159,1665,3853.767,6281,3896,2392,2438,5462281,92914,69112,5221,434
201374,75425,8427,7664,5353.006,9751,3125,6631,7433,9842182,4949,47517,7771,511
201270,39524,2626,6613,8832.476,6511,2215,4301,6323,4702151,98710,75817,8981,570
201167,99723,3045,8393,3382.014,5851,0963,4891,5692,6082145458,70718,8891,658
201066,17622,4124,8032,6611.575,1259664,1591,5252132011,4218,66219,3931,692
200971,28823,9904,3592,2601.345,5281,8473,6811,521701765199,66717,7771,686
200877,34925,9977,2424,3952.375,7273,5582,1691,70910,81520744517,7141,856

Some concepts are structurally absent for certain industries (banks report no gross profit or capex). Missing ≠ zero.