Lesson 214 min

Working Capital and Cash Conversion Cycle

Master the cash conversion cycle and its components: DIO, DSO, and DPO.

Learning Objectives

  • Calculate Days Inventory Outstanding (DIO)
  • Understand Days Sales Outstanding (DSO)
  • Apply Days Payable Outstanding (DPO)
  • Master the Cash Conversion Cycle calculation

Working Capital and Cash Conversion Cycle#

The Cash Conversion Cycle (CCC) measures how long it takes a company to convert its investments in inventory and other resources into cash from sales. A shorter cycle means faster cash generation.

Cash Conversion Cycle = DIO + DSO - DPO

Where:

  • DIO = Days Inventory Outstanding
  • DSO = Days Sales Outstanding
  • DPO = Days Payable Outstanding

Days Inventory Outstanding (DIO)#

DIO measures how many days, on average, inventory sits before being sold.

DIO = (Average Inventory / COGS) × 365

Or: 365 / Inventory Turnover

Interpretation#

DIOMeaning
LowerFaster inventory movement—less capital tied up
HigherSlower inventory movement—more capital required

Industry Benchmarks#

IndustryTypical DIO
Grocery15-25 days
Retail45-90 days
Manufacturing60-120 days
Aerospace200+ days

Too Low Can Be Bad

Extremely low DIO might indicate inadequate inventory leading to stockouts and lost sales. Balance efficiency with customer service.

Days Sales Outstanding (DSO)#

DSO measures how many days, on average, it takes to collect payment from customers.

DSO = (Average Accounts Receivable / Revenue) × 365

Or: 365 / Receivables Turnover

Interpretation#

DSOAssessment
< 30 daysExcellent collection efficiency
30-45 daysStandard for most businesses
45-60 daysMay need improvement
> 60 daysPotential collection problems

Industry Context#

Business TypeTypical DSO
Cash/credit card sales1-5 days
Consumer products30-45 days
B2B services45-60 days
Government contracts60-90+ days

Days Payable Outstanding (DPO)#

DPO measures how long a company takes to pay its suppliers.

DPO = (Average Accounts Payable / COGS) × 365

Or: 365 / Payables Turnover

Interpretation#

DPOAssessment
High (45-60+)Preserves cash, uses supplier financing
Low (15-30)Pays quickly, may get discounts

The Trade-off#

  • High DPO: Keeps cash longer but may strain supplier relationships
  • Low DPO: Uses cash faster but may earn early payment discounts

The Cash Conversion Cycle#

Calculation#

ComponentFormulaDays
DIO(Inventory/COGS) × 36545
DSO(AR/Revenue) × 36535
DPO(AP/COGS) × 36530
CCCDIO + DSO - DPO50 days

Interpretation#

CCCMeaning
PositiveCash is tied up for that many days
ZeroOperations are self-funding
NegativeCompany is funded by suppliers/customers

Examples by Company Type#

Company TypeTypical CCC
AmazonNegative (-20 to -30 days)
Dell (direct model)Negative
Traditional retailer30-60 days
Manufacturer60-120 days
Aerospace150-250 days

Negative CCC = Competitive Advantage

Companies with negative CCC (like Amazon) get paid before they pay suppliers—effectively using supplier and customer money to fund operations. This is a powerful working capital advantage.

Practical Application#

Analyzing Working Capital Efficiency#

MetricCompanyIndustryAssessment
DIO55 days45 daysSlow inventory movement
DSO40 days35 daysSlightly slow collections
DPO35 days40 daysPays faster than peers
CCC60 days40 daysLess efficient

Conclusion: Company has 20 more days of cash tied up than peers—opportunity for improvement.

Trend Analysis Red Flags#

TrendPotential Issue
Rising DIOInventory buildup, obsolescence risk
Rising DSOCollection problems, customer quality
Falling DPOLoss of supplier terms or leverage
Rising CCCOverall working capital deterioration

Working Capital Optimization#

To shorten CCC:

  1. Reduce DIO: Better inventory management, demand forecasting
  2. Reduce DSO: Tighter credit terms, faster collections
  3. Increase DPO: Negotiate better supplier terms

Key Takeaways

  • DIO = Days Inventory Outstanding—how long inventory sits
  • DSO = Days Sales Outstanding—time to collect from customers
  • DPO = Days Payable Outstanding—time to pay suppliers
  • CCC = DIO + DSO - DPO—total days cash is tied up
  • Negative CCC (Amazon, Dell) is a competitive advantage
  • Compare to industry peers—groceries have low CCC; aerospace has high CCC
  • Rising CCC trend indicates deteriorating working capital efficiency