Is there a margin of safety in Home Depot at $347.51 after the Q3 FY2026 print on 17 November 2026: BUY, HOLD or SELL?

SELL after the Q3 FY2026 print: the base DCF gives $255.51 a share, (26.5%) against the 16 November close of $347.51.

Home Depot · Q3 FY2026 · Published · Data cut-off: 2026-11-17 · By DeepCell AI · Sources

1 · Cover

SELL after the print: Home Depot is worth $255.51 a share against a 16 November close of $347.51


No margin of safety at this price.The base DCF is -26.5% against the price; a SELL is anything more than 10% below, which is under $313 today.
The quarter did not change it.Q3 beat consensus by 0.5% on adjusted EPS and the sales guide rose, but margins are guided to the low end. A BUY needs the price at or below $222; above $284 it stays a SELL.
Even a housing recovery does not close the gap.Faster transactions and SG&A leverage are worth $281.33, -19.0% against the price.
The cross-check is closer.A 14x exit multiple gives $326.16, which alone would be a HOLD; the average target is $371.71, 7.0% above the price.

Value per share by case, USD, against the 16 November close

Per shareAgainst the price
Average analyst target$371.717.0%
Housing turnover recovers$281.33-19.0%
Base value, Gordon growth$255.51-26.5%
Base value, exit multiple$326.16-6.1%
Margin squeeze$238.80-31.3%
Housing stays frozen$230.18-33.8%

2 · Our view

Q3 FY2026: sales of $43.4 billion and adjusted EPS of $3.86, just above consensus of $42.8 billion and $3.84


Sales beat.Up 4.9% on $41.4 billion, 1.4% above $42.8 billion (3.5%); comps 2.2%, our 1.5%.
Margin missed, costs held.Gross margin 32.8%, our 33.1%; SG&A of 18.2% held operating margin at 12.6%.
EPS in line.Adjusted $3.86, consensus $3.84, last year $3.74; we had $3.82 on $42.8 billion sales.

Exhibit 1: Q3 FY2026: reported against expectations

Consensus, our forecast and the reported figure

Net sales in USD millions
Q3 FY2026 · ConsensusQ3 FY2026 · Our forecast before resultsQ3 FY2026 · Actual
Net sales$M42,810.042,799.343,398.0
Comparable sales growth%1.48%2.20%
Gross margin%33.1%32.8%
Diluted EPS (adjusted, excl. acquired intangible amortization)$3.843.823.86

3 · The quarter

Ticket, not traffic, is carrying the comp: transactions fell again in Q3, by less


Transactions still fall.Comparable transactions were -1.6% in Q3 FY2025, -1.3% in Q1, -1.0% in Q2 and -0.5% in Q3 FY2026.
Ticket does the work.Q3 comps of 2.2% came from a 3.0% higher ticket (Q2: 1.7% from 2.8%).
Our base case waits for housing.Comps of 1.4% in FY2026E; transactions 0.0% in FY2027E and comps reaching 3.5% in FY2028E.

Exhibit 2: Reported quarters: Q3 FY2025, Q1 to Q3 FY2026 and the first half

Change on the prior year, as reported

Reported quarters: Q3 FY2025, Q1 to Q3 FY2026 and the first half
Comparable sales growth (%)Comparable customer transactions (% change) (%)Comparable average ticket (% change) (%)
Q3 FY2025A0.20%-1.60%1.80%
Q1 FY2026A0.60%-1.30%2.20%
Q2 FY2026A1.70%-1.00%2.80%
Q3 FY20262.20%-0.50%3.00%

4 · Traffic and ticket

Growth now comes from SRS and GMS: the stores shrank in FY2025 while the Other segment doubled


Stores (Primary).$152.0 billion in FY2025 against $153.1 billion in the 53-week FY2024.
SRS and GMS (Other).$12.7 billion in FY2025 from $6.4 billion, 7.7% of net sales, rising to 10.9% by FY2030E.
Acquired growth has a cost.It carries intangible amortization and lower gross margin, and it was bought: acquisitions were $17.6 billion in FY2024.

