View Single Post
  #3  
Old 08.02.2013, 12:40
BrianJW BrianJW is offline
Forum Veteran
 
Join Date: May 2009
Location: suburbs of LA, USA
Posts: 934
Groaned at 11 Times in 10 Posts
Thanked 873 Times in 439 Posts
BrianJW has a reputation beyond reputeBrianJW has a reputation beyond reputeBrianJW has a reputation beyond reputeBrianJW has a reputation beyond repute
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
Reply With Quote
This user would like to thank BrianJW for this useful post: