View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KevinM[_4_] KevinM[_4_] is offline
external usenet poster
 
Posts: 1
Default Annual Escalator's and Total Contract Value

I am trying to find a way to find my total contract value on a deal that has a 3% escalator on the anniversary of the contract every year.

Monthly Value: 5,000
Escalator: 3%
Contract Term: 48 months
Escalator: every 12 months

I can use the following formula to give me the ending value of the contract but i am looking for something to give me the total contact value

=(MonthlyValue*(1+Escalator)^((Term)/12))