Can I Afford This Property?Commercial real estate financing, worked out

Documenting commercial lease expiration concentrations before a refinance

A practical guide to preparing a lease expiration concentration schedule, understanding how it affects lender underwriting, and distinguishing between lease data, rent roll snapshots, and trailing operating history.

Source: CodexTopic: Commercial lease analysis1133 wordsUpdated 2026-11-19

A practical guide to preparing a lease expiration concentration schedule, understanding how it affects lender underwriting, and distinguishing between lease data, rent roll snapshots, and trailing operating history.

Why lease expiration concentration matters to a refinance

When you refinance a commercial property, the lender is underwriting the income stream that will repay the loan. Lease expirations that cluster in a narrow window create a refinance risk: if several tenants leave or renegotiate at once, net operating income could drop before the loan is repaid. Bank supervisory guidance notes that concentrations should be reported when they pose challenges to management or present unusual or significant risk [1]. Lease rollover risk may be considered a concentration factor. This guide helps you document that risk in your loan request so the lender can evaluate it alongside the property's strengths.

What to prepare: a lease expiration concentration schedule

Create a one-page workpaper that lists every lease, its expiration date, the annual base rent, and the percentage of gross rent that lease represents. Then group leases by the year they expire. A suggested format:

  • Tenant name (or unit number if confidential)
  • Unit / suite
  • Lease expiration date (month and year)
  • Annual base rent (not including percentage rent or pass-throughs)
  • Percentage of total gross rent (calculated from the current rent roll)
  • Renewal options (number and term, if any)
  • Co-tenancy or anchor clauses that could trigger rent reductions or termination [1]

Below the list, add a summary table:

This schedule is a suggested way to prepare information, not a mandatory lender form. It helps you and the lender see whether a significant portion of income expires in any single year and whether anchor tenants are part of that concentration.

Distinguishing the rent roll snapshot from the trailing operating history

A current rent roll is a snapshot of today's leases: who is in place, their rent, and their expiration. A trailing twelve-month (T-12) operating statement is a historical document that lenders commonly request, as noted in [2]. The rent roll is a snapshot of current leases, while the T-12 shows historical income and expenses. Lenders may compare them to identify discrepancies.

When you compare the two, record the timing difference. The rent roll is as of the date you prepare it. The T-12 covers the prior twelve calendar months. If a lease started six months ago, the T-12 will show only six months of that tenant's rent, while the rent roll shows the full annualized amount. Identify that gap in your workpaper so the lender can reconcile the numbers.

How expiration concentration affects the underwriting conversation

Lenders evaluate whether the loan can be repaid from stabilized income. A concentration of expirations in one or two years raises the question: can the property maintain its net operating income (NOI) if those tenants leave or renegotiate at lower rents? The OCC handbook notes that co-tenancy clauses make anchor tenant success even more critical to property viability [1]. If your concentration includes an anchor with a co-tenancy clause, document that clause and the anchor's lease term.

You can address this in your business plan by:

  • Identifying which tenants are likely to renew (based on your conversations, their investment in the space, or market conditions)
  • Showing historical renewal rates for the property or comparable properties
  • Including a rent roll projection that assumes a vacancy factor during the rollover period
  • Explaining any rent bumps or step-ups that mitigate the income drop

This is not a guarantee of approval; it is information the lender will use to structure the loan—possibly with a reserve, a shorter initial term, or a pre-negotiated extension tied to lease-up milestones.

Separating gross rent, collected income, NOI, debt service, and equity cash flow

Your workpaper should clearly distinguish these five figures:

  • Gross rent: the total contractual rent from all leases, as shown on the rent roll
  • Collected income: what actually arrived in the bank account, net of vacancies, concessions, and bad debt (from the T-12)
  • NOI: collected income minus operating expenses (including property taxes, insurance, management, and maintenance—but not debt service)
  • Debt service: the annual principal and interest payment on the proposed loan
  • Equity cash flow: NOI minus debt service

A lender typically underwrites to a debt-service coverage ratio (NOI divided by debt service). If your concentration schedule shows a large expiration cluster, you can model what NOI would look like if those leases roll at a lower rent or after a vacancy period. Record that scenario in your workpaper as a sensitivity analysis.

How to reconcile the T-12 with the rent roll for the lender

Lenders see many requests where the T-12 and the rent roll do not match. Rather than ignoring the gap, explain it. Common reconciling items:

  • A lease that started mid-year (the T-12 shows partial rent; the rent roll shows full annual rent)
  • A vacancy period during the T-12 that has since been leased (the T-12 shows lost income; the rent roll shows current occupancy)
  • Rent concessions or free rent that reduced collected income (the T-12 shows the concession; the rent roll shows the contractual rent)
  • Tenant improvements or abatements that were paid from operating cash flow

Create a simple reconciliation table:

This shows the lender you understand the timing difference and are not hiding a vacancy problem.

What to ask the actual lender about concentration risk

Every lender has its own policy on lease expiration concentration. Ask:

  • Does your underwriting assume a vacancy factor during the rollover period?
  • Do you require a reserve or holdback if more than X% of income expires in any year?
  • Will you consider a shorter loan term or a balloon with an extension option tied to re-leasing?
  • Do you treat renewal options as reducing concentration risk, or do you underwrite to the stated expiration?

Record the answers in your workpaper and adjust your loan request accordingly.

Frequently asked questions

How far out should I document lease expirations?

Most lenders want to see at least the next three to five years of expirations, and all anchor tenant expirations regardless of term. If your property has long-term anchors with 20-year leases, note those separately, as they may provide income stability [1].

Do renewal options reduce concentration risk?

Renewal options are a positive factor, but they are not guaranteed. The lender may discount them unless the tenant has a strong credit history and the rent is at or below market. Record the option terms in your schedule and note whether the tenant has historically renewed.

What if I cannot get a T-12 because I just bought the property?

Provide the rent roll and any operating statements you have from the prior owner or from your short ownership period. Explain the gap in your cover letter. The lender may ask for a year of operating history before closing or may underwrite with a higher vacancy factor.

Run the numbers on your deal

Estimate what a new loan could size to against your current balance and whether there is a gap to fill at maturity.

Open the maturity gap calculator

Talk through your financing

Working on a real property? Send us the deal and a financing advisor will review it and get back to you. It costs nothing to ask and does not commit you to anything.

Contact us

Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).

Sources

  1. OCC Commercial Real Estate Lending handbook
  2. Wraith commercial real estate debt