Hi Forum,

I am not sure if this is the right place for my query, but i am struggling with a (what i think is )a simple way of representing a formula.

So here is what it is.

I have an initial cost value , let's say 100 for year 1.
I want this value to increase at a rate of 5% each year.
I want to know my total cost at year n.

So if we take an example for 3 years.
r= my rate (i.e. 5%(0.05))

=100+100*(1+r)+((100*(1+r))*(1+r))

I am creating a userform which will populate the number of years and the rate in two cells. I just need the formula in my third cell to give me the total value.

Can anyone help here ?

Kind regards,

xvx_warrior