Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Another Time Calulation | Excel Discussion (Misc queries) | |||
CALULATION OF DURATION | Excel Discussion (Misc queries) | |||
Another Time Calulation Question - Sorry. | New Users to Excel | |||
Getpivot calulation | Excel Worksheet Functions | |||
Date calulation | Excel Programming |