Building a unit-type rent summary without losing lease-level detail
A rent roll is a snapshot; a T-12 is twelve historical months. This guide explains the timing difference, shows how to prepare a unit-type rent summary that preserves lease-level detail, and provides an evidence checklist for the financing discussion.
A rent roll is a snapshot; a T-12 is twelve historical months. This guide explains the timing difference, shows how to prepare a unit-type rent summary that preserves lease-level detail, and provides an evidence checklist for the financing discussion.
Identify the timing difference between a rent roll and a T-12
A current rent roll is a snapshot of today's occupancy and rent obligations. A trailing twelve-month (T-12) operating statement shows actual collected income and expenses over the past twelve months. The two documents cover different periods and different concepts: the rent roll shows what tenants are supposed to pay, while The T-12 reports historical income and expenses on its stated accounting basis. When you compare totals, adjust for the timing difference. For multifamily properties, the OCC Commercial Real Estate Lending handbook notes that even though a review of the rent roll might indicate a high rate of occupancy, actual collections should be examined to determine the true economic occupancy and evaluate the competency of property management and the effectiveness of its collection efforts [1].
Distinguish gross rent, collected income, NOI, capex, debt service and equity cash flow
Gross rent is the total of all signed lease obligations. Collected income is what the landlord actually received after vacancies, concessions, and collection losses. Net operating income (NOI) is collected income minus operating expenses. Capital expenditures (capex) are major improvements that are not operating expenses. Debt service is the scheduled loan payments. Equity cash flow is NOI minus debt service and capex. These are distinct measures; do not equate a cap rate with a debt constant. For multifamily properties, the OCC handbook lists property-specific considerations that include occupancy history, collection losses, rents as compared with competitive properties, and management quality [1].
Prepare a unit-type rent summary with lease-level detail
Create a workpaper that lists each unit by type (e.g., one-bedroom, two-bedroom) and, for each unit, the following fields: - Unit number - Lease start and end date - Monthly base rent - Any concessions (free rent, reduced rent periods) - Any percentage rent or other variable components - Security deposit held - Move-in and move-out dates if available
Then aggregate by unit type to show: - Number of units occupied - Average base rent per unit type - Total monthly base rent for each type - Total concessions per type - Percentage of units with concessions
This workpaper preserves lease-level detail while giving the lender a clear view of the rent structure. The OCC handbook notes that for retail properties, lease terms typically range from five to 10 years with anchor tenants often signing leases of 20 to 25 years with options to renew, and that leases are commonly written on a net basis with tenants reimbursing the landlord for common area maintenance [1]. For multifamily, the handbook lists demographics, economic factors, location factors, and local and state laws as important considerations [1].
Compare the rent roll to the T-12 to identify collection losses
Take the rent roll snapshot and calculate the expected monthly rent for the trailing twelve months. Then compare that expected amount to the actual rent collected shown in the T-12. The difference is collection losses. Record the dollar amount and the percentage of gross rent. For multifamily properties, the OCC handbook states that even though a review of the rent roll might indicate a high rate of occupancy, actual collections should be examined to determine the true economic occupancy [1].
Evidence checklist for the financing discussion
Prepare the following documents in a single package: - Current rent roll (snapshot date) - Trailing twelve-month operating statement (T-12) - Unit-type rent summary workpaper (as described above) - Reconciliation of rent roll to T-12 showing collection losses - Schedule of any concessions and their expiration dates - For each concession, note whether it is a free rent period, reduced rent, or other - Any lease clauses that could affect income, such as co-tenancy clauses or termination rights
For retail properties, the OCC handbook notes that some lease clauses may call for a decrease in rents or permit termination if an anchor tenant ceases operations (co-tenancy clauses), and that these clauses make the success of anchor tenants even more critical to the viability of the property [1].
Ask the actual lender about their preferred format
Lenders differ on how they want rent information presented. Some want a rent roll in a specific spreadsheet format; others want a PDF of the current rent roll plus a T-12. Ask the actual lender what format they prefer before you prepare the documents. The OCC handbook is bank supervisory guidance for banks' risk management; actual loan terms govern the borrower.
Use the workpaper to discuss lease expiration risk
List all leases that expire within the next 12 months. For each expiring lease, note the current rent and the market rent for that unit type. The difference is potential rent upside or downside. Also note any renewal options in the lease. For retail properties, the OCC handbook advises that anchor tenants may pay a flat rate plus a percentage of their annual sales (percentage rent), and that percentage rents may vary considerably and are inherently less predictable [1].
Frequently asked questions
How do I reconcile a rent roll to a T-12 if the rent roll is current and the T-12 is historical?
Start with the rent roll snapshot. Calculate the expected monthly rent for each of the past twelve months based on the leases in place at that time. Then compare that expected amount to the actual collected rent shown in the T-12. The difference is collection losses. This reconciliation shows the lender how much rent is actually being collected versus what is owed.
What if my property has concessions like free rent or reduced rent periods?
List each concession separately in the unit-type rent summary. For each concession, note the unit number, the type of concession (free rent, reduced rent, other), the start and end dates, and the dollar amount. Then aggregate by unit type to show the total concession amount and the percentage of units with concessions. This gives the lender a clear view of the true effective rent.
How do I handle percentage rent or other variable components?
For units with percentage rent or other variable components, list the base rent separately from the variable component. For the variable component, provide the historical amounts from the T-12 and note the basis for the calculation (e.g., percentage of gross sales). The lender will want to see the trend and the stability of this income stream.
Model this deal and request financing
Run a multifamily acquisition or value-add model with your own numbers in the financing workbench. Results are calculated on the server with the assumptions shown. If you choose to send the request, you get a preliminary lender-package PDF and can attach your rent roll, T-12 or OM.
Opens the financing workbench operated by Wraith Real Estate. Nothing goes to any lender without Wraith's review and your agreement.
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).