Revenue Forecasting for Founders: How to Build a Forecast People Actually Believe
A credible revenue forecast is built bottom-up from drivers — not top-down from aspirations. This guide shows how to build a forecast from real data, account for seasonality and churn, and present it in a way that is useful for both operations and investor conversations.
- Why most founder forecasts fail
- Bottom-up vs top-down forecasting
- Building a bottom-up revenue forecast
- Using AskBiz to build and track revenue forecasts
Why most founder forecasts fail#
The most common forecasting failure is the hockey stick — a flat line followed by a sudden steep upward trajectory that usually coincides with a planned product launch or marketing investment. Hockey stick forecasts fail because they are aspirational rather than mechanical. They do not show the specific assumptions that drive the growth. An investor or well-run finance function needs to understand the inputs — how many new customers, at what average order value, with what churn rate — not just the output revenue number.
Bottom-up vs top-down forecasting#
Top-down forecasting starts with the total market and applies a market share assumption: the market is £500 million and we will capture 2% = £10 million. This is almost never credible because it provides no mechanism by which the share is captured. Bottom-up forecasting starts with unit-level drivers: how many sales conversations per month, at what conversion rate, at what average contract value, with what churn rate. The resulting revenue forecast is the mechanical output of specific, trackable assumptions.
Building a bottom-up revenue forecast#
For eCommerce: Monthly revenue = (Existing customers × repeat purchase rate × average order value) + (New customers × first purchase AOV). For SaaS: MRR = Prior MRR + New MRR + Expansion MRR − Churn MRR. Every input is a business process you can track and improve. The forecast becomes a live dashboard, not a static document.
Data-backed guides on AI, eCommerce, and SME strategy — straight to your inbox.
Accounting for seasonality and churn#
Two factors most forecasts handle badly. Seasonality: apply historical seasonal indices to your base forecast rather than assuming linear growth. A month-by-month seasonal index applied to a trend forecast is far more accurate than a straight-line projection. Churn: failing to account for customer attrition significantly overstates revenue. If you add 100 new customers per month but 15% of your base churns annually, your net customer growth is significantly less than gross additions suggest.
Using AskBiz to build and track revenue forecasts#
AskBiz builds a revenue forecast from your historical data — applying your actual growth rates, seasonal patterns, and churn rates to project forward. As each month passes, it compares actuals to forecast and surfaces the drivers of any variance. Ask it: what is my forecast revenue for the next 6 months at current growth rates, what would happen if my churn rate increased 3 percentage points, how much of my revenue variance this month is explained by volume vs average order value.
People also ask
How do I build a revenue forecast for my small business?
Build a bottom-up revenue forecast from unit-level drivers: existing customer repeat rate, new customer acquisition rate, average order value, and churn rate. Apply historical seasonal patterns and build base, upside, and downside scenarios to show the range of likely outcomes.
What is a bottom-up revenue forecast?
A bottom-up revenue forecast starts with specific operational drivers — number of customers, conversion rates, average order value, churn rate — and calculates the resulting revenue as a mechanical output. It is more credible than top-down forecasting because every assumption can be tracked and debated.
12 metrics every SME owner should review monthly — download in 10 seconds.
Our team combines expertise in data analytics, SME strategy, and AI tools to produce practical guides that help founders and operators make better business decisions.
Build and track your revenue forecast with AskBiz
AskBiz builds a data-driven forecast from your historical data and tracks actuals vs forecast automatically. Free to start.
Start free — no credit card required →