Finance AI Skill

Treasury Cash Management

Manage treasury operations including cash flow forecasting, liquidity management, banking relationships, debt management, investment management, FX risk, and working capital optimization. Use when forecasting cash flow, optimizing cash position, managing ba...

Treasury & Cash Management

Optimize liquidity, manage cash flow, and protect the organization from financial risk.

Cash Flow Forecasting

Short-Term Cash Flow Forecast (13-Week Rolling)

13-WEEK CASH FLOW FORECAST — Week of Jan 27, 2025
════════════════════════════════════════════════════

Current Cash Position: $42,100,000
Weekly Burn (avg): $3,200,000
Estimated Runway: 13.2 months

WEEKLY PROJECTION:
══════════════════
Week      Inflows       Outflows      Net         Balance
───────────────────────────────────────────────────────────
Week 1    $8,200,000   ($7,400,000)   $800,000    $42,900,000
Week 2    $7,800,000   ($7,600,000)   $200,000    $43,100,000
Week 3    $9,100,000   ($7,200,000)   $1,900,000  $45,000,000
Week 4    $7,500,000   ($8,100,000)  ($600,000)   $44,400,000
Week 5    $8,400,000   ($7,300,000)   $1,100,000  $45,500,000
Week 6    $8,000,000   ($7,500,000)   $500,000    $46,000,000
Week 7    $7,900,000   ($7,400,000)   $500,000    $46,500,000
Week 8    $9,500,000   ($7,100,000)   $2,400,000  $48,900,000
Week 9    $8,100,000   ($7,800,000)   $300,000    $49,200,000
Week 10   $7,600,000   ($7,600,000)   $0          $49,200,000
Week 11   $8,300,000   ($7,200,000)   $1,100,000  $50,300,000
Week 12   $8,700,000   ($7,400,000)   $1,300,000  $51,600,000
Week 13   $7,800,000   ($8,000,000)  ($200,000)   $51,400,000

LOWEST PROJECTED BALANCE: $42,900,000 (Week 1)
HIGHEST PROJECTED BALANCE: $51,600,000 (Week 12)
MINIMUM CASH TARGET: $15,000,000 (4.5 months operating expenses)
STATUS: ✓ Comfortable — 2.9x minimum target at lowest point

Cash Flow Components

CASH INFLOW SOURCES:
════════════════════
Customer collections (AR):    Projected based on AR aging and payment history
  - On-time payers (72%): Collect within terms (Net 30)
  - Slow payers (18%): Collect 15-25 days late
  - Chronic late (5%): Collect 30-45 days late
  - Uncollectible (5%): Write-off allowance
  
Other inflows:
  - Refunds/credits reversed
  - Insurance proceeds
  - Investment income
  - Tax refunds (seasonal)

CASH OUTFLOW COMPONENTS:
════════════════════════
Payroll:                40% of total outflows (largest, most predictable)
Vendor payments (AP):   25% of total outflows (variable by month)
Operating expenses:     15% of total outflows (rent, utilities, insurance)
Debt service:           8% of total outflows (scheduled payments)
Taxes:                  7% of total outflows (income, payroll, sales)
Capex:                  5% of total outflows (lumpy, project-based)

CASH FLOW ASSUMPTIONS:
══════════════════════
Collection timing: Based on historical DSO and AR aging patterns
Payment timing: Based on AP terms and payment optimization strategy
Payroll: Per payroll schedule (bi-weekly, known amounts)
Tax payments: Per tax calendar (quarterly estimated, monthly payroll taxes)
Capex: Per approved capex plan and purchase schedule

Liquidity Management

Cash Position Monitoring

DAILY CASH POSITION REPORT — Jan 27, 2025
══════════════════════════════════════════

Bank Accounts Summary:
  ┌──────────────────────┬───────────────┬───────────────┬───────────────┐
  │ Account              │ Balance       │ Available     │ Restricted    │
  ├──────────────────────┼───────────────┼───────────────┼───────────────┤
  │ Operating — Chase    │ $18,400,000   │ $18,100,000   │ $300,000      │
  │ Operating — BofA     │ $12,700,000   │ $12,700,000   │ $0            │
  │ Reserve — Chase      │ $8,200,000    │ $8,200,000    │ $0            │
  │ Escrow — BofA        │ $1,500,000    │ $0            │ $1,500,000    │
  │ EU Operations — BNP  │ €1,800,000    │ €1,800,000    │ $0            │
  │ Asia Operations — HSBC│ ¥280M       │ ¥280M         │ $0            │
  └──────────────────────┴───────────────┴───────────────┴───────────────┘
  
Total USD Cash:           $42,100,000
Total Available Cash:     $41,800,000 (USD equiv.)
Restricted Cash:          $1,500,000

Cash Concentration:
  >$500K idle for 30+ days: $8,200,000 (reserve account)
  Recommended: Sweep into money market fund (yield: 4.8% vs. 0.01%)
  Annual yield improvement: ~$385K

Committed Credit Facilities:
  Revolver: $25M available, $0 drawn (fully available)
  Term loan: $10M outstanding, next payment due Mar 1, 2025 ($250K)

Liquidity Stress Testing

LIQUIDITY STRESS TEST — Scenarios
══════════════════════════════════

BASE CASE:
  Current cash: $42.1M
  Weekly burn: $3.2M
  Runway: 13.2 months
  Revolver available: $25M
  
STRESS SCENARIO 1 — Revenue Decline 20%:
  Adjusted weekly burn: $3.8M (cost reduction lag)
  Adjusted runway: 11.1 months
  With revolver: 18.7 months
  Action: Activate cost reduction plan within 30 days
  
STRESS SCENARIO 2 — Customer Concentration Loss:
  Loss of top customer ($350K/month revenue):
  Revenue impact: -$4.2M annually
  Adjusted runway: 9.8 months
  With revolver: 16.7 months
  Action: Accelerate sales pipeline; activate contingency budget
  
STRESS SCENARIO 3 — Funding Delay:
  Series B delayed 6 months:
  Current runway: 13.2 months (sufficient)
  Burn rate reduction needed: 15% to extend runway to 15 months
  Action: Pre-plan cost reduction levers (non-headcount first)
  
STRESS SCENARIO 4 — Economic Recession:
  Revenue decline 30% + extended collection (DSO +15 days):
  Adjusted weekly burn: $4.2M (short-term)
  Adjusted runway: 10.0 months
  With revolver: 17.5 months
  Action: Activate full contingency plan; preserve cash
  
MINIMUM LIQUIDITY REQUIREMENT:
  Target: 6 months minimum operating expenses
  Current: 13.2 months — WELL ADEQUATE ✓
  Trigger for concern: <9 months runway
  Trigger for action: <6 months runway

Debt Management

Debt Schedule & Covenant Monitoring

DEBT PORTFOLIO OVERVIEW:
════════════════════════

1. TERM LOAN A — Senior Secured
   Principal: $10,000,000
   Interest rate: SOFR + 2.50% (currently 6.3%)
   Maturity: March 2028
   Payment: Quarterly amortization ($250K/quarter + interest)
   Remaining principal: $9,500,000
   Next payment: March 1, 2025
   Security: First lien on assets
   
2. REVOLVING CREDIT FACILITY
   Commitment: $25,000,000
   Drawn: $0
   Available: $25,000,000
   Interest rate: SOFR + 2.00% (if drawn)
   Commitment fee: 0.25% on undrawn ($62,500/year)
   Maturity: March 2028
   Purpose: Working capital and contingency

3. CONVERTIBLE NOTES
   Principal: $5,000,000
   Interest rate: 5% (plus PIK option)
   Conversion price: $42.50/share
   Maturity: December 2026
   PIK interest accrued: $125,000
   Conversion trigger: Qualified financing >$50M or IPO

TOTAL DEBT: $24,625,000 (incl. PIK)
NET DEBT: $17,525,000 (debt minus cash)
DEBT/EBITDA: 0.82x (covenant max: 3.0x) — WELL WITHIN ✓

COVENANT COMPLIANCE (Quarterly Test):
  ┌──────────────────────────┬──────────┬──────────┬──────────┐
  │ Covenant                 │ Max/Min  │ Actual   │ Status   │
  ├──────────────────────────┼──────────┼──────────┼──────────┤
  │ Total Debt / EBITDA      │ ≤3.0x    │ 0.82x    │ ✓ Pass   │
  │ Senior Debt / EBITDA     │ ≤2.0x    │ 0.65x    │ ✓ Pass   │
  │ Interest coverage        │ ≥2.5x    │ 12.4x    │ ✓ Pass   │
  │ Minimum liquidity        │ ≥$10M    │ $42.1M   │ ✓ Pass   │
  │ Unencumbered cash        │ ≥$5M     │ $40.6M   │ ✓ Pass   │
  └──────────────────────────┴──────────┴──────────┴──────────┘
  Next covenant test: March 15, 2025 (Q4 results)
  Compliance status: ALL COVENANTS SATISFIED — 4Q consecutive

Foreign Exchange Management

FX Exposure & Hedging

FOREIGN EXCHANGE EXPOSURE ANALYSIS:
════════════════════════════════════

FX Exposure Summary:
  EUR-denominated revenue:    $8.4M/year (20% of total)
  EUR-denominated expenses:   $3.2M/year
  Net EUR exposure:           $5.2M/year (net revenue exposure)
  
  JPY-denominated revenue:    $2.1M/year (5% of total)
  JPY-denominated expenses:   $0.8M/year
  Net JPY exposure:           $1.3M/year (net revenue exposure)

FX Rate Movement Impact:
  10% USD strengthening:
    EUR impact: -$520K (revenue translation)
    JPY impact: -$130K (revenue translation)
    Total P&L impact: -$650K
  
  10% USD weakening:
    EUR impact: +$520K
    JPY impact: +$130K
    Total P&L impact: +$650K

