How to Forecast Revenue

Predicting future revenue can feel like trying to guess the weather a month from now, but it's a vital exercise for making smart business decisions. A good forecast helps you allocate your budget, plan for hiring, secure funding, and set realistic growth targets. This guide breaks down how to create a reliable revenue forecast without needing an advanced degree in finance.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What is Revenue Forecasting?

Revenue forecasting is the process of estimating how much money your business will generate in a specific future period, typically a month, quarter, or year. It’s not about finding a magic crystal ball, it’s about using data, logic, and an understanding of your business to make an educated prediction. Think of it as a financial roadmap for your company.

Why bother? A solid forecast gives you a baseline for performance. It helps you:

• Budget effectively: Know how much you can afford to spend on marketing, new hires, or equipment.
• Set realistic goals: Create targets for your sales and marketing teams that are ambitious but attainable.
• Manage cash flow: Anticipate potential shortfalls and plan for periods of high or low revenue.
• Secure investment: Investors and lenders want to see that you have a credible plan for future growth.
• Make strategic decisions: Decide when to launch a new product, enter a new market, or expand your team.

Common Revenue Forecasting Methods

There are several ways to build a forecast, and the best one for you depends on your business stage, model, and the data you have available. Let’s look at a few of the most popular methods.

1. Historical Forecasting

This is the simplest approach. It assumes your future revenue will follow an established pattern based on past performance. You look at your historical sales data - often from the previous year - and use that as a baseline, adding a growth rate.

For example, if you made $500,000 last year and project 20% growth, your historical forecast is $600,000 for the upcoming year.

A slightly more detailed method is to calculate your average monthly growth rate. Let's say your revenue has grown an average of 5% each month for the last six months. You could apply that 5% growth rate to next month’s forecast.

• Best for: Established businesses with a predictable sales cycle and several years of financial data.
• Downside: This method doesn't account for significant market changes, new competitors, economic shifts, or the impact of new marketing campaigns. It looks backward, not necessarily forward.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

2. Bottom-Up Forecasting (From the Sales Pipeline)

Popular with B2B companies, a bottom-up forecast builds your projection deal by deal right from your sales pipeline. It predicts sales by looking at each open opportunity in your CRM and calculating its likelihood of closing.

Here’s how it works:

1. List all open opportunities from your CRM (like Salesforce or HubSpot).
2. Estimate the value of each potential deal.
3. Assign a probability of closing to each deal based on its stage in your sales process. For example:
4. Calculate the weighted value of each deal (Deal Value × Probability %).
5. Add up the weighted values from all your open deals. This total sum is your sales forecast.

For instance, a $10,000 deal in the "Proposal Sent" stage (60% probability) would have a weighted forecast value of $6,000.

• Best for: Sales-driven organizations with a well-defined sales cycle and reliable CRM data.
• Downside: The accuracy of this forecast is entirely dependent on the quality of your CRM data and your sales team's ability to accurately assign probabilities.

3. Top-Down Forecasting

The top-down approach flips a bottom-up forecast on its head. It starts by looking at the largest possible market for your product and then estimates what percentage of that market you can realistically capture. It's often called a "market share" forecast.

The process looks like this:

1. Determine your Total Addressable Market (TAM): This is the total revenue opportunity if everyone who could use your product bought it. Industry reports and market research can help you find this number.
2. Estimate your realistic market share: Based on your competition, resources, marketing strategy, and pricing, what percentage of the TAM can you realistically capture over a certain period?

If your TAM is $500 million and you believe you can capture 1% of the market in your first year, your top-down revenue forecast would be $5 million.

• Best for: Startups, companies launching new products, or businesses entering new markets where no historical sales data exists.
• Downside: This method can be overly optimistic and is detached from the realities of day-to-day sales and marketing efforts. It's more of a high-level goal than a data-grounded forecast.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

4. Multivariable Analysis

This is a more sophisticated and data-driven approach. It uses statistical regression analysis to find the relationship between your revenue and a variety of key drivers - both internal and external. These drivers could include things like website traffic, ad spend, the number of sales reps on your team, or even economic indicators.

For example, a model might predict that for every 10,000 additional website visitors, revenue increases by $1,000. By forecasting your website traffic, you can then forecast your revenue.

• Best for: Companies with a lot of historical data and the resources to perform statistical analysis. It’s the most accurate method when done correctly.
• Downside: It’s complex and often requires someone with data science or statistical modeling skills. Setting it up can be difficult and time-consuming.

How to Build Your Revenue Forecast in 4 Steps

Ready to build your first forecast? You don't need fancy software - a simple spreadsheet (like Google Sheets or Excel) will do the trick.

Step 1: Gather Your Data

Your forecast is only as good as the data you put into it. Pull together information from all your "systems of record." This might include:

• Financial Software (QuickBooks, Stripe): Past monthly, quarterly, and yearly revenue numbers.
• CRM (Salesforce, HubSpot): Your current sales pipeline, deal sizes, and conversion rates.
• Web Analytics (Google Analytics): Website traffic, lead sources, and conversion funnels.
• E-commerce Platform (Shopify): Average order value, customer lifetime value, and historical sales trends.

Step 2: Choose Your Forecasting Method(s)

Now, select the model that best fits your business. You don't have to stick to just one!

• If you’re a new startup, start with a top-down model to understand market potential, but try to ground it with a simple bottom-up model based on your initial sales or marketing capacity.
• If you're an established SMB with a steady flow of customers, historical forecasting balanced with a bottom-up pipeline forecast will give you a reliable range.

Many mature companies create two or three forecasts using different methods to get a range of plausible outcomes - a conservative case, a realistic case, and an aggressive case.

Step 3: Structure and Calculate Your Forecast

Create a simple spreadsheet. Set up columns for each month of the upcoming quarter or year. Then, build rows for your primary revenue drivers based on the model you chose.

If you're using a bottom-up model, your rows might represent your sales reps and their weighted pipelines.

If you’re using a simplified multivariable model for an e-commerce store, your spreadsheet might look like this:

Monthly Website Visitors x Conversion Rate (%) x Average Order Value = Monthly Revenue Forecast

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 4: Monitor, Analyze, and Refine

A forecast is a living document, not a one-time assignment. At the end of each month or quarter, compare your actual revenue to what you projected. In your spreadsheet, add rows for "Actual Revenue" and "Variance" (the difference between forecasted and actual).

This is where the learning happens. If your forecast was way off, dig into why. Did a big deal you were banking on fall through? Did a marketing campaign perform better than expected? Did holiday seasonality give you an unexpected boost?

Every time you review your forecast against actual results, you learn more about your business's revenue drivers. Use those insights to refine your assumptions and make your next forecast even more accurate.

Final Thoughts

Revenue forecasting is a blend of art and science. By using different data-driven models and consistently reviewing your performance against your predictions, you can build a reliable financial roadmap that guides your business toward its goals. It clarifies your path forward, moving you from hoping for growth to intentionally planning for it.

One of the biggest hurdles in forecasting is just getting all the necessary data from different places - your CRM, analytics platforms, and payment processors. We built Graphed to simplify this exact problem. Our platform connects directly to all your key sources, like Salesforce and Google Analytics, to give you a real-time, unified view of performance. It makes creating a data-driven forecast much faster because you can just ask in plain English to see the exact numbers you need without spending hours exporting CSVs.