Large Trader AI

The Home Depot Inc (HD)

Consumer DiscretionaryHome Improvement RetailFairly valued

Price: $348.69 · Nov 13, 2026Analysis of Nov 9, 2026

Fair value

Fair value · Low
$235.10
Fair value · Mid
$293.87
Fair value · High
$352.65

Scorecard

Five subjects rated by the server with fixed thresholds. No overall grade: each colour shows where the strength or the weakness is.

Financial strengthStrong2 good · 2 neutral · 0 weak
ProfitabilityAverage1 good · 3 neutral · 0 weak
Earnings qualityStrong2 good · 1 neutral · 0 weak
GrowthAverage1 good · 3 neutral · 0 weak
ValuationFairly valued
Insolvency riskLow1.5% (estimate of the Ohlson model, 1-2 years)

Altman zone: Safe (Z 5.75) · annual report of Jan 31, 2026

Price and fair valueValue (USD)PriceFair value

Fairly valued

Price and fair value200400Nov 30, 2015May 28, 2021Nov 9, 2026+30%+10%-10%-30%

Analysis

Conclusion

The Home Depot is a United States home improvement retailer. It sells building materials, décor, lawn and garden products and facilities maintenance supplies, and it also offers installation services and tool rental. At 353.42 USD on 2026-11-09, the market capitalisation is 352.6 billion USD.

The verdict is overvalued. Today's multiples sit above their own ten-year medians: price to earnings is 24.8x against a median of 23.1x (a premium of 7.2%), enterprise value to EBITDA is 16.2x against 14.2x (14.4%), and price to free cash flow is 23.3x against 21.3x (9.8%). The DCF gives 257.93 USD per share at a discount rate of 9.61%, and the fair value from historical multiples is 329.82 USD. The fair value band runs from 235.10 to 352.65 USD with a midpoint of 293.87 USD, giving a margin of safety of -16.9% at the current price. The reverse DCF implies growth of 9.5% a year, while revenue grew 4.5% a year over five years and free cash flow per share fell 3.5% a year over the same period.

What holds the case up is a return on invested capital of 20.9% against a WACC of 8.7%, free cash flow conversion of 106.1% over the last twelve months, and interest coverage of 8.76x. What would break it is the gap between the growth the price implies and the growth delivered, the three-year EPS decline of 5.2% a year, and leverage with net debt at 2.37x EBITDA and a current ratio of 1.08.

Financial health

The colour of financial strength is green, held up by the Altman Z-score of 5.75 and interest coverage of 8.76x. The current ratio of 1.08 and net debt to EBITDA of 2.37x are neutral, and the quick ratio is 0.26. Debt to equity stands at 3.77. The Altman Z-score is in the safe zone, but the model was designed for manufacturers, and this company is a retailer. Insolvency risk: low, about 1.5% by the estimate of the Ohlson model over one to two years. The Ohlson estimate is based on figures as of 2026-01-31. Taken together, the balance sheet carries debt that is serviced comfortably, but liquidity is thin, so the company depends on steady cash generation to meet short-term obligations.

Earnings quality

The colour of earnings quality is green. Free cash flow conversion is 106.1% over the last twelve months and 93.3% on a five-year average. The accrual ratio is -2.2%, which means reported earnings are backed by cash. Stock-based compensation is 0.33% of revenue, and free cash flow after it is 14.54 billion USD. The share count fell 1.6% a year over five years, which reflects buybacks. The Piotroski score is 4 out of 9. The Beneish M-score is not available. Over the last eight quarters the company beat estimates four times and missed four times, with an average surprise of 1.1%. Next-year estimates were cut by 1.0% over 90 days, with three downward revisions and none upward in the last 30 days.

Profitability

