Multifamily · Due Diligence Checklist

Multifamily Due Diligence Checklist

Multifamily due diligence checklist built for institutional acquisitions. Unit-level rent roll audit, RUBS reconciliation, red-flag spot checks. Free Excel.

Why the due diligence checklist looks different for multifamily

Multifamily diligence happens at the unit level. A 180-unit deal means verifying 180 individual leases, deposits, and concessions, a granularity that commercial diligence doesn't touch at the same scale.

Concession burn and loss-to-lease behave differently here than in net-lease commercial. Rent escalations are implicit (annual lease renewals at market-up) rather than explicit step schedules, so the diligence layer has to reconstruct rent growth from the trailing ledger rather than reading it off the leases.

RUBS, utility recoveries, and controllable operating expenses are where multifamily NOI quietly leaks. Each requires a property-specific reconciliation.

The multifamily-specific checklist

  1. 1

    Confirm title is clean

    Verify: title commitment, policy exceptions, recorded liens

  2. 2

    Reconcile rent roll to executed leases

    Verify: rent, expiration, deposit, and options match each lease 1:1

  3. 3

    Tie rent roll to T-12 general ledger

    Verify: three months of GL tie to within 1% of rent roll totals

  4. 4

    Review property condition assessment (PCA)

    Verify: deferred maintenance budgeted and reflected in the pro forma

  5. 5

    Review Phase I environmental report

    Verify: no REC, no HREC, no CREC without remediation plan

  6. 6

    Review zoning and entitlements

    Verify: current use is a permitted use; no pending rezoning

  7. 7

    Confirm tax status

    Verify: tax bills paid current, no special assessments pending

  8. 8

    Audit operating expenses

    Verify: three-year trend; flag any single-line change >10% YoY

  9. 9

    Spot-audit 10% of leases against the rent roll

    Verify: rent, expiration, concessions, deposits, pet fees, parking; at least 18 leases on a 180-unit deal

  10. 10

    Reconcile RUBS charges to actual utility invoices

    Verify: recovery rate vs. pro forma recovery assumption; flag any month under 60%

  11. 11

    Pull T-12 delinquency trend by unit

    Verify: unit-level concentration; flag any single unit with 60+ day delinquency appearing twice

  12. 12

    Verify concession rollback timing

    Verify: free-rent periods and concession step-downs tied to actual lease start dates, not underwriting assumptions

  13. 13

    Reconcile controllable vs. non-controllable opex

    Verify: three-year trend on repairs, turnover, marketing; flag any single line >15% YoY

  14. 14

    Confirm unit mix matches marketing collateral

    Verify: bedroom count, SF, and renovation status match broker package

Metrics that matter for multifamily

Metric Target Calculation
Rent-roll-to-GL variance <1% (rent roll total - trailing 3mo collections avg) / rent roll total
Concession burn months <1 month avg sum of concessions / leased units
Renovation ROI >20% return on cost post-reno rent premium × 12 / reno cost per unit
Economic vacancy 5–7% 1 - (effective rent / gross scheduled rent)
Expense ratio 35–45% of EGI opex / EGI
Break-even occupancy <85% (opex + debt service) / GSR

Red flags unique to multifamily

  • Concession burn visible in current rent roll but absent from broker pro forma

    the broker's forecast removes concessions in Year 2 when the data shows them persisting for 18+ months

  • Loss-to-lease below 2% on a value-add positioning

    zero loss-to-lease eliminates the underwriting thesis, the rents are already at market

  • Unit renovation spend under-budgeted at <$6,500/unit for a classic-to-renovated lift

    institutional renovations routinely run $8,500–$12,000/unit; under-budget breaks Year 2 rent achievement

  • Loss-to-lease exceeding 8%

    signals stale leases or mismanaged rent growth; the in-place roll understates market

  • Concessions over 1 month average

    demand weakness the broker's pro forma almost never prices in

  • RUBS recovery under 60%

    expense inflation flows directly to NOI because recoveries are capped below market

  • Single-month trailing collections under 96%

    rising delinquency typically precedes a 2-3% NOI miss within two quarters

Example — multifamily due diligence checklist walkthrough

A 180-unit Class B multifamily in Dallas is trading at $42M, roughly $233,000 per unit. The seller's rent roll shows $1,950 average effective rent, 94% physical occupancy, and a $3.4M T-12 NOI. On paper, the deal underwrites to a 5.1% cap rate with 15% rent upside under the value-add thesis.

The diligence work begins with the rent roll. Pull 18 leases (10% of units) and compare each one to its row in the rent roll. Two units show $100/month concessions that didn't appear on the roll, a $2,400 annualized NOI hit already. Three more units have pet fees that weren't in the T-12, a small add. Net, the rent roll is within 0.8% of the leases.

Next, tie the rent roll to the general ledger. Pull three months of operating statements and sum total rental income. The GL shows $316,400, $319,100, and $311,800, averaging $315,767. The rent roll implies $319,300. That's a 1.1% gap, just over the threshold. Pull the owner on a call, and the gap turns out to be RUBS recovery, billed at the unit level on the rent roll but booked as a separate line in the GL. Reconciliation passes.

The red flag emerges in the concession audit. The broker's pro forma assumes concessions burn off in Month 13. The actual data shows 28 units (15% of the portfolio) received concessions in the trailing 12 months, and only 9 of those have expired. The remaining 19 concessions run into Year 2 of the hold. That's roughly $45,000 of Year 2 NOI the pro forma didn't price. On a 5.1% cap, that's $880,000 of valuation impact, enough to move the deal.

The last check is RUBS. Pull 12 months of utility invoices. Water and sewer recovery shows 58%, below the 60% threshold and well below the 75% the pro forma assumes. That's another $28,000 of annualized recovery not happening. Combined with the concession burn, the deal's actual in-place NOI is closer to $3.33M, not $3.4M. At the purchase price, that's a 5.0% cap, not 5.1%, still a real deal, but one now structured with a $700,000 price reduction or a seller credit for the concession run-off.

The same workflow on a 360-unit deal is where manual methods break down: 360 lease audits, three months of GL reconciliation, and RUBS verification typically consume a full week of analyst time per property in spreadsheets. Moraine's multifamily module runs that week in an afternoon.

Download the multifamily due diligence checklist template

Pre-populated Excel template matching this checklist, ready to use on your next deal.

Get the template →

Questions about multifamily due diligence checklist

Automate multifamily due diligence checklist with Moraine

Upload the documents and get the analysis, the red-flag report, and the template in one pass.