Sensitivity analysis is one of the most underused tools in commercial real estate, yet it is the discipline that separates a defensible lease recommendation from a guess dressed in spreadsheet formatting. Understanding How to Run a Sensitivity Analysis on a Commercial Lease Decision requires a working grasp of lease economics, a clear model architecture, and the judgment to know which variables actually move the needle for a specific occupier's situation.
Why Sensitivity Analysis Belongs in Every Lease Evaluation
A lease commitment is a financial obligation that spans years, sometimes decades. The base rent figure on page one of a proposal tells only a fraction of the story. Operating expense escalations, free rent periods, tenant improvement allowances, annual rent steps, and holdover penalties all interact to produce a total cost profile that can diverge significantly from the headline number.
Sensitivity analysis asks a disciplined question: if one or more of those inputs changes by a defined amount, how much does the outcome change? That question is not hypothetical decoration. It reflects the real uncertainty that surrounds any lease negotiation, where landlords counter, markets shift, and build-out costs routinely overshoot initial estimates.
For corporate real estate teams managing multi-market portfolios, the discipline is equally important at the portfolio level. A single lease may look acceptable in isolation, but the same assumptions applied across a portfolio of twelve leases can reveal concentration risk or cash flow exposure that no individual analysis would surface.
The output of a well-constructed sensitivity analysis is not a single number. It is a range of outcomes paired with the probability-weighted conditions that produce each outcome, giving decision-makers a foundation for negotiation strategy, board approval, and long-term planning.
Defining the Decision Before Building the Model
A sensitivity analysis is only as useful as the decision it is designed to inform. Before any numbers are entered, the adviser and client must agree on the specific question being answered. Is the team comparing two alternative spaces? Evaluating whether to renew or relocate? Deciding between a lease and a purchase? Each question produces a different model structure.
The scope of the analysis should also define what "outcome" means for this occupier. Some organizations optimize for total occupancy cost over the lease term. Others prioritize net present value of the cash flow obligation. Still others need to understand effective rent — the average annual cost after netting out landlord concessions — because that metric governs internal budget approvals.
Agreeing on the metric before building the model prevents the common mistake of producing a technically correct analysis that answers the wrong question. A tenant-rep adviser who delivers a clean NPV model to an occupier whose finance team uses effective rent as its benchmark has created friction, not clarity.
Defining the decision also means setting the lease term parameters. A ten-year analysis of a five-year lease is a different exercise from a ten-year analysis of a ten-year lease. The renewal option, expansion clause, and termination right embedded in a lease all create embedded optionality that the model must account for or explicitly exclude.
Mapping the Input Variables
Once the decision and metric are defined, the next task is identifying every input variable that affects the outcome. In a standard commercial lease model, these inputs fall into three broad categories: rent economics, cost economics, and occupancy economics.
Rent economics covers base rent, the structure of annual rent escalations (fixed step increases versus CPI-linked increases), free rent periods by month and phase, and any percentage rent clauses applicable to retail leases. Each of these has a direct, first-order effect on total rent paid.
Cost economics covers operating expenses, common area maintenance charges, real estate tax exposure, insurance pass-throughs, and utility structures. In a gross lease, many of these costs are bundled into the base rent, but they still affect the landlord's economics and therefore the negotiating range. In a net or modified gross lease, they appear as line items that require separate assumptions.
Occupancy economics covers the capital cost of occupying the space: tenant improvement allowances, above-standard build-out costs, furniture and technology fit-out, moving costs, and any space-planning fees. These are frequently the most volatile inputs in a lease model because they depend on the condition of the existing space and the occupier's program requirements, both of which are often imprecisely defined at the time of initial comparison.
Establishing Base, Upside, and Downside Cases
With inputs mapped, the model requires three scenarios for each variable: a base case, an upside case, and a downside case. The base case represents the most likely outcome given current market data and negotiation intelligence. The upside case represents the best realistic outcome the occupier might achieve. The downside case represents an adverse but plausible outcome.
Defining "realistic" is an act of market judgment, not mathematical convention. A downside case for operating expense escalation in a market with aging infrastructure and rising insurance costs should reflect what the local market has actually produced over the prior lease cycle, not an arbitrary percentage pulled from a template. The adviser's role is to supply that market context.
For rent steps, the base case might assume the landlord's proposed annual escalation of three percent. The upside case might assume a negotiated reduction to two and a half percent. The downside case might assume the landlord holds at three percent and the occupier absorbs higher operating expense pass-throughs than projected. Each of these is a specific, bounded assumption, not a vague range.
Some variables are correlated. A market that softens enough to produce a downside rent scenario for the landlord is also likely to produce more favorable tenant improvement allowances for the occupier. Building correlation into scenario design produces a more coherent stress test than treating each variable as independently random.
Building the Lease NPV Model
The lease net present value calculation is the engine of any rigorous lease sensitivity analysis. It discounts all future cash outflows back to a common point in time — typically lease commencement — using a discount rate that reflects the occupier's cost of capital or a market-standard benchmark rate.
Each month of the lease term generates a cash outflow representing rent, operating expenses, and any other contractual obligations. Free rent months produce zero cash outflow, but they do not eliminate the obligation; they defer it into the structure of the deal. The model must apply free rent accurately by month, not by averaging it across the term.
The discount rate selection deserves deliberate attention. Corporate real estate teams often use the company's weighted average cost of capital. Others use a risk-free rate plus a spread that reflects the credit quality of the lease obligation. Either approach is defensible, but the rate should remain consistent across all alternatives being compared; changing the discount rate between alternatives distorts the comparison.
The effective rent calculation provides a complementary perspective. Effective rent equals total base rent paid over the term, minus the gross value of landlord concessions (free rent and tenant improvement allowance), divided by the rentable square footage and the number of years in the term. It produces a single dollars-per-square-foot-per-year figure that makes alternatives with different structures directly comparable.
Running the One-Variable-at-a-Time Test
The first pass of sensitivity analysis changes one input at a time while holding all others at the base case. This is sometimes called a one-way sensitivity or tornado analysis, because the results, when plotted, produce bars of varying length that resemble a tornado diagram.
For each input variable, the model runs three times: once at the base value, once at the upside value, and once at the downside value. The output metric — NPV or effective rent — is recorded for each run. The difference between the upside and downside outcomes for each variable is that variable's sensitivity range.
Variables with the widest sensitivity range have the most leverage in the negotiation. If the free rent period produces a swing of forty dollars per square foot in effective rent between the best and worst case, while annual rent escalation produces a swing of twelve dollars per square foot, the adviser should concentrate negotiating energy on free rent first.
Ranking variables by their sensitivity range is not the same as ranking them by their probability of occurring. A variable with a wide range but a low probability of hitting the downside case is different from a variable with a moderate range that is almost certain to move adversely. The tornado analysis must be read alongside market intelligence, not in isolation.
Running the Multi-Variable Scenario Analysis
After the one-way test, the analysis moves to multi-variable scenarios that combine correlated assumptions into internally consistent stories about the future. A "soft market" scenario might combine lower base rent, a more generous tenant improvement allowance, additional free rent months, and slightly higher operating expense pass-throughs because the building is older. A "tight market" scenario might combine higher effective base rent, a smaller allowance, no free rent, and a landlord-friendly escalation clause.
These scenario combinations are more operationally realistic than the one-way test because markets move together, not in isolation. An adviser presenting scenario analysis to a client can frame each scenario as a named market condition, making the financial output legible to executives who do not think in spreadsheet terms.
The gap between the soft market and tight market NPV outcomes for a given space defines the occupier's risk exposure to market timing. If the occupier signs today in a tight market, that is the downside scenario on rent economics. If they wait six months and the market softens, they may achieve the upside scenario. The scenario analysis makes that trade-off explicit and quantifies it.
Adding a "do nothing" or "holdover" scenario gives the analysis a complete decision frame. Holdover costs in a commercial lease — often one hundred and fifty percent of the final monthly rent, contractually — can be the most expensive outcome in the model. A scenario that includes twelve months of holdover exposure frequently dominates the sensitivity analysis in total cost, which is a powerful argument for completing a transaction ahead of the lease expiration.
Applying Break-Even Analysis Within the Model
Break-even analysis is a targeted form of sensitivity analysis that asks: how far does this input have to move before the decision flips? Rather than testing a predefined upside or downside, it solves backward for the value at which two alternatives produce the same outcome.
A practical example: a tenant is evaluating two spaces. Space A has a lower base rent but a smaller tenant improvement allowance, requiring the occupier to fund an additional build-out cost. Space B has a higher base rent but a full turnkey allowance. The break-even analysis calculates the base rent level at which the higher allowance in Space B exactly offsets its rent premium, producing identical NPVs for both options.
If the break-even rent for Space B is below the landlord's current asking rent, Space A is more economical across all reasonable negotiation outcomes, and the team can commit with confidence. If the break-even rent is within the negotiating range, closing the gap becomes the primary objective of the LOI negotiation, and the adviser has a specific target number to carry into the conversation.
Break-even analysis also applies to lease term length. The question of whether a five-year or ten-year commitment produces a better economic outcome depends on concession structure, projected market conditions at year five, and the cost of capital. Solving for the market rent at renewal that makes the five-year option more expensive than the ten-year option gives the occupier a calibrated view of the bet they are making on future market conditions.
Using the Analysis to Structure the Negotiation
A sensitivity analysis is not a report to be filed after a decision is made. When used correctly, it is a live negotiating tool that directs where the adviser concentrates pressure and what trade-offs the client is prepared to accept.
The tornado diagram tells the adviser which variables move the outcome most. The scenario analysis tells the client what the realistic range of total cost looks like. The break-even analysis tells the negotiating team what specific concessions are needed to make a given space competitive. Together, they produce a negotiation brief that is grounded in numbers rather than intuition.
Presenting the analysis to the landlord — selectively and strategically — can also shift the negotiation dynamic. Showing a landlord that their proposed operating expense structure produces a downside occupancy cost well above comparable buildings gives a factual basis for a counter-proposal that is harder to dismiss than a bare request for a reduction.
The analysis also prepares the client for landlord counter-proposals. When a landlord counters by offering two additional months of free rent instead of a higher tenant improvement allowance, the model can evaluate that trade-off in real time and produce a revised NPV within the meeting. That capability converts the analysis from a one-time deliverable into an ongoing negotiation asset.
Documenting Assumptions and Source Transparency
Every number in a sensitivity analysis rests on an assumption, and every assumption should be traceable to a source. This discipline matters for three reasons: it allows the analysis to be peer-reviewed by the client's finance team, it protects the adviser when market conditions differ from projections, and it creates a record that can be used to calibrate future analyses.
Operating expense projections should cite the specific building's historical expense reconciliations where available, or comparable buildings in the same submarket. Rent escalation assumptions should be grounded in the local market's historical escalation patterns and the specific landlord's standard lease language. Discount rates should be documented with the client's treasury team or the source rate used.
Assumptions that cannot be sourced should be explicitly labeled as estimates and flagged for sensitivity testing with wider ranges than well-documented inputs. An unsourced estimate that goes into a model without a flag becomes an invisible risk that can invalidate the analysis entirely if it proves materially wrong.
Connecting the Analysis to the Broader Deal Workflow
A sensitivity analysis that lives only in a spreadsheet eventually becomes disconnected from the transaction it was designed to inform. Proposals update, landlords counter, build-out estimates revise, and the base case from week two may no longer reflect reality by week eight. Managing version control manually across a transaction team creates risk.
The model should be treated as a living document that is updated each time a material input changes. Each version should be dated and archived so the team can reconstruct how the recommendation evolved as the negotiation progressed. This record is particularly valuable if the decision is later reviewed by internal audit, a board, or a regulatory authority.
Reviewing the Analysis Before Final Recommendation
Before any analysis reaches a client, it should be reviewed by a second adviser or a senior team member who was not the primary author. Confirmation bias is a genuine risk in financial modeling: the analyst who built the model has strong intuitions about the right answer and may have — consciously or not — weighted the inputs toward that conclusion.
The review should check three things: arithmetic accuracy, assumption reasonableness, and decision alignment. Arithmetic accuracy is the minimum standard. Assumption reasonableness requires comparing every input to an independent source. Decision alignment asks whether the analysis actually answers the question the client posed at the outset.
Where the sensitivity ranges are wide — where the difference between upside and downside outcomes is large enough to change the recommendation — the review should flag that uncertainty explicitly. A client who understands that the recommendation is robust under most scenarios but vulnerable under one specific condition is better equipped to manage the lease than a client who received a single-point recommendation with no context.
Source transparency is not a back-office quality check; it is the mechanism by which a recommendation earns the client's confidence.
Communicating Results to Non-Financial Stakeholders
The final output of a sensitivity analysis is often presented to executives, board members, or facilities committees who do not read financial models. The adviser's job is to translate the model's output into plain language that preserves the key insights without losing the decision-relevant nuance.
The most effective communication format presents three things: the recommended option, the total cost range across scenarios, and the two or three variables that drive most of the uncertainty. Executives do not need to understand every input; they need to understand what could change the outcome and how likely that change is.
Visual output — tornado diagrams, scenario comparison tables, effective rent waterfall charts — makes the analysis accessible without oversimplifying. These visuals should be generated from the live model, not manually reconstructed, to ensure consistency between the chart and the underlying numbers.
The communication should also include a clear statement of what is not modeled: factors that affect the real estate decision but fall outside the financial model, such as the operational quality of the building, the landlord's reputation for lease administration, the proximity to the occupier's talent base, or the strategic value of a specific address. A sensitivity analysis informs the lease economics; the adviser synthesizes it with qualitative judgment to produce a recommendation.
About Advantai
Advantai is a commercial real estate intelligence and operations platform operated by ADVANTAGE AI LLC, a Delaware limited liability company. It connects client relationships, property research, documents and financial decisions in one workspace for commercial real estate teams — advisers and brokerage teams, occupier and facility teams, and portfolio teams. The platform covers CRM and origination, requirements and site selection, Property X-Ray (an interactive 3D building workspace), financial modeling and comparison, document intelligence, transactions and diligence, client collaboration, and portfolio strategy with critical dates. The optional Super Agent upgrade adds specialist, source-backed research and automated scenario analysis.
Get Started with Advantai
Ready to see your next move clearly? Go to advantaico.com, click Request a demo and tell us about your next project. Prefer to start with a single project? Visit advantaico.com/getting-started to plan your first one.