Avoiding Bad Multifamily Deals: Multifamily underwriting guide with apartment building, calculator, and deal analysis tools

Multifamily Underwriting: The Proven Guide That Helps You Avoid Costly Mistakes


You found a deal. The seller says it’s a home run. The broker’s offering memorandum looks polished. Your gut says maybe.

But what do the numbers actually say?

That’s what multifamily underwriting is all about.

Whether you’re brand new to apartment investing or you’ve been studying deals from the sidelines — this guide is for you. We’re going to walk through multifamily underwriting step by step, in plain English, so you can look at a deal with real confidence instead of confusion.

At Think Multifamily, we’ve closed over $1 billion in apartment deals across 120+ transactions. We’ve seen deals that looked great on paper fall apart — and deals that scared others turn into serious wealth-builders. The difference? The underwriting.


What Is Multifamily Underwriting?

Multifamily underwriting is the process of analyzing an apartment deal to decide if it’s worth buying — and at what price.

Think of it like a financial checkup for a property. You’re looking at the income, the expenses, the debt, and the future value potential to answer one core question:

Does this deal make sense — and can it survive when things don’t go as planned?

Multifamily underwriting is not just about filling in a spreadsheet. It’s about stress-testing the assumptions behind the numbers so you know exactly what you’re getting into.

For a deeper look at the most common mistakes that quietly destroy deals, read our post: 5 Multifamily Underwriting Mistakes That Kill Deals.


Key Terms Every Investor Needs to Know

Before we walk through the process, let’s make sure you know the vocabulary. Multifamily underwriting has its own language, and getting these terms wrong can cost you money.

Gross Potential Rent (GPR)

GPR is the total rent you could collect if every unit was occupied and paying full market rate. It’s the ceiling — not what you’ll actually collect, but where the analysis begins.

GPR = Total Units × Market Rent Per Unit × 12 months

Example: A 50-unit building where each unit rents for $1,200/month has a GPR of $720,000 per year.

Vacancy and Credit Loss

No property stays 100% occupied forever. Vacancy is the percentage of units that sit empty at any given time. Credit loss accounts for tenants who don’t pay. In most multifamily underwriting models, a combined rate of 5–10% is used, depending on the market and property class.

Effective Gross Income (EGI)

EGI = GPR − Vacancy & Credit Loss + Other Income

EGI is your realistic projected income after accounting for empty units, non-payment, and any extra revenue streams.

Net Operating Income (NOI)

NOI = Effective Gross Income − Operating Expenses

NOI is the single most important number in multifamily underwriting. Value, financing qualification, and returns all flow from this one figure.

Cap Rate

Cap Rate = NOI ÷ Purchase Price

Cap rate is a quick way to compare deals. A 5% cap rate means the property earns 5% of its value in NOI each year. But cap rates cut both ways — if market cap rates rise after you buy, your property value drops even if income stays the same.

Debt Service Coverage Ratio (DSCR)

DSCR = NOI ÷ Annual Debt Service

Fannie Mae — one of the primary agency lenders for multifamily — requires a minimum 1.25x DSCR on conventional loans. This means the property must earn 20–25% more than it costs to service the debt. If DSCR drops below the lender’s threshold, you may trigger a covenant violation.

Cash-on-Cash Return (CoC)

CoC = Annual Cash Flow ÷ Total Cash Invested

Cash-on-cash return measures your actual annual return on the money you put into a deal — not the total property value. Most operators target 6–10% in year one for a stabilized deal. If you’re new to this metric and want a beginner-friendly breakdown of how it’s calculated with real examples, BiggerPockets has a straightforward guide to cash-on-cash return worth bookmarking.

Internal Rate of Return (IRR)

IRR is the annualized return on your full investment — including both ongoing cash flow and the profit when you eventually sell. It’s the number most experienced investors use to evaluate total deal performance.


How to Underwrite a Multifamily Deal: Step by Step

Here’s how multifamily underwriting works in practice — the same process we use at Think Multifamily on every acquisition.

Step 1: Analyze the Rent Roll

The rent roll is a document that lists every unit in the building, the current tenant, what they’re paying, and when their lease expires. It is the foundation of every multifamily underwriting analysis — and the first thing you should ask for.

Why Shouldn’t You Trust the Seller’s Pro Forma?

The pro forma is a projection the seller puts together to show what the property could earn. It is a marketing document — not a financial statement.

