Back to blog

Cash Conversion Cycle Formula: DIO, DSO, and DPO Explained

Team CrossVal20 Nov 20268 minutes read

Cash Conversion Cycle Formula: DIO, DSO, and DPO Explained

The cash conversion cycle formula is CCC = DIO + DSO − DPO: days inventory outstanding plus days sales outstanding, minus days payable outstanding. The result is the number of days your own cash is tied up between paying for stock and collecting from customers. Fewer days means cash comes back faster.

Below, each component is broken down with its own formula, followed by a worked AED example, how to read the result, and the practical levers that shorten the cycle.

What Is the Cash Conversion Cycle Formula?

Cash Conversion Cycle (CCC) = DIO + DSO − DPO

Each term is measured in days:

  • DIO (days inventory outstanding): how long stock sits before it is sold.
  • DSO (days sales outstanding): how long customers take to pay after a sale.
  • DPO (days payable outstanding): how long you take to pay suppliers.

DIO and DSO are the days cash is locked up. DPO is the credit suppliers give you, which offsets part of that wait. The CCC measures speed, while working capital measures position on a single date. Our post on the cash conversion cycle vs the working capital cycle covers that distinction, and the working capital formula guide covers the balance sheet side.

How to Calculate Each Component

All three formulas use an average balance for the period, divided by the matching flow from the income statement, multiplied by the days in the period. Use 365 for a year, or 90 or 91 for a quarter with quarterly figures.

Days inventory outstanding (DIO)

DIO = (Average Inventory ÷ Cost of Goods Sold) × 365

Inventory is carried at cost, so it is compared with cost of goods sold, not revenue. Average inventory is usually (opening inventory + closing inventory) ÷ 2.

Days sales outstanding (DSO)

DSO = (Average Accounts Receivable ÷ Revenue) × 365

Strictly, the denominator should be credit sales only. If a meaningful share of your sales is paid in cash at the point of sale, including it understates DSO.

Days payable outstanding (DPO)

DPO = (Average Accounts Payable ÷ Cost of Goods Sold) × 365

Purchases would be the more exact denominator, since payables come from purchases. Most businesses use COGS because it is reported and keeps DPO on the same basis as DIO. Pick one and stay consistent.

Worked Example: A Dubai Distributor's Cash Conversion Cycle

A Dubai building materials distributor reports the following for the year:

ItemOpening (AED)Closing (AED)Average (AED)
Inventory1,000,0001,160,0001,080,000
Accounts receivable1,050,0001,200,0001,125,000
Accounts payable600,000660,000630,000

Annual revenue is AED 9,125,000 (AED 25,000 per day) and cost of goods sold is AED 6,570,000 (AED 18,000 per day).

ComponentCalculationDays
DIO1,080,000 ÷ 6,570,000 × 36560
DSO1,125,000 ÷ 9,125,000 × 36545
DPO630,000 ÷ 6,570,000 × 36535
CCC60 + 45 − 3570

From the day the distributor pays a supplier to the day it collects from the customer, its own cash is out of the business for about 70 days. That gap has to be funded from cash reserves, retained profit, or borrowing.

What the days are worth in AED

Converting days into money makes the cycle easier to act on:

  • Cutting DSO by 10 days frees about 10 × AED 25,000 = AED 250,000 from receivables.
  • Cutting DIO by 10 days frees about 10 × AED 18,000 = AED 180,000 from inventory.
  • Extending DPO by 10 days keeps about 10 × AED 18,000 = AED 180,000 in the bank for longer.

A 10-day improvement in each would bring the cycle down to 40 days and release roughly AED 610,000, without any change in sales or margin.

A UAE detail: VAT in receivables and payables

Customer invoices include 5% VAT, so receivables on the balance sheet are VAT-inclusive while revenue is not. For a business with mostly standard-rated sales, this slightly overstates DSO. Payables carry the same effect on purchases. For a cleaner comparison, divide receivables and payables by 1.05 where most transactions are standard-rated, or simply apply the same method every period so the trend stays meaningful.

How to Read the Result

