What Is Sales Forecasting

Forecasting sales is an activity often performed inaccurately, with growth figures either being anchored around a target of "inflation + x", or an unrealistic round number plucked from thin air. In this tutorial, we explain the process of sales forecasting and how a correct process can help businesses in other areas, beyond just setting top-line targets.
Full
profile
Aarish ShahUnited Kingdom
Aarish's led businesses for over a decade and is currently the CFO of an educational tech business powered by Eton College. He has also executed greenfield projects and secured over $10 million in venture, debt, and working capital funding. He now freelances to tackle a variety of business challenges and to help technology startups and scale-up founders understand and model their financial needs, secure investments, and build scalable businesses.
[click to continue…]
Financial ForecastingFinancial ModelingFinancial Planning & Analysis (FP&A)
Hire
Full
profile
Marty MooneyUnited States
Marty is a private equity professional who also has experience working inside small- and medium-sized businesses in a wide variety of industries. He has led M&A processes and also helped CEOs create and drive strategies. In addition to closing private equity deals, he has raised debt and equity financing, built financial packages and financial models, worked as an interim CFO, and has helped start businesses.
[click to continue…]
Financial ForecastingFinancial Planning & Analysis (FP&A)Financial ModelingMergers & Acquisitions (M&A)Valuation
Hire
Full
profile
Jordan T. MezoffUnited States
Jordan is a driven senior finance professional with extensive experience developing dynamic financial models for M&A transactions, growth strategy evaluation, P&L forecasting, pricing, etc. He has also leveraged his leadership experience to execute several M&A and commercial deals, as well as business process optimization and cost savings initiatives. Jordan now freelances to enjoy the excitement of M&A consulting and the freedom of remote work.
[click to continue…]
Financial ForecastingMergers & Acquisitions (M&A)Financial Planning & Analysis (FP&A)Revenue & Expense ProjectionsFinancial ModelingThree Statement Operating Model
Hire
Full
profile
Olivia PassoniAustria
Olivia has helped over 30 early-stage entrepreneurs globally plan realistic financials, adapt their strategy and prepare for their fundraising or exit by maximising their value over the long-term. Olivia has advised companies and investment firms of any size in valuation, M&A transactions and financing. She enjoys independent consulting work as it allows her to tailor projects to each client and provide higher quality and transparency.
[click to continue…]
Financial ForecastingValuationRevenue & Expense ProjectionsFinancial Planning & Analysis (FP&A)
Hire
Full
profile
Petar Jordan ZivkovicSerbia
Petar currently leads the controlling and strategy division of Air Serbia with a €250 million budget. Previously at Deloitte and PwC, he also worked on 20+ M&A projects and various audit, valuations, and restructuring engagements in Eastern Europe, serving industries such as oil & gas, pharmaceuticals, and trade. Petar freelances to advise clients on complex financial modeling and due diligence, and link business and finance perspectives.
[click to continue…]
Financial ForecastingThree Statement Operating ModelFinancial ModelingValuationFinancial Planning & Analysis (FP&A)Mergers & Acquisitions (M&A)Market Segmentation
Hire
Full
profile
Miki MitsuokaUnited States
Miki is an experienced finance professional with over ten years of experience. She has worked closely with C-level executives providing complex analysis, including M&A transactions and due diligence, forecasting, budgeting, modeling, company valuations, and ROI analysis. She has earned the CFA designation and passed all four CPA exams. Miki enjoys the flexibility of freelancing while helping clients with their financial analysis needs.
[click to continue…]
Financial ForecastingThree Statement Operating ModelComparable Company AnalysisRevenue & Expense ProjectionsFinancial Modeling
Hire
Full
profile
Michael OlafusiNigeria
Michael is an independent financial consultant with particular expertise in dashboards and modeling. He has worked with three of the largest telecommunications companies in Africa and built a dynamic portfolio model for a Canadian investment firm. He is one of the 125 Microsoft Excel MVPs in the world, which is the highest level of recognition Microsoft gives an expert in the real-world use of Microsoft Excel for business solutions.
[click to continue…]
Financial ForecastingMarket Research
Hire
Full
profile
Brad CarlsonUnited States
Brad helps clients execute high stakes M&A, capital-raise and real estate transactions. Since 2014, he’s advised PE firms, real estate investors, family offices and global companies on 80+ on-demand projects, with stellar results. This is his full-time job. It allows him to focus on what he does best and enjoys most—preparing investor-ready deal materials and delivering objective, fact-based advice in support of mission-critical transactions.
[click to continue…]
Financial ForecastingFinancial ModelingThree Statement Operating ModelMergers & Acquisitions (M&A)Financial Planning & Analysis (FP&A)
Hire
Full
profile
Mathieu AudetCanada
Mathieu has executed over $4.5B in M&A transactions and $2.0B in debt and equity financings while working at a leading investment bank (National Bank of Canada). He's experienced with both high-growth startups and global corporations in industries such as TMT, engineering and construction, retail, industrial, packaging, and real estate. He freelances to support executives in capital raising, M&A, corporate finance, and venture capital projects.
[click to continue…]
Financial ForecastingFinancial Planning & Analysis (FP&A)Financial ModelingComparable Company AnalysisValuationThree Statement Operating Model
Hire
Full
profile
Michael VietenUnited States
Mike has worked with dozens of clients—helping startups raise $250,000 to $10 million all the way up to helping larger companies execute due diligence on $100 million to $5 billion transactions. Mike started his career as an equity research analyst—covering the restaurant and food supply chain sectors. He later received his MBA from Columbia. He primarily helps his clients with financial modeling, M&A due diligence, fundraising, and pitch decks.
[click to continue…]
Financial ForecastingFinancial Modeling
Hire

