This is my third post on RMD, thus the 3 point 0. The other two post are:
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.