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

How to separate commercial and residential income in a mixed-use building

A practical guide to separating commercial and residential income streams in a mixed-use building for a financing request, including a document checklist and reconciliation steps.

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

A practical guide to separating commercial and residential income streams in a mixed-use building for a financing request, including a document checklist and reconciliation steps.

When a mixed-use building contains both commercial and residential units, lenders need to see each income stream clearly separated. This guide explains how to prepare the operating package so that a sponsor can present a complete and credible request.

Why separation matters to lenders

Lenders underwrite income-producing real estate by evaluating the trend, level, and stability of income and expenses. For a mixed-use building, the commercial and residential portions often have different lease structures, expense profiles, and vacancy patterns. If the rent roll and operating statements lump them together, a lender cannot assess the risk and stability of each income source separately. Separating the two streams makes those trends visible.

Prepare a current rent roll with unit-type flags

A current rent roll is a snapshot of the building at a single point in time. For each unit, record: - Unit number and type (commercial or residential) - Square footage - Current base rent and any additional rent (CAM, utilities, parking) - Lease start and end dates - Security deposit held - Any concessions or free rent periods

Flag each unit as commercial or residential. If a commercial tenant pays percentage rent or has expense stops, note those terms separately. The rent roll does not show history; it shows what is in place now.

Gather the trailing twelve months of operating statements

A trailing twelve months (T-12) report shows actual income and expenses for each of the past twelve months. Unlike the rent roll, it captures collections, delinquencies, and seasonal variation. The T-12 should be prepared on the same reporting basis as the building’s financial statements (cash or accrual). Identify the reporting basis and reconcile the periods before comparing totals.

For each month, separate: - Gross rent for commercial units - Gross rent for residential units - Other income (laundry, parking, vending) and flag which side it belongs to - Total collected income for each type - Operating expenses, allocated where possible (e.g., common area maintenance, utilities, management fees)

If expenses cannot be precisely allocated, use a reasonable allocation method (e.g., by square footage) and disclose it.

Reconcile the rent roll and the T-12

The rent roll shows what should be collected. The T-12 reports historical income and expenses on its stated accounting basis. Compare the two to identify: - Vacant units not yet reflected on the rent roll - Delinquent tenants - Free rent or concession periods that reduce actual income below the rent roll - Any one-time income or expense that does not recur

A suggested way to prepare this reconciliation is to create a simple spreadsheet with columns for unit, rent roll amount, actual collected amount, variance, and explanation. This document helps a lender understand the gap between potential and actual income.

Calculate NOI for each income stream

NOI is the property's net income from operations after all operating expenses are paid, before debt service, capital expenditures, and income taxes. For each stream, start with gross income, subtract a vacancy and credit loss allowance, then subtract operating expenses. Do not subtract debt service, capital expenditures, or income taxes at this stage. Those come later in the underwriting.

For the commercial portion, consider whether tenants pay their own utilities or property taxes. If they do, those expenses should not appear in the building’s operating expenses. For the residential portion, utilities and maintenance are typically the landlord’s responsibility.

Document the business plan for each side

If the commercial space is being re-tenanted or the residential units are being renovated, the lender will want a pro forma that shows expected income after the plan is executed. The pro forma should separate commercial and residential assumptions, including: - Projected rent per square foot or per unit - Lease-up period and vacancy during transition - Capital expenditure budget for each side

For a construction or bridge loan, the lender may require an interest reserve to cover loan interest during construction and lease-up [1]. The reserve amount is typically determined by the lender based on the project budget and timeline.

Evidence checklist for the loan request

Prepare these documents in a single operating package: 1. Current rent roll with unit-type flags and lease terms 2. T-12 operating statements with commercial and residential income separated 3. Reconciliation of rent roll to T-12, with explanations for variances 4. Two-year historical income and expense summary, if available 5. Pro forma for the next 12 months, showing separate streams and combined NOI 6. Schedule of any capital expenditures planned for either side 7. Allocation method for shared expenses, disclosed in writing

FAQs

How do I allocate shared expenses like common area maintenance or property management fees?

Use a reasonable, consistent method such as square footage or gross income percentage. Disclose the method in a short note attached to the operating statements. Lenders will ask for the rationale, so be prepared to explain why the allocation is fair.

What if the commercial tenant has a long-term lease below market rent?

Show the actual lease terms on the rent roll and in the T-12. The lender will underwrite based on actual income, not market rent, unless the lease is expiring soon and a higher rent is realistic. If the lease is below market, note the expiration date and any renewal options.

Do I need a separate appraisal for the commercial and residential portions?

Not necessarily. The appraisal may value the entire property using the income approach, which capitalizes total NOI, or may use other approaches depending on the property type and market. If the commercial and residential portions have very different cap rates, the appraiser may apply a weighted average. Ask the lender whether they want a single value or separate values for each use.


If you are preparing a mixed-use building for financing, send us the property, the business plan, and the capital you need. 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.

Open the loan sizing 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