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
Frequently Asked Questions
What is the Revenue Forecasting Model Builder prompt?
Build a structured revenue forecast with multiple scenarios, key assumptions, and sensitivity analysis to predict and plan for future growth. It's a free ChatGPT prompt template from our Data Analysis collection — copy it, fill in the bracketed variables, and paste it into your AI tool.
Which AI tools work with this prompt?
It's written and tested for ChatGPT, Claude and Gemini. Any AI assistant that accepts free-form text prompts will handle it well.
How do I customize this ChatGPT prompt?
Replace the bracketed variables — such as [amount], [% month-over-month or year-over-year], [list pricing structure] — with your own details before running it. State every assumption explicitly — a forecast is only as good as its assumptions, and unstated assumptions are the ones that break you
Is this prompt free to use?
Yes. Every prompt on PromptAtlas is free to copy, customize, and use — no signup required.
Related Prompts
Transit Fare Evasion Pattern Analysis Builder
Analyze transit fare evasion patterns with station segments, time trends, inspection data, equity safeguards, revenue estimates, and intervention testing.
Food Pantry Distribution Demand Analysis Builder
Analyze food pantry demand, visit patterns, household needs, item stockouts, volunteer coverage, and distribution-slot capacity for nonprofit food programs.
Library Hold Queue Wait Time Analysis Builder
Analyze public library hold queues, copy availability, branch demand, wait times, and purchasing signals for print, ebook, audiobook, or media collections.
Sterile Processing Instrument Tray Turnaround Analysis Builder
Analyze sterile processing instrument tray turnaround times, bottlenecks, rework, case readiness, staffing, and quality issues for hospital operations.
Clinical Lab Specimen Turnaround Time Analysis Builder
Analyze clinical lab specimen turnaround time by collection, transport, accessioning, testing, verification, priority, department, and bottleneck risk.
Municipal Permit Processing Backlog Analysis Builder
Analyze building permit intake, review stages, resubmissions, staffing, and service targets to find bottlenecks and reduce municipal permit backlogs.