Everything you need to know about Sales Forecasting and how to simplify it for your organization.
Sales forecasting is a process of estimating future sales based on past performance and trends. Sales forecasts are a key driver of a company’s financial model because they affect profit and cash flow generation. It is also one of the most important aspects of business planning because it is the starting point of the master budget process.
Want to learn the best way to do Sales Forecasting in Excel? You’re in the right place.
While interpreting total revenues might look easy, building an accurate sales forecasting model is harder than it looks. Every business has a unique product mix and market dynamics (competitive environment, market share, trends, etc.), and historical performance might be a poor predictor of future performance. Accurate sales forecasting is especially hard for startups and small businesses that don’t have historical benchmark values or consistent sales performance.
In this article, we’ll explain the importance of accurate sales forecasting, different sales forecasting methods, and share sales forecasting best practices to help you forecast more accurately. We’ll also highlight common mistakes to avoid. You can also download our free sales forecast template as a starting point for your own sales budget, or just to follow along with our examples.
Then try it by automating the template with OnPlan FP&A software. We've made it easy to update data instantly with the click of a button and without relying on manual inputs.Book a Demo Now
Revenue or sales is a key driver of a company’s income statement. Because it is the first line item on a company’s profit-and-loss statement (P&L), it is also sometimes called the top line. Revenues flow through the rest of the income statement and affect the subtotals as well as net income.
To get from revenue to net income, you have to subtract several costs. The first is
Cost Of Goods Sold (COGS). COGS represent all the direct costs associated with a product or service, such as direct materials, direct labor, and overhead expenses. These typically scale as revenue grows. This results in a subtotal which is called gross income.
Next, you subtract Operating Expenses not directly tied to revenue volume, including salaries, marketing, office rent, and non-cash depreciation and amortization charges. Taking these costs out of Gross Income leaves you with Operating Income, or Earnings Before Interest and Taxes (often abbreviated EBIT). This subtotal is a very important financial metric because it represents the company’s ability to make money. Finally, by subtracting interest expenses and taxes from operating income, you finally get to the company’s net income or bottom line.
Not only is a company’s profitability very sensitive to changes in sales forecasts, but net income or EBITDA is also a key input of the company’s cash flow statement. That’s why overoptimistic sales forecasts can mislead management into thinking that they are cash-rich while they are at risk of running out of funds. As we’ll see next, getting the sales forecast wrong can also lead to over- or under-producing, adding operating expenses faster or slower than necessary, and other sub-optimal operational decisions. This explains why the sales forecasting model is the starting point of the master budget cycle.
No matter its size and the nature of its offering, every company requires a master budget. The master budget comprises an operating budget and a financial budget over a specific time period (usually one year) or the operating cycle. The focus of the operating budget is on the management and planning of resources, while the financial budget is centered on cash inflows and cash outflows forecasts.
The sales budget is the first budget in the master budget cycle because sales volumes affect other budgets, such as the production budget and its sub-budgets (direct materials budget, direct labor budget, and manufacturing overhead budget), non-manufacturing budgets (sales, marketing, administrative, R&D) and cash flows. All these budgets are interrelated and are driven by the sales forecast budget. (The type and number of budgets depend on your business. For example, not every company requires an R&D or even a direct materials budget.)
Since we are now clear about the importance of sales forecasts in an overall financial planning and forecasting framework, let’s talk about the key drivers that can enhance your sales forecast model’s accuracy.
In their most rudimentary form, sales forecasts are a function of sales prices multiplied by unit sales for various products, irrespective of whether it is a physical good or a service. However, since businesses are extremely diversified, revenue models come in all shapes and colors. That’s why you must develop a thorough understanding of your company’s business model.
Sales forecast models usually consist of monthly sales projections. While the best financial models are built by individuals with solid financial modeling skills, they rely heavily on the inputs provided by other business partners. Sales, Production, Marketing, and HR can all impact your pro forma sales numbers.
Here’s a non-exhaustive list of sales drivers:
1. Trend & seasonality
Sales volumes might be a function of a sales base multiplied by a growth rate. The sales growth rate doesn’t need to be constant but could also be exponential. The demand for a minimum viable product (MVP) or a new product, for example, might initially be quite limited. But once the product receives acceptance, sales growth could skyrocket. If there is a trend, the sales forecasting model should exhibit an upward or downward pattern. For example, the growth of product B is exponential and the growth rate needs to be reduced because otherwise, the number explodes. This is something you need to be very cautious about when building a sales forecasting budget.
A trend could also be combined with seasonality effects. Champagne, toys, umbrellas, and ice-cream are all textbook examples of products with seasonal demand businesses. Their sales volumes are heavily correlated to weather conditions or specific months. The growth rates of product C in the above table exhibit a seasonal pattern.
2. Launch of a new product & timing uncertainty
A new product introduction is always exciting, especially if the products are expected to generate lofty returns. However, the development of a new product/service is often plagued by hiccups and delays. This leads to uncertainty regarding which month you should start recording revenues in your sales forecast model. The number might end up being pushed back by several months.
3. Sales management
Your sales forecasting model also needs to be aligned with your marketing plan, sales plan, sales pipeline, and the size of the sales team. If you have insufficient sales reps or account managers to realize your sales target, the sales projections are based on thin air.
Many B2B organizations end up bidding or tendering for new business. The probability of signing a new customer differs according to the status of the negotiations. If you include a potential contract prematurely in your financial projections, you create a risk of underperforming relative to your sales budget. Only potential business deals with a sufficiently high probability of materializing should be included in your sales forecasts. Assigning a probability in your CRM to each stage of the contract negotiations and using that in your forecast can greatly increase the accuracy and reliability of your projected sales data. This probability should be based on historical data and vetted by sales leadership.
4. Marketing strategy
The top line of some businesses, especially SaaS, consumer apps, marketplaces, and e-Commerce, is very dependent on customer acquisition through marketing campaigns. If your conversion rates are low because of ineffective marketing campaigns, wrong product-market fit, or poor sales funnel architecture, your sales numbers are going to disappoint. That’s why it is important to measure your customer acquisition cost and conversion rates.
There are several widely accepted forecasting techniques. Choosing among them is a judgment call based on what’s most appropriate to your particular context. You might also consider forecasting with several approaches and studying whether those approaches converge. If they don’t, it can help you refine your thinking about how the business works and the best forecasting technique for yours. In our sales forecasting template, we used a mixture of different forecasting techniques in column O and left some comments for you in column AB.
One way to think about tops-down vs bottom-up sales forecasting is that the tops-down forecast represents factors the business has less control over, and the bottoms-up forecast represents the business’s operational ability to execute. If you rely only on a tops-down forecast, it’s easy to get caught up in your own hype without a realistic plan (or budget!) to deliver. If you rely only on a bottoms-up plan, you’ll never push the business beyond its comfort zone, and people’s natural desire to underpromise and overdeliver will compound in every department and at every level, and the business will likely underperform its potential. That’s why it’s best to use both forecasting approaches and triangulate between them. In addition, watching key SaaS metrics like CAC, magic number, and others, can help ensure the plan is aggressive but realistic.
The table below illustrates the difference in granularity between the top-down approach and the bottom-up approach.
There are only a few techniques that FP&A professionals use widely in creating robust forecasting models. These techniques fall in two major groups:
Don’t spend too much time on getting exact values for every minor driver. Instead, spend 80% of your energy on those inputs that have a major impact on the sales forecast of your company.
Establishing accurate sales forecasts is hard. That’s why even well-established, well-funded, public companies regularly miss their revenue targets or revise them down because their outlook is no longer achievable. However, the following best practices go a long way toward creating a credible sales forecast model.
OnPlan FP&A software was built to help you avoid common mistakes and evolve your forecast thanks to incoming, real-time information. Use our platform to become a master of your data and overcome the challenges of spreadsheets.Book a Demo Now
The sales forecasting budget is a vital driver of pro forma financial statements. It is the first budget in the master budget cycle that drives the development of all other budgets and creates the capacity for the business to operate. While a reliable sales budget is a prerequisite for the company’s financial plan and management to take appropriate decisions, it can be tough to create an accurate sales forecast. This is because the market environment is very complex, dynamic, and historical relationships might not be valid in the future.
A robust sales model must be based on the collective input of all business partners, such as sales, marketing, production, and HR. Companies cannot rely only on Finance to develop the sales budget. Finance rarely possess the most accurate and latest information to make assumptions. Even the best model is likely to contain inaccuracies. It should be perceived as the company’s best guesstimate given the information that was available at the time.
Strategic thinking, storytelling, problem-solving, and objectivity are four soft skills that set aside the best FP&A analysists. Here’s why.
June 17, 2022 1 min read
In this article, we’ll cover some board report essentials: their purpose, general structure, and writing tips. We’ll also provide you with a board report template you can customize to fit your needs.
June 17, 2022 2 min read
Top-down vs bottom-up forecasting? Which option should you go for?
June 15, 2022 1 min read
The story of how OnPlan was founded, our CEO playing basketball with P Diddy, and much more.
June 3, 2022 1 min read
Learn how OnPlan gives your model superpowers.Book a demo