Revenue Forecasting Model Builder
Build a multi-scenario revenue forecast from your historical data — baseline, optimistic, and conservative — with monthly projections, assumption documentation, and sensitivity analysis. Output is investor-ready or usable for internal planning.
Pro tip
Include at least 6 months of historical monthly revenue. Adding seasonality notes and planned initiatives (new product launch, price change, marketing push) dramatically improves accuracy.
How to use this prompt
- Pick your AI model. Choose the tab for Claude, ChatGPT, Gemini or Copilot — each variant is tuned for that model.
- Copy the full prompt. Click Copy Full Prompt to copy the text to your clipboard.
- Paste into your AI tool. Open your chosen model and paste the prompt into a new chat.
- Replace the
[placeholders]. Swap any bracketed fields for your company name, audience, product or tone. - Run and refine. Review the output. If anything is off, ask the AI to tighten tone, length or format.
Prompt Variants by Model
Claude
Claude 4.x
UPDATED APR 2026
You are a financial analyst building a revenue forecast for a small business.
<historical_data>
[PASTE MONTHLY REVENUE DATA — at least 6 months, ideally...You are a financial analyst building a revenue forecast for a small business.
<historical_data>
[PASTE MONTHLY REVENUE DATA — at least 6 months, ideally 12+]
</historical_data>
<business_context>
Business type: [YOUR_BUSINESS_TYPE]
Revenue model: [subscriptions / one-time sales / retainers / mixed]
Seasonality notes: [e.g., "Q4 is 2x normal" or "summer is slow"]
Planned changes: [new product launch, price increase, marketing campaign, hiring — anything that will affect revenue]
Growth goal: [target revenue or growth rate for next 12 months]
</business_context>
Build a 12-month revenue forecast with:
1. **Methodology** — explain which forecasting approach fits my data (trend extrapolation, cohort-based, bottoms-up) and why.
2. **Three scenarios** — Conservative (what if growth slows), Baseline (current trajectory continues), Optimistic (planned initiatives succeed). Show monthly projections for each.
3. **Assumptions table** — every assumption behind each scenario, documented clearly so I can update them.
4. **Sensitivity analysis** — which 3 variables have the biggest impact on the forecast? Show what happens if each moves ±20%.
5. **Monthly tracking template** — a table I can fill in each month to compare actual vs forecast and recalibrate.
Make this usable in a spreadsheet. Use formulas I can replicate.
Notes: Claude handles complex multi-step financial analysis well with chain-of-thought. The XML tags keep historical data separate from instructions. Ask for CSV-formatted output you can paste directly into Sheets.
ChatGPT
GPT-5
UPDATED APR 2026
Act as a financial analyst who specializes in building revenue models for small businesses and startups.
I need a 12-month revenue forecast. Here is my data:
Monthly revenue history:
[PASTE...Act as a financial analyst who specializes in building revenue models for small businesses and startups.
I need a 12-month revenue forecast. Here is my data:
Monthly revenue history:
[PASTE MONTHLY REVENUE — 6+ months]
Business details:
- Type: [YOUR_BUSINESS_TYPE]
- Revenue model: [subscriptions / one-time / retainers / mixed]
- Seasonality: [e.g., "Q4 is strongest" or "summer dips"]
- Planned changes: [new product, price change, marketing spend increase, etc.]
- Growth target: [target revenue or % growth for next 12 months]
Build me:
1. Your recommended forecasting method and why it fits my data
2. Three scenarios (conservative, baseline, optimistic) with monthly projections
3. An assumptions table documenting every assumption per scenario
4. Sensitivity analysis — the 3 variables that matter most, showing ±20% impact
5. A monthly tracking table to compare actual vs forecast
Make everything spreadsheet-ready with formulas I can replicate in Google Sheets or Excel.
Notes: Use Code Interpreter to upload your revenue CSV — ChatGPT will build the model in Python and generate charts. Ask it to export as a downloadable Excel file for the most practical output.
Gemini
Gemini 3 Pro
UPDATED APR 2026
I need a revenue forecast for my small business.
**Monthly revenue history:**
[PASTE 6+ MONTHS OF DATA]
**Business type:** [YOUR_BUSINESS_TYPE]
**Revenue...I need a revenue forecast for my small business.
**Monthly revenue history:**
[PASTE 6+ MONTHS OF DATA]
**Business type:** [YOUR_BUSINESS_TYPE]
**Revenue model:** [subscriptions / one-time / retainers / mixed]
**Seasonality:** [notes on seasonal patterns]
**Planned changes:** [upcoming launches, price changes, campaigns]
**Growth target:** [revenue goal or growth % for next year]
Research current growth benchmarks for my industry, then build:
1. Recommended forecasting method with reasoning
2. Three scenarios (conservative, baseline, optimistic) — monthly projections
3. Documented assumptions table for each scenario
4. Sensitivity analysis on the 3 highest-impact variables (±20%)
5. Monthly actual-vs-forecast tracking template
Make it spreadsheet-compatible with replicable formulas.
Notes: Gemini can pull real-time industry growth benchmarks to calibrate your scenarios. If your data lives in Google Sheets, share the sheet link and ask Gemini to build the forecast directly in a new tab.
Copilot
Copilot (Microsoft 365)
UPDATED APR 2026
I need to build a 12-month revenue forecast for my small business.
Here is my monthly revenue history:
[PASTE 6+ MONTHS OF DATA]
Business type:...I need to build a 12-month revenue forecast for my small business.
Here is my monthly revenue history:
[PASTE 6+ MONTHS OF DATA]
Business type: [YOUR_BUSINESS_TYPE]
Revenue model: [subscriptions / one-time / retainers / mixed]
Seasonality: [any seasonal patterns]
Planned changes: [launches, price changes, campaigns]
Growth target: [revenue target or growth %]
Build me:
1. Which forecasting method to use and why
2. Three scenarios — conservative, baseline, optimistic — with monthly numbers
3. Assumptions table for each scenario
4. Sensitivity analysis — the 3 variables that matter most, with ±20% impact
5. Monthly tracking table to compare forecast vs actual
Format everything so I can paste it into Excel. Include formulas.
Notes: Use this directly in Excel with Copilot — paste your revenue data, then prompt Copilot in the sheet. It can build the model with live formulas, conditional formatting, and scenario toggle cells.
Frequently Asked Questions
What does the Revenue Forecasting Model Builder prompt do?
Build a multi-scenario revenue forecast from your historical data — baseline, optimistic, and conservative — with monthly projections, assumption documentation, and sensitivity analysis. Output is investor-ready or usable for internal planning.
Which AI models is this prompt tested on?
This prompt is field-tested on Claude, ChatGPT, Gemini and Copilot. Each model has its own optimized variant above.
Do I need a paid AI account to use this prompt?
No. This prompt is written to run on the free tier of Claude, ChatGPT, Gemini and Copilot. Paid tiers simply give you longer context windows and faster responses.
Can I customize this prompt for my business?
Yes. Any text inside square brackets is a placeholder you replace with your own business details, such as company name, audience, product or tone. You can also ask the AI to adjust format, length or style after the first output.
When was this prompt last verified?
Each model variant above shows its own freshness stamp. AlignAI re-verifies every prompt at least monthly and rebuilds when a major model changes.
Don’t see what you need? tailored to your use case.