calculate the total amount paid for y years if the rent increases by x% every year

36 Views Asked by At

How do I calculate the total amount paid for y years if the rent increases by x% every year?

I know that the rent for year x = startingRent * (1 + increaseFraction)^number of years.

And I could put that in excel and add em all up.

But is there a way to calculate the total in one line?