Why Consolidation Analysis Fails Before It Starts
Corporate real estate consolidation decisions are routinely under-modeled. Teams spend significant energy negotiating new lease terms while spending far less on the quantitative question that actually governs whether consolidation creates value: does the present value of recurring savings exceed the present value of one-time transition costs, and over what horizon? Without a structured answer to that question, approvals rest on intuition rather than arithmetic.
The failure usually happens at the scoping stage. Analysts identify the obvious savings — lower rent per square foot, fewer leases to administer — but stop short of cataloguing the full cost inventory. Moving costs, temporary swing space, tenant improvement write-offs, early termination penalties, and technology infrastructure relocation all carry real dollar values that can dwarf a first-year rent saving. A methodology that leaves any of those out produces a model that flatters the decision.
The second failure is the discount rate. Consolidation projects often span three to five years from announcement to stabilization. Applying a corporate weighted-average cost of capital to a real estate cash flow series is not always the right choice; some organizations use a hurdle rate, others a risk-adjusted real estate discount rate. The methodology must make the rate selection explicit and defensible, because the choice meaningfully changes the net present value calculation and the stated payback period.
Building the Savings Inventory
Before any numbers enter a spreadsheet, the team must construct an exhaustive savings inventory organized by category and timing. The four primary categories are occupancy cost reduction, headcount and facilities management reduction, portfolio administration simplification, and capital avoidance. Each category needs a gross annual figure, a start date, and a confidence rating.
Occupancy cost reduction is the most visible component. Take the current total occupancy cost across all locations being consolidated — base rent, operating expenses, parking, and any above-market tenant improvement amortization embedded in the rent — and compare it to the projected total occupancy cost in the consolidated location. The difference, expressed on a per-year basis, is the gross occupancy saving. To illustrate the structure: if gross occupancy cost today is $4.2 million across three leases and the consolidated lease projects to $3.1 million, the gross annual saving is $1.1 million.
Facilities management savings require a staffing analysis. Three separately managed locations each require on-site management capacity that a single larger location may not. Quantify full-time equivalents and their fully loaded compensation, then apply a realistic reduction percentage based on the new location's management structure. Never assume 100 percent headcount elimination; a consolidation typically changes the headcount ratio, not the entire function.
Portfolio administration savings are smaller but real. Three lease abstracts, three critical-date calendars, three sets of CAM reconciliations, and three landlord relationships each consume adviser and staff time. Assign an hourly rate to administrative time and estimate annual hours per location. The resulting dollar figure is modest compared to rent savings, but leaving it out creates a pattern of underestimating total benefit.
Capital avoidance belongs in the savings inventory when one of the existing locations is approaching a renewal that would have required significant capital commitment. If a lease renewal on an older facility would have triggered substantial capital expenditure to maintain the space, and consolidation eliminates that renewal, the avoided capital is a one-time saving that offsets the consolidation costs. Model it as a lump sum in the year the renewal would have occurred.
Cataloguing One-Time Consolidation Costs
The cost side of the model demands the same category discipline as the savings side. Experienced practitioners organize one-time consolidation costs into six buckets: space preparation, physical relocation, contractual exit costs, technology and infrastructure, change management, and carrying costs during the transition period.
Space preparation includes tenant improvements in the new consolidated location net of any landlord allowance, furniture and fixtures to accommodate the combined headcount, and any racking or specialized equipment for operations functions. The key modeling rule is to use net TI cost — total improvement cost minus landlord contribution — rather than gross cost, because the landlord allowance is a real offset even if it flows through the build-out contractor.
Physical relocation encompasses moving services, temporary storage, and any specialized equipment transport. For operations-heavy environments, equipment recertification after relocation can be a meaningful cost that project managers sometimes categorize under a different budget and therefore omit from the real estate model. Consolidate all relocation costs into a single line item to avoid double-counting or omission.
Contractual exit costs are frequently the largest single component of one-time costs and the most variable. Early termination fees depend entirely on the specific lease language and the number of months remaining. Some leases allow termination at a stated premium over remaining base rent; others require repayment of unamortized tenant improvement allowances and free rent. Read each lease carefully and model the contractual obligation, not a negotiated estimate, as the base case. Apply a probability-weighted scenario for negotiated settlement as a second tab, not the primary assumption.
Technology and infrastructure costs cover data network build-out, telephony, access control, and any specialized systems that do not transfer cleanly from multiple locations to one. These costs are frequently estimated by IT on a best-efforts basis during early feasibility. Build a contingency of 15 to 20 percent above the IT estimate, clearly labeled as a contingency, and justify it in the model documentation because technology costs on real estate projects routinely exceed initial estimates.
Change management costs include temporary productivity loss during the move period, employee communication programs, and any retention commitments made to key personnel for whom the new location represents a longer commute. Productivity loss is the hardest to quantify; many organizations model it as a percentage of affected payroll for the transition quarter, typically ranging from two to eight percent, labeled clearly as a hypothetical estimate.
Carrying costs during the transition arise when the organization is paying rent on both the old locations and the new consolidated space simultaneously. Calculate the precise overlap period — often three to twelve months depending on lease expiration alignment — and model the carrying cost as the sum of all rent obligations during that period. This is where lease-economics analysis becomes critical: even a short overlap period on multiple leases can materially increase the total cost of consolidation.
Structuring the Cash Flow Timeline
Once the savings and cost inventories are complete, the analyst must build a multi-year cash flow timeline that sequences every item in the correct period. The timeline is the backbone of the model; errors in timing are as damaging as errors in magnitude.
Start with a project calendar that identifies: the date each existing lease expires or terminates, the date the new lease commences, the build-out period and anticipated occupancy date, and the anticipated stabilization date when full savings are realized. Map each savings and cost item to a specific calendar quarter. Do not aggregate items into annual figures until after the quarterly cash flows are built, because annual aggregation can obscure overlap costs and delayed savings realization.
Savings rarely arrive in full on day one of occupancy. Staff moving from three locations to one typically require a ramp period before facilities management efficiencies are captured. Model savings in three phases: pre-move savings (any lease expirations that occur before the consolidated space opens), partial-year savings in the transition year, and full annual savings once stabilization is achieved. Each phase needs its own dollar figure and timeline entry.
The transition year is the most complex period in the model. During this year, the organization may be simultaneously paying exit costs on departing leases, carrying rent on both old and new spaces for some portion of the year, and incurring TI and relocation costs. Cash outflows during the transition year can easily exceed the annual savings figure, which is why the payback period is almost never less than 24 months for a meaningful consolidation.
Calculating Net Present Value of Consolidation
With the cash flow timeline built, the net present value calculation follows standard discounted cash flow methodology applied to the net annual savings after one-time costs. The mechanics are not exotic, but the inputs must be deliberate.
The net cash flow in each period is the period's savings minus the period's one-time costs. In the early periods, this figure is typically negative or zero because transition costs are front-loaded while savings build over time. In later periods, it becomes consistently positive as the one-time costs are fully incurred and savings are fully realized. The NPV of this series — discounted at the chosen rate — determines whether consolidation creates or destroys economic value.
Select the discount rate explicitly and document the rationale. A corporate real estate discount rate between six and ten percent is common for stable occupancy decisions, but organizations with higher capital costs or higher execution risk may apply twelve to fifteen percent. The choice matters: an annual occupancy saving discounted at seven percent over ten years has a materially higher present value than the same stream discounted at thirteen percent. Show NPV at multiple discount rates — a sensitivity table with at least three rates — to help decision-makers understand the model's exposure to rate assumptions.
The breakeven period is often more persuasive to senior stakeholders than NPV. Calculate the cumulative net cash flow quarter by quarter and identify the point at which it crosses zero. This is the payback period in real-dollar terms, unadjusted for time value. Report both the discounted payback period and the undiscounted payback period. The gap between them communicates the sensitivity of the project's economics to time value assumptions.
Handling Lease NPV in the Comparative Framework
Modeling consolidation savings against one-time consolidation costs is most rigorous when the lease NPV framework is applied consistently across every option the team is evaluating. The standard approach discounts all future occupancy cash outflows — base rent, operating expense escalations, parking, and amortized capital — back to a present value using the same discount rate applied to the consolidation cash flows.
When multiple scenarios are being evaluated in parallel — a status-quo scenario in which existing leases are renewed, a full-consolidation scenario, and a partial-consolidation scenario in which one location is exited — expressing each as a lease NPV places them on a common monetary scale. That common scale makes the comparison explicit and removes ambiguity that can otherwise surround consolidation recommendations supported only by annual savings estimates.
Effective rent is a useful summary metric within each scenario. Effective rent expresses the total occupancy cost of a lease, including free rent periods, TI amortization, and operating expense pass-throughs, as a single annual per-square-foot figure. Comparing effective rent across scenarios — and across markets if the consolidation involves a relocation — gives the decision committee a single number that captures the full economics of each option rather than just the face rent.
When an organization is also evaluating a purchase option alongside leasing in the consolidated location, the discounted cash flow framework accommodates that comparison within the same model structure. The relevant cash flows for the purchase scenario include acquisition costs, financing costs, capital expenditures, and the tax treatment of depreciation and interest, set against the avoidance of lease payments and a terminal value assumption at the end of the holding period. Most commercial real estate advisers present this as a separate tab within the same model.
Scenario Analysis and Sensitivity Testing
A single-point consolidation model is not sufficient for a decision of this magnitude. The model must include scenario analysis covering the variables most likely to affect the outcome: lease exit costs, construction costs, timeline delays, and savings realization speed.
Build a base case, an optimistic case, and a stressed case. In the stressed case, assume that exit costs come in at the contractual maximum, construction takes three months longer than planned and generates a longer overlap carrying cost, IT costs exceed estimates by 20 percent, and savings ramp more slowly due to organizational friction. The stressed case is not a prediction; it is a test of whether the transaction is robust to execution risk. If the stressed case NPV is still positive, the project has a strong economic argument. If the stressed case produces a negative NPV, the team needs to identify specific risk mitigants before proceeding.
Sensitivity tables should isolate the variables that have the most leverage on the outcome. In most consolidation models, exit costs and the length of the carrying period are the two highest-leverage cost variables. On the savings side, the discount rate and the length of the holding period (how long the organization occupies the consolidated space before its next major decision) are the highest-leverage assumptions. Presenting these in a two-variable sensitivity grid — exit costs versus holding period, for example — gives the decision committee an immediate read on the conditions under which the model's conclusion changes.
Monte Carlo simulation is appropriate for large or highly uncertain consolidation projects. By assigning probability distributions to the key variables and running thousands of scenarios, the analyst generates a probability distribution of NPV outcomes rather than a single-point estimate. Not every organization has the modeling infrastructure for this, but for a consolidation involving significant contractual exit risk, the additional rigor is justified.
Documenting Assumptions for Review
A consolidation model is only as credible as its assumptions documentation. Every input that cannot be derived from a signed contract or a verified invoice should be documented with a source and a confidence level. This discipline prevents the model from being revised informally during negotiation in ways that change the conclusion without a formal re-approval.
Organize the assumptions log by category, matching the savings and cost categories in the model. For each assumption, record the source (lease contract, property manager quote, IT estimate, historical benchmark), the date the source was obtained, and the name of the person responsible for the assumption. Date the assumptions log when the model is submitted for approval, so any subsequent revisions are explicitly tracked against the approved version.
Assumptions that carry the highest execution risk — exit cost negotiations, construction cost estimates, and IT infrastructure costs — should be flagged for re-verification at defined project milestones. A model approved in month one of a project that runs eighteen months will have assumptions that are no longer current. Build a formal refresh cycle into the project governance, typically at project authorization, at lease execution, and at move commencement.
Presenting the Model to Decision Committees
A well-built consolidation model that is poorly presented will not move a decision committee. The presentation must lead with the conclusion — consolidation creates or does not create net value over the relevant holding period — and support it with three supporting exhibits: the NPV summary across scenarios, the cumulative cash flow chart showing the payback crossover, and the sensitivity grid for the two or three highest-leverage variables.
Anticipate three challenges that decision committees consistently raise. The first is the exit cost estimate: committees often push back on termination penalty assumptions, believing that negotiation will reduce the cost. Address this by showing the base case at the contractual maximum and the optimistic case at a negotiated settlement, with a clear explanation of what drives the difference. The second challenge is the timeline: committees often compress the construction and transition timeline in their mental model, underestimating the overlap carrying cost. Show the monthly cash flow during the transition period explicitly. The third challenge is the savings realization assumption: committees tend to accept full-year savings in year one, while the model may show a ramp. Walk through the ramp assumption and its basis.
The model appendix should include the full assumptions log, the lease abstracts for all affected locations, and the key contract provisions governing exit costs. A decision committee member who asks to verify an assumption should be able to find the source in the appendix within two minutes. This level of documentation also protects the project team if the project is later audited against its original business case.
Governing the Model Through Project Execution
Approval of the consolidation business case is the beginning of a governance challenge, not the end of the modeling work. The financial model must be maintained as a live document throughout execution, updated as actual costs and savings replace estimates.
Establish a variance reporting protocol at project authorization. Define which variances trigger a formal re-approval: typically a ten to fifteen percent change in total one-time costs or a shift in the payback period of more than six months. Outside those thresholds, track variances in a running log and report them to the project sponsor at each milestone. Inside those thresholds, document the variance but continue on the approved basis.
The stabilization review — conducted approximately twelve months after full occupancy — is the most important post-approval model update. At stabilization, actual occupancy costs, actual headcount, and actual facilities management costs are available. Compare actuals to the model assumptions and document the explanation for each material variance. This retrospective analysis improves the quality of future consolidation models and builds organizational credibility for the real estate function.
On the core discipline of modeling consolidation savings against one-time consolidation costs: build a complete inventory on both sides, map every item to a specific period, discount at a defensible rate, test the stressed case, document every assumption, and maintain the model through execution. The modeling work is not complete at approval; it is complete when the stabilization review confirms whether the business case delivered what the model projected.
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.