Pro formas are built to make deals look as attractive as possible. They often include:

  • Optimistic rent growth projections that haven’t been tested
  • Vacancy rates that are lower than what the property has actually experienced
  • Expense figures that are too low — sometimes missing insurance, management fees, or reserves entirely
  • Income projections based on what “comparable” properties charge — not what this property has actually collected

Your job in multifamily underwriting is to go behind the pro forma and verify every single assumption with real data. Start with the T-12 (Trailing 12-Month Operating Statement) — the actual income and expense history for the past year. That’s your ground truth.


How to Analyze the Rent Roll

Once you have access, here’s what to look for:

  • Current rents vs. market rents — Is the property collecting at, above, or below what comparable properties charge?
  • Lease expiration dates — A building where every lease expires in the same month is a risk. Staggered expirations give you more stability.
  • Month-to-month tenants — These can be transitioned faster but represent more turnover risk.
  • Delinquency patterns — Ask for a delinquency history. Chronic late-payers won’t show up on the rent roll but will show up in your cash flow.
  • Unit mix — How many 1-bed, 2-bed, 3-bed units? How does the mix affect your income ceiling?
  • Long-term below-market tenants — Some tenants may have lived there for years and pay well below market. Factor in the timeline and cost of transitioning those units.

How Do You Know If Current Rents Are Below Market?

This is one of the most important questions in multifamily underwriting — and one of the most commonly glossed over.

Here’s how to find out:

  • Call competing properties directly and ask what their current rents are (and what concessions they’re offering, like free first month)
  • Use Rentometer, Apartments.com, and Craigslist to see advertised rents in the area
  • Talk to a local property management company — they know the real numbers better than any broker
  • If you have access, use CoStar or Yardi Matrix for submarket rent data
  • Tour 3–5 competitor properties and compare unit finishes, amenities, and condition to yours

What Is Market Rent — and How Do You Estimate It?

Market rent is the going rate for units similar to yours — matched by location, size, age, unit condition, and amenities — in the current market.

To estimate market rent for your underwriting:

  1. Define your comp set: Look at 3–5 competing properties within 1–3 miles that are comparable in class and vintage.
  2. Verify net effective rent: Some properties advertise $1,400/month but offer one month free on a 12-month lease. That’s actually $1,283/month effective. Use the net effective rent in your underwriting, not the face rent.
  3. Adjust for your property’s condition: If your units are unrenovated and comps are renovated, you can’t charge the same rent. Build your value-add premium based on realistic renovation assumptions, not wishful ones.
  4. Use current data, not stale data: Markets shift. Rents that were achievable 12 months ago may not be achievable today. Always verify with current listings and recent lease data.

What Is Gross Potential Rent — and How Do You Calculate It?

Once you know market rent for each unit type, you can calculate your Gross Potential Rent (GPR).

