--- name: cash-conversion-cycle description: Calculate, monitor, and optimize the cash conversion cycle (CCC) — the time between cash outflow for purchases and cash inflow from sales. Use when analyzing working capital efficiency, reducing days sales outstanding (DSO), extending days payable outstanding (DPO), optimizing inventory days (DIO), or identifying working capital improvement opportunities. Triggers on phrases like "cash conversion cycle", "CCC", "working capital cycle", "DSO optimization", "DPO extension", "inventory turnover", "days in inventory", "working capital efficiency", "cash tied up". --- # Cash Conversion Cycle (CCC) Measure and optimize the time it takes for cash invested in operations to be recovered — a critical metric of operational efficiency and liquidity. ## Workflow 1. **Calculate current CCC**: Compute DSO, DIO, and DPO from the latest financial statements; derive CCC = DSO + DIO − DPO. 2. **Benchmark against peers**: Compare each component and total CCC to industry medians and best-in-class companies. 3. **Diagnose bottlenecks**: Identify which component (DSO, DIO, DPO) is the primary driver of an inefficient cycle. 4. **Map cash flow timeline**: Visualize the full cash cycle — from supplier payment through production, sale, and customer collection. 5. **Develop improvement initiatives**: Prioritize actions by cash impact, implementation difficulty, and relationship risk (e.g., pushing on suppliers may damage relationships). 6. **Model impact**: Quantify the cash release from each initiative in dollar terms using working capital formulas. 7. **Implement and track**: Roll out initiatives with clear ownership, timelines, and monthly CCC tracking. 8. **Monitor trade-offs**: Ensure DSO reduction doesn't increase returns/churn, DPO extension doesn't harm supplier relationships, and DIO reduction doesn't cause stockouts. ## CCC Calculation ``` CASH CONVERSION CYCLE FORMULA: CCC = DSO + DIO − DPO Where: DSO = Days Sales Outstanding (how long to collect from customers) DIO = Days Inventory Outstanding (how long inventory sits) DPO = Days Payable Outstanding (how long to pay suppliers) INTERPRETATION: CCC = 0 → You collect from customers at the same pace you pay suppliers CCC > 0 → Cash is tied up in operations for [X] days (working capital cost) CCC < 0 → You're effectively using supplier financing to fund operations (ideal) Lower CCC → Better working capital efficiency, less cash tied up INDIVIDUAL COMPONENTS: DSO = (Accounts Receivable / Annual Revenue) × 365 → Target: Lower is better (faster collection) → Industry benchmarks: SaaS 30–60, Manufacturing 45–90, Retail 10–30 DIO = (Average Inventory / Cost of Goods Sold) × 365 → Target: Lower is better (faster turnover) — but not at cost of stockouts → Industry benchmarks: Manufacturing 60–120, Retail 40–80, SaaS N/A DPO = (Accounts Payable / Annual COGS) × 365 → Target: Higher is better (retain cash longer) — but not at cost of relationships → Industry benchmarks: Manufacturing 45–65, Retail 30–50, SaaS 30–45 WORKING CAPITAL DOLLAR IMPACT: Cash Released = Daily Run Rate × Days of CCC Reduction Daily Run Rate = Annual COGS / 365 (for DIO, DPO) or Annual Revenue / 365 (for DSO) Cost of Working Capital = Cash Tied Up × Cost of Capital (%) If $10M tied up for 45 days at 8% cost of capital: Cost = $10,000,000 × 0.08 × (45/365) = $98,630 annual cost ``` ## CCC Diagnostic Dashboard ``` CASH CONVERSION CYCLE ANALYSIS — January 2025 =============================================== CURRENT STATE: DSO: 62 days | DIO: 78 days | DPO: 45 days CCC = 62 + 78 − 45 = 95 days Cash tied up: $12.7M (at $49M annual run rate) Annual cost (8% capital cost): $995,000 INDUSTRY BENCHMARKS: Component Us Median Best-in-Class Gap ─────────────────────────────────────────────────────────── DSO 62 45 30 +17 days DIO 78 65 45 +13 days DPO 45 50 60 −15 days ─────────────────────────────────────────────────────────── CCC 95 60 35 +30 days TARGET STATE (12-month goal): DSO: 48 days | DIO: 60 days | DPO: 55 days CCC = 48 + 60 − 55 = 53 days Improvement: 42 days reduction Cash released: $12.7M × (42/95) = $5.6M Annual cost savings: $445,000 (at 8% cost of capital) ``` ## DSO Reduction Strategies | Strategy | Description | Typical Impact | Risk | |----------|-------------|----------------|------| | **Electronic invoicing** | Replace paper invoices with e-invoices + payment links | 5–10 days | Low | | **Automated dunning** | Systematic escalation reminders at 0, 7, 14, 30 days past due | 5–8 days | Low | | **Tighten credit terms** | Move from Net 60 to Net 30 for new customers | 10–15 days | Medium (may lose deals) | | **Early payment discounts** | Offer 2/10 Net 30 (2% discount if paid in 10 days) | 5–10 days | Low (cost of discount vs. interest savings) | | **Customer credit scoring** | Tighten credit limits for poor payers; require deposits | 3–7 days | Medium | | **Factoring** | Sell AR to factor at discount (typically 1–3%) | Immediate cash | Medium (cost of factoring) | | **Dynamic discounting** | Offer variable discount based on early payment date | 3–8 days | Low | | **Invoice financing** | Line of credit against AR | Immediate cash | Low (interest on drawn amount) | **DSO Improvement Priority Matrix:** ``` HIGH IMPACT, LOW RISK: → Electronic invoicing (every company should do this) → Automated dunning (set and forget) HIGH IMPACT, MEDIUM RISK: → Tighten credit terms (negotiate, don't impose) → Customer credit scoring (data-driven, fair) IMMEDIATE CASH, HIGHER COST: → Factoring (use for emergency liquidity, not strategy) → Invoice financing (short-term bridge only) ``` ## DIO Reduction Strategies | Strategy | Description | Typical Impact | Risk | |----------|-------------|----------------|------| | **Demand forecasting improvement** | ML-based demand prediction replacing manual forecasts | 10–20 days | Medium (requires data infrastructure) | | **Just-in-time (JIT) receiving** | Coordinate with suppliers for smaller, more frequent deliveries | 10–15 days | Medium (supply chain disruption risk) | | **Slow-moving inventory clearance** | Identify and liquidate items with < 1 turnover per year | 5–15 days | Low (markdown risk) | | **Vendor-managed inventory (VMI)** | Supplier monitors and replenishes inventory automatically | 5–10 days | Low | | **ABC analysis** | Prioritize tight control on A-items (top 20% by value) | 5–10 days | Low | | **Consignment inventory** | Supplier owns inventory until used/sold | 10–20 days | Low (supplier may not agree) | | **Drop shipping** | Ship directly from supplier to customer (zero inventory) | Eliminates DIO for those SKUs | Medium (shipping cost, control) | **Inventory Turnover Target Setting:** ``` Current Turnover = COGS / Average Inventory Target Turnover = Industry Best-in-Class Example: Current: COGS $10M / Avg Inventory $2.1M = 4.8x per year (76 days) Target: 6.0x per year (61 days) Target Inventory = COGS / Target Turnover = $10M / 6.0 = $1.67M Cash released = $2.1M − $1.67M = $430,000 ``` ## DPO Extension Strategies | Strategy | Description | Typical Impact | Relationship Risk | |----------|-------------|----------------|-------------------| | **Negotiate longer terms** | Move from Net 30 to Net 45/60 | 15–30 days | Low (if mutually beneficial) | | **Centralize payments** | Consolidate payables to negotiate from strength | 5–10 days | Low | | **Dynamic payables discounting** | Supplier offers discount for early payment; you pay on your terms | Variable | Low | | **Supply chain finance** | Bank pays supplier early; you pay on original terms | 0 days direct, but builds relationships | None | | **Optimize payment timing** | Pay on last day of terms (not early) | 5–10 days | None (if within agreed terms) | | **Consolidate suppliers** | Fewer, larger suppliers → better terms | 5–15 days | Medium | **DPO Extension Rules:** ``` DO: ✓ Pay on the last day of agreed terms (not a day later) ✓ Communicate proactively if you need more time ✓ Offer early payment discounts to critical suppliers as relationship investment ✓ Negotiate longer terms for new contracts, not existing ones DON'T: ✗ Pay late without communication (damages relationships, triggers penalties) ✗ Extend DPO at the expense of strategic suppliers (they may stop prioritizing you) ✗ Push small suppliers hard (they may have tighter margins and less flexibility) ✗ Use DPO extension as a permanent strategy (market conditions change) ``` ## Working Capital Release Calculator ``` QUANTIFY THE CASH IMPACT OF CCC IMPROVEMENT: Current CCC: 95 days Target CCC: 53 days Improvement: 42 days Daily Revenue Run Rate = Annual Revenue / 365 = $50M / 365 = $136,986/day Daily COGS Run Rate = Annual COGS / 365 = $35M / 365 = $95,890/day Cash Released by Component: DSO: 62 → 48 days (14 day improvement) Cash = 14 × $136,986 = $1,917,804 DIO: 78 → 60 days (18 day improvement) Cash = 18 × $95,890 = $1,726,020 DPO: 45 → 55 days (10 day improvement) Cash = 10 × $95,890 = $958,900 TOTAL CASH RELEASED: $4,602,724 ANNUAL COST SAVINGS (at 8% cost of capital): $4,602,724 × 8% = $368,218/year ROI: For every $1 invested in working capital optimization programs, expect $3–$10 in cash released (industry average) ``` ## Edge Cases - **SaaS businesses**: DIO = 0 (no inventory); CCC = DSO − DPO; focus entirely on accelerating collections and extending payables - **Retail**: High DIO is structural; focus on inventory velocity, omni-channel fulfillment optimization, and vendor consignment - **Construction/Project-based**: CCC can be negative (collect progress billing before paying subcontractors); manage retainage and milestone billing carefully - **Seasonal businesses**: CCC varies dramatically by season; use trailing 12-month averages or seasonally adjusted metrics - **Negative working capital model** (Walmart, Amazon): CCC < 0 — suppliers effectively finance operations; requires massive scale and bargaining power - **Distressed companies**: CCC can spiral — DSO balloons as customers delay, DIO rises as products don't sell, DPO stretches as cash is scarce; intervention required immediately - **International operations**: Currency effects on DSO/DPO; transfer pricing impacts on intercompany CCC; local banking practices affect payment timing ## Output ### CCC Optimization Plan ``` CCC OPTIMIZATION ROADMAP — 12-Month Plan ========================================= PHASE 1: Quick Wins (Months 1–3) — Est. 10-day CCC improvement [ ] Implement e-invoicing for all customers — 5 days DSO [ ] Activate automated dunning (0, 7, 14, 30 days) — 5 days DSO [ ] Shift payments to end of terms — 3 days DPO [ ] Clear slow-moving inventory (>180 days old) — 3 days DIO PHASE 2: Process Optimization (Months 4–6) — Est. 15-day CCC improvement [ ] Negotiate Net 45 terms with top 20 suppliers — 15 days DPO [ ] Implement demand forecasting ML model — 8 days DIO [ ] Introduce early payment discount program — 5 days DSO [ ] ABC inventory analysis for tighter A-item control — 5 days DIO PHASE 3: Structural Changes (Months 7–12) — Est. 17-day CCC improvement [ ] Vendor-managed inventory for top 30 SKUs — 10 days DIO [ ] Customer credit scoring system — 5 days DSO [ ] Supply chain finance program — 7 days DPO [ ] Drop shipping for low-margin, high-volume items — 15 days DIO TOTAL EXPECTED IMPROVEMENT: 42 days TOTAL CASH RELEASED: ~$4.6M ANNUAL COST SAVINGS: ~$370K MONTHLY TRACKING METRICS: • CCC (total and by component) • Cash tied up ($ amount) • Cost of working capital (monthly interest equivalent) • Stockout rate (ensure DIO reduction doesn't hurt sales) • Supplier satisfaction score (ensure DPO extension doesn't harm relationships) • Customer satisfaction / return rate (ensure DSO reduction doesn't hurt experience) ``` ## Integration Points - ERP (NetSuite, SAP): AR aging, inventory reports, AP aging, CCC calculation - CRM (Salesforce): Customer credit limits, payment terms, collection task management - Inventory management (Fishbowl, Cin7): Real-time inventory levels, turnover analysis - Supply chain platforms (Blue Yonder, Kinaxis): Demand forecasting, inventory optimization - Payment platforms (Bill.com, Tipalti): Automated payment scheduling, supplier terms management - BI tools (Tableau, Power BI): CCC dashboards, trend analysis, peer benchmarking - Banking APIs: Real-time cash position, working capital line availability