Preparing a tenant concentration summary for a single-property loan
A tenant concentration summary helps a lender evaluate how dependent the property's cash flow is on a small number of tenants. This guide explains what to include, how to prepare the information, and how it affects the financing discussion.
A tenant concentration summary helps a lender evaluate how dependent the property's cash flow is on a small number of tenants. This guide explains what to include, how to prepare the information, and how it affects the financing discussion.
A tenant concentration summary is a document that lists each tenant in a commercial property, their leased square footage, base rent, and lease expiration date, and then shows what share of the total rentable area and total base rent each tenant represents. For a single-property loan, this summary helps a lender evaluate how dependent the property's cash flow is on a small number of tenants. If one tenant occupies a large share of the space or pays a large share of the rent, a vacancy or default by that tenant could significantly reduce the property's net operating income (NOI) and its ability to service the debt. Lenders often set internal thresholds for tenant concentration, and a sponsor who prepares this summary in advance can identify potential issues before the lender does. The following sections describe what to include, how to prepare the information, and how the summary fits into the broader financing discussion.
What a tenant concentration summary includes
A tenant concentration summary is a single-page workpaper that pulls key lease data into a clear format. For each tenant, record the following: - Tenant name and the suite or unit number. - Leased square footage (the rentable area the tenant occupies under its lease). - Annual base rent (the minimum rent the tenant pays, before any percentage rent, escalations, or expense reimbursements). - Lease expiration date (the date the lease term ends, not including renewal options). - Lease type (e.g., gross, modified gross, triple net, or absolute net). This affects how operating expenses are allocated between landlord and tenant.
After listing each tenant, calculate the total rentable square footage of the property and the total annual base rent from all tenants. Then compute each tenant's percentage of total square footage and percentage of total base rent. Sort the list from largest to smallest by one of those percentages. The summary should also note any vacancy: record the vacant square footage and indicate whether it is leasable space or common area.
A lender may also ask for a rent roll, which is a snapshot of current tenant information, and a trailing twelve months (T-12) of operating statements. The rent roll shows who is in the building today, while the T-12 shows twelve months of historical income and expenses. These two documents serve different purposes: the rent roll is a point-in-time view, and the T-12 is a historical record. When comparing totals from the two, be aware that the rent roll may reflect current leases, while the T-12 may include income from tenants who have since moved out or from periods of vacancy. Reconciling the two is a suggested way to prepare information, not a mandatory lender process.
Distinguishing gross rent, collected income, NOI, capex, debt service, and equity cash flow
A tenant concentration summary focuses on gross rent — the total base rent from all leases. But a lender evaluating a loan will look at several layers of cash flow: - Gross rent is the sum of all base rents before any deductions. - Collected income is the gross rent minus any vacancies, concessions, bad debt, or free rent periods. This is what the landlord actually receives. - Net operating income (NOI) is the collected income minus operating expenses (property taxes, insurance, utilities, repairs, management fees, and other costs). NOI does not include debt service or capital expenditures. - Capital expenditures (capex) are major improvements to the property, such as new roofing, HVAC systems, or parking lot resurfacing. These are not deducted in NOI but are a cash outflow that affects the sponsor's equity return. - Debt service is the sum of principal and interest payments on the loan. The lender will compare NOI to debt service to assess whether the property generates enough cash to cover the loan payments. - Equity cash flow is what remains after debt service and capex are subtracted from NOI. This is the sponsor's return on the invested equity.
How tenant concentration affects the financing discussion
If the tenant concentration summary shows a high concentration, the sponsor can take steps to address it before the lender raises the issue. Possible steps include: - Discussing the tenant's credit quality. A tenant with strong credit (e.g., a national credit tenant or a publicly traded company) may be viewed as lower risk than a small local business, even if the concentration is high. - Reviewing the lease term. A long remaining lease term (e.g., 10 years) reduces the near-term risk of vacancy. - Identifying lease protections. If the lease requires the tenant to continue paying rent even if it vacates (e.g., a lease with a guarantee or a security deposit), that may mitigate the lender's concern. - Asking the actual lender whether it has a tenant concentration policy and what the threshold is. This is a suggested way to prepare information, not a mandatory lender process.
Preparing a tenant concentration workpaper
To create a concrete document, prepare a single-page spreadsheet with the following columns: - Tenant name - Suite number - Leased square footage - Annual base rent - Lease expiration date - Lease type - Percentage of total rentable square footage - Percentage of total annual base rent
Below the tenant list, include a summary section showing: - Total rentable square footage of the property - Total annual base rent from all tenants - Vacant square footage and the percentage of total rentable area that is vacant - The three largest tenants by percentage of total base rent, along with their combined percentage
This workpaper is a practical organizing step. It is not a mandatory lender process, but it helps the sponsor present the information clearly and identify potential issues early. A lender may also ask for a rent roll and a T-12; those are separate documents that support the tenant concentration summary.
How the summary fits into the loan request
The tenant concentration summary is one part of the loan request package. The loan request typically includes the business plan for the property, a rent roll and trailing twelve months of operating statements for existing properties, a pro forma with the assumptions behind it, the sponsor's schedule of real estate owned, financial statements for the principals and guarantors, and organizational documents for the borrowing entity. The tenant concentration summary sits alongside the rent roll as a tool for the lender to evaluate cash flow stability.
When submitting the loan request, include the tenant concentration summary as a separate document or as a page within the rent roll. Label it clearly so the lender can find it. If the property has multiple buildings or phases, prepare a separate summary for each building or phase, and then a combined summary for the entire property. The lender will use the summary to assess the property's cash flow risk and to decide whether to require additional reserves or a lower loan amount.
Does the summary include month-to-month tenants or tenants on holdover?
Yes, include them in the tenant list. For month-to-month tenants or holdover tenants, note the lease type and indicate that the lease is month-to-month or in holdover. These tenants do not have a fixed expiration date, which adds uncertainty to the cash flow. The lender will consider that uncertainty when evaluating the property's income stability. The summary should flag these tenants so the lender can ask about them.
How do I treat tenants with multiple suites or buildings?
If a single entity occupies multiple suites or buildings under separate leases, treat each lease as a separate line item on the summary, but also note the entity's total exposure. For example, if Tenant A occupies Suite 100 under one lease and Suite 200 under another, list each lease separately, then add a note that Tenant A's combined share of total base rent is X%. This gives the lender a complete picture of the entity's overall concentration.
If you have a property, a business plan, and a capital need, send us the property, the business plan, and the amount and timing. We will tell you how we would approach it. Submission is a preliminary request, not an engagement or lender submission.
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).