GPR = (# of 1BR units × 1BR market rent) + (# of 2BR units × 2BR market rent) + … × 12 months

Example: You’re analyzing a 40-unit building with 20 one-bedroom units at $1,100/month market rent and 20 two-bedroom units at $1,350/month market rent.

GPR = (20 × $1,100 × 12) + (20 × $1,350 × 12) = $264,000 + $324,000 = $588,000

This is your income ceiling. Every other income figure in your multifamily underwriting model will be derived from here.


Timing of Planned Rent Increases — How to Work This Into Your Analysis

If you’re buying a value-add property with the plan to renovate units and push rents, timing matters enormously in your multifamily underwriting model.

Here’s how to think through it:

  • Renovation timeline: How long will it take to turn and renovate each unit? Be realistic — budget contractors, permits, and lead times. Add 25% buffer to whatever you think it will take.
  • Absorption period: After you renovate a unit, how long does it take to lease it up at the new rent? In most markets, budget 30–60 days per unit after renovation.
  • Phase your income projections: Your year one income won’t reflect full value-add rents. If you’re renovating 5 units per month on a 40-unit property, it takes 8 months just to complete renovations — and longer to reach stabilized occupancy.
  • Underwrite what you can actually achieve in year one, not what the property can theoretically earn when fully stabilized. Projecting stabilized rents in month three is how models break from reality.

What Is Other Income — and How Do You Calculate It?

Beyond base rent, most multifamily properties generate additional revenue streams. Don’t leave these out of your multifamily underwriting — but don’t inflate them either.

Common sources of other income include:

  • Pet fees: Pet rent ($25–$75/month per pet) and/or one-time pet deposits
  • Parking: Assigned or covered parking spaces charged separately
  • Laundry: Income from on-site laundry facilities (either owned machines or a vendor revenue share)
  • Storage: Rentable storage units
  • RUBS (Ratio Utility Billing System): If tenants pay for a portion of utilities, this becomes recoverable income
  • Late fees and application fees

How to calculate other income:

Other Income = (# of pets × monthly pet rent × 12) + parking income + laundry income + storage + RUBS

Verify other income against the T-12. If the seller’s pro forma shows $30,000/year in other income but the T-12 shows $8,000 — that’s a red flag worth digging into before you trust the projection.


Step 2: Calculate Effective Gross Income (EGI)

Once you have your GPR and other income, you subtract vacancy and credit loss to get your Effective Gross Income.

EGI = GPR − Vacancy & Credit Loss + Other Income

Pull the actual historical vacancy for the property (request 12–24 months of data) and cross-check it against market vacancy for the submarket. If the seller claims 95% occupancy, verify it on the rent roll — not just their word.

Use a realistic vacancy assumption — typically 5–10%. Don’t underwrite below 5% even in the tightest markets.


Step 3: Build Your Expense Budget

This is where most beginners get burned. Expenses in multifamily underwriting include:

  • Property Taxes — Research whether the sale price will trigger a reassessment in your state. In many markets, the county revalues the property at the purchase price, which can dramatically increase your tax bill in year one. Engage a tax consultant to help you.
  • Insurance — Always get your own quotes. Do not use the seller’s current insurance numbers. Insurance premiums have increased 200–600% in some markets in recent years. Get actual quotes before you commit to a price. Getting on a master insurance policy can help reduce your costs.
  • Property Management — Budget 4% of collected rents for a third-party manager on a 50+ unit.
  • Maintenance and Repairs — This is in addition to the employee costs.
  • Capital Expenditure Reserves — Lenders typically require $250 per unit per year, but for most properties you need to at least double this amount.
  • Utilities, Landscaping, Pest Control, and Administrative Costs

Typical operating expenses run 35–55% of EGI. If a seller’s expense ratio is below 35%, ask why.


Step 4: Calculate NOI and Determine Value

NOI = EGI − Operating Expenses

NOI is the heartbeat of every multifamily underwriting analysis. Now use it to check the seller’s asking price:

Value = NOI ÷ Cap Rate

If a property has an NOI of $500,000 and market cap rates are 5.5%, the market value is approximately $9,090,000. If the seller is asking $11M, either the NOI needs to grow substantially to justify that price — or the deal is overpriced.

Always underwrite your exit at a higher cap rate than your entry. If you buy at a 5% cap rate, you have no idea what the cap rate will really be in the future. However, you should assume it will be higher (meaning values are going down). Underwriting your exit at the same or lower cap than you bought is optimistic — and has destroyed deals when markets shifted.


Step 5: Model the Debt

Most multifamily deals are purchased with financing. Your multifamily underwriting model needs to account for:

  • Loan amount (typically 65–80% of purchase price depending on loan type and sponsor experience)
  • Interest rate — and whether it’s fixed or variable. Fixed is safer. Floating rate debt has destroyed deals when rates surged unexpectedly.
  • Loan term and amortization period
  • Annual debt service (principal + interest)
  • DSCR calculation to confirm the property qualifies for the loan

For a full breakdown of how debt structure can make or break a deal, see our blog: Why Multifamily Deals Fail — which covers bridge vs. long-term debt, rate caps, prepayment penalties, and DSCR covenants in depth.


Step 6: Project Returns Over the Hold Period

Build a 3–5 year projection. For each year, model:

  • Rent growth: 2–3% annually is a reasonable, conservative assumption in most markets, but you should model 0% in many markets
  • Expense growth: Budget 3–4% per year
  • Cash flow after debt service each year
  • Projected sale price at exit (stabilized NOI at sale year ÷ your conservative exit cap rate)
  • Total return: cash flow + net sale proceeds ÷ total equity invested

Run three scenarios: best case, base case, and worst case. If only the best case produces acceptable returns, the deal is too fragile.


The Quick Analysis: Your Back-of-the-Napkin Deal Filter

If you tried to run a full multifamily underwriting analysis on every deal that hit your inbox, you would burn out fast. Most experienced operators receive dozens of deals a month. Doing a complete deep-dive on all of them is impossible.

That’s where the Quick Analysis comes in. Also called the Quick and Dirty, or the back-of-the-napkin analysis, this is a simple 5-minute filter that tells you one thing: is this deal even worth my time to look at more closely?

If the numbers don’t work on a Quick Analysis using conservative rules of thumb, the full analysis is almost never going to save it. Move on. If the numbers do look interesting, that’s your signal to dig deeper.


The Rules of Thumb Behind the Quick Analysis

The Quick Analysis works because it uses proven rules of thumb that have been stress-tested across hundreds of multifamily deals. You don’t need exact figures — you need consistent, conservative assumptions.

Rule of ThumbWhat to Use
Expenses50% of total income (excluding debt service)
Economic Vacancy10-12% of GPR
Cap Rate Varies by market
Rehab (Class C)$5,000 per door
Loan Cost65% of purchase price
Closing Costs3-4% of sales price (includes rate caps if applicable)
Rent IncreasesTypically 2-3% per year
Expense IncreasesTypically 2-3% per year

About the 50% expense rule:  This is a rough estimate only — real expenses vary significantly by market, property age, and management quality. But as a quick filter, if a deal doesn’t pencil at 50%, it almost certainly won’t pencil when you get the real numbers either. Think of it as your conservative gate.


What Is Economic Vacancy — and Why Does It Matter?

Physical vacancy is simply units that are empty. But economic vacancy is broader — and more honest. It captures all the ways a property can fail to collect its full potential rent:

  • Physical vacancy — units sitting empty
  • Bad debt — tenants who are in the unit but not paying, or paying less than they owe
  • Concessions — incentives like one month free rent or waived fees that reduce what you actually collect
  • Loss to lease — units where a tenant is paying below current market rate
Economic vacancy diagram showing four components that reduce multifamily income: physical vacancy, bad debt, concessions, and loss to lease

Why does this matter for your Quick Analysis? Because a property can look 95% occupied and still have 12-15% economic vacancy when you factor in all four of these buckets. Use 10-12% as your Quick Analysis assumption. It’s conservative enough to catch problems before they become yours.


The Quick Analysis: Step-by-Step Formula

Here is the exact formula, using a real example: a 100-unit property where the average rent is $1,660/month and the seller reports $77,358/year in other income.

StepWhat You CalculateAmount (Example)
GPR100 units x $1,660/mo x 12$1,992,000
– Economic Vacancy (10%)GPR x 10%($199,200)
= Net Rental Income $1,792,800
+ Other IncomePet fees, parking, laundry, etc.$77,358
= Total Income (EGI) $1,870,158
– Expenses (50% of EGI)EGI x 50%($935,079)
= NOI $935,079
/ Cap RateDivide NOI by market cap rate8%
= Price Excl. RehabNOI / Cap Rate$11,688,488
– Rehab Budget$10,000/door x 55 units needing work($550,000)
= MAX PRICE TO PAYYour walk-away number$11,138,488

Key takeaway:  This analysis told us in under 5 minutes that the maximum we should pay — before committing a single hour to due diligence — is approximately $11.1M. If the seller is asking $14M, the deal is almost certainly not worth pursuing further at that price. If they’re asking $10.5M, it might be very interesting.


What Information Do You Need to Run a Quick Analysis?

The beauty of the Quick Analysis for multifamily underwriting is you only need a few numbers — most of which are available in the broker’s offering memorandum (OM) before you even request a showing:

  • Total number of units
  • Average current rent per unit (or total monthly rent roll)
  • Annual other income (if available — if not, use zero to be conservative)
  • Current market cap rate for that property class and submarket
  • Estimated rehab cost (use $10,000/door for Class C as a quick estimate; adjust based on property condition)

Quick Analysis vs. Full Underwriting: Know the Difference

The Quick Analysis is not a replacement for full multifamily underwriting. It is a screening tool. Never make an offer based solely on a Quick Analysis.

Here’s how to think about when to use each:

  • Quick Analysis: Use on every deal you receive, before you commit any significant time. Takes 5 minutes.
  • Full Multifamily Underwriting: Use only on deals that pass the Quick Analysis. This is where you pull the actual T-12, verify every expense line, build your projection model, and stress-test assumptions.

The Quick Analysis filters your deal flow down to the handful of opportunities that deserve your full attention. That discipline is what keeps operators from burning out — and from falling in love with deals that don’t deserve it.


Use the Smart Apartment Analyzer for Your Full Analysis

Once a deal passes your Quick Analysis, it’s time to run the real numbers. That’s where the Smart Apartment Analyzer comes in — the professional-grade underwriting tool we use at Think Multifamily, built to model real scenarios, stress-test assumptions, and show you what a deal actually looks like before you sign anything.

Access it at: https://thinkmultifamily.com/analyzer


How to Stress-Test Your Multifamily Underwriting

At Think Multifamily, we don’t just ask ‘will this deal make money?’ We ask ‘how much pain can this deal take before it breaks?’

Run your multifamily underwriting through these scenarios before you ever make an offer:

  • What if rents are flat for two years instead of growing?
  • What if expenses increase 20% in year one?
  • What if vacancy runs at 12% instead of 7%?
  • What if the interest rate is 200 basis points higher than projected?
  • What if you can’t sell for three more years?
  • What if the exit cap rate is 1% higher than you projected?

If the deal survives all of those scenarios with positive cash flow and a reasonable return — you probably have a solid deal. If any single scenario causes a loss, you need to renegotiate the price or walk away.


Common Questions About Multifamily Underwriting

How do I know if my assumptions are too aggressive?

Ask: what happens if my rent projections are wrong by 10%? What if expenses run 15% higher? What if I can’t exit at the cap rate I projected? If any one of those scenarios breaks the deal, your underwriting is too tight. A solid deal should handle some adversity.

What is analysis paralysis — and how do I avoid it?

Analysis paralysis is when you get so deep into the numbers that you never actually make a decision. It’s one of the biggest deal-killers we see at Think Multifamily — not because investors don’t know enough, but because they use underwriting as a reason to delay rather than a tool to decide.

The goal of multifamily underwriting is not perfection. No model is perfect. The goal is to make a confident, informed decision with the best available data. You stress-test the assumptions, you build in margin, and then you decide.

How many deals should I underwrite before making an offer?

As many as you can. Most experienced operators underwrite dozens of deals for every one they actually buy. The more deals you analyze, the sharper your instincts get for separating real opportunities from sellers’ wishful thinking.

What’s a good cash-on-cash return?

Most investors target 6–10% in year one for a stabilized deal. Value-add deals may show lower initial CoC returns while renovations are underway, but should grow significantly as rents increase. Always model conservative CoC so you’re not banking on everything going perfectly.


The Right Tool for Multifamily Underwriting

Running multifamily underwriting manually in a generic spreadsheet is slow, error-prone, and easy to manipulate. It’s tempting to fudge a number to ‘make the deal work’ — and that’s exactly how investors get into trouble.

That’s why we built the Smart Apartment Analyzer.

After 20+ years of deal analysis and $20,000+ in development, it’s the professional-grade underwriting tool we use on every acquisition at Think Multifamily. It’s built to:

  • Run real scenarios — not just best-case projections
  • Flag assumptions that are too aggressive before they become expensive mistakes
  • Model returns across multiple hold periods and exit scenarios
  • Account for the variables that generic calculators miss: tax reassessments, insurance volatility, lease-up timing, and debt structure

If you’re serious about multifamily underwriting, this is the tool built for it.

→ Access the Smart Apartment Analyzer: https://thinkmultifamily.com/analyzer


How to Get Started with Multifamily Underwriting Today

You don’t have to be a spreadsheet expert to start. You just have to start.

  • Learn the vocabulary. Read through the key terms section above until you can explain them to someone else without notes.
  • Get the right tool. Use the Smart Apartment Analyzer to run your first deal — even a hypothetical one. Just go through the process so it becomes familiar.
  • Find real listings and practice. Pull actual deals from LoopNet or work with a broker and practice underwriting them — with no pressure to buy. This is how you build speed and instincts.
  • Join a community or get a mentor. Learning multifamily underwriting in isolation is slow. Learning alongside experienced operators is fast.
  • Keep underwriting. Volume is the best teacher.

Ready to Learn Multifamily Underwriting the Right Way?

At Think Multifamily, we’ve spent over two decades teaching investors how to analyze apartment deals — not just theory, but the real-world skills that protect capital and build lasting wealth.

Here’s where to go next:


Similar Posts