How to Build a Cash Flow Model That Helps You Make Decisions

Revenue, profit and cash are related, but they are not the same thing.

A business can record a sale and still not have received the cash. It can also have a profitable period while facing a short-term cash shortage because payments and expenses occur at different times.

The SBA describes cash flow projections as a way to understand expected money coming in and going out and to identify potential shortages before they become major problems.

That is the purpose of the model.

It is not to predict the future perfectly.

It is to make the future visible enough to manage.

Start with the cash balance you actually have.

Then map expected cash movements by period.

Depending on the business, these may include:

• customer payments
• deposits
• subscriptions
• grants
• financing
• asset sales
• other receipts

These may include:

• payroll
• supplier payments
• rent
• software
• taxes
• debt payments
• equipment
• professional fees
• other operating expenses

For each item, use the expected payment date rather than only the accounting date.

Then calculate:

Opening cash + cash inflows - cash outflows = ending cash

The ending balance becomes the opening balance for the next period.

A forecast is only as useful as the assumptions underneath it.

The SBA recommends using reasonable assumptions, comparing forecasts with actual results, and understanding the drivers behind changes rather than treating a forecast as a fixed prediction.

For each major assumption, record:

• what you expect
• why you expect it
• what evidence supports it
• when you will revisit it

For example, if a customer normally pays 60 days after invoicing, do not model the cash as arriving immediately.

If revenue depends on a sales pipeline, separate signed contracts from opportunities that have not yet closed.

If payroll is fixed, use the actual committed amount.

Transparent assumptions make the model easier to challenge and improve.

Do not build only the version you hope will happen.

Create at least three views:

Base case: what you currently expect.

Downside case: what happens if an important customer pays late, sales arrive more slowly, or a planned cost increases.

Recovery or upside case: what happens if a major opportunity closes or a delayed payment arrives.

The purpose is not to predict which case will happen.

It is to identify decisions that become necessary under different conditions.

A downside scenario can reveal the month in which you would need to reduce spending, accelerate collections, change payment terms, raise capital or delay a purchase.

A forecast should change when reality changes.

The SBA specifically recommends comparing expected results with actual results and revising the forecast as new information arrives.

At the end of each month:

1. enter actual cash received
2. enter actual cash paid
3. compare actuals with the forecast
4. explain material differences
5. update future assumptions
6. identify decisions created by the new information

This turns the model into a management loop rather than a spreadsheet that is opened only during a crisis.

A bank balance tells you where you are.

A cash flow model helps you see what is coming.

Look for:

• a large payroll period
• a cluster of supplier payments
• tax deadlines
• debt repayments
• major equipment purchases
• delayed customer collections
• seasonal revenue changes
• commitments that begin before expected revenue

The useful question is not:

"How much cash do I have?"

It is:

"After all known commitments and reasonable scenarios, when does my cash position become uncomfortable?"

That is the point where the model becomes a decision instrument.

The categories should match the way the business actually receives and spends money. The SBA recommends aligning forecast categories with actual financial reporting and reviewing the drivers behind changes.

A good cash flow model should lead to decisions.

For example:

• Can we afford this hire now?
• Should we delay this purchase?
• Do we need to improve collections?
• Can we safely extend payment terms?
• How much cash should we reserve?
• When would additional financing become necessary?
• Which expense can be reduced without damaging the core business?

If the spreadsheet cannot change a decision, it may contain too much detail in the wrong places.

Keep the model rolling.

Every month, replace assumptions with what you now know, compare actuals with the previous forecast, and extend the horizon.

The SBA's financial guidance emphasizes that forecasting is useful because it connects sales, costs and cash to management decisions, not because it produces a perfectly accurate prediction.

That is the mindset worth keeping.

A cash flow model is not a crystal ball.

It is an early-warning system for the founder.

Related reading: \2 · \2

Use How to Build a Cash Flow Model That Helps You Make Decisions as a working document, not as a scorecard. Start by defining the decision or problem it is meant to clarify.

Write the situation, owner, objective, time horizon and constraints. Do not fill a field just because the template has one; mark it unknown when evidence is missing.

Use the smallest set of real inputs needed to make the decision. Prefer customer evidence, financial records, observed behaviour and documented commitments over assumptions.

Fill each section with a concrete observation or decision. Where two answers conflict, record the conflict instead of averaging it away.

End with: decision, owner, next action, deadline, risk, and what would change the decision.

Return to the document after the relevant period and compare the original assumptions with what actually happened. Keep the lesson, not just the completed form.

Do not use a completed template as evidence that the underlying problem has been solved. The tool improves thinking and consistency; the business result still has to be observed.