Addition to Required Minimum Distribution

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

Don Pistulka

Retired Credit Union CFO - Finance
Background: over 40 years in investments, asset/Liability management, banking, securities trader.
Worked for: California Credit Union, WesCorp, CalFed S&L, Crocker Bank, Carroll McEntee, Federal Home Loan Bank Board (D.C.), Western Asset Management, Security Pacific National Bank.


  1. I am so excited to find this tool. It does exactly what I am looking for. However, RMD age is changed from 70 1/2 to 72. Does this tool still work if I want to calculate RMD based on age 72?


    1. Hi Tracy,
      I put a disclaimer on the first sheet in the workbook. It is not only the starting age that was changed, but new tables will be published (not sure when). I was confident about the calculations up until this year. I’m not a tax expert, only an Excel fanatic. At some point I might try and update the spreadsheet, but for now you would be better off relying on your financial institution.


  2. Thank 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.

    1. Peter,
      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,

  3. how’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!

    1. Thanks 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.

  4. Hey,

    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.


        1. Hi Don –

          I would also be interested in the excel workbook you sent Jess back in July if you wouldn’t mind sharing – I have been trying for weeks to solve the puzzle on how to neatly track RMDs for all clients and so far it isn’t any neater πŸ™


  5. Thanks 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.

Leave a Reply to Don Pistulka Cancel reply

Your email address will not be published. Required fields are marked *