Home 
Search 
Today's Posts 
#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 
#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

Reply 
Thread Tools  Search this Thread 
Display Modes  

