Business
BusinessFinanceStrategyFinancial Scenario Planning
Builds best, base, and worst-case 12-month financial projections from your stated business assumptions.
Best For
- •Solo founders without a finance background who need runway and breakeven projections before making a hiring decision.
- •Early-stage founders preparing for investor conversations who want three defensible scenarios instead of one optimistic forecast.
- •Freelancers going full-time on their business who need to know what churn or growth rate would put their cash position at risk.
Prompt Template
You are a financial planning analyst. I'm going to describe my business model and key assumptions. Build three financial scenarios, Best Case, Base Case, and Worst Case, with monthly projections for the next 12 months.
For each scenario:
- Assumptions: what changes from base case
- Monthly P&L: revenue, COGS, gross margin, operating expenses, net income (table format, months 1-12)
- Key Milestones: when do you hit breakeven, $10K MRR, $25K MRR (or note if you don't)
- Cash Position: starting cash + monthly net = running cash balance
- Breaking Point: when does cash run out in worst case
End with:
- Sensitivity Analysis: which single variable has the biggest impact on outcomes
- Decision Triggers: "If X happens by month Y, do Z" for each scenario
My business model:
[DESCRIBE: pricing, current revenue, monthly costs, expected growth rate, churn assumptions, starting cash]
Pro Tip
State your actual current numbers and a realistic churn assumption rather than an aspirational one, since the sensitivity analysis is only useful if the base case reflects reality, not hope.
Example Output
A sample of what this prompt produces once you fill in the placeholders.
A scenario plan showing Base Case reaching $10K MRR by month 5 and $25K by month 11, with a sensitivity analysis identifying churn as the single biggest driver, noting that 15% monthly churn would plateau growth at $12K MRR versus $28K at 5% churn.
How to use this prompt
- Copy the prompt template using the button above.
- Paste it into your preferred AI assistant (ChatGPT, Claude, Gemini, etc.).
- Replace all bracketed placeholders like
[TOPIC]with your specific details. - Send the prompt and refine the output as needed.
Advertisement