In its simplest terms, sales forecasting is the process of estimating future sales (revenues). At first, this may sound like both a vague and daunting task, but with some application it can be achieved relatively painlessly. Forecasting sales is neither guesswork nor exact prediction; it is a process of understanding the underlying assumptions and drivers of sales and eventually tracking and managing them.

As we will describe later in the article, there are many models and methods used to forecast sales, both qualitative and quantitative. The good news, though, is that there is usually no need for complex quantitative forecasting models. Although the probability of finding the exact future sales is almost zero, the accuracy of sales forecasting is crucial for projecting out financial statements and empowering smart business decisions.

Some of the most popular sales forecasting methods used are based upon historical data. This can be more realistic for an established company; conversely, a startup must use more creative sources of information.

Sales Forecasting Is Not a Waste of Time

There is empirical evidence that demonstrates the importance of sales forecasting for a company’s success. Some factors that contribute to this are:

  1. Strategic decisions and action tools: Sales forecasts can reveal trends or issues and provide necessary guidance in order to capitalize upon them, or indeed rectify them. For instance, a negative deviation of 20% against the sales target could point towards signs of bad management or competitors upping their game. On the other hand, a significant positive upswing will obviously be welcomed, but then suggests that more resources will be required going forward (e.g., recruiting more people). Uncovering potential problems and needs in advance can allow for timely action that will seize upon opportunity.

  2. A path forward: A downward deviation from a sales forecast is disappointing, but it can also be a chance to draw a line in the sand. It can help for clear goals to be set and serve to motivate the team through meaningful action plans and milestones.

  3. Forecasting financial models: Careful sales forecasting plays an important role within numerous financial modelling exercises:

    1. Cash Flows: Sales revenues directly affect cash flow. The accurate estimation of sales can offer insights towards cash movements and thus allow planning for future shortfalls or, indeed, windfalls.

    2. Inventory: A good sales forecast accommodates assumptions such as changes in customer habits and macro increases or decreases in demand. This allows for efficient inventory planning and subsequently drives working capital efficiency higher. On a more tangential basis, this then spills over toward better planning of raw material inputs and labor hiring.

sales forecast visualization

Factors to be Aware of When Forecasting Sales