The colour of profitability is yellow. Gross margin is 33.2% against a ten-year median of 33.8%. Operating margin is 12.4% against 14.3%, and net margin is 8.4% against 9.8%. Margin stability is 5.1%. Return on invested capital is 20.9% against a WACC of 8.7%, a given spread of 12.2%, but the five-year median ROIC is 33.6%, so returns have narrowed. Return on equity of 85.6% is inflated by leverage. The DuPont split shows a net margin of 8.6%, an asset turnover of 1.57x and an equity multiplier of 8.2x. Most of the headline return comes from the balance sheet, not from margins alone.

Growth

The colour of growth is yellow. Revenue compounded 1.5% a year over three years, 4.5% over five and 6.4% over ten. Earnings per share fell 5.2% a year over three years, rose 3.5% over five and rose 10.0% over ten. Free cash flow per share grew 4.2% over three years but fell 3.5% over five and rose 7.5% over ten. Revenue grew in nine of the last ten comparable years. Consensus expects earnings per share growth of 6.2% for next year, a figure the company has not yet delivered on a sustained basis.

Valuation

The colour of valuation is red, because the verdict is overvalued. Price to earnings is 24.8x against a ten-year median of 23.1x, a premium of 7.2%. Enterprise value to EBITDA is 16.2x against 14.2x, a premium of 14.4%, and price to free cash flow is 23.3x against 21.3x, a premium of 9.8%. Price to book is 21.2x against a median of 95.7x, a discount of 77.8%, but that median rests on seven data points. The DCF gives 257.93 USD per share with a discount rate of 9.61% and a terminal share of 53.4%. The reverse DCF implies growth of 9.5%, against 4.5% revenue growth and -3.5% free cash flow per share growth over five years. The dividend yield is 2.6% and the payout on free cash flow is 61.1%.

Risks

Each weak number carries its own risk. Leverage at 2.37x EBITDA and a current ratio of 1.08 leave little room if sales slow, because debt would need to be refinanced from cash flow. A falling return on invested capital, from a five-year median of 33.6% to 20.9% today, would narrow the spread over the 8.7% WACC. Three years of EPS decline, at -5.2% a year, cut against the valuation premiums. The Beneish M-score, the debt maturity schedule and revenue by segment are not available, so the analysis cannot test earnings manipulation or the timing of refinancing. The fair value band is an order of magnitude built on fixed assumptions, including a 5% equity risk premium and capped growth, and is not a price target.

Metrics

