Calculate WALT
Use the same units for all tenants. To weight by area, enter square footage in the rent fields and read only the WALT result.
The formula
WALT = sum of (each tenant's rent × years remaining) ÷ total rent.
| Tenant | Annual rent | Years left | Rent × years |
|---|---|---|---|
| Tenant 1 | $600,000 | 8.0 | $4,800,000 |
| Tenant 2 | $300,000 | 3.0 | $900,000 |
| Tenant 3 | $200,000 | 1.5 | $300,000 |
| Tenant 4 | $100,000 | 0.5 | $50,000 |
| Total | $1,200,000 | 5.04 WALT | $6,050,000 |
By rent or by area?
Weighting by rent shows income at risk. Weighting by area shows how much space could come back. They can differ widely when one tenant pays far more per foot. Investors often look at rent, while leasing teams may care about space. Whichever you use, state it, and use it everywhere.
WALT to expiry vs WALT to first break
A lease with five years left and a termination right in year two isn't really a five-year lease. Calculate WALT to expiry and WALT to the earliest termination date. That gap shows how much certainty is actually contractual. Don't assume renewal options will be exercised, because they belong to the tenant.
What WALT hides
Look at the example again. WALT is 5.04 years, which sounds comfortable. But half the income comes from one tenant, and 25% of rent expires within 18 months. Average numbers conceal cliffs.
- Concentration: one long lease can mask many short ones.
- Timing: always look at the expiration schedule too.
- Credit: a long lease is worth only as much as the tenant's ability to pay.
- Rent level: a long lease at above-market rent has its own risk when it ends.
Pair WALT with our rollover risk model and the concentration tests in our retail page.
Long or short: which is better?
| Longer WALT | Shorter WALT | |
|---|---|---|
| Income certainty | Higher | Lower |
| Financing | Often easier | Lenders may want more reserves or analysis |
| Inflation and market upside | Limited, unless leases have good escalations | More chance to reset rents |
| Leasing costs | Fewer in the near term | More TI and commissions soon |
Neither is automatically better. It should fit your business plan, your loan maturity and your exit timing. A value-add buyer may want short leases, and a lender on a refinance will prefer long ones. Check that important dates are captured in your lease abstracts, since that's where WALT calculations usually go wrong.