You don’t know where the year went, but somehow, 2020 is almost here. One area you want to focus more on for the first quarter of the coming year is your company’s sales strategy. It’s just lacking in some areas.

Often, you wish there was a way for you to look into the proverbial crystal ball to predict future sales. After all, at current, your sales come in when they come in. Sometimes your sales team is overloaded and frazzled and other times they’re struggling to pull in but a single lead.

This track record of unpredictability can be a waste of your time, energy, money, and resources. Instead of blindly guessing what your sales future may hold, there’s a way to know with more certainty. It’s known as sales forecasting.

If you’re not yet doing any sales forecasting for your company, that’s something you’ll definitely want to change for the year ahead. In this extensive guide, we’ll explain all things sales forecasts. From sales forecasting meaning to tips and strategies on how to make a forecasting sales plan (with examples), you’ll be all set to debut your forecast for 2020. In fact, you’ll almost feel like you have 2020 sales-projecting vision.

What Is a Sales Forecast?

As we said, we want to start with a sales forecast definition. This way, we’re on the same page going forward. Okay, so what does it mean when you forecast your sales anyway?

Sales forecasting predicts what your sales pipeline may look like in the future. Now, you don’t just reach into your magic hat and pull out the first sales number that comes to mind. You also don’t inflate your sales to an unreasonably high degree.

what is a sales forecast

Sales forecasting isn’t random. If it was, it’d be pointless. Instead, it’s based on actual sales data and trends. While it doesn’t hit the mark every single time, you can increase your forecast accuracy by using your own company’s data. Besides that, you also want to rely on current trends in economics and trends in your industry to shape what will become your future sales prediction.

Newer companies that don’t yet have years of data to review will have to use trends only. Competitive intelligence and market research can also help. In the meantime, keep track of your company’s sales over the coming weeks and months. Then, you can eventually use it to shape your own forecast. When you do, you may notice the accuracy of your predictions goes up.

The Importance of Sales Forecasting

We’ve explained the purpose of forecasting your sales, but since it’s not a 100-percent sure thing, you may wonder, why do it? Can it really help your sales team that much?

Yes, indeed. In fact, you’ll discover there are plenty of reasons to forecast sales, whether you’re a small business or a Fortune 500 company. Let’s talk about these more now.

Map out Sales Growth

The first and most obvious reason to forecast your company’s sales is to plan for the growth of your sales team. Will they make more customers out of leads? How many conversions can you expect given the past performance months or years back?

Will your customer base grow to the point where you need more salespeople as part of your company? These are all important questions to answer right about now as we enter the last stretch of the year. If you have to make significant changes to your sales team, you can unveil that at the start of 2020.

Ensure You Have the Right Resources

You want to accommodate your sales team so their job is as easy to do as possible. To that end, they will need resources to close deals and convert leads. Maybe that’s customer relationship management software (CRM), apps, programs, or smartphones.

Whatever it is, you don’t want to find out midway through a major sales deal that you’ve underdone it on the supplies or equipment. By planning for your team’s sales growth over 2020, you can obtain all the resources you need ahead of time. This way, you never have to end up in the tight, nerve-wracking situation of the members of your sales needing resources but you having none to provide.

Plan Your Sales Budget

Whether adding new members to your company’s sales team or buying more resources, these things all cost money. Every company should set a budget at the start of the year and do their best to follow it. Sure, things happen like surprises or accidents, and sometimes that can drain more of the budget than anticipated. As a whole, though, you should have a predictable budget that accommodates your company’s basic needs.

By predicting your sales for the year ahead, you’ll experience fewer of those stressful “whoops” moments we talked about before because you’ll have a more accurate sales budget. Now you won’t have to set aside money for CRM software access for that new sales reps when you had the cash allocated for something else.

If you over budget and don’t use all the money, that’s much better than scraping by because of a too-small budget.

Anticipate Revenue

We’ve talked enough about spending money. Now let’s discuss earning it. Your sales team are the big money-makers at your company, but how much will they bring in for the coming year? As you probably guessed, you can plan for this as well by forecasting your sales.

It almost sounds like a dream to know roughly how much money your company can generate. As we’ll explain in the next few points, there are a lot of other related benefits to predicting your cash flow as well.

Predict Product Interest

While you’re reviewing your 2019 income to plan for what’s to come next year, don’t forget to look at which of your products and services sold the most. This can be a great indicator of what may continue selling into 2020.

Sure, trends and preferences change, but if you’ve had a consistently best-selling item that made you most of your money, don’t forget that as the calendar year changes. Maybe you prioritize this top-selling product for the year ahead. You could even roll out a related product and hope it generates as much success and revenue.

Attract Investors

Small and mid-sized companies especially can always use more money. If you have someone who’s interested in your company and truly believes in what you do, they may choose to contribute as an investor.

