Thread: calulation
View Single Post
  #1   Report Post  
Surazal Surazal is offline
Junior Member
 
Posts: 1
Post calulation

First, thank you for looking at this post and any and all help you can offer.

Is there a formula to calculate escalation?
Say I have a price of $43875.00, the average increase is 5.0% per year and I
want to escalate the 43875.00 over a 2 year period. I'm using this formula.
=FV(E2,D2,,-I2)
E2=.05
D2=2 YEARS
I2= $43875.00 2010 COST
The result is $47704.38

calculator comes up with;
2010=$43875.00
2011 INCREASE@ 5%=$2195.75
2011 SELLING PRICE=$43875.00+$2195.75=$46.68.75
2012 INCREASE@ 5%=$2303.44
2012 SELLING PRICE=$46.68.75+$2303.44
=$48372.19

What am I doing wrong?

Thank you for your help
Ron