Someone asked me for a copy of the spreadsheet and I created an anonymized one here: Varianten Budget jährlich – June 2024 - Google Sheets
In order to make edits, you probably have to make a copy of the Sheet to your own account.
Here’s some light instructions if you’d like to use it as well:
- Tabs ‘Einkommen / Ausgaben’ and ‘Vermögen’ are the main tabs for planning things out over the years ahead. They autoupdate automatically based on tabs …
- ‘Tatsächlich’: actual numbers reached at the end of a given year or when the final taxes are determined. I punch in those numbers as they arrive or as I pay into pillar 3a etc.
- ‘Annahmen’: numbers that I assume, i.e. returns on the different pillars (1, 2, 3a), Umwandlungssatz (I used to run calculations for receiving a Rente instead of having the capital paid out), etc.
- Tabs marked as locked (you can of course override and edit) that are used as lookup tables to calculate the various taxes at state, cantonal and municipal level as well as to calculate how much to pay into AHV if / when I have to, etc.
- a helper tab ‘Graphdaten Vermögen’ to make a nice graph of expected income and wealth over time.
Enjoy?