Cash Conversion Cycle (CCC) · Days-to-Dollars

Turn cash conversion days into dollars — and see which lever moved.

Your balances

Full CCC or services (DSO − DPO). Keep the example, or plug in your own.

Mode
Prior period (optional — for variance)

Days and dollars

CCC components in days and ≈$/day — then dial each lever (−30…+30 days or $).

Cash impact by component dial ($)

How this is calculated
  • DSO = AR ÷ Revenue × period days
  • DIO = Inventory ÷ COGS × period days (0 in Services mode)
  • DPO = AP ÷ COGS × period days
  • CCC = DIO + DSO − DPO (Services: DSO − DPO)
  • $ / day DSO ≈ Revenue ÷ period days
  • $ / day DIO / DPO ≈ COGS ÷ period days
  • Dial — change days (−30…+30); cash impact: DSO/DIO ↓ frees cash (−days × $/day); DPO ↑ frees cash (+days × $/day). Switch to $ mode to set a signed cash move.

Further reading (not scraped): Wall Street Prep CCC, Deloitte working capital, APQC. Illustrative — not advice.

Take it with you

Get the worked example workbook in Excel — type your own numbers into it.

The Excel is the worked example workbook — type your own numbers into it. Stays on your device.