Skip to content
All resources

Blog

WALE, NOI and cap rate: how APAC REIT and fund teams calculate them from the lease file

by Daniel Leong, GTMUpdated

How to calculate WALE (weighted average lease expiry), net operating income and cap rate from the lease file, with worked examples for S-REIT, A-REIT and J-REIT teams.

Guide cover reading “WALE, NOI, cap rate”: how APAC REIT and fund teams calculate them from the lease file

WALE, net operating income and cap rate are three of the property metrics S-REIT, A-REIT and J-REIT reports lean on most, and every one of them starts in the lease file. For fund and asset teams working across Singapore, Australia and Japan, the hard part is rarely the formula. It is pulling clean, current lease data from many markets into one place so the weighted average lease expiry, NOI and cap rate are right every quarter. This guide shows how each is calculated, with worked examples using demo numbers, and how AI can help with the data behind them.

This article is general information, not financial, accounting or legal advice.

Short answers

What is WALE?

WALE, or weighted average lease expiry, is the average time left on a property's or portfolio's leases, weighted by rent or by area. It shows how secure the income is.

What is net operating income (NOI)?

NOI is a property's income after operating costs, before debt and tax. In simple terms: rental income plus recoveries, less vacancy and operating expenses. Singapore and Hong Kong REITs report a similar measure called net property income (NPI), broadly gross revenue less property expenses such as property tax and property management fees.

What is a cap rate?

The cap rate is NOI divided by the property's value. It links income to value and is used to compare assets and markets.

Why does the lease file matter?

Each number depends on lease data: rents, expiries, options, incentives and recoveries. If the lease data is stale, the WALE, NOI and cap rate are too.

How to calculate WALE (weighted average lease expiry)

Formula: WALE = sum of (remaining lease term x weight) divided by total weight. The weight is usually passing gross rental income (WALE by income) or lettable area (WALE by area).

Worked example (demo numbers only). Three tenants, with total annual rent of 2,000,000 and a total area of 10,000 sqm:

  • Tenant A

    Annual rent
    1,000,000
    Area (sqm)
    4,000
    Years remaining
    5.0
  • Tenant B

    Annual rent
    600,000
    Area (sqm)
    3,000
    Years remaining
    2.0
  • Tenant C

    Annual rent
    400,000
    Area (sqm)
    3,000
    Years remaining
    8.0

WALE by income = (5.0 x 1,000,000 + 2.0 x 600,000 + 8.0 x 400,000) / 2,000,000 = 9,400,000 / 2,000,000 = 4.7 years.

WALE by area = (5.0 x 4,000 + 2.0 x 3,000 + 8.0 x 3,000) / 10,000 = 50,000 / 10,000 = 5.0 years.

Points to decide and write down:

  • Income or area basis, or both. Many REITs report one or both, and the basis varies, so always state which.
  • Which rent you weight by: passing (face) rent, or effective rent after incentives.
  • Whether to measure to expiry or to the first break or option date.
  • How to treat vacant space and signed but not yet started leases. Vacant space is usually left out of the area total; say so if you include it, as it lowers WALE by area. MAS's Code requires S-REITs to calculate WALE based on the date each lease commences. That sets when a lease's term starts; it does not by itself exclude leases that are signed but not yet started, so reporting bases differ. Some A-REITs include signed leases or heads of agreement, so check each REIT's footnote before you combine them.
  • The date you measure from (usually the reporting date). MAS guidance for S-REITs is that rent-free periods be included in the WALE calculation, so they count towards the lease term.

How to calculate net operating income

Formula: NOI = gross potential rent + recoveries + other income - vacancy allowance and credit loss - operating expenses.

This is the underwriting build-up. For reported NOI or NPI, start from actual gross revenue billed, including service charges or outgoings recoveries, less property expenses. Recoveries do not change NOI whether they are shown gross or net, but they do change NOI margins, so do not compare margins across REITs that present them differently.

Worked example (demo numbers only):

LineAmount
Gross potential rent2,000,000
Outgoings recoveries300,000
Other income (car park)50,000
Vacancy allowance and credit loss(100,000)
Operating expenses(550,000)
Net operating income1,700,000

Lease file items that change NOI: rent reviews coming due, rent-free periods from incentive deeds, which outgoings are recoverable, and leases about to expire. Statutory revenue straight-lines rent and amortises incentives. Some reported NOI and NPI figures include these adjustments and some exclude them, so state which you use.

How to calculate cap rate

Formula: cap rate = NOI / property value. Rearranged: value = NOI / cap rate.

Worked example (demo numbers only): using the NOI above of 1,700,000 and a value of 34,000,000, the yield on value is 1,700,000 / 34,000,000 = 5.0%. This back-solved figure is a check, not the valuer's cap rate.

If the market cap rate for similar assets were 5.5%, the implied value would be 1,700,000 / 0.055 = about 30.9 million. A higher cap rate means a lower value for the same NOI.

In practice, passing NOI divided by value is the passing (initial) yield. Valuers usually apply the cap rate to market or fully let net income and then adjust for reversion, incentives and capex, so take the cap rate from the valuation report rather than back-solving it.

Cap rates differ by market and sector, so compare like with like and state the NOI basis you used. In Japan, appraisal cap rates are usually applied to net cash flow (NCF, broadly NOI after capex), so check which income figure a cap rate is quoted on.

