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)) |
All times are GMT +1. The time now is 12:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com