Join Early Retirement Today
Reply
 
Thread Tools Display Modes
Bonds in Taxable Account or tIRA - Spreadsheet Answer
Old 04-13-2014, 08:17 PM   #1
Thinks s/he gets paid by the post
 
Join Date: Jul 2005
Posts: 4,366
Bonds in Taxable Account or tIRA - Spreadsheet Answer

While placing bonds and other income producing investments in a traditional IRA makes sense to avoid the tax drag, it always bugged me that it also resulted in the low growth (presumably) investment going into the tIRA.

So, considering everything, where is the best place for bonds? What I found was that of course the tIRA was better for both stocks and bonds (with equal in and out tax rates). However, the advantage was larger with stocks rather than bonds. So if you contribute $1000 for stocks in the tIRA and $1000 - $250 taxes for bonds in the taxable account your withdrawal amounts are higher than if you bought bonds in the tIRA and stocks in the taxable account. The withdrawals were about 8% higher with bonds in a taxable account and stocks in the tIRA. The result was fairly robust with a few different tax rates and investment gains. Bond yields had to approach stock total returns before they were better placed in the tIRA.

I made a spreadsheet, hopefully attached, that compared the income available if you have $1000/year available to save pre-tax, and saved it as stocks or bonds in a taxable account or stocks or bonds in a tIRA. I assume 30 years of saving, and then 30 years of withdrawals, with the withdrawals sized to zero out the portfolio in the last year.

I used a fixed stock growth rate of 6% plus a 1% yield. I used a fixed bond yield of 3% with 0% principal growth. No inflation, so it's all real rates. I taxed the yields at a 15% rate in the taxable account. I taxed stock withdrawals at 10% from the taxable account, assuming 15% capital gains and noting roughly 1/3 tax basis at retirement to avoid tracking the stock basis. I taxed contributions to the taxable account at a 25% rate and withdrawals from the tIRA at 25%. The results were about the same using a 15% tax rate for both.

The spreadsheet uses iteration to find the withdrawal amount that gives a $0 final portfolio value for each of the four combinations of stock/bonds and taxable/tIRA.

You can plug in your own numbers or modify to your heart's content. This is just a quick and dirty start.

Attachment 18629

or

https://www.dropbox.com/s/tbvsnh2ccb...0or%20tIRA.xls

(I can't get the regular attachment to download for me.)
Attached Files
File Type: xls Taxable%20or%20tIRA.xls (30.5 KB, 17 views)
Animorph is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Old 04-13-2014, 09:57 PM   #2
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
pb4uski's Avatar
 
Join Date: Nov 2010
Location: Sarasota, FL & Vermont
Posts: 36,263
Did you consider that stocks generate qualified dividends and LTCG in a taxable account are taxed at 0% or 15% depending on your tax bracket and bond interest in a taxable account is taxed at ordinary rates?

I think what you are seeing is the power of deferral of taxes.

I think a 2% dividend yield would be more realistic than 1%.
__________________
If something cannot endure laughter.... it cannot endure.
Patience is the art of concealing your impatience.
Slow and steady wins the race.

Retired Jan 2012 at age 56
pb4uski is offline   Reply With Quote
Old 04-14-2014, 06:57 AM   #3
Thinks s/he gets paid by the post
 
Join Date: Jul 2005
Posts: 4,366
Quote:
Originally Posted by pb4uski View Post
Did you consider that stocks generate qualified dividends and LTCG in a taxable account are taxed at 0% or 15% depending on your tax bracket and bond interest in a taxable account is taxed at ordinary rates?

I think what you are seeing is the power of deferral of taxes.

I think a 2% dividend yield would be more realistic than 1%.
Easy enough to try that out. If I change to a 5% growth and 2% yield for stocks, placing the bonds in the taxable account gives 11.5% better retirement income. 4% growth and 3% yield makes it 15% better. More yield for stocks, leaving total growth the same, makes it look even better inside the tIRA where the increased yield is not taxed.

The big key is getting the most tax deferred growth. That's stocks unless you expect them to do worse than bonds.

I needed 0% growth and 5% to 6% yield for bonds to make it pay to put bonds in the tIRA. Certainly that could apply in the future, but not today.
Animorph is offline   Reply With Quote
Old 04-14-2014, 07:33 AM   #4
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
pb4uski's Avatar
 
Join Date: Nov 2010
Location: Sarasota, FL & Vermont
Posts: 36,263
So its seems to me that you have proved that if deferral of taxes is good then more deferral of taxes is better.

But.. I'm guessing that the advantage diminishes if you apply ordinary tax rates to bond income and preferential tax rates to equity income.
__________________
If something cannot endure laughter.... it cannot endure.
Patience is the art of concealing your impatience.
Slow and steady wins the race.

Retired Jan 2012 at age 56
pb4uski is offline   Reply With Quote
Old 04-14-2014, 10:25 AM   #5
Thinks s/he gets paid by the post
 
Join Date: Jul 2005
Posts: 4,366
Quote:
Originally Posted by pb4uski View Post
So its seems to me that you have proved that if deferral of taxes is good then more deferral of taxes is better.

But.. I'm guessing that the advantage diminishes if you apply ordinary tax rates to bond income and preferential tax rates to equity income.
I did tax bond income at 15%. If I raise that to 25%, holding bonds in the taxable account results in a 6% retirement income benefit instead of the original 8% benefit. So that does move in the direction of favoring bonds in the tIRA, but not by a lot. If I use 0% tax on stock dividends as well, the benefit goes from 6% to 3%. Still favoring bonds in the taxable account, or really placing as much of your stocks as possible into the tIRA.

You really have to fool with the growth and yield assumptions pretty heavily before stocks in a taxable account looks better.
Animorph is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Your invested assets: taxable vs TIRA/401k vs Roths haha FIRE and Money 119 02-01-2014 08:09 PM
Tracking basis with spreadsheet, how to structure the spreadsheet? bamsphd FIRE and Money 13 08-03-2009 09:31 AM
Bonds in taxable account? harley FIRE and Money 11 11-18-2008 03:58 PM
How to allocate taxable and non-taxable money? Olav23 FIRE and Money 6 01-10-2007 12:28 PM
Taxable or Non Taxable Seeker FIRE and Money 3 05-07-2005 11:23 AM

» Quick Links

 
All times are GMT -6. The time now is 09:13 AM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2024, vBulletin Solutions, Inc.