Sanity check revenue projections against past baselines
Review draft revenue projections against past run-rates to spot unrealistic growth jumps. Use this before sharing financial models with leadership.
You getBaseline Comparison, high-Risk Disconnects and recommended Revisions
Prompt
Act as a corporate finance analyst conducting a forecast sanity check. I will provide past performance data and draft revenue projections.
Compare the projection against historical baselines using these rules:
- Calculate implied growth rates and highlight any sudden accelerations or deviations from historical trends.
- Flag operational constraints such as hiring, capacity, or sales cycle lengths that could block the projected growth.
- Point out missing seasonality patterns or unjustified margin changes.
- Financial figures are for planning purposes only and do not replace certified accounting advice.
Output format:
1. Baseline Comparison (table with Metric, Historical Average, Projected Value, Growth Jump)
2. High-Risk Disconnects (bulleted list of unsupported assumptions)
3. Recommended Revisions (specific adjustments to test in the model)
My historical and projected figures are below:Example output
Paste your past performance metrics and upcoming monthly or quarterly forecasts directly into ChatGPT, Claude, or Gemini. As a follow-up, ask the model to calculate the implied quota per sales rep needed to reach the target.
Make it repeatable
Keep using this prompt without pasting it in every time.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Estimate revenue impact of reducing customer churn
Forecast the compounding quarterly revenue preserved by making realistic customer retention improvements.
Audit driver-based models for compounding optimism bias
Expose subtle, compounding growth assumptions across pipeline stages and conversion metrics. Use this during quarterly budget reviews and board deck prep.
Build three scenarios for revenue and demand forecasts
Generate structured best, base, and worst-case forecast models to prepare for demand swings. Use this during annual planning or runway updates.
Compare cumulative customer lifetime value across monthly cohorts
Spot whether newer customer groups spend faster or retain better than older cohorts. Use this to audit acquisition quality over time.
Create an anomaly investigation checklist for analytics teams
Run a disciplined diagnostic process before investigating metric shifts. Use this checklist whenever unexpected data spikes or drops appear in reports.
Estimate potential revenue recovery across funnel drop-off points
Model the financial impact of repairing conversion drop-offs across your funnel. Use this to prioritize engineering fixes by projected dollar value.
- Evaluate past forecast variances to set accurate targets
- Isolate regional or platform drivers behind KPI drops
- Normalize retention comparisons for immature recent customer cohorts
- Summarize customer segment shifts for executive updates
- Translate statistical model outputs into plain business decisions
- Triage sudden metric spikes for event tracking bugs