Rent review calculator with CPI, rent history and RTB deadlines
A rent review in a pressure zone has to follow a formula, a notice period and a deadline for telling the RTB. The workbook estimates the new rent the way the RTB calculator does, keeps the full rent history of each tenancy and warns before registrations and notices fall due.
- 20 properties and 40 tenancies
- CSO all-items CPI from January 2020
- Lower of CPI and 2% a year, pro rata
- 90-day notice and 7-day RTB copy

How the estimate is worked out
RENT CALCULATOR compares the CPI for the month before the new rent with the index when the rent was last set, and caps the increase at 2% a year pro rata. The CPI series is included up to September 2026 and can be extended month by month.
A look at the sheets




Rules and deadlines
- A rent review at most once every 12 months, with the 24-month rule where it applies
- Rent review notice served on the tenant no less than 90 days ahead
- RTB to receive a copy within 7 days
- RTB registration and annual renewal dates
- Termination notice periods for landlord and tenant, by how long the tenancy has lasted
History and ledger
RENT HISTORY keeps every rent set or reviewed with the previous rent and the change. RENT LEDGER records rent received for 12 months per tenancy and shows arrears, and NOTICES lists rent review, warning and termination notices with their dates.
What is in the file
- START
- SETTINGS
- PROPERTIES
- TENANCIES
- RENT HISTORY
- RENT CALCULATOR
- RENT LEDGER
- NOTICES
- CPI INDEX
- DASHBOARD
- File format
- .xlsx
- Tabs
- 10
- Capacity
- 20 properties · 40 tenancies · 150 rent changes
- Requires
- Excel 2016+ / Microsoft 365
- Macros
- None