How to Forecast Sales

Computer on a desk showing graphs and tables with more computer monitors in the background

Predicting your sales accurately isn’t easy – and an accurate sales forecast serves many important purposes as a management tool. Be realistic when projecting sales and be prepared to explain the reasoning behind your forecasts.

If you have an existing business

If your business is established, you can base your sales forecasts on previous sales records. Use these figures to estimate your likely sales for the year ahead and break this down into monthly or weekly figures as required. Some guidelines include:

  • Forecasting the number of units – items made or sold, or hours charged – you expect to sell during the coming year for each product or service category group.
  • Allowing for current market conditions, seasonality or fluctuating sales trends, and expected business growth.
  • Identifying any internal factors that might affect sales next year in each category such as staffing changes, profit expectations, promotional plans or capacity constraints.
  • Recognizing any external factors such as inflation, competition and business trends.
  • Talking to your customers about their expectations. Will they continue to buy from you? Are they looking for something different? Can you supply it? In short, stay close to your customers.

If you have a new business

If you’re new to business and have no past trading record, you’ll have to take extra care in estimating sales because you don’t have historical records to refer to. Base your sales forecast on the work you’ve done to validate market demand, such as:

  • Solid market research.
  • Test marketing on a limited scale.
  • Sales already made or contracts secured.

Other factors to consider include:

  • Your marketing plans and any new products in the pipeline.
  • The total size of the market.
  • What sales competitors are achieving.
  • The impact of potential new competitors.

It’s also worthwhile interviewing potential customers and talking to suppliers and industry experts.

Are there any sales constraints?

Double check your forecast figures in relation to these potential issues:

  • Do you have the stock, staff and resources to achieve your projections?
  • Can your suppliers meet demand?
  • Have you considered seasonality?

What other constraints might affect your predictions?

Why sales forecasting is important

You need a sales forecast because sales provide the income for your business. Without sales, you have no business. A forecast enables you to set sales targets, budget effectively and complete a cash flow forecast.

An accurate forecast gives you the hard facts to make better business decisions. It will help you determine how much you can afford to spend and what you need to sell each week to cover running costs.

Be realistic about cash timing

Your sales forecast is about predicting the total sales you hope to make in the next year. Your calculations will feed into your cash flow forecast.

However, a cash flow forecast is about the timing of the money. Knowing which months will be cash short and which months might see a cash surplus is valuable business management information. You can find out when you might need a loan arrangement to tide you over, and when would be the best times to buy necessary assets for your business.

This means you need to identify when you’ll actually be paid for sales, so you can complete a cash flow forecast more accurately. Bear in mind that payment is often slower than anticipated. This common error can distort your cash flow forecast.

Timing will be affected by:

  • The credit terms your offer.
  • The effectiveness of your creditor management and debt collection.
  • Whether people are able to pay you on time.

Consider including a provision for bad debts, which are likely to be higher during an economic downturn.

Once you know how much income you’re expecting, and when to expect it, all that’s left is to put these figures into the correct weekly or monthly columns in your cash flow forecast.

Completing your forecast

Your sales forecast needs to be as accurate and reliable as you can manage. After all, you’ll be committing yourself to expenditure and loan repayments based on your forecast.

If you underestimate, you won’t be able to cover your costs. If you overestimate, you may not have enough working capital to cover your day-to-day cash requirements.

Consult with your key advisors and staff

Rather than preparing your sales forecast in isolation, involve the right people to get the best input and projections. Talk to your advisors and to employees with relevant responsibilities, like sales, marketing, purchasing and planning staff.

Get help from your accountant before presenting your sales forecast to lenders or investors. Prepare two versions – a worst-case scenario and a most-likely scenario. Over-optimistic forecasts can undermine your credibility and increase your business risk. 

This information is provided for general awareness purposes only and is not intended to be relied upon as legal or compliance advice.

This article is provided for informational purposes only. While the information contained within has been compiled from source[s] which are believed to be reliable and accurate, Comerica Bank does not guarantee its accuracy. Consequently, it should not be considered a comprehensive statement on any matter nor be relied upon as such.

Related Content