Multifamily Underwriting Model: The Institutional Checklist

Multifamily Underwriting Model: The Institutional Checklist

An underwriting model has two jobs, and most conversations only cover the first. Job one is computation: turn a deal's inputs into NOI, coverage, and returns. Job two — the institutional job — is interrogation: expose every assumption to a specific check, so that by the time the deal reaches a committee, a lender, or your own final decision, each number has survived a question designed to break it.

This article is the second job, written as a checklist. It is organized the way an institutional reviewer actually reads a multifamily underwriting model — revenue first, then expenses, then the bridge, the debt, the exit, and the stress — with the specific check applied at each stop and the failure it exists to catch. Run it against your own model, a broker's, or a sponsor's; it works in all three directions. All figures are illustrative examples, not market data.

If you want the stage-by-stage build workflow instead, that is the multifamily pro forma walkthrough; this checklist assumes the model exists and asks whether it survives review.

Revenue Checks

1. Loss to lease is evidenced, not asserted. The gap between in-place and market rents drives most multifamily theses, so the first institutional question is always: market rents according to whom? The check: every market rent in the unit mix ties to comps of genuinely comparable product — same vintage, condition, and finish level as the units will be after the plan, not before. A model that comps unrenovated units against renovated stock has smuggled the renovation premium into the baseline, and the deal is being counted twice. Unit-mix construction and the comp discipline behind it are covered in the unit mix analysis guide.

2. Economic occupancy reconciles to collections. The model's vacancy stack — physical vacancy, concessions, bad debt — should reproduce, within reason, the relationship between the T-12's gross potential and its collected income. If the trailing statements show 91% economic collection and the pro forma assumes 95% with no funded mechanism for the improvement, the model contains four points of hope priced as income.

3. Other income is durable. Fee income, utility reimbursements, parking, pet rent: the check is whether each line exists in the trailing statements at the modeled run rate, or has a specific implementation plan with a phase-in. "Other income" is the traditional hiding place for the last $30,000 of NOI a deal needed.

Expense Checks

4. Every line clears the per-unit test. Expenses per unit per year, by category, against the reviewer's ranges for the vintage and market. The institutional read is not whether the total looks right — totals average away sins — but whether any single line is an outlier demanding a story: payroll suspiciously light for the unit count, R&M below what an older building plausibly consumes, marketing at zero.

5. The ratio is reconciled to the T-12, not to an ideal. The pro forma expense ratio will differ from the trailing one — taxes reset, insurance re-quotes, management normalizes — but every point of difference must map to a named adjustment. A pro forma running meaningfully leaner than the property's own history, justified only by "professional management," fails the check.

6. Taxes are underwritten at the buyer's basis. Where reassessment follows sale, the model carries taxes computed on the purchase price under local rules — frequently the single largest expense adjustment in the file, and the most common one quietly missing from seller materials.

7. Payroll matches the operating plan. On-site staffing modeled at real market wages for the unit count and service level. Owner-operators who did the work personally leave artificially light payroll in the T-12; the pro forma must staff the building the buyer will actually run.

The Bridge Check

8. Two NOIs, and a named path between them. The centerpiece of institutional review: in-place NOI (the property as it operates, honestly stated, on economic occupancy) and stabilized NOI, connected by a line-item bridge where every adjustment — premiums phased on turnover, the tax reset, expense normalization — is individually visible and individually challengeable. The check is brutal in its simplicity: cover the stabilized column and ask whether the in-place one, alone, justifies the price. The distance between the two numbers is exactly how much business plan the buyer is paying for in advance.

Debt Checks

9. Coverage is tested on in-place income. The DSCR that matters at close is computed on the income that exists at close — not on year-three stabilized NOI. A deal showing 1.45x coverage on stabilized income may show 1.15x on in-place, and the second number is the one the lender sizes to and the buyer lives with through the ramp. The coverage mechanics, including the back-solve from a lender minimum to maximum proceeds, are in the DSCR calculator guide.

10. The binding constraint is identified and stressed. The model shows both sizing tests — LTV and DSCR — flags which governs, and reprices proceeds at meaningfully higher rates. The institutional question behind the check: if rates move 50 basis points before close, how much equity does this deal suddenly need?

11. The financing matches the plan. A value-add ramp financed on a single permanent loan, or a bridge loan with no modeled refinance event, is a structural mismatch the model should not paper over. If the plan is bridge-to-perm, the model carries the IO period, the refinance test at stabilized value and stabilized coverage, and the failure scenario where the refi comes up short.

Exit Checks

12. The reversion runs on forward NOI at a defensible exit cap. Terminal value capitalizes the year-after-sale NOI, and the exit cap sits at or above the going-in cap absent a specific argument otherwise. The check: toggle the exit cap to equal the entry cap and note how much of the IRR was manufactured by the spread assumption alone.

