NNN Lease Calculator Guide: How to Calculate Triple Net Lease Total Cost

The NNN lease cost calculation is straightforward in concept but gets complicated quickly once you account for annual escalations, controllable expense caps, and different growth rates for taxes vs. insurance vs. CAM. Here's the full framework with a worked multi-year model.

The NNN Lease Cost Formula

Annual NNN total cost = Base rent + Property taxes + Building insurance + CAM

Each component is calculated on a per-SF basis and multiplied by the tenant's leasable area. The challenge is that each component grows at different rates and may be subject to different caps or provisions.

Per-SF calculation:

• Base rent: fixed rate per lease, with scheduled escalations
• Property taxes: tenant's pro-rata share of actual tax bill ÷ tenant SF
• Insurance: tenant's pro-rata share of actual premium ÷ tenant SF
• CAM: tenant's pro-rata share of CAM expenses ÷ tenant SF (subject to controllable cap)

Monthly payment:

• Monthly rent = Base rent × SF ÷ 12
• Monthly NNN estimate = (Taxes + Insurance + CAM) × SF ÷ 12
• Total monthly obligation = Monthly rent + Monthly NNN estimate

The monthly NNN estimate is reconciled annually against actual costs. See CAM reconciliation for how that process works.

Worked Example: Year-One NNN Cost Calculation

Tenant: 7,500 SF inline retail space in a 60,000 SF strip center Pro-rata share: 7,500 ÷ 60,000 = 12.5%

Base rent: $21.00/SF Annual property taxes (building total): $270,000 → Tenant share: $33,750 ($4.50/SF) Annual insurance (building total): $96,000 → Tenant share: $12,000 ($1.60/SF) Annual CAM (building total): $228,000 → Tenant share: $28,500 ($3.80/SF)

Year-one calculations:

• Annual base rent: $21.00 × 7,500 = $157,500
• Annual NNN expenses: ($4.50 + $1.60 + $3.80) × 7,500 = $74,250
• Total annual NNN cost: $231,750 ($30.90/SF all-in)
• Monthly total: $19,312.50

Use the pro-rata calculator to verify your share allocation, and the CAM gross-up calculator if the lease includes a gross-up provision.

The Multi-Year NNN Cost Model

This is where NNN leases get significantly more expensive than a flat-year calculation suggests. Each component grows at different rates.

Lease terms:

• 7,500 SF tenant, 7-year NNN lease
• Base rent: $21.00/SF with 3% annual increases starting year 2
• Controllable CAM cap: 4% annual increase
• Property taxes: projected at 6% annual increase
• Insurance: projected at 9% annual increase (current market trend)
• Controllable CAM actual growth: 5% annual increase (above cap)

7-year total NNN cost: $1,825,875 Vs. year-one rate × 7 years: $1,622,250 (the escalation adds $203,625)

The insurance line alone increased $1.08/SF over 7 years (at 9% annual growth). On 7,500 SF, that's $8,100/year more by year seven than in year one. That increase comes from insurance escalation alone.

What the Controllable Cap Actually Protects

In the model above, actual controllable CAM grew 5% per year but the tenant's obligation was capped at 4%. Here's what that means:

By year 7, the cap shields the tenant from $0.27/SF ($2,025/year on 7,500 SF). Over the full term, the cap saved the tenant roughly $6,750 in controllable expenses (sum of annual per-SF shortfalls × 7,500 SF). Meaningful, but not dramatic at 5% vs 4% divergence.

Where caps matter much more: if a major expense event (like a landscaping contractor renegotiation or janitorial contract renewal at significantly higher rates) pushes controllable costs up 12% in a single year, the cap limits that to 4%. That's real money. The controllable vs non-controllable expenses guide explains which categories fall under each cap.

Pro-Rata Share: The Denominator Matters

The pro-rata share formula looks simple, but the denominator (total leasable area) is often defined differently in different leases.

Common definitions:

• Total building area: All leasable SF in the building including vacant spaces
• Occupied area: Only leased SF (can shift your share as tenants move in/out)
• Gross-up basis: Total building area adjusted as if 90–95% occupied

If the building is 60,000 SF but only 48,000 SF is occupied, a tenant's share under "occupied only" is 7,500/48,000 = 15.6% vs. 7,500/60,000 = 12.5% under total area. The difference: on $228,000 in CAM, the tenant pays $35,625 vs. $28,500, a $7,125 annual difference.

This is exactly why the CAM gross-up calculation matters: gross-up normalizes occupancy effects to prevent tenants from bearing more than their fair share when a building has vacancies.

Calculating NNN Costs for Comparison to Gross Lease Alternatives

When evaluating NNN vs. gross lease options, convert both to all-in cost per SF for each year:

NNN option: $21.00/SF base + $9.90/SF NNN expenses = $30.90/SF year one Gross option: $31.50/SF fixed (with 3% annual increases)

In this scenario, the NNN lease becomes more expensive than the gross option by year 5 as insurance and tax escalation outrun the 3% gross lease bumps. If insurance had grown at only 5%/year instead of 9%, the crossover point shifts later. Use the NOI impact calculator to sensitize your specific deal.

For a comprehensive side-by-side comparison, see NNN lease vs gross lease.

Building Your NNN Lease Calculator in Excel

The simplest structure that captures the key dynamics:

Inputs (one row per category):

• Tenant SF
• Pro-rata share %
• Base rent $/SF year 1
• Base rent annual escalation %
• Property taxes $/SF year 1
• Property tax annual growth %
• Insurance $/SF year 1
• Insurance annual growth %
• CAM $/SF year 1 (controllable)
• Controllable cap %
• Lease term (years)

Year-over-year model (columns for each year):

• Base rent = prior year × (1 + escalation rate)
• Taxes = prior year × (1 + tax growth rate)
• Insurance = prior year × (1 + insurance growth rate)
• Controllable CAM = MIN(prior year × (1 + actual growth), prior year × (1 + cap rate))
• Total $/SF = sum of above
• Annual cost = total $/SF × tenant SF
• Monthly cost = annual cost ÷ 12

The CAM reconciliation template gives you a starting point for structuring the expense tracking side of this model.

When to Use a NNN Lease Calculator

Tenants: Before signing any NNN lease, build a year-by-year cost model through the full term and all renewal options. Know what your occupancy cost looks like in year five under conservative, base, and stressed expense growth scenarios. The stressed scenario (insurance +15%/year, taxes +8%/year) should be survivable.

Landlords: Model NNN expense recovery against actual operating cost growth to project NOI trajectory. Where controllable caps or exclusions create recovery gaps, quantify them by year. See NNN investment properties CAM analysis for the investor perspective on this modeling.

Brokers and advisors: Convert NNN and gross alternatives to comparable all-in cost models before presenting options. A lower base rent NNN space might cost more than a gross alternative once expenses are factored in, or it might not. The only way to know is the multi-year model.

For context on how NNN fits within the broader lease structure universe, see commercial lease types guide and commercial lease rent structures.

Sources

1. ICSC - Dictionary of Shopping Center Terms
2. J.P. Morgan - What Are CAM Charges in CRE?