I saw someone posted this before but the person who answered it didn't
go into real detail of the numbers they chose for the answer.

I have a lease the payment is $10,000 a year, there is a 5% increases
every 5 years and the Lease lasts for 30 years.

What would be the formula in Excel that would show what the full
amount of lease payments that would have been made at the end of 30
years??

Also I want to be able to change the 5 years for every increase to any
number of years from 1-10 years.

Does anyone know a formula in excel that would do this?

Thanks