Sure, you could find investors the good, old-fashioned way, such as through networking. You can also let them come to you. One way to get investors knocking on your door is by establishing what you believe your company’s sales goals will be as the year’s first quarter gets underway. The more accurate you are, the more investors may be interested in working with you.

Boost Stock Market Prices

Another benefit of your accurate revenue prediction through sales forecasting? Your stock prices could go up from publicizing such a positive sales report. As the year progresses and your investors realize your predictions were quite accurate, your stocks could climb even higher.

How to Forecast Sales

As we’ve proven, there are plenty of reasons to begin forecasting your company’s sales. You want to get started, but how do you even go about doing so? It’s important that you use trusted sales forecasting methods and not just any old thing that seems convenient at the time. Otherwise, you’re only contributing to the trend of inaccuracies associated with sales forecasting.

For instance, a 2016 report from SiriusDecisions notes there’s a pretty wide margin of error that can occur with this type of forecasting. Most sales companies (79 percent) were quite inaccurate with their own predictions, wrongly forecasting by greater than 10 percent. That’s quite a lot of companies making such big errors!

sales plan

Image courtesy of SiriusDecisions

The above image shows the range of accuracy you want to aim for with your own sales forecasting. As you can see, anything that’s under, at, or over 10 percent incorrect is considered terrible accuracy. If you’re within five percent of your predicted range, that’s good. It’s even better if you’re under five percent of the range. That’s excellent.

While you won’t achieve under five-percent accuracy your first go of things, the sooner you can make accurate sales predictions, the better. The information generated at the beginning of your company’s life can become the backbone in which all future data builds. If any of it’s wrong, that’s a huge problem.

Imagine a construction team erecting a building on a faulty foundation. Everything else is no longer sound. It’s the same way with your forecasting. Early mistakes get incorporated into future data, and it snowballs from there. Before you know it, you can affect months, even years of data. It’s all wrong, and just from a single mistake.

To improve your own predictive accuracy, you may want to use one of several sales forecasting types when planning your sales performance forecasting.

Pipeline Forecasting

The first forecasting method we’ve got for you is admittedly one of the more complicated ones. It’s known as pipeline forecasting. With this, you track your sales pipeline for opportunities. Then, implementing opportunity value, win rate, and other variables, you can assume your closing rate.

It’s much better to use software for pipeline forecasting because, as we said, it’s a bit complex. It’s also easy to make mistakes, and you don’t want to do that. You can’t provide imperfect data or mess up any of the inputs with pipeline forecasting or you’ll get an inaccurate result.

Historical Forecasting

As the name tells you, historical forecasting is all based on what’s happened in the past. You can rely on this to track data by the week, the month, or the year. Obviously, the newer your company is, the less viable historical forecasting becomes. If you haven’t yet made historical data to review over at least two years, then you have nothing to measure your current results against.

Even if you are a more established company, you have to watch out for some pitfalls with historical forecasting. For example, this method doesn’t accommodate for the fact that buyer demand can fluctuate, which it naturally does. It also doesn’t take into account that some companies are seasonal.

Intuitive Forecasting

Do you have a good sense of intuition? If so, then you might want to try intuitive forecasting for your company. This is a more opinion-based means of forecasting sales. Your sales team comes to the rescue yet again here, as their opinions and predictions get rolled into one forecast.

Does it work? It can. Mostly, we’d recommend intuitive forecasting for those companies that can’t use historical forecasting because they’re too new. Just triple-check for inaccuracies.

Length of Sales Cycle Forecasting

If you’re still not sure which forecasting method to use, we’ve got plenty more. Next is the length of the sales cycle forecasting. This focuses more on sales deal length, using it as the yardstick for when future deals may close. You can also track sales cycle length and use the data much the same way.

Feel free to incorporate all the different sales cycles into your forecasting, including those for leads versus qualified prospects. Your sales pipelines must be rock solid for this method to work, but it’s one of the better ones. There’s only room for objectivity here, no opinions-based predictions like with intuitive forecasting.

Opportunity Stage Forecasting

On the note of your sales pipeline, while you’re tracking it so closely, you might as well give the opportunity stage forecasting a try. This forecasting reviews deal stages through the pipeline, making assumptions on the likelihood of closing the deal.

You select a reporting period based on the quota of your sales team and your average sales cycle length. These periods may be monthly, quarterly, or annually. Once you figure that part out, you do some multiplication. You want to take your deal closing probability and multiply it by the potential value of the deal.

Continue multiplying until you’re done with each deal occupying your pipeline. Then tally up the multiplied values and you’ll see a more predictive forecast.

As another complex sales forecasting strategy, opportunity stage forecasting can be riddled with inaccuracies. Older and newer deals don’t get distinguished, muddying the waters that are your results. Further, if you don’t have historical data to rely on—like for new businesses—you can’t really use this method.

