Cash Flow Modelling in Financial Planning

Ask most people how much money they will have at retirement, whether it will last their lifetime, and what income it can sustain, and they will give you an estimate based on intuition rather than calculation. Cash flow modelling replaces that intuition with structured, testable analysis — providing a financial map of the future that can be interrogated, challenged, and refined as circumstances change.

This guide explains what cash flow modelling is, how it works, the key inputs and their sensitivities, and how it applies to internationally mobile clients with complex financial arrangements.

What Cash Flow Modelling Is

Cash flow modelling is a software-based projection of an individual's financial position over time — typically covering the period from the current date to age 95 or 100. It takes all known financial data as inputs and projects forward using stated assumptions about investment returns, inflation, income, and expenditure.

The output is a graphical and numerical picture of the client's financial journey: how wealth grows during the accumulation phase, when it peaks, how it depletes during retirement drawdown, and whether it runs out before the planning horizon — or, alternatively, what legacy remains.

At its most basic, cash flow modelling answers three questions:

• Will I have enough? If I continue saving and investing as planned, will my wealth at retirement support the lifestyle I want for as long as I might live?
• Can I afford to retire earlier? If I stop earning at 55 rather than 65, what does that do to my lifetime financial position?
• What is the impact of key decisions? Taking a pension lump sum vs drawdown; selling vs retaining a business; making large gifts to children; buying a second property — how does each option affect the long-term picture?

The Key Inputs

The quality of a cash flow model depends entirely on the quality of its inputs. A comprehensive model for an internationally mobile high-net-worth individual will include:

Current position.

• Current age and planned retirement age
• Current savings and investments (pension funds, offshore bond, ISA, general investment accounts, other)
• Current debts (mortgage, other borrowing)
• Property values
• Business equity

Income.

• Current earned income (salary, self-employment, dividends)
• Expected future income streams (pension income from defined benefit schemes, state pension, rental income, expected business sale proceeds)
• When each income stream starts and ends

Expenditure.

• Current annual living costs
• Expected retirement expenditure (often modelled in phases: higher in "go-go" early retirement, reducing in mid-retirement as activity slows, potentially increasing again in late retirement with care costs)
• One-off planned expenditure: school fees, house purchase, business investment, planned gifts to family

Assumptions.

• Investment return assumption (typically gross before fees; the model should also reflect annual charges)
• Inflation assumption (typically CPI; sometimes split between general inflation and specific costs like healthcare or property)
• Life expectancy (planning age — typically 90–100; for couples, the later of both)
• Tax rates in retirement (income tax, CGT)

Protection and contingencies.

• Life insurance pay-outs (if modelled)
• Long-term care costs (if modelled as a scenario)

The Outputs

Projected wealth over time. A chart showing the value of accumulated wealth at each year, rising through the accumulation phase and falling during retirement drawdown. The key question: does the line hit zero before the planning horizon? If so, when?

Sustainable income in retirement. Given the projected wealth at retirement and the assumptions, what annual income can the client sustainably draw without running out of money before age 95? How does this compare with the target retirement income?

Minimum viable retirement age. If the client retires earlier than planned, at what age do they have enough saved to fund their retirement income to the planning horizon? This is often a powerful and surprising number — many clients find they have more flexibility than they realised.

Surplus or shortfall at planning horizon. If the model shows a surplus (wealth remaining at age 95), this can be read as an inheritance opportunity or a signal that the client is over-saving. If it shows a shortfall, this is a prompt to adjust the savings rate, the retirement age, or the target income.

Scenario Analysis: The Real Value of the Model

The greatest value of cash flow modelling is not the base-case projection — it is the ability to test scenarios. The key scenarios to model:

Optimistic, base case, and pessimistic. Run the same model with three different investment return assumptions — say 6%, 4%, and 2% real. If the pessimistic case still shows sufficient wealth, the client can be confident the plan is robust. If the pessimistic case shows a shortfall, contingency plans (more saving, later retirement, lower spending) can be discussed.

Longevity scenario. What if the client lives to 100 rather than 95? Does the plan survive? This is particularly relevant for couples — one partner outliving the other by 20 years is not unusual, and the survivor needs to fund that additional period alone.

Care costs scenario. What if a period of residential care — typically costing £50,000–£100,000 or more per year in the UK as at 2026 — is needed in the final years? Many clients have not modelled this and are surprised by its impact.

Early retirement scenario. If the client retires at 55 instead of 65, what changes? How much more savings are needed? Alternatively, does the existing pot already support this?

Large expenditure scenarios. Buying a holiday home; making a £500,000 gift to children; funding grandchildren's education. Each can be run as a scenario to see the long-term impact before a decision is made.

International Complications

For internationally mobile clients, cash flow modelling is more complex but even more valuable.

Multiple currencies. Assets and income streams may be in different currencies. A sterling pension, a USD offshore bond, euro rental income, and AED salary create a model with currency assumptions embedded. Exchange rate risk is a real input that is often ignored in standard models.

Multiple pension pots. Pensions from different countries vest and draw at different ages under different rules. Sequencing the drawdown of different pots for tax efficiency requires modelling across multiple income streams.

Variable residency plans. A client planning to live in three different countries in retirement — with different tax rates in each — needs a model that reflects the tax environment in each phase. A "UK tax rates throughout" assumption produces the wrong answer for a client planning to retire to Portugal or the UAE.

State pension uncertainty. UK state pension (and equivalent in other countries) is a significant guaranteed income stream that must be incorporated. For internationally mobile individuals with broken NI contribution records, the state pension amount is often uncertain — the model should use a conservative assumption based on the current NI record and reflect the gap-filling option if the client plans to make voluntary NI contributions.

Cash Flow Modelling Software: Adviser-Grade Tools

Specialist cash flow modelling software — tools such as Voyant, Cenario, Cashcalc, and others — is primarily used by financial advisers rather than individuals directly. These tools model complex scenarios, incorporate tax, handle multiple income streams, and produce professional-quality outputs.

The use of professional software by an adviser is not merely about access to technology — it is about interpretation and challenge. A skilled adviser using a cash flow model will push back on over-optimistic assumptions, identify risks the client had not considered, and help them understand the range of outcomes rather than anchoring on a single optimistic projection.

Basic cash flow modelling can be done in Excel for simple situations. For complex international financial positions, the investment in professional advice that includes proper cash flow analysis is typically well justified.

How Global Investments Can Help

Global Investments incorporates cash flow modelling as a core component of comprehensive wealth reviews for internationally mobile clients. We build multi-currency, multi-jurisdiction projections that reflect the full complexity of your financial position, test multiple scenarios, and use the results to inform decisions about retirement timing, savings structure, estate planning, and income drawdown strategy. If you have never seen a properly modelled projection of your financial future, contact us — the clarity it provides is often transformative.