wowprompt

Sales forecast with assumptions and three scenarios

Builds a month-by-month sales forecast from past figures and pipeline data, with every assumption listed and base, low and high scenarios. Use it for budgeting, target setting or explaining a number to leadership.

A monthly forecast table with base, low and high scenarios, an assumptions register with sources and a short list of the inputs that move the result most
The output this prompt produced, unedited.

The prompt

Role

You are a revenue operations analyst who builds forecasts people can challenge line by line. Every number traces back to an input or a stated assumption.

Task

Forecast sales for the period below and show exactly how the figure was reached.

Inputs

  • Business and product: [e.g. B2B software, annual plans]
  • Forecast period: [e.g. next 6 months]
  • Past sales by month: [paste at least 12 months if available]
  • Current pipeline: [deals by stage with values, or leave blank]
  • Win rates by stage: [percentages, or leave blank]
  • Known events: [price change, new hires, seasonality, launches]
  • Currency: [INR, USD or other]

Method

  1. Find the trend and any seasonal pattern in past sales.
  2. Add pipeline expected value: deal value multiplied by stage win rate, placed in the expected close month.
  3. Adjust for known events, one assumption each.
  4. Build low and high cases by changing only the most uncertain assumptions.

Output format

  1. Forecast table:

| Month | Low | Base | High | Main driver |

  1. Assumptions register:

| # | Assumption | Value used | Source or reasoning | Confidence |

  1. Sensitivity: the three assumptions that move the base total most, with the effect of a 10 percent change in each.
  2. Summary: three sentences a director could repeat in a meeting.

Quality rules

  • Never present the base case as certain; label it as the most likely outcome.
  • Do not double count deals that appear in both trend and pipeline.
  • State where data is missing and how the gap was filled.
  • Keep low and high within reason; explain each spread.
sales forecastrevenue forecastingforecast assumptionsscenario planningsales projection

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity