How to Use Sensitivity Analysis to Win More CRE Listings
Most brokers skip sensitivity analysis in their pitch materials. The ones who include it win more listings — because they answer the seller's hardest question before it's asked.
Key takeaways
- Sensitivity analysis belongs in your BOV presentation, not just in your back-office underwriting model.
- Three variables drive 90% of CRE value sensitivity: cap rate, NOI, and exit timing. Build your table around those.
- The goal of showing sensitivity to an owner is not to introduce risk — it's to demonstrate that you've thought through every outcome and have a plan for each one.
- A well-built sensitivity table pre-handles the three objections most likely to kill a listing agreement: "the market is too uncertain," "cap rates are moving," and "I should wait."
What sensitivity analysis is and why it belongs in your pitch, not just your underwriting
Sensitivity analysis is the practice of modeling how an asset's value changes when one or more key inputs change. In CRE underwriting, it typically means building a grid that shows value across a range of cap rate and NOI scenarios — so instead of a single valuation number, you have a matrix of outcomes based on different market conditions.
Most brokers use sensitivity analysis privately, as a gut-check on their pricing opinion before an owner meeting. They run the table, see the range of outcomes, decide on a number, and then present that single number to the owner as if the range doesn't exist. That's a missed opportunity.
Showing an owner your sensitivity table is one of the most effective things you can do to build credibility in a listing pitch. It signals three things simultaneously: that you've done thorough, institutional-quality underwriting; that you're being transparent about the range of realistic outcomes rather than selling them a number; and that you understand how the market actually works, not just how it's performing on the day you walked in.
Owners who see sensitivity analysis in a broker presentation rate that broker as significantly more credible than brokers who present a single number. The analysis doesn't create uncertainty in the owner's mind — it resolves it. They were already thinking about what happens if cap rates move. You just showed them that you were thinking about it too.
The practical implication is straightforward: build your sensitivity table as part of your BOV preparation, not after it. The same work that goes into your internal underwriting check can be formatted for presentation with minimal additional effort, and it will differentiate you from 95% of the brokers competing for that listing.
The three variables that matter most in a CRE sensitivity table: cap rate, NOI, and exit timing
A sensitivity table can theoretically be built around any input, but in practice, three variables account for the majority of value variability in income-producing commercial real estate: exit cap rate, NOI, and hold period (exit timing). Understanding what each one tests for helps you build a table that's both analytically correct and easy for an owner to understand.
Exit cap rate is the variable that owners care about most in 2025–2026, because it's been the one most visibly in motion. A 25-basis-point movement in cap rate on a $3M NOI property produces a $1.2M to $1.5M swing in value at typical price points. That swing is real money — and owners know it. Showing them the table that maps the relationship between cap rate movement and sale price is far more powerful than telling them the market is "stable." For a detailed walkthrough of how to set up this analysis, see sensitivity analysis in IntellCRE.
NOI is the variable that buyers are most likely to challenge during diligence. If your underwritten NOI assumes full occupancy and market rents, a buyer who runs a 5% vacancy reserve will arrive at a different value. Build your sensitivity table to show how value changes if NOI contracts 5% or 10% from your base case. This prevents surprises in diligence and tells the owner that your pricing is conservative enough to withstand a buyer who underwrites more defensively than you did.
Exit timing matters most for deals with upcoming lease events, planned capital projects, or exposure to a near-term market shift. Show the owner what the value looks like if they sell today versus 12 months from now versus 24 months from now, given expected changes in NOI and cap rate. Sometimes the sensitivity analysis makes the strongest argument for acting now — which is exactly the conversation you want to have before the listing agreement is signed.
How to present sensitivity data to owners without confusing or alarming them
The concern most brokers have about showing sensitivity analysis to owners is that it will create anxiety about downside scenarios and make the owner reluctant to move forward. This concern is legitimate but misplaced — it assumes the owner isn't already running those scenarios in their head. They are. If you don't show the table, the owner fills in the blanks themselves, usually with less data than you have and more pessimism than the market warrants.
Presentation framing is everything. Don't lead with the downside cells. Lead with your base case, explain why it's realistic given current market conditions, and then introduce the table as a way of showing the range of outcomes on either side. "Here's our base-case value of $9.0M — and here's how that number shifts if the market moves in either direction." That framing positions the table as a confidence tool, not a risk disclosure.
Walk the owner through three specific cells: your base case, the scenario that corresponds to a 25-basis-point cap rate expansion (so they understand the exposure), and the scenario that corresponds to NOI coming in 5% above base case (so they can see the upside). Keep the conversation anchored on those three reference points rather than asking the owner to process every cell independently.
AI underwriting tools generate these tables automatically, which means the production barrier that has historically kept most brokers from including sensitivity analysis in BOV presentations is essentially eliminated. The question is no longer whether you have time to build the table — it's whether you know how to present it in a way that builds conviction rather than creating hesitation. That's a communication skill, not a math skill.
Finish the sensitivity presentation by returning to your recommendation. "Given current market conditions, our base-case scenario is the most likely outcome, and it produces a sale price of $9.0M–$9.4M in a well-run process." The table provides the analytical foundation. Your recommendation is the conclusion.
Building a sensitivity table that strengthens your pricing opinion, not undermines it
The most common mistake brokers make when building a sensitivity table for presentation is including too wide a range of scenarios. A table that runs from a 4.5 cap to a 7.0 cap creates the impression that the market is unpredictable and the deal could be worth almost anything — which is the opposite of the confidence you're trying to build.
Keep your cap rate range tight and market-anchored. For most deals in most submarkets, a 75-basis-point range (25bps above and 25bps below your base, or 50bps on one side for rate-risk-heavy deals) is the right spread. That's wide enough to show that you've thought through the exposure, and tight enough to communicate that you have a genuine view on where the market is. Going wider than 75bps on the cap rate axis signals uncertainty rather than analytical thoroughness.
For NOI, a ±10% range is typically appropriate. More than 10% in either direction usually indicates either a stabilization play (where the NOI upside is the story, not the risk) or a property with significant operational issues that should be addressed separately in the presentation.
Build your table in a clean, readable format. A 3×3 or 3×5 grid works better than a 5×5 — the goal is clarity, not comprehensiveness. Label the axes clearly: "Exit Cap Rate" on one axis, "Stabilized NOI" on the other. Bold your base-case cell. The design should make the base case the center of gravity and the other cells the margins.
One formatting discipline that separates strong sensitivity tables from weak ones: express value in dollars, not percentages. "Value: $8.6M" is more useful in an owner conversation than "Value: 4.2% IRR." Owners think in dollars. Buyers think in returns. Your BOV presentation is for owners.
Using sensitivity analysis to pre-handle objections about rate risk and market timing
Three objections kill more CRE listing agreements than any others: "cap rates are too uncertain right now," "I think I should wait for rates to come down," and "I'm not sure the market can support your pricing." All three can be pre-handled with a well-built sensitivity table — if you use it proactively rather than reactively.
For the cap rate uncertainty objection, your sensitivity table is the direct answer. Show the owner exactly what a 25-basis-point cap rate expansion does to their proceeds — and then show them what the same expansion does to their proceeds 12 months from now, after they've carried the asset for another year and the market has moved. In many cases, the cost of waiting is larger than the cost of pricing at the current cap rate. Put those numbers side by side and let the owner reach the conclusion.
For the "wait for rates to come down" objection, the counter-argument is in the timing rows of your sensitivity table. Show what happens if rates don't come down — or if they come down but cap rates don't compress proportionally (which is the more common outcome). The wait-for-rates narrative assumes a specific market behavior that sensitivity analysis can test. When you show an owner that the wait-for-better-rates scenario only produces a $300K–$400K improvement in proceeds versus a conservative current-market exit, and that improvement comes at the cost of 18 months of ownership risk, the case for acting now often becomes self-evident.
For the pricing credibility objection, the sensitivity table works because it shows your thinking, not just your conclusion. An owner who asks "are you sure the market will support $9.0M?" can be answered with "at the current cap rate environment and your in-place NOI, $9.0M is the base case — here's what it looks like at a 5.75 cap versus a 6.0 cap." The table demonstrates that you've stress-tested your own number, which is far more persuasive than any amount of reassurance.
Frequently asked questions
Do buyers care about sensitivity analysis, or is it just for owners?
Both, but differently. Owners use sensitivity analysis to evaluate timing and pricing risk. Buyers use it to stress-test exit scenarios and determine their bid confidence. If you include a sensitivity section in your OM, use a buyer-oriented framing: show how the deal underwrites across a range of exit cap rates at the end of a typical 5- or 7-year hold. That framing speaks directly to the institutional buyer's investment committee process.
How precise should my NOI projection be in a sensitivity table?
Precise enough to be defensible, not so precise that it implies false certainty. Use round numbers — $1.2M NOI, not $1,214,800 — and explain your rounding assumptions. The goal is to show your analytical methodology, not to produce a number that looks more authoritative because it has more decimal places.
What software do I need to build a sensitivity table?
A basic sensitivity table can be built in Excel in under an hour once you have your base-case NOI and cap rate. More sophisticated analysis — including multi-variable tables and time-weighted IRR sensitivity — can be built in specialized underwriting platforms. The output format for presentation is typically a clean PDF or slide, not the model itself.
Should the sensitivity table go in the BOV, the OM, or both?
In the BOV, always. The sensitivity table is primarily a listing pitch tool — it helps you win the listing by demonstrating analytical depth and managing owner expectations before the deal goes to market. In the OM, include it if the deal has meaningful cap rate or NOI uncertainty that buyers will underwrite independently anyway. For stabilized, fully-leased assets, the OM sensitivity table is often redundant — buyers already know how to stress-test a 100% occupied NNN deal.