Developed and operated in Europe

Monte Carlo simulation: in how many of 10,000 paths would your money have lasted?

Paperball builds 10,000 possible paths from real monthly returns — for your portfolio or an asset mix of equities, bonds, gold and interest. You see in how many of them your savings plan and your withdrawals would have worked out.

In short

A Monte Carlo simulation plays through not one but many possible paths. Paperball builds them from real monthly returns and counts in how many your plan would have worked out. In the worked example below, a first-year withdrawal of €20,000 from €500,000 would have lasted 30 years after German tax in 88 % of the 10,000 paths.

  • Free account with starter credits
  • Portfolio backtester included
  • Hosted in the EU · GDPR

What the simulation shows you

  • A range instead of a single line

    A fan chart shows how widely your wealth spreads over the years: the middle path, the middle half and 90 % of paths.

  • In how many paths the money would have lasted

    With a withdrawal plan you see in how many of the 10,000 paths your wealth would have covered every withdrawal to the end — and what would have been left at the end at the lower bound, in the median path and at the upper bound.

  • Which withdrawal would have held up, which savings rate it would have taken

    Paperball works out the highest withdrawal that would have lasted in 9 out of 10 paths — and, with a savings plan, the savings rate that would be needed for it.

How it works

  1. Choose a return source

    Take a saved portfolio from your backtests or put together an asset mix of building blocks, such as global equities, euro government bonds, gold, money market or a fixed interest rate.

  2. Set up saving and withdrawing

    Set your starting capital and time span, optionally a savings phase and after that a withdrawal plan with a cash buffer.

  3. Evaluate 10,000 paths

    Paperball randomly draws twelve-month blocks from the real price history and joins them into 10,000 paths. You see the fan chart, the success rate and the amounts that would have held up.

Save first, then withdraw — in a single run

Retirement or a career break: the simulation runs both phases back to back on the same paths. That way you see not only what would have been there at the end of the savings phase, but also whether it would have lasted afterwards.

  • Save first

    A savings rate, monthly up to yearly, fixed or raised by a percentage every year, plus a target amount if you like. You see what would have been there at retirement in the median path and at the lower bound, how often the target would have been reached and what rate it would have taken.

  • Then withdraw

    A fixed amount, raised by inflation every year if you like, or a percentage of the current value. With a fixed amount, an interest-bearing buffer can step in during weak years so you don't have to sell at the bottom — and you see how often it would have lasted with and without the buffer.

More about the withdrawal plan

Why a single path is not enough

A backtest shows what would have happened with the real prices — a single path with exactly one sequence of good and bad years. For withdrawals, though, that very sequence matters: a crash shortly after retirement weighs more heavily than the same crash twenty years later.

The Monte Carlo simulation draws the years in a new sequence and shows how your plan would have fared across many possible orders. Because whole one-year pieces are drawn – with replacement, as if from a lottery drum – the patterns within a year stay intact.

Worked example: a fan chart with figures

€500,000, 60% in German equities and 40% in German government bonds, €20,000 withdrawn in the first year (4 %) and raised with inflation every year after that, after German tax. The fan shows the wealth year by year in today's purchasing power:

Year 10Year 20Year 30
  • Middle value (median)
  • Middle half of the paths
  • 90 % of paths
Wealth in today's purchasing powerAfter 10 yearsAfter 20 yearsAfter 30 years
Upper bound (5 % would be above)€1,137,026€1,998,914€2,854,390
Median of the paths€551,875€598,731€564,330
Lower bound (5 % would be below)€238,212€83,085€0

After 30 years the wealth would be €564,330 in the median path, €0 at the lower bound and €2,854,390 at the upper bound. The money would have lasted in 88 % of paths.

Stress test: the financial crisis right at the start

The same 10,000 paths, except that withdrawals begin with the months from 11/2007 to 02/2009 in their real order. Then the money would have lasted in 52 % of paths instead of 88 %; in the median path, €14,156 instead of €564,330 would be left at the end in today's purchasing power.

And with other crises at the start of withdrawals:

At the start of withdrawalsWould have lasted inMedian at the end, today's purchasing power
No particular crisis (all paths)88 % of paths€564,330
Financial crisis 2007–0952 % of paths€14,156
Dot-com bubble 2000–0334 % of paths€0
High inflation 1973–8279 % of paths€155,316
The worst ten years in the price history66 % of paths€70,839

For comparison: real starting years

