One of the most overlooked tabs in an underwriting model is also one of the most important – the sensitivity analysis.
Most investors flip straight to IRR and equity multiple. I understand why. Those are the headline numbers. They are easy to compare across deals. They are what get highlighted in the investment offering decks.
But as a former commercial lender who managed a $1B+ credit portfolio, I was trained to ask a different question:
What breaks first?
A proper sensitivity analysis answers that question. It shows you how fragile – or how durable – the deal really is.
Below are the key variables I focus on and why they matter far more than many of the other KPIs investors obsess over.
1. Debt Service Coverage (DSC) – The First Line of Defense
If there is one metric that deserves your attention under stress, it is DSC.
DSC tells you whether the property generates enough net operating income to cover debt service. Once DSC drops to 1.0x, the property is generating just enough cash to pay the mortgage. Below 1.0x, it is not.
That is when problems start.
In your sensitivity tab, you should not only look at the base case DSC. You should look at:
- At what percentage decline in revenue does DSC fall to 1.0x?
- At what percentage increase in operating expenses does DSC fall to 1.0x?
- If the rate is floating, at what interest rate does DSC fall to 1.0x?
This is your margin of safety.
For example:
- If a 5% revenue decline pushes DSC to 0.98x, that deal has very little cushion.
- If revenue can decline 15% before DSC hits 1.0x, that is a more durable capital structure.
As a lender, I always stress-tested to the point of discomfort. As an investor, I do the same. I want to know how much pain the property can absorb before it stops paying its mortgage.
IRR does not tell you that. DSC under stress does.
2. Rent Sensitivity – When Does the Story Break?
Rent growth is often the quiet hero of the pro forma. A 3% annual increase may not look aggressive on paper, but compounded over five years, it drives meaningful value.
The question is not whether rent grows. The question is:
What happens if it does not?
In your sensitivity analysis, test:
- Flat rents.
- A 5% rent decline.
- A 10% rent decline.
At what point does:
- DSC fall below 1.0x?
- Cash flow turn negative?
- Returns compress to unattractive levels?
- IRR turn negative?
You may be surprised how often a deal that looks solid at a 17% IRR becomes mediocre – or worse – with only modest rent pressure.
This is especially important in value-add deals where the thesis relies on rent lifts. If the renovation premium does not materialize, does the deal still survive? Or does the capital stack become strained?
Rent sensitivity exposes whether the business plan is resilient or simply optimistic.
3. Exit Cap Rate – The Silent Value Driver
Few variables impact projected returns more than the exit cap rate.
A 25 basis point change can materially move IRR. A 200 basis point increase can decimate it.
In your model, do not stop at a modest expansion. Test:
- 25 bps compression.
- 25 bps expansion.
- 50 bps expansion.
- 100 bps expansion.
- Up to 200 bps expansion from baseline.
Then ask:
- At what exit cap do returns fall below your target threshold?
- At what exit cap does equity multiple drop below 1.0x?
- At what point do you barely return investor capital?
You may find that a deal showing a 17% IRR at a 5.75% exit cap becomes a 10% IRR at 6.25% – and barely clears your hurdle at 7%.
Cap rates are influenced by interest rates, capital markets liquidity, and investor sentiment – all factors outside the operator’s control.
If your returns only work in a favorable exit environment, you are betting on capital markets, not operations.
4. Stabilization Period – Time Is Risk
Value-add deals typically assume a stabilization period of 12 to 24 months. But what happens if lease-up takes longer?
In your sensitivity analysis, extend stabilization by:
- 6 months.
- 12 months.
Then evaluate:
- Impact on cash flow.
- Impact on DSC.
- Impact on refi assumptions.
- Impact on IRR.
Delays compress returns and can strain reserves. If break-even occupancy sits between 70 and 75%, that gives you breathing room. If it sits at 85%, you are walking a tightrope.
Time risk is real. Your model should show you how much of it you can afford.
5. Returns – Why IRR Alone Is Not Enough
Let me illustrate the danger of focusing only on IRR.
| Scenario | IRR | Equity Multiple | Min DSC |
| Base Case | 18% | 2.3x | 1.30x |
| Rent -5% | 14% | 1.9x | 1.05x |
| Exit Cap +100 bps | 13% | 1.8x | 1.28x |
| Rent -10% | 9% | 1.4x | 0.95x |
Notice something important.
The IRR still looks “acceptable” at 14%. But DSC is barely above 1.0x. At a 10% rent decline, DSC drops below 1.0x. That means operational strain, potential capital calls, or loan default risk.
Returns tell you upside.
Sensitivity analysis tells you survival.
What I Personally Look For
When reviewing a deal, I focus on:
- How much revenue can decline before DSC hits 1.0x?
- Is break-even occupancy below 75%?
- How sensitive are returns to 100–200 bps exit cap expansion?
- Does the deal cash flow from Day 1?
- Are reserves sufficient to withstand extended stabilization?
If the deal only works in a narrow band of assumptions, I get cautious.
My philosophy has always been simple:
Protect the downside first. Growth is optional. Survival is not.
Final Thought
A sensitivity analysis is not a formality. It is not a box to check.
It is where you discover whether the deal is built on fundamentals or favorable assumptions.
IRR can be engineered.
Resilience cannot.
If you train yourself to focus on DSC under stress, rent durability, exit cap exposure, and stabilization risk, you will see opportunities differently. You will ask better questions. And most importantly, you will avoid deals that look good on paper but crack under pressure.
That is how you invest with discipline – and with a lender’s lens.
Vessi Kapoulian
Breaking down multifamily underwriting one step at a time to create educated and empowered investors