The Home Depot, fiscal 2025

Prompts v2.26, run through the harness on claude-opus-5-5 on 2026-10-06, with these files: statements.xlsx, annual-report-FY2025-02-02-key-sections.txt, annual-report-FY2026-02-01-key-sections.txt, earnings-release-Q4-FY2025-02-02.txt, earnings-release-Q4-FY2026-02-01.txt. Every quotation and figure below was checked against the filings afterwards; the checker's reports are in the repository beside the replies. Nothing here is edited, except that a dash the model drew as an em-dash is shown as a hyphen.

A large retailer with two recent acquisitions and no known accounting problem. Notice that nothing is called a contradiction, every reading is ordinary or can't tell, and the report still gives an analyst five places to look.

Contents: The report · Prompt 1, scan the numbers · Prompt 2, follow the flags · Prompt 3, read the footnotes · Prompt 4, compare the footnotes

The report

The Home Depot: fiscal 2025 (52 weeks to 1 February 2026), compared with fiscal 2024 (53 weeks to 2 February 2025) Sources: the key sections of both 10-Ks, both Q4 results releases and statements.xlsx. Below, "text-1" and "text-2" are my two earlier replies; "numbers-1" and "numbers-2" are the pasted replies. Sizes are shares of fiscal 2025 pre-tax income of $18,602m.

No company sentence was contradicted by its own numbers or by another sentence, so nothing reaches level 1. Items 1–4 are level 2; item 5 is level 3.

Items to investigate

1. Operating margin and SG&A: Primary SG&A is outgrowing sales, partly explained by an unquantified "non-recurring" legal benefit

2. Acquired intangibles: long lives, and amortization excluded from adjusted results

3. Merchandise inventory: a build the company does not explain, while shrink review moved out of the critical audit matters

4. Receivables: days sales outstanding rising, an allowance with no figure, and a risk factor now saying Pros "increasingly" use trade credit

5. SRS goodwill: test passed with no stated headroom against thin segment earnings

Also noted

Checked and explained

Not examined

These documents don't include related parties (Item 13), Schedule II, or balances for the allowance, returns or shrink reserves. Receivables and inventory are not split by segment, and the legal benefit has no amount.

Items to investigate, not conclusions. The verdicts are the analyst's.

Prompt 1, scan the numbers

Measure FY Jan-22 FY Jan-23 FY Jan-24 FY Feb-25 (53 wk) FY Feb-26 Q4 Feb-25 (14 wk) Q4 Feb-26 (13 wk) Industry
Days sales outstanding 7.7 7.9 11.4 12.4 12.1 13.3
Days inventory 86.6 75.1 81.9 85.6 86.2 91.3
Days payable 39.8 35.9 41.7 38.1 43.9 40.6
Receivables minus revenue growth (pp) +3.3 +42.8 +10.9 +33.2 +17.9
Inventory minus cost-of-sales growth (pp) −12.9 +7.4 +6.7 −2.8 +13.6
Payables minus cost-of-sales growth (pp) −9.5 +14.5 −7.1 +4.4 −0.2
Receivables, % of sales 2.1 2.2 3.1 3.4 2.8
Inventory, % of sales 15.8 13.7 14.7 15.7 16.8
Payables, % of sales 7.3 6.6 7.5 7.0 9.4
Gross margin % 33.6 33.5 33.4 33.4 33.3 32.8 32.6 34.2
Operating margin % 15.2 15.3 14.2 13.5 12.7 11.3 10.1 11.9
Accruals, % of avg. total assets (quarter not annualised) −7.9 −5.8 −2.2 −1.7 −0.7
Free cash flow ($m) 14,005 11,496 17,946 16,325 12,646 3,570 2,289
Free cash flow ÷ net income 0.85 0.67 1.19 1.10 0.89 1.19 0.89
Depreciation rate % (quarter annualised, different basis) 7.44 7.38 5.51 5.60
Capex ÷ depreciation 1.13 1.07 1.06 1.07 1.2
Beneish M-score −2.81 −2.12 −2.42
Acquisition payments ($m) 421 0 1,514 17,644 5,410 31 162