Exhibit 3: Stores (Primary) and SRS plus GMS (Other) net sales, FY2023A to FY2030E (USD millions)

USD millions; FY2026E onward is our forecast

5 · Segments

Operating margin went from 14.2% to 12.7%; we model a slow climb to 13.4% by FY2030E


Gross margin is guided to the low end.33.3% in FY2025 against the 33.0% guide for FY2026; Q3 was 32.8%; 33.3% by FY2030E.
SG&A is the lever.18.6% of sales in FY2025, falling to 17.9% in our base case as comps recover.
FY2026E sits at the guide.Operating margin of 12.4% against guidance of about 12.4%, the low end of the earlier range.

Exhibit 4: Gross margin and operating margin, FY2023A to FY2030E

GAAP; FY2026E onward is our forecast

6 · Margins

Free cash flow was $12.6 billion in FY2025: enough for the dividend, not yet for buybacks


Cash conversion.Free cash flow was 89% of net earnings in FY2025 and $9.7 billion in the first half of FY2026.
Dividends come first.Cash dividends were $9.2 billion in FY2025; repurchases were zero after SRS.
Leverage is still elevated.Net debt was $50.8 billion on 2 August 2026, before operating leases.

Exhibit 5: Free cash flow against cash returned, FY2023A to FY2030E (USD millions)

USD millions; buybacks restart in FY2027E in our base case

7 · Cash and balance sheet

The base DCF gives $255.51 a share: -26.5% against the price


Discount rate.WACC 8.7%, terminal growth 3.0%; terminal value is 79% of enterprise value.
Cross-check.A 14x EV/EBITDA exit gives $326.16; the market pays 15.4x FY2026E EBITDA and 23.2x FY2026E adjusted EPS.
Stress cases.Housing frozen $230.18; margin squeeze $238.80; housing recovery $281.33.

Exhibit 6: Value per share by case, beside the price and the analyst target (USD)

USD per share; price is the 16 November close

8 · Valuation

What the print changed: a higher sales guide, margins at the low end, and still no recovery in traffic


Traffic.Transactions were -0.5%, not positive, so the housing-recovery case, worth $281.33, is not yet in view.
Gross margin.Q3 at 32.8% against our 33.1%: below forecast, not far enough for the margin squeeze case, worth $238.80.
The guide.Sales growth now 4.5%, comps 1.4%; our FY2026E adjusted EPS of $15.01 sits beside the $14.98 guide and $15.01 consensus, and needs Q4 sales growth of 2.3%.

Levels at which the rating changes, and where Q3 landed

LevelNow
Share price for a BUY at our valueat or below $222$347.51
Share price above which it stays a SELLabove $284$347.51
Q3 adjusted EPS against consensus$3.84$3.86
Q3 comparable sales against our forecast1.5%2.2%

Final stance: SELL. None of the three conditions for a higher rating was met.

9 · What would change the rating

We forecast $42.8 billion and $3.82; Home Depot reported $43.4 billion and $3.86, and the SELL stands


What we said.A provisional SELL at $347.51; the value is now $255.51 a share after the new guide.
What happened.Comps 2.2%, gross margin 32.8%; sales +1.4% and adjusted EPS +1.1% against our forecast.

Exhibit 7: Net sales and net earnings, FY2023A to FY2030E (USD millions)

USD millions; FY2026E onward is our forecast

10 · What we said and what happened

Sources

Not investment advice. Any rating here is this model's view of value against price at the data cut-off.

Built in DeepCell Every figure on these slides opens its formula and its source. See how a review like this is made.

Share this review

Send the link: it opens with the picture below, and every number on the page still opens its formula and source. The picture is free to download and share.

More valuation reports

All valuation reports