A deal can look compelling in the base case and still fail the moment reality is slightly less cooperative. That is why knowing how to stress test a real estate deal matters as much as knowing how to calculate cap rate, debt service, or IRR. A stress test tells you whether the property has room for ordinary underwriting error, market softness, or an unexpected operating problem.
For multifamily investors and brokers, the goal is not to predict the future perfectly. It is to identify the assumptions that can break the deal, measure the downside, and decide whether the return still justifies the risk. A useful stress test turns a polished pro forma into a decision tool.
Start With a Clean Base Case
Stress testing cannot fix an unsupported base case. Before changing assumptions, make sure your original underwriting reflects the property, the market, and the business plan as they exist today.
Your base case should clearly show in-place operations, projected rent growth, vacancy, concessions, other income, operating expenses, capital expenditures, financing terms, and exit assumptions. Separate actual trailing performance from your forward projections. If the deal only works because of aggressive future assumptions, the stress test may expose that quickly.
For example, if a 120-unit property is currently operating at 91% economic occupancy but your model assumes 96% within six months, write down why. Is there proven rental demand? Are comparable properties achieving that occupancy? Does the renovation scope support the rent premium? Stress testing works best when every major assumption has a reason behind it.
Identify the Assumptions That Actually Move Returns
Not every input deserves equal attention. Focus first on variables that materially affect net operating income, debt coverage, equity returns, or the sale price. In most multifamily deals, those variables are rent growth, vacancy, operating expenses, interest rates, renovation execution, and exit cap rate.
A small change in a low-dollar administrative expense may not change the investment decision. A $75 monthly rent miss across 100 renovated units will. Likewise, a 50-basis-point increase in exit cap rate can erase a meaningful portion of projected sale proceeds, especially when the holding period is short.
The most useful question is not, “What could go wrong?” Everything can go wrong. Ask, “What could go wrong that would materially change my ability to service debt, preserve equity, or hit the required return?”
Test Revenue Before You Trust It
Revenue assumptions often contain the most optimism in an acquisition model. Test them from several angles rather than applying one broad haircut to effective gross income.
Reduce Rent Growth and Rent Premiums
If your model assumes market rents grow 3% annually, test 1% growth, flat rents, and a modest decline. For a value-add deal, also test what happens if renovated units achieve only 75% to 90% of the expected premium.
This is particularly important when the renovation premium is carrying the investment thesis. A property may still lease renovated units, but it may take longer to reach target rents or require more concessions than planned. Model both outcomes.
Increase Economic Vacancy
Physical occupancy is not the same as economic occupancy. A building can appear full while concessions, bad debt, loss-to-lease, and delinquency reduce collected revenue.
Instead of assuming stabilized vacancy remains at 5%, run scenarios at 7%, 9%, and 11%. In a lease-up or renovation-heavy strategy, test a slower absorption period as well. If turns take longer, units sit vacant longer, and renovation costs arrive before rent growth does.
Challenge Other Income
Other income can be meaningful, but it should not become a hidden source of optimism. Review whether fees, utility reimbursements, parking, pet rent, storage, or furnished-unit income are proven and collectible. Stress test the categories that are new, inconsistent, or dependent on management changes.
Model Expenses as a Real Operating Risk
Expense growth is one of the easiest assumptions to underestimate. Insurance, payroll, repairs and maintenance, utilities, property taxes, and contract services can move faster than general inflation.
Do not apply one standard expense-growth rate to every line item. Property taxes may reset after a sale. Insurance may rise sharply based on location, claims history, replacement cost, or carrier availability. Payroll can increase because of wage pressure, staffing needs, or a management change.
A practical approach is to build an expense stress case that increases controllable expenses by 5% to 10% above the base case, while applying more specific pressure to taxes and insurance. If your base model assumes 3% annual expense growth, test what happens at 5% or 6%, then evaluate the impact on NOI and debt service coverage ratio.
Also distinguish between operating expenses and capital needs. Replacing roofs, HVAC systems, parking lots, plumbing components, or unit interiors may not hit NOI directly, but these costs reduce distributable cash flow and can require additional equity. A deal with thin reserves is more fragile than its operating statement suggests.
Stress the Debt Structure, Not Just the Property
A property can perform reasonably well and still create a difficult equity outcome because of its financing. Your stress test should show debt service coverage ratio, debt yield, breakeven occupancy, and cash flow after debt service under each scenario.
For floating-rate debt, model higher benchmark rates, wider spreads, and the expiration or cost of the interest-rate cap. If the loan matures before your planned sale, test a refinance at higher rates and a lower loan-to-value ratio. The question is whether the property can refinance without requiring a new equity contribution.
For fixed-rate debt, the immediate payment may be stable, but refinance risk still matters. A loan with a short term or a large balloon payment can become a problem if NOI misses the plan or cap rates expand before maturity.
A simple but valuable test is to calculate breakeven occupancy. This measures the occupancy required to cover operating expenses and debt service. If the deal needs 94% economic occupancy just to meet debt service, it has little room for normal operating volatility. A lower breakeven point generally gives the ownership group more flexibility.
Underwrite a Tougher Exit
Exit value is often the largest single contributor to projected equity returns. It deserves more skepticism than almost any other assumption.
Start by testing an exit cap rate at least 25 to 50 basis points higher than your base case. In uncertain debt markets, a 75- to 100-basis-point expansion scenario may be appropriate. The right range depends on asset quality, location, holding period, financing conditions, and whether your going-in cap rate already reflects a premium valuation.
Then test lower exit NOI. If the business plan is delayed, the buyer may value the property on a lower income level than your model assumes. Combining a higher exit cap rate with lower exit NOI is often more revealing than testing either assumption alone.
Do not assume you will sell at the same cap rate you used to buy unless the property is materially improved and the market evidence supports it. A lower cap rate at exit is possible, but it should be treated as upside, not a requirement for the deal to work.
Build Scenarios, Then Combine Them
One-variable sensitivity tables are helpful, but real markets rarely deliver one problem at a time. Rent growth may slow while insurance rises and exit cap rates expand. The most valuable stress tests combine related risks.
Use three or four clear cases: a base case, a moderate downside case, a severe-but-plausible downside case, and an upside case if it helps frame the opportunity. A moderate downside might include slower rent growth, 2% higher expenses, 100 basis points more economic vacancy, and a 50-basis-point higher exit cap rate. A severe case may include flat rents, meaningful vacancy pressure, expense growth above plan, delayed renovations, and tighter refinance proceeds.
Keep the scenarios understandable. A decision-maker should be able to see which inputs changed and why, without hunting through dozens of tabs. This is where a disciplined underwriting template or process can save time and prevent a sensitivity exercise from becoming a spreadsheet maze.
Decide What the Stress Test Is Telling You
A stress test is not a pass-fail exercise based only on whether IRR remains attractive. Look at the full picture: Does debt service remain covered? Does the investment need additional capital? How much equity value is lost? Is the hold period forced to extend? Can the sponsor still execute the business plan?
Some deals will show weaker returns in a downside case and still be acceptable because the asset has durable cash flow, conservative leverage, and a strong basis. Others may show that a minor rent miss produces negative cash flow, a refinance gap, or little remaining equity. Those are not equivalent risks.
If the downside case breaks the deal, you have options. Lower the purchase price, negotiate better financing, reduce leverage, increase reserves, revise the renovation scope, or walk away. The purpose of underwriting is not to make every deal work. It is to make the decision clear enough that you can protect your capital and communicate the risk with confidence.
A well-stress-tested deal may not be exciting on every line of the pro forma. It should, however, give you a credible answer when a lender, partner, or client asks the question that matters most: what happens if the plan does not go exactly as expected?
Leave a Reply