Why Lease NPV Gets Misread More Often Than It Gets Right
Lease net present value analysis sits at the core of almost every occupier decision — yet the numbers that reach the conference table are frequently built on assumptions that have never been tested and methodological shortcuts that compound quietly. The result is a recommendation that feels precise but is actually fragile. Understanding the 7 Common Errors in Lease NPV Calculations is the first step toward producing analysis that holds up under scrutiny from finance, legal, and the board.
Error 1 — Using a Discount Rate That Belongs to a Different Problem
The discount rate is where lease economics go wrong earliest. Many occupier teams default to their company's weighted average cost of capital because it is the number finance uses for capital investment decisions. WACC captures equity and debt costs, makes sense for evaluating expansion projects, and is widely understood — but it is the wrong instrument for a lease obligation analysis.
Lease liabilities carry a risk profile closer to secured debt than to an equity investment. The rate that best reflects a company's incremental borrowing cost for a collateralized, medium-term obligation is typically the rate used under ASC 842 and IFRS 16 — the incremental borrowing rate. Using WACC systematically understates the present value of near-term cash outflows, making riskier long leases appear cheaper than they are on a truly risk-adjusted basis.
A subtler version of the same error is using one discount rate for every option in a comparison. If two buildings are being evaluated with different credit structures — one a direct lease with an institutional landlord and one a sublease from a financially stressed tenant — their cash flows carry different certainty and arguably warrant different rates. Flattening both to a single corporate hurdle rate eliminates that distinction entirely.
Error 2 — Treating Free Rent as If It Were Money Already Spent
Landlord concessions, particularly free-rent periods, are among the most negotiated elements in a commercial lease — and among the most frequently mishandled in an NPV model. The common error is treating free rent as a straight reduction in total rent paid, then dividing it across the term to arrive at an average annual cost. That approach ignores the time value of the same concession entirely.
A twelve-month rent-free period at the front of a ten-year lease is worth considerably more than twelve months of free rent delivered at year eight — the earlier the concession, the lower its discounted cost to the landlord and the higher its real value to the tenant. When teams model free rent incorrectly, they tend to rank options based on headline economics that flatten these timing differences, and the lease with less front-loaded relief can appear artificially competitive.
The right approach is to model every rent-free period as a zero cash flow in the actual period it occurs, let the discount function do its work, and then compare options at the NPV level rather than the average annual cost level. The difference in a hypothetical scenario — say, twelve months free rent in year one versus year three on a five-hundred-thousand-dollar annual obligation — can represent tens of thousands of dollars in present-value terms even at conservative discount rates.
Error 3 — Omitting Operating Expense Volatility
Quoted base rents attract most of the attention, but operating expenses — common area maintenance, property insurance, and real estate taxes — can represent between twenty and forty percent of total occupancy cost in a gross or modified gross structure. In a net or net-net-net lease, those numbers fall entirely on the tenant, and their future values are genuinely uncertain. Many lease NPV models either ignore them or assume they grow at a fixed annual rate chosen without reference to the actual property's cost history.
The more defensible method is to review the landlord's historical CAM reconciliation statements, model a base-case escalation tied to a documented benchmark, and then run sensitivity analysis across a range of escalation scenarios.
Operating expense caps negotiated in the lease need to be modeled accurately too. A cap of five percent per year on controllable expenses is a real economic protection, and if the model assumes uncapped growth, it overstates total occupancy cost — which can make a capped lease appear less attractive than the numbers actually support. Getting the caps right matters for both lease selection and lease administration once the agreement is signed.
Error 4 — Ignoring Tenant Improvement Allowance Timing and Conditions
Tenant improvement allowances are almost universally present in new leases for meaningful-sized occupiers, yet their treatment in NPV models ranges from roughly correct to completely wrong. The simplest error is treating the full TI allowance as a cash receipt at lease commencement — when in practice, TI payments are disbursed by landlords against invoices, often over a construction period of three to twelve months, with final draw requirements, lien waivers, and sometimes an offset right if the tenant vacates early.
A TI allowance received in quarterly draws over eight months has a lower present value than the same dollar amount received on day one. The difference is not enormous in absolute terms on a mid-sized transaction, but in a close comparison between two options where one landlord structures disbursements differently, the error can reverse the apparent winner. Building a simple draw schedule into the NPV model — even a rough one based on the construction timeline — produces a materially more accurate result.
There is also the question of TI taxability and accounting treatment. Under ASC 842, landlord-provided TI allowances affect the right-of-use asset calculation differently depending on whether the improvement is a lease incentive or a reimbursement for tenant assets. While the accounting classification is ultimately a finance and audit question, the adviser who understands the distinction can present a more complete picture of total occupancy economics to the client.
Error 5 — Failing to Model Renewal Options at Their Real Economic Value
Renewal options look like optionality, and optionality has value — but most lease NPV models either ignore renewal periods entirely or extend the same base-year assumptions straight through to the option term without adjustment. Both approaches produce misleading numbers. Ignoring the option entirely understates the economic footprint of a lease for a tenant who is likely to exercise it. Extending current rent assumptions without adjustment ignores the fact that option rents are often set to fair market value or defined by a formula tied to a CPI index, not to the original deal economics.
The practical solution depends on how the option rent is structured. If the option rent is formula-driven — say, CPI plus one percent — the model should build a rent schedule based on a documented inflation assumption with sensitivity testing at higher and lower rates. If the option rent is set at fair market value at the time of exercise, the model should include a range of projected market rents based on comparable transaction data, clearly labeled as projections rather than certainties.
Option periods also trigger the question of remaining TI obligations, unamortized allowances, and landlord consent requirements. A renewal option that cannot be exercised if the tenant is in default, or one that requires ninety days' advance notice with a sixty-day response window, creates operational risks that have economic consequences if exercised improperly. Those conditions belong in the lease administration calendar, not buried in a footnote.
Error 6 — Applying Escalation Assumptions Inconsistently Across Options
When an adviser compares multiple lease options, the escalation assumptions applied to each one must be internally consistent. This sounds obvious, yet errors of this type are common in practice — particularly when different team members have built different tabs of the comparison model, or when broker proposals have been accepted at face value and assembled without normalizing the underlying assumptions.
One building's proposal might quote rent with three percent annual escalations. Another might use a CPI-tied escalation with a floor of two percent and a ceiling of five percent. A third might offer step rents at defined dollar amounts per square foot. If the NPV model treats these differently without documenting why, or — worse — converts them all to a flat growth rate for simplicity, the comparison is not comparing equivalent things. The effective rent calculation that emerges will reflect modeling choices as much as it reflects the actual deal economics.
The correct approach is to decide on a standard escalation assumption set before building any scenario, apply it consistently across every option being evaluated, and document where landlord proposals deviate from that standard. When actual lease terms include CPI escalations, the adviser should state the index, the base period, the cap and floor if applicable, and the assumed CPI path — and that assumed path should be the same for every option in the analysis.
Error 7 — Confusing Effective Rent With Net Present Value
This is the error that experienced professionals debate the most precisely because both metrics are legitimate — they just answer different questions. Effective rent converts total occupancy cost over the lease term into an average annual or per-square-foot figure, expressed in nominal dollars. It is easy to communicate and useful for quick market comparisons. Net present value, by contrast, translates every future cash flow back to today's dollars using a chosen discount rate, which means it explicitly accounts for the time value of money.
The confusion arises when teams use effective rent as a proxy for NPV without acknowledging that the two measures can produce different rankings. A ten-year lease with heavy front-loaded concessions can show a lower effective rent than a seven-year lease with modest concessions — but the NPV of the ten-year obligation, discounted at a reasonable borrowing rate, may be higher because the longer duration extends cash outflows far into the future. Making the decision on effective rent in that scenario systematically underweights the duration risk.
The two metrics are not in competition. Effective rent serves the market comparison conversation; NPV serves the decision. Advisers who present both, with clear labels and consistent assumptions, give their clients the full picture rather than a single number that can be used to tell whichever story the audience prefers.
Why Consistency in Assumptions Matters as Much as the Model Itself
The seven errors above are each technically distinct, but they share a common root: assumptions chosen for convenience, inherited from a prior analysis, or accepted from a third-party proposal without independent review. The model structure matters, but assumption consistency and documentation matter just as much. A lease NPV model with perfect mechanics and undocumented escalation rates is still a machine that produces unreliable outputs.
Documenting assumptions means more than adding a footnote at the bottom of the spreadsheet. The discount rate selection should reference a source — the company's IBR, a treasury yield, or a finance team sign-off. Each escalation assumption should identify whether it is based on the actual lease terms or a normalized projection. TI draw schedules should be labeled as estimated or confirmed. When the analysis reaches the client, every significant number should be traceable back to a decision that can be explained and defended.
This level of documentation is also what separates a one-time analysis from a reusable model. When a lease comes up for renewal three years later, or when market conditions shift and the client wants to test a sublease or early termination scenario, a well-documented model can be reopened and updated quickly. A model built on undocumented assumptions has to be rebuilt from scratch because no one is confident that the original assumptions were right.
Aligning the Model With the Lease Administration Reality
An NPV model is built before the lease is signed. Lease administration happens after. The gap between those two moments is where a third category of error lives — not a calculation error exactly, but an execution error that changes the economics the model predicted. Critical dates that were modeled but not tracked, renewal notices that were not sent within the contractual window, escalation reconciliations that were not audited against the lease's actual expense definitions — all of these shift the real cost of a lease away from what the NPV analysis projected.
Operating expense reconciliations deserve particular attention. A landlord's CAM reconciliation can include expenses that the lease specifically excludes, and tenants who do not audit those statements regularly — or at all — often pay for exclusions they negotiated. When the annual over-charge is a meaningful percentage of base rent, it changes the actual effective cost of the lease relative to the modeled cost. The NPV analysis told the story the lease was supposed to tell; the administration tells the story the lease actually delivered.
Renewal option tracking is the other lever. When a renewal window closes without a timely notice, the tenant either loses the option entirely or negotiates a new lease at market conditions that may be significantly less favorable than the formula embedded in the original agreement. Tracking critical dates is not a passive activity — it requires a system that surfaces notices with enough lead time to evaluate whether exercising the option is still the right economic decision, not simply whether it is still contractually available.
Building a Defensible Lease NPV Process
A defensible lease NPV process has four elements that go beyond the model itself. The first is a written assumption protocol agreed upon by the adviser and the client's finance team before any analysis is built — covering the discount rate methodology, the escalation rate source, the TI draw convention, and the renewal option treatment. When everyone agrees on the rules before the numbers are run, debates about the output become discussions about the deal rather than arguments about the model.
The second element is peer review. The person who built the model is the least well-positioned person to catch its errors. A second reviewer who understands the lease terms and the modeling conventions should check the key scenarios before they go to the client. That review does not need to be exhaustive — checking the discount rate, the rent schedule, the TI timing, and the renewal assumptions against the actual lease draft covers the most common error categories.
The third element is version control. Lease negotiations produce multiple drafts, each of which may change TI amounts, escalation structures, or free-rent periods. Without clear version control, it is easy to present NPV numbers based on a term sheet that has already been superseded. The final model must reflect the final lease terms — and there should be a documented checkpoint confirming that alignment.
The fourth element is a plain-language summary for the decision-maker. The NPV output from a thorough model can be detailed enough that the number itself gets lost in the supporting schedules. A one-page summary that states the discount rate, identifies the preferred option, and explains in plain terms why it ranks ahead of the alternatives on a present-value basis is what moves decisions forward.
Matching the Right Tool to the Complexity of the Decision
Not every lease decision warrants the same analytical depth. A short-term, below-market renewal on a small space may reasonably be evaluated on effective rent alone. A ten-year headquarters commitment in a market with meaningful rent volatility and significant TI negotiation deserves a full NPV model with sensitivity tables, documented assumptions, and a peer review. The error that organizations make is applying the lighter approach to the heavier decision — usually because that is what has always been done, or because time pressure compressed the process.
The practical test is whether a finance director, audit committee member, or CFO reviewing the analysis would be able to understand why each assumption was chosen and would find the conclusion supported by the numbers. If the answer is no — if the reviewer would have to trust the adviser's judgment without being able to follow the logic — the analysis is not yet complete. That is the standard that separates a lease recommendation from a lease recommendation that can be defended.
##
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 Super Agent upgrade adds specialist, source-backed research with citations 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.