13. Yield on cost clears the market with a margin. Stabilized NOI over total cost (price plus capital budget), compared against where stabilized product trades. The spread between yield on cost and the market cap rate is the deal's compensation for execution risk — and a spread of a few dozen basis points is the model announcing, quietly, that the plan must go nearly perfectly. Institutional reviewers read this one number before almost anything else, because it is the whole value-add proposition in a single subtraction.

Stress Checks

14. The sensitivity grid brackets the real exposures. The 5×5 matrix exists, is wired to live assumptions (not pasted values), and varies the two inputs the return genuinely depends on — typically exit cap against rent growth or entry price. The reading is directional: where does the return cross below the hurdle, and how plausible is that cell?

15. The plan itself is stressed, not just the market. For value-add deals, the grid's blind spot: what happens at partial premium capture, or a year of schedule slip. A model that can only stress cap rates treats the renovation as guaranteed — and the renovation is the part the buyer controls least on day one.

16. The model's own arithmetic is guarded. Tie-outs and error checks: sources equal uses, allocations sum to distributable cash, the rent roll rolls up to the revenue the cash flow consumes. Institutional reviewers have all seen a beautiful model with a broken link; the check exists because confidence and correctness are different properties of a spreadsheet.

The Fifteen-Minute Review Order

Institutional reviewers do not run the sixteen checks in numerical order — they run a triage sequence that fails bad files fast:

1. The two NOIs and the bridge (check 8) — thirty seconds to see how much business plan is priced in.
2. Yield on cost against the market cap (check 13) — one subtraction that reads the whole margin.
3. Coverage on in-place income (check 9) — does the deal even finance as it sits?
4. The exit-cap convention (check 12) — toggle it flat and watch the IRR.
5. Then, and only if the deal survives, the line-by-line work — comps behind the market rents, the expense reconciliation, the plan stresses.

The sequence works because the first four checks consume minutes and catch most of what is fatal. A file that fails two of them rarely deserves the afternoon the other twelve checks cost.

And some findings end the review immediately rather than deducting points: a model with one NOI and no bridge, market rents with no comp support anywhere in the package, an exit cap below the going-in cap with no argument attached, or a locked file whose formulas cannot be inspected at all. These are not aggressive assumptions to be haircut — they are disclosures about how the file was built, and the appropriate response is to rebuild the underwriting from documents rather than adjust someone else's conclusions.

Running the Checklist as Diligence

Sixteen checks, three uses. On your own model, run them before the letter of intent — every check failed now is a renegotiation lever or an avoided mistake. On a broker's pro forma, the checklist is a translation device: their file will fail several checks by design, and each failure tells you where the asking price came from. On a sponsor's underwriting, as an LP, checks 8, 12, and 13 are the fastest read on whether you are being shown underwriting or marketing — ask for the two NOIs, the exit-cap convention, and the yield-on-cost spread, and the answers (or the reluctance) tell you most of it.

The Model Behind the Checklist — and When You Need the Suite

Every check above presumes a model with the machinery to answer it: the two-column rent roll, the economic vacancy stack, the T-12 bridge, dual-constraint debt, the forward-NOI reversion, the live sensitivity grid, and the tie-outs. The Multifamily Sheet is that machine for single-asset acquisitions — the checklist is effectively a tour of its tabs.

The Multifamily Underwriting Suite is the step up for the deals where the checks get harder: larger properties, messier operating statements, deeper diligence. It extends the same conventions with heavier T-12 normalization and unit-level analysis — built for the underwriting where the inputs are the battle, not just the math. Same construction standards throughout: fully unlocked, no VBA, documented methodology, versioned.

Frequently Asked Questions

What is the difference between a pro forma and an underwriting model? In practice the terms overlap; the useful distinction is posture. A pro forma projects; an underwriting model projects and interrogates — it carries the checks (bridges, benchmarks, dual constraints, stress grids) that force every assumption to defend itself. This checklist is the interrogation layer.

What DSCR do institutional multifamily buyers underwrite to? The lender's minimum sets the floor — commonly quoted around 1.20x–1.25x for stabilized product — but the institutional habit is to check coverage on in-place income and to stress it, because the closing-day number is the one that constrains proceeds. Confirm any specific threshold on a live term sheet.

What expense ratio should a multifamily model show? The property's own normalized history, adjusted line by line — not a universal target. The check is reconciliation to the T-12 with named adjustments; a "correct" ratio imported from a rule of thumb is exactly what the per-unit test exists to catch.

How do I underwrite a multifamily deal with bad or missing financials? Wider ranges, harder stresses, and a price that compensates. Component-build the expenses (assessor, insurance quotes, comparable operating data), underwrite revenue from the physical rent roll you can verify, and treat the missing T-12 itself as diligence information about the seller.

This article is for educational purposes only and does not constitute investment, legal, or tax advice. All figures are illustrative examples, not market data. Lender requirements vary; confirm terms with your lender. Consult qualified professionals before making investment decisions.