Lease renewal rate: preserve the expiration cohort

A renewed lease can disappear from an expiration export when its end date changes, making last month’s rate depend on when you rerun the report.

Kartik Deshpande··7 min read

A late renewal reaches the register, and rerunning last month’s lease renewal rate changes both the numerator and the expiration count. The lease’s new end date has moved it out of the original export. Preserve the expiring term and link the renewal to it so a completed renewal changes its outcome without removing the opportunity from the denominator.

For an expiration-based measure, calculate confirmed renewals from an eligible expiration cohort divided by all eligible expirations in that cohort, multiplied by 100. State the qualifying renewal status and outcome cutoff beside the percentage. Pending cases remain visible in the denominator under the proposed method below; this is a reporting design to approve for your operation, not a universal tenant-retention standard.

Define the renewal event and counting unit

Re-Leased’s property management KPI definitions express retention as renewals divided by leases expiring. That formula still needs a counting rule: use the expiring lease term as the opportunity when reporting lease renewal, then attach its qualifying successor. Counting every named resident on one agreement would give that lease several votes.

A tenant retention rate can use a broader relationship, such as households remaining at a property or within a portfolio. State that scope separately when it includes transfers that a same-premises renewal measure excludes. Preserve household and tenant identifiers where available, but do not substitute a resident count for a lease-term denominator partway through the calculation.

Published labels need inspection before benchmarking. Equity Residential’s second-quarter 2026 results define Percentage of Residents Renewing against renewal offers extended during the reporting period. The same release uses Renewal Rate Achieved for the change in rent on renewed leases. Neither label alone establishes the expiration-based conversion measure used here.

Preserve the eligible expiration cohort before outcomes change

Choose the expiration period and property population, then preserve the original term’s expiration date with its lease and property identifiers. MRI’s expiring lease report documentation describes selecting leases by expiration date range. For a historical conversion report, retain that selected population after renewals update the current lease record.

Use a term identifier or a preserved term version when the source reuses one lease ID across renewals. Link the expiring term to the successor term, including the evidence and confirmation date. Reconcile those relationships against the rent roll, where today’s active lease and a future renewal can appear without explaining which earlier opportunity they resolve.

Declare eligibility before reviewing results. If your approved report excludes particular expired terms, record the reason and retain the full expiration count alongside the eligible count. Do not drop a case because no offer was sent or the outcome was unfavorable unless that exclusion belongs to the stated measurement policy. An offer-acceptance report can answer a separate question with its own denominator.

Preserving the cohort does not mean preserving a known error. If a verified amendment corrects the original expiration or a duplicate term entered the population, publish a labeled cohort correction with the changed rows and approval. Keep that denominator correction separate from the routine arrival of outcomes for terms already in the cohort.

Classify outcomes without treating presence as a signed renewal

Choose the evidence required for confirmed renewal and apply it across properties. Under the proposed same-premises measure, a reviewed executed renewal linked to the original term qualifies. An offer, verbal acceptance, or draft remains a pipeline event. Keep the executed date, future start date, and current occupancy status separate so a confirmed future term need not be described as already active.

Use distinct outcomes for confirmed renewal, moved out, transfer, continued occupancy without confirmed renewal, and pending. These are reporting categories, not findings about legal tenancy status. A system label such as holdover or month-to-month needs an approved classification; continued possession alone does not satisfy this report’s requirement for a confirmed renewal.

Treat transfers as linked events across the old and new premises. A household retained elsewhere in the portfolio may qualify for a separately defined retention measure while remaining outside the same-premises renewal numerator. Keep its original expiration row so that the transfer cannot appear as both a renewal and an unrelated new household in the same report.

Keep the opportunity stable as its outcome changes
Preserved identityDated evidence
Expiring lease termOriginal expiration
Linked outcomeStatus and cutoff
A new term or late decision attaches to the preserved expiring term. Updating the current lease must not erase that earlier opportunity.

Calculate the rate and show unresolved opportunities

Assume a hypothetical apartment cohort has 20 eligible lease terms expiring during October 2026. There are no exclusions or duplicate terms. At the November 5 outcome cutoff, assume 12 confirmed same-premises renewals, four move-outs, one transfer, one case of continued occupancy without confirmed renewal, and two pending decisions. These are invented reporting assumptions, not observed property results.

The proposed lease renewal rate is 12 / 20 × 100 = 60%, with two pending cases still included in the denominator. Show the outcome counts with the rate so the reader can distinguish resolved departures from incomplete decisions. Removing the pending cases would change the denominator and answer a different question about the cases resolved by the cutoff.

