Cash Conversion Cycle Formula: DIO, DSO and DPO Worked Out

Two distributors sell the same products at the same margin. One needs a bank line to grow. The other gets cash from customers before its own bills fall due. The difference between them is the cash conversion cycle: days inventory outstanding (DIO), plus days sales outstanding (DSO), minus days payables outstanding (DPO). The answer is in days: how long the company’s own money sits in stock and unpaid invoices. Fifty days means it funds fifty days of operations. A negative number means suppliers are funding it.

Company B from its annual report

Company B is a hypothetical wholesaler. Everything needed is on two statements: revenue and cost of goods sold from the income statement, and inventory, receivables and payables from the balance sheet, averaged over the opening and closing dates.

Goods sit on the shelf for sixty days. Customers then take thirty to pay. Suppliers wait forty. Company B is out of pocket for the fifty days in between.

What each leg is telling you

DIO uses cost of goods sold, since inventory is carried at cost. A rising DIO with flat sales usually means stock is building that nobody is buying, and the markdown comes later.

DSO uses revenue, because receivables are recorded at selling price. When DSO climbs faster than sales, the company may be offering easier terms to hit a number, or customers may be struggling to pay. Both deserve a look at the receivables note and the allowance for doubtful accounts.

DPO is the leg companies control most directly. Paying suppliers later lengthens it and shortens the whole cycle. That can reflect real bargaining power. It can also be a cash squeeze dressed up as efficiency.

What a day is worth

The cycle turns into dollars once you ask how much each day costs.

That $12M shows up as a positive change in working capital on the cash flow statement. It’s real cash. It comes once. Hold DIO at the new level and the next year gets no repeat. This is why a DCF has to model working capital explicitly. A cash forecast that assumes the cycle keeps shortening every year is inventing money, and a single big working capital swing can inflate one year of free cash flow enough to distort any DCF fair value estimate built on it. Growth works in the opposite direction. A company with a fifty-day cycle that doubles its sales has to fund twice as much inventory and receivables, and that cash leaves before the profit from the extra sales arrives, which is how fast-growing firms with healthy margins still run short.

When one leg drifts

Watch the legs separately from year to year. Suppose Company B grows revenue 5% the following year while customers slow their payments, and DSO moves from 30 days to 38.

Eight days of slower collections tie up nearly $17M. On the income statement nothing looks wrong, since the sales were booked and the profit recognized, and the shortfall only appears in operating cash flow, which comes in lower than net income by roughly that amount. A jump in DSO in the same year a company beats its revenue target is worth a second look at how those sales were made.

Industry sets the baseline. Grocers and restaurants run short or negative cycles. Heavy equipment makers and wine producers hold inventory for months, and their cycles run long by nature. Judge a company against its own past and its direct competitors, never across industries.

Negative cycles

Some businesses collect before they pay. A retailer selling for card payment settles in a few days, turns its inventory quickly and pays suppliers on longer terms.

Company C holds suppliers’ money for thirty-five days. While sales grow, that float grows with them and funds expansion for free. When sales shrink, the float runs in reverse and cash drains out quickly, so a negative cycle is a strength in growth and a risk in decline. It also explains why such companies can show a current ratio below 1 without any liquidity problem.

Supplier finance and other distortions

Supplier finance programs, sometimes called reverse factoring, let a bank pay a company’s suppliers early while the company itself pays the bank later. DPO stretches. The cycle shortens. Economically, part of that payable now behaves like short-term debt. The Financial Accounting Standards Board addressed this in ASU 2022-04, which requires buyers to disclose the main terms of these programs and the amount outstanding, effective for fiscal years beginning after December 15, 2022, with a rollforward of the balance required a year later. If DPO jumped, look for that disclosure.

Seasonality distorts the year-end snapshot. A retailer’s balance sheet at the end of January shows little inventory, the holidays having just cleared it, so DIO computed from that date looks better than any other month would. For a seasonal business, average the quarter-end balances.

Method choices matter too. Ending balances move faster than averages. Some tools divide by 360 days. Some use revenue for every leg. Each shifts the result by a few days, so compare companies on one source and one method.

Where to find it

Few quote pages show the cycle directly. Many show its parts as inventory turnover, receivables turnover or days sales outstanding, under efficiency or management effectiveness. Turnover converts to days by dividing 365 by it: inventory turnover of 6.1 is 365 ÷ 6.1, about 60 days. The metrics index has the related balance sheet fields. A lengthening cycle ends up in free cash flow, as cash that never arrives.