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

> Rent escalation is the increase in rent that a lease applies at fixed intervals, usually as a percentage of the rent being paid at the time. Because each increase builds on the last, the total rent over a lease, the average monthly rent and the final rent are all higher than the starting rent suggests.

## 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](/glossary/carpet-vs-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

| Assumption | Default | Notes |
| --- | --- | --- |
| Starting rent | Blank | From your own term sheet |
| Escalation | Blank (none) | The percentage in your own term sheet |
| Escalation every | 36 months | Change to your term sheet's interval |
| Lease term | 9 years | Change to your term sheet |
| Lock-in period | 3 years | Change to your term sheet |
| CAM and its escalation | Blank (left out) | Optional, from your term sheet |
| CAM escalation every | 12 months | Change to your term sheet's interval |
| Compounding | Each escalation on the current rent | Check how your term sheet words it |

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.

| Lease years | Monthly rent | Rent for each year | Rent for the period |
| --- | --- | --- | --- |
| 1 to 3 (lock-in) | 100 | 1,200 | 3,600 |
| 4 to 6 | 110 | 1,320 | 3,960 |
| 7 to 9 | 121 | 1,452 | 4,356 |
| **Total** | | | **11,916** |

- 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](/calculators/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.

## Frequently asked questions

### How is rent escalation calculated?

At each escalation date, the rent being paid is increased by the escalation percentage in the lease. Because the next increase applies to the already-increased rent, the escalations compound. Rent in any month is the starting rent × (1 + escalation) raised to the number of escalations that have taken place so far.

### How often does office rent escalate?

As often as your lease says. Many Indian office leases escalate every three years by a percentage stated in the term sheet, which is why the calculator starts at 36 months, but some escalate every year or on other terms. Use the interval and percentage in your own term sheet.

### What is the average effective monthly rent?

The total rent payable over the lease divided by the number of months. It is a single monthly figure that reflects the escalations, so two offers with different starting rents and escalations can be compared on one number for the same term.

### What does the lock-in total tell me?

The rent you are committed to whether or not you stay, because the lock-in period is the part of the lease you cannot leave without paying. It is the figure to weigh against what you expect to spend on the fit-out and the business case for the space.

### Does the calculator include CAM, GST or the deposit?

CAM can be added as an optional line with its own escalation and interval. GST, the security deposit, stamp duty and registration are not included; the occupancy cost calculator shows the deposit separately and adds the other running costs of the office.

---

Source: https://hagerstone.com/calculators/office-rent-escalation-calculator