--- name: cash-flow-forecasting description: Predict daily, weekly, and monthly cash inflows and outflows to optimize liquidity and inform financing decisions. Use when building cash flow forecasts, monitoring liquidity positions, projecting cash needs for operations, planning debt draws or repayments, or preparing cash position reports. Triggers on phrases like "cash flow forecast", "cash projection", "liquidity forecast", "13-week cash", "cash runway", "cash position", "cash outlook", "daily cash", "cash needs", "treasury forecast". --- # Cash Flow Forecasting Predict cash movements with precision to optimize liquidity, avoid shortfalls, and inform strategic financial decisions. ## Workflow ### Multi-Horizon Cash Forecasting Trigger: Daily for short-term (13-week), monthly for medium-term (12-month), quarterly for long-term (24-month): 1. **Short-term forecast (13-week rolling)**: Daily granularity weeks 1–4; weekly weeks 5–13; incorporate confirmed receipts, scheduled payments, AR collections (by aging), AP payments (by due date), payroll, tax deposits. 2. **Medium-term forecast (12-month monthly)**: Revenue cash inflows, operating expense outflows, capex plans, debt service, seasonal patterns, working capital changes. 3. **AR collection modeling**: Current aging by customer × historical payment behavior + known issues + seasonal patterns + ML refinement. 4. **AP payment projection**: Invoice queue with due dates, scheduled payments, expected new spend, term optimization, early payment discount capture. 5. **Operating cash flow drivers**: Payroll dates/amounts, rent, subscriptions, insurance, professional services — all mapped to specific payment dates. 6. **Investing/financing activities**: Capex by month, M&A, debt drawdown/repayment, equity raises, dividends. 7. **Scenario modeling**: Base case, stress case (delayed collections + accelerated payments), upside case, event-driven scenarios. 8. **Liquidity monitoring**: Minimum cash threshold alerts, credit facility tracking, early warning (14+ days out), emergency alert (< 7 days). ### Cash Forecast Calendar ``` CASH FORECAST MAINTENANCE SCHEDULE ==================================== Daily (Monday–Friday): 08:00 AM: Treasury pulls overnight bank balances via SWIFT/bank feed 08:30 AM: Update 13-week forecast with overnight transactions 09:00 AM: Check against minimum cash threshold; flag any breaches 09:30 AM: Review next 72-hour payment queue; confirm/defer as needed 04:00 PM: End-of-day cash position reported to CFO (brief email/SMS) Frequency: Every business day Owner: Treasury Analyst / Cash Manager Weekly (Every Monday): 09:00 AM: Weekly cash review meeting (Treasury, FP&A, Controller — 30 min) Agenda: - Prior week actual vs. forecast variance - Next week's major cash movements (>$50K items) - AR collection status (top 10 overdue accounts) - AP payment schedule confirmation - Credit facility utilization and covenant compliance 11:00 AM: 13-week forecast refreshed and published 03:00 PM: Cash position email to CFO and CEO (1-page summary) Owner: Treasurer / VP Finance Monthly (First week of month): Day 1–3: Full cash forecast recalculation with latest data Day 4: 12-month cash forecast updated monthly Day 5: Cash forecast presented to leadership team Day 6: Variance analysis completed (actual vs. forecast by category) Day 7: Cash forecast accuracy measured and improvement actions logged Owner: CFO / Treasurer Quarterly: Board cash report: Liquidity position, credit facilities, runway Scenario refresh: Update stress case assumptions Covenant testing: Formal compliance testing with documentation Long-term forecast: 24-month cash outlook for strategic planning Owner: CFO / VP Finance ``` ## Cash Inflow Forecasting ### AR Collection Modeling ``` AR COLLECTION FORECAST MODEL ============================== Method 1: Aging-Based Collection Pattern Apply historical collection percentages to current aging buckets: Current AR Aging Snapshot: Current (0–30 days): $12.5M → Expected collection: 85% = $10.6M 31–60 days: $3.2M → Expected collection: 60% = $1.9M 61–90 days: $1.8M → Expected collection: 35% = $0.6M 91–120 days: $0.7M → Expected collection: 15% = $0.1M 121+ days: $0.4M → Expected collection: 5% = $0.02M ────────────────────────────────────────────────────── Total Expected Collections: $13.2M Historical collection rates by bucket (average over past 12 months): Current: 80–90% collected within 30 days 31–60: 55–65% collected within 30 days 61–90: 25–40% collected within 30 days 91–120: 10–20% collected within 30 days 121+: 2–8% collected within 30 days Method 2: Customer-Specific Forecasting For top 20 customers (typically 60–80% of AR): - Track each customer's payment pattern individually - Example: Enterprise Corp — always pays Net 45, on time (95% of time) → Invoice dated Jan 15 → Expected payment Feb 29 - Example: SMB Account — typically pays 10 days late → Invoice dated Jan 15 (Net 30) → Expected payment Feb 24 - Example: Problem Account — inconsistent, averages Net 60 → Invoice dated Jan 15 (Net 30) → Expected payment Mar 16 Method 3: ML-Based Collection Prediction - Train model on 24+ months of invoice/payment data - Features: customer segment, invoice amount, seasonality, payment history, relationship length - Output: Probability distribution of payment date for each invoice - Accuracy: Typically 85–92% for payment date within ±5 days - Update frequency: Monthly retraining with latest data Key adjustments: - Known customer issues: Flagged in collections system (dispute, financial distress) - Seasonal patterns: Year-end slowdown (December collections 15–25% below average) - Economic factors: Rising interest rates → tighter customer cash → longer DSO - Contract changes: New payment terms, early payment discounts, factoring agreements ``` ### Non-AR Cash Inflows ``` OTHER CASH INFLOW CATEGORIES ============================== Customer Prepayments / Deposits: - SaaS annual prepaid: Recognized over 12 months but cash received upfront - Construction milestone advances: 10–30% of project value - Subscription renewals: 60–80% collected before expiration - Forecast: Track renewal calendar and prepaid invoice schedule Interest Income: - Cash account interest: 4.5–5.0% (money market, 2024–2025 rates) - Short-term investments: 4.0–5.0% (T-bills, commercial paper) - Calculation: Daily average cash balance × daily interest rate - Impact: $50M cash × 4.5% = $2.25M annual interest income Tax Refunds: - Federal/state income tax refunds: Based on prior year returns (filed by Apr 15) - VAT/GST refunds: Monthly or quarterly based on filings - Estimated timing: 60–120 days from filing - Forecast: Track filing calendar and historical refund timing Insurance Recoveries: - Property/business interruption claims: Negotiation timeline 3–12 months - D&O/Professional liability: Defense cost advances - Forecast: Based on claim status and adjuster estimates Other: - Asset sales: Equipment, property, intellectual property - Investment exits: Sale of minority stakes, fund distributions - Government grants: R&D credits, energy incentives, local incentives - Litigation settlements: Track case status and expected resolution ``` ## Cash Outflow Forecasting ### AP Payment Forecasting ``` AP PAYMENT FORECAST MODEL =========================== Method: Invoice Queue + Expected New Spend Current Invoice Queue (by due date): Due this week: $1.2M (12 invoices, 95% confirmed) Due next week: $0.8M (8 invoices, 90% confirmed) Due week 3: $1.5M (15 invoices, 85% confirmed) Due week 4: $1.1M (10 invoices, 80% confirmed) Due weeks 5–8: $3.2M (25 invoices, 75% confirmed) Due weeks 9–13: $2.8M (20 invoices, 70% confirmed) Expected New Spend (monthly run-rate): Cloud infrastructure: $250K/month (AWS, Azure, GCP — auto-pay) Software licenses: $100K/month (SaaS subscriptions — annual prepay) Professional services: $150K/month (consulting, legal — variable) Marketing: $200K/month (agencies, ad spend — monthly) Travel: $50K/month (variable, typically 50% below budget) Office/facilities: $80K/month (lease, utilities — fixed) ────────────────────────────────────────────────────── Monthly new spend: $830K (spread across payment terms) Payment term optimization: Net 30 vendors: Pay on day 28–30 (maximize cash retention) Net 60 vendors: Pay on day 55–60 (maximize cash retention) 2/10 Net 30: Evaluate — if ROI > cost of capital, pay early Example: $100K invoice, 2% discount = $2K savings for 20-day early payment Annualized return: ~37% — worth taking if cash available Critical vendors: Maintain relationship — never miss payment Non-critical: Can negotiate extended terms during review ``` ### Payroll and Tax Cash Outflows ``` PAYROLL CASH FORECAST ======================= Payroll Schedule: Bi-weekly: Every other Friday (26 pay periods/year) Semi-monthly: 15th and last day of month (24 pay periods/year) Monthly: Last business day (12 pay periods/year) Per-Pay-Period Components: Gross payroll: $X.XX M Employer payroll taxes: $0.XX M (7.65% FICA + SUTA/FUTA) Employer benefits loading: $0.XX M (health insurance, 401k match) Contractor payments: $0.XX M (1099 contractors) ─────────────────────────────────────────── Total cash outflow: $X.XX M Annual payroll calendar: Q1: $X.XXM (13% of annual — includes Q4 bonus payout) Q2: $X.XXM (12% of annual) Q3: $X.XXM (12% of annual) Q4: $X.XXM (12% of annual — includes annual merit increases effective Q4) Key variables: New hires: Add $X.XK/period per new hire (pro-rated) Terminations: Subtract last-period proportion Merit increases: Typically effective Jan or Jul (+$X.XXM annual) Bonus pools: Q4 payout $X.XXM (30–60 days after year-end close) Overtime: Variable 5–15% above base (manufacturing, operations) Tax deposit schedule: Federal payroll taxes (Form 941): Quarterly (Apr 30, Jul 31, Oct 31, Jan 31) Monthly depositers: Pay withheld taxes by 15th of following month Quarterly depositers: Deposit with return (if < $50K quarterly liability) Estimated income tax: Quarterly (Apr 15, Jun 15, Sep 15, Jan 15) Sales tax: Monthly or quarterly by state (varies by jurisdiction) ``` ## Scenario Modeling ### Cash Stress Testing ``` CASH STRESS SCENARIOS ====================== Scenario 1: Collections Delay (Moderate Stress) Assumptions: - DSO increases from 45 days to 60 days (+33%) - Cash inflows delayed by 15 days on average - Collections volume unchanged (eventually collected) Impact: - Weekly cash inflow reduced by 20–30% - Cumulative shortfall over 13 weeks: -$X.XM - Cash balance impact: -$X.XM at peak - Runway impact: -1–2 months Mitigation: - Extend AP by 10–15 days (temporary) - Defer non-essential capex - Activate factoring for top customer invoices - Draw on credit facility if needed Scenario 2: Revenue Shock (Severe Stress) Assumptions: - Key customer lost (10% of revenue) - Sales cycle extends 50% (new logos delayed) - Expansion revenue pauses (existing customers reduce spend) Impact: - Revenue decline: 15–25% in affected quarter - Cash impact: -$X.XM over 2 quarters (cumulative) - Runway impact: -3–5 months - Breakeven analysis: New burn rate = $X.XM/month Mitigation: - Activate Tier 1 cost cuts (10% opex reduction = $X.XM annual) - Activate Tier 2 cost cuts (additional 15% = $X.XM annual) - Hiring freeze (saves $X.XM in deferred headcount) - Negotiate vendor payment extensions (30–60 days) - Emergency fundraising (target close within 60 days) - Board notification within 48 hours Scenario 3: Payment Acceleration (Liquidity Crunch) Assumptions: - Major vendor demands early payment (contract clause) - Debt covenant requires principal prepayment - Lease termination penalties triggered Impact: - Immediate cash outflow spike: $X.XM within 30 days - Liquidity gap: -$X.XM Mitigation: - Draw on credit facility - Negotiate payment deferrals with other vendors - Accelerate AR collections (early payment discounts offered to customers) - Sale-leaseback for facilities ``` ## Cash Position Reporting ### Executive Cash Dashboard ``` EXECUTIVE CASH DASHBOARD — Updated Jan 15, 2025 ================================================== LIQUIDITY SNAPSHOT: Cash & Equivalents: $48.2M Checking accounts: $12.5M (3 accounts: Chase, BofA, Wells) Money market: $25.0M (yielding 4.5% APY) Short-term T-bills: $10.7M (maturing Feb–Apr 2025) Short-term Investments: $12.5M (commercial paper, CP) Total Liquid Assets: $60.7M Less Committed Cash: ($3.2M) (escrow, letters of credit) AVAILABLE CASH: $57.5M RUNWAY ANALYSIS: Monthly burn (normalized): $7.8M Runway at current burn: 7.4 months Runway (conservative +20%): 5.8 months Next funding trigger: At $20M cash (4.1 months from current trend) Funding readiness: Data room updated; investor list maintained 13-WEEK FORECAST: Expected min cash: $44.1M (Week 3 — AWS renewal impact) Expected max cash: $53.0M (Week 13 — seasonal collections peak) Trend: Stable with slight uptick ↑ Largest single outflow: $1.2M (AWS annual renewal, Week 3) Largest single inflow: $2.4M (Enterprise Corp payment, Week 8) CREDIT FACILITY: Revolving credit: $20.0M available (undrawn) Interest rate: SOFR + 1.50% (≈ 5.5% current) Commitment fee: 0.375% annually ($75K/year on full amount) Maturity: Dec 2027 Covenants: All compliant (leverage 1.2x vs. 3.0x max) Draw capability: Same-day (pre-authorized) DEBT OBLIGATIONS (Next 12 months): Q1 2025: $0.5M (term loan quarterly payment) Q2 2025: $0.5M (term loan quarterly payment) Q3 2025: $0.5M (term loan quarterly payment) Q4 2025: $0.5M + $5.0M balloon (term loan maturity) INVESTMENT YIELD: Cash yield (weighted avg): 4.5% Annual interest income: $2.7M on $60.7M liquid assets Idle cash optimization: $5M moved to 6-month T-bills (yielding 5.0%) RECOMMENDATIONS: 1. No immediate action required — cash position healthy 2. Consider reducing revolver to $15M to save $18.75K/year commitment fee 3. Prepare for Q4 2025 balloon payment ($5M) — refinance or set aside 4. Monitor customer concentration risk (Enterprise Corp = 15% of AR) ``` ## Edge Cases - **Seasonal businesses** (retail, tourism, agriculture): - Peak season cash build: 60–80% of annual net cash generated in 3–4 months - Trough season cash need: Fund 6–9 months of operating costs from peak build - Seasonal credit facility: Revolver sized to cover trough deficit ($X.XM) - Timing: Peak cash position typically October; trough typically March–May - Inventory cash trap: Pre-build inventory 60–90 days before peak (cash outflow before revenue) - Staffing: Temp workers paid from peak season cash; benefit loading budgeted separately - **Startup/negative cash flow**: - Burn rate: Monthly net cash outflow (fixed + variable) - Runway calculation: Current cash / monthly burn (target 18–24 months) - Monthly cash tracking: Daily balance check; weekly cash call with CFO - Trigger points: * 12-month runway: Begin fundraising conversations * 9-month runway: Submit term sheets to target investors * 6-month runway: Execute fundraising or activate cost cuts * 3-month runway: Emergency measures (massive cuts, bridge financing) - Burn rate categories: Fixed burn (salary, rent, subscriptions) vs. variable burn (sales, marketing, contractors) - Efficiency: Track burn multiple = net burn / net new ARR (target < 1.0 for investors) - **Multi-currency cash management**: - Position reporting: Daily cash balance by currency (USD, EUR, GBP, JPY, etc.) - Translation: All positions translated to reporting currency at spot rate - Netting: Intercompany netting to reduce cross-border payments (save wire fees + FX) - Repatriation: Tax-efficient methods (dividend, royalty, intercompany loan repayment) - FX risk: Unhedged foreign cash = natural hedge against foreign operations - Concentration: Target < 30% of cash in any single currency (diversification) - Banking: Local bank accounts in each operating country; central treasury in HQ currency - **M&A cash impact**: - Acquisition payment: Cash at closing ($X.XM) — typically funded by debt or existing cash - Working capital adjustment: $X.XM true-up within 45–60 days post-close - Integration spend: $X.XM over 6–12 months (IT systems, real estate, severance) - Revenue synergies: Additional cash inflow from cross-sell (Year 1: 5–15% of target revenue) - Cost synergies: Cash savings from elimination of duplicative functions (Year 1: 10–20% of target opex) - Financing: New debt service ($X.XM/year) added to cash outflow forecast - Risk: Integration delays extend cash consumption by 3–6 months - **Credit facility covenant compliance**: - Leverage ratio: Total debt / EBITDA (covenant < 3.0x; warning at 2.5x) - Interest coverage: EBITDA / interest expense (covenant > 3.0x; warning at 3.5x) - Fixed charge coverage: (EBITDA - capex) / (debt service + dividends) (covenant > 1.2x) - Minimum liquidity: Cash + revolver availability > $X.XM - Testing: Quarterly calculation with 30-day cure period for technical defaults - Cash impact: Covenant breach → lender demands immediate repayment → liquidity crisis - Mitigation: Maintain 15–25% buffer on all covenants; stress test before filing - **Cash pooling and zero-balancing** (enterprise): - Physical pooling: Actual cash movement between accounts (daily sweep) - Notional pooling: Net balance calculation without physical movement - Interest optimization: Reduce external borrowing by utilizing internal surplus - Tax consideration: Cross-border pooling may trigger withholding tax or deemed dividend - Regulatory: Some jurisdictions restrict cash pooling (China, India) - Bank fees: $1,000–$5,000/month per pooling arrangement - Benefits: Interest savings of 50–200bps; reduced bank account count; better visibility ## Integration Points - **Banking APIs**: Plaid, SWIFT gpi, bank直Connect (Fiserv), Salt Edge — real-time balance and transaction feeds - **ERP/GL**: NetSuite, SAP S/4HANA, Oracle ERP Cloud — GL actuals, AR/AP sub-ledgers, trial balance - **Treasury Management Systems**: Kyriba, SAP Treasury, FISERV Treasury, GTreasury — cash positioning, payment execution, FX - **CRM**: Salesforce — customer payment history, deal close dates, contract terms - **HRIS**: Workday, ADP — payroll schedule, amounts, tax deposits - **BI/Dashboards**: Tableau, Power BI, Looker — cash position visualization, trend analysis - **Alert Systems**: Slack, PagerDuty, Microsoft Teams — liquidity threshold alerts, threshold breach notifications - **Payment Platforms**: Stripe, Adyen, bill.com — incoming payment tracking, outgoing payment automation - **Tax Systems**: Thomson Reuters ONESOURCE, Vertex — tax payment schedules, refund tracking - **Debt Management**: Loanware, Treasurix — debt service schedule, covenant testing, amortization tracking - **Data Warehouse**: Snowflake, BigQuery — historical cash data, ML model training for collection prediction