James was searching the web, when he ran across my Taxes workbook and the sheet called Required Minimum Distribution (RMD). He was looking for an Excel spreadsheet that calculated the net balance each year on tax differed accounts (IRR, 401k, etc.) after the return on investments and the withdrawals due to RMD.

Rather than starting over, I added the table below on the same RMD sheet. The table calculates the balances of your accounts, out to age of 100 (good luck). The example below is truncated and show only to the age of 84.

Post: Required Minimum Distribution (RMD)

Workbook: Taxes

Peter BThank you for doing this. I also searched, to avoid reinventing the wheel. In my case this would be difficult as I am not a financial analyst type person.

The only limitation I see is that I want to use the spreadsheet to model my future income over my retirement. I need to calculate the RMD to add that to my other income (pension, rentals and social security) to see if I have enough funds moving forward.

The sheet I found blanks the table unless I make myself seventy years old. It would be nice to start now, and have blank withdrawals until I become of age (seventy), and start withdrawals then.

In any case, thank you for your excellent effort here.

Don PistulkaPost authorPeter,

You can use my post call “Annuity” to calculate your future retirement amount (download the spreadsheet from the Annuity post). There are two sheets in the workbook. You will probably use the monthly deposit sheet. Then put the future value of your accounts at 70 1/2 or 71, depending on your birthday, into the RMD calculation. You could combine the “Annuity” and the RMD workbooks into one workbook to make it more convenient.

God Bless,

Don

joshingahow’d you learn how to do all this, sir?

I thought i was smart by running standard deviations and such. But this is WAY above my pay grade!

Don PistulkaPost authorThanks You,

I hope you find one or two that are useful to you.

I am 71 years old and have been using spreadsheets since VisiCalc in the 1980s.

Pingback: Required Minimum Destribution (RMD) 3.0 | Excel@CFO

JessHey,

I work in a financial advisory office and part of my job duty entails calculating the RMD for each one of the clients. We have like 200 clients at the RMD stage, and they have IRAs from different companies and all that. Is there a spreadsheet out there that could help me out so it’s not one new sheet for each person? Or, maybe a starting sheet that has all of the client information in rows, and then for each new row a new sheet is created.

Basically, I just need to know if there is a simpler way to do this.

Thanks!

Don PistulkaPost authorJess,

I will take look at what you described and get back in a few days.

Don

Don PistulkaPost authorJess,

I am sending you an Excel workbook.

DCThanks for the great resource that calculates the Required Minium Distribution out to age 100.

I was trying to build this myself and then decided to search for it instead. You made it about 1 week before I needed it – thank you very much for sharing your knowledge.

Don PistulkaPost authorDC

Always glad to help a fellow septuagenarian.

Don