Dear Friends,

Can you help me with a formula that calculates the total cost for a dynamic number of years where the cost escalates at a periodic interval.

Eg:

Cost in Year 1 - $ 100
Escalation after every 3 years = 12%
Total cost in no of years = make the number of years dynamic

I should be able to get the total cost by changing the number of years eg: 3 years, 5 years, 7 years, 10 years etc.

Appreciate your help in this matter.

Thanks...Chaitanya