Flexible Retirement Planner Support Forum

@target2019, I ended up adding the extra tax columns that I mentioned above.

I plan to release the updated version in the next week or so, but if you send an email to info@flexibleRetirementPlanner.com I can send you a download link for the beta version.

That looks right to me.

I made a note to consider adding a "tax on income" column and a "total tax paid" column next time I'm in that code.

You've nicely demonstrated that both of these could be computed after the fact using information that's readily available. Thanks for that.

Adding Taxes on Portfolio Growth + Taxes on RMD + Taxes on Withdrawal should cover most of it. There's also taxes on income cash flows (eg on pensions or ss income). These aren't tracked inside the sim code since everything is handled net of taxes. So you'd have to manually add in taxes due on any t...

I don't think the results view can show taxes paid on income, but there is an estimated taxes paid on portfolio growth column that you can see by right-clicking on any column header and selecting "show all columns". The only trouble is that this estimate is computed after the fact for display purpos...

I think we might be stuck on some confusion over nomenclature. After tax income isn't related or connected to the amount of expenses you have. It's based on the sum of all the income cash flows you create either on the main input sheet (annual retirement income) and in the additional inputs window (...

Unfortunately, the planner isn't really set up to support this easily.

You could set up cash flows manually using additional inputs to simulate something close to this, but it'd be a bit of a fight because the planner logic really wants to control the portfolio withdrawal order.

Thanks for the update and for the nice clear report of what you are seeing. That column was sort of an afterthought and because I didn't want to increase the storage used by the sim code, I calculate it after the fact rather than saving the data needed to pull a median value out of the simulation. A...

If you right-mouse click on the body of the detailed view table, you should get a popup menu that you can use to export the data to excel.

Logically, annual expenses are deducted from the portfolio on the first of the year and portfolio growth and taxes are computed at the end of the year. Does that help to make your numbers make sense?

You are correct that the tax rates are not intended to be marginal tax rates, but rather an average or effective tax rate. The best numbers to plug into these rates are so dependent on personal circumstances that I can't be of much help with that, except to mention that these rates should account fo...