← All financial models

The Home Depot (HD) Financial Model

📊 Download Model

Three-statement Excel model · 22 quarters and 5 fiscal years of history · 10 quarters and 5 fiscal years of projections

current ✓ C13 recon ✓ C14 trace ✓ C15 terminals

About the HD model

This three-statement Excel model covers The Home Depot, Inc. (HD): its income statement, balance sheet and cash flow statement. It holds 22 quarters and 5 fiscal years of history and 10 quarters and 5 fiscal years of projections.

Projected revenue is built from KPI drivers: Per-week rates × weeks in the fiscal period: retail = transactions × average ticket; HD Supply and SRS/GMS each on their own per-week growth rate; the three pieces sum to filed net sales, across 2 segments.

Beyond the income statement, the workbook has these sections: KPI Drivers, Balance Sheet and Cash Flow Statement.

Model thesis: Traffic stays negative into FY27E and SRS/GMS mix holds net margin at 8.5% against the Street's 10% by FY30E: the Hold expressed as drivers

On October 19, 2026, the model passed checks C13 (every subtotal reconciles to the reported figure at $0), C14 (every projected revenue cell traces to a KPI driver row) and C15 (each driver ends in a rate, a count or a historical anchor, never a typed-in projected dollar level). It was last updated September 28, 2026.

History
22 quarters and 5 fiscal years
Projections
10 quarters and 5 fiscal years
KPI
Per-week rates × weeks in the fiscal period: retail = transactions × average ticket; HD Supply and SRS/GMS each on their own per-week growth rate; the three pieces sum to filed net sales
Segments
2
Units
Dollars in millions, except per share data
Verified
Updated
File
Excel workbook (.xlsx), 175 KB
Access
Free account required: 3 different models a month at no charge, then $9 a month.

Income statement preview

Columns FY23–FY25 are actual results and FY26E–FY28E are our estimates. Figures were recalculated in Excel on September 28, 2026. Dollars in millions, except per share data.

Income statement preview for HD. Dollars in millions, except per share data. Actual fiscal years followed by our estimates.
Income Statement
ActualEstimate
FY23FY24FY25FY26EFY27EFY28E
Net sales - retail$146,076$146,218$145,032$147,669$150,428$153,436
Net sales - HD Supply6,5936,8906,9346,8647,0707,282
Net sales - SRS Distribution and GMS (Other segment)06,40612,71717,12918,15719,246
Total Net Sales$152,669$159,514$164,683$171,662$175,654$179,965
Less: Cost of Sales($101,709)($106,206)($109,818)($114,761)($117,589)($120,654)
Gross Profit$50,960$53,308$54,865$56,901$58,065$59,310
Less: Selling, General and Administrative($26,598)($28,748)($30,702)($32,181)($32,771)($33,395)
Less: Depreciation and Amortization (operating expense)(2,673)(3,034)(3,273)(3,436)(3,471)(3,452)
Total Operating Expenses($29,271)($31,782)($33,975)($35,617)($36,242)($36,847)
Operating Income$21,689$21,526$20,890$21,284$21,823$22,464
Interest Income and Other, net$178$201$124$148$176$180
Less: Interest Expense(1,943)(2,321)(2,412)(2,382)(2,384)(2,407)
Earnings Before Provision for Income Taxes$19,924$19,406$18,602$19,051$19,614$20,237
Less: Provision for Income Taxes(4,781)(4,600)(4,446)(4,643)(4,707)(4,857)
Net Earnings$15,143$14,806$14,156$14,408$14,907$15,380
Ratios & Assumptions
YoY Total Net Sales Growth(3.0%)4.5%3.2%4.2%2.3%2.5%
Gross Margin33.4%33.4%33.3%33.1%33.1%33.0%
Operating Margin14.2%13.5%12.7%12.4%12.4%12.5%
Adjusted Operating Margin (Non-GAAP)14.2%13.6%12.9%12.8%12.8%12.8%
Net Margin9.9%9.3%8.6%8.4%8.5%8.5%

The full workbook adds 22 historical and 10 projected quarters, plus KPI Drivers · Balance Sheet · Cash Flow Statement — every subtotal a live formula, every projection traced to a driver.

Download the full HD model (xlsx)3 free models a month with an account, then $9 a month

The Home Depot research

Aardvark Labs Capital Research has published 4 reports on The Home Depot (HD). The latest is the Q2 FY26 Earnings Recap, published August 19, 2026, rated Hold.

The Beat Came From Washington, Not the Aisles: Downgrading HD to Hold as the De-Rating Trade Runs Out of Room

All HD research →

Methodology

Every projected revenue cell traces to a KPI/driver row (C14). Terminal driver cells are rates, counts, or historical anchors — never typed-in projected dollar levels (C15). Every subtotal-vs-reported reconciliation row ties to $0 (C13). Each model is written per-ticker against its actual schema — no cloning, no level-input shortcuts.