Cash conversion cycle: formula and a worked example
Stock can become a sale before the customer pays. Calculate DIO, DSO and DPO, then follow the gap between supplier payment and customer collection.
The cash conversion cycle, or CCC, estimates the time between paying suppliers and collecting cash from customers. Add inventory days and receivable days, then subtract payable days. It is also called the cash operating cycle or cash-to-cash cycle.
A distributor can sell stock at a profit and still have to fund the wait for payment. The sale, supplier bill and customer collection happen on different dates.
The ACCA working-capital guide explains the cycle and why the three parts need to be considered together. Start with their meanings before trying to shorten the headline number.
Cash conversion cycle formula: DIO + DSO − DPO
| Measure | Meaning | Formula for the period used here |
|---|---|---|
| DIO: days inventory outstanding | Inventory held relative to the cost of goods sold | Average inventory ÷ daily cost of goods sold |
| DSO: days sales outstanding | Trade receivables held relative to credit sales | Average trade receivables ÷ daily credit sales |
| DPO: days payable outstanding | Trade payables held relative to credit purchases | Average trade payables ÷ daily credit purchases |
Cash conversion cycle
CCC = DIO + DSO − DPO
Operating cycle before supplier credit = DIO + DSO
Use the same period and day convention for all three. The inventory turnover and days example explains why inventory uses cost rather than selling price, and why an average balance is different from an item's age.
DPO is sometimes calculated with cost of goods sold as a proxy when purchase data is unavailable. Label that choice. Here we know credit purchases and use them directly.
Worked example: calculate a 50-day cash cycle
Our fictional distributor uses a 365-day year. The balances below are representative annual averages, with consistent valuation and no seasonal peak hidden in a single closing balance. All sales and purchases in this example are on credit.
| Annual flow or average balance | Amount |
|---|---|
| Cost of goods sold | €730,000 |
| Credit sales | €1,095,000 |
| Credit purchases | €730,000 |
| Average inventory | €120,000 |
| Average trade receivables | €90,000 |
| Average trade payables | €80,000 |
Cost of goods sold and credit purchases both equal €2,000 per day here. Credit sales equal €3,000 per day. Credit purchases equal cost of goods sold in this example; in another business or period they can differ.
| Calculation | Result |
|---|---|
| DIO = €120,000 ÷ €2,000 | 60 days |
| DSO = €90,000 ÷ €3,000 | 30 days |
| DPO = €80,000 ÷ €2,000 | 40 days |
| CCC = 60 + 30 − 40 | 50 days |
The balance-sheet ratios describe the business over the year. They do not trace a particular pallet's dates.
For a simple timeline with the same intervals, imagine goods received on day zero, sold on day sixty and paid for by the customer on day ninety. The supplier is paid on day forty. The gap from supplier payment to collection is fifty days.
The timeline illustrates those intervals; the annual averages cannot recover individual invoice dates.
Change collection and payment timing
Keep inventory at sixty days in the visual. Change the customer collection interval or the agreed supplier payment interval to see which dates move.
365-day distributor / fixed DIO of 60 days
Follow payment and collection on the same timeline
Goods arrive at day zero and sell on day sixty in this illustration. Change DSO and DPO while daily sales and purchase flows stay fixed.
Cash conversion cycle50 daysSupplier paid before customer collection
Scenario average receivables€90,000DSO × €3,000 credit sales per day
Scenario average payables€80,000DPO × €2,000 credit purchases per day
Scroll sideways for the whole timeline. The dates and ratios are also in the table.
Inventory and credit intervals appear separately. The lower band joins payment and collection; a negative cycle reverses their order.
| Measure | Calculation | Result |
|---|---|---|
| DIO | €120,000 / €2,000 daily COGS | 60 days |
| DSO | €90,000 / €3,000 daily credit sales | 30 days |
| DPO | €80,000 / €2,000 daily credit purchases | 40 days |
| CCC | 60 + 30 − 40 | 50 days |
| Illustrative payment / collection | Day 40 / day 90 | 50 days apart |
Ratio and timeline assumptions
The example fixes annual COGS and credit purchases at €730,000 each and credit sales at €1,095,000. Average inventory stays at €120,000. Daily flows divide by 365. Receivables equal DSO×daily credit sales; payables equal DPO×daily credit purchases. These are representative scenario averages.
The separate timeline assumes receipt at zero, sale after DIO, collection after another DSO and supplier payment after DPO. It illustrates the same intervals; the annual ratios cannot identify an actual item's dates. The model holds prices and sales fixed and excludes tax and discounts. Actual cash released depends on invoices, collections and supplier terms.
If customers pay fifteen days after sale instead of thirty, collection moves from day ninety to seventy-five. With supplier payment still on forty, the cycle becomes thirty-five days.
Under the same steady-flow assumptions, that scenario implies average receivables of 15 × €3,000 = €45,000 instead of €90,000. That would reduce the average receivables balance by €45,000 under these assumptions. It would not create €45,000 of profit each year. Check actual invoices, collections and terms to confirm any cash released.
What does a negative cash conversion cycle mean?
Set DSO to fifteen days and DPO to ninety. The timeline collects from the customer on day seventy-five and pays the supplier on day ninety.
CCC becomes 60 + 15 − 90 = −15 days. Customer cash arrives fifteen days before supplier payment in this scenario.
The supplier must still be paid, and the timing says nothing about profit. A longer payment interval also needs agreement: suppliers may change prices, discounts, limits or supply terms.
The procurement total-cost example shows why a better result on one measure can move cost elsewhere. Supplier payment terms need the same wider review.
Improve the cause of the delay, then check service
If receivables are slow because customers dispute invoices, investigate the disputed records and resolve the billing problem. Asking for faster collection without fixing the error leaves the same work waiting.
If inventory is high, separate excess from stock that protects a real supply need. Cutting it until the ratio improves may leave orders unfilled. The inventory review comparison connects ordering timing to the demand period a policy must cover.
Review the three components together, using comparable periods and balances that represent the business. Add overdue debt, stock ageing, delivery performance and supplier exceptions to explain a change. There is no single CCC target that suits every product and payment arrangement.
For this distributor, trace the collection dates and stock groups behind the fifty-day gap. Separate agreed payment waits from overdue invoices and stock held longer than needed.
Source and calculation notes
- ACCA: Working capital management. Inventory, receivable and payable periods, cash-cycle interpretation and trade-offs.
All amounts, averages and dates are fictional. The example excludes tax differences and other working-capital items. It uses credit purchases for DPO and a 365-day convention. Inventory days remain a period ratio, not an item-age estimate.