Advertisement
Advertisement
FINANCE

Cash Conversion Cycle Calculator — DIO plus DSO minus DPO, in days

Work out how many days cash stays locked in the business between paying a supplier and collecting from a customer, and what funding that gap costs each year.

Sales made on terms. This drives the receivables leg only, so exclude revenue collected at the point of sale.
Drives both the inventory and the payables legs, because stock and supplier invoices are both carried at cost rather than at selling price.
Average the opening and closing balance for each rather than using a single date, or a seasonal year end will distort every result below.
Trade payables only. Accruals, tax and payroll liabilities are not supplier credit and do not belong in the payables leg.
Your overdraft, revolving facility or working capital loan rate. Used to price the cash the cycle keeps tied up. Enter zero to skip it.
Cash conversion cycle
0
 
0
Days inventory outstanding
0
Days sales outstanding
0
Days payable outstanding
0
Annual cost of the gap
Days inventory outstanding
0
Days sales outstanding
0
Days payable outstanding
0
Operating cycle
0
Tip: the first two bars add together and the third subtracts. If the payables bar is short relative to the other two, you are financing the gap yourself — the supplier is not.
Advertisement

A cash conversion cycle calculator measures something a profit and loss account cannot show: how long the business waits between money going out and money coming back. Buy stock, hold it, sell it on terms, wait to be paid — and somewhere in that sequence you paid the supplier. The number of days between those two events is the cycle, and it is the reason profitable businesses run out of cash.

Arb Digital publishes this in the free tool library at arbsbuy.com because the cycle is the clearest single explanation of why growth consumes money. It differs from the live working capital calculator in what it reports: that tool gives the balance sheet surplus of current assets over current liabilities, a figure in currency. This one gives the same relationship expressed as time, which is the form that tells you what to change.

What This Cash Conversion Cycle Calculator Does

The tool computes the three component periods and combines them. Days inventory outstanding is how long stock sits before it sells. Days sales outstanding is how long customers take to pay after it sells. Days payable outstanding is how long you take to pay suppliers. The first two add together into the operating cycle; the third is subtracted, because supplier credit funds part of the gap for you.

The sibling accounts receivable turnover calculator computes the DSO leg on its own and goes deeper into collection behaviour, ageing concentration and the countback method for growing businesses. This page assumes that leg and puts it in context alongside the other two, because the cycle can only be shortened by working on whichever leg is actually long.

The funding rate field converts the answer into money. Multiplying the working capital genuinely tied up by your short-term borrowing rate gives the annual cost of running the cycle at its current length, which is the figure that makes the case for changing it. The bars put all three legs plus the operating cycle on one scale so the shape is visible immediately.

How to Use It

  1. Use cost of goods sold for inventory and payables. Both are carried at cost. Using revenue there understates both periods, sometimes dramatically.
  2. Use credit sales for receivables. Cash and card takings never became a receivable, so including them shortens DSO artificially.
  3. Average each balance across the period. A single date, particularly a quiet year end, can move the cycle by weeks without anything real having changed.
  4. Keep only trade payables in the payables field. Tax, payroll and accruals are liabilities but they are not supplier credit funding your stock.
  5. Track the three legs separately over time. An unchanged total cycle can conceal inventory getting worse while collections get better.

The Formula / How It's Calculated

The cycle is CCC = DIO + DSO − DPO, where DIO = (average inventory ÷ cost of goods sold) × days, DSO = (average receivables ÷ credit sales) × days, and DPO = (average payables ÷ cost of goods sold) × days.

Run the defaults. Inventory of 260,000 against cost of goods sold of 1,560,000 is 0.1667 of a year, so DIO is 60.83 days. Receivables of 360,000 against credit sales of 2,400,000 is 0.15 of a year, so DSO is 54.75 days. Payables of 195,000 against cost of goods sold of 1,560,000 is 0.125 of a year, so DPO is 45.63 days.

The operating cycle is 60.83 + 54.75 = 115.58 days — the total time from receiving stock to collecting the cash for it. Subtract the 45.63 days of supplier credit and the cash conversion cycle is 69.96 days. The working capital actually funding that gap is inventory plus receivables minus payables: 260,000 + 360,000 − 195,000 = 425,000. At a nine percent funding rate that costs 38,250 a year, every year, simply to keep the cycle at its present length.

Advertisement

Why Growth Makes the Cycle Dangerous

The cycle is the mechanism behind the oldest failure mode in business: a company that is profitable, growing and insolvent at the same time.

The arithmetic is unforgiving. If the cycle is seventy days, every unit of extra annual sales requires roughly seventy days of working capital funding before the cash comes back. Double the sales and you double the amount permanently tied up. That funding has to come from somewhere — retained profit, a facility or new capital — and profit alone arrives too slowly, because it accrues over a year while the working capital demand appears immediately with the order.

This is why fast growth and a long cycle is a genuinely hazardous combination, and why the growth rate a business can fund from its own resources is bounded by its margin and its cycle together. Shortening the cycle raises that ceiling directly, which is a more useful lever than most owners realise. The free cash flow calculator shows where the working capital movement lands in the cash statement, and the burn rate calculator shows how long the resulting outflow can be sustained.

The Negative Cycle and Who Gets One

A cash conversion cycle can be negative, and a business with one is being funded by its own trading rather than funding it.

It happens when DPO exceeds the operating cycle — when you collect from customers and turn over stock faster than you pay suppliers. Supermarkets are the classic case: stock sells in days, customers pay at the till instantly, and suppliers are paid on extended terms. The float that results is real cash the business holds and can deploy. Subscription businesses billing annually in advance achieve the same thing from the other direction, with negative DSO in effect because the customer pays before the service is delivered.

