Hi umesh,

What I mean is that, given a starting and ending age, you can calculate whatever scenario you're interested in via a single formula. See attached. The 'retirement funds' value expressed in current-dollar terms. If you want to see the actual dollars, simply set the assumed inflation rate to 0.

Attached Files

Demo.xlsx (8.4 KB, 9 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]