Free Excel templates

A free WAULT calculator in Excel, to expiry and to break

WAULT by rent and by area, to lease expiry and to the first tenant break, with vacant space at its ERV and the share of rent that can end within one to ten years: a rent roll of up to twenty leases, dates in, years out, no macros.

WAULT, the weighted average unexpired lease term, is each lease’s years to expiry weighted by its rent. Measured to the first tenant break instead, it says when the income can actually stop. On an illustrative six-lease office with 1,778,000 of rent, the file returns 6.39 years to expiry and 3.82 years to break: two break clauses take 40 per cent off the headline term. Weighted by area, the figures are 6.17 and 3.77; counting the vacant unit at its ERV and zero years, 5.89 and 3.53. And 90.6% of the rent can end within five years if the tenants break. You type dates; the file does the years.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.

WAULT_Calculator.xlsx (15 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this model

This file is one worked case from The Real Estate Asset Manager. The book explains every assumption, every sheet and the decision the numbers support, chapter by chapter.

Get the book on Amazon → Or the DRM-free PDF edition, $19.99

Also on Amazon UK · Amazon Germany · Amazon France · Amazon Canada.

Want every model at once?

The Financial Model Library: all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).

Get the Library, $79 →

This free file stays free. Secure checkout by Stripe.

Not on Amazon: 36 paperbacks by Julian R. Sterling on how to read the documents, printed on demand and shipped worldwide. Browse the bookshop →

The formulas

WAULT to expiry = Σ(rent × years to expiry) / Σ rent

WAULT to break = Σ(rent × years to first break, or to expiry if there is no break) / Σ rent

What is in the file

4 sheets. Blue type on a pale blue fill is an input; black type is a formula.

Read Me
What the file does, the worked case, how to enter your own rent roll, and its limits.
Rent Roll
The valuation date, then up to twenty leases: area, passing rent, expiry date and first break date in blue. Years to expiry and to break are formulas on a 30/360 basis; a lease without a break uses its expiry. Vacant space and its ERV go at the foot.
Results
WAULT to expiry and to break, rent-weighted, area-weighted and with the vacancy counted, the gap between expiry and break, and the share of rent that can end within 1, 2, 3, 5, 7 and 10 years on each basis.
Checks
Five identities that hold for any rent roll, from “no break later than its expiry” to “counting the vacancy shortens the WAULT”, then the worked case. The file ends ALL OK.

What the worked case returns

MeasureValue
WAULT to expiry, rent-weighted6.39 years
WAULT to break, rent-weighted3.82 years
WAULT to expiry, area-weighted6.17 years
WAULT to break, area-weighted3.77 years
With the vacant unit at ERV, to expiry / to break5.89 / 3.53 years
Rent ending within 3 years, at expiry16.5%
Rent ending within 5 years, at expiry / at break39.3% / 90.6%

The two averages are 2.56 years apart because the two leases with breaks carry half the rent: the professional services firm on unit 1 can leave after 3.5 years of an 8.5-year lease, the software company after 5 of 10. The average to expiry looks like a long-let building; the expiry profile at break says 90.6% of the income can stop within five years. Read both, and read the profile behind them, before putting a WAULT in a loan covenant or a sale brochure.

How to use it on your own figures

  1. On Rent Roll, type the valuation date, then each lease’s area, passing rent and expiry date over the blue cells. Add the first break date where there is one; leave it blank where there is none.
  2. Use contracted rent as passing rent. If a lease is in a rent-free period, decide whether you want the rent it pays or the rent it will pay, and use the same basis for every lease.
  3. Put vacant space at the foot with its ERV. It stays out of the standard WAULT and comes into the third measure at zero years.
  4. Read Results. For a lender, the break figure and the profile are the ones that matter; for a valuer, both.
  5. Keep the Checks sheet. It ends ALL OK on any rent roll except the worked-case rows, which stop matching once you enter your own leases.

Questions people ask about it

What is WAULT in real estate?

The weighted average unexpired lease term: the average number of years left on a building’s leases, weighted by the rent each lease pays. It tells a lender, valuer or buyer how long the contracted income lasts on average.

How do you calculate WAULT to break?

Use each lease’s years to its first tenant break, or to expiry where there is no break, and weight by rent. On the worked office it is 3.82 years against 6.39 to expiry. It is often written WAULB.

Should WAULT be weighted by rent or by area?

By rent, normally, because it measures how long the income lasts. Area weighting gives a different figure, 6.17 years here against 6.39, and is used for occupancy questions. Always state the basis.

Is this WAULT calculator really free?

Yes. It is a companion file to a book. You enter an email address, the download opens at once, and you can leave the reader list in one click. It has no macros and no circular reference.

Where do the figures come from?

From an illustrative rent roll in the book: a fictional multi-let office of 8,100 m² with six leases and one vacant unit. Nothing here is investment advice.

The rest of the files

This template sits alongside the companion files for The Real Estate Asset Manager: the workbooks behind every chapter, the worked cases and the checklists. Free, like this one.

Open the companion files →

Worked questions from the same book

Short articles that each answer one question with the arithmetic shown, on the same ground as this model.

Other free templates

This template comes from The Real Estate Asset Manager. The book is on Amazon.

If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The template stays free either way.