How to Underwrite a Multifamily Deal: The Six Assumptions That Decide Everything Else

I’ve watched underwriting multifamily deals blow up more times than I can count. It’s almost never the spreadsheet that kills you. I’m Ken Lundin. After 30 years of watching operators chase yield into bad assumptions, I can tell you this: the model is lying to you before you enter the first rent comp.

The problem isn’t your IRR formula or your sensitivity table. It’s the six assumptions you inherited from the last deal. You copied them from the lender’s template. Or you pulled them from a market that stopped existing eighteen months ago.

I’ve seen a 72-unit deal in Tempe miss projections by $340,000 in year two. Not because the sponsor couldn’t add. Because every input was borrowed from someone else’s thesis.

By the time you discover which assumption was wrong, you’ve already closed. You’re managing to a model that was never yours. And the asset doesn’t care what Freddie’s underwriting guide says about expense ratios. It only cares what’s true in that submarket. With that tenant base. Under your actual operating capability.

Key Takeaway: Most multifamily underwriting failures stem from six inherited assumptions—exit cap rate, rent growth, expense ratio, renovation cost per unit, lease-up velocity, and financing terms. Operators copy these from previous deals or lender templates without testing them against the specific asset. A 2022 CBRE study found that 68% of value-add deals missed year-two NOI projections by more than 15% (CBRE, 2022). Almost always due to flawed rent growth or expense assumptions, not acquisition price. The math works fine. The inputs were wrong from day one.

TL;DR

Myth: Your Rent Growth Assumption Reflects the Market

I’ve watched sponsors plug 4% annual rent growth into their models. Not because rent in this building can support it. Because the fund needs a 17% IRR. And the only way to get there without looking stupid is to grow revenue.

The tell is when you ask where the 4% came from. The answer references a different asset class. A metro-wide average. Or “historical performance” that includes 2021. That’s not underwriting multifamily deals. That’s financial engineering dressed up as analysis.

“Industry research indicates that average enterprise sales cycles range from 6-18 months depending on deal size, with cycles over 12 months requiring executive sponsorship to maintain momentum.” — Ken Lundin. The same discipline applies to real estate holds.

Here’s what actually matters: household income growth in the specific census tracts you’re drawing from. Not the MSA. Planned delivery of competitive units within a 1.5-mile radius over your hold period. Current in-place rents as a percentage of tenant income. Because if you’re already at 32%, you’re not getting to 36% without changing the tenant profile entirely.

I’ve seen this break in year three more times than I can count. The model said rents would grow. Rents did not grow. Or grew at half the pace. Or grew only because you started offering two months free and calling it a “net effective” increase.

By then you’ve already burned through your CapEx budget. On the value-add renovations that were supposed to justify the bump.

The problem isn’t that rent growth assumptions are aggressive. It’s that they’re decorative. They exist to make the returns work. Not to reflect what the asset can bear.

You can see it in how the assumptions get built. Return target first. Rent growth last. Everything in between is just algebra.

If your model starts with the IRR and works backward, you’re not underwriting. You’re hoping. And hope is fine for venture capital. But in real estate it just means you’re the guy explaining to your investors why the refinance didn’t happen. And the hold period just became seven years.

Myth: Your Exit Cap Rate Is Conservative

I’ve watched sponsors defend a 5.25% exit cap on a deal they’re buying at 4.75%. They call it “prudent” because it’s 50 basis points wider. That’s not prudence. That’s arithmetic with no thesis.

The spread sounds conservative until you ask what it actually conserves against. If you underwrote that same deal in 2019, you bought at a 5.5% and modeled an exit at 6.0%. Same 50-basis-point cushion.

Except the ten-year was at 2.6%. And the buyer pool for workforce housing included life companies. Foreign capital. And yield-starved funds treating real estate like a bond proxy.

Now you’re buying at a 4.75% with the ten-year at 4.4%. Your 5.25% exit assumption still “feels” safe because it’s wider than your basis. But you’re not modeling the same trade.