With real starting years — one path per January from 1973 to 1996, in exactly the order in which the following years came — the money would have lasted in 24 of 24 starting years. It would have lasted in every one of these starting years.

Also included: the portfolio backtester

In the same account, Paperball runs every allocation of your ETFs, funds and stocks through real prices — after costs and taxes. You save the allocation you like and carry it on into the Monte Carlo simulation. One account, both tools.

More about the portfolio backtester

Sources

  • Tax rules (German law): Section 32d EStG (flat-rate withholding tax), Section 20(9) EStG (saver's allowance), Section 18 InvStG (advance lump sum), Section 20 InvStG (partial exemption).
  • Price history and consumer prices: a research series of German equities, German government bond yields from a central bank's yield curve and official consumer prices.

Questions about the Monte Carlo simulation

What is a Monte Carlo simulation?

A calculation that plays through not one but many possible paths. Paperball builds 10,000 paths from real monthly returns and evaluates them — for example: “In 94% of the simulated paths, the money would have lasted.” That is neither a probability nor a forecast, but an analysis of the past.

What is the difference between a backtest and a Monte Carlo simulation?

A backtest looks back: it uses real prices to work out what would have become of your money — exactly as things turned out at the time. That gives a single path. The Monte Carlo simulation asks one question more: what if the good and the bad years had come in a different order? To find out, it cuts the real price history into pieces of twelve months each and puts them back together 10,000 times. That shows you how differently things could have gone — for example, in how many of these paths your withdrawals would have lasted to the end. In short: the backtest shows what happened; Monte Carlo shows the range. Neither is a forecast.

Where do the returns come from?

From the real price history: from the calculation of a saved portfolio, from the backtest of a portfolio in the Community-Backtests or from total return index series, i.e. including distributions. Draws are made in twelve-month blocks so that market phases stay together — crisis years such as 2008 or 2022 remain intact.

How much price history is needed?

At least five years. For an asset mix, what counts is the period in which all building blocks have data — the calculation never uses a series that did not exist yet at the time. A fixed interest rate does not count here, as it has no history.

What can I do if a security's price history is too short?

A backtest needs at least one year, a Monte Carlo simulation at least five years in which all selected securities have prices. If that is not enough, there are two possible reasons. First: the security is simply still young. If an ETF was launched three years ago, there are only three years of prices — nobody can extend them. For the calculation you can then use an older security with similar holdings, for example another ETF on the same index. Second: the security is older, but our data provider does not deliver its prices far enough back. Then you add the missing prices yourself: on the “Watchlist” page, upload a price file (CSV) for the security — this is available on every plan. Tip: you can find free prices at onvista.de and investing.com. With a free account you can download the historical prices there as a CSV file, and Paperball reads both formats directly.

What do median, lower bound and upper bound mean?

If you sort all paths by their result, the median is the path exactly in between: one half ends above it, the other below. 5 % of paths lie below the lower bound, the same share above the upper bound, and 90 % between the two. So the lower bound is not a worst case — there are weaker paths below it.

What is a stress test?

The same paths, except that the first years of withdrawals are exactly the months of a real crisis in their real order — such as the financial crisis or the high inflation of the 1970s. This shows you what a weak sequence right at the start would have meant. Paperball calculates every crisis that lies entirely within the price history of the basis, plus the weakest ten years of that history.

Are taxes and costs included?

Yes, if you want. For a saved portfolio, Monte Carlo uses the tax settings of its backtest, which you can change; for asset mixes and portfolios from the Community-Backtests you switch taxes on. Every withdrawal is sold so that your amount arrives after tax on the gain share; each year, the tax on buffer interest, a wealth tax and the advance lump sum are added. A portfolio's costs and its tax on rebalancing are already part of its return series; an asset mix is calculated without costs. Approximated are the reduced rate after a holding period and the tax on distributions, which only applies on sale.

Is this investment advice?

No. Paperball is a calculation tool and does not provide investment advice or investment recommendations. Monte Carlo recombines past price history into possible paths. That is not a forecast. You make decisions about your investments yourself.

Do I need a separate subscription for Monte Carlo?

No. The Monte Carlo simulation and the portfolio backtester belong to the same account, and you need no subscription for either. Every simulation costs credits, whatever it is based on; with the starter credits your first ones are free, after that you buy more credits or take a subscription — see all prices.

Run the numbers on your own plan

Starting capital, savings rate, withdrawal — enter your numbers and see how they would have held up across 10,000 paths.