Author Topic: When a Trad to Roth Conversion Isn't Ideal  (Read 1370 times)

dbfire

  • 5 O'Clock Shadow
  • *
  • Posts: 34
When a Trad to Roth Conversion Isn't Ideal
« on: February 24, 2021, 03:45:08 PM »
Hi, everyone. Post number one, been reading and lurking for a year. Nice to meet you and officially join the community!

I’m 40 years old and am right on the verge of FIRE. Yay! Over the past 2 years I’ve created my own very detailed financial planning doc in Excel that’s been helping me understand the impact of various tax and investing strategies. I have money relatively well spread around in a taxable brokerage account, Trad IRA, Roth IRA, and a 401k (until I stop my part-time self-employed marketing work).

One thing I’ve noticed is that no matter how many ways I mess around with the numbers (timing, quantity, etc.), converting my Trad IRA to Roth IRA always results in a worse financial outlook and peak net worth. What I think is going on is that the tax hit albeit very small so early on in my retirement causes that money not to grow for decades and ultimately is not as good a result as having the small tax hit down the line. My plan was to first use up my brokerage $ which will last 20 years, then move to Trad IRA, then Roth.

Thinking this through I can imagine this is a lot more common that I first anticipated, yet it’s not something I have read much about because most reading material is about how the conversion is in most cases a wise tax strategy. I would imagine that is because a big component of the strategy is getting the money out before 59.5. That’s less of an issue for me because as of now my taxable may last 2 decades. If it ends up being short, I could always use a little bit of the Roth contributions or just convert a very small amount from Trad to Roth as a backup in my 50s.

I’m just curious if other people have run into the same situation and if there is something I’m missing. Obviously, I didn’t give a ton of details here, more philosophy, so let me know if more details would help.
« Last Edit: February 24, 2021, 04:04:09 PM by dbfire »

reeshau

  • Magnum Stache
  • ******
  • Posts: 2596
  • Location: Houston, TX
  • Former locations: Detroit, Indianapolis, Dublin
Re: When a Trad to Roth Conversion Isn't Ideal
« Reply #1 on: February 24, 2021, 04:19:35 PM »
You talk about converting your IRA to a Roth.  You also talk separately about your withdrawal order.  Sticking with the first topic:

Converting traditional to Roth is even money, assuming your income tax rate is the same on contribution and withdrawal.  So choosing where to make your contributions starts with guessing if your marginal tax rate now is more or less than it will be in retirement.  (whether through increased income or tax law changes)

After that, you might contribute to a Roth IRA rather than traditional because you already participate in a 401k, and make too much to qualify for deductible IRA deductions, but do qualify for Roth contributions.

These are how balances get built up.

Converting, in the form of a mega backdoor Roth, is a way (often talked about here) for you to access your traditional IRA balance before age 59 1/2, since Roth contributions are available penalty-free after 5 years.  Managing a Mega-backdoor Roth is again an exercise in managing / guessing your current tax bracket vs. your future bracket.  Usually, you wouldn't want to convert so much that you bump into a high tax bracket.  (you spendypants!)  But you might have to if your stache is highly concentrated in your 401k or trad IRA.

Other than this, when you are comparing numbers side-by-side, you again have to remember that trad IRA amounts are still pre-tax.  So, for example, $800k balance in a Roth may be worth the same as $1M in your trad IRA.  (Adjust for your total tax rate, state + Fed)  Taxable balances are the same way, although again if you manage it you can keep capital gains at 0%.

simonsez

  • Handlebar Stache
  • *****
  • Posts: 1584
  • Age: 37
  • Location: Midwest
Re: When a Trad to Roth Conversion Isn't Ideal
« Reply #2 on: February 24, 2021, 05:11:02 PM »
Without numbers I'm not going to add much other than note that even if your tax rate is the same now and would be the exact same every year for the rest of your life, you still might want to shift toward the Roth IRA.  It has no RMDs that kick in at age 72 unlike the 401k, Roth 401k, and trad IRA.  This might not matter depending on your plans but just wanted to throw that out there.

You can't do loans from IRAs (trad or Roth) but hopefully that doesn't apply to those on this forum.  Welcome @dbfire !

dbfire

  • 5 O'Clock Shadow
  • *
  • Posts: 34
Re: When a Trad to Roth Conversion Isn't Ideal
« Reply #3 on: February 24, 2021, 05:28:48 PM »
Thanks, @simonsez. I was unaware of the RMD distinction.

For the record, numbers wise.

