Multifamily Investing Guide

How to Analyze a Multifamily Deal

Every multifamily acquisition decision comes down to five numbers: NOI, cap rate, DSCR, cash-on-cash return, and IRR. This guide explains what each metric means, how to calculate it, what thresholds to look for, and how they work together to tell you whether a deal is worth pursuing.

In this guide

  1. Net Operating Income (NOI)
  2. Cap Rate
  3. Debt Service Coverage Ratio (DSCR)
  4. Cash-on-Cash Return
  5. Internal Rate of Return (IRR)
  6. Sensitivity Analysis
  7. Putting It All Together

1. Net Operating Income (NOI)

NOI is the foundation of every other metric. It tells you how much money the property generates after operating expenses but before debt service (mortgage payments).

Gross Potential Rent (GPR)
− Vacancy Loss (GPR × vacancy rate)
+ Other Income (laundry, parking, fees)
= Effective Gross Income (EGI)
− Operating Expenses
= Net Operating Income (NOI)
Example: A 20-unit building with average rent of $1,200/unit/month has GPR of $288,000/year. At 7% vacancy, vacancy loss is $20,160. Other income (laundry + late fees) is $8,400. EGI = $276,240. Operating expenses total $138,000. NOI = $138,240.

What to watch for

Expense ratio: Operating expenses as a percentage of EGI. For multifamily, 40-50% is typical. Below 35% may mean the seller is underreporting expenses (or self-managing and not accounting for management cost). Above 55% suggests operational issues or deferred maintenance.

Pro forma vs actual: Brokers often present "pro forma" NOI that assumes lower vacancy, higher rents, or reduced expenses. Always underwrite based on trailing 12-month (T12) actuals, not pro forma projections.

Management fee: Even if the current owner self-manages, include a management fee (typically 5-8% of EGI) in your underwriting. You might self-manage today, but your model should reflect the cost of professional management.

2. Cap Rate

The capitalization rate measures the property's unlevered yield — what you'd earn if you paid all cash. It's the most common metric used to compare deals and to estimate property value.

Cap Rate = NOI / Purchase Price
Example: NOI of $138,240 on a $2,100,000 purchase price = 6.58% cap rate.

What's a good cap rate?

It depends entirely on the market and asset class. Cap rates compress (go lower) in high-demand markets and for newer, stabilized properties. They expand (go higher) for older properties, secondary markets, and value-add opportunities.

A cap rate significantly above market average is a signal to investigate, not celebrate. There's usually a reason the market is pricing the property cheaply.

3. Debt Service Coverage Ratio (DSCR)

DSCR tells you how comfortably the property's income covers its mortgage payments. It's the metric lenders care about most, and it's the one that tells you whether you'll sleep well at night.

DSCR = NOI / Annual Debt Service
Example: NOI of $138,240. Loan: $1,575,000 (75% LTV) at 6.5% over 30 years = $119,556/year debt service. DSCR = 1.16.

What DSCR means in practice

DSCR is sensitive to interest rates. The same property at 5.5% vs 7.0% can swing from a comfortable 1.35 to a tight 1.10. Always stress-test at higher rates.

4. Cash-on-Cash Return

Cash-on-cash measures the annual return on the actual cash you invest — your down payment plus closing costs. Unlike cap rate, it accounts for leverage.

Cash-on-Cash = (NOI − Annual Debt Service) / Total Cash Invested
Example: NOI of $138,240 minus $119,556 debt service = $18,684 annual cash flow. Total cash invested: $525,000 (down payment) + $35,000 (closing costs) = $560,000. Cash-on-cash = 3.34%.

What to target

Cash-on-cash is a year-one metric. It doesn't account for principal paydown, appreciation, or rent growth over time. That's what IRR is for.

5. Internal Rate of Return (IRR)

IRR is the most comprehensive return metric. It accounts for the time value of money across the entire hold period: your initial investment, annual cash flows, and the eventual sale proceeds.

IRR = the discount rate that makes the NPV of all cash flows equal to zero

You can't calculate IRR with a simple formula — it requires iteration (or a financial calculator). The inputs are:

Example: Invest $560,000. Annual cash flow starts at $18,684 and grows 3% per year. Sell after 5 years at a 6.5% exit cap. After paying off the remaining loan and 2% selling costs, net sale proceeds are $620,000. 5-year IRR: approximately 14.2%.