Company
NameThe Home Depot Inc
SectorConsumer Cyclical
SymbolHD.US
CountryUSA
CurrencyUSD
IndustryHome Improvement Retail
DescriptionThe Home Depot, Inc. operates as a home improvement retailer in the United States and internationally. It sells various building materials, home improvement products, lawn and garden products, and décor products, as well as facilities maintenance, repair, and operations products. The company also offers installation services for flooring, water heaters, baths, garage doors, cabinets, cabinet makeovers, countertops, sheds, furnaces and central air systems, windows, and window coverings. In addition, it provides tool and equipment rental services. The company serves consumers, such as do-it-yourself homeowners and do-it-for-me customers; and professional renovators/remodelers, general contractors, homebuilders, maintenance professionals, handymen, property managers, building service contractors and specialty tradespeople, such as electricians, landscapers, insulation installers, plumbers, painters, pool contractors, roofers, and wallboard and ceiling installers. It sells its products through websites and its mobile applications, including homedepot.com; homedepot.ca and homedepot.com.mx; blinds.com, justblinds.com, and americanblinds.com for custom window coverings; constructionresourcesusa.com or design-oriented surfaces, appliances, and architectural specialty products; thecompanystore.com, an online site for textiles and décor products; hdsupply.com for maintenance, repair, and operations products and related services; and srsdistribution.com, heritagelandscapesupplygroup.co
Fiscal year endJanuary
Data dates
Price2026-11-09
Statements2026-07-31
Risk free date2026-11-09
Fundamentals fetched at2026-11-08T03:31:10.313Z
Market
Beta0.947
Price353.42
Market cap352,603,467,621
Quote unitUSD
Shares now997,689,626
Risk free rate0.0487
Risk free symbolUS10Y
Enterprise value413,085,467,621
Financial health
Altman z5.7493SAFE
Quick ratio0.2586
Current ratio1.0781WATCH
Debt to equity3.7652
Net debt to ebitda2.3743WATCH
Interest coverage8.7595OK
Debt vs revenue growth5y0.0401
Earnings quality
Beneish › M—
Beneish › Label—
Piotroski › Score4
Piotroski › Passed4
Piotroski › Evaluable9
Fcf after sbc14,541,000,000
Accrual ratio-0.0216
Sbc to revenue0.0033
Fcf conversion5y0.9327
Fcf conversion ttm1.0614
Share count cagr5y-0.0155
Earnings surprises › Beats4
Earnings surprises › Misses4
Earnings surprises › Quarters8
Earnings surprises › Average surprise pct1.1498
Estimate revisions › Next year › Growth0.0618
Estimate revisions › Next year › Change90d-0.0104
Estimate revisions › Next year › Up last30d0
Estimate revisions › Next year › Down last30d3
Estimate revisions › Current year › Change90d0.0038
Estimate revisions › Current year › Up last30d3
Estimate revisions › Current year › Down last30d2
Profitability
Roic0.2089
Wacc0.0872
Dupont › As of2026-01-31
Dupont › Net margin0.086
Dupont › Asset turnover1.567
Dupont › Equity multiplier8.2022
Tax rate0.239
Net margin0.0841
Cost of debt0.0487
Gross margin0.3321
Cost of equity0.0961
Roic median5y0.336
Roic minus wacc0.1217CREATES_VALUE
Return on equity0.8562
Net margin median0.0983
Operating margin0.1243
Gross margin median0.3379
Operating margin median0.1428
Operating margin stability0.0514
Growth
Eps › Cagr3y-0.0524
Eps › Cagr5y0.0353
Eps › Cagr10y0.1002
Revenue › Cagr3y0.0152
Revenue › Cagr5y0.0451
Revenue › Cagr10y0.064
Fcf per share › Cagr3y0.0419
Fcf per share › Cagr5y-0.0354
Fcf per share › Cagr10y0.0754
Revenue growth consistency › Growing years9
Revenue growth consistency › Comparable years10
Valuation
Dcf › G10.0618
Dcf › G t0.025
Dcf › Fcf014,541,000,000
Dcf › Discount rate0.0961
Dcf › Terminal share0.5336
Dcf › Fair value per share257.93
Current › Pb21.2194
Current › Pe24.7841
Current › Ps2.0842
Current › P fcf23.3497
Current › Fcf yield0.0428
Current › Ev to ebitda16.216
Current › Earnings yield0.0403
VerdictOVERVALUED
Fair value › Low235.0994
Fair value › Mid293.8743
Fair value › High352.6492
Fair value › Margin of safety-0.1685
Historical › Pb › Median95.6607
Historical › Pb › Points7
Historical › Pb › Current21.2194
Historical › Pb › Premium pct-0.7782
Historical › Pe › Median23.129
Historical › Pe › Points10
Historical › Pe › Current24.7841
Historical › Pe › Premium pct0.0716
Historical › Ps › Median2.0323
Historical › Ps › Points10
Historical › Ps › Current2.0842
Historical › Ps › Premium pct0.0256
Historical › P fcf › Median21.26
Historical › P fcf › Points10
Historical › P fcf › Current23.3497
Historical › P fcf › Premium pct0.0983
Historical › Ev to ebitda › Median14.178
Historical › Ev to ebitda › Points10
Historical › Ev to ebitda › Current16.216
Historical › Ev to ebitda › Premium pct0.1437
Reverse dcf › Implied growth0.0951
Reverse dcf › Vs revenue cagr5y0.0501
Reverse dcf › Vs fcf per share cagr5y0.1306
Historical fair value329.8187
Dividend
Yield0.0262
Payout on fcf0.6106
Forward yield0.0271
Data flags
Prices staleNo
Risk free staleNo
Fundamentals staleNo

Similar companies