The decision to acquire a multi-tenant industrial property lives or dies on the quality of the lease-by-lease analysis that sits behind the headline numbers. Aggregate figures — a blended cap rate, a single stabilized NOI — obscure the lease-economics that actually determine whether the asset performs across a full hold period. Knowing how to model a multi-tenant industrial purchase lease by lease is the discipline that separates a well-underwritten acquisition from a costly surprise.
Why Lease-by-Lease Analysis Changes the Acquisition Decision
Industrial properties often appear straightforward from the outside. A rent roll with eight or ten tenants, most at market, looks stable until you examine lease terms individually. The moment you disaggregate the income stream, patterns emerge that an average-rent assumption buries.
A single anchor tenant at a below-market rent with four years remaining on a fixed option to renew can suppress NOI for a decade. A cluster of month-to-month tenants in the smallest bays creates rollover risk that is invisible in the stabilized yield. Neither shows up in a blended cap rate.
Lease-by-lease modeling forces every assumption to be tied to a specific lease document, a specific tenant, and a specific space. The discipline of doing this up front is what makes a purchase price defensible to an investment committee and a lender — not just to the seller.
Assembling the Rent Roll Correctly
The foundation is a clean, verified rent roll. Obtain the actual executed lease and all amendments for every occupied suite, not a summary spreadsheet prepared by the seller's broker. Summary sheets introduce errors, omit options, and misstate rent-escalation schedules.
For each lease, record the tenant name, suite number, rentable square footage, base rent per square foot, annual escalation method (fixed percentage, CPI, or step schedule), lease commencement date, expiration date, and renewal or expansion option terms. Also record whether the lease is gross, modified gross, net, double-net, or triple-net, because the expense reimbursement structure changes how income behaves.
Confirm square footage against the building's floor plan. Leases occasionally reference a measured area that differs from the stacking plan, and that discrepancy creates reimbursement errors if left uncorrected. Rentable area is the contractual denominator for most industrial expense-recovery calculations.
Vacant suites must be included at zero revenue with an estimated downtime and re-leasing assumption. Leaving them out of the model understates capital requirements and overstates stabilized yield.
Mapping Lease Expirations Across the Hold Period
Once every lease is documented, build a timeline that plots each expiration date across the projected hold, typically five to ten years. The goal is to see how much square footage is rolling in any given year and whether concentrations create cliff risk.
A hypothetical example: if three of eight leases expire in year two, and those three collectively represent 55 percent of total rentable area, the asset carries meaningful re-leasing execution risk in that window. A model that smears the rollover evenly across the hold period fails to capture that concentration.
Color-code each expiration by lease type. Triple-net leases rolling to market present different economics than gross leases where the landlord has been absorbing expense growth. Knowing which type of lease is expiring changes how you model the re-leasing cost and the new rent level.
Renewal options with fixed rent caps deserve separate treatment. If a tenant has an option to renew at the lesser of market or a specified maximum rate, model both scenarios — exercised at the cap and exercised at market — and present the spread. That spread is a risk that must be reflected in the purchase price negotiation.
Modeling Rent Escalations Lease by Lease
Each active lease will escalate rent by one of three mechanisms: a fixed annual percentage (commonly two or three percent in industrial), a step schedule written into the lease, or a CPI-linked adjustment. Each requires a different modeling treatment.
For fixed-percentage escalations, compound the base rent forward from the lease commencement date using the stated rate. Do not use the passing rent as the base unless you have confirmed it already reflects all prior escalations. Errors here produce incorrect breakeven analyses and misstated future NOI.
For step schedules, extract each contractual step and enter it on the exact date it takes effect. Interpolating steps as smooth annual growth introduces timing errors that compound over a multi-year hold. The difference between a step effective January 1 versus July 1 of a given year is half a year's income at the higher rate.
CPI-linked leases require a separate assumption for the index. Use published federal CPI data as a reference point for your base scenario and sensitize the assumption with a low, mid, and high inflation case. Never invent an index forecast — label it clearly as a hypothetical scenario and document the source.
Understanding Expense Structures Across Lease Types
Industrial properties carry a spectrum of lease structures, and a multi-tenant building often has more than one type in force simultaneously. The expense reimbursement model for each tenant determines how much of the net operating income is actually landlord-retained income.
In a triple-net lease, the tenant pays its pro-rata share of property taxes, insurance, and operating expenses. The landlord's income closely matches base rent, except for management fees and any landlord-side capital expenditures that leases exclude from recoveries. Model gross revenue and expense reimbursements separately — do not net them in a single line without documentation.
In a modified gross lease, the landlord absorbs some expense categories — often utilities or janitorial — and the tenant pays others. Identify precisely which categories are gross-up items and which are reimbursed. Mistakes here either overstate recoveries or understate landlord expense.
Gross leases place the full operating cost risk on the landlord. For suites with gross leases expiring, underwrite the re-leasing assumption to reflect whether the market supports a conversion to net or whether the tenant profile in that bay demands gross treatment. Forcing a gross-to-net conversion into the model without market evidence is an unsupported assumption.
Projecting Vacancy and Downtime by Suite
Aggregate vacancy rate assumptions — applying a single stabilized vacancy rate to the whole building — mask the uneven distribution of rollover risk. Build a vacancy schedule that ties to each lease expiration.
For each expiring lease, model a downtime period between the old lease and the new one. Industrial re-leasing timelines vary by market, suite size, and clear height. Smaller bays in secondary markets may carry longer downtime than bulk distribution space in primary logistics corridors. Without documented market data to support a specific period, label the assumption clearly and sensitize it.
Also model a lease-up cost for each vacant suite: tenant improvement allowance per square foot and leasing commission as a percentage of total lease value or a dollar amount per square foot of term. These are capital costs that reduce net cash flow and affect the internal rate of return even if they do not appear in an operating income line.
Consider whether any currently occupied suites have below-market tenant improvement allowances from prior lease cycles. A tenant renewing at market who also negotiates a full TI package represents a combined economic cost — higher TI plus the revenue gap — that the acquisition model must absorb.
Building the Lease-by-Lease NOI Model
With rent escalations, expense structures, vacancy downtimes, and re-leasing costs mapped for every suite, the lease-by-lease NOI model assembles naturally. The annual NOI for the building is the sum of each suite's contribution, year by year, across the hold.
For each suite, the annual contribution equals base rent at the applicable escalation step, plus expense reimbursements under the lease terms, minus the landlord's unreimbursed operating expenses attributable to that suite, minus any management fee allocation. Vacant period months contribute zero rent and zero recoveries but carry vacancy-period operating costs.
Aggregate the per-suite annual figures into a total gross potential revenue, subtract vacancy and credit loss, add recoveries, subtract operating expenses, and arrive at NOI. Present this as a year-by-year table across the full hold period, not just at stabilization. A single stabilized NOI figure is a summary, not a model.
The lease-by-lease structure is what allows you to test sensitivity. When you adjust one tenant's downtime assumption, the impact flows only through that suite's row, leaving others intact. That granularity makes the model defensible and makes committee questions answerable.
Capitalizing NOI Into a Purchase Price Analysis
Once the year-by-year NOI is modeled, the going-in cap rate and the stabilized cap rate can be calculated with precision. The going-in cap rate divides the current-year NOI by the proposed purchase price. The stabilized cap rate uses the NOI at the point where current lease-up and rollover assumptions have been absorbed.
If the building has significant near-term rollover, the spread between going-in and stabilized NOI may be wide. That spread represents the execution risk the buyer is accepting. Price should reflect the cost of capital deployed during the lease-up period plus an appropriate risk premium.
Also compute the price per square foot implied by the purchase price and compare it to documented replacement cost and comparable sale transactions in the market. If the implied cap rate requires assumptions materially above current market leasing rates, the acquisition underwriting is not conservative — it is a projection of optimism.
Sensitize the stabilized cap rate across a range of exit cap rates. If the hold-period exit requires the same or a tighter cap rate than entry to generate an acceptable return, the model has limited margin of safety. Industrial cap rates respond to interest rate movements, logistics demand cycles, and local supply pipelines, none of which are within the buyer's control.
Modeling the Levered and Unlevered Return
A multi-tenant industrial acquisition analysis should produce both unlevered and levered return metrics. The unlevered internal rate of return treats the asset as an all-equity purchase and isolates the property's performance from financing effects. The levered IRR introduces debt service, loan fees, and the refinancing or payoff at disposition.
For each year of the hold, the unlevered cash flow equals NOI minus capital expenditures, including TI and leasing commissions modeled in the vacancy and re-leasing schedule. The unlevered IRR discounts those cash flows against the initial equity investment.
Debt assumptions — loan-to-value, interest rate, amortization term, and any floating rate caps — must be documented explicitly. If the acquisition is modeled using a floating rate, sensitize the return across rate scenarios using an appropriate range. Do not model only the current rate without testing adverse movement, particularly over holds of five years or more.
The reversion cash flow at exit is typically computed by applying a terminal cap rate to the final year's NOI, then netting brokerage costs and any disposition costs. Document the terminal cap rate assumption as separate from the in-place market cap rate, with reasoning for the spread between them.
Stress-Testing the Model
No acquisition model is complete without stress scenarios. The lease-by-lease structure makes stress-testing tractable because each assumption can be moved independently. The most consequential scenarios to test in a multi-tenant industrial context include extended downtime for the two largest expiring suites, below-budget re-leasing rents for the suites most at risk of below-market rollover, and adverse movement in operating expense recoveries if gross leases dominate.
A meaningful stress case is one that remains plausible given documented market conditions — not an extreme shock for optics, but a scenario a rational market participant would consider possible within the hold period. If the levered IRR turns negative under a plausible stress case, the buyer must decide whether the upside in the base case justifies that asymmetric downside.
Stress-testing also reveals where the model is most sensitive. If a single tenant's renewal decision drives most of the variation in returns, that is a concentration risk that can be addressed in lease negotiations or in price renegotiation. Finding it in the model before closing is the value of building the analysis correctly.
Choosing the Right Modeling Environment
The environment in which a lease-by-lease industrial model is built matters as much as the methodology itself. A model that works correctly in one analyst's hands but breaks when another team member updates an assumption is not a reliable decision-support tool. Version discipline and formula integrity are prerequisites, not afterthoughts.
Spreadsheet-based models remain common for industrial acquisitions because they allow full customization of the row-by-row lease structure. The key discipline is locking formula cells, using named ranges for shared assumptions, and saving timestamped versions at each major milestone — LOI, final diligence, and close. Without those controls, an escalation formula silently overwritten by a manual entry can produce misstated NOI across the entire hold.
Whatever environment a team uses, the model must be auditable. Every cell that contains an assumption rather than a formula derivation should be labeled and sourced. An auditable model withstands lender review, equity partner scrutiny, and the team's own revisit six months into the hold when market conditions have shifted.
Presenting the Analysis to Investment Committees
An investment committee needs to see the lease-by-lease logic without wading through every row of the model. The most effective presentation format includes a one-page rent roll summary showing each tenant, square footage, current rent, expiration date, and next-event risk, followed by a year-by-year NOI summary and a return table showing base, upside, and stress case IRRs.
The base case should represent the most likely outcome, documented with market evidence for every material assumption. Where market evidence is limited — in thin industrial submarkets or for unusual suite configurations — label the assumption clearly and note the market data limitations.
Present the lease-economics drivers explicitly: which leases are below market, which are above, which carry options that constrain the upside, and which present the most significant re-leasing execution risk. A committee that understands the lease-by-lease risk profile makes a better-informed decision and is more likely to close quickly once the diligence confirms the assumptions.
The lease-by-lease methodology is also the foundation of lender underwriting. Industrial lenders increasingly require this level of granularity in their own credit analysis, which means a well-prepared lease-by-lease model accelerates the financing process and reduces requests for additional information.
Connecting the Acquisition Model to Ongoing Asset Management
The acquisition model does not close its useful life at closing. A lease-by-lease model that is maintained through the hold period becomes a living operating reference for the asset management team. Each lease event — an escalation date, a renewal notice deadline, an option exercise window — is already documented in the model and can be tracked against actual performance.
When actual rent collections, expense reimbursements, and vacancy durations are entered against the original projections, the model becomes a variance analysis tool. Deviations from underwriting surface early, before they compound into material NOI shortfalls. That early visibility is what allows an asset manager to respond — renegotiating a renewal, accelerating a lease-up campaign, or adjusting the capital expenditure plan.
The handoff between acquisition underwriting and asset management is one of the highest-risk transitions in a commercial real estate investment. When the people who built the model are no longer the people managing the asset, the assumptions embedded in the financial analysis can be lost. A well-structured, documented lease-by-lease model that travels with the asset — rather than living in one analyst's workbook — is a material operational advantage.
Documenting Assumptions for Diligence and Compliance
Every acquisition model is eventually tested in diligence. Lenders, equity partners, and institutional investors will request the assumption documentation that sits behind the financial projections. Building that documentation into the model from the beginning — not reconstructing it after the LOI is signed — saves significant time and credibility.
For each material assumption in the lease-by-lease model, record the source: a comparable lease transaction, a broker opinion of market rent, a published operating expense benchmark, or a quoted contractor estimate for TI build-out. Where the source is an adviser's judgment rather than documented evidence, say so explicitly rather than presenting the assumption as market-derived.
Document every renewal option, right of first refusal, right of first offer, and co-tenancy clause. These contractual provisions can materially affect the valuation and the buyer's ability to re-lease space or sell the asset. A right of first refusal on a large bay, for example, may effectively limit the buyer's ability to execute certain capital strategies.
Discovering these provisions in diligence rather than in underwriting is a recoverable situation, but it is an avoidable one. The diligence process should use a systematic review of each lease against the rent roll representations made at LOI. Any variance between the lease terms and the seller's representations is a potential price adjustment point.
That sequence — documentation before modeling, not alongside it — is where many teams recover both time and negotiating leverage.
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.