ResultWhat it meansTypical examples
Long positive (60+ days)Cash is tied up for a long time and the business needs funding to growDistributors, manufacturers, contractors
Short positive (0 to 30 days)Cash returns quickly, growth needs less external financeFast-moving retail with some credit sales
NegativeCustomers pay before suppliers are paid, supplier credit funds operationsSupermarkets, upfront-payment and subscription businesses

A negative cycle is often a strength, though it carries risks if it depends on stretching suppliers. We look at both sides in is a negative cash conversion cycle good.

Three reading rules help:

  • Watch the trend. A cycle rising from 55 to 70 days over four quarters matters more than the absolute figure.
  • Read the components, not just the total. A stable CCC can hide DSO rising while DPO is stretched to compensate.
  • Compare like with like. A service business has no inventory, so DIO is zero and its CCC is effectively DSO minus DPO.

Common Mistakes When Calculating the CCC

  • Mixing denominators. Dividing inventory by revenue instead of COGS understates DIO, because revenue includes margin.
  • Using only year-end balances in a seasonal business. If stock peaks before Ramadan or the winter season and is low at year-end, closing balances flatter the result. Use monthly averages if you have them.
  • Mismatched periods. Quarterly balances with annual revenue, or a 365-day multiplier on quarterly flows, distort every component.
  • Changing method between periods. Switching from COGS to purchases for DPO, or from total to credit sales for DSO, breaks the trend.

How to Shorten Your Cash Conversion Cycle

Each component has its own levers. Work on all three, because improving one at the expense of another leaves the cycle unchanged.

Reduce DSO

  • Invoice on delivery or completion, not at month-end.
  • State payment terms clearly on every invoice and agree them before work starts.
  • Take deposits or milestone payments on large orders and projects.
  • Review receivable ageing weekly and follow up as soon as an invoice is overdue.

Reduce DIO

  • Identify slow-moving lines and stop reordering them on autopilot.
  • Set reorder points from actual sales history rather than habit.
  • Plan seasonal stock builds against a forecast, not last year's volume alone.

Increase DPO responsibly

  • Negotiate longer terms with key suppliers, especially as your volumes grow.
  • Pay on the due date, not early, unless an early-payment discount is worth more than the cash.
  • Avoid paying late. It may shorten the cycle on paper but can cost you pricing, priority, and supply.

Shortening the cycle feeds directly into operating cash flow, and it is one of the main levers covered in our guide to corporate cash flow management.

Frequently Asked Questions

What is a good cash conversion cycle?

There is no single good number, because the cycle depends heavily on the industry. A grocery retailer may run close to zero or negative, while a manufacturer or contractor can run well above 90 days. The useful tests are whether your cycle is shortening over time and how it compares with similar businesses.

Can the cash conversion cycle be negative?

Yes. If customers pay you before you have to pay suppliers, DPO is larger than DIO plus DSO and the result is negative. This is common in supermarkets and businesses that take payment upfront, and it means supplier credit is funding operations.

Should DPO be calculated with COGS or purchases?

Purchases is the more precise denominator because payables arise from purchases, but most companies do not report purchases separately, so COGS is the common choice. Either works if you use the same method every period. Using COGS keeps DPO on the same basis as DIO.

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

The operating cycle is DIO plus DSO: the days from buying stock to collecting cash from the customer. The cash conversion cycle subtracts DPO from that, because the time suppliers give you to pay reduces how long your own cash is tied up.

See Your Cash Cycle in Real Time with CrossVal

The cash conversion cycle tells you how long cash is tied up. CrossVal's cash flow management software shows what that means for your bank balance, with a live cash position from connected UAE and KSA bank accounts.

Cash flow forecasting and live runway let you see how a longer collection period or a seasonal stock build will affect cash in the weeks ahead, so you can act before the gap opens. Try CrossVal free

Common questions
about this topic.

About the author

Team CrossVal

Team CrossVal

CrossVal Finance Team

The CrossVal team combines expertise in accounting, tax compliance, and financial technology to help UAE businesses automate their finance operations. Our content is reviewed by chartered accountants and finance professionals with experience in FTA regulations.

LinkedIn

Put these insights
into your books.