Multi-Variable Analysis

A multi-variable analysis combines elements like the performances of your representatives, types of opportunities, and the length of your sales cycle. What you get is a more accurate means of forecasting your sales for the quarter or the year.

You’ll want to use analytics software to generate your multi-variable analyses, as this promises great accuracy. Also, clean data matters big time here, so make sure your sales team closes out deals when they’re done.

Times-Series Forecasting

Moving away from what’s in your sales pipeline for a moment, yet another forecasting method you can use is time-series forecasting. This accommodates for the season, cyclical changes in business, and industry trends. For newer companies that don’t have a lot of background, here’s yet another forecasting method to consider.

How Do You Calculate Sales Forecasts?

Now that we’ve shown you several methods and sales forecasting types, we wanted to take a deeper dive into calculating your own forecasts. You can do this with formulas; you could even forecast sales in Excel. Yes, we’re talking about the Microsoft program you more than likely have on your work computer right now.

Assuming you are using Excel, we want to keep things uncomplicated for you. The formula you want to follow is as basic as can be. Here it is:

Average seasonality + trend = projected sales

Yes, that’s it. And while sure, there are some services that can use Excel to automate your forecasts for you, you might prefer doing it yourself. This way, you can see how it’s all done. That hands-on knowledge could make forecasting your future sales easier in 2021, 2022, and beyond.

Here are the steps you need to follow when calculating your sales forecast without considering seasonality. Companies younger than two years old are not eligible to calculate their forecast using this method or the next one we’re going to share.

Step 1: Add in Past Sales Data, Up to Eight Quarters’ Worth

Column A of your Excel spreadsheet should contain the year. The line with the year should be adjacent to quarter one in column B. Leave three blanks spaces under each year in Column A for quarters two through four.

Eight quarters is at least two years’ worth of data, so you should have that much to work with. Make sure each quarter is numbered and not just “quarter one, quarter two, quarter three, and quarter four” repeated over and over. For example, for the second year of data, you should start with “quarter five.”

In Column C, add your sales for each quarter. You can then autofill column D, or trends, by inputting the following:

=FORECAST(B3,$C$3:$C$10,$B$3:$B$10)

Your trends may be up or down depending on your sales results.

Step 2: Make a Seasonality Column but Leave It Blank

Column E of your Excel spreadsheet should say “seasonality,” but you don’t want to add any values to it at this point. Remember, seasonal changes are excluded from your forecasting this time around.

Step 3: Fill in Your Sales Projections

After the seasonal column, you’ve got Column F for your sales projections. If you’ve done everything correctly to this point, then this column will autofill for you. How? Excel will calculate your sales projections by tallying your seasonality (column E) and trends (column D).

You can even use Excel to display this data as a linear graph. That might make it easier to visualize your predicted sales. Here’s what it may look like. Remember, we’re still excluding seasonality to this point.

sales projections

Image courtesy of Spotcap

What if you wanted seasonality in there? Well, open a new spreadsheet in Excel, because we’re starting over again. Here are the steps.

Step 1: Add in Past Sales Data, Up to 12 Quarters Worth

Just like we did last time, you want to work with a fresh Excel document. Column A is your year and column B your quarters. Arrange these two columns the same way you did before, leaving extra space under each year for all the quarters. The difference is now, instead of only eight quarters’ worth of data, you want 12 quarters. That’s three years.

Step 2: Add in Your Sales Data

Make column C for your sales. Input the sales for each quarter manually.

Step 3: Incorporate Your Moving Average and Centered Moving Average

Since you’re not replicating the other spreadsheet, here’s where things begin to change. In column D, you want to add a moving average. Then, in column E, a centered moving average. Hold on a moment. What’s a moving average and centered moving average?

Your moving average, in this case, is just four quarters averaged into one value. This can be any four quarters, so it doesn’t have to be in all in one year. The centered moving average refers to the average value you get when you take two moving averages and put them together.

Step 4: Autofill Your Trend Column

You still want the trend column in this Excel spreadsheet, this time in column F. This will be auto-filled once more.

Step 5: Factor in Seasonality

Okay, with all that legwork out of the way, it’s finally time to determine how seasonality plays a role in your forecast. The seasonality, in this case, is what you get when you take your trends and your sales and subtract one from the other.

Seasonality isn’t always a positive value. If that’s the case, then you undersold compared to what you anticipated you would. If it is indeed a positive value, then congrats, your company has done well. You may have even exceeded expectations.

Step 6: Figure out Average Seasonality by Quarter

If you want to take things a step further, such as determining seasonality by quarter, you can. Let’s say you wanted to focus on your first quarter, your fifth one, and your ninth quarter. The formula would look a little something like this:

=average(G3,G7,G11)

