WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home » Financial Modeling Tutorials » Financial Calculators » Required Minimum Distribution Calculator

Required Minimum Distribution Calculator

By Harsh KataraHarsh Katara | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

Calculator for Required Minimum Distribution

Required Minimum Distribution calculator can be used to calculate the minimum amount that can be withdrawn from a tax-deferred retirement plan when a certain age is reached as per the applicable rules.

Required Minimum Distribution Calculator

B / F


Wherein,
  • B is the Account balance held as of last reported date
  • F is the factor to be used per life expectancy factor as defined by the authority
Account balance
$
factor to be used
$

About the Required Minimum Distribution Calculator

The formula and steps for calculating Required Minimum Distribution are per below:

Required Minimum Distribution = B / F

Wherein,

  • B is the Account balance held as of the last reported date.
  • F is the factor to be used per life expectancy factor as defined by the authority.

Required Minimum Distributions are used to calculate the amount for many types of retirement plans wherein the person reaches the defined age and shall become eligible to withdraw a minimum amount that would be based upon the factor which is again dependent upon the age, and that factor is also called as life expectancy.

Here, we shall discuss the calculation in terms of IRS forms. Below is the life expectancy factor that we shall use in our examples.

IRS Uniform Lifetime Table

RMD applies to many different retirement plans such as traditional IRA, SIMPLE IRA, 401(k) and 403(b) plans, etc.

How to Calculate Using the Required Minimum Distribution Calculator?

One needs to follow the below steps in order to calculate the amount of Required Minimum Distribution.

Step #1 – One needs to locate the age on the IRS table, which is given above (uniform life table).

Step #2 – Secondly, find out the life expectancy factor which corresponds to the age in question.

Step #3 – Figure out the retirement account balance as of the end of the last reported year, which is mostly 31st Dec in IRS plans.

Popular Course in this category
Sale
Financial Modeling Course (with 15+ Projects)
4.9 (927 ratings)
16 Courses | 15+ Projects | 90+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Step #4 – Now divide the figure derived in step 4 by the life expectancy factor that was determined in step 2.

Step #5 – The resultant figure in step 4 will be the minimum amount that is withdrawn from the IRS account and is the required minimum distribution amount.

You can download this Required Minimum Distribution Calculator Excel Template here – Required Minimum Distribution Calculator Excel Template

Example #1

Mr. X, who was living happily in Newark city. He has worked for around 60 years in a multinational company and is nearing the age of retirement. He has been contributing to the IRA account for the past 30 years. Yearly he has been depositing around $3,000 in the account, and he also earned interest to the tune of $90,000 till now.

Mr. X feels that when he reaches age 72, he would like to withdraw a certain amount to take care of financial expenses, which is due during that age. But he is unsure of the rules and regulations and the tax effect of same and doesn’t know what to do to withdraw from that account; and therefore, he approaches Mr. Y, who is a tax and legal advisor, and he helps him in calculating the minimum amount that can be withdrawn from that plan.

Based on the given information, you are required to calculate the required minimum distribution.

Solution:

Mr. X wants to withdraw the amount from the IRA account, but before that, we need to calculate the account balance he is having in that account.

He was depositing $3,000 every year till the age of 60, which is $3,000 x 60, which is $180,000, and the interest earned in that account is $90,000. Therefore, the total balance in that account will be $180,000 + $90,000 which equals to $270,000.

Now the age at which Mr. X wants to withdraw the amount is 72.

We shall now determine the life expectancy factor, which is based on age which is 72, and from the above IRS table discuss, the factor applicable is 25.6

Given Data Example 1

Now, we can use the below formula.

Required Minimum Distribution = B / F

Required Minimum Distribution Example 1-1

  • = $270,000 / 25.6
  • = $10,546.88

Therefore, Mr. X would be able to withdraw $10,546.88 at the age of 72.

Example #2

Mr. and Mrs. Singh, both aging 77 years, have been living in states for around 25 years while they migrated from India. They have been planning for their retirement, and one of them is a deposit in an IRA plan where both have done the contributions. Mr. and Mrs. Singh will be required to withdraw $15,000 when they both reach 78 since the education fees of their daughter is due.

The IRA plan, as of last December, had $250,567.89 in it. Based on the given information, you are required to calculate the minimum distribution amount that can be withdrawn and determine whether it meets their funding requirement.

Solution:

We are given the account balance as $250,567.89

Now the family would like to withdraw a certain amount at the age of 78.

We shall now determine the life expectancy factor, which is based on age which is 78, and from the above IRS table discuss, the factor applicable is 20.30

Given Data Example 2

Now, we can use the below formula to calculate the Required Minimum Distribution

Required Minimum Distribution = B / F

Required Minimum Distribution Example 2-1

  • = $250,567.89 / 20.3
  • = $12,343.25

Therefore, the family would be able to withdraw $12,343.25 at the age of 78, and there would be a shortfall of $15,000 – $12,343.25, which is $2,656.75.

Required Minimum Distribution Example 2-2

Conclusion

This calculator, as discussed, can be used for calculating the required minimum distribution amount per rules and regulations determined by the authorities for the IRA plans. This was just a simple example of calculating the amount; there are many different scenarios wherein beneficiaries are involved, such as a spouse, and more such complexities are involved, which can be discussed later on.

Recommended Articles

This has been a guide to the Required Minimum Distribution Calculator. Here we provide you the calculator that is used to calculate the Required Minimum Distribution amount for many types of retirement plans with some examples. You may also take a look at the following useful articles –

  • Calculate Car Down Payment
  • Calculate Debt Consolidation
  • Calculate VA Loan
  • Calculate Auto Lease
  • Credit Card Interest Calculator
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Download Required Minimum Distribution Calculator Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More