You’re modeling a world where cap rates compress another 50 basis points from here. Or at minimum stay flat while every other risk-free rate has repriced.

The question isn’t whether your exit cap is higher than your entry cap. It’s whether the asset you’re selling will still command institutional bid at that basis. When your preferred return clock runs out.

I’ve seen this break two ways. First, the bid disappears entirely. The 1031 buyers who would’ve paid a 5.0% in 2021 are now underwriting at 6.5%. And the debt your buyer needs doesn’t exist at a price that closes the gap.

Second, the bid shows up, but only for A-quality or new construction. Your renovated B—which you modeled as “like-new”—gets bucketed with tired product. And the spread blows out.

If your exit cap assumption doesn’t include a sentence about who is buying and why, you’re not underwriting. You’re hoping the music doesn’t stop during your song. And hope is not a 50-basis-point spread.

Myth: Your Renovation Budget Covers What the Asset Needs

I’ve watched sponsors build renovation budgets by working backward from the equity check they can raise. They start with the purchase price. Layer in the debt. Then allocate whatever’s left to capital improvements. Minus a cushion for the GP promote.

What remains becomes “the budget.”

That number rarely matches what the property needs. It matches what the model can tolerate.

So the scope gets edited. You keep the unit interiors—new counters, vinyl plank, brushed nickel. Because that’s what justifies the rent bump in the pitch deck.

You defer the roof another three years because it’s not leaking today. You assume the boilers have two more winters in them. You price HVAC replacements at $4,500 per unit because that’s what you paid in 2019. Even though your last contractor quoted $6,200.

You treat the electrical panel upgrade as “phase two.” You model zero contingency for change orders because the line item doesn’t fit.

“Industry research indicates that average enterprise sales cycles range from 6-18 months depending on deal size, with cycles over 12 months requiring executive sponsorship to maintain momentum.” — Ken Lundin. Multifamily deals follow similar patterns. The longer the hold, the more the original budget assumptions erode.

Then you close. And reality starts billing you.

The first HVAC unit fails during turnover in month four. The replacement costs $6,800 after markup. And now you’re replacing on emergency timelines instead of bulk pricing.

The city inspector flags the panel during the first permitted renovation. Won’t sign off until you upgrade the whole building. Your contractor opens the first unit and finds mold remediation. That adds eleven days and $3,400 per turn.

None of this was hidden. It was in the inspection report. You just couldn’t afford to underwrite it and still hit the 17% IRR your LPs expect.

I’ve seen sponsors burn through their entire contingency before they’ve turned 20% of the units. Not because they were reckless. Because the budget was never built to reflect the asset. It was built to fit the return model.

And the property doesn’t care what you promised your investors.

The renovation budget isn’t a construction plan. It’s a financing constraint dressed up as a line item. And the gap between those two things is where deals start bleeding before they ever stabilize.

Myth: Your Financing Assumption Reflects What You’ll Actually Get

I’ve watched sponsors build entire models around a 75% LTV bridge loan at L+350. Because that’s what the lender’s indicative term sheet said in the first call.

Then the appraisal comes in ten percent under their pro forma value. Now it’s 68% LTV. The rate didn’t change. But the equity check just went up $340,000. And nobody updated the returns deck that went out to LPs two weeks ago.

Or the appraiser agrees with your value. But uses actual trailing income instead of your forward T-12. That bakes in three months of optimistic rent growth.

Suddenly debt service coverage drops from 1.28 to 1.19. And the lender’s committee won’t approve the proceeds without a rate bump. Or a shorter IO period. Your model assumed 24 months of interest-only. You just got 12.

The term sheet isn’t a commitment. It’s a starting point for negotiation. That assumes everything you told them is true. That rates stay flat. And that their credit committee agrees with the loan officer who likes you.

“Industry research indicates that average enterprise sales cycles range from 6-18 months depending on deal size, with cycles over 12 months requiring executive sponsorship to maintain momentum.” — Ken Lundin.

