Required Minimum Distribution (RMD)

You can tell that I am running out of ideas to create new spreadsheets. I’m back to creating tax calculators. This one is concerned with the required minimum distribution (RMD) that everyone with an IRA or 401K will some day need to use. When you reach 70 1/2 (not 70 years old but 70 1/2 years old) the IRS requires you to start taking out a portion of your retirement savings that were tax deductible when you invested the funds. I don’t expect a lot of excitement over this entry. After all, how many 70 year olds are sitting around waiting for an Excel spreadsheet in their retirement, or even have Excel.

The RMD tables and calculations are simple. The factor needed comes off one IRS table, unless you have a spouse that is more than 10 years younger than you and is the sole beneficiary. Then the factor you need comes off a different table. The first year you must start the RMD can be confusing, because of the 70 1/2 year old rule. If your birthday is before July 1st of the year you turn 70, your have to start the RMD that year. If you were born after June 30th, you can wait until the next tax year.

All you need for input to this calculator is the value of all your IRAs and 401Ks on the last day of the previous year, your birthday, and the birthday of your spouse if he/she is more than 10 years younger than you and the sole beneficiary. I use the spouse’s birthday just to make sure of the 10 year difference. You don’t need your spouse’s birthday unless you answer YES to both the 10 years younger and beneficiary questions. If you do, a new box appears asking for the spouse’s birthday. After downloading the spreadsheet, select the RMD sheet:

The spreadsheet opens to a big disclaimer sheet. I am not a tax guru. I do my taxes with Turbo Tax. Always consult with your tax consultant on any of my calculators.

 

Download Taxes

 

 

4 thoughts on “Required Minimum Distribution (RMD)

  1. Doug Tucker

    This was extremely helpful. I could have typed the IRS factors into an Excel sheet but was pretty sure some thoughtful soul would have already done it (I had already built the “add a ROA and subtract a distribution and use the FYE amount for the next year” model so all I really needed was the IRS factors in an Excel column already). Thank you!!! And I’m sure this entire model has helped countless others who don’t really know how to build models in Excel. Cheers

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

  3. Pingback: Addition to Required Minimum Distribution | Excel@CFO

Leave a Reply

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

WordPress spam blocked by CleanTalk.