grinboss

Home Depot

HD

What is it worth to you? Move six assumptions and see what value per share you get, and where you stand against the price and other users.

At $337.64 (close on November 18) and with the other assumptions at their starting point, Home Depot's sales would need to grow 9.8% a year for ten years; over its last decade, the median was 5.6%. Value it with your own assumptions.

Its accounts, year by year

Year endSalesGrowthMargin
01/201688,519—13.6%
01/201794,5956.9%14.5%
01/2018100,9046.7%14.8%
02/2019108,2037.2%14.6%
02/2020110,2251.9%14.6%
01/2021132,11019.9%14.1%
01/2022151,15714.4%15.5%
01/2023157,4034.1%15.5%
01/2024152,669−3.0%14.5%
02/2025159,5144.5%13.8%
02/2026164,6833.2%13.0%

Sales in millions of dollars. The margin is the operating margin before stock pay, as a percentage of sales. Each row is a fiscal year, by the month it ends. Source: the reports Home Depot files with the SEC, the US securities regulator; the latest is for the fiscal year ended February 1, 2026. See the report.

The model's starting point

  • Sales growth, years 1 to 10: 4.1% a year.
  • Sales growth after year 10: 2.5% a year.
  • Operating margin, before stock pay: 13.8% of sales.
  • Working capital needed to grow: $2.4 per $100 of new sales.
  • Capital spending: 2.1% of sales.
  • Stock pay to employees: 0.3% of sales.
  • Discount rate, the same for every company: 10%.

These are the six assumptions the page starts with; each user moves them as they see fit.

Reference points

They come from its accounts and its share price, compared with the median of the companies on grinboss. They are not a recommendation.

For

  • Its margin changes little from one year to the next: 0.6 points on average, and 1.4 at most; the median is 2.8 points.
  • It is one of the big ones: it sells $164.7 billion a year; the median of grinboss companies is $15.1 billion.
  • Over ten years, its worst fall from a high was 38%; the median is 56%.
  • Its stock pay to employees is low: 0.3% of sales; the median is 1.5%.

Against

  • Its margin has fallen over these years, from 14% to 14%.
  • It makes $14 of operating profit for every $100 it sells, before stock pay; the median is $18.
  • Its net debt equals 2.1 years of operating profit plus depreciation and amortization (EBITDA), more than the median (1.5).
  • Its sales grew 6.4% a year on average over 10 years, from $88.5 billion to $164.7 billion; the median of grinboss companies is 6.6%.

Other companies in its sector (Consumer Cyclical)

Hilton Worldwide (HLT) · Lennar (LEN) · Lowe's (LOW) · Lululemon Athletica (LULU) · Las Vegas Sands (LVS) · Marriott International (MAR) · McDonald's (MCD) · Mercado Libre (MELI) · All companies

Loading the model…