OfficeTemplateHub

The Complete Guide to Commercial Lease Analysis: Calculating Net Effective Rent, Concessions & NNN Outflows

A mathematical underwriting framework for corporate tenants, CRE brokers, and asset managers to objectively evaluate competing office, retail, and industrial lease proposals.

When evaluating commercial real estate leases, looking solely at the headline face rate (quoted dollars per rentable square foot per year) is one of the costliest mistakes corporate tenants and real estate investors make. A quoted rate of $42.00/RSF Full Service Gross may actually be cheaper on an effective cash basis than an apparently discounted $28.00/RSF Triple Net (NNN) proposal once Common Area Maintenance (CAM), building insurance pass-throughs, and capital reserve assessments are factored in.

In this guide, we break down the exact mathematical methodology utilized by institutional underwriting teams to normalize lease structures, discount multi-year concession packages, and calculate both Cash Net Effective Rent and Net Present Value (NPV) Effective Rent.

1. Deconstructing Lease Structures: FSG, Modified Gross, and NNN

Before running any quantitative discounted cash flow (DCF) model, you must classify who bears the operational risk of the building. Commercial leases generally fall into three standard categories:

  • Full Service Gross (FSG): The landlord covers all operating costs (taxes, insurance, janitorial, utilities, structural maintenance) out of the base rent during the initial base year. Increases above the base year are charged via an expense stop.
  • Modified Gross (MG): The tenant pays base rent plus a predetermined share of specified operational costs (for example, tenant pays electric and janitorial, while the landlord covers property taxes and structural insurance).
  • Triple Net (NNN): The tenant pays base rent and is directly billed for their proportionate share of three primary expense categories:
    1. Net Property Taxes: City and county assessments.
    2. Net Building Insurance: Casualty, flood, and liability policies.
    3. Net Common Area Maintenance (CAM): Snow removal, HVAC preventative maintenance, lobby staffing, and landscaping.

Need an interactive NNN Pass-Through Model?

Simulate triple-net breakdowns, tenant square footage shares, and annual pass-through escalations instantly.

Open NNN Calculator →

2. The Mathematical Formulas for Net Effective Rent (NER)

Net Effective Rent normalizes a lease by averaging net cash outflows over the total term, accounting for tenant improvements, landlord concessions, and rent escalation schedules.

A. Undiscounted (Cash) Net Effective Rent

Cash NER is the arithmetic mean of cash paid minus concessions, divided by the total rentable area and term in years:

Cash Net Effective Rent Formula Cash NER ($/RSF/Yr) = [ Total Gross Rents Paid - Total Free Rent Abatements - Tenant Improvement (TI) Allowance - Landlord Broker Commissions ] / [ RSF * Term in Years ]

B. Present Value (Discounted) Net Effective Rent

Because money today is worth more than money in Year 7 of a 10-year term, institutional CFOs discount the monthly cash flow vector $CF_t$ using the company's weighted average cost of capital (WACC) or discount rate $r$:

Discounted Cash Flow Net Effective Rent (NPV NER) NPV of Lease = Σ [ CF_t / (1 + r/12)^t ] for t = 0 to N Present Value Annuity Factor (PVAF) = [ 1 - (1 + r/12)^(-N) ] / (r/12) Monthly Equivalent NER ($/RSF) = (NPV of Lease) / (RSF * PVAF) Annualized NPV NER ($/RSF/Yr) = Monthly Equivalent NER * 12

3. Modeling Concessions: Free Rent vs. Tenant Improvement (TI) Allowance

Landlords frequently compete on concessions rather than slashing the headline face rate. Why? Because lowering the headline rate decreases the capitalized asset valuation on their building balance sheet when refinancing. Consequently, a landlord would rather give you 6 months of free rent and a $60/RSF TI Allowance than drop face rent by $5/RSF.

From a tenant's financial vantage point:

  • Front-Loaded Free Rent: Provides immediate cash conservation during the fit-out and onboarding period.
  • Turnkey Buildouts vs. Stated Allowances: A $50/RSF stated allowance carries the risk of construction cost overruns. A "turnkey" landlord buildout shifts cost-escalation risk entirely to the property owner.

4. Compounding Escalations & Expense Stops

Most 5-to-10-year commercial leases specify annual base rent escalations. Typical structures include:

  • Fixed Percentage Steps: 2.5% to 3.5% per annum compounding annually.
  • Flat Dollar Bumps: $1.00/RSF annual increase every 12 months.
  • Indexed (CPI) Escalations: Tied to the Consumer Price Index, often capped with a collar (e.g., minimum 2.0%, maximum 5.0%).

5. Real-World Case Study: Downtown Class A vs. Flex Campus (10,000 RSF)

Consider a technology firm leasing 10,000 RSF for a 5-year (60-month) term evaluating two competing Landlord Letters of Intent (LOI):

Lease Parameter Proposal A (Downtown Highrise) Proposal B (Suburban Flex Campus)
Quoted Lease Structure Full Service Gross (FSG) Triple Net (NNN)
Year 1 Base Face Rate $44.00 / RSF / Yr $29.00 / RSF / Yr
Annual Base Rent Escalation 3.0% Annual Step 3.0% Annual Step
Estimated NNN / CAM Pass-Throughs $0.00 (Covered by base year stop) $11.50 / RSF / Yr (Est. 4% annual increase)
Free Rent Concession 5 Months Abated (Months 1–5) 2 Months Abated (Months 1–2)
Tenant Improvement (TI) Allowance $45.00 / RSF ($450,000 credit) $15.00 / RSF ($150,000 credit)
5-Year Undiscounted Total Cash Outflow $2,036,750 $2,284,320
5-Year Cash Net Effective Rent (NER) $31.73 / RSF / Yr $42.68 / RSF / Yr
NPV Effective Rent (@ 8.0% WACC) $29.85 / RSF / Yr $39.92 / RSF / Yr

The Takeaway: Although Proposal B appeared substantially cheaper at first glance ($29.00 vs $44.00 face rate), the combination of heavy NNN pass-through operating expenses ($11.50/RSF escalating at 4%) and modest concessions resulted in Proposal B costing $247,570 more in real cash over 5 years. Proposal A delivered a far superior economic result.

Download the Full Commercial Lease Analysis Model

Get our battle-tested Excel spreadsheet with dynamic NER formulas, side-by-side comparison tables, and sensitivity charts.

View Excel Template & Model →

6. Frequently Asked Questions (FAQ)

What is the difference between Rentable Square Feet (RSF) and Usable Square Feet (USF)?

Usable Square Feet (USF) is the physical space within the perimeter walls of your private office suite. Rentable Square Feet (RSF) includes the tenant's pro-rata share of common areas (restrooms, building lobbies, elevator banks, mechanical shafts). The ratio between RSF and USF is known as the Core Factor or Loss Factor (typically 12% to 18% in modern Class A office buildings).

How are CAM audit rights negotiated in a commercial lease?

Tenants should always negotiate an explicit CAM Audit Right clause allowing an independent certified public accountant (CPA) to review the landlord's books within 90 to 180 days of receiving the annual year-end reconciliation. If an overstatement exceeding 3% to 5% is uncovered, the landlord must reimburse both the excess charge and the tenant's CPA audit fees.

Can free rent be taken outside of the first few months?

Yes. While most landlords default to consecutive front-loaded abatement (e.g. Months 1–6), tenants can negotiate spread abatement (e.g. Month 1 of each lease year) or delayed abatement to coincide with cash-flow trough periods.