Why Leasing Uncertainty Changes the Modeling Mandate
Office investment analysis has always required a view on future income, but the nature of that challenge has shifted materially. When demand for space is structurally uncertain — not just cyclically soft — the standard approach of running a single base-case rent roll and discounting it back at a market cap rate understates the true risk profile of an asset. The question of how to model office investment cash flows when leasing demand is uncertain is now a first-order discipline for every adviser, underwriter, and portfolio strategist operating in the sector.
The shift matters because leasing risk and financing risk compound each other. An office asset carrying meaningful vacancy does not just generate lower cash flows — it also attracts tighter debt terms, shorter loan maturities, and lender covenants that may accelerate refinancing decisions. Modeling that ignores the interaction between occupancy and capital structure will consistently mis-price both acquisitions and dispositions.
Practitioners who build robust uncertainty into their models from the outset make better hold-versus-sell decisions, structure more defensible investment committee presentations, and negotiate from a position of real information rather than optimistic assumption. The methodology described here is designed to work at the asset level, where the numbers have consequences.
Defining the Sources of Leasing Demand Uncertainty
Before structuring a scenario model, an analyst must map the specific sources of uncertainty affecting a given asset. Generic assumptions about "soft market conditions" are not sufficient. Demand uncertainty in office markets has at least three distinct drivers, and each one behaves differently in a discounted cash flow model.
The first driver is structural demand reduction — the kind produced by sustained hybrid work adoption, occupier footprint rationalization, or industry contraction in the asset's tenant base. When tenants are systematically leasing less space per employee than they did a decade ago, vacancy projections cannot simply revert to historical means. The absorption model must account for the possibility that prior peaks in occupancy will not recur on the asset's hold horizon.
The second driver is cyclical demand softness, which is temporary and historically mean-reverting. Rising interest rates, a slow hiring environment, or a local economic contraction can depress leasing velocity without permanently altering the equilibrium occupancy rate. Distinguishing structural from cyclical demand is analytically difficult but commercially critical — the two scenarios imply very different terminal values and very different capital expenditure requirements to retain tenants.
The third driver is competitive supply pressure, which acts on demand indirectly by redistributing existing tenants. A new Class A tower in the same submarket may not add net demand, but it draws tenants away from older assets, effectively increasing functional vacancy even when asking rates appear stable. Modeling supply-side risk requires tracking the development pipeline and assigning probability weights to deliveries within the hold period.
Building the Scenario Framework Before Opening the Spreadsheet
Disciplined modeling begins with a written scenario narrative, not with a cell reference. Before an analyst opens a financial model, they should have a one-page document that describes the base case, the downside case, and the upside case in plain language — with specific assumptions about leasing velocity, tenant retention rates, renewal probability, and free rent periods attached to each scenario. The numbers must follow the narrative, not precede it.
The base case should represent the most probable outcome given current market evidence, not the outcome required to make the investment work. This distinction sounds obvious but is routinely violated in investment committee submissions. A base case calibrated to justify a predetermined return will produce scenario outputs that are symmetrically optimistic, because the downside case is built as a haircut on a base that was already inflated.
The downside case should be specific enough to be testable. Vague language like "prolonged vacancy" is not actionable. A testable downside case names a specific occupancy level, a specific period of zero net absorption, and a specific concession package — say, a hypothetical asset absorbing at fifty percent of the submarket's average velocity with free rent periods fifty percent longer than the trailing three-year average. Even when those numbers are labelled as hypothetical, they create accountability in the model.
The upside case should be built with equal discipline. Optimistic scenarios that simply reverse downside assumptions without a credible causal mechanism do not add analytical value. An upside case earns its place in a model when it is grounded in a specific catalyst — a large tenant's known relocation search, a planned infrastructure project, or a submarket supply constraint — that could realistically shift absorption within the hold period.
Structuring the Rent Roll for Uncertainty
The rent roll is the structural backbone of an office investment model, and it is also the place where most uncertainty errors accumulate. Analysts frequently treat the rent roll as a static input — current tenants in place, assumed to renew at market or vacate on lease expiration — without modeling the probability distribution around each of those events.
A probability-weighted rent roll assigns a renewal probability to each tenant and builds explicit assumptions about the gap period between expiration and re-leasing, the tenant improvement allowance required to re-lease at market, and the leasing commission that will be paid. For large tenants, those assumptions should be developed tenant by tenant, based on observable factors like lease term remaining, the tenant's financial health, and whether the tenant has been contracting or expanding its footprint across other markets.
The gap period assumption is particularly consequential in uncertain markets. If the market leasing velocity implies that re-leasing a full floor takes eighteen to twenty-four months, a model that assumes a twelve-month gap understates the carrying cost of vacancy by a material amount. At a hypothetical effective gross income of two million dollars per floor per year, an extra six months of vacancy on three floors represents three million dollars of unmodeled cash shortfall — a figure that can swing an IRR by hundreds of basis points on a typical office asset.
Tenant improvement allowances deserve similarly careful treatment. In markets where landlords are competing aggressively for tenants, TI packages have expanded substantially. Using the trailing average allowance without adjusting for current competitive conditions will understate the capital outlay required to execute the rent roll. In a hypothetical scenario, an asset that modeled TI at fifty dollars per square foot but is actually required to offer ninety dollars per square foot to retain a key tenant faces a capital requirement that was not visible in the base case.
Modeling Vacancy at the Floor and Suite Level
Portfolio-level vacancy assumptions obscure the operational reality of office assets. A model that holds a twelve percent vacancy rate constant across the hold period treats that vacancy as if it were spread uniformly across the building at a constant level, which almost never matches how vacancy actually behaves. Real vacancy is concentrated, episodic, and physically specific.
Floor-level modeling forces the analyst to confront the actual leasing problem. A twenty-story building with two full-floor vacancies on floors three and four is a fundamentally different risk profile than the same building with scattered suite vacancies on eight floors. The concentrated vacancy may be easier to solve with a single large tenant but harder to solve quickly; the distributed vacancy may lease more gradually but generates small revenue in the interim.
Structuring the model at the floor or suite level also makes the capital expenditure schedule more realistic. TI commitments, elevator lobbies, common area upgrades, and utility infrastructure are all physically located — they attach to specific floors or units, not to a vacancy rate. When those costs are assigned to specific spaces and specific projected lease-up dates, the cash flow schedule becomes a genuinely plannable capital program rather than a smoothed assumption.
The floor-level model also makes it possible to test a lease-up sequencing strategy. If the investment thesis requires leasing the top three floors to a credit tenant at a premium rent, the model should show what happens if that tenant takes eighteen months to commit, signs at a ten percent discount to asking rent, and requires a lobby renovation as a condition of the lease. That is not pessimism — it is the kind of operational specificity that separates a fundable underwriting from a wishful one.
Calibrating Effective Rent and Concession Packages
Nominal asking rent is not the number that drives investment returns — effective rent is. Effective rent accounts for free rent periods, tenant improvement allowances, and leasing commissions, all expressed as a present value equivalent to the base rent stream. In uncertain leasing markets, the spread between asking rent and effective rent widens, and models that do not track this spread overstate income.
The lease net present value calculation is the right tool for comparing leasing scenarios. For each proposed lease, calculate the NPV of the rent stream after deducting the present value of landlord costs — TI, free rent, and leasing commissions — using a discount rate that reflects the cost of the capital deployed in those concessions. The resulting figure, expressed as an effective annual rent, allows direct comparison across leases with different term lengths, concession levels, and commencement dates.
Effective rent analysis also exposes the hidden cost of short-term leases. A three-year lease at market asking rent with a standard TI package may produce a lower effective rent than a seven-year lease at five percent below asking with a larger but amortized TI budget. When modeling office investment returns, the lease term structure matters as much as the headline rent — shorter leases increase rollover frequency and therefore increase aggregate concession costs over the hold period.
Practitioners should also model the lease economics of renewal versus new tenant scenarios side by side. Renewing an existing tenant typically costs less in TI and leasing commissions than replacing a tenant, even when the renewal rent is below market. That differential is real capital savings, and it belongs in the model as a probabilistic outcome weighted by the renewal probability assigned to each tenant.
Applying Probability Weights and Monte Carlo Logic
Scenario analysis with three discrete outcomes — base, upside, downside — is a starting point, not an endpoint. The limitation of discrete scenarios is that they treat probability as binary: either the base case happens or it does not. Probability-weighted analysis moves one step further by assigning explicit weights to each scenario and computing the weighted-average return.
A simple three-scenario model might assign sixty percent probability to the base case, twenty-five percent to the downside, and fifteen percent to the upside. The weighted-average IRR and equity multiple then represent a more honest expected return than the base case alone. When the weighted-average return is materially below the hurdle rate — even though the base case clears the hurdle — the investment requires either a price adjustment or a thesis revision.
Monte Carlo simulation extends this logic by running thousands of iterations with randomized inputs within defined ranges. For an office investment, the key variables to randomize include leasing velocity, renewal probability, free rent periods, TI per square foot, and exit cap rate. The output is a probability distribution of IRRs rather than a single number, and that distribution is a far more honest representation of the return profile than any point estimate.
Not every asset warrants full Monte Carlo analysis, but the discipline of identifying the key variables and assigning distributions to them — even informally — produces sharper thinking. The process of deciding which inputs should have wide distributions and which should be tightly bounded forces an analyst to make explicit where the real uncertainty in the investment lives.
Stress-Testing the Exit Assumptions
Terminal value is the dominant driver of return in most office investment models, which makes the exit cap rate and the stabilized net operating income at exit the two most consequential assumptions in the entire analysis. In uncertain leasing environments, both are inherently unstable, and standard sensitivity tables that vary only the exit cap rate while holding NOI constant are insufficient.
Exit NOI should be modeled as a function of the occupancy and rent assumptions that the investment thesis implies will be achieved by the sale date. If the thesis requires leasing eighty percent of the building before an exit at year five, the model should show the precise sequence of leases, the capital required to execute them, and the probability that the occupancy target is achieved on schedule. Exiting at a stabilized cap rate when the building is not actually stabilized produces a hypothetical exit value that buyers will not pay.
Cap rate stress testing should cover a wider range than analysts typically use. A twenty-five-basis-point cap rate sensitivity on either side of the base case is insufficient for assets with structural demand questions. A more defensible stress test ranges the exit cap rate across one hundred to one hundred fifty basis points, recognizing that buyer perception of office risk has repriced meaningfully and that pricing will not necessarily revert to the cycle peak in any given hold period.
The debt maturity profile must be integrated into the exit analysis. If the loan matures in year four and the building is sixty percent occupied, the refinancing options available at that point — and their cost — should be modeled explicitly. A forced sale or a pay-down requirement at an inopportune point in the leasing cycle can destroy returns that looked reasonable at acquisition, and that outcome must be visible in the downside scenario before the investment is made.
Managing Cash Flow Timing and Liquidity Reserves
Uncertainty in leasing demand does not just affect the magnitude of cash flows — it affects their timing, and timing mismatches create liquidity risk that the base-case income statement does not reveal. An operating reserve analysis is a necessary complement to the standard cash flow model.
The liquidity reserve should be sized to cover the worst-case scenario's cumulative cash shortfall from operations, including debt service, through the period of peak expected vacancy. For a hypothetical office asset where the downside scenario projects an eighteen-month window of negative operating cash flow, the reserve should be sized to fund that shortfall plus a buffer — not an average of the scenarios, but the specific downside path.
Timing also affects the equity contribution schedule. If the investment thesis requires three large capital infusions for TI packages in years two, three, and four — coinciding with anticipated lease expirations — the equity partners need to understand those commitments at the time of investment, not when the draw is called. A well-structured model presents the equity contribution schedule in calendar-year columns so that capital calls are visible years before they occur.
Reserves held in the entity should be explicitly modeled as a drag on equity returns, because they represent deployed capital that earns nothing until it is spent. An investor who commits ten million dollars of equity to an asset but holds two million in reserves for two years before spending it has effectively deployed twelve million dollars of capital over the hold period — a distinction that matters when computing time-weighted returns.
Connecting the Model to the Operational Decision Record
A financial model is not a one-time document — it is a living framework that should update as leasing evidence accumulates during the hold period. Establishing a cadence for model updates and a process for comparing actual results against underwriting assumptions is as important as the initial build. Without that discipline, models drift from reality quietly and the warning signs of a deteriorating thesis arrive too late.
The comparison report should track, at minimum, the leasing velocity achieved against the underwritten pace, the concession packages granted against the modeled assumptions, and the occupancy level achieved against the quarterly projection. When actual leasing velocity falls materially behind the model, the right response is to revise the base case immediately — not to assume catch-up in the remaining quarters.
##
The key operational discipline is assigning ownership of the model to a named person, establishing a defined update cadence, and creating a threshold rule — specifying how far actual results must diverge from underwriting before a formal review is triggered. That governance layer turns a good model into a managed asset rather than an archived document.
##
Building the Investment Committee Narrative from the Model
A sophisticated cash flow model is only as useful as the narrative that communicates its findings to decision-makers. Investment committees do not evaluate spreadsheets — they evaluate arguments, and the model's job is to make the argument precise rather than to replace it. The presentation of an office investment under uncertain leasing conditions should lead with the range of outcomes, not with the base-case number.
Present the probability-weighted return first, with a plain-language description of what the base, downside, and upside cases assume. Follow that with the break-even occupancy analysis — the occupancy level at which the investment returns its capital at the hurdle rate — expressed as a percentage of the building that must be leased within a specific time frame. That framing tells the committee exactly what the investment requires the market to deliver.
The sensitivity table should highlight the two or three variables that drive the widest range of outcomes, not every variable in the model. For most uncertain office investments, those variables are leasing velocity, exit cap rate, and free rent per lease. Everything else is secondary. Keeping the presentation focused on the highest-impact variables forces a productive conversation about the assumptions rather than a numerical review.
Using the Model as a Negotiation Tool
The lease-economics analysis embedded in a well-structured office investment model is directly usable in lease negotiations. When a landlord understands the NPV impact of extending a free rent period by one month versus reducing the TI allowance by five dollars per square foot, the negotiating position shifts from positional bargaining to economic problem-solving.
Advisers who bring effective rent calculations into lease negotiations — showing the tenant that a shorter free rent period with a higher base rent produces the same effective economics as the tenant's proposed structure — close deals more efficiently than those who negotiate on headline numbers alone. The model becomes a shared analytical framework rather than an internal tool.
Sustaining the Methodology Across the Hold Period
The final discipline of this methodology is continuity. A model built at acquisition and never revisited is a snapshot, not a tool. Office investment under uncertain leasing demand requires a governance structure that assigns ownership of the model, defines the frequency of updates, and specifies the threshold at which a material deviation from underwriting triggers a formal hold-versus-sell review.
That governance structure should include a critical-date calendar that maps every lease expiration, loan maturity, capital call, and regulatory deadline across the full hold period. The calendar does not replace the model — it activates it.
Portfolio strategy informed by this level of analytical discipline produces decisions that are traceable, defensible, and faster to execute when market conditions change. The teams that build this infrastructure around their office investments are the ones positioned to act when distressed assets come to market, to refinance before covenants are tested, and to exit before the window closes.
Modeling office investment cash flows under demand uncertainty is not an academic exercise — it is the operational foundation of sound commercial real estate stewardship.
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.