Back to Prompt Library
Business
BusinessFinanceStrategy

Financial 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.

Recommended Tools

How to use this prompt

  1. Copy the prompt template using the button above.
  2. Paste it into your preferred AI assistant (ChatGPT, Claude, Gemini, etc.).
  3. Replace all bracketed placeholders like [TOPIC] with your specific details.
  4. Send the prompt and refine the output as needed.
Advertisement