What is Sensitivity Analysis in CRE?
A financial modeling tool that shows how a property's value and returns change under different assumptions — and the single most effective way to pre-handle a seller's "what if rates move?" objection.
Key takeaways
- Sensitivity analysis maps how a property's value and returns shift as key inputs — cap rate, rent growth, vacancy — change across a defined range of scenarios
- Brokers who present sensitivity tables in listing pitches demonstrate that they've stress-tested the pricing, not just optimized for the best case
- A sensitivity analysis is not just for institutional deals — any property where a buyer is underwriting to a cap rate benefits from one
- The most valuable output isn't the upside scenario; it's identifying the floor — the worst-case assumption set under which the deal still works for a buyer
The plain-English definition
Sensitivity analysis is a financial modeling technique that shows how a property's projected value or returns change when you vary one or more key inputs. In commercial real estate, the most common inputs are cap rate, net operating income, rent growth rate, vacancy, and exit cap rate. The output is typically a matrix — sometimes called a sensitivity table or heat map — that displays how the deal performs across a range of combinations.
The simplest version is a two-variable table. You fix everything else and vary two assumptions — say, going-in NOI and exit cap rate — across five values each. The result is a 5x5 grid showing 25 outcomes. At a glance, a buyer can see which combinations produce acceptable returns, which produce unacceptable ones, and where the break-even line sits.
Sensitivity analysis is distinct from scenario analysis, though both are often used together. Scenario analysis runs a small number of discrete cases — base, bull, bear — each with its own internally consistent set of assumptions. Sensitivity analysis isolates individual variables to show their independent effect. Together, they give a buyer a complete picture of where the deal is robust and where it's fragile. That picture is far more useful than a single-point projection, which tells a buyer only what happens if every assumption is exactly right.
How brokers use it in practice
Most brokers think sensitivity analysis belongs in the underwriting model — something the buyer's analyst produces during due diligence. The brokers who win the most listings use it earlier: in the BOV, in the listing pitch, and in the OM itself. That shift changes the entire conversation.
When a seller asks "what happens if rates move another 50 basis points before we close?", a broker who can pull up a cap rate sensitivity table and say "at 25 bps of expansion, we're still pricing inside market; at 50 bps, we'd likely reprice to $X" is having a different conversation than a broker who says "we'll cross that bridge when we get there." One broker looks like they've thought through the risk. The other looks like they're hoping.
You can build a sensitivity analysis in IntellCRE directly within the underwriting workflow, which lets you produce a formatted sensitivity table as part of your BOV or OM package rather than as a separate spreadsheet. Presenting it inside the marketing document — not as an attachment — signals to buyers that the pricing is based on tested assumptions, not a single optimistic model. In competitive listing situations, that level of preparation often makes the difference in winning the assignment.
For multifamily and office assets with near-term lease rollover, a rent-growth sensitivity table is equally useful. If a buyer is underwriting to a 3% annual rent growth assumption and your sensitivity table shows the deal still works at 1%, you've pre-answered the pushback before it's raised.
Common misconceptions
The most common misconception is that sensitivity analysis is only useful for large or complex deals — institutional assets, development projects, or properties with complicated lease structures. It isn't. Any property where a buyer is underwriting to a cap rate — which includes virtually every income-producing commercial property — benefits from a sensitivity table. A 12-unit multifamily at $2.5M has exactly the same cap rate sensitivity as a 200-unit institutional asset. The buyer's question is the same: how does my return change if I'm wrong about NOI by 5%, or if exit caps expand by 50 basis points?
A second misconception is that presenting a wide sensitivity range will scare buyers away. The opposite is usually true. Buyers who see a transparent sensitivity table trust the pricing more, not less — because it signals that the broker isn't hiding the downside. A range that shows the deal works across multiple scenarios creates conviction. A single-point projection with no range creates skepticism, because every experienced buyer knows the projection won't be exactly right.
The third misconception is that building a sensitivity table requires advanced spreadsheet skills. It doesn't. A clean two-variable sensitivity matrix takes 20 minutes to build in Excel — and with AI underwriting tools that automate the financial model, the table can be generated as part of the standard underwriting output. The constraint isn't technical; it's the habit of including it. Start including a sensitivity table in every BOV you deliver this quarter and watch how different the seller conversation becomes.
Frequently asked questions
What inputs should I vary in a sensitivity analysis for a multifamily deal?
The two most impactful variables are exit cap rate and stabilized NOI (or rent growth rate, which drives NOI). Run your sensitivity table with exit cap rate on one axis (±50 to ±100 basis points from your base assumption) and NOI on the other (±5% to ±15%). The resulting matrix will cover the realistic range of outcomes a buyer will model during underwriting.
Is sensitivity analysis the same as a scenario analysis?
No. Sensitivity analysis isolates individual variables — it shows what happens when one assumption moves while everything else stays fixed. Scenario analysis runs fully integrated cases (base, bear, bull) where all assumptions change together. Both are useful; a complete underwriting package typically includes both.
Should I include a sensitivity table in the OM, or only in the BOV?
Both, if the asset warrants it. In a BOV, it demonstrates your underwriting depth and supports your pricing recommendation. In the OM, it gives buyers a pre-built tool to check their own assumptions against yours — which reduces back-and-forth during the offer process and speeds the deal toward an LOI.
How do I use sensitivity analysis to handle a seller's pricing objection?
When a seller wants to price above market, a cap rate sensitivity table is your most credible reframing tool. Show them what buyer pool exists at each cap rate increment — and where the buyer pool thins out. Sellers who see a table demonstrating that pricing 25 bps above market cuts the qualified buyer pool in half are far easier to have a rational pricing conversation with than sellers who are responding to a single number.