It is worth being clear about what a negative cycle is not. It is not free money in any permanent sense, because the balance unwinds the moment volumes fall — a shrinking business with a negative cycle has to repay the float out of declining trade, which is why contraction can be as cash-hungry as growth. And a negative cycle achieved by simply paying suppliers late is a borrowing, not an efficiency, and it is priced accordingly in the goodwill and terms you get next time.

Stretching Payables Is Not Free

Of the three legs, DPO looks like the easiest to change: pay later and the cycle shortens with no operational work at all. The arithmetic in the formula supports that, and the arithmetic outside it often does not.

Early settlement discounts are the clearest case. Terms offering a two percent discount for payment within ten days rather than thirty mean giving up two percent to gain twenty days of credit. Annualised, that is a very expensive form of borrowing — far above any normal overdraft rate — and a business declining the discount to stretch its cycle is usually financing itself at a rate it would never accept from a bank. Whenever a discount is on the table, the comparison is against your funding rate, not against zero.

The softer costs are harder to quantify and just as real. Suppliers price reliability: a customer who pays consistently on time gets better prices, priority allocation when stock is short, and flexibility when something goes wrong. A business known for paying at ninety days is quietly charged for it somewhere. Extending DPO is a legitimate lever, but it should be a negotiated change in terms rather than a unilateral drift into paying late, and the inventory leg is usually where the larger and less costly gains are — which is what the inventory turnover calculator and the EOQ calculator are for.

Where the Standard Formula Misleads

The formula assumes a linear, single-product flow that many businesses do not have, and knowing where it breaks keeps the number honest.

Businesses with long production cycles carry work in progress that behaves differently from finished stock, and lumping the two together produces a DIO that describes neither. Under inventory accounting standards, cost includes purchase price plus conversion costs such as direct labour and production overhead, as IAS 2 Inventories sets out — so a manufacturer's inventory balance embeds labour and overhead that a reseller's does not, and comparing their DIO figures directly is not meaningful.

Service businesses have almost no inventory, so their cycle is effectively DSO minus DPO, and the tool handles that correctly if inventory is entered as zero. Consignment stock, drop-shipping and deposits taken in advance each break the assumed sequence in their own way. And seasonality is the persistent problem across all of them: a cycle computed from year-end balances in a business whose stock peaks in autumn is describing one moment rather than the year. Where monthly balances exist, computing the cycle each month and looking at the range is far more informative than a single annual figure. Cross-industry working capital data such as the NYU Stern current-year dataset is useful mainly for showing how far normal cycle lengths diverge between sectors.

A shorter cycle funds growth. So does more demand.

Arb Digital builds long-term online growth programmes for established businesses, so the working capital you have already funded turns over more times a year.

Web Growth Services Talk to Arb Digital

Common Mistakes to Avoid

  • Using revenue instead of cost of goods sold for inventory and payables — both are carried at cost, and using selling price understates both periods.
  • Including tax and payroll in payables — they are liabilities but they are not supplier credit funding your working capital.
  • Reading the total without the three legs — an unchanged cycle can hide inventory deteriorating while collections improve.
  • Treating a longer DPO as a free win — forgone settlement discounts and lost supplier goodwill are real costs that sit outside the formula.
  • Computing the cycle once a year from year-end balances — in a seasonal business that single date can be the least representative of the twelve.

Related Free Tools From Arb Digital

Pair this with the accounts receivable turnover calculator for the DSO leg in depth, the inventory turnover calculator for the DIO leg, the working capital calculator for the same relationship expressed as a balance, the current ratio calculator for short-term coverage, the EOQ calculator for the order sizing that drives inventory days, and the free cash flow calculator for where the movement appears in cash. The full free online tools hub lists everything else.

Frequently Asked Questions

What is the cash conversion cycle formula?

Days inventory outstanding plus days sales outstanding minus days payable outstanding. Each period is a balance divided by the relevant annual flow and multiplied by the days in the period, with inventory and payables measured against cost of goods sold.

What is a good cash conversion cycle?

Shorter is generally better, but the meaningful range depends entirely on the sector. Grocery retail routinely runs negative while heavy manufacturing runs into hundreds of days, so the comparisons worth making are to your own history and to close competitors.

Can the cash conversion cycle be negative?

Yes. When supplier credit lasts longer than the time taken to sell stock and collect payment, the business is funded by its trading rather than funding it. Retailers and advance-billing subscription businesses commonly achieve this.

Why use cost of goods sold rather than revenue?

Because inventory and supplier invoices are both carried at cost. Dividing by revenue puts a cost-based balance over a margin-inflated flow and shortens both the inventory and payable periods incorrectly.

What is the difference between the operating cycle and the cash cycle?

The operating cycle is inventory days plus receivable days, the whole time from receiving stock to collecting cash. The cash conversion cycle subtracts payable days, because supplier credit funds part of that period for you.

How does the cycle affect how fast a business can grow?

Every unit of additional annual sales requires roughly a cycle's worth of days in working capital funding before the cash returns. A long cycle therefore caps the growth a business can finance from its own profits.

Is stretching payables a good way to shorten the cycle?

It shortens the number, but forgone early settlement discounts can be a very expensive form of borrowing, and reliable payment buys pricing and priority from suppliers. It works best as a negotiated change in terms rather than a drift into paying late.

Does this work for a service business?

Yes. Enter zero inventory and the cycle becomes receivable days minus payable days, which is the correct measure for a business that holds no stock.

This calculator performs arithmetic on figures you supply and is provided for general information only. It is not accounting, credit or financial advice, and cycle lengths vary enormously by sector and season — confirm any figure used in reporting, lending or a transaction with a qualified professional.

Advertisement
Advertisement

Take it further