470k in taxable
247k in Trad IRA
62k in Roth IRA
124k in 401k (ongoing)
8k in HSA
About 50k cash as an emergency fund (I want to keep over a year of expenses).
I rent my small apartment, no plans on owning a home, except maybe a $30k-$60k tiny home if income is a little more than I expect this year or next)

Expenses right now are around 30k-36k/year (low end is covid actual trending)
Earned Income after this year may be 20k for a year or two then nothing.
I live in California and likely will continue to do so.
I'm single, no kids, no debt.
« Last Edit: February 24, 2021, 06:02:11 PM by dbfire »

dbfire

  • 5 O'Clock Shadow
  • *
  • Posts: 34
Re: When a Trad to Roth Conversion Isn't Ideal
« Reply #4 on: February 24, 2021, 05:33:47 PM »
You talk about converting your IRA to a Roth.  You also talk separately about your withdrawal order.  Sticking with the first topic:

Converting traditional to Roth is even money, assuming your income tax rate is the same on contribution and withdrawal.  So choosing where to make your contributions starts with guessing if your marginal tax rate now is more or less than it will be in retirement.  (whether through increased income or tax law changes)

After that, you might contribute to a Roth IRA rather than traditional because you already participate in a 401k, and make too much to qualify for deductible IRA deductions, but do qualify for Roth contributions.

These are how balances get built up.

Converting, in the form of a mega backdoor Roth, is a way (often talked about here) for you to access your traditional IRA balance before age 59 1/2, since Roth contributions are available penalty-free after 5 years.  Managing a Mega-backdoor Roth is again an exercise in managing / guessing your current tax bracket vs. your future bracket.  Usually, you wouldn't want to convert so much that you bump into a high tax bracket.  (you spendypants!)  But you might have to if your stache is highly concentrated in your 401k or trad IRA.

Other than this, when you are comparing numbers side-by-side, you again have to remember that trad IRA amounts are still pre-tax.  So, for example, $800k balance in a Roth may be worth the same as $1M in your trad IRA.  (Adjust for your total tax rate, state + Fed)  Taxable balances are the same way, although again if you manage it you can keep capital gains at 0%.

@reeshau Thanks for the response. My doc makes it appear that converting trad to roth is not even money. I am guessing this is because giving the government money now on the conversion is worse than giving the government money later with the trad IRA distribution, even if my tax bracket is the same. Is that logic flawed?

Backdoor Roth won't work for me because of the Traditional IRA balance, correct? Either way I won't be contributing any more after this year and don't really have any cash left to contribute, anyway.

reeshau

  • Magnum Stache
  • ******
  • Posts: 2596
  • Location: Houston, TX
  • Former locations: Detroit, Indianapolis, Dublin
Re: When a Trad to Roth Conversion Isn't Ideal
« Reply #5 on: February 24, 2021, 06:20:50 PM »

@reeshau Thanks for the response. My doc makes it appear that converting trad to roth is not even money. I am guessing this is because giving the government money now on the conversion is worse than giving the government money later with the trad IRA distribution, even if my tax bracket is the same. Is that logic flawed?

Backdoor Roth won't work for me because of the Traditional IRA balance, correct? Either way I won't be contributing any more after this year and don't really have any cash left to contribute, anyway.

Yes, that is flawed.  It depends on your assumptions for tax brackets.  I could see that it might always look worse if you assume a 100% conversion in a single year, which would drive up your tax bracket.  But if you manage the taxes on the conversion, and say: "I will convert this year, up to the cap of the 12% bracket," then you start to take control of the situation.  You can check your work with an online calculator like this one:

https://www.schwab.com/ira/understand-iras/ira-calculators/roth-ira-conversion

You can do a backdoor Roth with an IRA balance; you just can't do it tax free.  A mega backdoor or Roth conversion ladder talks about amounts equal to annual spending--much bigger than contribution limits--So those aren't tax free, anyway.

reeshau

  • Magnum Stache
  • ******
  • Posts: 2596
  • Location: Houston, TX
  • Former locations: Detroit, Indianapolis, Dublin
Re: When a Trad to Roth Conversion Isn't Ideal
« Reply #6 on: February 24, 2021, 06:25:33 PM »
This article is focused on contributions rather than conversions, but here you can see some of the variable stat impact the decision, in table format.

https://www.nerdwallet.com/blog/investing/roth-ira/roth-tops-traditional-iras-up-to-six-figures/


And another article, this time focusing on initial choice, but still listing some of the pros and cons.

https://www.nerdwallet.com/article/investing/roth-or-traditional-ira-account

The big one here:  If all goes well (meaning, no SORR and great returns) then RMD's may blow up your plan to have a low bracket in retirement.
« Last Edit: February 24, 2021, 06:30:43 PM by reeshau »