The cost line is the reported "Cost of sales." Annual depreciation is "Depreciation and finance lease amortization expense" from the property note. For the quarters, depreciation is the release's income-statement "Depreciation and amortization" line less "Acquired intangible asset amortization." That basis leaves out depreciation in cost of sales, so compare the two quarters only with each other. Both Q4 columns come from the spreadsheet with its one mixed-basis line left out.

Flags

  1. Free cash flow fell behind net income. Free cash flow ÷ net income went from 1.19 (FY Jan-24) to 1.10 and then 0.89 (FY Feb-26). Q4 fell from 1.19 to 0.89, and accruals rose from −7.9% to −2.2%. The release notes lower cash taxes from the new tax law (OBBBA), though that would raise cash flow, not lower it. Size: $1,510m, 8.1% of pre-tax income (net income $14,156m less free cash flow $12,646m). It has run for 2 years and 2 same-quarter comparisons.
  2. Operating margin fell. It dropped from 13.50% to 12.69% in FY Feb-26, and Q4 dropped from 11.3% to 10.1%. The SRS (FY Feb-25) and GMS (Sep 2025, $5.0bn) acquisitions raised intangible amortization. Size: $1,334m, 7.2% of pre-tax income (0.81 pp × FY revenue of $164,683m). It has run for 3 years and 2 same-quarter comparisons.
  3. Inventory outgrew cost of sales. Days inventory rose from 81.9 to 85.6. Inventory grew 6.7 pp faster than cost of sales, and Q4 days rose from 86.2 to 91.3. The GMS acquisition in Q3 FY Feb-26 could explain it. Size: $1,102m, 5.9% of pre-tax income (inventory less inventory at prior-year days; the Q4 figure is $1,450m). It has run for 2 years and 2 same-quarter comparisons.
  4. Payables fell while cost of sales rose. Days payable dropped from 41.7 to 38.1, as payables fell 3.7% against cost of sales up 3.4%. At 7.0% of sales, payables also sit 2.4 pp below the industry's 9.4%. Size: $1,090m, 5.9% of pre-tax income (payables at prior-year days less the actual balance). It has run for 1 year and 1 same-quarter comparison.
  5. Receivables outgrew sales. Days sales outstanding rose from 7.9 to 11.4 and then 12.4. Receivables are 3.4% of sales against the industry's 2.8%. The annual report links the rise in customer receivables to SRS, and GMS followed in FY Feb-26. Size: $438m, 2.4% of pre-tax income (receivables less receivables at prior-year days; the Q4 figure is $517m). It has run for 3 years and 2 same-quarter comparisons.

Revised figures: No revision moved income or equity. The cash-flow depreciation figure was cut by $179m (FY Jan-23), $186m (FY Jan-24) and $52m (Q1 FY Jan-25), with the same amounts moved to a new intangible amortization line. In the Jan-24 balance sheet, $3,606m moved from "Other assets" to "Intangible assets, net."

Not calculated:

Prompt 2, follow the flags

Inventory: days inventory up from 81.9 to 85.6, with inventory rising 6.7 pp faster than cost of sales (FY Feb-26)

Operating margin: down from 13.50% to 12.69% (FY Feb-26); Q4 down from 11.3% to 10.1%

Receivables: days sales outstanding up from 11.4 to 12.4 (FY Feb-26), after 7.9 to 11.4 the year before

Other flags

Revised basis: none of last reply's measures change. The only revisions moved amounts between lines (cash-flow depreciation into intangible amortization, and "Other assets" into intangible assets), so the M-score inputs and accruals are the same on the revised basis.

Adjusted earnings

Changes in estimate that lifted income: None disclosed. Useful lives for property and equipment are unchanged in both reports. The depreciation rate barely moved, from 7.44% to 7.38%.

Prompt 3, read the footnotes

Page numbers are the documents' own [p. N] markers.

1. Policy profile

