Multifamily Underwriting: A 2026 Guide to Proformas and Waterfall Models

Multifamily underwriting evaluates whether an apartment property can meet an investor’s return requirements at a specific price and under defined operating assumptions. In 2026, lender scrutiny, changing tenant demand, and operating-cost volatility make it especially important to build a model that is consistent, supportable, and easy to defend.

The analysis connects historical performance with a forward-looking business plan. Trailing twelve-month financials show how the property has operated, while the proforma models potential performance after renovation, lease-up, or repositioning. The difference between those two views often defines the investment thesis.

Start With Clean, Comparable Data

A repeatable underwriting process begins with standardized information. Offering memoranda, rent rolls, and trailing twelve-month statements provide the core evidence for the analysis. The offering memorandum presents the seller’s asset and market narrative; the rent roll details units, rents, concessions, occupancy, and lease expirations; and the operating statements document historical revenue and expenses.

These documents should reconcile before projections begin. Gaps in historical statements or inconsistencies between a rent roll and operating statements force the underwriter to rely on unsupported assumptions. Standardizing data across systems such as Yardi, RealPage, and Entrata also makes competing opportunities easier to compare.

Build and Test the Proforma

The proforma converts historical results and the business plan into year-by-year projections of income, expenses, debt service, and returns. Income projections begin with in-place rents, unit mix, lease expirations, concessions, vacancy, collection loss, and market rent growth. Value-add models must also account for renovation timing, unit downtime, lease-up pace, and post-renovation rents.

Expense assumptions should be grounded in the property’s history and adjusted where appropriate for taxes, insurance, utilities, repairs, management fees, and replacement reserves. Deferred maintenance, structural repairs, and renovation costs should be modeled as capital outlays and timed against the income they are expected to produce.

Debt service connects property operations to the capital structure. The model should show debt coverage throughout the projection period and measure returns against invested equity, projected cash flow, and sale or refinance proceeds. Sensitivities should test the effects of slower rent growth, higher expenses, weaker occupancy, or changed exit conditions.

Model the Waterfall and Challenge Assumptions

A waterfall model shows how operating cash flow and disposition proceeds are divided between the sponsor and capital partners as performance thresholds are reached. Underwriting should present both the partnership-level return and the economics allocated to each investor class, since identical property-level returns can produce different outcomes under different distribution structures.

Red flags include unsupported rent growth, expenses below the property’s historical experience, and occupancy assumptions that overlook upcoming expirations. A disciplined workflow collects and reconciles source documents, standardizes the data, sets assumptions, builds the proforma, adds debt and waterfall calculations, runs sensitivities, and documents the recommendation. Consistency makes the result easier to audit, compare, and defend.

View the complete multifamily underwriting guide on Coastwise Analytics