Required Minimum Distribution (RMD) 3.0

This is my third post on RMD, thus the 3 point 0. The other two post are:

http://pistulka.com/Other/?p=2422

http://pistulka.com/Other/?p=2674

Read my first post if you are not familiar with RMD. This Excel workbook came about at the request of a reader who’s firm manages hundreds of retirement plans. I put together a spreadsheet to calculate RMD for multiple accounts.

I also included my declaimer, that I am not a tax adviser, tax attorney, or CPA. Also that this calculator is given “as-is” with no guarantee as to its accuracy or completeness. It covers most situations, but not all.

Each row contains the information for one client. The yellow cells are input cells. The calculator assumes the user wants to calculate RMD for the current year and it updates each year automatically. If you need to keep the current years information and you are getting close to year end, print a PDF copy.

The eligibility information shows which table the calculator will use. The factor comes from that table. It determines if the client is 70 and a half, and if the spouse is 10 years or more younger than the client. The client and spouse’s ages are only used if the table gets the factor from TableII.

 

Download  RMD_3.0

6 thoughts on “Required Minimum Distribution (RMD) 3.0

  1. Bill Stone

    How about an excel file that will calculate remaining savings with an RMD drawdown and a monthly reinvestment. My wife is much younger than me and I want to make sure the remaining savings will be enough. This seems like a very common issue but I cannot find a calculator or excel template that does this task.

    Reply
  2. Gunther

    Don. These are great! Have you ever thought about making a stretch IRA calculator? I would love to share with you how the RMD calc could be tweaked to become a Stretch IRA calculator. I will be working on building off your current workbook and would love to collaborate with you. Please email me if interested.

    Kindest,
    G

    Reply
    1. Don PistulkaDon Pistulka Post author

      Gunther,
      I Googled “Stretch IRA” and found a lot of confusion between older websites and newer ones. It seems new laws have changed the rules. It would help to see a schematic diagram on how the current laws apply and what the options are. It is appears by your e-mail address, that you are a financial planner and could provide such a diagram. Let me see what you have so far, working off my spreadsheet, and I will see if I can help. Email at blog@pistulka.com. Thanks

      Don

      Reply
  3. Dave Morris

    Are contributions appropriate?

    Any security concerns downloading this on the Internet, given the site is not HTTPS?

    Thanks! –Dave

    Reply

Leave a Reply

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

WordPress spam blocked by CleanTalk.