IRA Distribution Table Calculator

Account balance on 31 December last year The prior year-end fair market value of this account. Each account is calculated separately.

Whose account is it?

Age the owner reaches this year (years)The age attained during the distribution year, not the age today.

Year the owner was bornOptional. Used only to say at what age distributions have to begin.

Is a spouse the sole designated beneficiary?

Spouse's age this year (years)Only used when the spouse is the sole beneficiary and is more than 10 years younger.

Beneficiary's age in the first distribution year (years)For an inherited account: the age used to look up the Single Life Table the first time.

Years since the first distribution year (years)The Single Life factor is reduced by one for each of these years.

Already withdrawn this year

Years to project forward (years)

Assumed return on the balance (%)Used only to project the balance of later years in the distribution table.

Required minimum distribution

20,325.20

Required Minimum Distribution (RMD) Calculator

Distribution period

24.6 years

IRS table used

Uniform Lifetime Table (Table III)

If taken monthly

1,693.77

Share of the balance

4.0650 %

Still to withdraw this year

20,325.20

Excise tax if the shortfall is not taken

5,081.30

Excise tax if corrected in time

2,032.52

Balance after the distribution

479,674.80

Worked out from Treas. Reg. 1.401(a)(9)-9, Life expectancy and distribution period tables (T.D. 9930) and 3 other sources.

The distribution is calculated per account from its own prior year-end balance. IRAs may be aggregated when taking the total, but 401(k)-type plans generally may not.

Whether a distribution is required, which beneficiary category applies, and whether the 10-year rule replaces life-expectancy payments are tax and legal determinations this tool does not make. Confirm your facts with a qualified tax adviser and against current IRS guidance before acting.

How this is worked out

4 steps

Distribution period 24.6 for an owner aged 75.
RMD = balance / distribution period = 500000 / 24.6 = 20325.2.
Already withdrawn 0, leaving 20325.2 still to take.
A shortfall carries a 25% excise tax under IRC 4974(a), reduced to 10% if corrected within the two-year window.

Projected distributionstable

year	age	openingBalance	distributionPeriod	distribution
1	75	500,000	24.6	20,325.2
2	76	503,658.54	23.7	21,251.42
3	77	506,527.48	22.9	22,119.1
4	78	508,628.79	22	23,119.49
5	79	509,784.77	21.1	24,160.42
6	80	509,905.57	20.2	25,242.85
7	81	508,895.86	19.4	26,231.75
8	82	506,797.32	18.5	27,394.45
9	83	503,373.01	17.7	28,439.15
10	84	498,680.55	16.8	29,683.37
11	85	492,447.04	16	30,777.94
12	86	484,752.56	15.2	31,891.62
13	87	475,503.99	14.4	33,021.11
14	88	464,607.02	13.7	33,912.92
15	89	452,228.81	12.9	35,056.5
16	90	438,030.92	12.2	35,904.17
17	91	422,233.09	11.5	36,715.92
18	92	404,793.03	10.8	37,480.84
19	93	385,677.8	10.1	38,185.92
20	94	364,866.47	9.5	38,407
21	95	342,782.45	8.9	38,514.88
22	96	319,480.95	8.4	38,033.45
23	97	295,519.87	7.8	37,887.16
24	98	270,514.35	7.3	37,056.76
25	99	245,130.47	6.8	36,048.6

Results are general information, not financial, tax, legal, medical or engineering advice.