0ceeb7ee-07dc-4e53-a90f-e6b7aa39e657 31 2 5 false false 0 decimal

&[DATE] &[TIME] - &[FILENAME]

Dist # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # 301 mat :

CALCULATION OF RMD BY INTERPOLATINNG IRS WORKSHEET TABLES

Age 70100 range :

Age length 31

IRS WORKSHEET TABLES AGE VS. DIST PERIOD

IRA AT 31 DECEMBER OF PREVIOUS YEAR =

IRA 801250.45 :

Age 707172737475767778798081828384858687888990919293949596979899100311 mat

Dist 27.4 26.5 25.6 24.7 23.8 22.9 22.0 21.2 20.3 19.5 18.7 17.9 17.1 16.3 15.5 14.8 14.1 13.4 12.7 12.0 11.4 10.8 10.2 9.6 9.1 8.6 8.1 7.6 7.1 6.7 6.3 311 mat :

AGE AT BIRTHDAY OF THIS YEAR =

AGE 76 :

Define log-log interpolation

X1 Age ln vectorize :

Y1 Dist ln vectorize :

Z 70100 70.1 range :

ZL Z ln vectorize :

ZL length 301

a b c linterp2 n c length : result n Zeros : i 1 n range result i el a b c i el linterp : for result 41 line :

Logarithm Interpolation:

YYL X1 Y1 ZL linterp2 :

Convert back to regular space:

YFIT YYL exp vectorize :

Distribution Period at Birthday of this year =

Z YFIT AGE linterp 22

RMD FOR THIS YEAR =

RMD IRA Z YFIT AGE linterp / :

RMD 36420.48

PLOT LOG-LOG INTERPOLATION FIT TO THE IRS WORKSHEET TABLES FOLLOWS ON NEXT PAGE

DATA Age Dist o 16 blue augment :

FIT Z YFIT augment :

DATA FIT 2 1 sys