Telecaster

  • Magnum Stache
  • ******
  • Posts: 3576
  • Location: Seattle, WA
Re: When a Trad to Roth Conversion Isn't Ideal
« Reply #7 on: February 24, 2021, 07:13:00 PM »
@reeshau Thanks for the response. My doc makes it appear that converting trad to roth is not even money. I am guessing this is because giving the government money now on the conversion is worse than giving the government money later with the trad IRA distribution, even if my tax bracket is the same. Is that logic flawed?

Unless I am missing something regarding your spreadsheet, it would appear to be flawed.  If the tax rate is .22 (or whatever) then it doesn't matter when you take the deduction.  Beginning or end, it is mathematically the same. 

dbfire

  • 5 O'Clock Shadow
  • *
  • Posts: 34
Re: When a Trad to Roth Conversion Isn't Ideal
« Reply #8 on: February 25, 2021, 05:25:05 AM »
Thanks for your help, all of you. I'll have to think about this a little more and look to see where my spreadsheet is off. It has done a stellar job accurately calculating my taxes every year and handles the flow of expenses, income, inflation, and distributions and I've put a lot of work into it so I thought it was relatively sound. And yes, @reeshau, I was planning the Roth conversion up to the 12% limit and keeping the LTCG taxes from the taxable account at 0% at that time, as well. Or as close as possible. That's what I meant by playing around with numbers and timing. Conversions of different amounts (5k, 30k, 100k), it always came out worse.

@Telecaster I understand that if the tax rate is the same that the math is the same, but I don't fully comprehend (yet) why the timing isn't important. I still don't understand why having the $ now that I would've sent to the government isn't much better than sending it later, in which case I'll have more $ in my Trad IRA and can keep the same tax rate later but on more money.

But I'll read through the links you all kindly provided and try to wrap my head around it more. Thanks again!

reeshau

  • Magnum Stache
  • ******
  • Posts: 2596
  • Location: Houston, TX
  • Former locations: Detroit, Indianapolis, Dublin
Re: When a Trad to Roth Conversion Isn't Ideal
« Reply #9 on: February 25, 2021, 05:40:41 AM »
Beyond the math and absolute tax optimization, I find it useful to have some "tax diversification" as I synthesize the income I want to have in order to optimize current taxes, ACA subsidies, and cash flow given deductions and refundable / nonrefundable tax credits.  I have more than 1 year's cash, so I could have $0 income if I chose, but that's not optimal.  I have 10 years to go to 59 1/2, so the next decade I will use my own mega backdoor Roth to bleed my rollover IRA ahead of RMD's, as well as to generate "income," none of which I will spend this year.

The total disconnect between income and spending has been amusing.  I suppose the same is generally true during the accumulation phase, for good savers.  But that still had some relationship, meaning in order to save, you had to spend less than you made.  Now, in retirement, the two numbers are entirely disconnected, at least until the IRA becomes my primary cash source.

SeattleCPA

  • Handlebar Stache
  • *****
  • Posts: 2384
  • Age: 64
  • Location: Redmond, WA
    • Evergreen Small Business
Re: When a Trad to Roth Conversion Isn't Ideal
« Reply #10 on: February 25, 2021, 07:06:59 AM »
@reeshau Thanks for the response. My doc makes it appear that converting trad to roth is not even money. I am guessing this is because giving the government money now on the conversion is worse than giving the government money later with the trad IRA distribution, even if my tax bracket is the same. Is that logic flawed?

Unless I am missing something regarding your spreadsheet, it would appear to be flawed.  If the tax rate is .22 (or whatever) then it doesn't matter when you take the deduction.  Beginning or end, it is mathematically the same.

+1

SeattleCPA

  • Handlebar Stache
  • *****
  • Posts: 2384
  • Age: 64
  • Location: Redmond, WA
    • Evergreen Small Business
Re: When a Trad to Roth Conversion Isn't Ideal
« Reply #11 on: February 25, 2021, 07:14:11 AM »
Thanks for your help, all of you. I'll have to think about this a little more and look to see where my spreadsheet is off. It has done a stellar job accurately calculating my taxes every year and handles the flow of expenses, income, inflation, and distributions and I've put a lot of work into it so I thought it was relatively sound. And yes, @reeshau, I was planning the Roth conversion up to the 12% limit and keeping the LTCG taxes from the taxable account at 0% at that time, as well. Or as close as possible. That's what I meant by playing around with numbers and timing. Conversions of different amounts (5k, 30k, 100k), it always came out worse.

