Office Rent Escalation Calculator: Rent Year by Year Over the Lease

What it calculates

From the terms in your own term sheet, the calculator works out the rent payable month by month over the lease and shows:

• a year-by-year table of the monthly rent and the rent for each year;
• the total rent over the lock-in period;
• the total rent over the full term;
• the average effective monthly rent over the term;
• the final monthly rent, after the last escalation;
• the same for CAM (common area maintenance), if you enter it.

It contains no rents. Every amount and every escalation percentage is yours. The calculator stores nothing, and the rent and escalation fields start blank.

Inputs

• Chargeable area: the area the rent is charged on, in sq ft, as stated in the term sheet. This is often larger than the carpet area; the carpet and built-up area entry explains the difference.
• Starting rent: either a monthly rent for each sq ft of chargeable area, or the total monthly rent.
• Escalation: the percentage increase stated in your term sheet. Blank means no escalation.
• Lease term and lock-in period, in years.

In the assumptions panel:

• Escalation every: the interval in months. Many Indian office leases escalate every 36 months, so the calculator starts there, but use the interval in your own term sheet.
• CAM, its escalation and its interval: optional, from your term sheet.

Method

1. Starting monthly rent = rent for each sq ft × chargeable area, or the total as entered.
2. Escalations so far = the number of whole escalation intervals completed before that month.
3. Rent in a month = starting monthly rent × (1 + escalation) ^ escalations so far.
4. Rent for a year = the sum of its twelve months.
5. Rent over the lock-in = the sum of the months in the lock-in period.
6. Rent over the term = the sum of every month in the lease.
7. Average effective monthly rent = rent over the term ÷ months in the term.
8. CAM, if entered, is worked out the same way with its own escalation and interval.

Assumptions

The first escalation falls at the end of the first interval: with a 36-month interval, the rent changes at the start of month 37.

Limitations

• It applies the escalation as compounding. If your lease escalates on the starting rent each time (a flat increase), the later years will be lower than shown.
• It assumes a fixed interval and percentage. Leases that step differently in different periods, or link the rent to an index, need working out period by period.
• It leaves out rent-free periods. If the landlord gives a rent-free fit-out period, the rent starts later than the lease and the totals here are too high.
• It does not include GST, the deposit, stamp duty or registration. Add those separately, and have their treatment confirmed by your chartered accountant.
• It does not discount future rent. Money paid in year nine is counted the same as money paid in year one.
• It is not a reading of your lease. The lease document, not this calculator, decides what you owe.

Worked example

Suppose an offer at a starting rent of 100 units a month, escalating 10% every 36 months, with a 9-year term and a 3-year lock-in. The figures below are invented for the example and are not market prices.

• Rent over the lock-in: 3,600 units.
• Rent over the full term: 11,916 units, after 2 escalations.
• Average effective monthly rent: 11,916 ÷ 108 = 110.33 units.
• Final monthly rent: 121 units, 21% above the starting rent.

The second escalation builds on the first: 110 × 1.10 = 121, not 100 + 10 + 10 = 120.

How occupiers use it

When two or more buildings are on the shortlist, the starting rents are rarely the whole story. One offer may start lower but escalate more often, or carry a longer lock-in. Running each term sheet through the calculator puts them on the same footing: the commitment over the lock-in, the total over the term and the average monthly rent. Those figures then sit alongside the fit-out budget and running costs in the office occupancy cost calculator.

The year-by-year table is also the basis for a rent budget, so finance teams know which years the rent steps up.

When a professional must replace it

Use the calculator to understand and compare the rent commitment in your own term sheets. Before you sign, have the lease reviewed by a lease advisor or property lawyer, who will check how the escalation, lock-in, rent-free period, CAM and exit terms are actually written, and have the tax and accounting treatment of the lease confirmed by your chartered accountant.