Comparing multiple locations on a single financial basis is one of the most technically demanding tasks in corporate real estate, and it is also one of the most consequential. A misstep in how you structure the comparison — mismatched base years, ignored operating escalations, inconsistent capital assumptions — can make an expensive option look cheap and cause an organization to sign a lease it will regret for a decade.
Why Occupancy Cost Analysis Fails Without a Framework
Most location comparisons fail before the spreadsheet is even opened. The failure happens during scope definition: teams collect proposals from different landlords, each structured differently, and attempt to compare them line by line without first establishing a common structure for what "cost" means.
A gross lease proposal in one market and a triple-net proposal in another are not directly comparable at face value. The gross lease may appear higher on a per-square-foot basis but could carry fewer variable obligations. The triple-net lease may advertise a lower base rent while transferring meaningful operating expense risk to the occupier.
The foundation of any sound comparison is a total occupancy cost model — one that captures every cash outflow associated with holding, operating, and exiting a space over the full lease term. This goes well beyond base rent to include operating expense passthroughs, capital expenditures, tax obligations, parking, utilities, and any costs associated with the fit-out and eventual restoration of the premises.
Teams that skip this foundation produce comparisons that are superficially tidy but analytically hollow. A one-page summary showing "Year One Rent: $X" tells a decision-maker almost nothing about the true financial commitment of each option.
Establishing a Common Lease Term for the Comparison
Before any numbers are entered, the analysis must establish a common comparison period. If one location offers a seven-year term and another offers a ten-year term, comparing total costs over different durations produces a meaningless result. The standard practice is to set a common analysis period — typically the longest term under consideration — and then model what happens at the end of shorter terms.
For the location with the shorter lease, the model should include either an assumed renewal at a market rent (clearly labeled as a projection) or a vacancy period and relocation cost to reflect the realistic scenario. Neither assumption is objectively correct; what matters is that both options are subjected to the same treatment so the comparison is fair.
This common-period discipline also forces the team to confront a question many overlook: what is the probability of actually occupying each space for the full assumed term? A location that requires a ten-year commitment when the organization's planning horizon is five years carries optionality risk that does not appear in a static rent schedule. That risk has economic value and should be noted in the analysis narrative even if it cannot be precisely quantified.
Mapping Every Cost Category Before Building the Model
A robust total occupancy cost model contains more line items than most teams initially expect. Base rent and operating expense recoveries are the obvious starting points. Beyond those, the model should capture real estate taxes (either embedded in gross rent or assessed separately), building insurance allocations, janitorial and utilities where the lease places those obligations on the tenant, parking fees, and any supplemental amenity charges.
Capital costs deserve their own section. Tenant improvement allowances reduce upfront capital requirements but often come with conditions — clawback provisions, construction milestones, landlord approval rights — that affect timing and certainty. The model should net the allowance against the anticipated fit-out cost and carry any gap as a capital outflow in Year Zero.
Restoration obligations are another category that practitioners frequently undervalue at the time of signing. Many leases require the tenant to remove specialty improvements and return the space to its original condition. In a laboratory, data center, or heavily built-out office, that obligation can reach meaningful sums. Every proposal in the comparison should be reviewed for reinstatement language, and a cost estimate should be carried as a terminal cash outflow in the final year of the modeled term.
Moving costs, transition costs, and productivity disruptions are harder to quantify but should be addressed qualitatively in any presentation to decision-makers. A location that requires a disruptive phased move during a critical business period carries a real but difficult-to-monetize cost. The model should flag this rather than pretend it does not exist.
Calculating Effective Rent as a Screening Metric
Effective rent is the starting point for most practitioners when they first receive competing proposals. It takes the total rent obligation over the term — net of landlord concessions such as free rent periods and tenant improvement allowances — and converts that total into an average annual or monthly figure expressed in per-square-foot terms.
The calculation is straightforward: add all scheduled base rent payments, subtract the present value of concessions, and divide by the rentable square footage and the number of years in the term. The result is a single number that allows a rough apples-to-apples comparison of competing proposals when the lease structures are broadly similar.
Effective rent is a useful screening tool but a poor final decision metric. It ignores the time value of money, treats a dollar of rent in Year One the same as a dollar in Year Ten, and does not capture operating expense risk or capital variability. Analysts who stop at effective rent are looking at a sketch when they need an engineering drawing.
Nonetheless, effective rent serves a practical purpose in early rounds of negotiation. It gives the occupier a way to quickly rank proposals and decide which deserve deeper modeling. The key is treating it as a filter, not a conclusion.
Building the Net Present Value Model
Lease net present value is the analytical workhorse of occupancy cost comparison. The NPV model discounts all future cash outflows associated with each option back to a common base date, using a discount rate that reflects the organization's cost of capital or its hurdle rate for real estate commitments.
The choice of discount rate matters more than many practitioners acknowledge. A high discount rate makes near-term costs more significant relative to later-year costs, which tends to favor options with back-loaded rent schedules or generous free rent periods at the front of the term. A low discount rate treats near-term and long-term costs more equally, which benefits options with stable, predictable rent escalation.
The standard practice in corporate occupier analysis is to use the organization's weighted average cost of capital or, where that is not available, a rate that reflects the risk profile of the cash flows. Some teams use a blended borrowing rate. What matters most is that the same rate is applied consistently across every option being compared.
Once the discount rate is established, the model should discount each year's total occupancy cost — not just rent, but every cash outflow identified in the cost-mapping phase — back to Year Zero. The option with the lowest NPV of total occupancy costs represents the most economical choice under the modeled assumptions. That result should then be stress-tested with sensitivity analysis, which is addressed in a later section.
Accounting for Operating Expense Escalation
Operating expense passthroughs are one of the most consequential and least understood components of commercial lease economics. In a modified gross or net lease, the tenant pays a base year or base stop amount and is responsible for any increases above that level. In a full gross lease, the landlord typically absorbs operating expense growth, though this risk is often priced into the base rent.
The modeled escalation rate for operating expenses should be drawn from historical data for the submarket and property type, and should be clearly labeled as an assumption. Using an optimistic escalation assumption — or none at all — systematically understates the long-term cost of net and modified gross leases relative to gross alternatives.
A common mistake is applying the same escalation assumption to all properties in the comparison regardless of their lease structure, building class, or market. A Class A tower with significant common area amenities will have a different operating expense trajectory than a suburban flex building. The model should reflect those structural differences, even if it requires separate escalation assumptions for each option.
Operating expense base years are another technical trap. If one proposal uses a calendar-year base and another uses a lease-year base, the effective exposure is different even if the stated base amounts are identical. The comparison model should normalize all proposals to the same base year convention before drawing conclusions.
Normalizing for Size Differences Across Options
Rarely do competing locations offer exactly the same usable square footage. Differences in floor plate efficiency, loss factor, and load factor mean that two buildings offering nominally similar rentable square footage may deliver meaningfully different usable space. The occupier's occupancy cost model should include a usable-square-foot analysis alongside the rentable-square-foot analysis.
The load factor — the ratio of rentable to usable square footage — varies by building type, floor configuration, and landlord measurement methodology. A building with a fifteen percent load factor and another with a twenty-two percent load factor are not offering the same value at the same per-square-foot rent. Converting all proposals to a cost-per-usable-square-foot basis is a standard normalization step that many in-house teams skip.
Efficiency also affects headcount planning. If one location's floor plate allows forty-five workstations per floor and another allows only thirty-eight with the same footprint, the operationally appropriate footprint at each location may differ. The model should be built to the organization's actual seat requirements, not the nominal square footage in each proposal.
Where size differences are significant, the model should also consider whether multiple floors or a phased build-out is involved, because those scenarios introduce different capital timelines and operational complexities that affect the total cost comparison.
Incorporating Incentives, Abatements, and Public Benefits
Location comparisons that span different municipalities or regions must account for economic incentives, tax abatements, and public assistance programs. These can materially alter the economics of a location that might otherwise appear less competitive on a pure rent basis.
State and local incentive programs vary widely in structure, certainty, and duration. Some are statutory entitlements triggered by meeting employment or capital investment thresholds; others are discretionary grants awarded through a negotiated process with no guaranteed outcome. The analysis should distinguish between incentives that are contractually committed at the time of decision and those that are contingent on future performance.
Operating expense savings tied to location also belong in the model. Real estate tax rates, utility rates, labor cost differentials, and logistics costs vary by market and can be significant for operations-intensive users. These are not strictly lease economics, but they belong in any complete occupancy cost comparison that is meant to inform a location decision rather than simply a lease negotiation.
The model should present incentives and location-based savings as a separate section rather than netting them against base rent. Decision-makers need to see both the gross occupancy cost of each option and the net-of-incentives cost, because the assumptions underlying each are different and carry different levels of certainty.
How to Compare Occupancy Costs Across Alternative Locations Using a Scoring Matrix
When the total occupancy cost NPVs of two or more options are close — within a margin that sensitivity analysis cannot reliably resolve — the decision requires a broader framework. A weighted scoring matrix brings qualitative and semi-quantitative factors into the comparison alongside the financial model.
The scoring matrix assigns weights to criteria that matter to the organization: proximity to talent, transportation access, brand presentation, flexibility provisions, lease term optionality, and landlord financial stability, among others. Each option is scored against each criterion, and the weighted scores are summed to produce a composite result. The financial NPV is typically treated as one heavily weighted criterion within the matrix rather than a separate analysis.
The discipline of building a scoring matrix forces the real estate team and its internal stakeholders to agree on priorities before they see the numbers. When stakeholders are shown results without having declared their weights in advance, they tend to reweight the criteria to favor the option they already prefer — a well-documented bias in group decision-making. Setting weights first and scores second produces a more defensible recommendation.
The scoring matrix should be presented transparently, showing both the weights and the scores for every criterion. Decision-makers should be able to trace exactly why one option outranked another, and they should be able to adjust weights interactively to see how sensitive the ranking is to changes in priority. This transparency is what transforms an analysis into a recommendation that a leadership team will trust and act on.
Sensitivity Analysis and Scenario Planning
No occupancy cost model is more accurate than its assumptions, and assumptions in real estate are always uncertain. Sensitivity analysis is the discipline of testing how the NPV ranking of competing options changes when key assumptions are varied.
The most important variables to stress-test are the discount rate, the operating expense escalation rate, the anticipated holding period, and the cost and timing of tenant improvements. For each variable, the analyst should identify the range of plausible values — not arbitrary extremes — and recalculate the NPV of each option across that range.
The output of sensitivity analysis is not a single answer but a picture of the conditions under which each option is financially superior. If Option A is cheaper than Option B across most of the plausible range for every key variable, the case for Option A is strong. If the ranking flips under several realistic scenarios, the decision is genuinely close and the qualitative factors in the scoring matrix carry more weight.
Scenario planning takes sensitivity analysis one step further by modeling discrete future states — a lease renewal, a sublease of excess space, an early termination — and attaching probabilities to them. This approach is particularly useful when the organization faces meaningful uncertainty about its space needs over the comparison period.
Presenting the Analysis to Decision-Makers
An occupancy cost comparison that lives only in a complex spreadsheet will not drive a decision. The presentation layer — the summary that reaches executives and boards — must distill the analysis into a clear narrative without hiding the assumptions that underlie it.
The summary should lead with the NPV of each option and immediately note the key assumptions on which that ranking rests. It should then present the sensitivity ranges, flagging the conditions under which the ranking might change. The scoring matrix results should follow, with the composite scores for each option shown alongside the financial comparison.
Every financial figure in the summary should trace back to a documented source or assumption in the underlying model. Decision-makers who want to probe a number should be able to find its source without assistance from the analyst. This standard of transparency is what separates a professional occupancy cost comparison from a back-of-envelope estimate dressed up as analysis.
The narrative should close with a clear recommendation, stated plainly, with the primary reason the recommended option is preferred. A recommendation buried in qualifications is not a recommendation — it is a description of uncertainty. The analyst's job is to make the uncertainty visible and then commit to the option that performs best across the most plausible range of conditions.
Managing the Comparison Through Negotiation
An occupancy cost comparison is not a static document produced once and filed away. It is a living analysis that must be updated as proposals are revised, concessions are negotiated, and market conditions shift. Building the model so that it can be refreshed quickly is as important as building it correctly in the first place.
Version control is essential. Each revision to the model should be saved as a distinct version with a clear notation of what changed and why. When a landlord improves a proposal — adding tenant improvement allowance, offering a rent abatement period, reducing escalation caps — the updated version should recalculate the NPV impact of those changes immediately so the team can evaluate the economic improvement in real time.
This live-update discipline also protects the occupier from a common negotiation tactic: proposals that are improved in one dimension while quietly worsened in another. A landlord who increases the tenant improvement allowance while also tightening the operating expense base year has made a trade that may or may not benefit the occupier. The model makes that trade visible.
Aligning the Analysis with Portfolio Strategy
A location decision is rarely made in isolation. The chosen location becomes a portfolio asset that interacts with the organization's other occupancies: it creates a critical date, an obligation, and a financial commitment that must be tracked and managed for the full lease term.
Before the comparison is finalized, the real estate team should map the proposed commitment against the organization's existing lease expiration schedule. A ten-year commitment that begins just as another major lease expires in the same market may create concentration risk. A five-year term in a market where the organization is already underweight may align well with a portfolio rebalancing objective.
The occupancy cost model is also the foundation for future portfolio reporting. The assumptions built into the comparison — particularly the operating expense escalation rates and capital expenditure schedules — should be carried forward into the organization's portfolio cost tracking once the lease is executed. Starting the portfolio record with the assumptions that informed the decision creates continuity between the underwriting phase and the management phase.
Building the Team and the Data Infrastructure
The quality of an occupancy cost comparison depends on the quality of the data that feeds it. For a rigorous comparison, the team needs access to lease abstracts for comparable properties, operating expense history for the buildings under consideration, local market rent surveys, and — where relevant — municipal tax rate schedules and utility tariff structures.
Sourcing this data is not always straightforward. Landlords may provide operating expense histories selectively, emphasizing periods that are favorable to their proposals. Independent market data from brokers, appraisers, or data providers is essential for calibrating the assumptions used in the model. Where independent data is not available, the model's sensitivity analysis should widen the range of assumptions tested.
The team producing the comparison should include someone with direct lease analysis software experience — not because the software does the thinking, but because a practitioner who has built and stress-tested occupancy cost models understands where the structural errors tend to occur. The most dangerous errors in these models are not arithmetic mistakes, which are visible, but structural errors in how costs are categorized, how base years are defined, or how escalation compounds.
Documenting the Decision for Future Reference
A well-constructed occupancy cost comparison has value beyond the immediate decision. It creates a record of why a particular location was chosen, what the assumptions were at the time, and what alternatives were considered and rejected. That record becomes important when the lease reaches renewal, when the organization undertakes a portfolio review, or when an internal audit team asks why a particular commitment was made.
The documentation should include the final version of the NPV model, the scoring matrix with weights and scores, the sensitivity analysis output, and a written narrative that summarizes the recommendation and its basis. These materials should be stored with the lease documents so that whoever manages the commitment in three or five years has access to the original decision logic.
Many organizations treat the occupancy cost comparison as a deliverable to be produced for a single approval meeting and then discarded. That practice creates a knowledge gap that becomes apparent only when renewal negotiations begin and no one can reconstruct the original underwriting. Treating the analysis as a permanent record, updated as the lease evolves, is the professional standard that distinguishes mature real estate functions from reactive ones.
The lease-economics framework built into the initial comparison — the NPV structure, the escalation assumptions, the capital schedule — can also serve as the baseline for lease accounting compliance, where organizations are required to carry the present value of future lease obligations on their balance sheets. Starting with a rigorous comparison model makes the accounting work significantly easier and more defensible.
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.