--- name: liquidity-management description: Manage organizational liquidity including cash position monitoring, short-term funding strategies, liquidity stress testing, credit facility management, and cash concentration optimization. Use when assessing liquidity position, managing cash pools, optimizing short-term investments, conducting liquidity stress tests, managing revolving credit facilities, or preparing liquidity reports for treasury and board. Triggers on phrases like "liquidity management", "cash position", "liquidity stress test", "credit facility", "revolving credit", "cash concentration", "short-term funding", "liquidity coverage", "cash pooling", "committed credit facility", "liquidity buffer". --- # Liquidity Management Monitor, optimize, and safeguard organizational liquidity to ensure the company can meet all financial obligations while maximizing returns on excess cash. ## Workflow ### 1. Daily Cash Position Management ``` DAILY CASH POSITION REPORT ═══════════════════════════════════════ AS OF: March 15, 2024 (5:00 PM ET) CASH BALANCES BY ACCOUNT: ═══════════════════════════════════════ Entity Bank Account Currency Balance Available ───────────────────────────────────────────────────────────────────────────── US Parent Chase Operate USD $12,450,000 $12,450,000 US Parent Chase Reserve USD $5,000,000 $5,000,000 US Parent BofA Payroll USD $3,200,000 $3,200,000 EU Holding Deutsche Operating EUR €8,500,000 €8,500,000 UK Sub HSBC Operating GBP £3,200,000 £3,200,000 SG Subsidiary DBS Operating SGD $12,000,000 $12,000,000 ───────────────────────────────────────────────────────────────────────────── CONSOLIDATED (USD equivalent @ spot rates): USD accounts: $20,650,000 EUR accounts (€8.5M × 1.0850): $9,222,500 GBP accounts (£3.2M × 1.2650): $4,048,000 SGD accounts ($12M SGD × 0.7450): $8,940,000 ────────────────────────────────────────────────────────────────────── TOTAL GLOBAL CASH: $42,860,500 RESTRICTED / UNAVAILABLE: Less: Restricted cash (escrow, letters of credit): ($1,500,000) Less: Reserve account (board-designated): ($5,000,000) ────────────────────────────────────────────────────────────────────── AVAILABLE CASH: $36,360,500 COMMITTED CREDIT FACILITIES: Revolving Credit Facility: $100,000,000 (committed, undrawn) Less: Letters of credit: ($2,500,000) Less: Bank guarantees: ($500,000) ────────────────────────────────────────────────────────────────────── AVAILABLE REVOLVER: $97,000,000 TOTAL LIQUIDITY (cash + available revolver): $133,360,500 COMPARISON TO PRIOR DAY: Prior day liquidity: $135,200,000 Change: ($1,839,500) Primary drivers: → Wire payments to vendors: ($8,500,000) → Customer collections: +$7,200,000 → FX translation: ($539,500) ``` ### 2. Cash Flow Forecasting (Short-Term) ``` 13-WEEK CASH FLOW FORECAST ═══════════════════════════════════════ Week ending Collections Disbursements Net Cash Cash Balance (inflows) (outflows) Flow (cumulative) ──────────────────────────────────────────────────────────────────────── Mar 22 $8,500,000 ($6,200,000) $2,300,000 $38,660,500 Mar 29 $7,800,000 ($7,500,000) $300,000 $38,960,500 Apr 5 $9,200,000 ($6,800,000) $2,400,000 $41,360,500 Apr 12 $8,000,000 ($8,200,000) ($200,000) $41,160,500 Apr 19 $7,500,000 ($7,000,000) $500,000 $41,660,500 Apr 26 $9,800,000 ($6,500,000) $3,300,000 $44,960,500 May 3 $8,200,000 ($7,800,000) $400,000 $45,360,500 May 10 $8,500,000 ($8,000,000) $500,000 $45,860,500 May 17 $7,900,000 ($7,200,000) $700,000 $46,560,500 May 24 $9,000,000 ($9,500,000) ($500,000) $46,060,500 May 31 $8,800,000 ($6,500,000) $2,300,000 $48,360,500 Jun 7 $7,600,000 ($7,400,000) $200,000 $48,560,500 Jun 14 $9,500,000 ($8,200,000) $1,300,000 $49,860,500 ──────────────────────────────────────────────────────────────────────── Average weekly collections: $8,446,154 Average weekly disbursements: ($7,315,385) Average weekly net cash flow: $1,130,769 FORECAST CONFIDENCE: Weeks 1-4: HIGH (actuals-based, confirmed transactions) Weeks 5-8: MODERATE (pipeline-based, some uncertainty) Weeks 9-13: LOWER (assumption-based, update weekly) KEY CASH EVENTS (next 13 weeks): → Apr 12: Tax payment — ($1,500,000) included in disbursements → Apr 26: Customer milestone payment — $2,500,000 in collections → May 24: Capital expenditure — ($2,000,000) equipment purchase → Jun 7: Quarterly interest on debt — ($800,000) → Jun 14: Dividend payment — ($3,000,000) ``` ### 3. Liquidity Stress Testing ``` LIQUIDITY STRESS TEST ═══════════════════════════════════════ BASE CASE LIQUIDITY POSITION: Cash: $36,360,500 Available revolver: $97,000,000 Total liquidity: $133,360,500 Monthly burn (net cash outflow): ($4,523,077) Liquidity runway: 29.5 months STRESS SCENARIO 1: MODERATE DOWNTURN ═══════════════════════════════════════ Assumptions: → Revenue declines 20% (collections drop proportionally) → Customer payment terms extend 15 days (DSO increases) → Operating expenses increase 10% (hiring freeze ineffective) → Revolver access reduced to 50% ($48.5M available) → No new financing available Impact: → Monthly collections: $8.4M × 80% = $6.7M → Monthly disbursements: $7.3M × 110% = $8.0M → Monthly net outflow: ($1.3M) Monthly outlook (with stress): Collections: $6.7M Disbursements: $8.0M Net monthly burn: ($1.3M) Available liquidity: $36.4M + $48.5M = $84.9M Runway: $84.9M / $1.3M = 65 months ✓ STRESS SCENARIO 2: SEVERE DOWNTURN ═══════════════════════════════════════ Assumptions: → Revenue declines 40% → DSO increases by 30 days → Operating expenses increase 15% → Revolver access reduced to 25% ($24.25M) → Key customer churns ($2M annual revenue lost) → No new financing; potential covenant concerns Impact: → Monthly collections: $8.4M × 60% = $5.0M → Monthly disbursements: $7.3M × 115% = $8.4M → Monthly net outflow: ($3.4M) Liquidity outlook: Available liquidity: $36.4M + $24.25M = $60.65M Runway: $60.65M / $3.4M = 17.8 months ✓ MONTH-BY-MONTH CASH POSITION: Month 1: $60.65M - $3.4M = $57.25M Month 3: $50.45M Month 6: $40.45M Month 9: $30.45M Month 12: $20.45M Month 15: $10.45M Month 18: $0.05M (liquidity exhausted) STRESS SCENARIO 3: COMBINED CREDIT + OPERATING CRISIS ═══════════════════════════════════════ Assumptions: → Revenue declines 50% → Revolver drawn down by other entities (only $10M available) → Supplier demands cash on delivery (working capital squeeze) → Interest rates spike 200bps (increased debt service) Impact: → Monthly net burn: ($5.8M) → Available liquidity: $36.4M + $10M = $46.4M → Runway: 8 months ⚠ LIQUIDITY MITIGATION ACTIONS: ═══════════════════════════════════════ Immediate (0-30 days): → Delay non-essential capex ($2M, 3-month deferral) → Negotiate payment term extensions with top 10 vendors (+15 days) → Accelerate customer collections (early payment discount) → Freeze hiring and discretionary spending → Review dividend policy (suspend if needed) 30-90 days: → Right-size headcount if revenue decline persists → Sell non-core assets (estimate: $5M net proceeds) → Secure additional credit facility → Explore asset-based lending 90+ days: → Strategic review (partnerships, JV, sale) → Equity raise (bridge financing) → Debt refinancing ``` ### 4. Cash Concentration & Pooling ``` CASH CONCENTRATION STRATEGY ═══════════════════════════════════════ CURRENT STATE (Decentralized): Each entity maintains own cash accounts Local treasury manages local banking relationships Limited visibility into global cash position TARGET STATE (Centralized Pooling): OPTION A: NOTIONAL POOLING (recommended for multi-country) → Each entity keeps own account (legal ownership maintained) → Bank nets balances across pool for interest calculation → Overdraft in one account offset by surplus in another → Interest savings on net position only → No actual funds transfer (avoids withholding tax) Applicable entities (same bank, same country): → US Parent: Chase accounts (3 accounts) → EU Holding: Deutsche Bank accounts → UK Sub: HSBC accounts OPTION B: PHYSICAL POOLING / ZERO BALANCING → Sub-account balances swept to master account daily → Central treasury manages master account → Funds physically transfer (withholding tax considerations) → Maximum interest optimization Applicable: Same legal entity accounts only OPTION C: INTRA-COMPANY LENDING → Surplus entities lend to deficit entities → Arm's-length interest rate (transfer pricing) → Formal intercompany loan agreements → Withholding tax on interest payments EXPECTED BENEFITS: → Interest savings: $150K-$300K/year → Reduced bank accounts: 25 → 12 → Improved visibility: Real-time global position → Reduced bank fees: $50K/year savings ``` ### 5. Credit Facility Management ``` REVOLVING CREDIT FACILITY OVERVIEW ═══════════════════════════════════════ FACILITY DETAILS: Lender: Bank of America (agent), syndicate of 5 banks Facility type: Committed revolving credit facility Amount: $100,000,000 Maturity: September 2027 (3.5 years remaining) Purpose: Working capital, general corporate purposes, acquisitions PRICING: Base rate option: SOFR + 1.25% = 5.50% (current) SOFR option: SOFR + 1.50% = 5.75% (current) Commitment fee (undrawn): 0.25% = $242,500/year Utilization: 0% (undrawn) COVENANTS: ═══════════════════════════════════════ Covenant Requirement Actual Status ──────────────────────────────────────────────────────────── Leverage Ratio ≤ 3.0x 0.50x ✓ COMPLY (Net Debt / EBITDA) (very strong) Interest Coverage ≥ 3.0x 14.4x ✓ COMPLY (EBITDA / Interest) Minimum Liquidity ≥ $20M $133.4M ✓ COMPLY Minimum Net Worth ≥ $150M $180M ✓ COMPLY Unencumbered Assets ≥ 65% of total 80% ✓ COMPLY CapEx Limit ≤ $15M/year $8M (YTD) ✓ COMPLY COVENANT TESTING: → Tested quarterly (Jan, Apr, Jul, Oct) → Deliver financials to agent within 45 days of quarter end → Deliver compliance certificate → Next test: April 30, 2024 DRAW PROCEDURES: 1. Treasury submits draw request (24-hour notice) 2. Specify amount, pricing option, purpose 3. Agent confirms availability 4. Funds wired to operating account 5. Interest accrues from draw date 6. Repayments reduce outstanding balance REPAYMENT SCHEDULE: → Voluntary prepayments: Any time, no penalty → Mandatory prepayment: On asset sale or insurance proceeds → Extinguishment fee: 1.0% if refinanced within first 12 months (expired) ``` ## Edge Cases - **Cash trapped overseas**: Tax implications of repatriation; use intercompany lending or dividends strategically - **Restrictive covenants**: Monitor closely; stress-test covenant compliance under adverse scenarios - **Bank relationship concentration**: Diversify across banks; avoid single-bank dependency for critical accounts - **FX risk on foreign cash**: Natural hedging (match FX inflows/outflows); forward contracts for large transfers - **Regulatory restrictions**: Operating in countries with capital controls; plan for limited access ## Integration Points - **Banking platforms**: Cash management portals, SWIFT, ACH, wire systems - **Treasury management systems**: Kyriba, SPL Global, SAP TMS - **ERP systems**: Cash account integration, payment processing - **Forecasting tools**: 13-week cash flow models, rolling forecasts - **Market data**: Bloomberg, Reuters (FX rates, interest rates) - **Reporting**: Board liquidity reports, covenant compliance certificates ## Output ### Liquidity Dashboard ``` LIQUIDITY DASHBOARD — March 2024 ═══════════════════════════════════════ CASH & LIQUIDITY: Global cash: $42.9M Available cash: $36.4M Available revolver: $97.0M Total liquidity: $133.4M RUNWAY: Base case: 29.5 months Moderate stress: 65.0 months Severe stress: 17.8 months Combined crisis: 8.0 months COVENANT STATUS: All covenants: IN COMPLIANCE ✓ Next test date: April 30, 2024 Closest-to-breached: Leverage (0.50x vs 3.0x limit) CASH FORECAST (13-week): Expected ending balance: $49.9M Confidence: HIGH (weeks 1-4), MOD (5-8), LOW (9-13) Next update: Weekly (Monday) ACTIONS: → Cash pooling implementation: In progress (Q2 target) → Bank account rationalization: 8 accounts slated for closure → FX forward program: Under review (€10M exposure identified) ```