How a tenant concentration schedule supports collateral review
A tenant concentration schedule helps lenders and sponsors understand the risk of relying on a single tenant or a small group of tenants for the property's income. This guide explains how to prepare one, what to include, and how it supports the financing discussion.
A tenant concentration schedule helps lenders and sponsors understand the risk of relying on a single tenant or a small group of tenants for the property's income. This guide explains how to prepare one, what to include, and how it supports the financing discussion.
When a sponsor asks a lender to underwrite a commercial property, the lender is evaluating the property's ability to produce income that will cover the debt. The tenant concentration schedule is a document that shows how much of that income comes from each tenant. It is a practical way to identify whether the property's revenue is vulnerable to the departure of one or two tenants.
This guide describes how to prepare a tenant concentration schedule, explains how the information affects the financing discussion, and distinguishes source facts from assumptions. The goal is to help the sponsor present the property's income risk clearly, so the lender can assess the collateral with fewer open questions.
What a tenant concentration schedule records
A tenant concentration schedule is a table or spreadsheet that lists every tenant in the property, the rent they pay, and the percentage of total gross rent that each tenant represents. It is not a rent roll, though a current rent roll is the starting point. The schedule adds the concentration analysis: for each tenant, calculate the tenant's annual base rent divided by the total annual base rent for the property. The result is the tenant's share of the property's income.
The schedule should also note: - Lease expiration dates - Whether the tenant is an anchor tenant - Any co-tenancy clauses that could reduce rent if an anchor leaves - Whether the lease is on a net basis or gross basis, as retail leases are commonly written on a net basis [1]
A suggested way to organize the schedule is to list tenants in descending order by rent contribution. This makes it easy to see whether any single tenant or a small group of tenants accounts for a large share of the income.
Why lenders ask about tenant concentration
Lenders are concerned about the stability and predictability of the property's income. If a single tenant represents a large share of the rent, the property's cash flow is more sensitive to that tenant's financial health or lease renewal. At the property level, the lender wants to see whether the income is spread across multiple tenants or concentrated in a few.
A tenant concentration schedule does not guarantee that a lender will approve a loan. It is a tool for the sponsor to present the property's income risk in a clear, organized way. The lender will use this information alongside other underwriting factors, such as the property's operating history, the sponsor's financial strength, and the loan-to-value ratio.
How to prepare the schedule from a rent roll and T-12
A current rent roll is a snapshot of the property's leases at one point in time. It shows the tenant names, unit sizes, lease start and end dates, and the current base rent. A trailing twelve-month (T-12) operating statement shows the actual income collected over the past twelve months, net of vacancies and concessions.
To prepare a tenant concentration schedule, start with the rent roll. For each tenant, record the annual base rent. Then calculate each tenant's percentage of the total. This gives a static view of the property's income concentration at the date of the rent roll.
The schedule should also distinguish gross rent from collected income. Gross rent is the total rent that tenants are obligated to pay under their leases. Collected income is what the landlord actually received. Net operating income (NOI) is collected income minus operating expenses. Capital expenditures (capex) are separate from operating expenses. Debt service is the loan payments. Equity cash flow is what remains after all expenses and debt service.
What to include for each tenant
For each tenant, the schedule should include: - Tenant name - Unit or suite number - Lease area in square feet - Annual base rent - Rent per square foot - Lease start and end dates - Renewal options, if any - Whether the lease is net or gross [1] - Any co-tenancy clauses that could reduce rent if another tenant leaves [1] - The tenant's percentage of total gross rent
If the property has anchor tenants, note that anchor tenants often sign longer leases, typically 20 to 25 years, and may pay a flat rate plus a percentage of sales [1]. The flat rate should be high enough to discourage the tenant from ceasing operations while maintaining possession [1].
How the schedule affects the financing discussion
The tenant concentration schedule helps the sponsor and lender identify whether the property's income is vulnerable to tenant turnover. If the schedule shows that one tenant accounts for a large share of the rent, the lender may ask for more information about that tenant's financial health, lease terms, and renewal history.
A suggested way to prepare for this discussion is to research each significant tenant's business, industry, and creditworthiness. If the tenant is a national retailer or a publicly traded company, the sponsor can find financial information in public filings. If the tenant is a small local business, the sponsor may need to rely on the tenant's payment history and the lease terms.
The schedule also helps the sponsor evaluate whether the property's income is diversified across multiple tenants, property types, or geographic areas. At the property level, diversification means having multiple tenants in different industries, so that a downturn in one industry does not wipe out the property's income.
Common points of confusion to avoid
A common mistake is to treat the rent roll and the T-12 as interchangeable. They are not. The rent roll is a snapshot of what tenants are supposed to pay. The T-12 is a historical record of what was actually collected. The difference between the two can reveal collection problems, concessions, or rent abatements.
Another common confusion is between cap rate and debt constant. The cap rate is a measure of the property's value relative to its NOI. The debt constant is a measure of the annual debt service relative to the loan amount. They are not the same, and one should not be used to estimate the other.
A third point of confusion is about legal costs. The schedule does not prescribe legal or tax conclusions. The sponsor should consult with legal and tax professionals for advice specific to the property and the transaction.
How often should I update the tenant concentration schedule?
Update the schedule whenever a lease is signed, expires, or is modified. If the property is being underwritten for a loan, provide the most current schedule at the time of the loan request. The lender will also ask for a current rent roll and a T-12, so the schedule should be consistent with those documents.
What if a tenant represents a very large share of the rent?
If a single tenant accounts for a large share of the rent, the lender will likely ask for more information about that tenant's financial health and lease terms. A suggested way to prepare is to research the tenant's creditworthiness and include that information in the loan request. The sponsor can also discuss whether the lease has protections, such as a security deposit or a personal guarantee.
Does a tenant concentration schedule replace a rent roll or T-12?
No. The schedule is an additional document that analyzes the concentration of income. The lender will still need a current rent roll and a trailing twelve-month operating statement. The schedule helps the sponsor and lender see the income risk that the rent roll and T-12 alone may not reveal.
Run the numbers on your deal
Try your own NOI, value and lender tests to see which one limits the loan: DSCR, LTV or debt yield.
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.
Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).