Calcady™
Home / Financial / Commercial Lease NPV Calculator

Commercial Lease NPV Calculator

Discount a multi-year commercial lease with annual escalation clauses back to present value using DCF methodology for GAAP ASC 842 compliance.

Lease Parameters

$
Years

Contract Growth & Economics

%
%

Net Present Value (NPV)

$755,013
The true economic value of the contract today.

Total Contract Size

Total Nominal Rent (Unadjusted):$1,146,388
Average Rent over 10 Yrs:$114,639/yr

Discounted Free Cash Flow Schedule

Period
Nominal Rent
Discounted PV
Year 1
$100,000
$92,593
Year 2
$103,000
$88,306
Year 3
$106,090
$84,218
Year 4
$109,273
$80,319
Year 5
$112,551
$76,600
Year 6
$115,927
$73,054
Year 7
$119,405
$69,672
Year 8
$122,987
$66,446
Year 9
$126,677
$63,370
Year 10
$130,477
$60,436
Email LinkText/SMSWhatsApp

What is Net Present Value (NPV) in Commercial Leasing?

In commercial real estate, evaluating a multi-year lease is complex because a dollar received in year 10 is mathematically worth far less than a dollar received today. Lease NPV (Net Present Value) normalizes all future escalating rent payments back to "today's dollars." This allows landlords and corporate tenants to accurately compare competing lease structures (e.g., a flat 10-year lease vs. a 10-year lease with 3% annual bumps).

Mathematical Foundation

NPV=∑t=1NBase Rent×(1+Escalation)t−1(1+Discount Rate)t\text{NPV} = \sum_{t=1}^{N} \frac{\text{Base Rent} \times (1 + \text{Escalation})^{t-1}}{(1 + \text{Discount Rate})^t}
tt= The specific year of the lease (e.g., Year 1, Year 2).
NN= The Total Lease Term in years.
Escalation\text{Escalation}= The contractual annual percentage increase in rent (the 'Bump').
Discount Rate\text{Discount Rate}= The Weighted Average Cost of Capital (WACC) or target return on investment used to discount future cash flows back to the present.

Laws & Principles

  • The Illusion of Nominal Rent: A landlord might boast about a lease bringing in $1.5M in 'Total Rent' over 10 years. But if inflation (discount rate) is 8%, the actual economic value (NPV) of that contract might only be $900k.
  • The Escalation Race: The value of the lease critically depends on whether the Annual Escalation (%) outpaces the Discount Rate (%). If Escalation == Discount Rate, the present value of every rent check theoretically stays flat forever.
  • GAAP ASC 842 Accounting: Modern accounting standards legally require corporate tenants to record the entire multi-year Present Value of their building leases as a liability on their balance sheet.

Step-by-Step Example Walkthrough

" A tenant signs a 5-year lease. Base rent is $100,000 in Year 1. It increases by 5% every year. The firm's internal discount rate is 10%. "

  1. Year 1 Rent: $100k / (1.10)^1 = $90,909 PV.
  2. Year 2 Rent: $105k / (1.10)^2 = $86,776 PV. (The 10% discount rate is decaying the value faster than the 5% escalation is growing it).
  3. Year 3 Rent: $110,250 / (1.10)^3 = $82,832 PV.
  4. Year 4 Rent: $115,762 / (1.10)^4 = $79,067 PV.
  5. Year 5 Rent: $121,550 / (1.10)^5 = $75,473 PV.
Final Result: The Total Nominal Rent paid is $552,563. But to the CFO today, the Net Present Value of that 5-year liability is only $415,057.

Quick Answer: Why do you NPV a commercial lease?

A 10-year commercial lease with 3% annual rent escalations will generate vastly more total rent than a flat lease — but a dollar paid in Year 10 is worth significantly less than a dollar paid today. Lease NPV (Net Present Value) discounts every future rent payment back to "today's dollars" using a discount rate (typically the tenant's incremental borrowing rate or the landlord's target return). This single NPV number lets you directly compare competing lease proposals on a true economic basis. Since the adoption of ASC 842, corporate tenants are also legally required to record the present value of operating leases as a liability on their balance sheet.

Common Lease Escalation Structures

Commercial lease rent increases are contractually fixed at signing. Understanding the most common escalation structures helps tenants and landlords negotiate intelligently and model NPV accurately.

Escalation Type How It Works NPV Impact
Fixed % Annual BumpRent increases by a set percentage (typically 2-4%) each year.Moderate. Predictable and easy to model. Most common in US commercial leases.
CPI-IndexedRent adjusts annually based on the Consumer Price Index change.Variable. Harder to project NPV because future CPI is unknown. Use historical averages (2.5-3.5%).
Step-Up (Stair-Step)Rent stays flat for 2-3 years then jumps (e.g., $100k → $115k → $130k).Lower NPV than continuous escalation because early years are cheaper and those dollars are worth more.
Percentage RentBase rent plus a percentage of tenant's gross sales above a breakpoint.Impossible to NPV precisely without revenue projections. Use base rent only for conservative NPV floor.

Pro Tips & Common Lease Modeling Mistakes

Do This

  • ✓Use the tenant's incremental borrowing rate as the discount rate. Under ASC 842, if the lease doesn't state an implicit rate, the tenant must use the rate they would pay to borrow a similar amount over a similar term. For most mid-market tenants, this is typically 6-10% depending on credit quality.
  • ✓Model free rent and TI allowances separately. If a landlord offers 3 months free rent or a $50/sqft tenant improvement allowance, reduce the NPV of the total lease obligation accordingly. These concessions dramatically change the effective NPV even when the sticker base rent looks identical to a competing proposal.

Avoid This

  • ✗Don't compare leases by total nominal rent. A 10-year lease paying $1.5M total is not necessarily cheaper than a 7-year lease paying $1.2M total. The 10-year lease may have a lower NPV because most of its payments occur far in the future where they're heavily discounted. Always compare NPV, not nominal totals.
  • ✗Don't forget NNN pass-throughs in your total cost. In Triple Net (NNN) leases, the tenant pays base rent PLUS property taxes, insurance, and maintenance. These pass-through costs escalate unpredictably beyond the stated rent bump and should be modeled separately with their own growth assumptions.

Frequently Asked Questions

What is ASC 842 and how does it affect lease accounting?

ASC 842 is the FASB accounting standard (effective 2019 for public companies, 2022 for private) that requires companies to record nearly all leases on their balance sheet. Previously, operating leases were "off-balance-sheet" — they appeared only as rent expense. Under ASC 842, the tenant must calculate the NPV of all remaining lease payments and record it as both a Right-of-Use (ROU) Asset and a Lease Liability. This calculator directly produces the number needed for that liability entry.

What discount rate should a landlord use vs. a tenant?

Landlords typically use their required return on equity (8-12%) or their WACC as the discount rate — this tells them the economic value of the lease as an investment. Tenants typically use their incremental borrowing rate (the rate they'd pay on a secured business loan of similar term), which is usually 5-9%. A lower discount rate produces a higher NPV, meaning the same lease looks more expensive to the tenant than to the landlord.

How do renewal options affect NPV?

Under ASC 842, if the tenant is "reasonably certain" to exercise a renewal option, those renewal periods must be included in the NPV calculation. For large anchor tenants with significant leasehold improvements, renewal is typically assumed. For small tenants in flexible coworking spaces, renewal is typically excluded. The judgment call significantly impacts the reported balance sheet liability.

Related Calculators