As we mentioned above, sales will almost always deviate from their forecasts. The higher the standard deviation from this prediction, the higher the magnitude of knock-on effects on the business.

Forecasting analysts need to give thought to potential scenarios and/or have a contingency plan in place. Incidents far beyond the control of the business can occur with untold ramifications for its operation. Such examples include unexpected economic factors (e.g., stock market slumps) and legislation or policy changes.

Although sales forecasting is vital, it should never be a lone scapegoat. If predictions fall wildly short, a firm can suffer significant losses and loss of market share. Instead of blaming the forecast, a holistic post-mortem is required to look at how all factors of the business contributed to the disappointment.

Qualitative and quantitative forecasting methods each have idiosyncratic characteristics that one must pay attention to. Within qualitative methodologies, due to their subjective nature, one needs to shape a holistic view and then qualify it further with well-rounded and credible research. On the other hand, quantitative forecasting models can reveal trends, but still could suffer from biases such as the correlation/causality paradigm.

Finally, sales forecasts are critically interconnected to the general strategy of a company and its high-level milestones. Forecasting models are dynamic and therefore need to be continually updated when conditions change.

What are the Main Sales Forecast Approaches?

There are two main approaches for sales forecasting: “top down” and “bottom up.”

  • Top down: In a top-down approach, we start with the big picture and then work downwards; we define the milestones that need to be achieved in order to reach the target. For instance, if there are 1.8 billion smartphones worldwide and we assume that we want to penetrate 1% of the market, our target number of customers will be 18 million. If done in a rushed and ill-defined way, this can give rise to tenuous situations with unrealistic expectations.

  • Bottom up: In a bottom-up approach, we look at micro assumptions based on the resources that the company holds—for example, how many sales can be made per salesperson, or how many times an advertisement will be converted into a sale. This method allows businesses to look at the efficiency of their current operation and isolate means in which they can tweak factors to increase sales. The more data that the business has from prior performance, the more accurate its forecasts can be in this area.

Which Approach Should We Take?

As the descriptions above show, the top-down approach may result in subjective, overly-optimistic predictions, but it is useful for swiftly establishing clear milestones that can become organization-wide benchmarks. Forecasts derived using the more granular, bottom-up approach will typically end up being more conservative by comparison, yet more accurate due to their emphasis on internal capabilities. For sales forecasting purposes, as is the case with financial modeling in general, the bottom-up approach can give a more structured, realistic perspective, which can be complemented from a strategic perspective with some top-down analysis.

sales forecast upward growth

What are the Main Methods for Sales Forecasting?

As previously mentioned, there are two principal methods of sales forecasting: quantitative sales forecasting and qualitative sales forecasting.

Quantitative Sales Forecasting

Quantitative sales forecasting pertains to the gathering and analysis of numerical data, such as consumer spending and economic trends. There are many quantitative models and their forms vary significantly. In their simplest form, they appear as linear models and look like the following:

Y = a0 + a1X1 + … + anXn

These formulas can quickly become more complicated when testing, trends, and seasonal effects enter the picture. While quantitative methods might not be very appropriate for a new business that has no track record, they can be very useful for established ones. Take an example of a mid-sized clothing company; a quantitative model could enable it to discover seasonal trends and other cyclical effects. This would offer them more accurate sales forecasting and, consequently, prudent inventory planning.

Qualitative Sales Forecasting

