What it means
A founder planning a new store may estimate customers, average spend, staffing, rent, inventory and capital spending, and the model converts those drivers into revenue, expenses, assets, liabilities and cash movement. A lender may use it to understand repayment capacity, and management may use it to test hiring or pricing.
The value comes from clear assumptions and consistent links between statements, not from producing a precise-looking spreadsheet. Start with operational drivers: forecast units sold and unit price by product, account for returns and discounts, and estimate variable cost from expected volumes and fixed costs from contracts or headcount plans.
Document when revenue is recognised and when the customer pays, because profit and cash are different. A sale on credit may increase forecast revenue before cash arrives, and inventory purchases, tax payments and loan repayments can create cash pressure even in a profitable period.
A linked balance sheet helps catch errors, since projected sales that require more inventory and receivables need financing. Equipment purchases increase assets and reduce cash or raise debt, and depreciation later affects profit but is not the original cash payment.
Debt repayments reduce a liability and cash, not operating expense in full, so reconcile opening cash plus forecast net cash flows with closing cash and check that assets equal liabilities plus equity after each period. Build at least a base case and a plausible downside case, because a small change in volume, collection time or gross margin can have a large effect on cash headroom.
Sensitivity tests should name the changed input and avoid quietly changing several assumptions at once. An acquisition model may include integration cost and financing and a new product model may include development and launch costs, while forecast periods should fit the decision and data available rather than extending a smooth growth rate indefinitely.
Compare the forecast with actual results regularly, separating changes in volume, price, cost and timing, and revise assumptions openly. A missed target is information, not a reason to overwrite the old forecast without an audit trail.
Lenders and investors should be able to see the date, scope, accounting basis and major risks, so do not present a forecast as audited historical performance or conceal a sensitivity that is central to the decision. For small businesses, a practical forecast can be simple if the drivers are credible, so use a transparent monthly cash model before adding complex detail.
Check whether a planned expansion consumes cash before generating revenue and whether an emergency reserve is needed. The model supports a choice; it cannot remove uncertainty about customer demand, supplier prices or execution.
In practice
Real-world examples.
Example
A cafe models customer visits, spend and payroll before opening a second location.
Example
A lender reviews projected cash receipts and debt service under a downside case.
Example
An acquisition forecast includes integration expenses rather than just combining revenue totals.
Formula
Calculation
Illustrative forecast revenue = Prior-period revenue x (1 + Assumed growth rate)
Illustrative forecast operating profit = Forecast revenue - Forecast operating costs
Worked example. An invented company had $5 million of revenue. Its scenario assumes 20% growth and costs equal to 80% of projected revenue. Revenue is $5,000,000 x 1.20 = $6,000,000, and costs are $6,000,000 x 80% = $4,800,000. Simplified operating profit is $6,000,000 - $4,800,000 = $1,200,000 before any omitted items.
This example does not show tax, financing, capital spending or collections; a full three-statement forecast would. If customers paid 60 days late on $1,000,000 of the sales, closing cash would be $1,000,000 lower than profit suggests.Case study
Seen in the real world.
This illustrative and entirely fictional example follows Cedar Kitchens, an invented cabinet maker. It planned a second workshop and first produced a forecast that simply raised last year's sales by 25%. A manager noticed the plan required new equipment and more material stock months before customers would pay. The team rebuilt the model around orders, production capacity, deposits, delivery dates and supplier terms. It added a balance sheet and monthly cash flow, then tested slower customer collections.
In the invented downside case, the business needed additional short-term funding even though annual profit remained positive. Management staged the equipment purchase and set a cash buffer before signing the lease. The forecast did not predict the future exactly. It exposed the timing risk that a profit-only estimate had missed.
Watch out
Common mistakes.
- Calling projected numbers actual or audited financial results.
- Forecasting profit without modelling receivables, inventory and cash timing.
- Using precise-looking growth rates without sources, sensitivities or update dates.
Questions
People also ask.
What is a pro forma forecast?
A forward-looking financial model showing possible results under stated assumptions.
Is it the same as a budget?
They can overlap, but a budget is often an internal operating plan; a pro forma forecast may show a transaction or scenario for a specific audience.
Why include cash flow?
Profits can be recorded before customers pay, while investment and debts require cash at specific times.
From the founder's library
Take it further with the book.
Build your financial confidence beyond this definition. Shihan's full-length guide, Accounting Fundamentals, takes the same plain-English approach and turns it into a complete, practical playbook for non-finance managers, business owners and students - with chapter-end quiz answers and presentation slides included.
25% off with code MMHQ25, applied at checkout. Priced in USD - checkout may show the equivalent in your local currency.
View the book and save 25%