Area What the report says Where it sits Why, in a few words Size
Revenue recognition Revenue is booked when the customer takes possession, net of expected returns. Services are booked on completion. Services where a subcontractor supplies material are reported gross. Gift-card breakage is immaterial (10-K p.52) Typical Point of sale, plain retail. Deferred revenue ties: $1.5bn + $1.1bn against $2,575m on the balance sheet Not quantified. The returns liability has no amount
Reserves: receivables and returns The allowance on receivables "was not material" (p.48). Customer receivables rose 36% to $2,588m, mostly through GMS ($899m acquired) Can't tell: not enough disclosed No allowance amount, no returns-liability amount, no Schedule II Balance: $2.6bn of customer receivables
Reserves: self-insurance and shrink Self-insurance claims are recorded at expected ultimate cost "(undiscounted)", $1.6bn (p.52). A 10% rise in the shrink rate would add "$79 million" to cost of sales (p.39) Leans conservative Not discounting gives a larger liability Balance: $1.6bn. Exposure: $79m (0.4% of pre-tax income)
Useful lives: property and software Lives are 5–45 and 2–20 years. Software is capitalized over 3–7 years. Interest is capitalized but no amount is given (p.49) Typical Implied average life is 14.0 years and average age 9.1 years. That fits the stated ranges Not quantified
Useful lives: acquired intangibles Customer relationships have weighted lives of "20" years for SRS (p.76) and "19" for GMS (p.74). The policy range is "up to approximately 20 years", straight-line (p.51) Leans aggressive The lives sit at the top of the range, while the valuation assumes customer attrition About 0.5–1.6% of pre-tax income (illustrative, see below)
Impairment and goodwill Primary: a qualitative test, relying on a 2023 test that showed fair value "substantially exceeded" carrying value. SRS: fair value only "exceeded its respective carrying amount". GMS: "no events or circumstances" (p.60) Can't tell: not enough disclosed No headroom is given for $13.8bn of goodwill in Other Balance: goodwill $22.3bn
Off the balance sheet "no material off-balance sheet arrangements" (p.37). Supplier finance is shown (p.51). Third parties own the private-label credit card receivables and are not consolidated (p.52). Letters of credit (p.73) Typical All items are disclosed with amounts Exposures: $675m of leases not yet started, $1.9bn purchase obligations, $738m letters of credit, $414m supplier finance (already within payables)
Related parties Item 13 is not included. The only item found: SRS managers reinvested sale proceeds in company shares, "not material" (p.76) Can't tell: not enough disclosed Section not supplied Not quantified
Contingencies and legal Litigation is "not expected to have a material adverse effect" (p.73). No accrual or possible-loss amounts. The management discussion cites a "non-recurring legal-related benefit" from fiscal 2024 with no amount (p.33) Can't tell: not enough disclosed No accrued or possible-loss figures Not quantified
Auditor and controls KPMG, unqualified opinions on the accounts and on controls. One critical audit matter (retail-method inventory IT evidence). No material weakness. GMS excluded from the controls assessment (p.41–42, 77–78) Typical Standard first-year exclusion of an acquisition Not quantified
Adjusted measures Adjusted figures exclude "amortization expense from acquired intangible assets". The company does "not adjust for the revenue" those assets generate (release p.8). Return on invested capital uses long-term debt only (p.35) Leans aggressive A recurring cost is left out $607m, 3.3% of pre-tax income

2. Write-ups

No claim was contradicted, either in the audited statements and notes or in the management discussion. Two areas lean aggressive.

Adjusted measures: a recurring amortization charge is excluded

Acquired intangibles: lives at the top of the stated range

3. Also noted

4. Not in the documents

These are not in the documents: related-party transactions (Item 13), Schedule II valuation accounts, and the amounts of the returns reserve and the doubtful-accounts allowance.

Prompt 4, compare the footnotes

No disclosed change in an estimate or policy lifted income. The two write-ups below are a change in the auditor's report and a reworded explanation in the management discussion. "Last year" is the 10-K for fiscal 2024 (year ended 2 February 2025); "this year" is the 10-K for fiscal 2025. Pages are the documents' [p. N] markers. All six required sections are in both files, so every comparison below could be made.

1. Write-ups

Auditor's report: the store-shrink critical audit matter was dropped and replaced with one on IT evidence

Management discussion, SG&A: the fiscal 2024 legal benefit is now called "non-recurring"

Building on the last reply:

2. Other changes

3. Words searched

