The weighted average remaining lease term is each lease's remaining term weighted by its lease liability balance at the reporting date: multiply every lease's remaining term by its liability, add those products up, and divide by the total lease liability. ASC 842-20-50-4(g)(3) requires it, disclosed separately for operating and finance leases. It is not an average of lease counts, and it is not weighted by remaining payments, which is what the discount rate line next to it uses.
That last sentence is the whole reason this page exists. Two lines sit beside each other in every ASC 842 footnote, they look like a matched pair, and they are weighted by two different things. Preparers pick one weight and apply it to both, and the resulting numbers are close enough to plausible that nobody catches it until an auditor recalculates.
What ASC 842 actually asks for
The requirement is short. A lessee discloses the weighted-average remaining lease term and the weighted-average discount rate, each split between operating leases and finance leases, as part of the supplemental quantitative disclosures under ASC 842-20-50-4(g). Four numbers total, sitting in the other-information table alongside cash paid and noncash right-of-use asset additions.
The codification tells you what each one is built from. The remaining term calculation uses the remaining lease term and the lease liability balance for each lease as of the reporting date. The discount rate calculation uses the rate that was used to measure each lease liability and the remaining balance of the lease payments for each lease as of the reporting date. Liability balances drive one, undiscounted remaining payments drive the other.
Both are reporting-date measures. Nothing about the original lease term or the rate you used two years ago enters the calculation, which sounds obvious and is the second most common error after the weighting itself.
The formula
For a portfolio of leases at the reporting date, all within one lease type:
Weighted average remaining lease term = Σ (remaining term of each lease × lease liability balance of that lease) ÷ Σ (lease liability balances)
Weighted average discount rate = Σ (discount rate of each lease × remaining undiscounted payments of that lease) ÷ Σ (remaining undiscounted payments)
Run it once for your operating leases and once for your finance leases. Never blend the two, and never run it across the combined portfolio and then split the answer.
A worked example
Four operating leases at a December 31 year end. All payments are annual in arrears, which keeps the arithmetic legible; monthly payments change nothing about the method.
| Lease | Annual payment | Remaining term | Discount rate | Liability balance | Remaining payments |
|---|---|---|---|---|---|
| A, headquarters office | $420,000 | 9 years | 7.00% | $2,736,398 | $3,780,000 |
| B, warehouse | $96,000 | 2 years | 3.25% | $183,030 | $192,000 |
| C, regional office | $180,000 | 5 years | 5.50% | $768,651 | $900,000 |
| D, copier fleet | $36,000 | 1 year | 4.00% | $34,615 | $36,000 |
| Total | $3,722,694 | $4,908,000 |
The term products, remaining term multiplied by liability balance: lease A contributes 24,627,578, lease B 366,059, lease C 3,843,256 and lease D 34,615. Those sum to 28,871,509. Divide by the $3,722,694 total liability and the weighted average remaining lease term is 7.76 years, which you would disclose as 7.8 years.
The rate products, discount rate multiplied by remaining payments: 264,600 from lease A, 6,240 from B, 49,500 from C and 1,440 from D, summing to 321,780. Divide by the $4,908,000 of remaining payments and the weighted average discount rate is 6.56%.
Why the weighting choice changes the answer
Run the same portfolio three ways and the spread is not academic.
| Method | Remaining term | Discount rate |
|---|---|---|
| Correct under ASC 842 | 7.76 years (liability-weighted) | 6.56% (payment-weighted) |
| Weight swapped between the two lines | 7.93 years | 6.48% |
| Simple average across the four leases | 4.25 years | 4.94% |
Swapping the weights costs about two months of term and eight basis points of rate. Annoying, defensible-looking, wrong. The unweighted average is the one that should worry you: it reports 4.25 years against a real 7.76, because a $36,000 copier lease gets the same vote as a $2.7 million headquarters. A reader using that footnote to model your off-balance-sheet-era rent commitments would be off by nearly half.
The spread between the correct and swapped figures widens with the spread in your discount rates. A portfolio that adopted ASC 842 at a 3 percent incremental borrowing rate and has signed leases since at 7 percent has exactly the rate dispersion that makes this visible.
Which leases belong in the calculation
Scope errors move the answer more than method errors do. Four rules cover most of it.
- Only leases with a recognized liability. The weight is the liability balance, so a lease with no liability contributes nothing. Short-term leases you elected to keep off the balance sheet are out entirely.
- Remaining term, not original term. A ten year lease seven years in contributes three years, not ten.
- The term is the accounting term, including options reasonably certain to be exercised. If a five year lease has a five year renewal you concluded was reasonably certain at commencement, its remaining term runs to the end of the option period, because that is the term the liability was measured over.
- Leases signed but not yet commenced are excluded. Nothing has been recognized, so there is no liability to weight. They get disclosed narratively under ASC 842-20-50-3(b) instead.
The third rule is where abstraction quality shows up in a disclosure. Whether an option is reflected in the term is a judgment made once, at commencement, and it has to be documented well enough that the number can be reproduced years later. If your register stores renewal options as a yes or no flag rather than a window, a rent basis and a conclusion, the weighted average term is not reproducible and the reconciliation to the maturity analysis will not tie either. Our lease commencement date guide covers the related dating judgment that sets the clock in the first place.
How to calculate weighted average remaining lease term in Excel
One formula each, given a table with remaining term in column C, liability balance in column D, discount rate in column E and remaining payments in column F:
- Remaining term:
=SUMPRODUCT(C2:C50,D2:D50)/SUM(D2:D50) - Discount rate:
=SUMPRODUCT(E2:E50,F2:F50)/SUM(F2:F50)
Express the remaining term in years to two decimals rather than in months. If your leases end mid-year, use the exact fraction, so a lease with 41 months left enters as 3.42 rather than 3. Filter to one lease type before running either formula, and reconcile the denominators: the sum of liability balances must agree to the operating lease liability on the balance sheet, and the sum of remaining payments must agree to the total undiscounted column of your maturity analysis. When both denominators tie, the weighted averages are almost always right. When one does not, you have found a data problem that would have shown up in the maturity reconciliation anyway.
Most controllers run this in a spreadsheet even when a lease accounting platform generates the footnote, purely as a check. If the lease register already lives in a database rather than a workbook, it is quicker to ask the register in plain English than to write the SUMPRODUCT against an export that may already be a week stale.
Frequently asked questions
What is the weighted average remaining lease term?
It is the average remaining term of a company's leases, weighted by the lease liability balance of each lease at the reporting date, disclosed separately for operating and finance leases under ASC 842. Weighting by liability means large leases influence the average in proportion to their size, so the figure describes the term over which most of the recognized obligation actually runs.
How do you calculate weighted average remaining lease term?
Multiply each lease's remaining term by its lease liability balance, sum those products across the portfolio, and divide by the total lease liability balance. In the example above, term products of 28,871,509 divided by a total liability of $3,722,694 gives 7.76 years. Do it once for operating leases and once for finance leases.
Is the weighted average remaining lease term weighted by lease liability or by payments?
By lease liability balance. The neighboring disclosure, the weighted average discount rate, is the one weighted by remaining undiscounted lease payments. Using the same weight for both is the most common technical error in this part of an ASC 842 footnote, and it typically shifts the term by a couple of months and the rate by several basis points.
What is the difference between weighted average lease term and WALT or WALE?
WALT and WALE are landlord metrics, the weighted average lease term or lease expiry across a property or portfolio, usually weighted by contracted rent or by leased area, and used to describe income durability to investors. The ASC 842 weighted average remaining lease term is a tenant-side accounting disclosure weighted by lease liability. Same words, different weight, different audience, and they will not agree.
Do short-term leases count toward the weighted average remaining lease term?
Not if you elected the short-term lease exemption for that class of underlying asset, because no liability was recognized and the weight would be zero. Their cost appears on the separate short-term lease cost line instead. Short-term leases you did not elect to exempt are recognized like any other lease and do belong in the calculation.
Does the weighted average remaining lease term include renewal options?
It includes renewal periods that were judged reasonably certain of exercise, because those periods are part of the lease term the liability was measured over. Options you concluded were not reasonably certain are excluded from both the measurement and the term. If a reassessment later brings an option into the term, the remeasured liability and the longer term both flow into the next disclosure.
How often is the weighted average remaining lease term recalculated?
At every reporting date, using balances and remaining terms as of that date. It is not rolled forward by subtracting a year from last period's figure, because new leases, terminations, modifications and remeasurements all change the mix. Public companies recalculate it for interim reporting as well.
Where the number comes from
Both weighted averages are arithmetic over three fields per lease: remaining term, liability balance, and remaining payments. The liability balance and the payments come out of your subledger. The remaining term traces back to a commencement date and an option conclusion that somebody read out of a lease document and its amendments, and that is the field auditors actually test.
This is the pattern across the whole footnote. The calculations are easy and the evidence behind them is not, which is why disclosure testing usually turns into a document hunt. A source-linked abstract, where every extracted value carries the page and clause it came from, turns that hunt into a lookup. See the full ASC 842 disclosure requirements page for the complete footnote with a worked example, the lease liability calculation guide for the measurement that produces these balances, and the ASC 842 implementation guide if you are still building the population these numbers will be drawn from.
WALT vs WALB: the same idea outside lease accounting
WALT is the weighted average lease term and WALB is the weighted average lease break, and the difference is which date you count to. WALT measures to lease expiry. WALB measures to the earliest date a tenant could hand the space back under a break or termination right. Both are commercial real estate underwriting metrics rather than accounting disclosures, and they are usually weighted by rent or by area rather than by lease liability.
The gap between them is the point. A building with a WALT of 7.2 years and a WALB of 3.1 years is not a seven year income stream. It is a three year income stream with an option attached, and a buyer underwriting it on WALT alone is paying for cash flow the tenants can cancel. Investors quote both for exactly that reason, and lenders sizing a loan generally look at the shorter one.
| Metric | Counts to | Weighted by | Used by |
|---|---|---|---|
| WALT | Lease expiration | Rent or rentable area | Investors, brokers, lenders |
| WALB | Earliest break or termination date | Rent or rentable area | Lenders and buyers pricing downside |
| Weighted average remaining lease term | End of the ASC 842 lease term | Lease liability balance | Financial reporting and audit |
How to calculate WALT in real estate
Multiply each tenant's remaining term in years by its share of the total, then add the results. Weighting by rent is the more common convention because it reflects income at risk. Take three tenants: $600,000 of rent with 8 years left, $300,000 with 4 years, and $100,000 with 2 years, on $1,000,000 total. That is (0.6 x 8) + (0.3 x 4) + (0.1 x 2), which is 4.8 + 1.2 + 0.2, so a WALT of 6.2 years.
Run the same weights against each tenant's earliest break date and you get WALB. If the 8 year tenant holds a termination right at year 3, its contribution drops from 4.8 to 1.8 and the portfolio WALB falls to 3.2 years, roughly half the headline WALT. Nothing about the leases changed. Only the date being counted did, which is why the early termination clause is the field that moves this number most.
Weighting by area instead of rent answers a different question, closer to how much space rolls over and when, and it is the right weight for leasing and space planning rather than for income. State the weight whenever you quote the number. A WALT with no stated basis is not comparable to anyone else's.
Does WALT mean the same thing as weighted average remaining lease term?
No, though the phrases are used interchangeably in conversation. WALT is a property level income metric weighted by rent or area and measured to expiry. The weighted average remaining lease term in an ASC 842 footnote is an entity level accounting figure weighted by lease liability and measured to the end of the accounting lease term, which already includes renewals reasonably certain of exercise and excludes periods after a termination option reasonably certain to be exercised. The two will not agree on the same portfolio, and they are not supposed to.
If you need both, they come from the same underlying data: commencement and expiration dates, the rent schedule, and every option with its notice window. Abstract those once, properly, and the accounting figure and the underwriting figure both fall out of the same table instead of being rebuilt from PDFs twice.