Cash conversion cycle formula: DIO, DSO and DPO worked example
Calculate inventory, receivables and payables days for one period, investigate the component behind a change, and keep averages separate from invoice deadlines.
Use one period and consistent balance definitions
Cash conversion cycle combines the average time represented by inventory and receivables, then subtracts the time represented by supplier payables. The familiar formula is inventory days plus receivables days minus payables days. Select a reporting period and use average balances appropriate to that period. Keep inventory at cost rather than retail selling value, credit sales separate from cash sales, and trade payables consistent with the cost denominator. The tool uses the cost-of-goods-sold approximation for payables days. It describes an average operating cycle, not the date when a particular invoice will be paid.
Calculate a 21-day cash conversion cycle
For a 90-day period, use average inventory 45,000, average receivables 30,000, average payables 36,000, cost of goods sold 135,000 and credit sales 180,000. Inventory days are 45,000 ÷ 135,000 × 90, or 30. Receivables days are 30,000 ÷ 180,000 × 90, or 15. Payables days are 36,000 ÷ 135,000 × 90, or 24. The cash conversion cycle calculator returns 30 + 15 − 24, or 21 days. Record all six inputs with the result so a later comparison can identify which balance or denominator changed.
| Component | Calculation over 90 days | Days |
|---|---|---|
| DIO | 45,000 inventory ÷ 135,000 COGS × 90 | 30 |
| DSO | 30,000 receivables ÷ 180,000 credit sales × 90 | 15 |
| DPO | 36,000 payables ÷ 135,000 COGS × 90 | 24 |
| CCC | 30 + 15 − 24 | 21 |
Balances are averages. COGS is a payables-denominator approximation; average days are not invoice deadlines.
Review receivables with the DSO calculator
Opening receivables of 20,000 and closing receivables of 40,000 produce a simple average of 30,000. Enter those balances, credit sales 180,000 and 90 days in the days sales outstanding calculator to reproduce 15 days. With entered payment terms of 30 days, the aggregate comparison is negative 15 days. That does not establish that every invoice was paid early. Large recent sales, a few unpaid older invoices and the timing of collections can coexist with a low average DSO. Inspect an invoice-aging report when investigating specific overdue customers.
Check inventory turns without accidental annualization
Use cost of goods sold 135,000, average inventory at cost 45,000 and a 90-day period in the inventory turnover calculator. The result is three turns in that period and 30 inventory days. Three quarterly turns are not automatically a three-turn annual result. Nor does a 30-day average mean every product sells within 30 days. Fast-moving products can conceal slow or obsolete lines. Compare inventory by product family and examine the stock actually needed to maintain service. If the period is seasonal, avoid projecting its turnover unchanged into the rest of the year.
A shorter cycle can conceal a worsening component
Suppose inventory days increase from 30 to 40, receivables days remain 15, and payables days increase from 24 to 40. The cycle falls from 21 to 15 days despite slower inventory movement. The apparent improvement comes from supplier financing rather than faster selling or collection. Longer negotiated terms can be useful, but late payment outside agreed terms creates a different situation. Review supplier aging and the actual agreements before interpreting the shorter aggregate cycle as an operational improvement. Show the three components beside the headline result so that offsetting changes stay visible.
Understand the payables denominator approximation
Payables relate to purchases made on credit, while cost of goods sold reflects inventory consumed through sales. Those amounts can differ when inventory expands or contracts. This calculator uses period COGS as its stated approximation for payables days, which may be adequate for a consistent comparison but can distort a period with major stock building. Document that convention and ask whether a purchases-based analysis is needed for your records. Do not compare a purchases-based DPO from another report with the tool’s COGS-based result without reconciling the definitions first.
Use averages thoughtfully when balances move sharply
The opening-and-closing average can miss a large balance peak between those dates. If inventory doubles for a seasonal launch and returns to normal by quarter-end, two snapshots understate the inventory held during much of the period. More frequent balances can provide a better average when your reporting supports them. Apply the same averaging convention across comparison periods and disclose a change. Zero sales or zero COGS can also make the relevant days ratio undefined. An undefined denominator needs investigation; replacing it with zero days would imply a speed the data have not demonstrated.
Translate the diagnosis into a cash forecast
After identifying the changed component, inspect the underlying stock orders, invoice collections or supplier payments. Choose actions using that evidence: review an obsolete line, resolve a billing dispute or confirm negotiated terms. Then enter the expected dates and amounts in a cash forecast. A 21-day average cycle does not tell you whether payroll next Friday is funded, and a negative cycle does not eliminate all cash risks. Preserve the historical calculation alongside the forecast, since one describes operating averages and the other tests specific future payments. Revisit both when sales volume, stock purchases or collection patterns change.