aaronQuick win: Framing best- and worst-case revenue scenarios is exactly the right place to apply AI — it turns messy assumptions into clear, testable projections you can act on.
The problem: Most small businesses either guess revenue or spend days building spreadsheets that don’t reflect uncertainty. That leads to bad decisions on hiring, marketing, and cash.
Why it matters: Know the range of possible outcomes, the drivers that move the needle, and the probabilities. That gives you predictable runway, prioritised investments, and clear KPIs tied to cash.
What I’ve learned: Simple, repeatable scenario models beat complex, fragile forecasts. Use AI to structure assumptions, generate scenarios, and translate them into monthly revenue curves you can track.
What you’ll need:
- Last 12 months of revenue by month (CSV or spreadsheet)
- Top-line assumptions: conversion rate, traffic, average order value (AOV), churn, CAC
- A spreadsheet (Excel or Google Sheets)
- Access to an AI assistant (ChatGPT or similar)
Step-by-step (do this):
- Collect: export monthly revenue and units for last 12 months.
- Define drivers: list 5 inputs that most affect revenue (traffic, conv%, AOV, churn, pricing).
- Use the AI prompt below to generate three scenarios (worst/base/best) with monthly revenue for 12–36 months, and include probability weights and sensitivity notes.
- Paste outputs into your spreadsheet. Add formulas to calculate cash burn, cumulative revenue, and runway.
- Validate: compare month 1–3 with actuals; ask AI to revise assumptions where variance >10%.
Copy-paste AI prompt (primary):
“I will give you monthly revenue for the last 12 months and five key inputs: traffic, conversion rate, average order value, churn rate, customer acquisition cost. Create three scenarios (worst, base, best) for the next 24 months. For each scenario provide: monthly revenue, monthly customers (or transactions), assumptions for each input, probability weight (sum to 100%), and a 3-bullet explanation of the main drivers. Format as a CSV table with columns: Month, Scenario, Revenue, Customers, Traffic, ConversionRate, AOV, Churn, CAC, Probability. Use realistic ranges and note where assumptions differ between scenarios.”
Prompt variants:
- Conservative: Ask AI to be conservative on growth and assign 60% probability to base.
- Monte Carlo-lite: Ask AI to simulate 500 runs using random draws from input ranges and return the median, 10th and 90th percentiles per month.
What to expect: A table you can paste into Sheets, plus a short narrative explaining drivers and recommended monitoring thresholds.
Metrics to track:
- Probability-weighted expected revenue (monthly)
- Worst-case revenue (10th percentile)
- Revenue variance between best/base/worst
- Customer Acquisition Cost and Payback Period
- Cash runway under worst-case
Common mistakes & fixes:
- Mistake: Garbage inputs. Fix: Use the last 12 months of real data as baseline.
- Mistake: Ignoring correlations (e.g., traffic and conversion tied). Fix: Ask AI to note correlations and adjust ranges.
- Mistake: Overconfidence in a single scenario. Fix: Use probability weights and track percentiles.
1-week action plan:
- Day 1: Export 12 months of revenue and list 5 drivers.
- Day 2: Run the primary AI prompt, paste output into Sheets.
- Day 3: Validate month 1–3 vs actuals; adjust inputs.
- Day 4: Build simple dashboard: expected revenue, worst-case, runway.
- Day 5: Identify 2 tactical moves (cut cost or boost traffic) for worst-case protection.
- Day 6: Run a sensitivity check (change conv% by ±2%) and note impact.
- Day 7: Present scenario summary and decision triggers to stakeholders.
Your move.