--- name: working-capital description: Manage working capital including cash conversion cycle optimization, DSO/DPO/DIO management, liquidity management, inventory optimization, trade credit, and working capital financing. Use when optimizing the cash conversion cycle, managing receivables and payables efficiency, improving liquidity, negotiating trade credit terms, or managing working capital financing. Triggers on phrases like "working capital", "cash conversion cycle", "DSO", "DPO", "DIO", "liquidity", "trade credit", "receivables management", "payables optimization", "working capital financing", "revolving credit facility", "cash management". --- # Working Capital Management Optimize the cash conversion cycle and maximize liquidity through efficient management of current assets and liabilities. ## Cash Conversion Cycle Optimization ### CCC Analysis & Improvement ``` CASH CONVERSION CYCLE ANALYSIS — Q4 2024 ══════════════════════════════════════════ CCC COMPONENTS: Days Sales Outstanding (DSO): 42 days Days Inventory Outstanding (DIO): 0 days (SaaS — no inventory) Days Payable Outstanding (DPO): 35 days CASH CONVERSION CYCLE (CCC): CCC = DSO + DIO - DPO CCC = 42 + 0 - 35 = 7 days Interpretation: Positive 7 days (cash tied up for 7 days on average) Industry benchmark (SaaS): 15-30 days Our performance: 7 days (EXCELLENT — well below industry average) Note: For SaaS with annual prepayment, effective DSO is lower because cash is received before revenue is recognized (deferred revenue acts as source of working capital) DSO TRENDS (12 Months): ┌──────────┬──────────┬──────────┬──────────┐ │ Quarter │ DSO │ Trend │ Comment │ ├──────────┼──────────┼──────────┼──────────┤ │ Q1 FY24 │ 48 days │ — │ Baseline │ │ Q2 FY24 │ 45 days │ ↓ 3 days │ Collections│ │ │ │ │ process │ │ Q3 FY24 │ 43 days │ ↓ 2 days │ Automation│ │ Q4 FY24 │ 42 days │ ↓ 1 day │ Near target│ │ Target │ 35 days │ │ Industry │ │ │ │ │ best │ └──────────┴──────────┴──────────┴──────────┘ DSO improvement initiatives: 1. Electronic invoicing (implemented Q2 — reduced processing time) 2. Automated payment reminders (implemented Q3 — improved compliance) 3. Early payment discount (0.5% for payment within 10 days — 15% adoption) 4. Customer credit scoring (implemented Q4 — tightened terms for high-risk) DPO MANAGEMENT: Current DPO: 35 days Standard terms: Net 30 (80% of vendors) / Net 45 (15%) / Net 60 (5%) Average payment: Day 35 (5 days after terms for most vendors) DPO optimization opportunities: - Negotiate extended terms for top 20 vendors (target: Net 45) - Utilize full payment terms (currently paying early on 30% of invoices) - Dynamic discounting for early payment (selective — when cost of capital < discount) Risk of extending DPO: - Vendor relationship impact (monitor satisfaction) - Missed early payment discounts ($120K/year potential savings) - Supply chain reliability (critical vendor payment priority) DEFERRED REVENUE (SaaS-specific): Deferred revenue balance: $48,000,000 As % of annual revenue: 27.5% (strong prepayment position) Run-rate recognition: $4,000,000/month Impact on working capital: - Deferred revenue acts as "interest-free financing" - Reduces need for external working capital financing - Provides buffer for cash flow volatility - Recognition lag: 8-10 months (annual contracts) ``` ## Receivables Management ### AR Optimization Framework ``` RECEIVABLES MANAGEMENT FRAMEWORK: ══════════════════════════════════ CREDIT POLICY: Credit assessment process: 1. Customer credit application (new logo) 2. Credit score check (D&B, Experian, or equivalent) 3. Financial statement review (enterprise accounts) 4. Reference check (industry references) 5. Credit limit assignment Credit limit tiers: Tier 1 (Low risk): Up to $500K — automated approval Tier 2 (Medium): $500K - $2M — Finance manager approval Tier 3 (High): $2M+ — CFO approval Tier 4 (Exception): Any — Board approval Terms by customer segment: Enterprise (>$100K ACV): Net 30 (standard), Net 45 (negotiated) Mid-market ($20K-$100K ACV): Net 15 (standard) SMB (<$20K ACV): Prepaid / Net 10 Government: Net 45 (standard — prompt payment act) COLLECTIONS PROCESS: Aged receivables (Q4 2024): Current (0-30 days): $18,500,000 (72%) 31-60 days: $4,200,000 (16%) 61-90 days: $2,100,000 (8%) 91-120 days: $900,000 (4%) 120+ days: $300,000 (1%) ════════════════════════════════════ TOTAL AR: $26,000,000 Gross-to-net: Less: Allowance for doubtful accounts: ($520,000) NET AR: $25,480,000 Allowance rate: 2.0% (industry avg: 2.5%) Collection workflow: Day 0-15: Automated invoice delivery (electronic) Day 16-30: Friendly reminder (automated email) Day 31-45: Collection call (AR specialist) Day 46-60: Escalation to AR manager + customer account manager Day 61-90: Formal collection notice + payment plan negotiation Day 91-120: Collections agency referral (selective) 120+ days: Write-off review (individual assessment) Collection effectiveness index (CEI): 94% Industry benchmark: 85% — above average ✓ Trend: Improving (Q1: 89% → Q4: 94%) BAD DEBT MANAGEMENT: Historical write-off rate: 0.8% of revenue (low — strong customer base) Current allowance: $520,000 (2.0% of gross AR) Write-off approval: <$5,000: AR Manager $5,000-$25,000: Controller $25,000-$100,000: CFO >$100,000: CEO FACTORS IMPACTING DSO: Positive: - Annual prepayment model (85% of customers) - Automated billing and invoicing - Electronic payment options (ACH, wire, card) - Strong customer financials (enterprise focus) Negative: - Enterprise customer payment cycles (procurement delays) - International payment delays (currency conversion, local practices) - Dispute resolution (billing disputes, service credits) - Quarter-end timing (invoice vs. payment date mismatch) DSO IMPROVEMENT TARGETS: 2025 target: 38 days (-4 days from current) Levers: 1. Increase electronic invoicing adoption (95% → 99%) 2. Implement payment link in invoices (reduce friction) 3. Tighten credit terms for high-risk customers 4. Quarterly credit limit review (dynamic adjustment) 5. Customer self-service portal (payment visibility) ``` ## Working Capital Financing ### Financing Strategies ``` WORKING CAPITAL FINANCING OPTIONS: ══════════════════════════════════ CURRENT FINANCING: Revolving credit facility (RCF): Facility size: $25,000,000 Drawn: $0 (undrawn — strong cash position) Available: $25,000,000 Interest rate: SOFR + 1.25% (5.05% current) Fee (commitment): 0.25% on undrawn amount Maturity: March 2027 (2 years) Covenants: - Fixed charge coverage ratio: >1.5x (current: 4.2x) - Leverage ratio (net debt/EBITDA): <3.0x (current: 0.82x) - Minimum liquidity: >$10M (current: $17.5M + $25M revolver) Status: ✓ All covenants comfortably met ALTERNATIVE FINANCING OPTIONS: 1. Asset-based lending (ABL): - Available against AR and other assets - Advance rate: 85% of eligible AR - Potential capacity: ~$22M (but unnecessary — strong balance sheet) - Use case: Only if RCF unavailable or insufficient 2. Supply chain finance (reverse factoring): - Program with [Bank] for vendor payments - Vendor benefit: Early payment at lower cost - Company benefit: Extend DPO without vendor impact - Participation: 15 key vendors enrolled - Average extension: 15 additional days - Annual benefit: ~$300K working capital improvement 3. Receivables factoring: - Not currently used (strong credit quality, low cost of capital) - Would consider only for specific large-ticket deals - Discount rate: 1.5-2.5% of factored amount - Impact on relationships: Potential (customer sees factor) 4. Inventory financing: - N/A (SaaS model — no inventory) WORKING CAPITAL BUDGET: 2025 working capital plan: Expected AR growth: +35% (with revenue) Expected AP growth: +30% (with expenses) Net working capital investment: $3.2M (one-time, growth-related) Funding source: Organic cash flow (sufficient) External financing needed: $0 (organic sufficient) Sensitivity analysis: Revenue growth 25% (downside): WC investment $2.1M (easier) Revenue growth 45% (upside): WC investment $4.8M (manageable) Revenue growth 55%+ (hyper): Consider external financing CASH MANAGEMENT BEST PRACTICES: Cash pooling: ✓ Implemented (netting across entities) Cash forecasting: ✓ 13-week rolling + 12-month quarterly Sweep accounts: ✓ Daily sweep to main operating account Investment policy: ✓ Short-term Treasuries + money market (excess cash) Banking relationships: 3 banks (primary, backup, international) ``` ## Liquidity Management ### Cash Position & Forecasting ``` LIQUIDITY MANAGEMENT FRAMEWORK: ════════════════════════════════ CASH POSITION (as of Jan 27, 2025): Operating accounts: $12,800,000 Money market funds: $3,200,000 Short-term investments: $1,500,000 (T-bills, 3-month) Restricted cash: $0 ════════════════════════════════════ TOTAL CASH & EQUIVALENTS: $17,500,000 Debt obligations (current): Term loan (current portion): $2,500,000 Accounts payable: $8,200,000 Accrued liabilities: $4,100,000 ════════════════════════════════════ TOTAL CURRENT LIABILITIES: $14,800,000 NET LIQUIDITY: $2,700,000 (Note: Excludes $25M revolver — total liquidity: $27,700,000) CASH RUNWAY ANALYSIS: Monthly cash burn (net): Operating cash outflow: $18,500,000/month Operating cash inflow: $21,200,000/month Net cash flow: +$2,700,000/month (POSITIVE) Runway (at current burn): With $17.5M cash + $25M revolver: >50 months Without revolver: >65 months (growing cash, not burning) Status: EXCELLENT — no near-term liquidity concern 13-WEEK CASH FLOW FORECAST: ┌────────────┬──────────┬──────────┬──────────┬──────────┐ │ ($000s) │ Week 1 │ Week 2 │ Week 3 │ Week 4 │ ├────────────┼──────────┼──────────┼──────────┼──────────┤ │ Opening │ $17,500 │ $17,500 │ $17,500 │ $17,500 │ │ Inflows │ $5,200 │ $5,400 │ $5,100 │ $5,500 │ │ Outflows │ ($4,800) │ ($4,600) │ ($4,900) │ ($4,700) │ │ Capex │ ($300) │ ($200) │ ($250) │ ($250) │ │ Tax │ ($0) │ ($0) │ ($0) │ ($0) │ │ Dividends │ ($0) │ ($0) │ ($0) │ ($0) │ │ Net change │ +$100 │ +$600 │ +($50) │ +$550 │ │ Closing │ $17,600 │ $18,100 │ $18,050 │ $18,600 │ └────────────┴──────────┴──────────┴──────────┴──────────┘ 13-week projection: Cash increasing to ~$19.2M Confidence: HIGH (historical accuracy >95%) CASH MANAGEMENT POLICY: Minimum cash balance: $10,000,000 (policy threshold) Investment policy: - Excess cash (> $12M): Money market + short-term Treasuries - Maturity: < 90 days - Credit quality: AAA minimum - Counterparty limit: $10M per institution Liquidity stress triggers: - Cash < $15M: Review spending, accelerate collections - Cash < $12M: RCF draw authorization - Cash < $10M: Emergency cost reduction plan - Current position: $17.5M (well above all triggers) BANKING RELATIONSHIPS: Primary bank: [Bank A] — operating accounts, RCF Secondary bank: [Bank B] — backup operating, international Investment bank: [Bank C] — capital markets, advisory Relationship value: - Competitive pricing on lending - Access to capital markets - Treasury management services - Advisory relationships ``` ## Output ### Working Capital Dashboard ``` WORKING CAPITAL DASHBOARD — Jan 27, 2025 ══════════════════════════════════════════ Cash Position: Total cash: $17.5M Available revolver: $25.0M Total liquidity: $42.5M Cash runway: >65 months (net positive cash flow) 13-week projection: $19.2M (increasing) Cash Conversion Cycle: DSO: 42 days (target: 38 days) DIO: 0 days (SaaS) DPO: 35 days (maintaining vendor relationships) CCC: 7 days (excellent — well below industry) Receivables: Total AR: $26.0M CEI: 94% (improving) Allowance: $520K (2.0% — below industry avg.) >90 days: $1.2M (5% of gross — manageable) Bad debt write-offs: $0 (YTD) Payables: Total AP: $8.2M Within terms: 92% (8% early payment — review) Vendor concentration: Top 20 = 45% (monitor) Supply chain finance: 15 vendors enrolled Liquidity: Current ratio: 1.18x Quick ratio: 1.18x (no inventory) Revolver utilization: 0% Covenant compliance: ✓ All met (wide margin) Investment portfolio: $4.7M (money market + T-bills) Actions: 1. DSO improvement — implement payment links (Feb) 2. DPO optimization — negotiate terms with top 20 vendors (Mar) 3. Quarterly cash forecast update (Feb 15) 4. Revolver covenant review (Q1) 5. Bank relationship review (Q2) ``` ## Integration Points - ERP/GL (NetSuite, SAP): AR, AP, cash data - Cash management platforms (Concur, Treasury Management Systems): Cash pooling, forecasting - CRM (Salesforce): Pipeline data for cash inflow forecasting - Banking platforms: Account aggregation, payment processing - BI platforms: Working capital dashboards - RPA tools: Automated reconciliation, payment processing - Credit bureaus (D&B, Experian): Customer credit scoring - Supply chain finance platforms: Reverse factoring programs - Document management: Contract terms, credit applications - Payment gateways: Electronic payment processing ## Edge Cases - **Seasonal cash flow swings**: Peak season cash accumulation; off-season cash drawdown; proactive planning - **Large deal timing**: Concentrated revenue recognition; cash flow volatility; deal structuring - **International operations**: FX risk on working capital; local banking relationships; transfer pricing - **M&A transactions**: Working capital purchase price adjustments; integration of banking/RCF - **Credit crunch**: RCF availability uncertainty; alternative financing; cost of capital spike - **Customer concentration**: Key customer payment delay; credit risk; reserve assessment - **Supply chain disruption**: Vendor payment urgency; cash prioritization; relationship management - **Regulatory changes**: Prompt Payment Act (government); local payment rules (international) - **Cyber attack on banking**: Account compromise; fraud detection; payment hold; emergency procedures - **Hypergrowth**: Working capital investment outpaces cash generation; external financing need