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

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

Example for: quarterly SaaS revenue model review

  1. Baseline Comparison
MetricHistorical AverageProjected ValueGrowth Jump
Quarterly Net New ARR$320,000$680,000+112%
Sales Cycle Length64 days45 days-30%
Win Rate22%31%+9 pts
Customer Churn (Gross)1.8% / mo1.1% / mo-39%
  1. High-Risk Disconnects
  • Sales cycle acceleration: The model assumes cycles compress from 64 to 45 days without changes in product packaging or deal size.
  • Unbacked conversion lift: Win rates jump to 31% while pipeline volume also doubles, which historically causes conversion quality to fall rather than rise.
  • Understated churn: Churn is modeled down to 1.1% despite moving into mid-market accounts that take longer to onboard.
  1. Recommended Revisions
  • Hold win rate constant at 22% and test if the pipeline target alone can deliver the required bookings.
  • Stagger the Net New ARR acceleration across four quarters rather than taking the full step-up in Q1.
  • Stress-test the cash runway with churn held at the historical 1.8% monthly run-rate.
Written by AI from this prompt. Your results will vary.

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.

Keep exploring

More in Data Analysis