Revenue Forecasting: How to Predict Sales Without Guessing

Why a forecast is worth the hour

A forecast tells you when cash will be tight, when you can afford to hire or buy equipment, and how much room you have to take on a payment.

Most owners watch their bank balance and react. A forecast moves you from reacting to planning. It shows a slow quarter before you are in it, which gives you time to cut costs, collect receivables or arrange financing on your terms.

It also keeps big decisions grounded. Adding a second shift or a new truck looks smart in a busy month. A forecast tests whether the extra revenue will show up in the slow months too.

Start with twelve to twenty-four months of history

Pull monthly revenue from your accounting software or bank statements. Past sales show your base level, your growth rate and your seasonal pattern.

List revenue month by month. If you have two years, put the same months next to each other. Look for three things:

• Level. What does a normal month look like?
• Trend. Is the same month up or down from last year, and by roughly how much?
• Season. Which months are consistently strong or weak?

Remove one-time events, such as a single huge order or a month closed for repairs, or at least mark them. Otherwise they distort the pattern.

Three simple methods you can use

The most practical methods are a prior-year comparison with a growth rate, a pipeline-based forecast, and a bottom-up count of customers times average sale.

1. Prior year plus growth. Take last year's month and apply an expected change. If June was $50,000 and you expect 5 percent growth, forecast $52,500. It is quick and works for stable businesses.

2. Pipeline. For service and project businesses, list signed work and open quotes. Weight each quote by how often you actually win that kind of job. An illustrative example: $100,000 of open quotes with a 30 percent win rate suggests about $30,000.

3. Bottom-up. Multiply expected customers or orders by average sale. Ten orders a day at $40 across 26 operating days gives $10,400 a month. Change one input at a time to see what moves the result.

Build three scenarios, not one number

Create a base case, a low case and a high case. Plan spending against the low case and treat the high case as upside.

A single number gives false comfort. Try this layout:

If fixed costs and debt payments are covered in the low case, you have a margin of safety. If they are not, you know how large the gap is and can plan for it.

Turn revenue into cash

Revenue is not cash. Forecast when customers actually pay, then subtract bills, payroll, taxes and loan payments to see your real cash position.

A sale in March paid in May helps your May bank balance, not your March one. Apply your average collection time to each month's revenue. Then lay out costs on the dates they are actually due.

This is where many profitable businesses get caught. Our piece on cash flow vs. profit explains the gap, and the cash flow analysis guide shows how to read it month by month.

Review the forecast every month

Compare actual revenue with the forecast each month, note the difference, and adjust. Over time your assumptions improve.

Add an actual column beside the forecast. When you miss by more than 10 percent, ask why. Was it timing, price, a lost customer or a seasonal shift? Write the reason down. After a few months you will see which assumptions you overestimate.

If the forecast shows a profitable opportunity that needs cash before it pays, such as inventory for a peak season, you can price the funding against it. ROI Funder shows true cost, payback period and monthly-equivalent payment before you sign, so you can check the return against your own forecast. Options include working capital and a line of credit.