How to Create a Sales Forecast for a New Business

This guide is for founders and early‑stage entrepreneurs who need a reliable sales forecast but don’t have a large data set or sophisticated analytics tools. You’ll learn a hands‑on workflow that starts with the few numbers you already have, helps you pick the right forecasting method, and walks you through building a clear spreadsheet model.

By the end, you’ll have a practical sales forecast you can use for budgeting, fundraising, and strategic planning, plus a set of checks to spot common errors before they affect your decisions.

Understanding the Basics of Sales Forecasting

Now that you know the workflow, let’s look at the foundation: what a sales forecast actually is and why it matters for a new business. A sales forecast is an estimate of future revenue (or units sold) over a defined period, based on the data you have today and the assumptions you make about growth. For a startup, the forecast becomes the financial north‑star that guides budgeting, informs investors during fundraising, and shapes strategic decisions such as hiring or inventory planning.

There are two common ways to build that estimate. Top‑down forecasting starts with a market‑size or industry‑level figure and applies a share‑of‑market assumption to arrive at your expected sales. Bottom‑up forecasting works the opposite way: you begin with the details of your own pipeline—number of leads, conversion rate, and average deal size—and aggregate them to project total revenue. Bottom‑up tends to be more granular and realistic for early‑stage companies, while top‑down can be useful for quick sanity checks or when you have limited pipeline data.

Regardless of the method, every sales forecast should include three core components:

• Revenue or unit volume you expect to generate.
• Time horizon—monthly, quarterly, or yearly periods.
• Assumptions such as run rate, seasonality, and growth rates.

Keeping these basics clear will make the rest of the “How to Create a Sales Forecast for a New Business” process far easier to execute and validate.

Collecting the Right Inputs for a Startup

Start by gathering the few pieces of concrete information you already have, then fill gaps with publicly available data or reasonable assumptions. The most reliable inputs for a startup are:

• Market research reports – use industry overviews, TAM (total addressable market) figures, and growth rates published by trade groups or analyst firms.
• Comparable companies – look at the revenue and pricing of businesses that serve a similar customer segment; public filings or press releases can give ball‑park numbers.
• Early customer interviews – ask prospects how much they would pay, how often they would buy, and how long a typical decision takes.
• Internal pipeline – list qualified leads, stage them in your sales funnel, and apply an estimated conversion rate to project closed deals.

To turn these sources into forecast inputs:

1. Estimate market size by multiplying the TAM by the portion of the market you can realistically reach (your target share).
2. Derive an average deal size from interview feedback or comparable pricing, then multiply by the projected number of customers.
3. Define the sales cycle length using interview data or industry norms; this informs how many pipeline opportunities you need each period to hit your revenue goal.
4. Apply a simple conversion rate to your pipeline stages to calculate expected closed‑won deals per month.

Document each assumption next to the source you used. This transparency makes later scenario or sensitivity analysis much easier and keeps the sales forecast grounded in the limited data a startup actually possesses.

Selecting a Forecasting Approach

Choosing the right forecasting approach determines how realistic your sales forecast will be. Top‑down forecasting starts with market‑size estimates or industry benchmarks and then allocates a share to your company. It’s quick, but it relies heavily on external data that may not reflect your early‑stage reality.

Bottom‑up forecasting builds the sales forecast from the inside out: you estimate the number of leads you can generate, apply your conversion rate, and multiply by the average deal size. Because it uses the pipeline metrics you already tracked, it aligns closely with the limited data a startup possesses and keeps assumptions transparent.

A hybrid method blends the two—using top‑down market growth rates to sanity‑check a bottom‑up pipeline model, or to fill gaps where you have no historical conversion data. This can be useful when you have a solid internal pipeline but need to validate that your growth expectations are not out of line with overall market trends.

• Bottom‑up is generally recommended for new businesses because it ties the forecast directly to actions you can control.
• Top‑down may be added later to benchmark ambition against industry averages.
• Hybrid works best when you have enough internal data to model the pipeline but still want external context for fundraising or strategic planning.

