If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




Escalation Formula
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 $1,000, the average increase is 4.5% per year and I want to escalate the 1000 over a 10 year period. Could this be done? I'm trying to find the result for each year and then separately for year 10. Thank you for your help Joe 
Ads 
#2




Escalation Formula
assuming
a1 = 1000 b1 = 4,5% c1 = # of years (1,2..10) d1 =(a1*(1+b1)^c1) change c1 to see the result as you need hth  regards from Brazil Thanks in advance for your feedback. Marcelo "Joe Gieder" escreveu: > 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 $1,000, the average increase is 4.5% per year and I > want to escalate the 1000 over a 10 year period. Could this be done? I'm > trying to find the result for each year and then separately for year 10. > > Thank you for your help > Joe 
#3




Escalation Formula
Thank you for the formula. It does just what I need. How does the formula
know to compound? "Marcelo" wrote: > assuming > > a1 = 1000 > b1 = 4,5% > c1 = # of years (1,2..10) > d1 =(a1*(1+b1)^c1) > > change c1 to see the result as you need > > hth >  > regards from Brazil > Thanks in advance for your feedback. > Marcelo > > > > "Joe Gieder" escreveu: > > > 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 $1,000, the average increase is 4.5% per year and I > > want to escalate the 1000 over a 10 year period. Could this be done? I'm > > trying to find the result for each year and then separately for year 10. > > > > Thank you for your help > > Joe 
#4




Escalation Formula
If you wish...
=FV(4.5%,C1,,1000) where C1 is the year in question.  HTH :>) Dana DeLouis "Joe Gieder" > wrote in message ... > Thank you for the formula. It does just what I need. How does the formula > know to compound? > > "Marcelo" wrote: > >> assuming >> >> a1 = 1000 >> b1 = 4,5% >> c1 = # of years (1,2..10) >> d1 =(a1*(1+b1)^c1) >> >> change c1 to see the result as you need >> >> hth >>  >> regards from Brazil >> Thanks in advance for your feedback. >> Marcelo >> >> >> >> "Joe Gieder" escreveu: >> >> > 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 $1,000, the average increase is 4.5% per year and I >> > want to escalate the 1000 over a 10 year period. Could this be done? I'm >> > trying to find the result for each year and then separately for year 10. >> > >> > Thank you for your help >> > Joe 
#5




Escalation Formula
Thank you for the formula it works perfectly, I appreciate your help and
response. One question, why do you use a 1000? I used the formula without it and I received a negative answer for the value but why does this formula require a 1000? Joe "Dana DeLouis" wrote: > If you wish... > > =FV(4.5%,C1,,1000) > > where C1 is the year in question. > >  > HTH :>) > Dana DeLouis > > > "Joe Gieder" > wrote in message > ... > > Thank you for the formula. It does just what I need. How does the > formula > > know to compound? > > > > "Marcelo" wrote: > > > >> assuming > >> > >> a1 = 1000 > >> b1 = 4,5% > >> c1 = # of years (1,2..10) > >> d1 =(a1*(1+b1)^c1) > >> > >> change c1 to see the result as you need > >> > >> hth > >>  > >> regards from Brazil > >> Thanks in advance for your feedback. > >> Marcelo > >> > >> > >> > >> "Joe Gieder" escreveu: > >> > >> > 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 $1,000, the average increase is 4.5% per year > and I > >> > want to escalate the 1000 over a 10 year period. Could this be done? > I'm > >> > trying to find the result for each year and then separately for year > 10. > >> > > >> > Thank you for your help > >> > Joe > 
#6




Escalation Formula

Thread Tools  
Display Modes  

