How to Calculate Weighted Average Lease Term (WALT)
Weighted average lease term, usually abbreviated WALT, is one of the most practical concentration and rollover-risk indicators in commercial real estate. Asset managers, lenders, and investors use it to estimate how quickly lease income could reprice in changing market conditions. A short WALT can increase refinancing and vacancy risk; a long WALT can stabilize near-term cash flow but may cap upside when market rents are rising.
This walkthrough defines WALT rigorously, documents variables with units, and shows a reproducible process for building the metric from lease-level data. It also connects WALT interpretation to leverage and coverage analytics through the Commercial Loan DSCR calculator, valuation framing in the NOI to Cap Rate Value calculator, and related leverage checks using the Loan-to-Value Ratio calculator.
Definition and metric boundary
WALT is the area-weighted average of each tenant's remaining lease term. In plain terms, larger leases carry more influence than smaller ones. Because the metric depends on weighting choice, you must define the boundary in advance: use net rentable area, gross leasable area, or annual base rent, then keep that basis unchanged through time-series reporting.
For portfolio governance, it is common to report contractual WALT first, then scenario-adjusted WALT using renewal assumptions. Keep these two outputs separate so stakeholders can distinguish what is legally contracted today from what is expected under probabilistic assumptions.
Variables, symbols, and units
- Ti = remaining lease term for lease i, in years.
- Ai = leased area for lease i, in square feet.
- Sum(T × A) = aggregate weighted lease-year area, in lease-year·ft².
- Sum(A) = total leased area in the calculation boundary, in ft².
- WALT = weighted average lease term, reported in years.
ISO-consistent reporting requires one time unit and one area unit throughout. If lease terms include partial years, convert months to decimal years before aggregation.
Core formula and scenario extension
Contractual WALT = Sum(Ti × Ai) divided by Sum(Ai)
Renewal-adjusted WALT = Contractual WALT + (prenew × Yext)
Here, prenew is renewal probability as a decimal and Yext is expected extension years conditional on renewal. The adjusted expression is not a replacement for the contractual figure; it is a planning layer for stress tests and debt committees.
Step-by-step calculation workflow
Step 1: Freeze lease inventory and data cut-off
Export all active leases at a fixed date. Include committed move-ins only if your policy and investor reporting framework explicitly allow them.
Step 2: Normalize remaining terms
Convert each residual term to decimal years. Use consistent day-count conventions so multi-asset comparisons remain comparable.
Step 3: Apply area weights
Multiply each lease term by its area, producing lease-year·ft² values, then sum across the portfolio.
Step 4: Divide by total leased area
Compute contractual WALT and round consistently, usually to two decimals.
Step 5: Run optional renewal scenario
Apply renewal probability and expected extension years only in scenario analysis, then present both contractual and adjusted values side by side.
Validation checks and interpretation limits
Perform three checks before publication: first, verify that summed lease-level area equals the denominator used in the formula; second, confirm no expired or duplicated lease records are included; third, reconcile significant WALT shifts with known rollover events and leasing activity.
WALT captures timing risk, not full credit risk. Two portfolios with identical WALT can have very different covenant quality, tenant concentration, and mark-to-market exposure. Use WALT with rent concentration and debt coverage metrics to avoid overinterpreting one summary statistic.
Run the WALT calculator
Enter your aggregate weighted lease-year area and total leased area to compute contractual WALT. Add optional renewal assumptions to generate a scenario-adjusted view for portfolio risk discussions.