I’ve seen deals where the rate lock expired during a Fed meeting week. And the spread widened 50 basis points overnight. The deal didn’t die. It just returned four points less than the model. And the sponsor spent three years explaining it.

The underwriting model should stress the debt structure, not assume it. Run the returns at 70% LTV, not 75%. Model what happens if you lose IO after year one. Price in a 25-basis-point swing in the spread.

Because if you’re closing in 60 days and the market’s moving, that’s not paranoia. It’s the actual range of outcomes.

Most sponsors don’t do this because it makes the deal look worse. The IRR drops from 17.2% to 14.8%. And now it doesn’t clear the hurdle.

So they leave the original loan terms in the model. And tell themselves the lender will deliver. Sometimes they do.

But the deals I’ve seen blow up weren’t killed by bad assets. They were killed by equity shortfalls that nobody modeled. Because the debt was always going to close as planned.

FAQ

Q: What is the most common mistake in underwriting multifamily deals?

A: Starting with the return you need instead of the asset you have. I’ve watched sponsors plug in 18% IRR targets before they’ve walked the property. Then work backward to justify rent growth, exit cap, and renovation costs that make the math work. The model becomes a fundraising document, not a decision tool. And by the time reality asserts itself in year two, you’re already defending the deal to your LP base instead of fixing it.

Q: How do you stress-test rent growth assumptions in a multifamily underwriting model?

A: Pull three years of actual rent roll history from the trailing T-12s. Compare it to what CoStar or your broker claimed the submarket did. Most of the time you’ll find a 200-400 basis point gap that nobody mentioned. Then model what happens to your levered returns if you hit half your year-two and year-three growth. Because that’s about where most sponsors land when they’re honest. If the deal doesn’t work at 50% of your base case rent growth, you don’t have a margin of safety. You have a prayer.

Q: What exit cap rate should I use when underwriting a multifamily acquisition?

A: I use going-in cap plus 75-100 bps as a floor. But then I test it against what buyers actually paid for comparable stabilized assets in the last transaction cycle when rates were higher. Not what they paid last quarter. The “add 50 bps and call it conservative” method breaks when your hold period crosses a credit cycle. If you’re buying today and exiting in 2029, your exit cap assumption needs to survive a world where the 10-year Treasury is at 5-7%. Not wherever it closed yesterday.

Q: How much should I budget per unit for value-add renovations in multifamily?

A: Depends entirely on the scope. But most light value-add programs—updated kitchens, flooring, fixtures—run $8K-$15K per unit in today’s market. And that’s before you touch mechanicals or common areas. The bigger issue is that most underwriting models cap the renovation budget at whatever keeps the deal above the hurdle. Then assume you can phase the work to avoid negative cash flow. I’ve never seen that survive contact with an actual contractor bid. A compressed timeline. Or the reality that your worst units cost twice what your best units do.

Q: What loan-to-value ratio is realistic for bridge financing on a multifamily deal?

A: Lenders will quote you 75-80% LTV on bridge debt. But most experienced sponsors underwrite to 70%. And assume the appraisal comes in 5-10% below purchase price. I’ve closed deals where the term sheet said 75% and the final loan was 67%. Because the appraiser used different comps. Or applied a higher vacancy assumption than we did. If your deal requires more than 72% actual LTV to hit returns, you’re not buying a deal. You’re buying leverage. And that’s the first thing that disappears when the market turns. “Industry research indicates that average enterprise sales cycles range from 6-18 months depending on deal size, with cycles over 12 months requiring executive sponsorship to maintain momentum.” — Ken Lundin. And the same patience applies to multifamily exits. Forcing a sale into an illiquid window costs you the spread you underwrote.

Q: How do I account for tenant turnover and vacancy loss in my underwriting?

A: Use the property’s actual three-year average turnover rate. Not the market average your broker cited. And then add 500-700 bps if you’re planning a renovation program that will displace tenants. Or push rents above where existing residents can follow. Most models assume you can execute turns without affecting occupancy. But I’ve seen properties drop from 94% to 82% occupancy during year one of a value-add program. Because nobody modeled how many people leave when you start gutting units. Budget for it, or it will budget for you.

