A multifamily deal can look great in the broker email and still fall apart once you pressure-test the numbers. A rent roll may be inflated, expenses may be understated, or the exit may depend on a cap rate assumption that only works in a perfect market. If you want to know how to analyze a multifamily deal with real confidence, you need a process that moves from raw information to a clear buy, retrade, or pass decision.
That process does not need to feel institutional or overly complex. It does need to be consistent. The goal is not to build the prettiest model. The goal is to understand what drives value, where the deal can break, and whether the projected return matches the risk.
Start with the right question
Most underwriting mistakes happen before the spreadsheet gets interesting. People start by asking, “What return does this deal show?” A better opening question is, “What has to be true for this deal to work?”
That shift matters because multifamily underwriting is really an assumptions business. The purchase price is visible. The future is not. Your job is to test the assumptions around income, expenses, financing, and exit value, then decide whether those assumptions are realistic for this asset in this market.
Before you model anything, gather the basic inputs: trailing 12-month operating statement, current rent roll, offering memorandum, unit mix, occupancy history, tax information, debt terms if available, and any planned renovation scope. If one of those items is missing, that is not a reason to stop. It is a reason to mark uncertainty and underwrite more conservatively.
How to analyze a multifamily deal from the top down
A practical multifamily analysis starts with the property as it exists today, then moves to where you think it can realistically go. In other words, underwrite in two layers: in-place performance and stabilized performance.
In-place performance tells you what the asset is doing now. Stabilized performance tells you what it could do after operational cleanup, lease trade-outs, renovations, or occupancy normalization. Mixing those two views too early is where people end up overpaying.
If the property is 92 percent occupied but the seller is marketing it on a 95 percent stabilized basis with lower expenses and higher rents, separate those stories. One is fact. One is a business plan.
Underwrite the current income first
Start with gross potential rent based on the actual rent roll, not pro forma market rent. Compare in-place rents by unit type against market comps and recent leases. If the seller is claiming a large mark-to-market opportunity, ask whether that rent growth is supported by finishes, location, amenities, and tenant profile.
Then look beyond base rent. Multifamily income often includes parking, pet fees, RUBS, laundry, storage, application fees, and other charges. Some of these are durable. Some are not. A good rule is to underwrite ancillary income only if there is clear historical support or a credible operational plan.
Vacancy and credit loss deserve more thought than a standard plug. A newer Class A property in a strong submarket may justify a tighter vacancy assumption than an older workforce asset with more tenant turnover. If current occupancy is temporarily high, do not assume it will stay there forever. If current occupancy is low, determine whether the problem is operational, physical, or market-driven.
The result of this section is effective gross income, and that number needs to reflect what the property can actually collect, not what the marketing package hopes it will collect.
Get serious about expenses
Expense underwriting is where many multifamily deals go wrong. Newer analysts often accept seller expenses too quickly, especially when they are trying to make debt coverage or return metrics work.
Start with the trailing 12 months and adjust line by line. Property taxes often reset after sale, so the historical number may be unusable. Insurance has also become more volatile, particularly in weather-exposed markets. Payroll, repairs and maintenance, utilities, admin, contract services, and management fees all need review against both history and market norms.
Some operators like to underwrite expenses on a per-unit basis. Others prefer a percentage of effective gross income. In practice, both are useful. Per-unit helps compare against similar assets. Percentage of income helps catch situations where expenses appear unrealistically low relative to the revenue base.
Be especially cautious with value-add deals. Renovation plans often increase downtime, turn costs, marketing costs, and labor intensity before they produce higher rents. If the business plan assumes fast unit upgrades with limited disruption, test a slower pace too.
Once you have effective gross income minus operating expenses, you reach net operating income. NOI is the engine of multifamily valuation, but it is only as reliable as the assumptions underneath it.
Value the deal using realistic cap rates
One of the fastest ways to misread a deal is to focus only on the going-in cap rate. It is useful, but not enough.
Look at the purchase price relative to in-place NOI and stabilized NOI. If the going-in cap is thin, the deal may still work if there is credible upside. If the stabilized yield looks attractive but depends on aggressive rent growth, low vacancy, and compressed exit pricing, the story gets weaker.
Your exit cap rate should usually be at least as conservative as the market cap rate you are using today, and often higher. A common mistake is underwriting strong income growth and a favorable sale environment at the same time. That double optimism can make almost any deal look good on paper.
The better approach is simple: if the market softens, can the deal still produce an acceptable outcome? That is where real conviction comes from.
How to analyze a multifamily deal with debt in mind
A multifamily deal is not just a real estate decision. It is also a financing decision. The debt structure can improve returns, but it can also erase margin for error.
Underwrite the loan using realistic terms for interest rate, amortization, loan-to-value, reserves, and fees. Then calculate debt service coverage and debt yield, not just cash-on-cash return. A deal that shows strong levered returns with weak DSCR is more fragile than it first appears.
If the financing is floating rate, stress it. If there is an interest-only period, ask what happens after amortization begins. If the business plan depends on a refinance in year two or three, do not assume the capital markets will cooperate on schedule.
This is especially important for smaller operators and brokers advising clients. Deals do not fail only because the asset underperforms. They also fail because the debt was too tight for the execution risk.
Build returns from operations, not from hope
Once income, expenses, valuation, and debt are in place, model the cash flow over your hold period. Focus on the return metrics that actually help you make a decision: cash-on-cash return, internal rate of return, equity multiple, and average debt coverage.
But do not stop at the headline outputs. Look at what is driving them. Is the return mostly coming from year-one cash flow, operational improvement, or sale proceeds? A deal that only works because of a strong terminal value is usually more sensitive than one supported by durable in-place cash flow.
This is where scenario analysis earns its keep. Run a base case, a downside case, and an upside case. The downside case does not need to be dramatic. Slightly lower rent growth, higher expenses, a slower lease-up, and a softer exit cap can tell you a lot. If returns collapse under a modest stress, the deal may be priced too tightly.
At Underwriting 4 All, this is the point where speed and clarity matter most. A faster model is helpful, but only if it helps you see the pressure points sooner.
Know what can kill the deal
Strong multifamily underwriting is not about proving a deal works. It is about identifying what could break it.
Sometimes the issue is operational. Maybe bad debt is elevated, tenant turnover is high, or payroll is too thin for the asset size. Sometimes it is physical, such as deferred maintenance, aging roofs, plumbing risk, or unit interiors that need more capital than the budget shows. Sometimes it is strategic. A Class B asset may be underwritten like a light value-add deal when it really needs a heavier repositioning.
You do not need perfect certainty to move forward. You need a clear view of the main risks and whether the pricing compensates you for taking them.
The decision is the real output
A good underwriting model should help you make one of three decisions quickly: pursue, pursue at a different price, or pass. If your analysis ends with a stack of outputs but no clear judgment, the process is incomplete.
That is the real answer to how to analyze a multifamily deal. Build from current reality, separate facts from business plan assumptions, pressure-test income and expenses, respect the debt, and stress the exit. When your process is disciplined, you do not need every deal to be perfect. You just need to know which ones deserve your time and capital.
The best underwriters are not the ones who can make every deal pencil. They are the ones who can spot the weak assumption before it becomes an expensive lesson.