Three-statement Excel model · 22 quarters and 5 fiscal years of history · 10 quarters and 5 fiscal years of projections
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.
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 | ||||||
|---|---|---|---|---|---|---|
| Actual | Estimate | |||||
| FY23 | FY24 | FY25 | FY26E | FY27E | FY28E | |
| Net sales - retail | $146,076 | $146,218 | $145,032 | $147,669 | $150,428 | $153,436 |
| Net sales - HD Supply | 6,593 | 6,890 | 6,934 | 6,864 | 7,070 | 7,282 |
| Net sales - SRS Distribution and GMS (Other segment) | 0 | 6,406 | 12,717 | 17,129 | 18,157 | 19,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 Margin | 33.4% | 33.4% | 33.3% | 33.1% | 33.1% | 33.0% |
| Operating Margin | 14.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 Margin | 9.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.
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
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.