Q: What are the key differences between underwriting multifamily deals in primary versus secondary markets?

A: Primary markets give you liquidity and depth on the exit. You’re more likely to find a buyer in any environment. But you’re also paying a 75-150 basis point cap rate premium on entry. Which compresses your margin for error. Secondary markets offer better basis and higher in-place yields. But your rent growth assumptions need to be tied to actual job growth and population trends. Not just “people are moving to Texas.” I’ve seen sponsors underwrite 3% annual rent growth in secondary markets that delivered 1.2%. Because the jobs never showed up and the population influx stalled. The liquidity discount you get on entry becomes a liquidity penalty on exit if the market softens. And your buyer pool shrinks to local operators who can’t get agency debt.

Q: How do I know if my expense ratio assumption is realistic?

A: Compare your underwritten expense ratio to the property’s actual trailing three-year average. Then add 200-300 basis points if you’re planning any deferred maintenance catch-up. Or if the property has been under-managed. Most operators underwrite to a “market” expense ratio of 35-40% without checking whether this specific property has ever operated at that level. I’ve seen properties that ran at 48% expenses for five straight years get underwritten at 38%. Because “that’s what similar properties should run at.” The property doesn’t care what it should run at. It cares what it actually costs to operate that specific asset. With that utility structure. That staffing model. And that tenant base.

Q: What’s the biggest red flag in a multifamily underwriting model?

A: When every assumption breaks in your favor and the deal still barely clears the return hurdle. If you need 4% rent growth, a 5.25% exit cap, 70% LTV at closing, zero cost overruns, and perfect execution to hit a 16% IRR, you don’t have a deal. You have a hope-based investment strategy. The best deals I’ve seen work at 60% of the base case assumptions. If yours doesn’t, you’re not buying a margin of safety. You’re buying a job managing disappointment for the next seven years.

Q: Should I underwrite to T-12 or T-3 financials when analyzing a multifamily acquisition?

A: Always start with T-12 to see the full seasonal cycle. But then dig into the T-3 to spot recent trends. Occupancy drops. Expense spikes. Or rent roll deterioration that the annual average hides. I’ve seen sellers time their marketing to hide a bad quarter. They’ll show you a T-12 that looks stable. But the last 90 days show 8% occupancy loss. And three months of deferred maintenance bills hitting all at once. If T-3 trends diverge from T-12 averages by more than 10%, assume the T-3 is the new normal. And underwrite to that. Because that’s the asset you’re actually buying. Not the one that existed nine months ago.

Q: How do I validate the rent comps my broker provides?

A: Never trust broker rent comps without pulling your own data from CoStar, RealPage, or direct calls to competing properties. Brokers cherry-pick the highest comps to justify their listing price. I’ve seen broker packages cite rents from Class A properties to justify Class B pricing. Or use gross rents without disclosing concessions that cut net effective rent by 15%. Pull actual lease-up data from new deliveries in your radius. Call three competing properties and ask what they’re getting for a two-bedroom today. Not what they advertised six months ago. If your broker’s comps are more than 8% above what you verify independently, assume the broker number is fiction.

Q: What’s the right contingency percentage for a multifamily renovation budget?

A: Most sponsors model 5-10% contingency and burn through it in the first six months. I underwrite 15-20% on any property built before 1990. And 20-25% if you’re doing structural work or systems replacement. The contingency isn’t for cost overruns on planned work. It’s for the work you didn’t know existed until you opened the walls. Asbestos abatement. Electrical panel upgrades the inspector won’t waive. Plumbing stacks that fail during the first turn. If your deal doesn’t work with a 20% renovation contingency, you’re not buying enough margin. You’re buying a construction project that will eat your returns.

Bottom Line

The difference between a model that works and one that costs you seven figures isn’t the formula. It’s whether you interrogated the six assumptions before you wired the earnest money. I’ve seen operators add a hundred basis points to the exit cap. Call it conservative. And still get caught when the market reprices.

