Sensitivity Analysis and Stress Testing Syndication Models

Every syndication model contains dozens of assumptions, but a handful drive the majority of return variance. The five most impactful assumptions are: (1) exit cap rate (a 50 basis point change can swing returns by 300-500 basis points of IRR), (2) rent growth rate (cumulative over 5 years, each 1% change compounds), (3) vacancy rate (each 1% of physical vacancy reduces NOI by 2-3%), (4) renovation cost and timeline, and (5) interest rate at refinance or exit financing. Sophisticated investors rerun the model with adverse assumptions for each variable independently (sensitivity) and simultaneously (stress test).

A sensitivity analysis varies one assumption at a time while holding others constant. The standard approach creates a matrix with the two most impactful variables on each axis. For a multifamily syndication, the most common sensitivity matrix uses exit cap rate (columns) and rent growth (rows). Each cell shows the projected IRR under that combination. The sponsor's base case should be in the middle of the matrix, with realistic downside scenarios surrounding it. If the downside corner of the matrix produces an IRR below the preferred return (8%), the deal has meaningful risk of underperformance.

Stress tests combine multiple adverse assumptions simultaneously to model plausible worst-case outcomes. A standard stress test includes: (1) Moderate stress—exit cap rate 75 basis points above base, rent growth 1% below base, vacancy 2% above base, renovation costs 15% above budget. (2) Severe stress—exit cap rate 150 basis points above base, rent growth replaced by 0%, vacancy doubles, renovation costs 25% over budget, and hold period extends 2 years. Under moderate stress, a well-structured deal should still return investor capital with a modest positive return. Under severe stress, the question becomes whether investors face a total loss or merely a reduced return.