How to prepare financial forecasts for your business

Start by identifying the decision: launch a new business, buy equipment, open a location, pursue financing or manage day-to-day liquidity. The model should show expected revenue, expenses, investment, financing and cash movements.

A lender may ask for evidence that a proposed loan can be repaid even when sales are weaker than expected. Management may need a more detailed weekly or monthly cash outlook. Align your model to the use case and clearly state the period covered.

Build a list of drivers before adding complex spreadsheets: prices, volumes, seasonality, customer payments, staffing, supplier terms, equipment and borrowing costs. Record each assumption's source, date and confidence level.

Use historical sales where available, adjusting for known changes. For a new venture, rely on quotations, customer tests and relevant market evidence. A growth rate without an explanation should be marked as an assumption, not a fact.

For services, estimate billable units times average price. For retail, estimate transactions times average basket size. For subscriptions, consider active customers, new subscriptions, cancellations and the price of each plan.

Forecast at the monthly level where timing matters. Ensure the expected volume fits your staffing, opening hours, supply chain and marketing approach. A year-one business should not assume full capacity from day one without evidence.

Variable costs often rise with each sale, while many fixed costs remain payable even in a slow month. Estimate direct materials and commissions separately from rent, software, insurance and payroll. Include relevant employer costs rather than treating net wages as the full payroll expense.

Buying long-lived equipment is a cash outflow, but its accounting expense may be recognized through depreciation over time. Distinguish the income statement from cash flow to avoid double counting or missing significant payments.

The income statement estimates revenues minus costs and expenses over the selected period. Subtract direct costs from revenue to obtain gross profit, then operating expenses, depreciation, interest and applicable taxes to estimate net income.

It does not necessarily equal cash in the bank. A customer may be invoiced this month but pay later, and principal repayments reduce cash without being an income-statement expense.

Begin with opening cash. Add expected customer receipts and financing inflows, then subtract suppliers, payroll, taxes, capital purchases and loan payments when the cash is expected to move. Closing cash equals opening cash plus receipts minus payments.

Timing is crucial. A January sale collected in March does not pay a February bill. Likewise, inventory purchases and investment deposits may come before the related revenue. A profitable business can still experience a cash shortage.

Track the lowest balance and maintain a realistic contingency. A short-term weekly outlook may be needed if liquidity is tight.

Record each proposed or confirmed financing source, expected drawdown, principal, interest rate, payment schedule and fees. Interest usually affects the income statement, while interest and principal repayments both affect cash.

Test whether cash flow can support debt payments under less favorable sales and cost assumptions. A financing package that balances initial costs may still lead to a cash shortage later.

Change key underlying drivers, not just the final revenue total. Direct costs may move with sales while rent and other fixed costs remain unchanged. Consider slower collections, delayed opening, wage increases and higher input costs.

Compare gross margin, operating result, lowest cash balance and repayment headroom for each scenario. Identify actions you could take if important thresholds are missed.

Review formulas, signs, units and periods. Do not mix annual cost figures into monthly rows. Clarify whether a growth assumption applies each month or each year.

Once trading begins, compare actual and forecast prices, volumes, expenses and customer collections. Keep the original forecasts for learning and update future assumptions as better evidence becomes available. Consider professional accounting review when documents will support lending or investment decisions.

Summarize forecast revenue, direct margin, fixed costs, financing needs and lowest expected cash balance. Explain what drives changes over time, such as recruitment, new equipment or a marketing launch.

Keep evidence such as quotations, customer tests and past financial statements accessible. A transparent model with realistic assumptions is more useful than a highly precise number without support.