Cash Conversion Cycle Calculator

What the cycle actually measures

A distributor buys stock on Monday, sells it three weeks later, and is paid a month after that. It paid its own supplier somewhere in the middle. The cash conversion cycle is the gap between the money going out and the money coming back — and for the length of that gap, the business is lending money to its own trading.

That is the whole idea, and it is why the cycle matters more than any of its three parts alone. A company can have an excellent DSO and still run out of cash, if it holds six months of stock and pays suppliers on delivery.

Each part is a stock divided by a flow — a balance measured on one date, against a rate measured across a year. That mismatch is where most of the confusion in this subject comes from, and it has one consequence worth stating plainly before anything else: the cycle moves when the business grows, even if nothing about how it operates has changed. Receivables reflect recent, larger months. The denominator averages the whole year. Growth alone lengthens DSO.

It follows that a cycle figure is only comparable against itself over time, or against another business of similar size and growth rate. A cycle of 40 days is neither good nor bad until you know which sector it sits in and which direction it is moving.

The three parts, and which one to fix

The instinct is to attack the largest number. That is usually wrong. The part worth attacking is whichever sits furthest from what its sector normally achieves, because that is the one where the gap is a choice rather than a constraint.

DSO is a collections problem, and partly a contract problem. Some of it is your payment terms and some of it is customers ignoring them, and the two need completely different responses. The DSO calculator separates them with a best-possible-DSO figure: the number your terms alone would produce if every customer paid exactly on time.

DIO is usually a forecasting problem. Stock accumulates because demand was predicted badly, or because purchasing is optimised on unit price rather than on total cost of holding. Halving it is rarely possible without changing how buying decisions get made, which is why it is the slowest of the three to move.

DPO is the one you can change on Monday — and the one most likely to cost you money. Paying later shortens the cycle by exactly the days added. It is arithmetic, and it is guaranteed. Whether it is a good idea depends entirely on what the supplier was offering in return for paying early, which is the subject of a separate page.

One rule covers all three: get the denominators right before optimising anything. DSO takes credit sales, not total revenue. DIO and DPO take cost figures, not revenue. A cycle built on the wrong denominators will point at the wrong part, and the effort goes into the thing that was never the problem.

Negative cycles are a business model, not a mistake

A supermarket sells a tin of beans for cash on Tuesday and pays the supplier for it in six weeks. Its DSO is nearly zero, its DIO is short because food moves, and its DPO is long. The cycle comes out below zero.

That is not an error to be corrected. It means the business is funded by its own suppliers: every new store is financed by the trade creditors it generates, not by capital raised in advance. Marketplaces, grocers and subscription businesses that bill up front all share this shape, and for them growth releases cash instead of consuming it.

It has a specific and dangerous failure mode, which is worth stating alongside the advantage. A negative cycle depends on volume continuing to arrive. When sales stop growing, the payables stop growing with them, but they still have to be settled — so the same mechanism that released cash on the way up demands it back on the way down. A business that has been funding itself this way discovers its working-capital requirement precisely when it can least afford to.

Any calculator that rejects a negative cycle as invalid input is wrong about the most interesting case it can be handed. This one names it and explains it.

Turning days into money

A cycle of 40 days means nothing on its own. Multiply it by daily cost of sales and it becomes a balance: the working capital permanently absorbed by trading at that speed.

At £1.8m of annual COGS, one day of cycle is about £5,000. Taking ten days out of the cycle releases £50,000 — once. It is a one-off release, not a recurring saving, and that distinction gets lost constantly in working-capital programmes that report the same improvement every quarter.

The same arithmetic explains why identical cycle targets are worth wildly different effort at different scales. Ten days at £1.8m releases £50,000. Ten days at £180m releases £5m. The first is a project for the finance team; the second is a project for the board.

It also sets the honest test for any working-capital initiative: compare the cash released against what it costs to release it. Chasing customers harder costs collections time and occasionally costs the customer. Cutting stock costs service levels and lost sales. Paying suppliers later costs discounts, and sometimes costs the relationship. None of those are free, and the days figure alone never shows the price.

How the cycle gets gamed

Because the formula subtracts DPO, the easiest way to report a better cycle is to pay suppliers later. It works instantly, it needs no operational change, and it is visible in the accounts as an improvement.

It is often expensive. If a supplier offers 2/10 net 30 — two per cent off for paying within ten days, otherwise the full amount at thirty — then taking the extra twenty days is borrowing 98% of the invoice for twenty days at a cost of 2%. Annualised, that is about 37% on a 365-day year. Almost no business can borrow at 37%, so the cycle improved and the margin paid for it.

It can be hidden. Supply-chain finance, sometimes called reverse factoring, lets a company extend its own payment terms while a bank pays the supplier early. The obligation is arguably still trade payable and arguably now borrowing, and where it is classified changes both DPO and reported debt. Several large corporate collapses have featured exactly this ambiguity, which is why disclosure requirements around supplier finance programmes were tightened.

It can happen by accident. A shrinking business shows a falling cycle, because receivables and stock fall faster than payables do. The metric improves while the business gets worse. This is the single most common way a working-capital number flatters a bad year.

None of which makes the cycle a bad measure. It makes it a measure that has to be read next to revenue growth, gross margin, and the terms actually on offer from suppliers — never on its own.

What the cycle cannot tell you

Four real limits, none of which a calculator can remove.

It is an average, and averages hide concentration. A 45-day DSO can be every customer paying at 45 days, or nine customers paying at 30 and one large one paying at 120. Those are different businesses with different risks, and the cycle cannot distinguish them. An ageing report can.

It says nothing about profitability. A business can have an excellent cycle and lose money on every sale. The cycle measures the timing of cash, not whether there is any margin in it — which is what the margin and break-even tools are for.

It assumes the balance-sheet date is representative. A seasonal retailer measured on 31 December is measured at its post-Christmas trough. The same company measured in October would look completely different, and neither figure is wrong — they are answers to different questions.

It ignores the cost of the money. Forty days of cycle matters more to a business borrowing at 12% than to one sitting on cash. The days are the same; the consequence is not.

Finally, a cycle is only comparable across companies that account the same way. Two firms with identical operations can report different cycles because one uses FIFO and the other LIFO, or because one divides DPO by purchases and the other by COGS. Before comparing, check that the denominators match.

Sources and methodology

The definitions the inputs rely on, from the bodies that set them.

• SEC Regulation S-X §210.5-03 — the prescribed income-statement format, which keeps net sales and cost of sales as separate line items
• IRS Form 1125-A, Cost of Goods Sold — the schedule that computes COGS from opening inventory, purchases and closing inventory
• IAS 2 Inventories — inventory is measured at cost, which is why DIO takes COGS and not revenue
• OpenStax, Principles of Finance — the income statement, freely readable
• ACCA Financial Management technical articles — the professional-syllabus treatment of working-capital management
• How we calculate — methodology

Method. All three parts are computed from one day basis chosen once, so the common error of adding a 360-day DSO to a 365-day DIO cannot occur through this tool. Purchases for the DPO denominator are derived as COGS plus closing inventory minus opening inventory, the same identity Form 1125-A uses, and the tool refuses a derivation that resolves to zero or less rather than printing a meaningless ratio. Negative cycles are treated as valid results and explained, not rejected. The engine is verified on every change against 113 assertions shared with the three component calculators, including the cycle identity fuzzed over four thousand randomly generated sets of books and the cost-of-forgoing-a-discount figures checked against the conventional 360-day and 365-day results. The count and the per-case breakdown are published on the formula verification page.

Related calculators

The three parts, each with its own traps:

More in Business, or browse all calculators.