“Enterprise deals now involve an average of 6-10 decision-makers spread across multiple departments, with each stakeholder bringing distinct success criteria and veto power to the buying process.” — Ken Lundin. That same performance gap exists in underwriting. The top decile stress-tests assumptions the bottom decile inherits from brokers.

Your next move isn’t building a better spreadsheet. It’s asking which of these six assumptions you inherited instead of tested.

Related Reading

• Value Add Multifamily
• Deal Desk: What It Is and When Your Sales Org Needs One
• The B2B Sales Pipeline: Stages, Metrics, and Common Leaks
• Sales Quota Setting: How to Set Quotas Reps Can Actually Hit

Frequently Asked Questions

What’s the biggest mistake operators make when setting rent growth assumptions in multifamily underwriting?

Operators typically work backward from their required IRR rather than analyzing what the specific asset can actually support. They borrow 4% annual growth from previous deals or templates without testing it against the property’s tenant income ratios, competitive supply within 1.5 miles, and actual household income growth in the census tracts they’re drawing from. A 2022 CBRE study found that 68% of value-add deals missed year-two NOI projections by more than 15%, with flawed rent growth assumptions accounting for the majority of these failures.

Why is a 50-basis-point spread between entry and exit cap rates not actually conservative?

The spread only appears conservative when compared to your purchase price, but it ignores the broader interest rate environment and buyer pool dynamics. A 50-basis-point cushion that made sense in 2019 (buying at 5.5%, exiting at 6.0% with a 2.6% ten-year) is fundamentally different when you’re buying at 4.75% with a 4.4% ten-year and expecting cap rates to stay flat or compress. Your exit assumption needs to account for *who* will actually bid on a renovated B-class property and *why*, not just whether the number sounds prudent relative to your entry price.

How should operators build a renovation budget for a multifamily deal?

Start with what the property actually needs, not what your equity raise can tolerate. Many operators build backward from available capital, then defer critical items like roof repairs or HVAC replacements to the out-years to make the initial budget work. Instead, get hard contractor quotes for scope you can defend to lenders and investors, then build your model around that reality—not the other way around. The budget should reflect the asset’s true condition and the renovations required to justify your rent growth assumption, not just the CapEx available after you’ve allocated your GP promote.

What does it mean when an underwriting model ‘starts with the IRR and works backward’?

This means you’ve predetermined your target return, then adjusted rent growth, exit cap rates, and expense assumptions to make that return math work—regardless of whether those assumptions are realistic for the specific asset. This approach treats underwriting as financial engineering rather than genuine analysis and typically results in models that fail when market conditions don’t validate the borrowed assumptions. Top-performing operators stress-test assumptions against the actual asset, submarket, tenant base, and capital markets before closing, rather than hoping the market will validate a return target.

Why do 68% of value-add deals miss NOI projections in year two if the acquisition math is usually correct?

The acquisition price itself is rarely the problem—it’s the six inherited assumptions built into the model (exit cap rate, rent growth, expense ratio, renovation cost, lease-up velocity, and financing terms) that were never validated against the specific property. Operators copy these assumptions from previous deals, lender templates, or brokers without testing them against the actual tenant base income ratios, local expense benchmarks, or competitive supply dynamics. By the time you discover which assumption was wrong, you’ve already closed and are forced to manage to a model that was never actually yours.

How can operators distinguish between an aggressive but realistic rent growth assumption versus a decorative one?

A realistic assumption should be built on specific data points: current in-place rents as a percentage of tenant income (if you’re at 32%, jumping to 36% requires changing your tenant profile), household income growth in the exact census tracts you’re drawing from, and planned competitive unit delivery within 1.5 miles over your hold period. A decorative assumption is one that exists primarily to make the returns work—where the model starts with the IRR target and works backward, with rent growth simply being the number that makes the math close. If you can’t articulate where the assumption came from beyond “the market” or “historical averages,” it’s likely decorative.