Lease Escalation Calculator — CPI, RPI, INSEE, VPI

Q: How is index-linked rent escalation calculated?

Index-linked rent is typically the base rent multiplied by the ratio of the current index value to the base index value, plus any fixed margin the lease adds (for example CPI + 1.5%). Caps and collars then limit how much any single adjustment can move.

Q: Which indices does this calculator support?

Fixed percentage escalation, and index-linked escalation with presets for US CPI-U, UK CPI, UK RPI, German VPI and the French INSEE family: ILAT, ILC, ICC and IRL. You can also enter any custom index values.

Q: Where do I find official index values?

US CPI-U is published by the Bureau of Labor Statistics (bls.gov), UK CPI and RPI by the Office for National Statistics (ons.gov.uk), the German VPI by Destatis (destatis.de), and the French ILAT, ILC, ICC and IRL series by INSEE (insee.fr).

Q: Can a rent escalation be negative?

Yes, if the lease has no collar. For example, the French ILC fell 0.45% year-on-year to Q1 2026 and the ICC fell 2.89% — an uncollared ILC- or ICC-linked rent would decrease. Many leases add a 0% collar to prevent this.

Try a worked example:

Base rent (per period)

Currency

Adjustments to project

Escalation % per adjustment

Compounding

Cap per adjustment % (blank = none)

Collar per adjustment % (blank = none)

How the calculator works

Fixed percentage: each adjustment multiplies the rent by (1 + rate). In compounding mode the rate applies to the already-escalated rent; in simple mode each step adds the same absolute amount computed on the base rent.

Index-linked: the classic formula is new rent = base rent × (current index ÷ base index), plus any margin the lease stacks on top: the pattern behind clauses like “CPI + 1.5%”. The arithmetic step by step, with a worked example on the synthetic demo lease, is on how to calculate a CPI rent escalation. For future periods the calculator projects the index forward at the assumed annual change you enter; replace it with published values as they are released.

Caps and collars: a cap limits how far a single adjustment can rise; a collar sets the floor. A 0% collar prevents rent decreases in years when an index falls — not hypothetical: the French ILC was down 0.45% year-on-year and the ICC down 2.89% at Q1 2026 (per INSEE). Tower leases have their own escalation patterns — fixed percentage, CPI-linked and hybrid — and the cell tower lease escalation guide explains those clauses and their common disputes.

Download the schedule as an Excel workbook

The rent escalation schedule workbook carries the same arithmetic as this calculator with live formulas: a fixed-percentage sheet (compounding or simple, cap and collar per adjustment), a CPI-plus-margin sheet (base index, first review index, margin added to the percentage change or multiplied onto the indexed rent, projected reviews you overwrite with published values) and a compound-versus-simple sheet that shows the two readings side by side over a term. Inputs sit at the top of each sheet in blue cells; nothing else needs editing. Free, no email required.

Download the workbook (.xlsx)

Where to find official index values

US CPI-U — Bureau of Labor Statistics: bls.gov (July 2026: 333.918, 1982-84=100, NSA)
UK CPI & RPI — Office for National Statistics: ons.gov.uk (July 2026: CPI 142.9, 2015=100 · RPI 419.1, Jan 1987=100)
DE VPI — Destatis: destatis.de (July 2026: 125.6, 2020=100)
FR ILAT · ILC · ICC · IRL — INSEE: insee.fr (Q1 2026: ILAT 137.42 · ILC 135.26 · ICC 2084 · IRL Q2 2026: 148.37)

Reference values above as published at the stated periods; verified 27 Aug 2026 against the official sources. Always confirm the current value and the exact series your lease names before invoicing.

Frequently asked questions

How is index-linked rent escalation calculated?

Base rent × (current index ÷ base index), plus any fixed margin the lease adds — for example “CPI + 1.5%”. Caps and collars then limit each adjustment.

Which indices does this calculator support?

Fixed % escalation, plus index-linked presets for US CPI-U, UK CPI, UK RPI, German VPI and the French INSEE family (ILAT, ILC, ICC, IRL) — or any custom index values.

Where do I find official index values?

bls.gov (US CPI-U), ons.gov.uk (UK CPI/RPI), destatis.de (DE VPI), insee.fr (French indices). Links above.

Can a rent escalation be negative?

Yes, without a collar: the French ILC and ICC both fell year-on-year to Q1 2026. Many leases add a 0% collar to prevent decreases.

Can I download the schedule as an Excel file?

Two ways. "Copy for Excel" and "Download CSV" under the calculated schedule export the run you just made; the escalation schedule workbook is a standalone Excel file with live formulas for fixed-percent, CPI-plus-margin and compound-versus-simple cases.

How do I calculate a compound rent increase?

Apply each adjustment to the rent then in force, not to the initial rent: rent × (1 + rate) at every review, so each step builds on the last. Set the calculator to compounding, or follow the worked example on how to calculate a CPI rent escalation, which shows a 12-year schedule both ways.

Your leases already contain these clauses

MYX Analyzer's AI lease abstraction extracts the escalation type, index, margin and review dates from every lease, with a confidence level and the exact page reference for every field, then exports the schedule to Excel. See rent calculation, plans and credits, or drop one lease into the free demo.

Start free trial Contact sales

30-day free trial · Card required — first charge only when the trial ends · Cancel anytime