What it means
A cash flow schedule shows what you expect to happen. Cash flow modelling is the discipline of building that schedule so the numbers respond automatically when an assumption changes, which is what makes it useful for decisions rather than just reporting.
The distinction matters because businesses rarely need to know what happens if everything goes to plan. They need to know what happens if sales run 15% behind, if a large customer stretches payment from 30 to 60 days, or if a price increase lands three months late, and a driver-based approach answers those questions in seconds.
The core technique is to separate assumptions from calculations. Sales growth, collection profiles, gross margin, headcount and payment terms live in a clearly marked input block, and every downstream figure is a formula referring back to those inputs rather than a typed number.
Collection profiles are usually the single most valuable driver. Rather than assuming customers pay the month they are invoiced, the model splits receipts across months according to observed behaviour, so a business that collects 60% in the month of sale and 40% the month after can see the cash consequence of growth immediately.
Good practice then adds scenarios and sensitivities. A scenario changes several assumptions together to describe a coherent story such as a recession, while a sensitivity moves one variable at a time to see which assumption the answer depends on most.
Boards usually find the sensitivity table more useful, because it identifies where to focus attention.
In practice
Real-world examples.
Example
A logistics company builds a driver-based model linking fuel cost to a diesel price assumption and sees that a 20 cent per litre rise would consume its entire monthly cash surplus. It hedges half its expected volume as a result.
Example
A software business models three scenarios for a new product launch and finds that even the downside case stays cash-positive, provided hiring is delayed until the third quarter. The board approves the launch with that condition attached.
Example
A hotel operator runs a sensitivity table across occupancy rates and finds that cash flow turns negative below 54% occupancy. Management sets that figure as the trigger for cutting agency staffing.
Think of it
“Cash flow modeling is forecasting future cash flows-building a detailed projection of money in and out.
Formula
Calculation
Cash Receipts in a month = (Current Month Sales x Same-Month Collection Rate) + (Prior Month Sales x Following-Month Collection Rate)
Net Cash Flow = Cash Receipts - Cash Payments
A wholesale business has sales of $600,000 in month one and $700,000 in month two. History shows 60% of sales are collected in the month of sale and 40% in the following month.
Month 2 receipts = (0.60 x $700,000) + (0.40 x $600,000) = $420,000 + $240,000 = $660,000
Cash payments in month two are supplier purchases at 55% of current sales, which is 0.55 x $700,000 = $385,000, plus payroll of $150,000 and overheads of $60,000.
Total payments = $385,000 + $150,000 + $60,000 = $595,000
Net Cash Flow = $660,000 - $595,000 = $65,000
If the model is then flexed so that only 40% is collected in the month of sale and 60% the following month, month two receipts fall to $280,000 + $360,000 = $640,000 and net cash flow drops to $45,000, showing how sensitive the position is to collection behaviour alone.Case study
Seen in the real world.
The following is an illustrative and entirely fictional example. Ravensworth Instruments, an invented maker of laboratory equipment, was deciding whether to accept a large contract from a national health provider that would double its revenue.
The finance team built a driver-based projection rather than a single forecast. The inputs included a 90-day collection profile demanded by the customer, materials at 48% of sales payable on 30-day terms, and $340,000 of additional working capital tied up in inventory during the ramp-up. The base case showed the contract was highly profitable but consumed $1,100,000 of cash before it returned any.
Sensitivity testing showed the answer hinged almost entirely on collection days: at 60 days the contract was self-funding, at 120 days it required a facility the company could not obtain. Management negotiated staged milestone payments, accepted the contract, and used the projection to secure a $900,000 facility sized directly from the modelled low point.
Watch out
Common mistakes.
- Typing hard-coded numbers into calculation cells, which breaks the link between assumptions and results and makes scenario testing impossible.
- Building an elaborate projection with dozens of tabs when three or four well-chosen drivers explain almost all of the movement.
- Treating the base case as a prediction rather than one of several plausible outcomes, and never testing the downside.
Questions
People also ask.
What is the difference between a cash flow model and cash flow modelling?
The model is the artefact, the spreadsheet itself, while the modelling is the practice of building, flexing and interpreting it.
How many scenarios should a projection include?
Three is the usual standard, a base case, a downside and an upside, with a sensitivity table showing which single assumptions matter most.
Do I need specialist software?
No, a well-structured spreadsheet handles most business needs, and dedicated tools add value mainly for complex group structures or multi-currency consolidation.
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%