Finance AI Skill

Liquidity Management

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, optimiz...

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)