Home · Tools · WAULT calculator

WAULT Calculator

The weighted average unexpired lease term: how long a building’s rent is contracted for, weighted by what each tenant pays. Enter the rent roll or paste it from a spreadsheet, and see it to expiry and to break.

The rent roll

One row a lease: the tenant or unit, its let area, the annual rent, the expiry and any break. Leave the rent empty for a vacant unit.

Load an example
Examples with made-up numbers, not real buildings.
Every term is measured from this date.
1.00 years to expiry · 20.0% of the rent
2.00 years to expiry · 15.0% of the rent
5.00 years to expiry · 3.00 to break · 30.0% of the rent
3.00 years to expiry · 12.0% of the rent
4.00 years to expiry · 23.0% of the rent
Vacant: counts in occupancy, not in the WAULT.
6 of 50 rows
Copy the rows straight out of Excel or Google Sheets instead of typing them.

What the leases add up to

WAULT to expiry
3.28 years
weighted by rent, to each expiry
WAULT to break
2.68 years
to the first break or the expiry
WALE by area
3.46 years
weighted by let area, to expiry
A WAULT of 3.28 years to expiry is moderate: some of the income comes up for renewal within a few years. To break it is 2.68 years, because one tenant has a break and can leave earlier.
The income
Total annual rentAED 1,000,000
Leases counted5 let · 1 vacant
Largest tenant’s share (Suite 103, regional office)30.0%
Coming up
Rent expiring within 12 months20.0%
Rent expiring within 24 months35.0%
The space
Occupancy by area (8,500 sq ft let of 10,000 sq ft)85.0%
Expiry ladder
The share of the annual rent whose lease expires in each year from the valuation date.
Year 120.0%
Year 215.0%
Year 312.0%
Year 423.0%
Year 530.0%
Year 60.0%
Year 70.0%
Year 80.0%
Year 90.0%
Year 100.0%
Later0.0%
Years left = days from the valuation date to the expiry, or the first break, divided by 365.25. Vacant units count in occupancy, never in the income weighting. A lease past its expiry counts as 0 years. Year 1 of the ladder is the 12 months from the valuation date and also holds anything already expired. The examples use made-up numbers, not real buildings. General information, not valuation or investment advice.
Danny Anderson
Danny Anderson
Director · View profile →

Commercial income, read properly

Buying or holding a multi-let building? Talk to the desk about the leases, the breaks and the tenants behind the WAULT.
Usually replies within 5 minutes

How WAULT works

WAULT, the weighted average unexpired lease term, is the average time left on a building’s leases, weighted by the rent each one pays. A tenant paying twice the rent counts twice as much. It is measured in years from a valuation date, either to each lease’s expiry or to the first date a tenant can legally leave, and commercial property uses it to judge how secure the contracted rent is across a building or a portfolio.4

The formula

WAULT = the sum of (years left on each lease × its annual rent) ÷ the total annual rent

Years left are counted from the valuation date: the calculator takes the days to each date and divides by 365.25. A lease that has already expired counts as zero, and a vacant unit pays no rent, so it adds nothing to either side of the sum. For a longer read, Adventures in CRE has a glossary entry and an article on the weighted average lease term.12

A worked example

The calculator’s first example, a multi-let office floor with made-up numbers. Five suites are let on leases with 1 to 5 years left, one has a break, and one suite is empty.

LeaseRent (AED a year)Years leftRent × years
Suite 101, consultancy200,0001200,000
Suite 102, law firm150,0002300,000
Suite 103, regional office300,0005 (break at 3)1,500,000
Suite 104, clinic120,0003360,000
Suite 105, tech firm230,0004920,000
Suite 106, vacant0vacant0
Total1,000,0003,280,000

WAULT to expiry: 3,280,000 ÷ 1,000,000 = 3.28 years. Counted to break, Suite 103 runs 3 years instead of 5, so its line falls from 1,500,000 to 900,000 and the WAULT to break is 2,680,000 ÷ 1,000,000 = 2.68 years. The empty suite does not move either figure; it shows in occupancy instead, 8,500 of 10,000 sq ft let, or 85%. Load the example in the calculator above and it gives the same numbers.

To expiry or to break

