Cash Flow Forecaster Skill
When to activate
When building 12–24 month cash flow projections; modeling scenarios and sensitivity to revenue/cost changes.
When NOT to use
For historical variance analysis (use budget-analyzer). For multi-year strategic modeling (use financial-modeler).
Instructions
- Establish baseline — Pull opening cash, historical cash in/outflows, and seasonal patterns.
- Build scenarios — Model base case (most likely), upside (+15–20% revenue), downside (-15–20% revenue).
- Sensitivity analysis — Show impact of ±10% revenue, ±5% cost, ±30 day AR change.
- Identify risks — Flag any scenario where cash dips below minimum operating threshold.
- Output — Waterfall chart, scenario table, sensitivity heatmap, and liquidity recommendations.
Example
Base: Revenue $100K/mo, costs $85K/mo, starting cash $500K. Upside: +20% revenue. Downside: -20% revenue. Output: [12-month cash flow projection with scenarios and liquidity runway analysis]