Lesson 11.8: Sensitivity Analysis

1. Lesson Introduction

Real estate models rely on assumptions, and assumptions are never perfectly certain. Rent growth may come in lower than expected. Vacancy may last longer. Expenses may rise faster. Exit cap rates may widen. Because projected returns depend on these assumptions, investors need a disciplined way to test how fragile or resilient a model is.

Sensitivity analysis provides that discipline. Instead of treating one forecast as if it were guaranteed, sensitivity analysis asks how results change when one important assumption moves up or down. This helps investors identify which assumptions matter most and where a deal may be vulnerable to disappointment.

A strong investment is not just one that looks attractive in the base case. It is often one that still performs reasonably well when key assumptions weaken.

2. Learning Objectives

• Define sensitivity analysis and explain its purpose in real estate underwriting.
• Identify which assumptions are commonly tested in real estate models.
• Interpret how small changes in a single assumption affect value and returns.
• Recognize which variables often have the greatest impact on projected outcomes.
• Use sensitivity analysis to improve risk awareness and investment discipline.

3. Core Concepts

What Sensitivity Analysis Does

Sensitivity analysis measures how the output of a model changes when one input changes while other assumptions are held constant. In real estate, the outputs may include value, NOI, debt service coverage, cash-on-cash return, or IRR.

One Variable at a Time

The defining feature of sensitivity analysis is that it usually changes one assumption at a time. This allows the investor to isolate the effect of that single variable and understand which model inputs are most influential.

Common Variables to Test

In real estate underwriting, common sensitivity variables include rent growth, vacancy rate, expense growth, terminal cap rate, interest rate, loan proceeds, and sale timing. These assumptions often have meaningful effects on both annual cash flow and overall investment returns.

Base Case vs Sensitized Cases

Most models begin with a base case, which reflects the investor's central forecast. Sensitivity analysis then compares that base case to stronger or weaker versions of a single assumption. For example, rent growth may be tested at 2%, 3%, and 4%, or terminal cap rate may be tested at 5.5%, 6.0%, and 6.5%.

Fragility and Resilience

If a small change in one assumption causes a large change in investment returns, the deal may be fragile. If the investment still performs reasonably well across a range of assumptions, it may be more resilient. This distinction is critical in disciplined underwriting.

4. Mechanics

Step 1: Choose a Key Assumption

Start by selecting one assumption that is both uncertain and economically important. Common choices include rent growth, stabilized vacancy, terminal cap rate, or interest rate.

Step 2: Keep All Other Assumptions Constant

To isolate the effect of a single variable, do not change multiple assumptions at once. Hold the rest of the model constant so the results clearly reflect only the chosen input.

Step 3: Test a Reasonable Range

Create a set of cases above and below the base assumption. For example, if the base vacancy assumption is 5%, test 4%, 5%, and 6%. If the base terminal cap rate is 6.0%, test 5.5%, 6.0%, and 6.5%.

Step 4: Observe the Output

Recalculate the model for each case and record the resulting value, IRR, cash-on-cash return, or other metric. This shows how sensitive the investment is to that variable.

Step 5: Interpret What the Change Means

The goal is not merely to produce numbers. The goal is to understand risk. If a 50 basis point increase in terminal cap rate reduces IRR materially, that tells the investor something important about exit dependence. If small rent growth changes have little effect, the investment may be less exposed to that variable.

Simple Example Structure

A typical sensitivity table might look like this:

• Rent growth: 2%, 3%, 4%
• Projected IRR: 10.1%, 11.0%, 11.9%

Or:

• Terminal cap rate: 5.5%, 6.0%, 6.5%
• Projected sale value: $9.1M, $8.3M, $7.7M

5. Worked Example

Suppose an investor underwrites an apartment property with a base-case Year 5 terminal NOI of $480,000 and a base-case terminal cap rate of 6.0%.

Base Case

Estimated Sale Value = $480,000 ÷ 0.06 = $8,000,000

Sensitivity Test: Terminal Cap Rate

The investor tests what happens if the terminal cap rate changes by 50 basis points in either direction.

• 5.5% cap rate: $480,000 ÷ 0.055 = $8,727,273
• 6.0% cap rate: $480,000 ÷ 0.06 = $8,000,000
• 6.5% cap rate: $480,000 ÷ 0.065 = $7,384,615

Interpretation

A relatively small change in the terminal cap rate creates a large change in projected sale value. This tells the investor that the investment is highly sensitive to exit pricing assumptions. If projected returns depend heavily on a favorable sale environment, the model may deserve a more conservative interpretation.

6. Real Estate Application

Rent Growth Testing

Investors often test rent growth because even modest changes can compound over several years and affect both annual cash flow and terminal NOI. This is especially important in value-add or growth-oriented strategies.

Vacancy and Collections Testing

Sensitivity analysis can reveal whether a property remains healthy if occupancy weakens or collection loss rises. This is useful in markets where demand conditions are uncertain or tenant rollover is high.

Expense Growth Testing

Insurance, payroll, repairs, and taxes may rise faster than expected. Testing expense growth helps investors understand whether margins are strong enough to absorb cost pressure.

Financing and Exit Testing

Interest rate changes, debt terms, and terminal cap rates often have large effects on levered returns. Sensitivity analysis helps reveal whether returns come from durable operations or from aggressive financing and optimistic exit assumptions.

7. Common Mistakes

• Testing unrealistic ranges: Sensitivity analysis is most useful when the assumption range is plausible rather than extreme or arbitrary.
• Changing multiple assumptions at once: That becomes scenario analysis, not pure sensitivity analysis.
• Focusing only on upside cases: Conservative investors pay close attention to downside sensitivity.
• Ignoring the most important variables: Some assumptions matter far more than others, especially exit cap rates and rent growth in many models.
• Producing tables without interpretation: The purpose is to understand risk, not just create more outputs.

8. Knowledge Check

1. What is the main purpose of sensitivity analysis in real estate underwriting?
2. Why is only one assumption usually changed at a time?
3. Which common real estate assumptions are often tested for sensitivity?
4. What does it suggest if a small assumption change causes a large drop in projected returns?
5. How is sensitivity analysis different from scenario analysis?

9. Practical Exercise

A property has projected terminal NOI of $360,000. The base terminal cap rate is 6.0%.

1. Calculate projected sale value at a 6.0% terminal cap rate.
2. Recalculate sale value at 5.5% and 6.5% terminal cap rates.
3. Measure the difference in value between the best and worst cases.
4. Write 3 to 5 sentences explaining what this tells you about exit sensitivity.
5. Briefly explain why an investor should not rely only on the base-case exit assumption.

10. Key Takeaways

• Sensitivity analysis tests how one changing assumption affects projected outcomes.
• It helps investors identify which assumptions matter most in a real estate model.
• Common sensitivity variables include rent growth, vacancy, expenses, financing terms, and terminal cap rates.
• Small changes in a key variable can materially affect value and returns.
• The goal of sensitivity analysis is not certainty, but better understanding of model risk and investment resilience.

11. Next Lesson

In Lesson 11.9: Scenario Analysis, students expand beyond one-variable testing and examine how multiple assumptions interact under upside, base-case, and downside conditions.

Lesson Navigation