A break option lets a tenant leave on a set date before the lease ends. WAULT to expiry runs every lease to its end date; WAULT to break runs it to the first break, or to the expiry where there is none, so it is the same or shorter. QuotedData’s glossary names both forms.5 INREV, the European association for investors in non-listed real estate, defines WAULT as the shorter of the first tenant break or the lease expiry, weighted by current headline rent per annum, in years.3 When a report quotes a single WAULT, check which one it is.

Weighted by income or by area (WALE)

The same average can be weighted by let area instead of rent, and it gives a different answer. In the example, Suite 103 is the largest suite and the longest lease but pays the least per square foot, so weighting by area lifts the figure to 3.46 years against 3.28 by rent. The calculator shows the area figure as WALE by area. PropertyMetrics sets out both weightings.6

The names change by market. WAULT is the term in the UK and Europe. Australia and New Zealand say WALE, weighted average lease expiry, and usually weight it by income too. In the US it is WALT, the weighted average lease term. Whatever the name, ask which weighting a figure uses before comparing two buildings.

What a short or long WAULT means

For value. Rent contracted for longer is more certain, so it can be priced with more confidence. A short WAULT means the price has to allow for re-letting: the months a unit may stand empty, the cost of finding the next tenant and the rent that tenant will agree to.

For a lender. A loan secured on a building is paid from its rent. The WAULT shows how long that rent is contracted for, and leases that end before the loan does are a risk the lender has to weigh.

For a buyer. Read the WAULT with the expiry ladder and the tenant list, never on its own. Five years spread across twenty tenants is a different thing from five years resting on one, and a large share of the rent ending in the same year is a risk the average hides. The calculator flags any tenant paying over 40% of the income for that reason.

In the UAE

Dubai commercial leases are commonly 1 to 3 years and registered in Ejari, so a building let only on leases like that has a WAULT of three years or less however full it is. Two of Dubai’s listed REITs have reported the figure. ENBD REIT, listed on Nasdaq Dubai, reported a portfolio WAULT of 3.56 years at 30 June 20197 and 3.37 years at 31 December 2019, when its occupancy was 81%.8 Emirates REIT reported a weighted average lease expiry of 8.5 years at 30 September 2016, much of it schools on long leases.9 The tenants make the difference: long leases, such as those to schools, lift a portfolio’s figure, and a roll of one to three year leases holds it down.

Buying or holding a commercial building in Dubai or Abu Dhabi? See the commercial property we have on the market, or read Dubai commercial real estate: a four-part investor framework.

Common questions

What does WAULT stand for?

Weighted average unexpired lease term. It is the average time left on the leases of a building or a portfolio, in years, with each lease weighted by its annual rent, so the bigger rents count for more. Commercial property uses it to judge how secure the contracted rent is.

How do you calculate WAULT?

Multiply the years left on each lease by its annual rent, add the results together and divide by the total annual rent. A building with one lease of 4 years at AED 600,000 and one of 1 year at AED 400,000 has a WAULT of (4 × 600,000 + 1 × 400,000) ÷ 1,000,000 = 2.8 years.

What is the difference between WAULT to expiry and WAULT to break?

WAULT to expiry runs each lease to its end date. WAULT to break runs it to the first date the tenant can legally leave, where the lease has a break option, so it is the same or shorter. INREV, the European association for investors in non-listed real estate, defines WAULT on the shorter of the first break and the expiry.

Is WALE the same as WAULT?

Nearly. WALE, weighted average lease expiry, is the name used in Australia and New Zealand, where it is usually weighted by income as WAULT is; WALT is the American name. Some reports weight by let area instead of rent, which gives a different answer, so check the weighting before comparing two buildings.

Do vacant units count in the WAULT?

Not in the income weighting. A vacant unit pays no rent, so it adds nothing to either side of the sum. It shows up in occupancy instead, which is why a WAULT should be read next to the occupancy figure: a long WAULT on a building with a third of its space empty is weaker than the number alone suggests.

What is a good WAULT?

There is no single good number: it depends on the building, the tenants and what the owner wants from it. As a plain reading, this calculator calls under 2 years short, 2 to 5 years moderate and over 5 years long. For a listed example, ENBD REIT on Nasdaq Dubai reported a portfolio WAULT of 3.37 years at 31 December 2019.

Sources