Working Capital Warnings: Debtor & Inventory Days

A company can report growing profit, defend a healthy gross margin and still trap a year's worth of cash. The warning usually sits below the headline results: customers take longer to pay, stock waits longer to sell, or suppliers demand their money sooner.

The useful signal is not a single working-capital number. It is working capital growing faster than revenue, quarter after quarter. That is when accounting profit stops arriving in the bank.

Target offers a clean US case. In the quarter ended July 2022, revenue still grew, yet inventory was roughly a third higher than a year earlier and operating margin collapsed as the retailer marked down excess goods. The income statement showed the damage only after cash had already been locked into the wrong stock.

Target is used here to teach the method, not to express a view on the stock.

What working capital analysis measures

Working capital is the cash tied up in daily operations:

Receivables are sales the customer has not paid for. Inventory is cash sitting on a shelf or factory floor. Payables are supplier credit — goods the company has received but has not paid for yet.

The absolute amount tells you little without context. A large distributor should carry more working capital than a small software company, and the asset-turnover ratio helps show whether that investment produces enough sales. The revealing questions are:

1. Is working capital rising faster than revenue?
2. Which component caused the change?
3. Is the change temporary, or has it persisted for several quarters?
4. Did management quantify when the cash should return?

When receivables and inventory swell, cash from operations can fall while reported profit stays steady. Roughly:

This is why the cash-flow statement and balance sheet must be read beside the income statement. The gap between profit and cash is often the first place an optimistic sales story meets reality.

Target's quarter ended July 30, 2022 makes the same point through inventory. Total revenue rose 3.5% year over year to $26.0 billion, but operating income fell from $2.47 billion to $321 million. Operating margin dropped from 9.8% to 1.2%. The company attributed much of the pressure to markdowns, inventory impairments and the cost of clearing excess goods (Target Q2 2022 Form 10-Q).

Sign 1 — Debtor days keep rising

Debtor days estimate how long customers take to pay. A sustained rise can mean the company is offering looser credit to protect sales, customers are under stress, or revenue was booked before cash collection became likely.

Use average receivables when possible: opening plus closing receivables, divided by two. A year-end balance can be distorted by seasonality or a large invoice raised just before the reporting date.

The number is sector-dependent. A cash retailer and an engineering contractor should not have the same debtor days. Compare a company with its own history and close peers, then read the notes for overdue balances, expected-credit-loss provisions and related-party receivables.

Target's 2022 problem was inventory rather than receivables, but the receivables test still applies to US filings. Compare accounts receivable with revenue over several 10-Qs, then inspect the allowance for doubtful accounts. A rising balance paired with flat sales or a larger loss allowance deserves an explanation even when reported earnings remain healthy.

Sign 2 — Inventory grows faster than sales

Inventory days estimate how long goods sit before sale. A temporary build can be sensible ahead of a festival, product launch or supply disruption. The warning is stock rising faster than sales without a time-bound reason, or failing to reverse after management's stated event passes.

Check which denominator your data source uses. Cost of goods sold is the usual convention, but some screeners divide inventory into revenue. Either method can show a trend; mixing the two produces a false comparison.

Target carried about $15.3 billion of inventory at July 30, 2022, up from roughly $11.3 billion a year earlier — an increase of about 35% against 3.5% revenue growth. Management said earlier receipts, investment in frequently bought categories, higher unit costs and weaker-than-expected discretionary demand created the build. It also said it had canceled orders and marked down goods to resize inventory. The explanation was specific; the financial consequence was visible in the 1.2% operating margin.

Sign 3 — Payable days fall

Payables are financing supplied by vendors. Falling payable days mean cash leaves sooner. Sometimes the company chooses to pay early for a discount; sometimes suppliers have shortened terms because trust or negotiating power weakened.

Pair this sign with the other two. Collecting more slowly while paying suppliers faster closes the cash vice from both sides. The working-capital cycle then explains why profit can look healthy while free cash flow deteriorates.

Sign 4 — Working capital consumes more of each sale

Divide operating working capital by revenue and follow the percentage across several years. If a company once needed 15 units of working capital for every 100 of sales and now needs 25, each new sale consumes more cash than the last.

A flat or falling ratio as revenue grows means the business is funding expansion more efficiently. A sustained rise means growth needs an increasing cash subsidy. The next question is whether that investment produces better growth or margins later.

Target's two-quarter snapshot shows why the components matter more than the label “current assets.”

Source: Target Q2 2022 Form 10-Q. Figures are rounded.

Revenue still advanced, but inventory grew about ten times faster. The eventual markdowns converted the balance-sheet warning into an income-statement loss. Investors who watched sales alone saw growth; investors who watched inventory beside sales saw the risk building.

Where this reading can mislead you

Working capital is seasonal. A retailer may build stock before a holiday, a manufacturer may buy materials ahead of a shutdown, and a distributor may carry receivables after a large quarter-end shipment. One period rarely proves a trend.

Inflation can also lift inventory value even when units are flat. Acquisitions can add balances without comparable prior-period revenue. Fast growth often requires more receivables and stock before the resulting sales appear. These are reasons to normalise the data, not reasons to ignore it.

The strongest counter-case has three parts: management explains the build precisely, gives a date or operating milestone for reversal, and later filings show the cash returning. A vague claim that inventory is “strategic” is weaker than a quantified plan.

Target disclosed what went wrong and the actions it was taking, including order cancellations and markdowns. That candor does not erase the loss, but it gives investors something measurable to check in later filings. Inve's US earnings-call research can surface disclosed inventory, margin and operating targets; the 10-Q remains the source for whether the balance sheet actually improved. The US Promise Tracker keeps quantified commitments connected to later calls, while the earnings-call transcript guide explains how to record a claim so it can be checked next quarter.

A five-minute review

For each annual or quarterly filing:

1. Put revenue, receivables, inventory and payables in one small table.
2. Calculate debtor days, inventory days and payable days with one consistent method.
3. Compare each trend with revenue growth and operating cash flow.
4. Read the notes for aging, impairments, inventory provisions and changes in payment terms.
5. Write down management's explanation and expected reversal date.
6. Check the next two filings against that statement.

The calculation finds the smoke. The notes and later results tell you whether it came from a planned investment or a fire.

Frequently asked questions