Blog
Industry Models14 min13 September 2026Alex TapioBy Alex Tapio

How to Underwrite a Multifamily Acquisition

How to Underwrite a Multifamily Acquisition

Key Takeaways

  • Underwriting is a chain, not a single number. Rent roll feeds EGI, EGI feeds NOI, NOI feeds both the cap rate check and the DSCR test, and NOI plus the value-add plan feeds the exit returns. An error early in the chain compounds through every step after it.
  • Rebuild NOI from the actual rent roll, not the broker's pro forma - the gap between in-place and "pro forma" NOI is usually where the optimism lives.
  • DSCR is the real constraint for financed deals. A property can look attractive on cap rate alone and still fail to qualify for the loan size you need if NOI does not clear the lender's DSCR minimum.
  • The value-add plan is the thesis, not a footnote. Model the renovation capex, the realistic rent premium, and the multi-year ramp explicitly - a widening DSCR cushion over the hold is often more persuasive underwriting evidence than the exit IRR alone.
  • Exit cap rate assumptions deserve the most scrutiny. Cap rate compression is not guaranteed; always stress-test the exit at a flat or wider cap before trusting the projected IRR.
  • Present a range of returns, not a point estimate. Cash-on-cash return, IRR, and equity multiple each tell a different part of the story - a deal with a low Year 1 cash-on-cash return can still be an excellent value-add investment if the multi-year IRR and equity multiple clear your hurdle.

To go deeper on the individual pieces of this model, see our guides to building a real estate pro forma, the debt service coverage ratio, and cap rate fundamentals. To test your own numbers, try our DSCR calculator and IRR calculator.

Underwriting a multifamily acquisition means turning a broker's marketing package into your own number: what will this property actually pay you, and does the price justify the risk? This guide walks through the full six-step process a sponsor runs before wiring earnest money - building the rent roll, calculating net operating income (NOI), testing the deal against a lender's DSCR minimum, modeling a value-add renovation plan, and underwriting the exit - using a fully worked 150-unit example with real numbers at every step.

Multifamily underwriting is not one calculation - it is a chain of them, each one feeding the next. A broker's offering memorandum will hand you a "pro forma NOI" that assumes every unit is renovated, fully leased, and paying top-of-market rent on day one. Your job as the buyer is to rebuild that number from the actual rent roll, layer in a realistic financing structure, and decide whether the resulting returns clear your hurdle rate. Skip a step - or worse, trust someone else's step - and you overpay.

flowchart TD A["Rent Roll and Unit Mix"] --> B["Gross Potential Income minus Vacancy plus Other Income"] B --> C["Effective Gross Income EGI"] C --> D["Less Operating Expenses"] D --> E["Net Operating Income NOI"] E --> F["Going-In Cap Rate Check vs. Purchase Price"] E --> G["Size Debt and Test DSCR"] G --> H["Model Value-Add Plan and Stabilized NOI"] H --> I["Underwrite Exit Value and Sponsor Returns"]

The Multifamily Underwriting Chain: From Rent Roll to Exit Returns


The Six-Step Underwriting Process