Step‑by‑Step Build of the Forecast

With the forecasting approach chosen, you can now translate the assumptions into a concrete sales forecast that will feed your budget, fundraising deck, and operational plan.

Step 1: Define the Forecast Period and Granularity

Decide whether you need a 12‑month, 24‑month, or longer horizon and choose a time‑slice that matches your sales cycle—monthly for most SaaS pipelines, quarterly for longer‑term contracts. This granularity determines how you will apply conversion rates and seasonality later.

Step 2: Estimate Units or Revenue per Period

Start with the bottom‑up method: list the number of leads you expect in the pipeline each period, apply an estimated conversion rate, and multiply by the average deal size. For product businesses, estimate unit sales and then calculate revenue using your price per unit.

Step 3: Incorporate Seasonality and Growth Assumptions

Adjust the raw numbers for known seasonal peaks—e.g., higher demand in Q4—or for a steady growth rate that reflects market expansion. Document each assumption so you can later run scenario analysis.

Step 4: Build a Simple Spreadsheet Model

Create columns for period, leads, conversion rate, won deals, average deal size, and calculated revenue. Add rows for total revenue, cumulative run rate, and a separate section for top‑down benchmarks. Use basic formulas (e.g., =Leads*Conversion*DealSize) to keep the model transparent.

Step 5: Review and Stress‑Test the Numbers

Run sensitivity analysis by varying key inputs—conversion rate, average deal size, or growth percentage—to see how the forecast reacts. Highlight best‑case, base‑case, and worst‑case scenarios; this prepares you for investor questions and internal decision‑making.

Using the Forecast to Drive Business Decisions

A solid sales forecast becomes the backbone of every major budget line. When you know the expected revenue for each month, you can allocate cash to marketing, product development, and operating expenses with confidence, avoiding both over‑spending and cash‑shortfalls.

Hiring plans should be tied directly to the forecasted pipeline. If the model shows a steady increase in qualified leads and a stable conversion rate, you can justify adding sales reps or support staff in the quarter when the headcount need peaks. Conversely, a flat or declining forecast signals a pause on new hires until the pipeline improves.

For inventory‑driven businesses, the forecast translates directly into purchase orders. By converting projected units sold into required stock levels, you reduce the risk of excess inventory that ties up cash, while also preventing stock‑outs that could damage customer trust.

When pitching to investors, the forecast provides a concrete narrative. Show the base‑case revenue trajectory, then walk through the best‑ and worst‑case scenarios you built during sensitivity analysis. This demonstrates that you understand the levers of growth and have a plan for each outcome.

Finally, treat the forecast as a living document. Update it monthly with actual sales, recalculate conversion rates, and compare results to projections. Tracking variance highlights early warning signs and lets you adjust budgets, hiring, or marketing tactics before small gaps become larger problems.

FAQ – Common New‑Business Forecasting Questions

How often should I update my sales forecast? Treat the forecast as a living document and refresh it at least once a month. Plug in the latest actual sales, recalculate conversion rates, and adjust any growth or seasonality assumptions that have shifted.

What if my data is very uncertain? Use a range‑based approach instead of a single point estimate. Build a best‑case, most‑likely, and worst‑case scenario, then run a quick sensitivity analysis to see which inputs (pipeline volume, conversion rate, average deal size) move the outcome the most. This highlights where you need better data.

Which tools are best for a startup? A simple spreadsheet (Google Sheets or Excel) is usually sufficient. Leverage built‑in functions for percentages and basic charts. If you prefer a visual interface, low‑cost CRM platforms often include pipeline reporting that can be exported directly into your forecast model.

How do I interpret a gap between forecast and reality? First, calculate the variance as a percentage of the forecast. Then ask whether the deviation stems from a change in volume, conversion rate, or average deal size. Small, explainable variances are normal; persistent or growing gaps signal that one of your core assumptions needs revisiting before you allocate budget or make hiring decisions.