Revenue Forecasting Model Builder
Build a structured revenue forecast with multiple scenarios, key assumptions, and sensitivity analysis to predict and plan for future growth.
Prompt Template
You are a financial analyst specializing in revenue forecasting. Help me build a revenue forecast model for: Business type: [SaaS / e-commerce / marketplace / subscription / services] Current MRR or monthly revenue: $[amount] Growth rate (recent): [% month-over-month or year-over-year] Revenue streams: [list each stream — subscriptions, one-time, usage-based, etc.] Pricing tiers: [list pricing structure] Customer count: [total active customers] Churn rate: [monthly or annual %] Average revenue per customer (ARPC): $[amount] Sales cycle length: [average days to close] Forecast period: [6 months / 12 months / 3 years] Key upcoming changes: [price increase, new product launch, market expansion, hiring] Provide: 1. **Assumptions table** — every assumption behind the forecast, clearly stated and adjustable 2. **Base case forecast** — month-by-month revenue projection with growth drivers 3. **Optimistic scenario** (+20-30% above base) — what needs to go right 4. **Pessimistic scenario** (-20-30% below base) — what could go wrong 5. **Revenue waterfall** — new MRR + expansion - churn - contraction = net new MRR per month 6. **Sensitivity analysis** — how the forecast changes when you adjust churn, growth rate, or ARPC by ±10-20% 7. **Leading indicators** — 5 metrics to track weekly that predict whether you'll hit the forecast 8. **Risks and contingencies** — what would break the forecast and what to do about it
Example Output
12-Month Revenue Forecast — Flowdesk (SaaS)
Key Assumptions
| Assumption | Value | Source |
|-----------|-------|--------|
| Starting MRR | $42,000 | Current month |
| Monthly new customers | 35 → growing 8%/mo | Last 6-month avg |
| Churn rate | 4.2% monthly | Trailing 90-day |
| ARPC (new) | $89/mo | Current pricing |
| Expansion rate | 3% of existing MRR/mo | Based on upsell data |
| Price increase in Month 6 | +15% on new customers | Planned |
Base Case Forecast
| Month | New MRR | Expansion | Churn | Net New | Total MRR |
|-------|---------|-----------|-------|---------|----------|
| 1 | $3,115 | $1,260 | -$1,764 | $2,611 | $44,611 |
| 2 | $3,364 | $1,338 | -$1,874 | $2,828 | $47,439 |
| 3 | $3,633 | $1,423 | -$1,992 | $3,064 | $50,503 |
| ... | | | | | |
| 12 | $6,780 | $2,890 | -$3,290 | $6,380 | $91,200 |
**Year-end ARR:** $1,094,400 (from $504,000 starting → 117% growth)
Sensitivity Analysis
| Variable | -20% Change | Impact on Month 12 MRR |
|----------|-------------|------------------------|
| Churn rate (4.2% → 5.0%) | | -$8,400 MRR (-9.2%) |
| New customer growth (8% → 6.4%) | | -$5,200 MRR (-5.7%) |
| ARPC ($89 → $71) | | -$6,100 MRR (-6.7%) |
**Key insight:** Churn is the most sensitive variable — a 0.8% increase in monthly churn costs more than losing 20% of new customer growth. Retention is your highest-leverage investment.
Leading Indicators to Track Weekly
1. Pipeline value (predicts new MRR 30-60 days out)
2. Trial-to-paid conversion rate
3. Feature adoption in first 14 days (predicts churn)
4. Support ticket volume trend (early warning for churn spike)
5. Expansion conversations initiated by CS team
Tips for Best Results
- 💡State every assumption explicitly — a forecast is only as good as its assumptions, and unstated assumptions are the ones that break you
- 💡Run the pessimistic scenario first — if you can survive it, the base case becomes a comfortable plan instead of a hope
- 💡Update the forecast monthly with actuals — the gap between forecast and reality is where all the learning happens
Related Prompts
Cohort Retention Analysis Explainer
Interpret your cohort retention data to understand user behavior, identify drop-off patterns, and improve retention strategies.
Dataset Summary and Insights
Paste or describe a dataset and get an instant summary of key statistics, patterns, anomalies, and actionable insights.
SQL Query Writer for Business Reports
Generate SQL queries for common business reporting needs — revenue trends, cohort analysis, funnel metrics, and more.