{{organization_name}}
Organization Name
Example: Example: Apex Subscription Services
Enter the organization or business unit being forecast.
Ready to Use
Complete Prompt
This prompt has variables that can be replaced with your own information. Copy and use it with your preferred LLM, or try it out in the LearnerBox Prompt Playground.
Act as a senior FP&A analyst specializing in driver-based revenue forecasting.
Build a multi-scenario revenue forecast using the information provided below.
Organization:
{{organization_name}}
Industry and business model:
{{business_model}}
Forecast horizon:
{{forecast_horizon}}
Historical revenue and volume data:
{{historical_data}}
Revenue drivers:
{{revenue_drivers}}
Capacity and operational constraints:
{{capacity_constraints}}
Market and customer assumptions:
{{market_assumptions}}
Analysis requirements:
1. Define the revenue equation for each product, service, geography, channel, or customer segment.
2. Separate revenue effects into:
- volume;
- price;
- mix;
- new customers;
- churn or retention;
- capacity;
- utilization;
- seasonality;
- foreign exchange;
- acquisitions or disposals; and
- one-time items.
3. Build at least three scenarios:
- downside;
- base case; and
- upside.
4. For each scenario, specify:
- assumptions;
- probability or management confidence, if supplied;
- monthly or quarterly revenue;
- volume;
- average price;
- mix;
- capacity utilization;
- customer movements; and
- key risks.
5. Reconcile the forecast with historical trends and explain material departures.
6. Identify leading indicators that should be monitored to update the forecast.
7. Conduct sensitivity analysis on the most important drivers.
8. Highlight forecast points where capacity, supply, staffing, or working capital becomes a constraint.
9. Separate controllable drivers from external drivers.
10. Identify data gaps and assumptions requiring commercial or operational validation.
11. Do not invent market growth, customer behavior, prices, conversion rates, or probabilities.
12. Present calculations transparently so the model can be reproduced in a spreadsheet.
Present the result as:
{{output_format}}
Include:
- revenue-driver map;
- forecast assumptions table;
- historical baseline;
- downside, base, and upside forecasts;
- volume-price-mix bridge;
- sensitivity analysis;
- capacity and constraint review;
- leading-indicator dashboard;
- risk and opportunity register;
- validation questions; and
- forecast update recommendations.Customization Variables
Replace each variable shown in double curly brackets with accurate information from your own professional context.
{{business_model}}
Industry and Business Model
Example: Example: B2B software subscriptions with annual contracts and usage-based add-ons.
Describe how the business earns revenue and the main revenue streams.
{{forecast_horizon}}
Forecast Horizon
Example: Example: Monthly forecast for the next 24 months
State the period and frequency required.
{{historical_data}}
Historical Revenue and Volume Data
Example: Paste revenue, units, price, customers, churn, utilization, and mix by period.
Use sufficiently detailed historical data to establish a credible baseline.
{{revenue_drivers}}
Revenue Drivers
Example: List volume, price, mix, customers, conversion, retention, utilization, and channel drivers.
Identify the measurable variables that directly create revenue.
{{capacity_constraints}}
Capacity and Operational Constraints
Example: Describe production capacity, staffing, supply, inventory, service capacity, and lead times.
Constraints prevent unrealistic growth assumptions.
{{market_assumptions}}
Market and Customer Assumptions
Example: Provide supplied assumptions about demand, competition, customer wins, churn, and market conditions.
Only include assumptions supported by internal planning or reliable external evidence.
{{output_format}}
Output Format
Choose the format needed for model building, review, or presentation.
Expected Output
A transparent multi-scenario revenue forecast containing driver equations, assumptions, historical baselines, scenario tables, sensitivities, capacity constraints, leading indicators, and validation questions.
💡 Important:
The quality of the result depends on the
completeness, accuracy, and relevance of the
information supplied to the AI.
Prompt Characteristics
These characteristics describe the type of thinking, customization, and output structure involved in using this prompt effectively.
Prompt Anatomy
This breakdown explains how the prompt’s major components work together to guide the AI toward a useful, reliable, and well-structured response.
Role
Positions the AI as a senior FP&A analyst specializing in revenue forecasting.
Context
Provides the business model, historical data, drivers, capacity, market assumptions, and horizon.
Task
Requires a reproducible multi-scenario revenue forecast with transparent driver logic.
Constraints
Prevents invented growth rates, customer behavior, prices, probabilities, and unconstrained forecasts.
Output Structure
Requires driver maps, scenario tables, bridges, sensitivity analysis, risks, and update indicators.
Input Variables
Organization, business model, forecast horizon, historical data, drivers, constraints, market assumptions, and output format.
Customization Tips
- Forecast at the lowest useful level, such as product, region, customer type, or channel.
- Separate price, volume, and mix so management can understand the source of change.
- Provide capacity and staffing limits to prevent unconstrained upside scenarios.
- Use leading indicators such as pipeline, bookings, conversion, utilization, or churn.
- Ask for formulas and spreadsheet logic when the forecast will be implemented in Excel or another planning tool.
Responsible Professional Use
Review Before Applying the Output
AI-generated responses can contain errors, omissions, unsupported assumptions, outdated information, or recommendations that do not reflect your jurisdiction or professional context.
Verify calculations, evidence, regulations, standards, policies, and professional recommendations before relying on the result. The qualified professional remains responsible for the final decision.