Word Last year's report (pages) This year's report (pages)
holding period none none
useful life / lives 49, 51, 74 49, 51, 74, 75, 76
average 5, 32, 33, 34, 35, 36, 40, 44, 52, 54, 59, 61, 69, 70, 71, 72, 73, 74, 75 5, 32, 33, 34, 35, 36, 38, 40, 41, 44, 49, 52, 54, 59, 61, 69, 70, 71, 72, 73, 74, 76
residual 50, 75 50, 75
salvage none none

Most "average" hits are ticket size, share counts, interest rates, stock awards and store size. The ones that bear on lives or reserves are lease terms (p.59), intangible lives (p.74/76), the 17-year amortization period for fiscal 2023 acquisitions (last year p.75) and "moving average cost" (this year p.38, 41, 49). "Residual" hits are the lease residual-value guarantees and residual goodwill. No sentence gives a life a direction: the only hits for "longer", "shorter" or "extended" are the leasehold rule "whichever is shorter" and non-accounting uses.

4. Statements of lives, holding periods, residual values and reserve methods

The lease rows use rough proxies, not the company's calculation.

Statement Pages (last year / this year) The number (last year → this year) Still fits?
Finance leases: weighted average remaining term "12" years; the final maturity moved from "January 31, 2055" to "July 31, 2075" p.59, 62 / p.59, 62 Term 12 → 12. Payment-weighted timing 5.7 → 5.3 years; liability ÷ next-year payment 8.0 → 7.6; share of payments after year 5 54% → 52% Rough: can't tell. The tail shrank while the final date moved out 20 years
Operating leases: weighted average remaining term p.59 / p.59 9 → 8 years. Proxies fell 3–4% Rough: the direction fits
Shrink "primarily based on recent shrink results" p.39 / p.39 Sensitivity $95m → $79m; implied estimate about $950m → $790m Can't tell: no reserve balance
Returns liability "based on historical return levels" p.52 / p.52 No amount in either year Can't tell
Self-insurance "(undiscounted)", actuarial p.52 / p.52 Liability $1.5bn → $1.6bn (+6.7%). Related deferred tax asset $271m → $262m Can't tell: no claims or movements disclosed
Software "three to seven years" p.49 / p.49 No software balance disclosed Can't tell
Gift cards redeemed "within six months" p.52 / p.52 Liability $1.1bn both years; no issuance figure Can't tell
Fiscal 2023 acquisitions: "weighted average amortization period of 17 years" p.75 / dropped Not given Can't tell: dropped along with the old acquisition note
Property lives 5–45, 2–20 and 5–45 years p.49 / p.49 Implied average life 13.8 → 14.0 years; depreciation rate 7.4% → 7.4%; average age 8.9 → 9.1 years Yes
Definite-lived intangibles "up to approximately 20 years" p.51 / p.51 Gross ÷ next-year amortization 17.1 → 16.7 years Yes
SRS customer relationships "20", trade names "5"; GMS "19" and "7" p.74 / p.74, 76 Implied SRS charge for fiscal 2024 (229 days) $217m vs $218m reported. Fiscal 2025 implied $395m vs $398m in Other Yes
Leases: "remaining lease terms of one to 20 years" p.50 / p.50 Weighted averages of 8–12 years Yes

5. Disclosed changes in estimates or policies

Neither report discloses a change in a useful life, a reserve method or revenue policy. All the disclosed changes are presentation or measurement-period items with nil or immaterial stated effects, so they are listed in date order.

Change Year Stated effect on income Page
SRS purchase price allocation finalized; measurement-period adjustments FY2025 "immaterial" This year, p.75
ASU 2023-09 (tax disclosures), adopted retrospectively FY2025 "no impact" This year, p.54
Merchandising realignment; fiscal 2024 product-line sales reclassified (e.g. Hardlines $48,562m → $47,721m) FY2025 "no impact on consolidated net sales" This year, p.56
Intangible assets and their amortization shown on separate lines FY2024 None stated (presentation only) Last year, p.48
ASU 2023-07 (segment disclosures) FY2024 Disclosure only Last year, p.54
ASU 2022-04 (supplier finance rollforward) FY2024 "did not have an impact" Last year, p.54

6. Sections not in the documents

Neither file includes related parties (Item 13) or Schedule II, so those can't be compared.