As the OP - I appreciate all the feedback on this thread. Overall it seems that the majority of people spend more (sometimes a lot more) during their earlier retirement years and much less in their later years (excluding those who have health or LTC expenses) so I feel that many of the retirement models (e.g. 4% “rule”) and the various tools out there do not model the “real world” - at least not by default as I know some tools allow you to adjust expenses each year but it’s a PITA.
We know that we don’t want to leave a significant nest egg to our mostly ungrateful kids but we also don’t want to live only on SS late in life. The curse is that I’m only 51 and DW is 53 so we have a long time left on this earth (at least we hope/think). Does anyone know of a tool that more accurately reflects the real world (where withdrawals decrease with age - especially after say 80 years old - and then perhaps jump a little more the last few years)?
Years ago, when I first started planning for FIRE, I built an Excel spreadsheet with projected year-by-year expenditure, investment returns and liquid assets on hand that reflect higher spending in my 50s and 60s for things like traveling and sports, and lower spending once I hit my 70s and 80s.
Over the years I've refined the spreadsheet to a fairly elaborate degree and use it to track my cash flow (including monthly income from various source and outlays) and tie it back to my overall NW spreadsheet to project out my overall NW and cash flow needs up to age 100. It did take a bit of trial and error and tweaking to reflect my individual situation but it's pretty easy to do and it has now become an indispensable tool for me to track my cash flow and NW on a monthly basis.
I suggest that you can easily do the same. Whatever you set up is going to be way better than a generic tool you find on the internet, because you can set up yours to reflect your own personal situation, and you can tweak it to a level of detail that a generic tool just won't provide.
In my case, I have a lot of RE with dividend/rental income and I am frequently buying and selling properties. So my monthly income and cash bucket can fluctuate wildly depending on my investment decisions. I set up my spreadsheet to be able to easily account for these transactions and that's a much more accurate and detailed picture of my finance than what a generic tool could ever provide.
I am around your age and I agree that it's more realistic to model higher spending in the next couple of decades while we're still physically capable of a more active lifestyle.
Last edited: