Sensitivity Analysis for Syndication Deals: Stress-Testing Your Underwriting

The Five Variables That Drive Syndication Returns

In most multifamily syndication deals, five variables account for 90% or more of the variance in investor returns. In order of impact: (1) exit cap rate — determines disposition value and drives the majority of total return, (2) rent growth rate — compounds over the hold period and drives NOI trajectory, (3) vacancy and occupancy — directly affects revenue and cash flow available for distribution, (4) interest rate on debt — determines debt service burden and cash available for equity, (5) operating expense growth — the silent return killer that erodes NOI over time. A comprehensive sensitivity analysis varies each of these independently and in combination to map the full range of potential outcomes.

Single-Variable Sensitivity Tables

The simplest form of sensitivity analysis holds all variables constant except one and shows how returns change across a range of values. For example: "If exit cap rate ranges from 5.0% to 7.0% in 25-basis-point increments, here is the resulting IRR and equity multiple for each scenario." Single-variable tables are useful for showing which assumptions matter most and how sensitive the deal is to each individual input. Best practice is to create single-variable sensitivity tables for all five key variables, clearly showing the base case assumption and the range of outcomes. This gives LPs and lenders a quick read on the deal's risk profile.

Two-Variable Sensitivity Matrices

More powerful than single-variable analysis is the two-variable sensitivity matrix, which shows how returns change when two assumptions vary simultaneously. The most common combinations are exit cap rate vs. rent growth rate (the two largest return drivers) and vacancy rate vs. expense growth (the two largest cash flow drivers). A 2D matrix with exit cap rate on one axis and rent growth on the other shows the investor exactly how these variables interact. This is the format institutional LPs expect to see in an investment memo, and it is the analysis that lender credit committees review when approving financing.

Scenario-Based Stress Testing

Beyond mechanical sensitivity tables, scenario analysis creates coherent narratives about potential market conditions and tests the deal against each narrative. A "recession scenario" might combine higher vacancy (8% vs. 5% base), lower rent growth (1% vs. 3%), higher exit cap rate (6.5% vs. 5.5%), and slower renovation pace (30 months vs. 18 months). A "rate shock scenario" might model a 200-basis-point increase in floating rate debt with its downstream impact on DSCR, refinance economics, and disposition timing. Scenario analysis is more realistic than single-variable sensitivity because market conditions tend to move together — a recession does not cause higher vacancy without also affecting rent growth and cap rates.

What Lenders Actually Want to See

Lender underwriting committees evaluate sensitivity analysis differently than LP investors. Lenders focus on DSCR under stress: "At what rent growth rate does DSCR fall below 1.20x?" and "If vacancy increases by 300 basis points, does the property still cover debt service?" They also focus on LTV at exit: "If cap rates expand 75 basis points, does the property value still exceed the loan balance?" Your sensitivity analysis for lender presentations should center on debt coverage metrics and collateral value, not equity returns. Show the breakeven analysis: the specific assumption levels where DSCR hits covenant minimums and where LTV exceeds refinance thresholds.

Presenting Sensitivity Analysis to LPs

For LP investor presentations, sensitivity analysis serves a different purpose: it builds confidence that the GP has rigorously tested the deal and understands the risk-return profile. Lead with the base case, then immediately show the downside: "Even in our conservative scenario with 50bps cap rate expansion and 1% lower rent growth, the deal still produces a 1.6x equity multiple and 11% IRR." This framing — showing resilience under stress rather than hiding from risk — is what separates sponsors who consistently raise capital from those who struggle. LPs know every deal has risks. They invest with GPs who demonstrate they have mapped, measured, and planned for those risks.

Related Glossary Terms

Related Articles