A shorter (or negative) cash conversion cycle means a business needs less working capital. Amazon and Apple famously collect from customers before paying suppliers. A lengthening CCC can signal problems collecting cash or selling stock.
How to use the Cash Conversion Cycle Calculator
- Revenue
- Cost of goods sold
- Beginning inventory
- Ending inventory
- Beginning accounts receivable
- Ending accounts receivable
- Beginning accounts payable
- Ending accounts payable
- Days in the period
Results update as you type, and every field accepts the units shown in its menu.
How it works
Enter revenue, cost of goods sold and the beginning and ending inventory, receivables and payables.
Inputs explained
| Field | What to enter |
|---|---|
| Revenue | Amount in your currency |
| Cost of goods sold | Amount in your currency |
| Beginning inventory | Amount in your currency |
| Ending inventory | Amount in your currency |
| Beginning accounts receivable | Amount in your currency |
| Ending accounts receivable | Amount in your currency |
| Beginning accounts payable | Amount in your currency |
| Ending accounts payable | Amount in your currency |
| Days in the period | A number |
What each result means
- Days inventory outstanding (DIO) = ([Beginning inventory] + [Ending inventory])÷2÷[Cost of goods sold]×[Days in the period]
- Days sales outstanding (DSO) = ([Beginning accounts receivable] + [Ending accounts receivable])÷2÷[Revenue]×[Days in the period]
- Days payable outstanding (DPO) = ([Beginning accounts payable] + [Ending accounts payable])÷2÷[Cost of goods sold]×[Days in the period]
- Cash conversion cycle = [Days inventory outstanding (DIO)] + [Days sales outstanding (DSO)] – [Days payable outstanding (DPO)]
Example values
How the main result changes when Revenue changes and everything else stays at the example values above:
| Revenue | Cash conversion cycle (days) |
|---|---|
| 1,000,000 | 85.8 |
| 1,500,000 | 66.3 |
| 2,000,000 | 56.6 |
| 2,500,000 | 50.7 |
| 3,000,000 | 46.8 |
| 4,000,000 | 42 |
Formula
DIO = average inventory ÷ COGS × 365
DSO = average receivables ÷ revenue × 365
DPO = average payables ÷ COGS × 365
CCC = DIO + DSO − DPO
Worked example
Inputs: Revenue: $2,000,000; Cost of goods sold: $1,200,000; Beginning inventory: $180,000; Ending inventory: $220,000; Beginning accounts receivable: $150,000; Ending accounts receivable: $170,000; Beginning accounts payable: $100,000; Ending accounts payable: $120,000; Days in the period: 365.
Results: Days inventory outstanding (DIO) = 60.8 days; Days sales outstanding (DSO) = 29.2 days; Days payable outstanding (DPO) = 33.5 days; Cash conversion cycle = 56.6 days.
Frequently asked questions
What is a good cash conversion cycle?
Shorter is better; it varies widely by industry.
Can the cash conversion cycle be negative?
Yes, when a company is paid before it pays suppliers.
How can a business shorten its CCC?
Sell inventory faster, collect receivables sooner and negotiate longer supplier terms.