How the cash conversion cycle works

The cash conversion cycle asks how long cash is tied up in the operating loop after counting how long the firm takes to pay its suppliers:

$$CCC = DSO + DIO - DPO$$

DSO is days sales outstanding: how long customers take to pay. DIO is days inventory outstanding: how long stock sits. DPO is days payable outstanding: how long the firm takes to pay suppliers. Add the first two and you have the operating cycle. Subtract DPO and you have how much of that loop the firm still has to fund itself.

45 days of receivables plus 60 days of inventory is a 105 day operating cycle. Minus 30 days of payables leaves 75 days. For 75 days, on average, the operations have cash stuck in the cycle.

This is working capital written in days rather than in dollars. An increase in the cycle consumes cash. A fall in it releases cash, which is why a change in net working capital is subtracted when profit is turned into free cash flow. The cash conversion cycle calculator on this page adds the three days.

DSO 30, DIO 20, DPO 100. The operating cycle is 50 days. Payables are 100 days. CCC is minus 50 days.

Suppliers are paid 50 days after the cash from the sale is already in. Customers and inventory are not funding a gap. The payables are. Supermarkets and some subscription firms run this on purpose: collect before paying. A negative cycle is not a bug in the formula. It is a business that has shifted the funding of its cycle onto its suppliers.

It is also not free. Stretch DPO far enough and suppliers raise prices, cut service, or walk. The formula will still print a prettier number.

A third sheet holds each clock at 40. The operating cycle is 80 days. CCC is 40 days. Equal clocks are not a target. A manufacturer with long production holds more inventory days than a retailer turning pallets overnight. Compare CCC inside a sector, the way P/E is compared inside a sector, or the comparison is noise.

This page does not compute DSO, DIO or DPO from a balance sheet. Those three are inputs. The usual constructions, using a 365 day year, are:

$$DSO = \frac{\text{Receivables}}{\text{Sales}/365} \qquad DIO = \frac{\text{Inventory}}{\text{COGS}/365} \qquad DPO = \frac{\text{Payables}}{\text{COGS}/365}$$

Receivables over daily sales. Inventory over daily cost of goods. Payables over daily cost of goods. Some sheets use 360. Say which, and use it for every firm in the comparison. Type the days your sheet already has.

A 75 day cycle on a growing firm consumes more cash next year than this year, because the same days sit on a larger sales number. Cutting DSO by refusing customers, or cutting DIO into stockouts, can cost more than the cash it frees. The number is a diagnostic, not a score.

The free cash flow calculator is the page that takes the change in working capital off NOPAT. How to read financial statements is where the three ledger lines live.

It is not a cash forecast and not a working-capital dollar schedule. It will print a negative CCC rather than swapping the labels. Minus 50 days on the second sheet is the formula working.

The figures throughout are a teaching sheet: 45 plus 60 minus 30, then 30 plus 20 minus 100, then three clocks of 40. They are not a target for any particular firm. This is educational material, not financial advice.