Qualitative sales forecasting is based upon expert and/or personal opinion. This method is particularly suitable when there is a lack of historical data. There are four main categories of qualitative forecasting:

  1. Jury of executive opinion: This method gathers opinion from a group of company executives and then compiles them to form a consensus. It is quick, easy, and based upon informed opinion. However, not all executives are equally experts in sales and, subsequently, their opinions might not carry equal weight within commercial realities.

  2. Delphi technique: Similar to the previous method, this technique averages opinion from a firm’s executives, but in addition, augments it with counsel from external experts. Although it can lead to more rounded results, it is more time intensive and typically more expensive.

  3. Sales force composite: This technique gathers opinions from the sales force, which can lead to well-informed and inexpensive sources of sales forecasts. However, the sales force may not have access to the strategic insights that managers have. Perverse incentives may also come into play, where, for example, the sales force forecasts lower-than-expected sales in order to make benchmarks easier to hit.

  4. Survey of buyer intentions: This method focuses on the demand-side and the intention of the consumer to buy a product or service. By focusing on the final client, the forecasts can be relatively accurate because some layers of information can be found through reliable public data (e.g., economic indicators of the US Census Bureau)

A firm should use a hybrid of these methods in order to achieve holistic forecasts based upon robust assumptions, placing more or less weight on a technique depending on its applicability to the business. For example, a company with a relatively inexperienced sales force may not want to value the results of a sales force composite projection too highly. Given the nuance involved in deciding upon the correct approaches and weighting, a rational approach can ensure that a business will arrive at accurate forecasts. In deciding the mix of methods required for a forecast, the input of an expert can provide valuable perspective and knowhow.

Building Your Own Sales Forecasts

The math to calculate net sales is simple. We just multiply the forecasted units to be sold with the expected price and we reach the sales forecast. We then perform a similar process for direct costs. After subtracting these (COGS) from sales, we reach the net sales.

Moving away from absolute numbers, if we divide the net sales by gross sales, we can see the expected gross margin. We should do this for every month of the first year and then for every quarter for the following two.

Start with the Costs

A business has more control over its expenses compared to its revenues. Therefore, expenses presents an easier place to start at from a forecasting perspective. We can create categories of costs and then analyze each category granularly to help us find more accurate waypoints. For instance, if marketing is a significant driver of sales, instead of being placed as a single number under a generic category of overhead, we can segment it further (e.g., Google Ads, social media ads, etc.) for greater accuracy.

Develop and Check Sales Assumptions

We should include the costs in the assumptions tab. It is critical that these are reviewed every month and, if necessary, that the sales are also revised accordingly. As is the case with financial modeling, these assumptions must be flexible and easily changeable. High quality and relevant (cited) sources are also critical. For example, data from app stores can help sales forecasting for a new mobile app while credible tech blogs can also provide anecdotal evidence that can be applied into assumptions. The key final factor for developing appropriate assumptions is having relevant previous experience developing sales forecasts. If a company does not have the expertise required, it is better to hire specialist talent, even if for a short period. Below is an example of sales and cost assumptions built out for a forecast:

Forecasting Sales for Two Scenarios

Sales forecasts should include a conservative scenario and an aggressive/optimistic one. The latter is the ideal outcome that can keep the company motivated and also serve as an illustration of its true potential to investors. This is the “think big” factor. The former is the scenario that keeps the company prepared for disappointing outcomes. Furthermore, it is better to break down sales into prices and units, which allows for deeper understanding of their respective dynamics. In addition, estimating intervals and probabilities can lead to more accurate projections.

Complementing the Data with Ratios and Graphs

Ratios can reveal key information while also serving as tests to confirm whether the sales forecasting is sound and if the numbers tie up. For instance, a direct cost to revenue ratio that is too low (and subsequently, a gross margin ratio that is too high) could be an indication of overly-optimistic projections. Another useful ratio is the employees-per-client ratio. This ratio offers insight regarding future sales and how they can evolve based on recruiting decisions. Finally, graphs can help visualize trends and the progress of the sales, rendering the numbers more comprehensible.

sales forecast chart and graph

And Finally, Beware of Templates

It can be easy to just search for a template and try to shoehorn your business’ requirements into what has already been created. This approach could actually be to your detriment, as each business has its own needs and no one is the same.

I would encourage you to try building your own template from scratch using the learnings from this article. Starting the process from a blank spreadsheet will help you to understand how all facets of your business tie together and ensure that your forecast is exactly tailored to your business’ specific needs.

Hire a Top Forecasting Consultant Now