Trying to write a formula that will allow lease rate escalation to be variable between two rates. Example inputs:
Lease Start Rate = $20/sq ft/yr
Escalation years 2-3 = 10%
Escalation years 4-end of lease = 4%
Square feet of lease = 15,000
Lease starts year x
Lease ends year y
Any thoughts or help appreciated
Lease Start Rate = $20/sq ft/yr
Escalation years 2-3 = 10%
Escalation years 4-end of lease = 4%
Square feet of lease = 15,000
Lease starts year x
Lease ends year y
Any thoughts or help appreciated
