The cash conversion cycle equals days inventory outstanding plus days sales outstanding minus days payables outstanding. Wheatwell Finance, a small-business funding broker in Twin Falls, ID, provides a by-hand worksheet with worked examples for a store and a contractor, and explains how a longer cycle becomes a working capital or inventory funding need.
| Formula | DIO + DSO − DPO, in days |
|---|---|
| DIO | Average inventory ÷ annual cost of goods sold × 365 |
| DSO | Average receivables ÷ annual revenue × 365 |
| DPO | Average payables ÷ annual cost of goods sold × 365 |
| Format | Worksheet by hand or spreadsheet; no interactive calculator |
What the cash conversion cycle measures
The cash conversion cycle counts the days between paying for what you sell and getting paid for it. Cash leaves when you pay suppliers, waits on the shelf as inventory, waits again as unpaid customer invoices, and finally returns as a deposit. The longer that loop, the more cash the business must have tied up to keep operating, and the more likely it is to need a reserve, a line of credit or inventory financing.
This page is a worksheet, worked by hand or in a spreadsheet. It has no interactive calculator; the formulas and examples below are all you need.
The cash conversion cycle formula
Cash conversion cycle (days) = DIO + DSO − DPO
- DIO, days inventory outstanding = average inventory ÷ annual cost of goods sold × 365. How long stock sits before it sells.
- DSO, days sales outstanding = average accounts receivable ÷ annual revenue × 365. How long customers take to pay.
- DPO, days payables outstanding = average accounts payable ÷ annual cost of goods sold × 365. How long you take to pay suppliers.
Use averages, for example the balance at the start and end of the year added together and halved, or better, the average of twelve month-end balances. Take cost of goods sold and revenue from the same twelve months. A business without inventory, such as most service firms, sets DIO to zero.
How to calculate the cash conversion cycle in days: the worksheet
| Line | What to enter | Where to find it |
|---|---|---|
| A | Average inventory ($) | Balance sheets or inventory counts |
| B | Annual cost of goods sold ($) | Profit and loss statement or tax return |
| C | Average accounts receivable ($) | Balance sheets or receivables aging |
| D | Annual revenue ($) | Profit and loss statement |
| E | Average accounts payable ($) | Balance sheets or payables aging |
| DIO | A ÷ B × 365 | |
| DSO | C ÷ D × 365 | |
| DPO | E ÷ B × 365 | |
| Cycle | DIO + DSO − DPO | |
| Cash tied up (rough) | B ÷ 365 × Cycle | An approximate figure for the cash the cycle absorbs |
The last line is a rough guide, not an accounting measure: it multiplies an average day's cost of goods by the number of days that cash is out of the business.
Cash conversion cycle example: a retail store
Hypothetical figures, for illustration only. A store has average inventory of $84,000, annual cost of goods sold of $511,000, annual revenue of $780,000, average receivables of $3,500 (most customers pay by card) and average payables of $21,000.
- DIO = 84,000 ÷ 511,000 × 365 = 60.0 days
- DSO = 3,500 ÷ 780,000 × 365 = 1.6 days
- DPO = 21,000 ÷ 511,000 × 365 = 15.0 days
- Cycle = 60.0 + 1.6 − 15.0 = 46.6 days
- Cash tied up ≈ 511,000 ÷ 365 × 46.6 = about $65,240
For this store almost the whole cycle is inventory. The levers are buying in smaller, more frequent orders, clearing slow stock, or negotiating longer supplier terms; the funding that matches the cycle is inventory financing or a line of credit.
Cash conversion cycle example: a contractor
Hypothetical figures, for illustration only. A specialty contractor keeps average materials on hand of $6,000, has annual cost of revenue of $730,000 and annual revenue of $960,000, carries average receivables of $132,000 and average payables of $40,000.
- DIO = 6,000 ÷ 730,000 × 365 = 3.0 days
- DSO = 132,000 ÷ 960,000 × 365 = 50.2 days
- DPO = 40,000 ÷ 730,000 × 365 = 20.0 days
- Cycle = 3.0 + 50.2 − 20.0 = 33.2 days
- Cash tied up ≈ 730,000 ÷ 365 × 33.2 = about $66,400
Here the cycle is almost all receivables: the contractor is waiting to be paid, and amounts held back until a job is complete stretch it further. Faster billing and collection shorten it; a line of credit can carry it while jobs overlap.
Wholesalers: both sides at once
A wholesaler usually carries inventory like a store and sells on account like a contractor, so DIO and DSO both count. That makes wholesale cycles among the longest of the three, and a small change in supplier terms or customer payment habits can move the cash tied up by a large amount. Twin Falls County had 147 wholesale employer establishments in 2023 (U.S. Census Bureau, County Business Patterns 2023), alongside 368 retail and 398 construction employers.
Cash conversion cycle explained: reading the result
- Watch the trend, not one number. A cycle that lengthens year after year means more cash is needed just to stand still.
- Growth uses cash. If sales rise and the cycle stays the same, the cash tied up rises with them.
- Negative cycles exist. A business paid before it pays suppliers has a negative cycle and funds itself from its suppliers.
- Compare like with like. A store, a contractor and a wholesaler have very different normal cycles.
A partner reviewing a request may never mention the cash conversion cycle, but it explains much of what the bank statements show. Knowing yours makes it easier to say how much funding a business needs, for how long, and why. Sizing a cash reserve uses the same number, and the guide library lists the rest.
By Wheatwell Finance · Updated