Revenue Forecast Scenario Calculator

This revenue forecast scenario calculator projects cautious, base, and optimistic revenue cases from starting monthly revenue, growth, churn or renewal loss, seasonality, and weighted pipeline assumptions.

It is designed for planning conversations where a simple price times units calculation is too narrow, but a full accounting or cash-flow model would be too heavy.

Use it to compare top-line revenue assumptions before hiring, raising marketing spend, setting sales targets, ordering stock, or building a board-pack forecast.

The calculator is manual-input only. It does not import CRM data, recognise revenue under accounting standards, predict demand, or model when cash is collected.

Imagine a business starts with GBP 35,000 in monthly revenue, expects 4% monthly growth, loses 2% to churn or non-renewal, and has GBP 60,000 of open pipeline at a 35% win probability.

The base case applies those assumptions directly. The cautious case lowers starting volume, growth, and pipeline conversion. The optimistic case raises them. That gives a range instead of one fragile forecast.

The useful output is often the spread between cautious and optimistic revenue. A wide spread tells you the plan is sensitive to sales conversion, renewal quality, or seasonality.

Starting monthly revenue is projected forward month by month. Growth increases the recurring revenue base, while churn or renewal loss reduces it.

Seasonality adds a repeating monthly swing so the forecast does not assume every month behaves the same. Pipeline value is probability-weighted and spread across the forecast period as expected new revenue.

The cautious and optimistic cases adjust volume, growth, and pipeline conversion. They are not predictions; they are structured planning scenarios using the same assumptions in different directions.

Revenue forecast and cash-flow forecast answer different questions. Revenue forecasting asks what the top line may be. Cash-flow forecasting asks when money may enter or leave the bank account.

If invoices are paid late, deposits are collected early, subscription revenue is deferred, or tax and payroll timing matter, use the cash-flow forecast alongside this page.

For a full business plan, compare revenue scenarios with gross margin, CAC, cash flow, runway, and hiring assumptions rather than treating revenue alone as proof that the plan works.

This calculator does not validate CRM stages, deal quality, pricing contracts, refunds, discounts, revenue recognition, taxes, or customer payment timing.

For investor reporting, board packs, lender discussions, or audited accounts, reconcile the forecast with signed contracts, accounting records, pipeline reports, and finance definitions.

Use the output as a structured conversation starter: what has to be true for the optimistic case, and what would the business do if the cautious case appears?