Sensitivity Analysis: How One Assumption Can Change Everything
FAM Capital | Investor Education Series
In the previous articles, we covered stress-testing (what happens when things go wrong) and the difference between conservative and aggressive underwriting (how the assumptions are set). This article takes those concepts one step further and introduces a tool that shows you something neither of those exercises reveals on their own: which assumptions matter most.
That’s what sensitivity analysis is. It’s the process of changing one assumption at a time and watching how the deal’s returns respond. Some assumptions have a massive impact when changed by a small amount. Others barely move the needle. Knowing which is which tells you where the real risk lives in the deal and where to focus your due diligence.
Not all assumptions are equally important. A 1% change in the exit cap rate can swing the projected IRR by several percentage points. A 20% increase in renovation costs can eliminate the entire value-add premium. A 12-month delay in the timeline can compress the IRR significantly even if the total dollars returned stay the same. Sensitivity analysis isolates each of these variables so you can see which ones drive the deal and which ones are secondary.
The Concept in Plain Terms
Imagine a deal with a projected 15% IRR over five years. That 15% is based on a specific set of assumptions: a certain rent level, a certain vacancy rate, a certain expense load, a certain renovation budget and timeline, and a certain exit price. Each of those assumptions contributes to the 15%.
Now change one assumption. Keep everything else exactly the same and adjust just one variable. What happens to the 15%?
If you increase the renovation budget by 15% and the IRR drops from 15% to 11%, that tells you the deal is highly sensitive to renovation costs. A relatively small overrun produces a meaningful decline in returns.
If you increase the vacancy rate by 3 percentage points and the IRR drops from 15% to 14.2%, that tells you vacancy is a factor but not the primary driver. The deal can absorb some vacancy increase without a dramatic impact.
By testing each assumption individually, you build a map of what matters most. The assumptions that produce the largest swings in returns are the ones that carry the most risk, and those are the assumptions that deserve the most scrutiny in your due diligence.
That’s sensitivity analysis. Change one thing. See what moves. Identify what matters.
The Assumptions That Typically Matter Most
Every deal is different, and the relative importance of each assumption depends on the property type, the strategy, and the market. But there are patterns. Certain assumptions tend to have an outsized impact across most real estate deals, and knowing what they are helps you focus your analysis.
- Renovation Cost and Timeline: For value-add deals, renovation cost and timeline are typically the assumptions with the biggest impact on returns, and they’re the ones that deviate from plan most frequently. These two variables directly affect the value-add execution because they determine how much you spend to create the income increase and how long it takes to realize that increase.
- Exit Cap Rate: The exit cap rate determines the sale price of the property, which is typically where the largest portion of an investor’s total return is generated.
- Rent Growth Rate: Rent growth compounds over the hold period, which means small differences in the annual growth rate produce increasingly large differences in revenue as the years pass.
- Vacancy Rate: Vacancy directly reduces revenue and is one of the more volatile assumptions in any pro forma.
- Interest Rate: If the deal uses fixed-rate debt, interest rate sensitivity is limited to the refinance scenario if one is planned.
Test what happens if the renovation costs 15% more than budgeted. What happens if it takes 12 months longer? What happens if both occur simultaneously? The answers tell you how resilient the deal is to the most common and most impactful deviation from plan.
How to Think About the Results
Once you’ve identified which assumptions the deal is most sensitive to, you have actionable intelligence for your investment decision.
- If the deal is most sensitive to an assumption you can control, that’s a more manageable risk. Renovation cost and timeline, for example, are influenced by the sponsor’s planning, contractor selection, and project management.
- If the deal is most sensitive to an assumption you cannot control, that’s a less manageable risk. Exit cap rate, interest rates, and market-wide rent growth are driven by forces outside anyone’s control.
The best deals are sensitive to controllable factors and resilient to uncontrollable ones. When the assumptions you can influence have the biggest impact and the assumptions you can’t influence have a smaller impact, the deal’s outcome is more closely tied to execution quality than to market luck. That’s the kind of risk profile that rewards competent sponsors and protects investors from forces beyond anyone’s control.
Asking the Sponsor for Sensitivity Analysis
You don’t have to build the sensitivity analysis yourself, though doing it with a basic spreadsheet is not difficult. What you should do is ask the sponsor to show you theirs.
A well-prepared sponsor will have already run sensitivity analysis on the key variables: renovation cost, timeline, rents, vacancy, expenses, exit cap rate, and interest rates at refinance. They should be able to tell you which assumptions the deal is most sensitive to and how the returns change under different scenarios.
Ask them to walk you through it. What happens to the IRR if renovation costs increase by 15%? What happens if the timeline extends by a year? What’s the IRR at a 50-basis-point higher exit cap? What if rent growth is flat? These are simple questions, and a sponsor who has done their homework can answer them without hesitation.
If the sponsor hasn’t done sensitivity analysis, that tells you something about their underwriting process. It doesn’t mean the deal is bad. But it means the sponsor hasn’t fully explored how the deal behaves under different conditions, which means they may not fully understand their own deal’s risk profile. A sponsor who can’t tell you what breaks the deal hasn’t asked the question, and that should concern you.
Sensitivity Analysis vs. Stress-Testing: How They Work Together
Sensitivity analysis and stress-testing are related but different exercises, and both are valuable.
- Sensitivity analysis changes one variable at a time to isolate its impact. It tells you which assumptions matter most and where the deal is most vulnerable to a single deviation.
- Stress-testing changes multiple variables simultaneously to simulate real-world scenarios. It tells you whether the deal can survive a bad stretch where several things go wrong at once.
Together, they give you a complete risk picture. Sensitivity analysis tells you where to look. Stress-testing tells you how bad it can get. A deal that is most sensitive to controllable variables (renovation cost and timeline) and survives reasonable multi-factor stress tests (vacancy up, rents flat, expenses higher, timeline extended) is a deal with a well-understood risk profile and genuine margin for error.
Making It Practical
You don’t need to be a financial analyst to apply sensitivity thinking to your investment decisions. Here’s a simple, practical approach you can use on any deal.
- First, identify the three or four assumptions that you think are most uncertain or most impactful.
- Second, for each of those assumptions, ask yourself: how confident am I that this assumption will hold?
- Third, combine the sensitivity with the probability.
- Fourth, use your findings to ask better questions.
The Bottom Line
Sensitivity analysis shows you which assumptions matter most. Not all assumptions are equally important, and understanding which ones drive the deal’s returns tells you where the real risk lives and where to focus your attention.
For value-add deals, renovation cost and timeline are typically the most impactful variables because they directly affect the execution of the business plan. Exit cap rate is consistently one of the most powerful single assumptions in any deal because small changes in the cap rate produce large changes in the sale price. Rent growth compounds over time. Vacancy can shift quickly. Each variable matters, but some matter much more than others.
Ask the sponsor for their sensitivity analysis. A well-prepared sponsor has already identified the deal’s pressure points and can walk you through how the returns change under different assumptions. If they can’t, that’s a gap in their underwriting process that should make you cautious.
The best deals are the ones where the assumptions you can control have the biggest impact and the assumptions you can’t control have the smallest. That means the outcome is driven by execution quality, not by market luck. And execution quality is exactly what you’re evaluating when you vet the sponsor.
