Welcome! Please Log In
Go
Home Portfolio Stocks Options Funds ETFs Hedge Funds Markets Tools Personal Finance Discuss
Advanced Search
Essentials Popular Topics
My Favorite Forums Join Discuss to setup a list of your favorite forums.
El Lobo's Roth conversion spreadsheet
meyerr 05-13-2008, 7:15 AM | Post #2517309 |  5 Replies
0  

El Lobo,

I can't make search work to continue the original discussion as you requested on the spreadsheet.  if and when we can make it work, we can append or copy and paste.

Sam and I played with El Lobo's Roth conversion spreadsheet this weekend.  In addition to Roth conversions, we looked at such things as adding a large lump sum such as an inheritance or rollover into assets, death of a spouse with subsequent loss of SS and/or pension income, paying for nursing home costs at varying ages.  It worked fine with one minor glitch.   Sam tried to convert 200k each from ira's to Roths in 2010.  The spreadsheet showed $2 for him and 200k for me, although it picked up the correct totals for 2011.

The only flaw, which he (Sam) can fix is that it assumes that Roth Conversions end when RMD's start.

I still have a hair up my nether regions about using sheltered rather than taxable assets to decrease future RMD's and increasing assets to be inherited since we obviously will not be able to convert  except in 2010.  We'll use the spreadsheet to play with that scenario .

Roberta 

 Related Topics
Page 1 of 1
roberta and Others!
copie 05-13-2008, 8:22 AM | Post #2517328
0  

Now is the time when I start geting my horses(IRA stocks) lined up to go over to the other side(Roth) and I need yours and others wisdom on which ones to convert!

Since I have only so much money paided in est. taxes to cover so much money converted then who do I choose this year and in what order?

On one hand I have the high price oil stocks like CVX(97.35), RDS.A(81.12) and XOM(89.19) in one group.

Another group like JnJ(66.54), PG(65.12), MMM(77.01), KMR(56.31), GE(32.40) and WMT(58.02).

Or from my depressed bank stocks: WB(28.06) and RF(21.74).

Do I take a percent from each group? Do I jump on the bank stocks where I can do a lot more shares? Do I just do oils because of price appreciation over the next several years?  Do I stay in the middle and convert more shares of the JnJ's and PG's?

Any ideals from anyone will be appreciated!

Copie

 Related Topics
Re: roberta and Others!
meyerr 05-14-2008, 4:23 AM | Post #2517659
0  

Copie,

The amounts conversions are not  limited by the amount of estimated taxes paid however you will need to find the money to pay the additional taxes.

I could argue for doing the financials and playing cost basis losses until they stabilize.  I could also argue for the large caps b/c I see growth in their future (I've been seeing large cap growth breakout for almost five years now :-) ) and now would be the least expensive time to do it and allow for the growth with step up basis to occur outside the IRA.  I could also argue for the oil stocks to remain in the IRA if you're going to trim them and take profits or the exact opposite and move them when they're cheap.

I don't try to balance sheltered and taxable portfolios.  It's all one pot.

Roberta 

 Related Topics
Re: roberta and Others!
copie 05-14-2008, 7:38 AM | Post #2517675
0  

Roberta thanks for your comments and I like you see good in all areas on which ones to convert. May end up drawing names out of a hat!

Copie
Re: El Lobo's Roth conversion spreadsheet
Frank Wood 05-14-2008, 6:23 PM | Post #2517869
0  

What appears to be  the original link  http://www.wwest.net/~chuckjan/IRAConversions.xls

in thread 2864 in Investing During Retirement no longer works.  Does anybody have a link to the spreadsheet which does work? 
Re: El Lobo's Roth conversion spreadsheet
ElLobo 05-14-2008, 9:04 PM | Post #2517931
0  

That was a link to our private website, where I deposited files.  If you send me an email, I can send you the file.  Our address is

JanChuck, and we are at WWest.net.

Please, no spam.
Top
Page 1 of 1
 
Corrections Site Map Help Advertising Opportunities Licensing Opportunities Glossary Store
© Copyright 2008 Morningstar, Inc. All rights reserved. Please read our Terms of Use and Privacy Policy.
Quotes for NASDAQ are 15 minutes delayed. All other exchanges are delayed 20 minutes.