Hi
I am trying to put together a worksheet to track rent increase . the lease can be for any no of years . The escalation may be 12 ,36, 48 months interval.at say 10%. eg if the rent is $1000 start of lease date is 1-1-21, increase % 10%, increase interval is 36 months ,. then on 1-1-24 (36months from the lease date,) the worksheet should show rent increase date and new rent which would be 1100, then on 1-1-27 the new rent increase date will be shown as 1-1-27 and rent as 1210 so on until expiry of the lease agreement. ANy help will be appreciated
Regards
Shamsu
I am trying to put together a worksheet to track rent increase . the lease can be for any no of years . The escalation may be 12 ,36, 48 months interval.at say 10%. eg if the rent is $1000 start of lease date is 1-1-21, increase % 10%, increase interval is 36 months ,. then on 1-1-24 (36months from the lease date,) the worksheet should show rent increase date and new rent which would be 1100, then on 1-1-27 the new rent increase date will be shown as 1-1-27 and rent as 1210 so on until expiry of the lease agreement. ANy help will be appreciated
Regards
Shamsu