@Telecaster I understand that if the tax rate is the same that the math is the same, but I don't fully comprehend (yet) why the timing isn't important. I still don't understand why having the $ now that I would've sent to the government isn't much better than sending it later, in which case I'll have more $ in my Trad IRA and can keep the same tax rate later but on more money.

But I'll read through the links you all kindly provided and try to wrap my head around it more. Thanks again!

@dbfire, this blog post I did a while back maybe provides the math you ask for. (It's first of a three-part series that argues Roth style accounts are often misunderstood and overrated):

https://evergreensmallbusiness.com/are-roth-iras-and-roth-401ks-really-a-good-deal/

Also, a related but perhaps slightly dangerous thought to share. If long-term interest rates are going to stay lower and that also impacts equity returns (because they equal the riskless bond rate plus an equity premium), that impacts decisions like going with a Roth for RMD-y reasons.

https://evergreensmallbusiness.com/financial-game-plans-for-low-interest-rates/

BTW, in my own planning, though I am very alert to RMD issues (hey, I'm a tax accountant), I have no worry about RMDs.

P.S. Your large taxable balance also solves the RMD question if you're judicious about how you draw your money.

reeshau

  • Magnum Stache
  • ******
  • Posts: 2596
  • Location: Houston, TX
  • Former locations: Detroit, Indianapolis, Dublin
Re: When a Trad to Roth Conversion Isn't Ideal
« Reply #12 on: February 25, 2021, 08:07:00 AM »

@dbfire, this blog post I did a while back maybe provides the math you ask for. (It's first of a three-part series that argues Roth style accounts are often misunderstood and overrated):

https://evergreensmallbusiness.com/are-roth-iras-and-roth-401ks-really-a-good-deal/

@SeattleCPA , that's a great blog post and does a good job building up the math to show the relationships between the pieces.  I did also read they other two posts, and wanted to comment on another scenario potentially for the Roth 401(k).  At the risk of hijacking this thread, I thought I would post it here rather than in the blog.

The scenario is this:  if a person is maxing their 401(k), then a Roth is actually sheltering more money.  The "makes no difference" comparison relies on the idea that the starting money is equal, pre-tax.  But if someone has enough money to start the Roth out ahead, they will end up ahead.  (potentially, even if they make an equal "traditional 401(k) + taxable excess" scenario, due to ongoing tax drag on growth in the taxable account)  There was one guy in particular who I had some deep conversations about this.  You might want to address this scenario, either way that you see the outcome.

dbfire

  • 5 O'Clock Shadow
  • *
  • Posts: 34
Re: When a Trad to Roth Conversion Isn't Ideal
« Reply #13 on: February 25, 2021, 05:17:05 PM »
Hijack away! Thanks for the additional materials to read through. That's why I finally posted, because I feel like the sheet I built does a good job but I didn't fully trust that it was telling me that the conversion wasn't good for me. Since no one has chimed in to say that they did their own math for their own situation and they came out with a similar problem, I can focus on figuring out the tweak I need to make in my sheet and plan for the conversions to Roth once my earned income decreases next year or whenever.

Much obliged.

seattlecyclone

  • Walrus Stache
  • *******
  • Posts: 7264
  • Age: 39
  • Location: Seattle, WA
    • My blog
Re: When a Trad to Roth Conversion Isn't Ideal
« Reply #14 on: February 25, 2021, 08:02:04 PM »

@dbfire, this blog post I did a while back maybe provides the math you ask for. (It's first of a three-part series that argues Roth style accounts are often misunderstood and overrated):

https://evergreensmallbusiness.com/are-roth-iras-and-roth-401ks-really-a-good-deal/

@SeattleCPA , that's a great blog post and does a good job building up the math to show the relationships between the pieces.  I did also read they other two posts, and wanted to comment on another scenario potentially for the Roth 401(k).  At the risk of hijacking this thread, I thought I would post it here rather than in the blog.

The scenario is this:  if a person is maxing their 401(k), then a Roth is actually sheltering more money.  The "makes no difference" comparison relies on the idea that the starting money is equal, pre-tax.  But if someone has enough money to start the Roth out ahead, they will end up ahead.  (potentially, even if they make an equal "traditional 401(k) + taxable excess" scenario, due to ongoing tax drag on growth in the taxable account)  There was one guy in particular who I had some deep conversations about this.  You might want to address this scenario, either way that you see the outcome.

This is absolutely true, and can be a tiebreaker in favor of the Roth if you are expecting your tax rate to be the same now and in retirement and you're actually maxing out every available tax shelter (401(k), IRA, HSA, etc.). I remember looking at this and the "sheltering more" aspect doesn't make up for more than a couple percentage points' difference in tax rates.

MustacheAndaHalf

  • Walrus Stache
  • *******
  • Posts: 6665
Re: When a Trad to Roth Conversion Isn't Ideal
« Reply #15 on: February 26, 2021, 02:42:40 AM »
Are you comparing the size of a Traditional IRA before withdrawal, which is in pre-tax dollars, with a Roth IRA, which is in post-tax dollars?  One has been taxed, one hasn't, so the Traditional IRA will look larger.

To compare them more directly, subtract your tax rate from the entire remaining balance in the Traditional IRA - that's how much money you'll get, after the government taxes your withdrawals.

I favor Roth IRA in tiebreaks because what you see is what you have, and it removes uncertainty over the tax rates going up / being in a higher bracket later.

seattlecyclone

  • Walrus Stache
  • *******
  • Posts: 7264
  • Age: 39
  • Location: Seattle, WA
    • My blog
Re: When a Trad to Roth Conversion Isn't Ideal
« Reply #16 on: February 26, 2021, 09:28:27 AM »
In terms of post-withdrawal dollars, a maxed-out Roth is bigger than a maxed-out traditional because the number of dollars is the same but the government doesn't have a claim on a fraction of your Roth dollars.

dbfire

  • 5 O'Clock Shadow
  • *
  • Posts: 34
Re: When a Trad to Roth Conversion Isn't Ideal
« Reply #17 on: February 26, 2021, 01:43:54 PM »
Are you comparing the size of a Traditional IRA before withdrawal, which is in pre-tax dollars, with a Roth IRA, which is in post-tax dollars?  One has been taxed, one hasn't, so the Traditional IRA will look larger.

To compare them more directly, subtract your tax rate from the entire remaining balance in the Traditional IRA - that's how much money you'll get, after the government taxes your withdrawals.

I favor Roth IRA in tiebreaks because what you see is what you have, and it removes uncertainty over the tax rates going up / being in a higher bracket later.

I basically built a doc to look at my finances holistically from now until age 150. It takes all of my expenses pre retirement and then post which are outlined in one tab in the doc, figures out the total need every year, and determines whether I have income to cover those expenses. If not, it looks to the investment accounts and takes from them, calculating LTCG from taxable or taxes from Trad IRA. When it gets to taking from the Roth, it takes from them tax free. So when I put $ in the column for a Trad to Roth conversion, it subtracts from Trad $ + current tax, and inserts those Trad funds into Roth which it will then pull out tax free later to cover the expenses. It doesn't just use a tax rate I put in, I mimicked tax software so it calculates my taxes in real time every year, using the current tax tables and historical increases to estimate the future tax rates based on the current system.

Where it is broken, I have not quite figured out yet. It could be my estimates for the future tax tables (although even the outcome of one conversion next year indicates converting is not ideal) or it could be something else. Using the tax table method instead of a percentage is certainly an area I could look to improve. It seems to be working properly everywhere else. Time will tell!
« Last Edit: February 26, 2021, 01:49:27 PM by dbfire »


SeattleCPA

  • Handlebar Stache
  • *****
  • Posts: 2384
  • Age: 64
  • Location: Redmond, WA
    • Evergreen Small Business
Re: When a Trad to Roth Conversion Isn't Ideal
« Reply #19 on: February 28, 2021, 08:03:35 AM »

@dbfire, this blog post I did a while back maybe provides the math you ask for. (It's first of a three-part series that argues Roth style accounts are often misunderstood and overrated):

https://evergreensmallbusiness.com/are-roth-iras-and-roth-401ks-really-a-good-deal/

@SeattleCPA , that's a great blog post and does a good job building up the math to show the relationships between the pieces.  I did also read they other two posts, and wanted to comment on another scenario potentially for the Roth 401(k).  At the risk of hijacking this thread, I thought I would post it here rather than in the blog.

The scenario is this:  if a person is maxing their 401(k), then a Roth is actually sheltering more money.  The "makes no difference" comparison relies on the idea that the starting money is equal, pre-tax.  But if someone has enough money to start the Roth out ahead, they will end up ahead.  (potentially, even if they make an equal "traditional 401(k) + taxable excess" scenario, due to ongoing tax drag on growth in the taxable account)  There was one guy in particular who I had some deep conversations about this.  You might want to address this scenario, either way that you see the outcome.

So I agree with this notion. But the math and the accounting get tricky. Tricky enough that I think one ought to not think this way unless you do a full accounting.

To just barely scratch the surface, for example, $20K into a traditional 401(K) is less money than $20K into a Roth 401(k).

But if the marginal tax rate is 25% (to keep math easy), you need to account for the $5K of tax savings the traditional 401(k) provides.

And so carefully think about how that $5K of additional tax savings might work. Probably you can invest in extremely tax efficient options like an Index fund and so pay very low or even zero income taxes. You can possibly harvest tax losses. You can practically invest in alternative assets (something you can't really do with an IRA or 401(k)). If the accumulated after-tax savings grow over the decades you do this, you possibly have long-term tax and financial benefits you'll harvest. You can easily gift tax-deferred amounts to heirs. You might use the appreciated assets to fund charitable giving. Looking all the way to end of road, there's also that step-up in basis at the end of life.

And then almost always the bigger thing whenever I do these calculations is the drop in tax rates someone experiences when they move from their working years to their retired years. It might be pretty common to go from 22% or 24% to 12%. Or from 28% or 33% to 25%.

So to circle back, I agree with your observation that a Roth account balance is larger. And if someone wants to do the accounting for that, they'll get an even more precise understanding of economics. But seems like you need to "go all the way" with your analysis.

seattlecyclone

  • Walrus Stache
  • *******
  • Posts: 7264
  • Age: 39
  • Location: Seattle, WA
    • My blog
Re: When a Trad to Roth Conversion Isn't Ideal
« Reply #20 on: February 28, 2021, 11:57:00 AM »
Exactly. When you do "go all the way" and assume you invest the tax savings from traditional investments in a taxable index fund, the "you can shelter more in a Roth" factor does act as a small tiebreaker if you expect your marginal rates to be roughly equal now and in retirement, but it just isn't that significant in the grand scheme of things.

MustacheAndaHalf

  • Walrus Stache
  • *******
  • Posts: 6665
Re: When a Trad to Roth Conversion Isn't Ideal
« Reply #21 on: March 03, 2021, 02:21:34 AM »
Are you comparing the size of a Traditional IRA before withdrawal, which is in pre-tax dollars, with a Roth IRA, which is in post-tax dollars?
It doesn't just use a tax rate I put in, I mimicked tax software so it calculates my taxes in real time every year, using the current tax tables and historical increases to estimate the future tax rates based on the current system.

Where it is broken, I have not quite figured out yet.
I don't think you addressed my question, which is where I think you have a bug in your spreadsheet.

A Traditional IRA with $101k is actually smaller than a Roth IRA with $100k when you make an apples-to-apples comparison.

dbfire

  • 5 O'Clock Shadow
  • *
  • Posts: 34
Re: When a Trad to Roth Conversion Isn't Ideal
« Reply #22 on: March 03, 2021, 03:03:47 PM »
Are you comparing the size of a Traditional IRA before withdrawal, which is in pre-tax dollars, with a Roth IRA, which is in post-tax dollars?
It doesn't just use a tax rate I put in, I mimicked tax software so it calculates my taxes in real time every year, using the current tax tables and historical increases to estimate the future tax rates based on the current system.

Where it is broken, I have not quite figured out yet.
I don't think you addressed my question, which is where I think you have a bug in your spreadsheet.

A Traditional IRA with $101k is actually smaller than a Roth IRA with $100k when you make an apples-to-apples comparison.

Hi @MustacheAndaHalf, I appreciate you following up. My response was basically to say that I am not doing a comparison except in the sense that the sheet tells me when I run out of money. The sheet either takes $ from Trad IRA (The $ I need to pay expenses + the money I need to pay taxes on the distribution) or it takes from Roth IRA later (just the $ I need to pay expenses with no taxes). So in effect the sheet recognizes through the additional distribution to pay the tax that the accounts with the same balance would not be equal.

Unless I'm not quite understanding what you think might be broken?

MustacheAndaHalf

  • Walrus Stache
  • *******
  • Posts: 6665
Re: When a Trad to Roth Conversion Isn't Ideal
« Reply #23 on: March 04, 2021, 07:51:25 AM »
Oh, I thought by Trad IRA outlasting Roth IRA, you meant a larger ending balance.

The sheet either takes $ from Trad IRA (The $ I need to pay expenses + the money I need to pay taxes on the distribution) or ...
Maybe I'm misunderstanding this part, but if you need to withdraw $10,000 from a Trad IRA, in the 24% tax bracket you would withdraw $12,400?  Because it's actually more complicated than that:

$10,000 needed... withdraw $2,400 more to pay taxes
..now owe tax on $2,400... withdraw $576...
..now owe tax on $576... with draw $138.25 ...
... then pay $33.18 ... then pay $7.96... then $1.91 ... $0.46...

Adding that regression up is $13,157.76.
So you pay 24% tax of $3,157.86 and have $9,999.90 after tax money.
It's off because I didn't finish the regression.

If you withdraw amount needed + tax rate on that amount, you might have an error there.  Over time that would let the Traditional IRA keep 7.6% of withdrawals that should have been paid in taxes, and make it seem to last longer.

teen persuasion

  • Handlebar Stache
  • *****
  • Posts: 1226
Re: When a Trad to Roth Conversion Isn't Ideal
« Reply #24 on: March 04, 2021, 08:03:28 AM »
Thanks for your help, all of you. I'll have to think about this a little more and look to see where my spreadsheet is off. It has done a stellar job accurately calculating my taxes every year and handles the flow of expenses, income, inflation, and distributions and I've put a lot of work into it so I thought it was relatively sound. And yes, @reeshau, I was planning the Roth conversion up to the 12% limit and keeping the LTCG taxes from the taxable account at 0% at that time, as well. Or as close as possible. That's what I meant by playing around with numbers and timing. Conversions of different amounts (5k, 30k, 100k), it always came out worse.

@Telecaster I understand that if the tax rate is the same that the math is the same, but I don't fully comprehend (yet) why the timing isn't important. I still don't understand why having the $ now that I would've sent to the government isn't much better than sending it later, in which case I'll have more $ in my Trad IRA and can keep the same tax rate later but on more money.

But I'll read through the links you all kindly provided and try to wrap my head around it more. Thanks again!

I think I finally understand what you are doing with your spreadsheet (running it year by year until you run out of money, comparing when you run out instead of comparing balances).

Regarding the part above that I bolded - making Roth conversions up to the standard deduction, then using taxable assets up to the top of the zero LTCG bracket for expenses should be zero tax cost, right?  So how could small, $5k conversions still end up worse?  Maybe look at that scenario to tease out the error.

That is somewhat our plan, though we have no taxable assets to speak of.  We intend to Roth convert at least enough to use up the standard deduction each year (MFJ, so larger for us) and withdraw for expenses from previous Roth IRA contributions and past HSA unreimbursed expenses.  The question for us is whether we want to convert more, and pay 10% tax on that, or whether we are good at that level annually? 

It all depends on how quickly the tIRA grows (replacing the converted portion, or not quite and thus shrinking with time).  Part of this equation is what proportion of the tIRA is bonds.  We have all our bonds in the tIRA, plus some stocks, and only stocks in the Roth IRAs.  So if the tIRA is slowly being drained (while the rIRAs are left to grow), its proportion of bonds grows, reducing its income, shrinking it further with each conversion.  Hopefully we will get it to a manageable size by the time SS benefits start, so that much of SS is untaxed, keeping the total income again inside the standard deduction.  Hopefully RMDs would then be below the conversions we'd already been doing, and we keep rolling.

It's hard to know how much we need to do annually - too much early, and we've prepaid tax unnecessarily.  Not enough early, it's hard to course correct later, and we pay more tax later instead.  Find the sweet spot, we might pay zero or close to it, forever, leaving more to spend.

dbfire

  • 5 O'Clock Shadow
  • *
  • Posts: 34
Re: When a Trad to Roth Conversion Isn't Ideal
« Reply #25 on: March 05, 2021, 06:06:30 AM »
Oh, I thought by Trad IRA outlasting Roth IRA, you meant a larger ending balance.

The sheet either takes $ from Trad IRA (The $ I need to pay expenses + the money I need to pay taxes on the distribution) or ...
Maybe I'm misunderstanding this part, but if you need to withdraw $10,000 from a Trad IRA, in the 24% tax bracket you would withdraw $12,400?  Because it's actually more complicated than that:

$10,000 needed... withdraw $2,400 more to pay taxes
..now owe tax on $2,400... withdraw $576...
..now owe tax on $576... with draw $138.25 ...
... then pay $33.18 ... then pay $7.96... then $1.91 ... $0.46...

Adding that regression up is $13,157.76.
So you pay 24% tax of $3,157.86 and have $9,999.90 after tax money.
It's off because I didn't finish the regression.

If you withdraw amount needed + tax rate on that amount, you might have an error there.  Over time that would let the Traditional IRA keep 7.6% of withdrawals that should have been paid in taxes, and make it seem to last longer.

You are correct, that's why when I had the sheet built in Google Sheets it used an iterative calculation. When I shifted it to Excel I got around this by shifting the tax burden to the next year, so the tax from the conversion wouldn't hit the same year causing the circular reference.

dbfire

  • 5 O'Clock Shadow
  • *
  • Posts: 34
Re: When a Trad to Roth Conversion Isn't Ideal
« Reply #26 on: March 05, 2021, 06:21:43 AM »
Thanks for your help, all of you. I'll have to think about this a little more and look to see where my spreadsheet is off. It has done a stellar job accurately calculating my taxes every year and handles the flow of expenses, income, inflation, and distributions and I've put a lot of work into it so I thought it was relatively sound. And yes, @reeshau, I was planning the Roth conversion up to the 12% limit and keeping the LTCG taxes from the taxable account at 0% at that time, as well. Or as close as possible. That's what I meant by playing around with numbers and timing. Conversions of different amounts (5k, 30k, 100k), it always came out worse.

@Telecaster I understand that if the tax rate is the same that the math is the same, but I don't fully comprehend (yet) why the timing isn't important. I still don't understand why having the $ now that I would've sent to the government isn't much better than sending it later, in which case I'll have more $ in my Trad IRA and can keep the same tax rate later but on more money.

But I'll read through the links you all kindly provided and try to wrap my head around it more. Thanks again!

I think I finally understand what you are doing with your spreadsheet (running it year by year until you run out of money, comparing when you run out instead of comparing balances).

Regarding the part above that I bolded - making Roth conversions up to the standard deduction, then using taxable assets up to the top of the zero LTCG bracket for expenses should be zero tax cost, right?  So how could small, $5k conversions still end up worse?  Maybe look at that scenario to tease out the error.

That is somewhat our plan, though we have no taxable assets to speak of.  We intend to Roth convert at least enough to use up the standard deduction each year (MFJ, so larger for us) and withdraw for expenses from previous Roth IRA contributions and past HSA unreimbursed expenses.  The question for us is whether we want to convert more, and pay 10% tax on that, or whether we are good at that level annually? 

It all depends on how quickly the tIRA grows (replacing the converted portion, or not quite and thus shrinking with time).  Part of this equation is what proportion of the tIRA is bonds.  We have all our bonds in the tIRA, plus some stocks, and only stocks in the Roth IRAs.  So if the tIRA is slowly being drained (while the rIRAs are left to grow), its proportion of bonds grows, reducing its income, shrinking it further with each conversion.  Hopefully we will get it to a manageable size by the time SS benefits start, so that much of SS is untaxed, keeping the total income again inside the standard deduction.  Hopefully RMDs would then be below the conversions we'd already been doing, and we keep rolling.

It's hard to know how much we need to do annually - too much early, and we've prepaid tax unnecessarily.  Not enough early, it's hard to course correct later, and we pay more tax later instead.  Find the sweet spot, we might pay zero or close to it, forever, leaving more to spend.

Hi @teen persuasion, yeah you've hit one one of the areas I have to review in the sheet for accuracy. One reason why in my original post I focused more of the idea of whether or not other people were running into this "questioning of the math" without actually getting into the math because I knew how deep the math/sheet conversation could go.

You also hit on the overarching point here, which is that balance of paying the right amount of taxes at the right time. I think we all strive to plan it perfectly, yet we all need to get comfortable with that uncertainly. Especially since we know something may happen to the tax code in the future. The Fidelity link posted here was helped in that regard, showing me there are other ways. Since no one has really said though that their math on conversions doesn't come out in the same way that mine has, I'll have to keep digging. Less so on the spreadsheet side frankly and more on the philosophy.

Sandi_k

  • Handlebar Stache
  • *****
  • Posts: 1610
  • Location: California
Re: When a Trad to Roth Conversion Isn't Ideal
« Reply #27 on: March 05, 2021, 10:15:54 AM »
I want to ask one question: why would you prioritize pulling from your brokerage accounts in retirement prior to the Traditional IRA? I've always thought you'd pull from the tIRA first, so that you will not be subject to such high RMDs in your 70's...

Secondly, Roths are not subject to RMDs, so you want to tap those last.

Finally - does your spreadsheet account for the reversion of the tax rates that were cut in the 2016 Tax Cuts and Job Recovery Act?

Because the 12/22/24% brackets are set to revert in 2026: to 15%, 25% and 33%. So I am expecting taxes to be HIGHER in retirement, as I will have a pension that makes it impossible to control income to below the 25% bracket federally.

For these reasons, I am now maximizing my post-tax, mega-backdoor Roth contributions, so our accounts will be more balanced between Roth and traditional IRAs/457/403(b) investment accounts.

 

Wow, a phone plan for fifteen bucks!