ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Annual Escalator's and Total Contract Value (https://www.excelbanter.com/excel-discussion-misc-queries/453167-annual-escalators-total-contract-value.html)

KevinM[_4_]

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