Rent Increase Calculation for Data Take-On
Hi,
I have the following scenario:
Lease Commencement = 01-NOV-2012
Lease Termination = 31-OCT-2015
Therefore Lease Term is 3 years
The lease has a base rent for a monthly Actual amount of 100 ; 1200 Annual Amount.
I then created a rent increase of 10% to occur on the following Basis Periods:
01-Nov-2013 and 01-Nov-2014
Therefore the calculation should be as follows:
01-Nov-2012 until 01-Oct-2013 = 100 per month ; Annually = 1200
01-Nov-2013 until 01-Oct-2014 = 110 per month (As 10% of 100 = 10 therefore 100 + 10 = 110) ; Annually = 1320
01-Nov-2014 until 01-Oct-2015 = 121 per month (As 10% of 110 = 11 therefore 110 + 11 = 121) ; Annually = 1452
HOWEVER I am not receiving the above but rather the following:
01-Nov-2012 until 01-Oct-2013 = 100 per month ; Annually = 1200 - refer to point A on excel