I’ve been playing with the retirement planner along with the cashflow forecast and have found it really useful for planning up to retirement (which for me is only 5 or 6 years away, hopefully). I’ve also modeled in some known expenses, income and changes on a year by year basis which is really powerful and up to the retirement date seems accurate. The problem starts after that date.
One thing I am struggling to work around is the arbitrary need to select a withdrawal percentage of the entire amount, rather than an amount to match the needs of the budget for that year, which is basically the difference between my budget and any other income (TRS, Social Security, Rental Income, etc.)
The second issue is that the withdrawal amount doesn’t go back to the cashflow sheet (you can’t reference it either because it says it’s a circular formula) so the net investment amount goes down every year even if the investment gain plus other income plus drawdown is greater than the budget of any year, which for me it is for at least 10 years. Surely it should remain in the accumulated cashflow amount, even if I don’t reinvest it?
Are there any thoughts on how to work with this? If I use Personal Capitals Retirement Planner, I basically never run out of money with the budget a picked, barring a huge emergency. With the Retirement Planner Community Sheet, I run out of money in about 25 years because the above.