Projected RMD calculator?

[COZICAN]

I've Googled everything. Trying to find a RMD calculator that will let me put in more than birthdate and savings. I need it to allow for withdraws from now (57.5) to 71.5. I've adjusted DOB, ROR etc and it just messes up the numbers. I'm trying to calculate future RMD's based on my current savings, minus WD's over the next 11 years plus interest.

 

[Big_Hitter]

do you have a spreadsheet software? you could bust that out yourself in excel, based on current law anyway

 

[sengsational]

i-orp

 

[COZICAN]

I-orp indeed gives some details. Thanks. Gets me in the ballpark anyway.

 

[cbo111]

Vanguard has a nice RMD calculator that you can enter different variables and "what-ifs." Not sure if it is only for enrolled customers.

 

[Dtail]

Fidelity also has a RMD column in their withdrawal details on their calculator.

 

[COcheesehead]

Fidelity also has a RMD column in their withdrawal details on their calculator.

I thought about that too, but I don't think you can modify the withdrawal date before 70.5, can you?

 

[Dtail]

I thought about that too, but I don't think you can modify the withdrawal date before 70.5, can you?

Yeah you are probably right.

 

[Bamaman]

You can get the information on the IRS.gov website for RMD percentages.

Unfortunately the year end balances on your IRA/401K's is a moving target--depending usually on how the stock market's doing. Makes future tax planning a little hit or miss.

 

[COcheesehead]

Maybe this one will help.

https://www.dinkytown.net/java/required-minimum-distribution-rmd.html

 

[Clone]

You can get the information on the IRS.gov website for RMD percentages.

Unfortunately the year end balances on your IRA/401K's is a moving target--depending usually on how the stock market's doing. Makes future tax planning a little hit or miss.

I have tried to do some modeling on RMDs and the impact on taxes. What I came up with is a decent estimate of what our taxes will be in the future, including an estimate of the impact of a surviving spouse.

Then you have the big question mark on the possibility if the tax rates will revert back to where they were a few years ago. The current tax schedule is a 'temporary'.

After December 31, 2025, the individual income tax rate schedule is set to revert to the pre-TCJA brackets and rates. Should this occur, many households would see their taxes go up significantly in 2026.

Top this off with a big slice of 'what do you think the market will do in the next 10-15 years'! I ended up with a philosophy that we will probably be in the 22% incremental tax bracket, it gets worse if one of us passes, and even worse if the tax tables revert. Therefore- ROTH convert as much as possible and just close your eyes, pinch your nose, and pay the taxes.

 

[foxfirev5]

IMHO there are many more considerations than a calculator can provide. For example DW and I have converted most of our equity holdings to our Roth accounts. Over 80% of our tIRA's in fixed income. This narrows the range for future RMD estimates. We simply take our current IRA balance and divide it by 27.4. Since it is pretty close to our current withdrawal of interest and dividends it is good enough currently at 7 years out.

 

[Cobra9777]

This sounds like a fairly routine spreadsheet exercise... beginning IRA balances, plus market change at some RoR assumption, minus pre-RMD WDs, minus RMDs (using IRS factors), equals ending balance. One row for each year. For us, it would also include Roth conversions.

As others have mentioned, the much harder part is predicting growth and future tax rates and then optimizing all this with the rest of your withdrawal strategy and decisions (like when to take SS). After lots of analysis, and even considering the one-spouse-dies-early scenario, I've decided not to convert beyond the top of the 12% bracket.

So regarding RMDs, at this point... it is what it is. If the market is generous, I'll happily pay my tax. If the market is a trainwreck, I'll be happy I didn't convert into the 22% bracket. I'm happy either way.

 

[Souschef]

I have both mine and DW's in a spreadsheet. I downloaded the table from the IRS.
I use it to keep track of my withdrawals. I have it to calculate the total that are QCD, plus $ to our sons,, some to me, and some for taxes. Once set up it is painless year to year