Cash Conversion Cycle: Formula, Calculator, and Excel Workbook
The cash conversion cycle measures the days between paying for operating inputs and collecting cash from customers. The formula adds days inventory outstanding and days sales outstanding, then subtracts days payables outstanding.
A shorter cycle usually releases cash. But the total can improve for bad reasons: stockouts lower inventory days, rejected creditworthy sales lower receivables, and late supplier payments raise payable days. This page gives you the formula, a worked example, and a free Excel calculator that keeps those guardrails beside the number.
What is the cash conversion cycle formula?
Cash conversion cycle = DIO + DSO – DPO.
- Days inventory outstanding (DIO): how long inventory remains before sale.
- Days sales outstanding (DSO): how long credit customers take to pay.
- Days payables outstanding (DPO): how long the business takes to pay suppliers.
The J.P. Morgan Working Capital Index methodology uses the same DIO, DSO, and DPO structure to measure working-capital efficiency. The important word is operating. CCC focuses on the cash tied up in the cycle, not every payment the business makes.
Calculate DIO, DSO, and DPO consistently
Use average balances when the period moves materially. A month-end inventory spike or one large collection can make an ending balance look unusually weak or strong.
| Component | Formula | Use this denominator |
|---|---|---|
| DIO | Average inventory / cost of goods sold x days | Cost of goods sold |
| DSO | Average accounts receivable / credit sales x days | Credit sales |
| DPO | Average accounts payable / cost of goods sold x days | Cost of goods sold |
| CCC | DIO + DSO – DPO | Days |
Document whether you use 365 days or the number of days in the reporting period. Do not calculate inventory against sales in one month and cost of goods sold in another. Consistency matters more than a false sense of precision.
Service businesses without inventory can set inventory to zero and focus on DSO and DPO. The result still helps, but do not pretend it measures an inventory cycle that does not exist.
Cash conversion cycle worked example
Assume annual credit sales of $1.2 million, cost of goods sold of $720,000, average inventory of $102,575, average receivables of $124,932, and average payables of $65,096.
| Calculation | Result |
|---|---|
| DIO = $102,575 / $720,000 x 365 | 52 days |
| DSO = $124,932 / $1,200,000 x 365 | 38 days |
| DPO = $65,096 / $720,000 x 365 | 33 days |
| CCC = 52 + 38 – 33 | 57 days |
That 57-day result becomes useful when compared with prior periods, the same seasonal period, and similar businesses using the same formula. A single benchmark without operating context can push the team toward the wrong action.
Use the cash conversion cycle calculator
The workbook calculates current and target DIO, DSO, DPO, and CCC. It estimates the cash released or absorbed by the change, stores a 12-month trend, and gives you a four-week improvement sprint.
Get the Excel calculator with DIO, DSO, DPO, current and target CCC, a 12-month trend, cash estimate, and a 30-day sprint. Enter your details and I’ll email the secure download link. The newsletter checkbox is optional and can be cleared if you only want the workbook.
| Workbook output | Decision use |
|---|---|
| Current CCC | Sets the operating baseline |
| Target CCC | Shows the intended cycle after action |
| Change in days | Measures the improvement gap |
| COGS cash per day | Translates days into a rough cash amount |
| Estimated cash released | Sizes the opportunity, not a guarantee |
| 30-day sprint | Assigns one component, owner, due date, and guardrail |
The cash estimate uses cost of goods sold per day as a practical approximation. It does not predict the exact bank balance. Customer mix, purchase timing, tax, financing, payroll, and seasonality still matter.
Read the components before celebrating a shorter CCC
A shorter cash conversion cycle is normally helpful, but each component carries an operating tradeoff. Read the reason for the change before calling it an improvement.
| Change | Healthy explanation | Warning sign |
|---|---|---|
| DIO falls | Better forecasting and fewer slow items | Stockouts or lost service level |
| DSO falls | Faster invoicing and dispute resolution | Creditworthy sales rejected |
| DPO rises | Terms negotiated with suppliers | Bills paid late without agreement |
| CCC turns negative | Customers pay before suppliers are due | Timing distorted by one unusual period |
A negative CCC can be a genuine advantage in prepaid, subscription, marketplace, or fast-turn retail models. It is not a target every business can copy. A contractor billing after delivery cannot collect cash before the work begins unless the commercial terms change.
Do not extend DPO by quietly paying every supplier late. That replaces financing cost with supply risk and damaged trust.
Run one 30-day improvement sprint
Choose the component with the clearest bottleneck. The workbook sample starts with DSO because invoice timing, disputes, reminders, and promises can be changed and measured within a month.
- Week 1: invoice on the delivery milestone and resolve the top disputes.
- Week 2: call the largest overdue accounts and record dated promises.
- Week 3: escalate broken promises and review credit holds.
- Week 4: recalculate DSO and compare cash, complaints, and sales impact.
Keep one guardrail beside the target. For DSO, protect creditworthy sales and customer relationships. For DIO, protect stock availability. For DPO, protect agreed terms and key suppliers.
The J.P. Morgan working-capital benchmark connects CCC to working-capital efficiency. The published business budget guide and break-even point calculator cover the operating plan and unit economics around it.
Do not confuse CCC with a cash flow forecast
CCC is an operating efficiency metric. It does not know the date of payroll, tax, debt service, rent, annual renewals, capital spending, or owner draws. A business can improve CCC and still break its cash floor next Friday.
- Use CCC to see where operating cash is tied up.
- Use a cash flow forecast to see when the bank balance moves.
- Use working capital to review the short-term balance-sheet position.
- Use AR and inventory aging to inspect the quality behind the averages.
If the payment calendar is the problem, move to the cash flow forecast template. Use the working capital calculator to inspect the balance-sheet position, and the published cash-flow killers guide to trace the operating cause.
Frequently asked questions
What is the cash conversion cycle formula?
Cash conversion cycle equals days inventory outstanding plus days sales outstanding minus days payables outstanding: CCC = DIO + DSO – DPO.
Is a lower cash conversion cycle always better?
Usually, but only when it comes from healthier operations. Stockouts, rejected sales, or suppliers paid late can create a misleading improvement.
Can the cash conversion cycle be negative?
Yes. Businesses that collect customer cash before supplier payments are due can have a negative cycle. Confirm that it reflects the business model, not one unusual period.
How often should a business calculate CCC?
Monthly works for many operating businesses. Seasonal companies should compare the same period last year as well as the prior month.
Can a service business use the cash conversion cycle?
Yes, with care. Set inventory to zero and focus on receivable and payable days. State clearly that the model does not have a physical inventory cycle.
What to do next
Enter one consistent period, calculate all three components, and choose the bottleneck you can change without breaking a guardrail.
Run the sprint for 30 days, then recalculate with the same method. A smaller CCC earns its value only when the cash improves and the operation still works.