Scenario modelling for financial decisions

Most financial decisions have at least two answers

Should you rent or buy? Save the cash or invest it? Pay down the debt or keep it and invest the difference? These are everyday financial decisions, and the right answer is almost never obvious — because the right answer depends on assumptions about returns, costs, and time that nobody can observe perfectly.

Scenario modelling is the discipline of writing down those assumptions explicitly, modelling each path side by side, and seeing which one wins under your numbers. It’s not a forecast. It’s a structured way to make your own assumptions visible so you can reason about them.

Why what-if thinking beats gut feel

Gut feel for financial decisions is usually wrong because:

• The numbers are big and the time horizon is long. Compounding turns small annual differences into life-changing gaps over decades. A 1% gap that feels trivial year-by-year becomes 20–30% over 30 years.
• The intermediate path matters as much as the destination. Two strategies can finish in similar places while taking very different paths to get there. One might be down 30% at year 5; the other might never decline. Same final number, very different experience.
• Crossover points are invisible without modelling. A scenario that starts behind can finish ahead, and vice versa. The exact year of crossover is rarely intuitive — but knowing it changes how you act.

Writing the scenarios down forces you to commit to specific numbers, which makes the disagreement between scenarios concrete and discussable.

Setting up a meaningful scenario

A useful scenario has four parts:

1. A name that describes what you’re modelling — “Rent + invest difference” is much clearer than “Scenario A”.
2. A starting position — initial cash, initial debt, or initial asset value. Use what you actually have, not a round number.
3. A monthly behaviour — what changes month-by-month. Contributions, repayments, withdrawals.
4. A growth or interest rate — the annual rate at which the position changes.

You can also include one-time costs: stamp duty on a property purchase, a deposit, a setup fee. These come out of the starting position immediately and don’t recur.

The trick is to use the same horizon and the same assumptions for shared variables across all scenarios. If you’re testing rent vs buy, both scenarios should run for the same number of years. If both scenarios assume 6% market growth, use 6% in both — even if you secretly think one strategy will outperform.

Three scenario patterns that actually decide things

Rent vs buy

Two scenarios, same horizon, same starting cash:

• Buy: Initial position = property value, monthly change = mortgage payment + holding costs, growth = property appreciation rate, one-time costs = stamp duty + buying fees.
• Rent + invest: Initial position = the same starting cash, monthly change = the difference between rent and the buyer’s monthly outgoings (which they invest), growth = expected investment return.

The buy scenario wins when property appreciation outruns investment returns by enough to overcome buying costs and the foregone savings on rent. The rent scenario wins when investment returns dominate. The actual answer for your situation depends on numbers you can vary.

Save vs invest

Two scenarios, same starting cash:

• Save: Initial = your cash, monthly = ongoing savings, growth = savings account interest (typically 4–5%).
• Invest: Initial = your cash, monthly = ongoing contributions, growth = expected market return after fees (typically 5–7% real).

The interesting question is not which finishes higher in expectation — investing usually does — but how much higher, and whether the gap justifies the volatility you’d live with on the way. The model shows the expected gap; you decide if it’s worth it.

Pay debt vs invest the difference

Two scenarios, same monthly cash:

• Pay debt: Initial = your debt as a negative number, monthly change = your debt payment (positive — you’re reducing the debt), growth = the debt’s interest rate (positive — debts compound against you).
• Invest: Initial = $0, monthly change = your debt payment redirected to investing, growth = expected investment return after fees.

This is the cleanest mathematical comparison there is. If your debt rate is 8% and your expected investment return is 7%, the math says pay the debt. If your debt rate is 4% (a low-rate mortgage) and expected investment return is 7%, investing the difference may win.

What the model does not tell you

Scenario modelling shows you the math under your assumptions. It does not tell you:

• Whether the assumptions are correct. A model with optimistic returns shows optimistic outcomes. Use realistic, long-run averages.
• How you’ll feel during the path. Investing has volatility; debt repayment has discipline costs. Both are real but neither shows up in the final number.
• Tax consequences. Real-world taxes can change a winning strategy into a losing one. Most scenario tools (including this one) abstract away tax — model it separately when material.
• Your personal circumstances. Liquidity needs, job stability, dependants, and risk tolerance all matter. The model is a thinking tool, not an instruction.

The single most important habit

Run the scenarios twice. Once with assumptions you actually believe, and once with assumptions that are 1–2 percentage points worse. If your decision is the same under both — high-confidence answer. If the decision flips between the two — you’re closer to the line than you think, and the choice is largely emotional rather than mathematical.

Scenario modelling rewards humility. The exercise is less about finding the “right” answer and more about understanding which assumptions actually drive the outcome. Once you know that, you know what to focus on.

Next steps

Use our scenario builder calculator to model any what-if comparison with your own assumptions. For specific decisions, the rent vs buy calculator and asset comparison calculator provide purpose-built versions of common scenarios.