What to target

IRR is sensitive to assumptions about rent growth, exit cap rate, and hold period. A deal that shows 18% IRR with 5% annual rent growth might show 11% with 2% growth. Always check the assumptions behind the number.


6. Sensitivity Analysis: Stress-Testing Your Deal

No set of assumptions is perfectly accurate. Vacancy could be higher than expected. Rents could grow slower. Interest rates could change. Sensitivity analysis shows you what happens to your returns when key assumptions shift.

Vacancy sensitivity

Run your model at multiple vacancy rates: 3%, 5%, 8%, 12%, 15%. At what vacancy rate does the deal stop cash-flowing? This is your break-even occupancy — one of the most important numbers in any underwriting. If break-even occupancy is 92% and the market average is 94%, you have a 2% cushion. If break-even is 97%, you're one bad quarter away from negative cash flow.

Rent growth sensitivity

What happens if rents don't grow at 3% per year? Run the model at -5%, 0%, +2%, +3%, +5%, and +10%. This is especially important for your IRR calculation, since IRR compounds over the hold period and is highly sensitive to growth assumptions.

Interest rate sensitivity

If you're using floating-rate debt or plan to refinance, model the deal at your expected rate, +50bps, +100bps, and +200bps. The deal that works at 6% might not work at 7.5%.

Key question: What is the worst realistic scenario, and can you survive it? A deal that works at base-case assumptions but breaks at 10% vacancy isn't as strong as one that still cash-flows at 15% vacancy.

7. Putting It All Together

No single metric tells the whole story. Here's how experienced multifamily investors typically use these metrics together:

Quick screening (30 seconds per deal)

Look at cap rate and price per unit first. If the cap rate is below your minimum threshold for the market, or the price per unit is above comparable sales, move on. Don't waste time underwriting a deal that fails the basic smell test.

Initial underwriting (5-15 minutes)

Calculate NOI from the T12 or OM financials. Apply your own vacancy and expense assumptions (not the broker's). Calculate DSCR at current financing terms. If DSCR is below 1.20, the deal probably doesn't work with conventional debt.

Deep dive (1-2 hours)

Build the full model with cash-on-cash, IRR projections, and sensitivity tables. This is where you model the value-add business plan: what happens to returns if you renovate units and raise rents by $150/month? What if only 60% of units turn over in year one instead of 80%?

Decision framework

A deal typically gets a "go" when it hits all of these:

Skip the spreadsheet

If you have an offering memo, T12, or rent roll, you can run this entire analysis in about 2 minutes. Dealyze reads the PDF, extracts all the financial data, and calculates every metric covered in this guide — NOI, cap rate, DSCR, cash-on-cash, IRR, sensitivity tables, and a Go/Caution/No-Go verdict.

Try your first analysis free — no account required, no credit card.


Multifamily Deal Analysis Checklist

Use this as a quick reference when screening deals:

  1. Get the documents: Request the OM, trailing 12-month P&L (T12), and current rent roll from the broker.
  2. Calculate NOI: Use T12 actuals, not pro forma. Include a management fee even if the owner self-manages. Include capex reserves ($250-500/unit/year).
  3. Check the cap rate: Compare to recent comparable sales in the submarket. If it's significantly above market, find out why.
  4. Calculate DSCR: Use realistic financing terms (current agency rates, 75% LTV, 30-year amortization). Target 1.25+ minimum.
  5. Calculate cash-on-cash: Include all cash required (down payment, closing costs, immediate repairs). Target 6%+ for stabilized deals.
  6. Project IRR: Use conservative rent growth (2-3%). Model a realistic exit cap (same or slightly higher than going-in cap). Target 12%+ on a 5-year hold.
  7. Run sensitivity analysis: Test vacancy at 5%, 8%, 12%, and 15%. Find break-even occupancy. Test rent growth at 0% and -5%.
  8. Make the call: Does the deal pencil under conservative assumptions? Is there a margin of safety? Does it still work if two things go wrong?

Analyze Your Next Deal in 2 Minutes

Upload any offering memo, T12, or rent roll. Dealyze extracts the data and runs the full underwriting model — NOI, cap rate, DSCR, cash-on-cash, IRR, sensitivity analysis, and a Go/No-Go verdict.

Try Free Analysis See Demo Report