Compute rent payable over the contact period after factoring in escalations

{ 0 Comments }

Assume the following data on a worksheet:

1. Cell B3 – Tenure of loan (in years).  This will be a whole number, say 15
2. Cell B5 – Escalation (in percentage), say 10%
3. Cell B6 – Escalation period (in months), This will be a whole number, say 24.  This means that the escalation will happen after every 24 months
4. Cell B7 – Rent per month, say 15,000

In cell B9, one may want to know the total rent payable over the tenure of the contact after factoring in the escalation clause.

You may refer to my solution in this workbook.

Leave a Comment

Your email address will not be published.

*