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

Preparing a property-level operating comparison for a small apartment portfolio

A practical guide to building a side-by-side operating comparison for a small apartment portfolio, with a concrete evidence checklist to support the financing discussion.

Source: CodexTopic: Property-specific operating packages1156 wordsUpdated 2026-11-19

A practical guide to building a side-by-side operating comparison for a small apartment portfolio, with a concrete evidence checklist to support the financing discussion.

When you own several small apartment buildings, a lender will want to see how each property performs on its own before considering the whole portfolio. A property-level operating comparison helps you present that information clearly. This guide explains what to prepare, how to organize it, and how the information affects the financing conversation.

Start with a current rent roll for each property

A rent roll is a snapshot of the property on a specific date. It lists each unit, the tenant, the lease term, the monthly rent, and any concessions or deposits. The date should be within 30 days of when you submit the package. If a unit is vacant, note it. If a unit is rented below market, note the lease expiration. The rent roll shows the lender the gross potential rent at that moment. It does not show what you actually collected over time. For that, you need the trailing twelve months of operating statements, often called a T-12. The T-12 covers twelve historical months and shows actual income and expenses. Comparing the rent roll to the T-12 can reveal timing differences: a rent roll may show full occupancy while the T-12 reflects a period with vacancies. Explain those differences in a short note.

Build a trailing twelve-month operating statement for each property

The T-12 is a report of actual income received and expenses paid over the prior twelve months. It should be prepared on the same accounting basis you use for your financial statements, whether cash or accrual. If you use accrual, note that rent is recorded when earned, not when received. If you use cash basis, note that rent is recorded when collected. Reconcile the periods: if the T-12 ends in June but the rent roll is dated August, explain any large changes in occupancy or rent between those dates. The T-12 gives the lender a historical view of net operating income, or NOI, which is gross income less operating expenses. Operating expenses include costs like property taxes, insurance, repairs, management fees, and utilities. They do not include interest, principal payments, or income taxes. [1]

Distinguish gross rent, collected income, and NOI

Lenders look at several income and cash flow measures. Gross rent is the total rent if all units are leased at full market rates. Collected income is what you actually received after vacancies, concessions, and bad debt. NOI subtracts operating expenses from collected income. After NOI, the lender considers debt service, which is the principal and interest on the loan. What remains is equity cash flow, which is the return to the owner after all property expenses and debt payments. A cap rate divides NOI by property value. [1]

Prepare a side-by-side comparison of key operating metrics

Create a simple spreadsheet with one row per property and columns for the following items. Use actual numbers from your rent roll and T-12. Do not use pro forma projections unless you also show the actual historical figures.

  • Property name and address
  • Number of units
  • Gross potential rent (from rent roll)
  • Vacancy and concession loss (dollar amount and percentage)
  • Collected income (gross rent minus losses)
  • Operating expenses (total from T-12)
  • NOI (collected income minus operating expenses)
  • Annual debt service on existing loans (if any)
  • Equity cash flow (NOI minus debt service)
  • Occupancy rate (percentage of units leased)
  • Average rent per unit

This comparison lets a lender see which properties carry the portfolio and which need attention. It also helps you identify where you might improve performance before seeking financing.

Include a capital expenditure history and plan

Lenders want to know what capital items you have spent on and what you plan to spend. Capital expenditures are not operating expenses. They include items like a new roof, HVAC replacement, or parking lot resurfacing. List major capital projects completed in the last three years, the cost, and the year. Then list planned capital projects for the next two years, with estimated costs. This helps the lender understand whether the property needs significant investment soon, which could affect cash flow. [1]

Explain any non-recurring income or expenses

If your T-12 includes a one-time insurance settlement, a large repair from a storm, or a legal settlement, note it separately. The lender will want to know that those items are not expected to repeat. If you exclude them from your NOI calculation, explain why. Consistency matters more than a high number. A lender would rather see a stable, repeatable NOI than one inflated by unusual items.

Suggested worksheet: property operating comparison

Create a single document with the following sections for each property. Label it "Property Operating Comparison" and date it.

Section 1: Property summary - Name, address, year built, number of units, building type - Current rent roll date and occupancy rate - T-12 period covered (start and end dates)

Section 2: Income and expense summary - Gross potential rent - Vacancy and concession loss - Collected income - Operating expenses (list major categories: taxes, insurance, utilities, management, repairs, other) - NOI - Debt service (if any) - Equity cash flow

Section 3: Capital expenditure history and plan - Completed projects (item, cost, year) - Planned projects (item, estimated cost, expected year)

Section 4: Notes on non-recurring items - Describe any one-time income or expense - State whether it is included or excluded from NOI

Section 5: Reconciliation of rent roll to T-12 - Explain any large differences between the rent roll snapshot and the T-12 average

How this affects the financing discussion

The lender uses your operating comparison to underwrite the loan. The NOI helps the lender assess the property's ability to service debt. If your NOI is low because of high vacancies or expenses, the lender may adjust loan terms accordingly. The capital expenditure plan tells the lender whether the property will need more cash soon. If large capital projects are coming, the lender may require reserves or a higher equity contribution. The side-by-side comparison also helps the lender evaluate the borrower's portfolio concentration as part of its overall risk assessment. [1]

FAQs

How far back should my operating statements go?

Provide at least the trailing twelve months. If you have three years of history, include that as well. More history helps the lender see trends in occupancy, rent growth, and expenses.

What if my properties use different accounting methods?

Prepare each T-12 on the same basis as the property's financial statements. Then note the method used for each property. If one is cash basis and another is accrual, explain the difference in a note. The lender will reconcile them during underwriting.

Do I need to include properties I plan to sell?

Include all properties you own, even those you plan to sell. The lender needs a complete picture of your portfolio. If a property is for sale, note that in the comparison. The lender may exclude it from the underwriting or adjust the loan amount accordingly.

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.

Open the acquisition model

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