Cash Flow Forecasting & Liquidity Optimization
Build multi-scenario cash flow forecasts with daily precision for strategic liquidity planning
What You Can Do
Transform 12-18 months of historical cash data into probabilistic forecasts across three scenarios (base, bull, bear) with daily resolution. You'll identify seasonal patterns, cash flow drivers, and working capital dynamics to anticipate funding needs, stress-test liquidity against worst-case scenarios, and present defensible assumptions to CFOs, boards, and credit rating agencies.
Features
Extract seasonal trends, cyclical patterns, and one-time events from 12-18 months of transaction data to identify reliable cash flow drivers
Build base case (expected), bull case (optimistic), and bear case (pessimistic) 13-week rolling forecasts with documented assumptions for each scenario
Generate day-by-day cash position projections that capture payroll cycles, receivables timing, and vendor payment windows for operational precision
Compare forecast versus actuals to identify root causes of cash flow misses and refine forward-looking assumptions
Model covenant breach scenarios, delayed receivables, and supply chain disruptions to quantify downside cash needs and funding requirements
Analyze DPO (days payable outstanding), DSO (days sales outstanding), and inventory cycles to identify levers for cash position improvement
Generate audit-ready summary of all forecast drivers, adjustments, and sensitivities for CFO/board presentations and credit rating agencies
Calculate minimum liquidity buffer, credit facility draw triggers, and optimal capital deployment windows based on forecast outcomes
Example Output
Base Case Forecast Summary (13-week rolling)
- Week 1-4 average daily cash position: $4.2M
- Week 5-9 trough (seasonal payables peak): $1.8M
- Week 10-13 recovery: $3.5M
- Recommended minimum liquidity buffer: $2.5M
Key Drivers Identified:
- Receivables: $2.1M inflows every 15 days (net 45 payment terms)
- Payroll: $1.2M weekly outflow, peaks second Friday
- Vendor payments: $850K average, concentrated on net-30 terms
Bear Case Scenario (30-day receivables delay)
- Cumulative cash shortfall: $3.8M over 6-week period
- Recommended credit facility draw: $4.5M (includes 15% safety margin)
- Recovery timeline: 4 weeks post-receipt normalization
Bull Case Scenario (accelerated collections, extended payables)
- Peak cash position: $6.2M (week 8)
- Optimal deployment window: weeks 7-9 for capex or debt repayment
What's Included
- SKILL.md instruction file with complete workflow (data prep, pattern recognition, scenario building, stress-testing framework):
- Cash Flow Analysis Template: Data intake structure for 12-18 months of transaction history with data quality checklist
- Scenario Assumption Tracker: Spreadsheet template documenting base/bull/bear case assumptions, sensitivities, and variance drivers
- Covenant Stress Test Framework: Workings for modeling debt covenant breach scenarios and liquidity buffer requirements
- 13-Week Rolling Forecast Checklist: Weekly update process, variance reconciliation steps, and presentation-ready output formats
Who It's For
- Treasury analysts and cash managers optimizing daily liquidity positions and funding decisions
- CFOs preparing cash flow outlooks for board reporting, credit rating agencies, and lender covenant compliance
- Working capital managers analyzing receivables and payables cycles to improve cash conversion efficiency
- FP&A analysts stress-testing financial models against operational and market disruption scenarios
- Credit and corporate development teams assessing liquidity headroom for M&A, capex, or debt refinancing decisions
Best For
- Building rolling 13-week cash forecasts when you have 6+ months of reliable transaction data
- Analyzing seasonal patterns before major funding cycles, capital deployments, or quarterly reforecasting
- Stress-testing liquidity against worst-case scenarios (supply chain disruption, delayed receivables, covenant pressure)
- Reconciling forecast vs. actuals variance to refine cash flow drivers and improve forward accuracy
- Presenting liquidity outlook to executive stakeholders with audit-ready assumptions and risk sensitivities
You might also like
You'll construct defensible, driver-based revenue forecasts that link operational metrics (customer count, contract value, churn, win rates) directly to revenue outcomes. Claude helps you build base, upside, and downside scenarios with transparent assumptions, perform sensitivity analysis to quantify business variable impacts, and automatically document variance explanations—enabling you to respond confidently to CFO and board-level scrutiny.
by fastclaw-ai
You systematically evaluate bank proposals against standardized criteria, uncovering pricing structures and covenant terms that impact your treasury strategy. The framework helps you compare commitment fees, arrangement fees, and facility structures across multiple term sheets, then generates data-backed talking points for renegotiating existing arrangements and consolidating redundant banking relationships.
by fastclaw-ai
You'll build comprehensive DCF models that automate explicit forecast periods, terminal value calculations, and weighted average cost of capital derivation. The skill produces audit-ready assumption documentation, multi-scenario sensitivity tables, and valuation ranges across bear/base/bull cases—all formatted for board presentations and fairness opinions. You'll stress-test equity value assumptions and compare DCF outputs to trading multiples and M&A precedent data.
by fastclaw-ai
You can conduct multi-scenario covenant stress testing to quantify financial headroom between current metrics and covenant thresholds, identify which covenants are most vulnerable to market downturns, and calculate the cost-benefit of proactive amendments versus reactive refinancing. This enables you to report covenant health to leadership with actionable mitigation strategies before breach risk materializes.
by fastclaw-ai
You consolidate end-of-day cash positions from multiple bank accounts, entities, and currencies into a single analytical view. The skill automatically identifies concentration risks, flags liquidity gaps, highlights timing mismatches, and surfaces rebalancing opportunities—turning hours of manual compilation into minutes of actionable intelligence. You get daily cash management reports ready for CFO or Treasury Committee review, plus specific optimization recommendations for notional pooling, sweep decisions, and excess cash deployment.
by skillslib
You can build comprehensive deal execution timelines that map interdependencies across all workstreams—legal, regulatory, financing, and operations—and automatically flag risks that could delay closing. The skill identifies which delays actually impact your close date versus minor slippage, creates decision trees for contingency scenarios, and generates stakeholder-ready reports for boards, lenders, and sponsors. You turn raw deal data into a living, weekly-updated source of truth for deal execution status.
by fastclaw-ai
You can build 12-month rolling forecast models that automatically drop the oldest completed month and add a new forward month as actuals close each period. The skill calculates budget variances (favorable/unfavorable) with root cause drivers, reforecasts remaining quarters based on current spending patterns and run-rate assumptions, and generates executive dashboards highlighting key budget risks and opportunities before they become serious overruns.
by fastclaw-ai
Create a structured one-page business model that captures your core value proposition, revenue model, and key partnerships. You will define your riskiest assumptions, design an MVP with prioritized features, and build a customer discovery roadmap with interview templates and validation experiments. This approach helps you move from theory to validated learning before investing significant resources.
by fastclaw-ai