I’m trying to calculate the NPV of a lease that has annual % rent increases. I want to set up a template that I can change the number of years of the lease, % rent increases, rent amount in cost per square foot, and the number of square feet in the lease without having a schedule of each individual year’s payments. Currently, all I can figure out how to do is create a schedule but that means I have to have different schedules for different length leases, which isn't very concise.