S-REIT, A-REIT and J-REIT reporting: what differs

S-REIT
Usually reports in SGD (some in USD) and commonly shows WALE and net property income. Appendix 6 of MAS's Code on Collective Investment Schemes requires annual reports to disclose WALE for the portfolio and for new leases entered into in the year, with the share of revenue from those leases, calculated based on the date the leases commence, plus a lease maturity profile by share of gross rental income for each of the next five years. MAS guidance in the same paragraph is that rent-free periods be included in the WALE calculation. NPI is market practice rather than a defined term. S-REITs also follow SGX listing rules.
A-REIT
Usually reports in AUD; many leases recover outgoings, so recoveries matter to NOI. WALE is commonly reported, but its basis is chosen by each REIT.
J-REIT
Reports in JPY, usually on six-month fiscal periods, and discloses occupancy and NOI yield. Many office leases in Japan are ordinary building leases, which carry statutory renewal protection and often let tenants leave on notice, so WALE to expiry says less there; look at the share of fixed-term leases. Logistics REITs, mostly on fixed-term leases, commonly report WALE. Japan's new lease accounting standard (ASBJ Statement No. 34) applies from fiscal years starting on or after 1 April 2027, with early application allowed for fiscal years beginning on or after 1 April 2025. It mainly changes lessee accounting, so for J-REITs it matters most where they lease land or buildings in, such as ground leases.

Sources: MAS Code on Collective Investment Schemes, Appendix 6, paragraph 11.1(c) (opens in a new tab), ASBJ Statement No. 34 (opens in a new tab) and, for its effective dates, Works Applications (opens in a new tab).

For pan-Asia funds, agree one reporting currency, one WALE basis and one NOI definition, and document the conversion rates and dates. WALE by income across currencies depends on the rate used: one consistent approach is closing rates for WALE weights and average rates for NOI.

Consolidating reports across Singapore, Australia and Japan

This method works with any tool, or none. Whatever you use for the extraction and change steps should show its sources and its review trail.

1. Write the metric policy
WALE basis, commenced leases only or signed leases too, break treatment, measurement date, and your ownership share for joint venture assets.
2. List the sources
Where documents already live: document stores, property manager reports, the rent roll system.
3. Agree one field set
Rent, area, expiry, options, incentives, recoveries and operating costs, defined once for the portfolio.
4. Extract with sources
Every figure keeps a link to the lease, deed or report page it came from.
5. Flag changes
Compare with last quarter and surface what moved or is missing.
6. Calculate
Calculate WALE and NOI from that one structure, not from re-keyed spreadsheets, and take cap rates from the valuation reports.
7. Reconcile and sign off
Reconcile the lease data to the property manager's rent roll and the general ledger, then people check flagged items and approve.

Where Fifth Dimension fits

Fifth Dimension is AI for commercial real estate, from underwriting to lease abstraction. For portfolio teams, it connects Yardi, Argus, operating partner reports and portfolio data rooms, and pulls reporting from connected sources so teams can review insights instead of reconciling spreadsheets. See Fifth Dimension for portfolio managers.

  • It connects Excel, SharePoint, Argus, Dealpath and more, bringing them into one intelligence layer across your stack.
  • It tracks what has changed across assets, tenants, markets and performance, then brings the exceptions that need attention to the surface.
  • Every answer is grounded in your own systems with every source cited, and Evidence & Controls keeps sources, assumptions, review steps and changes visible.
  • It turns analysis into the memos, reports, models and presentations your team already uses, with the working behind them intact.
  • Customer data stays within the region agreed for your deployment, and is never used to train the models that power Fifth Dimension. See Fifth Dimension security.

Together, we identify the manual processes that are slowing you down across the full lifecycle of how you invest in and manage your assets. Start with the people and work that matter most, then expand as Fifth Dimension connects more of your organisation. Fifth Dimension takes on the work between receiving information and making a decision, while keeping your team in control of the judgement that matters. Request a demo.

FREQUENTLY ASKED QUESTIONS.

How do I calculate WALE across a portfolio?
Multiply each lease's remaining term by its rent (or area), add the results across every property, and divide by total portfolio rent (or area). Use the same basis, measurement date and treatment of breaks and vacancies for every asset.
Should WALE be calculated by income or by area?
Either, or both, as long as you say which. WALE by income shows how secure the rent is; WALE by area shows how much space falls due. Many REITs report one or both, and the basis varies between them.
Is NPI the same as NOI?
Broadly, yes. Singapore and Hong Kong REITs report net property income (NPI): gross revenue less property expenses such as property tax and property management fees. Definitions vary between REITs, so check what each one includes before comparing.
How do asset managers consolidate reports from Singapore, Australia and Japan?
They write one metric policy, agree one set of fields and one reporting currency, map each market's leases and property reports to it, keep a link to each source, and calculate WALE and NOI from that single structure instead of re-keying into Excel, taking cap rates from the valuation reports.
What AI tools help with REIT reporting?
Look for tools that connect to where your documents already live, extract lease and report data with a source for every figure, flag changes since last quarter, and produce the reports and models your team already uses. Test any tool, including Fifth Dimension, against that list.

Tools & libraries.