What is a commercial property lease expiry profile?
A commercial property lease expiry profile shows when the leases in a portfolio expire. It shows the rent, floor area or number of leases reaching expiry each year, making portfolio vulnerabilities easier to identify.
A simple lease expiry profile can be created in Excel. The tool itself is not the important part; accurate underlying data is. Lease dates, options, notice deadlines, rent amounts, floor areas and tenant status must be up to date.
Without this, you often get an attractive chart that reflects yesterday’s position. It looks organised until someone asks whether an option was exercised, a lease was extended verbally or a tenant’s floor area changed.
Why commercial property lease expiry profiles matter more now
In a market with higher capital costs, rising construction costs and more selective tenants, documenting rental income becomes more important. Statistics Norway reported CPI growth of 3.4 per cent from April 2025 to April 2026, and Prognosesenteret expects construction costs to continue rising towards 2027. This does not make every lease deadline dramatic. But it makes weak control of the lease portfolio more expensive.
A portfolio can look stable overall while much of its income is concentrated in a few leases with short remaining terms. This is where the expiry profile does its job.
It answers questions such as:
- How much rental income is at stake over the next 12, 24 and 36 months?
- Which buildings have the greatest renegotiation risk?
- Is risk spread across many small leases or concentrated among a few large tenants?
- Which deadlines need attention before summer, budgeting or refinancing?
- How resilient is the portfolio if one large tenant leaves?
This is not just a reporting question. It is a management question.
WALT: the figure that makes the expiry profile easier to read
WALT stands for Weighted Average Lease Term, often described as the weighted average remaining lease term. In simple terms, it shows how long the portfolio’s rental income is secured on average, weighted by rent.
A lease with high annual rent should carry more weight than a small storage-unit lease. WALT is therefore more useful than simply averaging the months remaining on each lease.
A simplified formula:
WALT = sum(annual rent × remaining lease term) / sum(annual rent)
Example:
Example data: three tenants with total annual rent of NOK 2,000,000.
| Tenant | Annual rent | Remaining lease term | Weighted contribution |
|---|---|---|---|
| A | NOK 1,000,000 | 5 years | 5 000 000 |
| B | NOK 500,000 | 2 years | 1 000 000 |
| C | NOK 500,000 | 1 year | 500 000 |
| Total | NOK 2,000,000 | — | 6 500 000 |
WALT is therefore 6,500,000 / 2,000,000 = 3.25 years.
This is a useful figure. But it is not the whole picture.
Always read the lease expiry profile and WALT together
WALT can provide a useful snapshot, but it can also hide risk. Two portfolios can have the same WALT and very different risk profiles.
Consider two property companies:
- Portfolio A has ten tenants of roughly equal size, with leases expiring evenly over five years.
- Portfolio B has one large tenant accounting for 45 per cent of rent whose lease expires next year, while the remaining expiries are much further away.
Both can have a WALT that looks acceptable. But Portfolio B has very different renegotiation risk. If the large tenant leaves, vacancy, cash flow, yield assessment and refinancing are affected far more than WALT alone reveals.
Use WALT as a key metric and the expiry profile as its explanation.
Five questions a good lease expiry profile should answer
1. Which leases expire in the next 12 months?
This is the most practical part. Do not start with an advanced report. Start with a list of leases that need action soon.
Include:
- the lease expiry date
- the notice deadline
- any option
- the responsible person
- annual rent
- floor area
- the status of discussions with the tenant
If this list does not exist, the portfolio relies too heavily on individuals. The answer is often “Ask Anne”. That works until Anne is on holiday, off sick or has changed jobs.
2. How much rental income falls into each expiry year?
The number of leases alone says little. Five small leases may matter less than one large lease.
Organise the expiry profile by rental income per year, not just the number of leases. You can then quickly see whether 2027 is an ordinary year or whether half the budget is suddenly up for renegotiation.
This is particularly important before board meetings, portfolio valuations and refinancing. It is better to present the risk yourself than have the bank discover it.
3. Which tenants would have the greatest impact if they left?
Not all expiries carry the same risk. A financially sound public-sector tenant in a specialised building is assessed differently from a cyclical business occupying flexible office space.
A practical expiry profile should therefore connect lease data with a simple risk assessment:
- tenant size
- payment history
- alternative uses for the space
- market rent versus contracted rent
- investment required for reletting
This need not be complicated. A simple low/medium/high assessment is often enough to set the right priorities.
4. Where are the options, special terms and verbal agreements?
The lease expiry date is only half the story. Options, extension rights, specific notice deadlines and agreed adjustments can change the picture considerably.
This is where many Excel setups become vulnerable. The date is in the spreadsheet, but the reasoning is in a key person’s head or a PDF nobody has opened for two years.
Good lease administration is therefore not just about storing documents. It is about making the important provisions manageable.
Lease expiry profiles are closely connected with topics such as commercial lease administration (/en/nytt-og-nyttig/kontraktsadministrasjon-naeringseiendom-frister), CPI rent indexation (/en/nytt-og-nyttig/kpi) and commercial property service charges (/en/nytt-og-nyttig/felleskostnader).
5. Which actions need to start now?
A lease expiry profile has value only if it leads to action.
For each lease, it should be clear:
- who is following up
- when discussions should start
- whether a market assessment is needed
- whether floor area, rent or terms need renegotiating
- whether there is a risk of vacancy
- which documents need updating
This is the difference between reporting and actual portfolio management. Reporting says “this lease expires in Q2”. Management says “we start discussions in September, have a named owner and know what we want to achieve”.
Common mistakes when creating lease expiry profiles in Excel
Excel often works well at first. Problems arise when the portfolio grows, more people use the same information and leases acquire more special terms.
The most common mistakes are:
- old lease dates remain after an extension
- options and notice deadlines are recorded as free text
- floor-area changes are updated in one place but not another
- the report shows the number of leases but not their rental value
- the lease document and key metrics are disconnected
- nobody owns data quality
The report may then look correct but be difficult to trust. Rather like a map with well-drawn roads but several missing bridges.
How to get started without making it too big
You do not need a six-month data-cleaning project to benefit from a lease expiry profile. Start with what gives you the most control quickly.
A useful first version can include:
- All active leases
- Expiry date and notice deadline
- Annual rent
- Floor area
- Tenant
- Option or special terms
- Internal owner
- Status: not started, discussions ongoing, extended, at risk
You can then add WALT, building-level data, segment, tenant type, market rent and risk assessments.
The aim is one source of truth. Not a perfect setup nobody has time to maintain.
In summary
A commercial property lease expiry profile shows when leases expire and how much rental income is at stake. WALT provides a useful metric for remaining lease terms, but should always be read alongside the underlying details: tenants, options, notice deadlines, floor areas and renegotiation status.
For small and medium-sized property companies, this is often the difference between identifying risk in time and being surprised when an important lease approaches expiry.
Estatelab helps property companies bring leases, deadlines, CPI indexation, service charges and portfolio information into one structured workflow.
Book a demo · 30 minutes · Free · No obligation · Meet people who understand property
Ready for more control?
Less Excel. More visibility.
Estatelab helps property companies and managers gain a better overview of leases, portfolios and financial processes.
