FIRE Dashboard

FIRE Dashboard or your own spreadsheet?

Many people start their FIRE plan in a spreadsheet. That is a good start: you see every formula and you learn a lot about your own money. But a Dutch plan has a few parts that are often missing from a home-made spreadsheet, or that no longer add up after a year. Here you can read which ones, and when a spreadsheet is simply enough.

In short

  • A spreadsheet is free, flexible and entirely yours. For saving and a first FIRE number, it is often enough.
  • For a Dutch plan it often goes wrong with one fixed return, box 3, the AOW date, sequence risk, tax partners and keeping up with new rules.
  • In the example, the same plan ends after five years at €991,334 with a fixed return, and at €865,285 with a crash in the first year.
  • You can also use both: FIRE Dashboard exports the whole projection as a CSV for your own spreadsheet.

What a spreadsheet does well

  • Full control. You see every formula, and you decide what goes in. Nobody else decides which assumptions you make.
  • Free. A spreadsheet costs nothing, and you probably already have one.
  • Flexible. Your own spending categories, a sabbatical in three years, an inheritance you expect: you add it in a minute.
  • You learn from it. If you work out a FIRE number yourself, you understand better what it depends on. That is worth a lot, even if you use something else later.

A calculator cannot do all of that. It is a model too, with assumptions you need to understand. But for a Dutch plan there are six places where a home-made spreadsheet often falls short.

Where it often goes wrong

1. One fixed return

Most spreadsheets use the same return every year, for example 4%. But the stock market never gives 4% every year. While you are saving, that makes little difference. Once you withdraw every year, it does. The example below is also in the guide to the Monte Carlo simulation: €1 million, €40,000 withdrawn at the start of each year, and five years with an average return of 4%.

YearFixed 4%Crash firstWealthCrash lastWealth
1€998,400−20%€768,000+25%€1,200,000
2€996,736−10%€655,200+15%€1,334,000
3€995,005+10%€676,720+10%€1,423,400
4€993,206+15%€732,228−10%€1,245,060
5€991,334+25%€865,285−20%€964,048

The spreadsheet with a fixed return says €991,334. With a crash in the first year it is €865,285, more than €126,000 less, with the same average. And even with the crash at the end you finish lower (€964,048). That is because the average of +25% and −20% is not what you actually keep: after −20% you need +25% just to get back. Per year, the return in this sequence is really 2.6%, not 4%.

Enter your own numbers, free

2. Box 3 with one year's rules, or not at all

Many spreadsheets leave box 3 out, or use a fixed percentage. With €1 million in investments, as a single person you pay about €20,300 in box 3 tax in 2026, more than 2% of your wealth a year. And the rules change every year: in 2027 the tax-free allowance under current law is €60,098 and the deemed return on investments 6.37%, against €59,357 and 6% in 2026. How to calculate it is explained in calculating box 3 tax in 2026.

3. The AOW date and two phases of spending

A simple spreadsheet withdraws the same amount every year, to the end. In the Netherlands your wealth pays for everything until your AOW age, and after that only what the AOW and your pension do not cover. That AOW age depends on your date of birth and may still move for younger people. Without those two phases, your FIRE number comes out too high or too low.

4. Sequence risk and Monte Carlo

The example above shows one bad sequence. How likely it is that things go wrong, you only see when you play the plan hundreds or thousands of times with random years. That can be done in a spreadsheet, with random numbers and a table per future, but it is a lot of work and hard to keep free of errors. FIRE Dashboard does it for free, with box 3, the AOW and your pension in every simulated year, next to four stress tests such as a crash in the first year.

5. Tax partners

With a tax partner, the box 3 tax-free allowance is doubled: €118,714 in 2026. If there is an age gap between you, there are also two AOW dates, and between those dates only one AOW comes in. A spreadsheet for one person with a double budget misses that. How it works is explained in FIRE as a couple.

6. Keeping up with new rules

Autumn 2026 showed how fast the rules change. On 29 September the cabinet wanted to make box 3 more expensive in 2027, with a tax-free allowance of €30,846. On 3 November it dropped that plan again, and proposed a tax on capital gains from 2029 (a bill, not yet law). If you do not update your spreadsheet every year, it uses the rules of the year you made it. In FIRE Dashboard, current law and, with Plus, the plans sit side by side as scenarios.

When a spreadsheet is enough

To be fair: not everyone needs more. A spreadsheet is often enough if:

  • your FIRE date is still far away. Then it is mostly about your savings rate and your spending, and your plan will change a lot along the way anyway.
  • your wealth stays below the tax-free allowance. Then you pay no box 3, and one of the hardest parts drops out.
  • you deliberately plan with a wide margin. If you use a low withdrawal rate and add box 3 to your spending, you cover part of the above.
  • you enjoy building and maintaining it. If you fill in the Belastingdienst's new percentages every year, your spreadsheet will be right.

You can also use both. FIRE Dashboard exports every year of your projection, with balances, cash flows and tax, as a CSV. You open it in your own spreadsheet, to keep calculating or to check what the app does.