HDHome Depot

Consumer discretionary · Home Improvement Retail · NYSE

The Home Depot, Inc. is the world’s largest home improvement retailer based on net sales for fiscal 2025. 10-K, Item 1

Employees: 472,400
Headquarters: Atlanta, GA
Next results: around Nov 17, 2026

This is a calculator, not a valuation. It answers one question: how fast would free cash flow have to grow for the share price to make sense, with the assumptions you choose. Tickdelta does not estimate what HD is worth.

From the filings and the price source

Share price No licensed price source is set up. Type the price you see at your broker. Free cash flow, last 12 months ($) Cash from operations (NetCashProvidedByUsedInOperatingActivities, 10-K 0001628280-26-019436) minus capital spending (PaymentsToAcquireProductiveAssets, 10-K 0001628280-26-019436); TTM to 2026-08-02 Shares outstanding EntityCommonStockSharesOutstanding 2026-08-18 Debt minus cash ($) Debt (LongTermDebtAndCapitalLeaseObligations 2026-08-02, 10-Q 0001628280-26-058715 + LongTermDebtAndCapitalLeaseObligationsCurrent 2026-08-02, 10-Q 0001628280-26-058715 + CommercialPaper 2026-08-02, 10-Q 0001628280-26-058715) minus cash (CashAndCashEquivalentsAtCarryingValue 2026-08-02, 10-Q 0001628280-26-058715)

Your assumptions

Discount rate (%) The yearly return you want. 10% is a round starting point, not our estimate. Growth after that, forever (%) Usually near long-run inflation. Must be below the discount rate. Years of faster growth How long the faster growth lasts before the forever rate takes over.

Type a share price to see what it implies.

HD's free cash flow, last 5 years-5.0% a year

Revenue, last 5 years+4.5% a year

Free cash flow, longest history (10 years)+5.0% a year

Past growth is from the 10-Ks (see the Financials tab). It is there to compare against, not to predict.

Implied growth for other assumptions

Model: free cash flow grows at the implied rate for the chosen years, then at the forever rate. Each year is discounted at your rate, and debt minus cash is subtracted. Change any number above and everything recalculates. Not advice.

Work on HD in a spreadsheet: Excel workbook (a sheet per section, ten years by column, charts, links to the filings) · CSV. For a Google Sheet that stays up to date, paste =IMPORTDATA("https://tickdelta.com/company/HD/export.csv") into a cell.