NNN Lease Calculator Formula
Understand the math behind the nnn lease calculator. Each variable explained with a worked example.
Formulas Used
Monthly Total Occupancy Cost
monthly_total = total_annual / 12Annual Total (Year 1)
annual_total = total_annualAll-In Cost Per Sq Ft
all_in_psf = total_all_in_per_sqftAnnual NNN Charges
annual_nnn = annual_nnn_chargesMonthly Base Rent
monthly_base = annual_base / 12Total Base Rent Over Lease
total_lease_cost = total_lease_baseVariables
| Variable | Description | Default |
|---|---|---|
rentable_sqft | Rentable Square Feet(sq ft) | 3000 |
base_rent_per_sqft | Base Rent (per sq ft/year)(USD) | 22 |
cam_per_sqft | CAM Charges (per sq ft/year)(USD) | 6.5 |
tax_per_sqft | Property Tax (per sq ft/year)(USD) | 4.25 |
insurance_per_sqft | Insurance (per sq ft/year)(USD) | 1.75 |
lease_term_years | Lease Term (years) | 5 |
annual_escalation_pct | Annual Base Rent Escalation(%) | 3 |
annual_base | Derived value= rentable_sqft * base_rent_per_sqft | calculated |
annual_cam | Derived value= rentable_sqft * cam_per_sqft | calculated |
annual_tax | Derived value= rentable_sqft * tax_per_sqft | calculated |
annual_insurance | Derived value= rentable_sqft * insurance_per_sqft | calculated |
annual_nnn_charges | Derived value= annual_cam + annual_tax + annual_insurance | calculated |
total_annual | Derived value= annual_base + annual_nnn_charges | calculated |
total_all_in_per_sqft | Derived value= base_rent_per_sqft + cam_per_sqft + tax_per_sqft + insurance_per_sqft | calculated |
total_lease_base | Derived value= annual_escalation_pct > 0 ? annual_base * ((pow(1 + annual_escalation_pct / 100, lease_term_years) - 1) / (annual_escalation_pct / 100)) : annual_base * lease_term_years | calculated |
How It Works
Understanding NNN (Triple Net) Leases
In a triple net lease, the tenant pays base rent plus their proportionate share of property taxes, insurance, and common area maintenance (CAM). This is the most common lease structure in commercial real estate.
Components
NNN vs. Gross Lease
Escalation Clauses
Most NNN leases include annual base rent escalations of 2-4% to keep pace with inflation. NNN charges adjust based on actual costs each year.
Worked Example
3,000 sq ft office at $22/sq ft base rent, $6.50 CAM, $4.25 tax, $1.75 insurance, 5-year term with 3% annual escalation.
rentable_sqft = 3000base_rent_per_sqft = 22cam_per_sqft = 6.5tax_per_sqft = 4.25insurance_per_sqft = 1.75lease_term_years = 5annual_escalation_pct = 3
- 01Annual base rent: 3,000 x $22 = $66,000
- 02Annual CAM: 3,000 x $6.50 = $19,500
- 03Annual tax: 3,000 x $4.25 = $12,750
- 04Annual insurance: 3,000 x $1.75 = $5,250
- 05Total NNN charges: $19,500 + $12,750 + $5,250 = $37,500
- 06Year 1 total: $66,000 + $37,500 = $103,500
- 07Monthly total: $103,500 / 12 = $8,625
- 08All-in per sq ft: $22 + $6.50 + $4.25 + $1.75 = $34.50
Ready to run the numbers?
Open NNN Lease Calculator