Cash conversion cycle: formula, a worked example over two quarters, and what it costs in cash

The cash conversion cycle (CCC) is the number of days a company's cash is tied up between paying suppliers for goods and collecting from customers for them. It is days inventory outstanding plus days sales outstanding minus days payable outstanding. The company below runs 45.0 + 45.9 − 36.0 = 54.9 days in its first quarter and 61.4 days in its second, and the extra days cost it $150,357 of cash.

The formula, and what each part measures

CCC = DIO + DSO − DPO

DIO = Inventory / Cost of sales × Days in period

DSO = Receivables / Revenue × Days in period

DPO = Payables / Cost of sales × Days in period

DIO is how long goods sit in stock, DSO how long customers take to pay, and DPO how long the company takes to pay suppliers. DIO plus DSO is the operating cycle: the days from receiving goods to collecting cash for them. Supplier credit covers part of that time, so the cash conversion cycle subtracts DPO. The Corporate Finance Institute's cash conversion cycle guide builds it the same way from the three legs.

Conventions vary. This page uses cost of sales for DIO and DPO, revenue (credit sales) for DSO, and the actual days in the period: 365 for a year, 90 or 91 for a quarter. Some analysts use 360 days, or revenue for every leg; neither is wrong, but the same convention must run every period. Each leg has its own page: days sales outstanding and days payable outstanding work them customer by customer and supplier by supplier.

The figures you need

From the income statement: revenue (credit sales) and cost of sales for the period. From the balance sheet: inventory, trade receivables and trade payables. For a year, average the opening and closing balances, or better, the twelve month-ends. The example below uses quarter-end balances so it matches the quarter already worked on the working capital, DSO and DPO pages.

Worked example: two quarters

One distributor. Q1 is January 1 to March 31, 2026 (90 days); Q2 is April 1 to June 30, 2026 (91 days).

Q1: DIO = 780,000 / 1,560,000 × 90 = 45.0; DSO = 1,225,000 / 2,400,000 × 90 = 45.9; DPO = 624,000 / 1,560,000 × 90 = 36.0; CCC = 54.9 days. The operating cycle is 45.0 + 45.9 = 90.9 days, of which suppliers fund 36.

Q2: DIO = 830,000 / 1,690,000 × 91 = 44.7; DSO = 1,400,000 / 2,600,000 × 91 = 49.0; DPO = 600,000 / 1,690,000 × 91 = 32.3; CCC = 61.4 days. The cycle lengthened by 6.4 days (61.38 − 54.94, unrounded). Stock turned slightly faster, but customers paid three days slower and suppliers were paid almost four days sooner.

In Excel, with revenue in B2, cost of sales in B3, days in B4 and receivables, inventory and payables in B5:B7:

=B6/B3*B4+B5/B2*B4-B7/B3*B4

What the change costs in cash

Each day of a leg is worth one day of its flow: a day of DSO is a day of sales, a day of DIO or DPO a day of cost of sales. At Q2 rates, daily sales are 2,600,000 / 91 = $28,571 and daily cost of sales 1,690,000 / 91 = $18,571.

Cash effect of a change in days = Change in days × Daily revenue (DSO) or Daily cost of sales (DIO, DPO)

Slower collection tied up $87,500 and earlier supplier payment $68,571; leaner inventory released $5,714. Net, the longer cycle tied up $150,357.

The check that proves it

Trade working capital (receivables + inventory − payables) was 1,225,000 + 780,000 − 624,000 = $1,381,000 at March 31 and 1,400,000 + 830,000 − 600,000 = $1,630,000 at June 30: up $249,000. The cash effects must explain all of it. The rest comes from growth: Q1's days applied to Q2's higher daily flows.

Each column ties to a balance: receivables rose $175,000, inventory $50,000, and payables fell $24,000. If the two effects do not sum to the movement on the balance sheet, a balance or a day count is wrong. Days × daily rate must also rebuild each balance: 49.0 × 28,571.43 = $1,400,000.

Negative cash conversion cycles

A negative cycle means customers pay before suppliers are paid, so suppliers finance the business. Three figures computed from the latest 10-K filings, using average balances, cost of sales and 365 days:

Apple, for example: net sales of $416,161 million, cost of sales of $220,960 million, average trade receivables of $36,594 million, inventory of $6,502 million and payables of $69,410 million. Its payables are more than ten times its inventory, so suppliers fund far more than the goods on hand. Costco collects at the register and sells stock in about four weeks, so it nearly breaks even on the cycle. A food distributor such as Sysco extends credit to restaurants and runs positive. A negative cycle is a business model, not a target for every company.

How to shorten it

• Collections, by customer. DSO is the most valuable day here because it runs at the sales rate. Start with customers paying furthest beyond terms; check that invoices go out promptly.
• Inventory, by SKU and site. Range and reorder points set DIO. Inventory aging by site shows where the slow stock sits. The trade-off is availability: cut too far and stockouts cost sales.
• Payment terms, by supplier. Paying on terms rather than early lengthens DPO without paying anyone late; payment terms compliance shows which suppliers you pay early. Longer terms can cost a higher price or an early-payment discount forgone.

Where it goes wrong

• Year-end balances in a seasonal business. A December low in receivables flatters DSO. Use averages, ideally monthly.
• DPO on revenue instead of cost of sales. It understates DPO and overstates the cycle.
• Comparing across industries. A grocer and an engineering firm have structurally different cycles.
• Stretching suppliers. Longer payment cuts the cycle but can cost price, reliability or reputation. A supplier finance program that lengthens DPO must also be disclosed under US GAAP: ASU 2022-04 (ASC 405-50) requires buyers to disclose the program's key terms and the amount outstanding.
• A falling cycle from inventory run down to stockouts. Fewer days of stock is good only while customers still get their orders.

Where the days sit

The total cycle says cash is tied up; the ledger says where. Covirage's tools compute days by customer, site and supplier from your receivables, inventory and payables files; the external AI model explains the movement and never does the arithmetic. See Covirage for finance teams, and working capital for the balance sheet behind the cycle. For the KPIs it sits among, see financial KPIs; for the receivables leg, accounts receivable turnover ratio.