Why Lease Expiration Profiles Deserve More Than a Glance
Lease expiration profiles sit at the center of every income-producing property underwriting, yet they are routinely treated as a secondary exhibit rather than a primary analytical tool. A capital markets team that reads the profile correctly can identify rollover risk, re-leasing exposure, and embedded optionality that the offering memorandum almost never highlights. The practitioner who treats the expiration schedule as a checklist item rather than a story will systematically misprice assets.
Building the Baseline: What the Profile Actually Contains
Before any analysis can begin, the team needs a clean, verified expiration schedule that goes beyond lease end dates. A complete profile lists the tenant name or anonymized suite reference, the square footage governed by each lease, the current passing rent, and the lease end date — but also the termination options, renewal options, and any co-tenancy clauses that could accelerate or defer the exposure.
The profile should distinguish between hard expirations, which are firm lease-end events with no contractual extension mechanism, and soft expirations, where the tenant holds one or more renewal options at predetermined rents or at market. Soft expirations carry very different underwriting implications because the renewal economics are already partially fixed by the lease document, and the team needs to assess whether the option rents are above or below projected market at the time of exercise.
A third layer that experienced capital markets advisers add to the baseline is the weighted-average lease term, or WALT, calculated both by square footage and by base rent contribution. These two WALTs rarely align, and the gap between them reveals whether the longest leases belong to the highest-rent tenants or to anchor tenants carrying below-market rents locked in during an earlier cycle.
Once those three layers are assembled, the team can build a year-by-year rollover exposure table that shows not just when leases expire but what percentage of gross potential rent is at risk in each future year. That table — not the raw expiration dates — is the instrument the underwriter actually uses.
The Stacking Plan as a Spatial Companion to the Expiration Schedule
Expiration schedules are abstract until they are mapped onto the building. A stacking plan shows which tenants occupy which floors or zones, and when read alongside the expiration profile it reveals whether the near-term rollovers are clustered on a single floor or dispersed through the asset.
Clustering matters because contiguous expiration creates the possibility of delivering a large block of space, which may attract a credit tenant requiring a full-floor or multi-floor layout. That optionality can be a value driver rather than a risk. Dispersed expiration, on the other hand, creates a series of smaller, disconnected availabilities that tend to lease more slowly because fewer users can absorb sub-5,000-square-foot suites without a tenant improvement budget that may not be recoverable in the projected rent.
A stacking plan also reveals adjacency risk. If the two largest tenants in the building share a floor or are adjacent vertically, and both have leases expiring in the same calendar year, the underwriting must carry a scenario in which both vacate simultaneously. That scenario is rarely modeled explicitly in offering materials but is among the most consequential stress tests a capital markets team can run.
Tiered Risk Classification: Sorting Expirations by Credit and Term
Not all expirations carry equal risk, and one of the most useful methodologies a capital markets team can apply is a tiered classification system. The first dimension is credit quality: investment-grade tenants, creditworthy private tenants with demonstrable financials, and tenants without verifiable financial statements occupy very different risk tiers regardless of their lease length.
The second dimension is residual term at the time of acquisition. Leases with more than seven years remaining present minimal near-term rollover risk and can be underwritten at the current passing rent through the hold period with a reversion assumption at expiration. Leases with three to seven years remaining require a renewal probability assumption and a re-leasing cost assumption. Leases with fewer than three years are effectively near-term rollover events that need to be underwritten at projected market rent net of concessions, rather than at passing rent.
The matrix created by combining credit quality with residual term produces a nine-cell grid that helps the team prioritize where to spend analytical time. A high-credit tenant with six years remaining needs far less scenario analysis than a private tenant with fourteen months left on a lease that represents twenty percent of building income.
This tiered approach also helps investors distinguish between a well-leased asset — where a long WALT obscures a concentration of credit risk in one or two dominant tenants — and a genuinely diversified rent roll, where the weighted exposure is spread across tenants of different sizes, industries, and lease terms. Both may look similar in a headline occupancy number but carry fundamentally different risk profiles.
Reading Rollover Exposure as a Cash Flow Event, Not Just an Occupancy Event
The most common analytical error capital markets teams make is treating lease expiration as an occupancy question rather than a cash flow question. A suite that expires and re-leases at a lower rent on a shorter term is a cash flow impairment even if the building stays fully occupied. The underwriting must account for this explicitly.
The correct framing is to model each rollover as a discrete cash flow event with four components: the downtime period between the departing tenant's last rent payment and the new tenant's first rent commencement, the tenant improvement allowance and leasing commission required to secure the new lease, the new base rent, and the new lease term which determines the length of the income stream being acquired.
Downtime assumptions are particularly consequential because they compound. A four-month downtime on a suite representing ten percent of building income creates a roughly three-percent reduction in gross revenue for that year, which at a market cap rate translates directly into a valuation impact that can exceed the total improvement allowance. Teams that underwrite downtime as a single blended assumption across the entire rent roll tend to underestimate this effect when expiration is clustered.
Leasing commissions should also be modeled on a suite-by-suite basis where feasible, because commission rates vary by market, by space size, and by whether the transaction is a new lease or a renewal. A renewal commission at fifty percent of the new lease rate is a materially different cost from a new-lease commission at full rate, and blending them obscures the true re-leasing economics.
Effective Rent as the True Measure of Rollover Economics
Face rent — the stated base rent per square foot — is the figure most prominently displayed in offering materials. Effective rent, which accounts for free rent periods, tenant improvement allowances, and other landlord concessions, is the figure that actually determines whether a rollover is accretive or dilutive to value.
The effective rent calculation nets the total landlord economic contribution over the lease term against the total base rent collected. A hypothetical example makes this concrete: if a new lease is written at $50 per square foot per year for five years but includes eight months of free rent and a $60 per square foot tenant improvement allowance amortized over the term at a 7% hurdle rate, the effective rent drops materially below the face rent. That gap must appear explicitly in the underwriting model, not in a footnote.
When comparing a current in-place lease to the rollover scenario, the team should calculate the effective rent for both the departing tenant's lease and the projected new lease, then express the rollover as the percentage change in effective rent rather than the change in face rent. This comparison often reveals that what looks like a modest rent bump in the offering materials is actually a flat or declining effective rent position once concession trends are applied.
Market concession data — free rent in months, tenant improvement packages in dollars per square foot — varies by submarket, by building class, and by the competitive set the subject property draws from. Capital markets teams should build their concession assumptions from recent comparable transactions rather than from the broker's pro forma, which tends to understate concession costs in markets with meaningful vacancy.
Renewal Option Analysis: When the Tenant Controls the Narrative
Renewal options embedded in existing leases transfer optionality to the tenant, and that transfer has value implications that standard expiration profile analysis often misses. When a tenant holds a below-market renewal option, they will almost certainly exercise it, capturing the spread between their option rent and market rent. From an underwriting perspective, this means the income stream is effectively fixed at the option rent for the renewal period, and any projection of market rent uplift in that space must be deferred to the end of the option term.
The reverse situation — above-market renewal options — is less common but worth identifying. A tenant holding a renewal option at a rent that exceeds projected market will rationally decline to exercise, creating a rollover event at a time when comparable space may be leasing below their option price. That scenario needs to be modeled as a vacancy and re-leasing event rather than as a renewal.
First-right-of-refusal clauses and expansion options add further complexity. A major tenant holding a right of first refusal on adjacent space constrains the landlord's ability to lease that space to another tenant, effectively reserving it as optionality. Capital markets teams should catalog all such rights across the rent roll, because they can prevent the creation of the large contiguous blocks that command premium rents from institutional users.
The option analysis should culminate in a probability-weighted scenario tree for each option-bearing lease. Assigning renewal probabilities based on the tenant's space utilization, lease economics, and industry dynamics produces a more defensible underwriting than simply assuming all options are or are not exercised.
Concentration Risk and the Single-Tenant Cliff
Concentration in the expiration schedule creates what practitioners call the single-tenant cliff — a moment in the projected hold period where a disproportionate share of income is at risk in a single event. A building where one tenant represents forty percent of gross revenue with a lease expiring in year three of a projected five-year hold presents a fundamentally different risk profile from a building where no single tenant exceeds twelve percent of gross revenue.
The cliff is particularly acute in net-lease assets where the entire property is leased to a single tenant and the expiration is contemporaneous with or occurs before the anticipated disposition date. In that structure, the exit cap rate applied by a prospective buyer will reflect the residual term at sale, and a short residual term at exit will compress the sale price even if the tenant has strong credit and high renewal probability.
For multi-tenant assets, the concentration analysis should include not just the largest tenant but also industry concentration. A portfolio-strategy question that experienced capital markets advisers ask is whether multiple tenants in the same sector — technology, healthcare, professional services — share correlated rollover risk. If economic conditions affecting that sector deteriorate, co-movement in tenant decisions may create simultaneous vacancies that the model treats as independent events.
Stress-testing concentration risk requires building a downside scenario in which the concentrated tenant vacates at expiration. That scenario should carry explicit assumptions for downtime, re-leasing costs, and the rent achievable for the space in its delivered condition. A space built out for a specialized user — trading floors, medical exam rooms, call-center density — may require significant capital to re-configure for a general-office tenant, and those costs belong in the downside scenario.
Understanding How Capital Markets Teams Should Read Lease Expiration Profiles in Underwriting at the Portfolio Level
The question of how capital markets teams should read lease expiration profiles in underwriting becomes considerably more complex when the subject is not a single asset but a portfolio. A portfolio acquisition requires a view of aggregate rollover exposure by year, because the investor's capital requirement for re-leasing costs across the portfolio in any given year is the sum of all individual asset rollover events falling in that year.
Portfolio-level expiration analysis should produce a heat map that shows, by year, what percentage of total portfolio income is subject to rollover. A portfolio where twenty-five percent of gross income expires in year two and another twenty percent expires in year three presents a very different capital planning challenge from one with a balanced five-to-seven percent rolling off each year over a ten-year horizon.
The portfolio view also reveals cross-asset diversification effects. Geographic diversification across markets with different leasing velocity — the speed at which vacant space is absorbed — changes the downtime distribution significantly. An expiration in a high-demand submarket with limited competitive supply may re-lease in under three months, while the same expiration in an oversupplied secondary market may carry a twelve-to-eighteen month downtime assumption. Averaging these together without disaggregating by market systematically distorts the model.
Critical Date Management as an Underwriting Input
Lease expirations are not the only critical dates that affect rollover risk analysis. Notice periods for renewal options — often six to twelve months before lease end — represent decision points where the tenant must elect to renew or vacate. These notice periods are frequently missed in underwriting because they sit inside the lease term and do not appear on the expiration schedule.
A tenant who fails to deliver a renewal notice by the contractual deadline may forfeit the renewal option, converting a soft expiration into a hard one. Conversely, a landlord who fails to respond to a tenant's renewal notice within the required window may inadvertently bind the property to a renewal at terms less favorable than market. These mechanical risks are real, and a capital markets team's due diligence should include a critical-date audit that maps every notice obligation and response deadline across the rent roll.
Rent escalation dates are a related category. Many leases contain annual rent steps or Consumer Price Index escalations that are not automatic — they require the landlord to issue a notice within a specified window. Missing those notices forfeits the escalation for that period and, in some jurisdictions, may waive the escalation permanently under estoppel principles. The underwriting model should assume current in-place rents rather than projected escalated rents unless the escalation mechanism has been verified as automatic.
Underwriting Assumptions: Market Rent, Absorption, and Lease-Up Scenarios
The final and most consequential inputs into rollover underwriting are the market rent and absorption assumptions that govern what happens after each lease expires. These assumptions are forward-looking and inherently uncertain, which makes the methodology for building them more important than any individual number.
Market rent assumptions should be grounded in a formal comparable lease analysis — a survey of leases signed within the competitive set for the subject property over the prior twelve to twenty-four months, adjusted for lease size, floor, condition, term, and concession package. Using list rents or asking rents from current availabilities systematically overstates achievable rents because they represent the landlord's opening position rather than the transaction outcome.
Absorption assumptions determine the downtime period between expiration and new-tenant commencement. These should be calibrated to the size of the space being underwritten — larger blocks take longer to lease — and to the submarket's historical vacancy and net absorption data. A capital markets team building absorption assumptions from observation of a single recent transaction rather than from a trend analysis is anchoring to a potentially unrepresentative data point.
Lease-up scenarios should be presented in at least three versions: a base case that reflects current market conditions with a modest upward bias if the hold period extends beyond the near-term, a downside that assumes a ten-to-fifteen percent reduction in achievable rent and a fifty-percent extension of the projected downtime, and an upside that reflects tightening supply and rising demand. The spread between these scenarios is the honest representation of the uncertainty the investor is accepting.
Connecting the Analysis to Disposition Strategy
Lease expiration profiles do not just affect income during the hold period — they shape the exit valuation fundamentally. A buyer acquiring the asset at the projected disposition date will apply a cap rate to the forward net operating income, and that income will reflect whatever lease-up or rollover events have occurred during the hold period.
If the capital markets team projects that a major tenant will renew at market rent during the hold period, the exit NOI is meaningfully higher than the current in-place NOI, and the strategy implicitly assumes the team will have successfully re-leased or renewed that space before marketing the asset. If that renewal does not occur, the exit strategy must shift — either accept a lower price reflecting the rollover risk, or extend the hold period to complete the leasing before disposition.
This dynamic is why experienced advisers model the exit as a function of the projected lease-up state at disposition, not simply as a cap-rate application to stabilized NOI. The model should carry a separate schedule showing the projected rent roll at disposition, including any leases signed during the hold period, any options exercised, and any vacancies remaining at sale.
Due Diligence Verification: Trust but Verify the Rent Roll
Every underwriting assumption built on the lease expiration profile is only as good as the accuracy of the source document. Rent rolls provided in offering materials are prepared by the seller and are not always current, complete, or consistent with the actual lease documents. The due diligence process must include a side-by-side reconciliation of the rent roll against every executed lease, amendment, and estoppel certificate.
Common discrepancies between rent rolls and lease documents include unreported termination options, escalation clauses that the rent roll reflects at the current-year figure rather than the fully escalated rate, and square footage discrepancies arising from re-measurements or demising changes that occurred after the original lease was signed.
Estoppel certificates signed by tenants are the authoritative source for the tenant's understanding of the lease terms, and they are particularly important for identifying disputes, claims, or side agreements that do not appear in the executed lease document. A tenant who signs an estoppel citing an unresolved landlord default is communicating material information about future rollover risk that must be reflected in the underwriting.
The verification discipline applies equally to options. Every renewal option, termination option, and expansion right in the rent roll should be traced to the specific lease provision, with the notice deadline and exercise conditions confirmed. This process is painstaking, but skipping it is how capital markets teams acquire surprise rollover events that were visible in the documents all along.
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.