You can switch up any of the quarters by changing the G values in the above formula. Once you have that data, you can follow the original formula: average seasonality + trends = projected sales to get your projected sales.

In this case, you’d want to input: =F3+$J$21

Do make sure you review your Excel graph, which now accounts for seasonality.

predict future sales

Image courtesy of Spotcap

Sales Forecast Templates and Examples

We’ve provided plenty of forecasting methods and formulas, but if you still need more guidance for getting started, then you’ve come to the right place. In this section, we’ll share our most preferred sales forecasting examples and templates.

Templates

The following templates work in Microsoft Excel or Google Sheets, some even in Microsoft Word or PDF. They include either examples or instructions on how to use the template, if not both. Here are our best template picks:

  • Add various product lines and growth rates to your Excel spreadsheet here; examples and instructions included
  • Toggle more with admin/marketing costs and growth rates in Excel here; no examples, but you do get instructions
  • Make goods/services sold and seasonality projections with Microsoft Word here; no examples or instructions included
  • Implement scenario planning in Excel here; no examples, but there are instructions
  • Make sales forecasting using more historical growth data (two years or more) in Excel here; no examples or instructions included
  • Include more shifting marketing conditions in your forecasts in Excel here; examples and instructions are both included
  • Work with longer deals with a greater projected volume in Excel here; no examples or instructions included
  • Add more overhead costs to your projects in Excel here; you get examples, but no instructions
  • Include all your product lines in your forecasting in Excel here; you get both examples and instructions
  • Use this template if you’re a small business or startup beginning with forecasting in Excel here; includes neither instructions or examples
  • Produce monthly business reports in PDF here; comes with both examples and instructions

Examples

Would you like to see a sales forecast in action? Here’s one courtesy of Bplans. It’s for a small restaurant. The establishment makes $1,152 on dinners when the restaurant is at full capacity and $288 on lunches. Keeping that information in mind, here are snapshots of the forecasting for this restaurant.

sales forecasting examples

sales forecast template

forecast sales in excel

Images courtesy of Bplans

To calculate this forecast, the theoretical restaurant owner could track their sales over each weekday to get an idea of weekly sales. They could then do some math to figure out what annual sales might look like.

However, restaurants aren’t open every single day of the year, nor are they always at full capacity. This example takes several of these factors into consideration. For instance, the restaurant isn’t open for lunch hours on the weekend. They also generate a smaller crowd on Monday nights for dinner.

Each month then, the restaurant predicts they’ll sell 1,044 dinners and 370 lunches. However, in the Excel spreadsheet, the restaurant owner goes even lower than that since they’re a new establishment that doesn’t want to assume too much.

We quite like what Bplans says about making your own sales forecast: “These numbers are not magic…As you work through yours, don’t look for some answer out there in the world, as a right answer to a puzzle; look for ways to break your assumptions down into the logic you need to work with them.”

How Can EngageBay CRM Help in Forecasting Sales?

This guide has proven that you need to begin forecasting your sales if you aren’t already. As we’ve mentioned, some of the methods and tactics you need for sales forecasts can be quite difficult to do on your own. In that regard, CRM software can make your life far easier.

If you’re shopping around for CRM software for sales forecasting purposes, allow us to introduce ours at EngageBay. We started EngageBay as an alternative to more expensive sales and marketing software. Our all-in-one suite includes the tools and programs you need to see your company flourish.

Our CRM is always free. If you happen to use another CRM before moving to ours at EngageBay, we’ll also help you migrate over free of charge.

Wondering why you should use a CRM for forecasting sales, especially EngageBay’s? Here are some ways a CRM can come especially in handy:

  • Track sales performance and sales trends using reporting software and tools. You can review these by the month, the quarter, or the year. When predicting future sales success, having this past data to rely on will improve the accuracy of your forecasting.
  • Track and filter leads so only the most qualified prospects get to your sales team. Your sales reps can then close more deals, which is reflected in a revenue increase.
  • Use lead confidence and other features for more accurate estimates of what’s going on in your sales pipeline during any quarter.
  • Make changes to your sales pipeline predictions as the year gets underway or other situations arise.
  • Get on-demand reports detailing your most up-to-date sales forecasting data. This includes sales team quotas, open and closed deals in your company’s sales pipeline, how many deals the team has closed, and projected revenue.

Whether you’re a small business just beginning to track your sales forecasting or a more established company eager to use past data to predict the future, EngageBay’s CRM can help.

Conclusion

A sales forecast is a prediction of what’s to come for your sales team, including closed deals and revenue. By using past data, industry trends, and other info, you can make more accurate predictions on what your year ahead will look like.

With so many methods and formulas for calculating sales forecasts, if you need some extra help, you can always rely on EngageBay’s CRM. Best of luck and may your company have a more fruitful 2020 through forecasting your sales.