Every multifamily acquisition underwriting model - whether it is a 24-unit walk-up or a 400-unit garden community - runs through the same sequence:

  1. Build the rent roll and unit mix from the actual, verified in-place rents (not the broker's asking rents).
  2. Project income down to Effective Gross Income (EGI), accounting for vacancy, credit loss, and other income.
  3. Build operating expenses line by line and calculate Net Operating Income (NOI).
  4. Check the going-in basis by dividing NOI by the purchase price to get the going-in cap rate.
  5. Size the debt and test DSCR against the lender's minimum covenant.
  6. Model the value-add plan - renovation capex, rent premiums, and the resulting stabilized NOI.
  7. Underwrite the exit - a resale cap rate, sale costs, loan payoff, and the resulting cash-on-cash return, IRR, and equity multiple.

We will work through all seven with one running example: a 150-unit, Class B garden-style community trading at $18,500,000.


Step 1: Build the Rent Roll and Unit Mix

The rent roll is the foundation of the entire model - not the seller's pro forma, the actual current rent roll, unit by unit. Group units by type and take the average in-place rent for each group.

Unit Type Units Avg. In-Place Rent Monthly Rent
Studio / 1BR 75 $850 $63,750
2BR / 3BR 75 $1,090 $81,750
Total 150 - $145,500

Annualized, that is Gross Potential Rent (GPR) of $1,746,000 - the revenue the property would collect if every unit were occupied, all year, at the current in-place rent. This is the starting point, not the answer: it assumes zero vacancy and ignores whatever the broker claims "market rent" should be.

The gap between these in-place rents and what renovated, re-leased units are actually achieving in the submarket is the entire thesis of a value-add deal - and it is the first thing worth verifying independently against comparable listings, not the seller's claims.


Step 2: Project Income Down to Effective Gross Income (EGI)

Gross Potential Rent overstates real revenue in two ways: some units sit vacant or in collections, and some revenue comes from sources other than rent (parking, pet fees, laundry, application fees). Effective Gross Income (EGI) corrects both.

// Effective Gross Income (EGI)
= GPR - (GPR * Vacancy_And_Credit_Loss_Rate) + Other_Income

For this property, assume a 5% vacancy and credit loss allowance - reasonable for a stabilized Class B asset in a healthy submarket - and $45,000 of annual other income from parking, pet rent, and laundry.

Line Item Annual Amount
Gross Potential Rent (GPR) $1,746,000
Less: Vacancy & Credit Loss (5%) ($87,300)
Plus: Other Income $45,000
Effective Gross Income (EGI) $1,703,700

Underwriters typically test the vacancy assumption against both the property's own trailing 12-month history and the submarket average from a source like a local apartment association or CoStar - if the seller's trailing vacancy is materially lower than the submarket, treat that as a red flag rather than a feature.


Step 3: Build Operating Expenses and Calculate NOI

Net Operating Income (NOI) is EGI less all operating expenses required to run the property - before debt service, capital expenditures, and income taxes. Build it line by line rather than as a single expense-ratio guess; it is the single most manipulated number in a broker's offering memorandum.

Expense Line Per Unit / Year Annual Total
Property taxes $1,050 $157,500
Insurance $350 $52,500
Utilities (common area) $300 $45,000
Repairs & maintenance $650 $97,500
Payroll (on-site staff) $900 $135,000
General & administrative $200 $30,000
Management fee (3% of EGI) - $51,111
Total Operating Expenses - $568,611
// Net Operating Income (NOI)
= EGI - Total_Operating_Expenses

// Expense ratio sanity check
= Total_Operating_Expenses / EGI
Metric Value
Effective Gross Income $1,703,700
Less: Total Operating Expenses ($568,611)
Net Operating Income (Year 1) $1,135,089
Expense Ratio (OpEx / EGI) 33.4%

An expense ratio in the low-to-mid 30s is reasonable for a well-run, moderately sized Class B community - the typical range runs 30-45% depending on age, climate, and whether utilities are owner-paid. If a seller's pro forma shows an expense ratio well below that range, the difference is usually deferred maintenance about to become your problem, not genuine efficiency. For the full build from gross rent to NOI, including reserves and levered cash flow, see our guide to building a real estate pro forma.


Step 4: Check the Going-In Basis with the Cap Rate

Once you have Year 1 NOI, divide it by the purchase price to get the going-in cap rate - the single number brokers lead with, and the one most often manipulated by using an inflated, forward-looking "pro forma NOI" instead of the actual in-place figure.

// Going-in cap rate
= NOI_Year1 / Purchase_Price
Metric Value
Purchase Price $18,500,000
Year 1 NOI (in-place) $1,135,089
Going-In Cap Rate 6.1%

A 6.1% in-place cap rate is a realistic, if unspectacular, starting basis for a Class B value-add deal - the return is unremarkable before the renovation plan does anything. That is normal: value-add sponsors are explicitly underwriting the gap between this in-place number and the stabilized NOI they expect to create in Steps 6 and 7, not the day-one yield. For more on how cap rates translate income into price (and vice versa), see our guide to cap rate fundamentals.


Step 5: Size the Debt and Test DSCR

With NOI established, size the acquisition loan and confirm the deal clears the lender's minimum Debt Service Coverage Ratio (DSCR) - the ratio of NOI to annual debt service that determines whether a lender will fund the loan at all, and at what size.

Assume a 70% loan-to-value (LTV) acquisition loan at a 5.75% fixed rate, structured as interest-only for the hold period (typical for a bridge loan financing a renovation program, since there is no amortization to model until refinancing into permanent debt at stabilization).

// Loan amount
= Purchase_Price * LTV

// Annual debt service (interest-only)
= Loan_Amount * Interest_Rate

// DSCR
= NOI / Annual_Debt_Service
Metric Value
Purchase Price $18,500,000
Loan Amount (70% LTV) $12,950,000
Equity (Down Payment) $5,550,000
Interest Rate 5.75%
Annual Debt Service (Interest-Only) $744,625
Year 1 NOI $1,135,089
Year 1 DSCR 1.52x

Most agency and bank lenders set a minimum DSCR of 1.20x-1.25x for stabilized multifamily; bridge lenders financing a heavier value-add plan often accept 1.00x-1.15x in-place, betting on the renovation to grow coverage over the hold. At 1.52x, this deal clears even a conservative 1.25x covenant with room to spare in Year 1 - before the value-add plan has done any work. For a deeper look at how lenders calculate and stress-test this ratio, see our guide to the debt service coverage ratio.


Step 6: Model the Value-Add Plan and Stabilized NOI

This is the step that separates multifamily underwriting from a simple income-property pro forma: modeling the capital plan that closes the gap between in-place rent and market rent, and the resulting stabilized NOI once the renovation is complete.

Budget $22,000 per unit ($3,300,000 total across 150 units) for interior renovations - new flooring, countertops, fixtures, and appliances - funded from the initial equity raise alongside the down payment, not from operating cash flow.

In-Place (Year 1) Post-Renovation (Market) Premium
Studio / 1BR $850 $1,000 +$150
2BR / 3BR $1,090 $1,285 +$195

Rent premiums of 150/mo and 195/mo on renovated units are conservative for a Class B value-add plan - well within the 10-25% lift typical of a well-executed interior renovation program. Assuming all 150 units are renovated and re-leased by Year 5, and market rents grow a modest 3% per year over that ramp:

Metric Year 1 (In-Place) Year 5 (Stabilized)
Gross Potential Rent $1,746,000 $2,314,609
Less: Vacancy & Credit Loss ($87,300) ($115,730)
Plus: Other Income $45,000 $50,648
Effective Gross Income $1,703,700 $2,249,527
Less: Operating Expenses ($568,611) ($638,709)
Net Operating Income $1,135,089 $1,610,818
DSCR (on original debt) 1.52x 2.16x

Operating expenses grow more slowly than revenue (2.5%/yr versus 3%/yr) because fixed costs like payroll and G&A do not scale linearly with rent, while the management fee - the one variable line - rises with EGI. The result: NOI grows 41.9% over the hold, and DSCR on the original, unchanged loan balance climbs from 1.52x to 2.16x, since debt service is fixed but income is not. That widening coverage cushion is the real underwriting case for a value-add deal - not just the exit valuation.

Live example: Multifamily Residential Model in Excel

Loading...

Step 7: Underwrite the Exit and the Returns

The final step converts the Year 1-5 NOI path into the cash flows that determine whether the deal actually clears your return hurdle: cash-on-cash return each year, the resale value at exit, and the resulting IRR and equity multiple across the whole hold.

Year-by-Year Levered Cash Flow

With NOI ramping from $1,135,089 to $1,610,818 and debt service fixed at $744,625 (interest-only), the property's operating cash flow to equity grows every year of the hold:

Year NOI Debt Service Levered Cash Flow
1 $1,135,089 ($744,625) $390,464
2 $1,254,021 ($744,625) $509,396
3 $1,372,954 ($744,625) $628,329
4 $1,491,886 ($744,625) $747,261
5 $1,610,818 ($744,625) $866,193

Year 1 cash-on-cash return - operating cash flow divided by total equity invested - comes in at 4.4%, which is deliberately modest: this is the underwriting case for a heavy value-add deal, where the return builds over the hold rather than showing up on day one.

Exit Valuation

At the end of Year 5, value the property using the stabilized NOI and a resale cap rate. Assume modest cap rate compression from the 6.1% going-in cap to a 5.85% exit cap, reflecting the improved, renovated asset quality:

// Exit value
= NOI_Year5 / Exit_Cap_Rate

// Net proceeds to equity
= (Exit_Value * (1 - Selling_Cost_Pct)) - Outstanding_Loan_Balance
Metric Value
Year 5 NOI $1,610,818
Exit Cap Rate 5.85%
Gross Exit Value $27,535,350
Less: Selling Costs (2%) ($550,707)
Net Sale Proceeds $26,984,643
Less: Loan Payoff (interest-only, unchanged) ($12,950,000)
Net Proceeds to Equity at Sale $14,034,643

Sponsor Returns

Add the sale proceeds to the Year 5 operating cash flow, and compare total distributions against the $8,850,000 of total equity invested ($5,550,000 down payment plus $3,300,000 renovation capex):

// IRR across the full hold period
= XIRR(Cash_Flow_Range, Date_Range)

// Equity multiple (MOIC)
= Total_Distributions / Total_Equity_Invested
Metric Value
Total Equity Invested $8,850,000
Total Cash Distributed (Years 1-5, incl. sale) $17,176,286
5-Year Levered IRR 15.3%
Equity Multiple (MOIC) 1.94x

A 15.3% IRR and 1.94x equity multiple sit squarely in the range most sponsors target for a middle-market, value-add multifamily deal (typically 12-18% IRR and 1.5-2.5x over a 5-year hold). Note how sensitive both figures are to the exit cap rate assumption: model the exit at the same 6.1% cap rate you paid, with zero compression, and the exit value - and therefore the IRR - drops meaningfully. Never underwrite cap rate compression as a given; treat it as the upside case and stress-test the deal at a flat or even wider exit cap.


Common Mistakes When Underwriting a Multifamily Acquisition

  1. Using the broker's pro forma NOI instead of the actual trailing NOI. Offering memoranda routinely show a "Year 1 pro forma" that already assumes renovated units at market rent - rebuild NOI from the real, current rent roll and treat the broker's number as a target, not a starting point.
  2. Underestimating vacancy and credit loss. A seller's trailing 12-month vacancy can be flattered by recent concessions or a temporary leasing push. Cross-check against the submarket average.
  3. Ignoring capital reserves. Deducting only operating expenses from EGI and forgetting an ongoing capital reserve (routinely $250-$400/unit/year even outside a renovation program) overstates the cash flow available to equity.
  4. Assuming cap rate compression at exit. Underwriting the exit at a lower cap rate than you paid is the single most common way sponsors inflate projected IRR. Model a flat or wider exit cap as your base case.
  5. Sizing debt off pro forma NOI instead of in-place NOI. Lenders (and disciplined sponsors) size the loan against the trailing, in-place NOI - not the stabilized number you hope to achieve after renovation.
  6. Overestimating renovation rent premiums. A 10-25% premium on renovated units is realistic in most submarkets; underwriting 30%+ premiums without strong comparable evidence is how value-add deals miss their pro forma.
  7. Treating DSCR as a one-time test. DSCR should be checked every year of the hold, not just at closing - a deal that clears the covenant on Year 1 in-place NOI but would fail it on a downside vacancy scenario carries real refinancing risk.

Alex Tapio, founder of Finamodel and ex-Deloitte financial modelling expert

Alex Tapio

Founder of Finamodel • Professional Financial Modeller • Ex-Deloitte

alextapio.comx.com/alextapioLinkedIncontact [at] finamodel.com

Frequently asked

A real estate pro forma is the mechanical build from gross rent down to net operating income and levered cash flow - the income statement for the property. Underwriting a multifamily acquisition uses that pro forma as one input among several: it also sizes the debt and tests DSCR, models a value-add capital plan and the resulting rent growth, and underwrites an exit valuation and sponsor-level returns (cash-on-cash, IRR, equity multiple). The pro forma answers 'what does this property earn?' Underwriting answers 'should I buy it, at this price, with this financing?'

Most agency (Fannie Mae/Freddie Mac) and bank lenders require a minimum DSCR of 1.20x-1.25x on stabilized NOI for permanent multifamily financing. Bridge lenders financing a heavier value-add renovation plan will sometimes accept 1.00x-1.15x on in-place, pre-renovation NOI, betting that the property will grow into a healthier coverage ratio as rents are pushed to market. Whatever the minimum, lenders size the loan amount to the number that produces that DSCR - not necessarily the LTV you asked for.

It depends heavily on market and asset class, but a going-in cap rate in the 5.5%-7% range on in-place (pre-renovation) NOI is typical for a Class B value-add deal in a healthy secondary market as of 2026. A lower in-place cap rate is not necessarily bad - it can reflect strong submarket fundamentals - but it does mean the deal relies more heavily on the value-add plan and exit cap rate compression to hit target returns, rather than day-one cash flow.

Light-to-moderate interior renovations (flooring, countertops, fixtures, appliances, paint) typically run $8,000-$15,000 per unit. A more comprehensive program that includes kitchen and bathroom reconfiguration, in-unit washer/dryers, and common-area amenity upgrades can run $18,000-$30,000+ per unit. Budget conservatively, include a 10-15% contingency, and validate the resulting rent premium against actual comparable renovated units in the submarket rather than the contractor's or seller's projections.

Use all three, because each measures something different. Cash-on-cash return shows near-term income yield and matters most to investors who need current distributions. IRR captures the time value of money across the full hold and is the standard metric for comparing deals with different hold periods. Equity multiple (MOIC) shows the simple multiple of capital returned, ignoring timing, and is a useful gut-check against IRR (a high IRR with a low multiple often means a very short hold, which can carry its own risks). A well-underwritten value-add deal typically shows a modest Year 1 cash-on-cash return alongside a strong multi-year IRR and equity multiple - that pattern is normal, not a red flag.

Exit cap rate assumptions. Because terminal value is calculated by dividing a future NOI by an assumed cap rate, a small change in that assumption swings the exit value - and the resulting IRR - dramatically. Sponsors who assume aggressive cap rate compression (buying at one cap and underwriting an exit 50-100 basis points lower) are effectively underwriting a market bet on top of the operational value-add thesis. The safer practice is to underwrite the exit at the same cap rate you paid, or wider, and treat any compression as upside rather than the base case.

Have more financial modelling questions? Contact us

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview