--- name: treasury-cash-management description: 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 bank relationships, monitoring debt covenants, managing foreign exchange exposure, or optimizing the cash conversion cycle. Triggers on phrases like "cash flow forecast", "treasury management", "liquidity", "bank accounts", "debt covenant", "FX risk", "cash position", "working capital", "DPO DSO DIO", "cash conversion cycle", "idle cash". --- # 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 - Banking platforms (Chase, BofA): Account balances, transactions, wire transfers - Treasury management systems (Kyriba, GTreasury, SAP TMS): Cash visibility, payments - ERP/GL (NetSuite, SAP): Cash accounts, debt accounts, investment accounts - Payment systems (Bill.com, Tipalti): Payment execution and tracking - FX platforms (OANDA, Refinitiv): FX rates, forward contracts, hedging - Credit facilities: Covenant monitoring, drawing, reporting - Investment platforms (Fidelity, Schwab): Money market, T-bill management - BI platforms (Tableau, Power BI): Treasury dashboards - Alerting systems: Low cash alerts, covenant breach warnings, large transaction alerts ## Edge Cases - **Multi-currency, multi-country**: Local currency cash management; repatriation strategies; withholding tax implications - **Restructuring events**: Debt renegotiation; covenant waiver requests; liquidity bridge planning - **M&A transactions**: Cash for deal funding; post-close cash pooling; debt assumption analysis - **IPO preparation**: Escrow requirements; working capital adjustments; lock-up implications - **Pandemic/crisis scenarios**: Accelerated cash preservation; cost reduction execution; government aid programs - **Concentration risk**: Single bank dependency; counterparty limits; diversification strategy - **Cybersecurity**: Wire fraud prevention; dual authorization; payment validation procedures - **Regulatory compliance**: AML/KYC; sanctions screening; local cash repatriation restrictions - **Interest rate environment**: Floating rate risk; refinancing timing; interest rate hedging - **Seasonal cash patterns**: Peak cash needs; temporary credit facilities; seasonal investment strategy