Financial Forecasting for Small Business, Step by Step

What a forecast does for you

A forecast shows where your cash is headed so you can act early: cut a cost, collect faster, hire later or arrange funding before you need it.

Budgets say what you plan to spend. Forecasts say what you expect to happen. The two work together, but the forecast is the one you update, because reality moves.

The most valuable output is not a profit number. It is the month your cash balance is lowest. Knowing that month in advance gives you time to fix it. Our piece on cash flow vs. profit explains why those two can disagree.

Start with the data you already have

Pull 12 to 24 months of bank and sales data. Past patterns are the best starting point for any small business forecast.

Gather these before you open a spreadsheet:

• Monthly revenue by product, service or customer type
• Fixed costs such as rent, insurance, software and salaries
• Variable costs such as materials, shipping and card fees
• Loan payments and tax payments
• Typical days to get paid by customers and days you take to pay suppliers

Clean bookkeeping makes this much faster. If your records are behind, start with bookkeeping tips and catch up first.

Build the revenue line with a clear assumption

Forecast revenue from drivers you can name, such as customers times average sale, rather than a flat percentage guess.

Choose one method and write down the assumption behind it:

1. Run-rate. Use the last three months as the base and apply seasonality from last year.
2. Driver-based. Multiply expected customers or jobs by average order value.
3. Pipeline-based. For service firms, weight signed work and likely proposals by the chance of closing.

Illustrative example: 120 customers a month at an average sale of $400 gives $48,000. If you expect to add 10 customers a month, build that into each month, not as a lump. For more on the options, see forecasting methods.

Turn revenue into cash timing

Revenue is not cash. Shift each month's sales by how long customers take to pay, and shift costs by when bills actually come due.

If customers pay in 45 days, January sales arrive as cash in late February or March. Rent and payroll do not wait. Lay out a month-by-month cash table:

• Opening cash
• Plus cash collected from customers
• Minus payroll, rent, suppliers, taxes and loan payments
• Equals closing cash

Look for months where closing cash falls below the amount you need to cover about a month of expenses. That is your warning line. See cash flow forecasting for a deeper look.

Run three scenarios, not one

Model a base case, a downside where sales drop and a stronger case. The downside tells you how much cushion you really have.

Build a downside with sales 15 to 20 percent lower and costs mostly unchanged. If cash still holds, you are resilient. If it hits zero in month five, you know exactly what you need to change or arrange in advance. The stress test for payments if revenue drops follows the same logic for loan payments.

Update the forecast monthly. Replace the forecast figure with the actual figure, then adjust the months ahead. A forecast you never revisit becomes decoration.

Using the forecast to decide on funding

A forecast tells you how much you may need, when, and whether the project funded will pay it back from its own results.

If the forecast shows a gap in month six, you can size it. Perhaps you need $60,000 to cover inventory before a busy season, and the season adds an expected $35,000 in profit. That supports a funding cost of well under $35,000. If the gain is smaller than the cost, skip it or change the plan.

ROI Funder funds from $5,000 to $5,000,000 for businesses with 500+ FICO, 6+ months in business and $20,000+ in monthly revenue. A business line of credit suits uneven gaps you can draw and repay. Our team's track record is $2B+ funded across 40,000+ businesses, and applying takes minutes with a soft credit pull.