View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dana DeLouis Dana DeLouis is offline
external usenet poster
 
Posts: 947
Default 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