HEDGING STRATEGY:
  EUR: Forward contracts for 50% of expected exposure (6-month horizon)
    - Outstanding forward: €2.0M @ 1.0850 (matures June 2025)
    - Hedge effectiveness: 92%
  
  JPY: Not hedged (exposure below materiality threshold of $2M)
  
  Policy: Hedge 40-60% of forecasted exposure for currencies >$3M/year
  Review frequency: Quarterly hedge program review
  Authorization: Treasury Manager recommends, CFO approves

Working Capital Optimization

Cash Conversion Cycle Analysis

WORKING CAPITAL METRICS:
════════════════════════

Days Sales Outstanding (DSO):
  Current: 43 days
  Budget: 38 days
  Industry benchmark: 35 days
  Trend: ↑ 3 days over last 6 months
  Action: Collections initiative needed

Days Payable Outstanding (DPO):
  Current: 52 days
  Budget: 50 days
  Industry benchmark: 45 days
  Trend: Stable
  Action: Maintain — good vendor relationship management

Days Inventory Outstanding (DIO):
  Current: 18 days (SaaS — low inventory, primarily hardware/COGS)
  Budget: 20 days
  Trend: ↓ 2 days (improving)
  Action: On track

CASH CONVERSION CYCLE (CCC):
  CCC = DSO + DIO - DPO
  Current: 43 + 18 - 52 = 9 days
  Budget: 38 + 20 - 50 = 8 days
  Target: 5 days
  Trend: Slightly elevated due to DSO increase

OPTIMIZATION OPPORTUNITIES:
  ┌──────────────────────────────┬──────────────┬───────────────────┐
  │ Initiative                   │ CCC Impact   │ Implementation    │
  ├──────────────────────────────┼──────────────┼───────────────────┤
  │ Accelerate collections       │ -5 days      │ Q1 (high priority)│
  │ Online payment adoption      │ -3 days      │ Q1-Q2             │
  │ Invoice accuracy improvement │ -2 days      │ Ongoing           │
  │ Negotiate extended AP terms  │ +3 days      │ Q2 (careful)      │
  │ Dynamic discounting          │ -2 days      │ Q3 (pilot)        │
  └──────────────────────────────┴──────────────┴───────────────────┘
  Net potential improvement: -9 days (CCC to 0 days)
  Estimated cash freed: ~$400K

Investment Management

Idle Cash Investment Policy

INVESTMENT POLICY — Idle Cash
══════════════════════════════

Investment Objectives:
  1. Safety of principal (primary)
  2. Liquidity (secondary)
  3. Yield (tertiary)

Approved Investment Vehicles:
  ┌───────────────────────────┬──────────────┬───────────┬────────────┐
  │ Vehicle                  │ Max Amount   │ Max Matur │ Credit Req │
  ├───────────────────────────┼──────────────┼───────────┼────────────┤
  │ Money Market Funds        │ $20M         │ Overnight │ Prime      │
  │ Treasury Bills            │ $15M         │ 6 months  │ US Gov     │
  │ Certificate of Deposit    │ $10M         │ 12 months │ AA+        │
  │ Commercial Paper          │ $5M          │ 3 months  │ A-1/P-1    │
  │ Bank deposits             │ Per FDIC lim │ Demand    │ FDIC ins.  │
  └───────────────────────────┴──────────────┴───────────┴────────────┘

Current Investment Portfolio:
  Money market fund: $8,200,000 @ 4.85% APY
  3-month T-bills: $5,000,000 @ 4.92% APY
  Operating cash: $28,900,000 (uninvested, in operating accounts)
  
Annual yield on invested cash: ~$596K
  vs. operating account yield (~0.01%): ~$473K
  Opportunity cost of idle operating cash: ~$137K
  
Recommendation: Increase sweep threshold — invest amounts >$5M/day
  in operating accounts into money market fund

Output

Treasury Dashboard View

TREASURY DASHBOARD — Jan 27, 2025
══════════════════════════════════════

Cash Position:
  Total cash: $42.1M           Available: $41.8M
  Invested: $13.2M             Operating: $28.9M
  Restricted: $1.5M            Min target: $15.0M
  
Liquidity:
  Runway: 13.2 months          Revolver available: $25M
  Weekly burn (avg): $3.2M     Status: ✓ Comfortable

Debt:
  Total debt: $24.6M           Net debt: $17.5M
  Debt/EBITDA: 0.82x           Covenant compliance: ✓ All pass
  Next payment: Mar 1 ($250K)  Interest rate: 6.3%

Cash Flow (13-Week):
  Net inflow (13 weeks): +$9.3M
  Lowest projected balance: $42.9M (Week 1)
  Highest: $51.6M (Week 12)
  Cash flow risk: LOW

FX:
  Net exposure: $6.5M (EUR + JPY)
  Hedged: €2.0M forward (matures Jun 2025)
  Unhedged exposure: $4.5M
  Next hedge review: Feb 15

Working Capital:
  DSO: 43 days (↑ vs budget)   DPO: 52 days
  DIO: 18 days                 CCC: 9 days
  Priority action: Reduce DSO to 38 days

Investments:
  Portfolio: $13.2M            Weighted yield: 4.87%
  Annual income: ~$596K        Recommendation: Sweep idle cash

Integration Points

Edge Cases