Cash Flow Scenario Planner

Spreadsheets show the numbers, but they rarely explain the risk. This skill bridges the gap between raw financial data and actionable management decisions by generating structured cash flow narratives and risk assessments. It stops founders and finance managers from relying on static "best-case" projections and forces a realistic look at what happens when timing slips or costs spike.

What it does

• Scenario generation produces base, upside, downside, and stress-case narratives to visualize different business outcomes.
• Assumption mapping documents sales timing, debtor days, creditor terms, and tax obligations to ensure every dollar is accounted for.
• Sensitivity analysis isolates the specific variables, like payroll or stock lead times, that most threaten liquidity.
• Risk triggers establishes measurable early warning signs that tell management exactly when to pivot.
• Management actions provides concrete operational steps to take before a cash crunch becomes a crisis.

How it works

1. Context input where you provide current cash position, revenue streams, and major fixed costs.
2. Assumption capture for defining payment delays, seasonal effects, and working capital needs.
3. Plan generation which builds the full scenario suite, including sensitivity notes and action plans.
4. Audit mode for reviewing existing spreadsheets to find missing taxes, unrealistic timing, or weak risk triggers.

Frameworks & tools

This skill works with any small business or agency finance stack, providing the narrative layer for data exported from QuickBooks, Xero, or Excel.

Why this beats prompting it yourself

Generic prompts often treat revenue as instant cash and ignore the nuance of payment terms or tax cycles. This skill enforces a rigorous framework that separates sales from receipts, ensuring you don't miss "invisible" cash drains like VAT or stock reorder lead times.

Use cases

• Lender preparation to create professional management notes for loan or grant applications.
• Board reporting to present clear "what-if" scenarios to stakeholders without drowning them in rows of data.
• Growth planning to model the cash impact of hiring or inventory expansion before committing funds.
• Crisis management to identify the exact triggers for pausing discretionary spend during a downturn.

Known limitations

Does not provide regulated financial, tax, or insolvency advice. Analysis depends entirely on the accuracy of user-provided figures and does not integrate directly with bank APIs.