Lease Rollover

Lease rollover is the share of a property’s leases, measured by units, square feet or rent, that expire in a given period, and it shows when the property’s income is exposed to renewal, re-leasing and rent resets.

Formula

What is the lease rollover formula?

Rollover in a period = leases expiring in the period / total leased units, square feet or rent

  • Leases expiring in the period: leases whose term ends in the period, plus month-to-month leases (counted as expiring now) and, on commercial property, leases a tenant can end early, counted on the option date.
  • Total leased units, square feet or rent: the occupied base the share is measured against; rent is the measure closest to repayment.

Lenders build an expiration schedule from the rent roll, by month for apartments and by year for commercial properties, and look for clusters. Rollover is also tested against the loan's maturity, since a large expiration just before maturity can block a refinance.

What does rollover look like on the sample deal?

Illustrative figures. The 96-unit community refinanced with a $9.0 million loan has 91 occupied units on 12-month leases or month to month.

PeriodUnits expiringShare of 91 occupied
Month to month (now)44.4%
Months 1 to 32224.2%
Months 4 to 62426.4%
Months 7 to 92123.1%
Months 10 to 122022.0%
Total91100%

Every residential lease rolls within a year, which is normal for apartments. The schedule is even: the busiest month has 9 expirations (9.9 percent), and 50 units (54.9 percent) are month to month or expire within six months. Shares are rounded. For this property the questions are renewal pricing and turnover cost. The rooftop antenna lease ($14,400 a year) is the one longer lease and is confirmed separately.

How do lenders use lease rollover?

Rollover tells a lender when the in-place NOI is at risk of changing. On apartments the risk is spread across many small leases and shows up as vacancy and rent trends. On office, retail and industrial properties, one expiration can remove a large share of income and require tenant improvements and leasing commissions to replace it. Many lenders require a leasing reserve, or cash management that starts when a major tenant does not renew, where rollover is concentrated in the loan term.

Typical policy treatment (illustrative): on apartments the sample lender reviews the monthly expiration schedule without a limit. On commercial property it asks for a leasing reserve or a cash management trigger where expirations cluster inside the loan term.

What are common rollover errors?

  • Building the schedule from the rent roll summary instead of the lease dates, so holdovers and month-to-month tenants are missed.
  • Ignoring termination options and co-tenancy clauses that let a tenant leave before the stated expiration.
  • Underwriting renewals at the in-place rent when market rent is lower.
  • Testing rollover only in the first year instead of across the term and at maturity.

Where does rollover appear in the credit memo?

The rent roll section includes the expiration schedule, by period and by share of rent, with the largest expirations named. The risk section addresses clusters near maturity and the mitigants, such as reserves, cash management triggers or a lower loan amount.

Related terms

Weighted average lease term, tenant concentration, rent roll, estoppel certificate, cash management and lockbox.

Where LenderBox does this work

Through financial spreading, LenderBox reads the rent roll and leases with every figure cited to the document and page it came from, so the expiration schedule your underwriter reviews traces to the lease dates themselves.

See it worked on a deal you bring.

A 30-minute demo can run on documents you bring: LenderBox reads the file, shows the source page behind each figure, and checks the result against your credit policy.

See it on your deal
30 MINUTES. NO COMMITMENT. 90-DAY MONEY-BACK GUARANTEE.