**Re: Need help with Pension Planning on Excel Spreadsheet - Formula headache ...**
so you want to know the equivalent of 1.2m in 25 years from now with 3% inflation?
I make it 2.5m. You are basically applying compound interest.
There would be a formula Im guessing it`s 1.2m * (1.03 to the power of 25) don`t know how to express that on computer.
i just take 1,200,000 x 1.03 year 1, take that answer (1,236,000) and multiply X 1.03 and you get the answer year 2 (1,273,080) in 2 columns repeat this start amount, end amount 25 times you get 2,512,534.
Hope that helps.
ps and if you want 5,000 of todays money in 25 years time you will need 10,469.
*
Last edited by BrianJW; 08.02.2013 at 12:43.
Reason: added ps
* |