I'm try to figure out the formula for determining the present day equivalent of a future amount of money (adjusting for inflation). Specificially in determining retirement account growth as the years go on, how much would the value of money in X year (eg: 2037) be in today's dollars? I've already got the spreadsheet determining the value of the account based on contributions and rate of rate... but adjusting for inflation I cannot figure out.
I can't seem to find the formula... but it seems like there's got to be a predone template out there for something like this.
cells value
A1 retirement account value
B1 account value in today's dollars
thanks!
Heather
I can't seem to find the formula... but it seems like there's got to be a predone template out there for something like this.
cells value
A1 retirement account value
B1 account value in today's dollars
thanks!
Heather