TromboneAl
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
- Joined
- Jun 30, 2006
- Messages
- 12,880
I've attached a very simple spreadsheet for determining how much to spend each year. I figured that having a spreadsheet would keep me honest.
You enter the retirement year, the amount of your retirement dough (including or excluding house, you decide) and the SWR you will use.
It tells you how much to spend for your first year. At the end of that year, you enter the inflation rate that you will use for that year, and it tells you how much to spend next year. Any money left over goes in your fun money account.
I've put in hypothetical values to illustrate how it works.
You enter the retirement year, the amount of your retirement dough (including or excluding house, you decide) and the SWR you will use.
It tells you how much to spend for your first year. At the end of that year, you enter the inflation rate that you will use for that year, and it tells you how much to spend next year. Any money left over goes in your fun money account.
I've put in hypothetical values to illustrate how it works.