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

Documenting which loan-sizing test limits a proposed multifamily request

A practical guide for commercial real estate sponsors to identify and document the most restrictive loan-sizing constraint on a multifamily property, including a downloadable evidence checklist and guidance on reconciling rent rolls, T-12s, and debt-service coverage calculations.

Source: CodexTopic: Using financing models and packages1067 wordsUpdated 2026-11-19

A practical guide for commercial real estate sponsors to identify and document the most restrictive loan-sizing constraint on a multifamily property, including a downloadable evidence checklist and guidance on reconciling rent rolls, T-12s, and debt-service coverage calculations.

When you present a multifamily financing request to a lender, the underwriter will run several sizing tests against your property's income. The loan will be limited by whichever test produces the smallest amount. Your job as sponsor is to document which test is likely to bind before you submit, so you can structure the request realistically and avoid surprises.

Identify the primary sizing tests a lender will apply

Most multifamily lenders evaluate at least three constraints: loan-to-value (LTV), debt-service coverage ratio (DSCR), and sometimes a third test based on loan per unit or a maximum loan amount tied to the sponsor's liquidity. The binding test is the one that yields the lowest loan amount.

To prepare, you need the property's as-is or as-stabilized value, the net operating income (NOI), and the proposed debt service. Lenders apply their own LTV limits and DSCR minimums based on property type, location, and portfolio concentration. Bank supervisory guidance notes that lenders should "establish prudent underwriting standards that are clear and measurable, including LTV limits" [1]. These are internal bank policies, not fixed rules for every transaction.

Gather the current rent roll as a snapshot

A rent roll is a point-in-time list of every unit, its tenant, lease term, monthly rent, and any concessions or delinquencies. It shows what is leased today and what is vacant. To be useful for sizing, the rent roll must also show the security deposit status and any rent abatements.

Record the following from the rent roll: total gross potential rent, total rent concessions, total vacancy (dollar amount and percentage), and total collected rent for the current month. This snapshot tells you the immediate cash flow but does not show seasonal patterns or one-time events. The rent roll is the starting point for calculating effective gross income.

Prepare a trailing twelve-month operating statement

A T-12 is a month-by-month income and expense report for the most recent twelve months. It shows actual collected revenue, not just leased amounts. The T-12 reveals trends in vacancy, rent growth, expense increases, and any non-recurring items like a large repair or a legal settlement.

Reconcile the two documents by identifying the difference between gross potential rent on the rent roll and actual collected rent on the T-12. That gap represents concessions, vacancy loss, and collection loss. A lender will want to understand whether the gap is improving or worsening.

Calculate net operating income from the T-12

From the T-12, subtract total operating expenses from effective gross income (collected rent plus other income like parking or laundry) to arrive at NOI. Operating expenses include property taxes, insurance, management fees, utilities, repairs and maintenance, and reserves for replacement. Do not include debt service or capital expenditures in NOI.

Compare NOI to the proposed debt service

Once you have NOI, test it against the proposed loan amount and terms. Use an amortization schedule or a debt constant to find annual debt service. Divide NOI by the required DSCR to find the maximum annual debt service the property can support. Then divide that annual debt service by the debt constant to find the maximum loan amount.

Document the binding test with a worksheet

Create a one-page workpaper with the following sections:

Property information - Property name and address - Number of units - Year built

Rent roll snapshot (current month) - Gross potential rent: $___ - Vacancy (units and dollars): ___ units, $___ - Concessions: $___ - Collected rent: $___ - Effective gross income (collected rent plus other income): $___

T-12 summary (most recent 12 months) - Total collected revenue: $___ - Total operating expenses: $___ - Net operating income: $___ - Average occupancy: ___% - Any non-recurring expense items: ___ (list and estimate if recurring)

Proposed financing assumptions - Requested loan amount: $___ - Interest rate assumption: % - Amortization period: ___ years - Annual debt service: $

Sizing tests - LTV test: Value $___ x LTV limit % = $ - DSCR test: NOI $___ / required DSCR x = max annual debt service $ / debt constant ___ = max loan $___ - Binding test: LTV or DSCR (circle one) - Maximum loan amount under binding test: $___

This worksheet is not a lender form. It is a suggested way to organize information for your own preparation and for discussion with a lender.

Distinguish NOI from cash flow available for equity

Lenders underwrite to NOI, not to the cash flow that reaches the sponsor after debt service. NOI is before debt service. After paying debt service, the remaining cash flow is available for capital expenditures, reserves, and equity distributions. Do not confuse NOI with the sponsor's cash-on-cash return. The lender cares about NOI coverage of debt first.

Also distinguish gross rent from collected income. Gross rent is the total of all signed leases. Collected income is what actually hits the bank account. A lender will use collected income, not gross rent, to calculate effective gross income.

Ask the actual lender for its specific tests

No guide can tell you exactly what a particular lender will require. Bank policies vary based on the institution's size, risk appetite, and portfolio concentration. The OCC handbook notes that lenders should "establish prudent underwriting standards that are clear and measurable" and that these standards should be applied consistently [1]. As a sponsor, you can ask the lender directly: "What LTV and DSCR minimums do you apply to multifamily properties in this market?" The answer will help you focus your documentation.

Frequently asked questions

How do I reconcile a rent roll and a T-12 that show different occupancy numbers? The rent roll is a snapshot of the current month. The T-12 shows average occupancy over twelve months. If the rent roll shows higher occupancy, the property may have improved recently. A lender will likely use the T-12 average because it is more representative. Record both numbers and note any trend.

What if the DSCR test produces a much lower loan than the LTV test? That means the property's income is weak relative to its value. You can increase equity, negotiate a lower purchase price, or find a lender with a lower DSCR requirement. The worksheet helps you see the gap before you apply.

Should I include capital expenditures in the T-12 expenses? Capital expenditures (roof replacement, HVAC upgrades) are not operating expenses. They are typically treated separately and may be added back to NOI for underwriting if they are one-time items. Check with the lender on how to treat major capex.

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