name: cash-flow-forecaster
description: Daily, weekly, and monthly cash forecasting skill with scenario analysis and liquidity stress testing
allowed-tools:
- Read
- Write
- Glob
- Grep
- Bash
metadata:
specialization: finance-accounting
domain: business
category: treasury
priority: medium
graph:
domains: [domain:finance]
specializations: [specialization:corporate-finance]
skillAreas: [skill-area:financial-modeling, skill-area:budgeting-forecasting, skill-area:investment-analysis, skill-area:valuation-analysis]
workflows: [workflow:financial-planning, workflow:budget-planning]
roles: [role:financial-analyst]
Cash Flow Forecaster
Overview
The Cash Flow Forecaster skill provides comprehensive cash forecasting capabilities across multiple time horizons. It enables liquidity planning, stress testing, and working capital optimization through scenario-based analysis.
Capabilities
Direct Method Cash Forecasting
- Cash receipts projection
- Cash disbursements estimation
- Payroll timing
- Tax payment scheduling
- Debt service timing
- Capital expenditure planning
Indirect Method Reconciliation
- Net income to cash flow bridge
- Non-cash item adjustments
- Working capital changes
- Accrual to cash conversion
- Deferred item treatment
- Cross-check validation
Working Capital Optimization Modeling
- Days sales outstanding targets
- Days payable outstanding optimization
- Inventory turnover improvement
- Cash conversion cycle analysis
- Payment term negotiation impact
- Early payment discount analysis
Liquidity Stress Scenarios
- Revenue decline scenarios
- Customer concentration risk
- Supply chain disruption
- Credit facility unavailability
- Rapid growth requirements
- Economic downturn modeling
Bank Balance Aggregation
- Multi-bank connectivity
- Currency position consolidation
- Sweep account integration
- Concentration account tracking
- Notional pooling support
- Zero balance account management
Cash Position Optimization
- Surplus investment strategies
- Deficit coverage planning
- Intercompany funding
- FX exposure netting
- Cash pool balancing
- Target balance maintenance
Usage
Short-Term Forecast (Daily/Weekly)
Input: Bank balances, expected receipts, planned disbursements
Process: Build detailed cash flow by day/week
Output: Daily cash position, funding requirements, investment opportunities
Long-Term Forecast (Monthly/Quarterly)
Input: Budget, working capital assumptions, capital plans
Process: Project cash flows, identify liquidity needs
Output: Liquidity forecast, covenant compliance projection, funding plan
Integration
Used By Processes
- Cash Flow Forecasting and Liquidity Management
- Debt Facility Management and Covenant Compliance
- Annual Budget Development
Tools and Libraries
- Treasury management system APIs
- Kyriba
- GTreasury
- Bank connectivity platforms
Best Practices
- Reconcile forecast to actual regularly
- Measure and improve forecast accuracy
- Build bottom-up forecasts from operating units
- Maintain multiple scenario overlays
- Establish liquidity thresholds and triggers
- Integrate with FP&A processes