Count the transfer separately even if the household stays in the portfolio. Do not count the continued-occupancy case as a confirmed renewal without the required evidence. Those choices keep the worked example consistent with its same-premises, confirmed-term definition; another approved retention policy needs its own label and calculation.

Where Permute links expiring terms to renewal evidence

Permute sells connected business data and custom applications. We can combine supplied expiration registers, Excel leasing records, and permitted renewal documents using agreed property, lease-term, and household identifiers. Linking the original term to its outcome preserves the opportunity when the source’s current expiration date changes.

We apply your declared eligibility, qualifying outcome, and reporting-cutoff rules across the connected records. A recurring report can keep same-premises renewals, transfers, and unresolved outcomes distinct. Confirm whether source history, signature evidence, and stable identifiers are available before depending on a historical cohort calculation.

A leasing lead could ask which expired terms remain unlinked to a confirmed renewal or departure, then inspect the source records and missing evidence. We sit underneath Claude, ChatGPT, and Copilot, supplying governed business data to the AI tools you use. The permitted report and underlying documents must remain scoped to the people responsible for the properties in question.

Connect an expiration cohort to its outcomes

Start with a permitted lease register and renewal records to explore a report that preserves the original opportunities.

Distinguish later outcomes from corrections to earlier reports

Continue the hypothetical example and assume both pending terms have qualifying renewals signed on November 10. At a November 12 outcome cutoff, the same October cohort has 14 confirmed renewals out of 20, or 70%. Preserve the November 5 view at 60% and label the later view with its new cutoff. The denominator stays fixed because the new evidence resolves existing opportunities.

If instead the documents were signed before the original cutoff but reached the register afterward, record when the event occurred and when the evidence became available. A corrected report should identify the late-recorded evidence and retain the earlier version. A later outcome and an earlier event discovered late should not be presented as the same change in leasing performance.

Choose a reporting lag (the time allowed after the expiration period) and a policy for subsequent revisions. Compare cohorts at equivalent outcome horizons, or disclose that one has had more time to resolve. The leasing owner decides when unresolved cases require follow-up; the reporting process should retain their status even after a dashboard period is closed.

Compare matching cohorts and assign evidence-based follow-up

Aggregate confirmed qualifying renewals and eligible expirations across properties, then divide the totals. Keep property membership, counting units, and outcome horizons consistent when comparing periods. An unweighted average of property rates gives different influence to small and large expiration cohorts, so label that calculation if the management question calls for it.

Use the property management KPI scorecard to place the renewal measure beside other operating evidence. A low rate does not establish why residents left or whether a price change caused the result. Inspect recorded departure reasons, offer history, concessions, and unresolved service issues before assigning a cause, keeping missing reasons visible.

Keep renewal cohorts separate from the lead-to-lease conversion process. Prospect conversion begins with a new inquiry or another declared entry event, while renewal conversion begins with an existing term’s expiration opportunity. Combining their counts obscures whether follow-up belongs with prospect leasing, renewal administration, or source-data review.

Keep lease decisions and legal classifications with their owners

We do not determine tenancy rights, interpret holdover provisions, or decide whether a disputed agreement is enforceable. This workflow reads supplied records and applies approved reporting definitions; we do not send renewal offers, execute agreements, or update your lease administration system through the analytical view described here. Property and legal owners approve lease decisions and resolve cases whose meaning is uncertain.

Calculate lease renewal rate from a preserved expiration cohort and the qualifying outcomes linked to it. State the counting unit, eligibility policy, and outcome cutoff so pending decisions and transfers remain visible. In the opening rerun problem, update the outcome while retaining the original expiring term; correct the denominator only when its source evidence warrants a labeled revision. Compare equivalent reporting horizons and use the linked records to assign the next follow-up.

Review why a historical renewal rate keeps changing

Bring an expiration export and its renewal history to trace lost cohort rows, late outcomes, and unresolved identity links.

Questions about renewal cohorts and tenant retention

What should the rate show when no eligible leases expire?

Show the rate as not applicable with the zero eligible-expiration count. It is not evidence of complete retention or failed retention. Distinguish a verified empty cohort from missing expiration data.

Does a roommate change create another renewal opportunity?

Under the lease-term method, the opportunity remains the original expiring term. Record the resident changes and have the responsible owner confirm how the successor agreement links to that term. A separate household-retention measure may need another identity rule, which should be disclosed with its result.

Can commercial lease renewals be measured by square feet?

A separately defined area-based measure can compare qualifying renewed space with eligible expiring space. It needs rules for partial renewals, expansions, and contractions, so a lease-count percentage cannot be substituted for it. Keep the unit of measurement and the affected premises visible.