A practical guide to cashflow modelling
A cashflow model is the clearest way to show a client their financial future. It's also easy to do badly. Here's how to make it land.
Cashflow modelling projects a client's income, spending, goals and life events forward year by year, so they can see whether the plan holds. Done well, it transforms an abstract conversation about pensions and pots into a picture a client actually feels: "I can retire at 62 and still be fine," or "if I don't change something, I run short at 84." That emotional clarity is the point.
Start from real data, not round numbers
The fastest way to lose a client's trust is a model built on guessed inputs. Income, outgoings, existing provision and goals should come from the fact-find — ideally flowing straight from a completed KYC profile rather than being re-keyed. When the model is grounded in the client's own numbers, the output is credible and the conversation is about decisions, not data entry.
The central forecast is the least interesting part
Every model produces a headline projection. Treat it with suspicion — it's a single path through a deeply uncertain future. The value is in what you do around it:
- Stress tests. What happens if markets fall 20% the year they retire? If they stop work at 58 instead of 65? If care costs arrive at 80? A plan that only works in the base case isn't a plan.
- Levers. Show the client the handful of changes that move the outcome most — retire two years later, spend a little less, downsize at 75. People engage with choices, not forecasts.
- Scenarios side by side. Comparing "plan A" and "plan B" on one screen makes trade-offs concrete in a way a single chart never does.
A good rule: spend less time perfecting the central line and more time showing how the plan behaves when life doesn't cooperate. That's where advice adds value.
Avoid false precision
Projecting a number to the pound across 40 years implies a certainty that doesn't exist, and clients can sense it. Round sensibly, talk in ranges, and be explicit about assumptions — inflation, growth, charges. A model that's honest about its uncertainty is more persuasive, not less, because it matches how thoughtful people actually reason about the future.
Make it a living document
A cashflow model isn't a one-off PDF; it's a baseline you revisit. Each review, update the inputs and show what's changed. Over time the model becomes the spine of the ongoing relationship — the shared map you and the client navigate together.
Try it. CapEmber's Cashflow Modeller builds year-by-year projections with stress tests and scenarios, standalone or grounded in live KYC data. Explore Cashflow Modelling →