Underwriting Multifamily Deals with AI: A Practical Walkthrough

Underwriting a 48-unit apartment building used to take a senior analyst 2-3 days. You'd receive a PDF rent roll that looks like it was formatted in Excel circa 2009, spend an afternoon normalizing it, another morning pulling comp data from CoStar and calling brokers, then a full day building the pro-forma model and stress-testing the assumptions. By the time you had a clear picture of the deal, the seller had already received three other LOIs.

With AI-assisted underwriting workflows, the same analysis runs in under 4 hours — and the output is more rigorous, not less. Here's exactly how the workflow operates, using a real 48-unit garden-style apartment deal in the Southeast as the running example.

Step 1 — Rent Roll Extraction and Normalization

The first bottleneck in multifamily underwriting is always the rent roll. Sellers provide it in inconsistent formats — sometimes a clean Excel export, more often a scanned PDF or a printed-and-re-scanned document that's been through three ownership transfers. Before any analysis can happen, the data has to be extracted and normalized into a consistent structure.

AI document parsing handles this step in under 90 seconds. Upload the rent roll PDF, and the system returns a structured table: unit number, unit type (studio/1BR/2BR/etc.), square footage, current rent, lease start, lease expiry, tenant status (occupied/vacant/month-to-month), and any concessions in place. The AI flags anomalies automatically: below-market units that suggest long-term tenants with embedded discounts, units with lease expirations clustering in the next 60 days (lease cliff risk), and rent concessions that inflate the apparent gross income figure.

On the 48-unit deal, the parsed rent roll revealed that 8 units were on month-to-month leases and 6 had lease expirations within 45 days — a 29% near-term rollover exposure that wasn't visible in the headline occupancy number the broker had quoted. That single insight changed how the team structured their offer and contingency period.

Step 2 — Market Comp Pull and Rent Gap Analysis

With a clean rent roll in hand, the next step is establishing the market rent ceiling — what comparable units in the same submarket are actually leasing for — and computing the rent upside on a per-unit-type basis.

AI queries rent comp databases (a combination of CoStar API, RentCast, and local MLS data where available) and identifies comparable units: same submarket, similar vintage, similar unit mix, similar amenity set. It returns a comp matrix with median and 75th-percentile rents per unit type, then calculates the rent gap — the difference between the property's in-place rents and market achievable rents — for each unit type.

On the 48-unit deal, the rent gap analysis identified 14 units — all 2-bedroom units — carrying rents that were 18% below the market median. At current below-market rents, those 14 units generated $189,000 in annual gross income. At market rents achievable with lease-up over 18 months, they'd generate $223,000 — a $34,000 annual increase, which at a 6% cap translates to $567,000 in added value at stabilization. That number became the anchor for the value-add underwriting thesis.

The analysis that used to require a CoStar analyst spending three hours pulling comps and building a comparison matrix now runs in under 15 minutes, with the output delivered in a format that flows directly into the pro-forma model.

Step 3 — Pro-Forma Generation and Sensitivity Tables

The final step is converting the rent roll data and comp analysis into a 5-year pro-forma and a risk/return sensitivity table. This is where most analysts spend the most time — not because the math is difficult, but because building a model flexible enough to stress-test multiple scenarios requires significant setup work.

AI populates the pro-forma from the structured data produced in Steps 1 and 2, applying standard assumptions (5% vacancy for stabilized Class B, 35-40% expense ratio for garden-style apartments, 1.5-2% capex reserve depending on vintage) with the ability to override any assumption manually. The 5-year model projects NOI growth, debt service coverage under the proposed financing terms, and distributable cash flow to equity.

The sensitivity table is where the output becomes most useful for investor decision-making. The AI generates a matrix showing IRR outcomes across three variables: exit cap rate (ranging from current market cap to a 75-basis-point expansion), hold period (3, 5, and 7 years), and rent growth assumption (flat, 2% annual, and 3.5% annual). The result is a single-page view of the deal's risk profile — the range of outcomes under realistic scenarios — rather than a single-point estimate that's almost certainly wrong.

On the 48-unit deal, the sensitivity table showed that the base case (5-year hold, 5.75% exit cap, 2.5% annual rent growth) produced a 17.2% IRR. The stress case (7-year hold, 6.5% exit cap, flat rents) still produced an 11.4% IRR — above the team's minimum return threshold. That range of outcomes gave the investment committee the context to make a confident decision rather than a hopeful one.