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

Reconciling apartment unit counts across the model and source documents

A practical guide for commercial real estate sponsors to match unit counts between their financial model, rent roll, and legal documents, with a checklist to identify discrepancies before lender review.

Source: CodexTopic: Acquisition model inputs947 wordsUpdated 2026-11-19

A practical guide for commercial real estate sponsors to match unit counts between their financial model, rent roll, and legal documents, with a checklist to identify discrepancies before lender review.

When you prepare a financing request, lenders start by checking that the unit count in your model matches the rent roll and the legal description of the property. A mismatch, even by one unit, can slow underwriting or raise questions about how well you know the asset. This guide walks through the documents you need, the specific numbers to compare, and a worksheet you can prepare to show the lender you have reconciled every unit.

Identify the unit count in each source document

Start by gathering the documents that define the property. The rent roll is a snapshot of current occupancy, listing each unit by number, type, square footage, and rent. The legal description in the deed or the property survey states the total number of units the building was designed to contain. The appraisal or a feasibility study may reference a unit count used to estimate value. Record each count separately, noting the date of the document and who prepared it. A common discrepancy is a unit that was converted to a different use, such as a manager’s unit or a storage room, that appears on the legal description but not on the rent roll. [1]

Compare the model unit count to the rent roll

Your financial model likely projects revenue based on a certain number of units. Compare that number unit by unit to the rent roll. If the model assumes 100 units but the rent roll shows 98, identify the two missing units. Are they vacant, offline for renovation, or legally not rentable? The lender will want to see that you have accounted for every unit in the building. If a unit is not rentable, note why and whether it can be restored to income-producing use. This comparison also catches data entry errors, such as a unit listed twice or a unit omitted. [1]

Check the legal unit count against the appraisal

The appraisal may state a unit count that differs from the legal description, especially if the appraiser adjusted for units that are not marketable. For example, if a unit lacks a certificate of occupancy or is structurally compromised, the appraiser may exclude it from the value analysis. Record the appraiser’s unit count and note any adjustments. The lender will use the lower of the legal count or the appraiser’s count for underwriting, unless you can document that the excluded units can be brought to market. [1]

Reconcile unit types and mix

Apartments are not all the same. A building may have studios, one-bedrooms, two-bedrooms, and penthouses. Your model should break down revenue by unit type, and the rent roll should match that breakdown. If the model assumes 20 studios but the rent roll shows 18, find the two units that are misclassified. Unit mix affects rent projections, vacancy assumptions, and eventual NOI. A lender who sees a mismatch may question the reliability of your entire pro forma. [1]

Prepare a unit reconciliation worksheet

Create a simple spreadsheet with columns for each source: legal description, rent roll, appraisal, and model. List every unit by number, type, and square footage. Flag any unit that appears in one source but not another. Add a notes column for explanations, such as "converted to office" or "unit 3A is a manager’s unit not on rent roll." This worksheet is not a lender requirement, but it shows you have done the diligence to catch discrepancies. Submit it with the loan request to reduce underwriting questions. [1]

Understand how unit count affects loan structure

Lenders may consider unit count when sizing a loan, particularly for properties where the number of income-producing units influences the property’s value. If your model assumes a higher unit count than the legal documents support, the lender may reduce the loan amount. Conversely, if the legal count is higher but several units are not rentable, the lender may apply a discount. Reconciling unit counts early helps you set realistic expectations for loan size and structure.

Distinguish between gross units and net rentable units

Gross units include every unit in the building. Net rentable units exclude common areas, mechanical rooms, and units that are not income-producing. Your model should clearly state which count you are using. If the lender sees a gross unit count where they expected net, they may recalculate your revenue projections downward. Clarify in your model or worksheet whether you are using gross or net and why. This distinction is especially important for properties with significant common space or planned conversions. [1]

Frequently asked questions

What if a unit is vacant but still rentable?

List it on the rent roll as vacant but available. Include it in your unit count and note the expected rent in your pro forma. The lender will factor vacancy into underwriting, but excluding a rentable unit from the count would understate the property’s potential income.

Does a unit count discrepancy always hurt the loan request?

Not necessarily. A small discrepancy that you can explain, such as a unit taken offline for renovation, shows you know the property. The lender will ask for a plan and timeline to return the unit to service. A large or unexplained gap, however, may indicate you do not have control of the asset.

Should I include the unit reconciliation worksheet in the loan request?

Yes. Including it with the sources and uses, rent roll, and pro forma demonstrates thorough preparation. It is not a lender requirement, but it reduces back-and-forth during underwriting and positions you as a sponsor who has done the diligence.

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