Page 1 of 1

Roth Conversions as 1st class citizens!

Posted: Sat Mar 13, 2021 11:15 pm
by fedupforone
Roth Conversions have become very popular and I think they deserve to be treated as "first class citizens" in the data entry modeling.

Other threads in this forum are ended with the suggestion to model it with 3 line items in the advanced inputs.
  • - Tax Deferred
  • + Tax Free
  • + Other Expense (for taxes)
Also, noted are the problems with this.
  • The tax rate that should be used
  • running out of funds in Tax Deferred - causing the + Tax Free to overestimate the amount in savings.
:idea: I think another "Cashflow Type" of "Roth Conversion" would help a lot. It would use at least the start year, end year, and annual amount. Tax would be computed like any other expense, the tax rate would be like any other income, and the Roth Conversion would not happen if the Tax Deferred ran out of funds before the end year arrived.

I have had to spend considerable amounts of time trying to :roll: guess what these numbers should be to avoid the issues and get a reasonable level of conversions over a multi-year period. Especially when I change the retirement year, or change the amount of 401k contributions, this becomes very difficult to keep up to date.

This may not be a perfect, or even good, solution :? , better minds can chime in!

Re: Roth Conversions as 1st class citizens!

Posted: Fri Mar 26, 2021 10:43 am
by jimr
Thanks for posting. This has been on my to-do list for a long time and I've been reluctant to add it because it needs to happen in the heart of the simulation logic, which I don't like to muck with since it's easy to break things in that code.

Anyhow, I took a shot at adding a "Roth Conversion" cash flow type and I've posted a beta version of the code for testing below. The change to the sim code turned out to be pretty limited and it wasn't as complicated/disruptive as I thought it might be. Still, this beta release has only seen limited testing and it'll be several months before i put it into production.

You can find the download links here:
viewtopic.php?f=7&t=1381

(NOTE: if you use this new version and later decide to back-rev, any .frp files you have that contain the new "Roth Conversion" cashflow type will not load with older versions of the planner. To fix this, you'd need to use the new version to delete the "Roth Conversion" cash flows, or you'd need to manually edit the .frp file to remove them (not recommended).

Re: Roth Conversions as 1st class citizens!

Posted: Sat Mar 27, 2021 2:56 pm
by jimr
I updated the download link to correct a possible install error in the last one. Should be all set now.

Re: Roth Conversions as 1st class citizens!

Posted: Thu Apr 08, 2021 3:12 pm
by fedupforone
Wow, great turnaround on a request! Initial testing looks very good. I really like it :D

Re: Roth Conversions as 1st class citizens!

Posted: Thu Apr 08, 2021 5:51 pm
by jimr
Glad to hear it. Thanks for posting the suggestion.