Skip to main content

Net Operating Income Real Estate Formula: Three Property Scenarios

By Angel Campa·Founder, CapVeri

Net Operating Income Real Estate Formula

NOI = Base Rent + CAM Recovery + Tax Recovery + Insurance Recovery + Other Income − Operating Expenses. CAM recovery is not a footnote — for most commercial properties it represents 15-25% of total revenue and is the most variable, most controllable line in the formula.

The net operating income real estate formula is the same across property types. What differs is how CAM recovery behaves in each — and how much NOI is at stake when recovery ratios slip.

The Formula, Expanded

For a commercial property with tenant expense recoveries:

NOI =
  Base Rent (scheduled, per active leases)
  + CAM Recovery Revenue (billed × collected)
  + Real Estate Tax Recovery
  + Insurance Recovery
  + Percentage Rent
  + Other Income (parking, antenna, etc.)
  − CAM Expenses Incurred
  − Property Taxes
  − Insurance Premiums
  − Property Management Fees
  − Non-Recoverable Operating Expenses

The critical feature: CAM expenses appear on both sides. When recovery = 100%, they net to zero — full pass-through. When recovery < 100%, the unrecovered portion is a net NOI cost.

Three Property Scenarios

Scenario 1: Stabilized Retail Strip (Recovery Working)

Property: 45,000 sf neighborhood retail center, 96% occupied, suburban market

Line ItemAmount
Base Rent$927,000
CAM Recovery (95.5% of $270,000 pool)$257,850
Tax Recovery (100%)$185,000
Insurance Recovery (100%)$31,500
Total Revenue$1,401,350
CAM Expenses($270,000)
Property Taxes($185,000)
Insurance($31,500)
Management Fee (4%)($56,054)
Non-Recoverable Expenses($18,000)
Total Operating Expenses($560,554)
NOI$840,796
CAM Recovery Ratio95.5%
NOI Margin60.0%

At 7.0% cap rate: $12.0M implied value. This property's recovery machinery is working — 4.5% unrecovered is mostly anchor exclusions, not billing error.

Scenario 2: Value-Add Opportunity (Recovery Gap)

Same property type, different management quality:

Line ItemAs-IsCorrected
Base Rent$910,000$910,000
CAM Recovery (82% vs 95%)$221,400$256,500
Tax Recovery$180,000$180,000
Insurance Recovery$30,000$30,000
Total Revenue$1,341,400$1,376,500
Total Operating Expenses($560,054)($560,054)
NOI$781,346$816,446
Value at 7.0% cap$11.16M$11.66M

Value gap: $500,000 — recoverable by improving billing and reconciliation from 82% to 95%. No cap-ex, no lease modifications, no rent increases. This is the CAM leakage concept from the cam-leakage-guide applied to NOI valuation.

Scenario 3: Office Building with Gross-Up Complexity

Property: 80,000 sf suburban office, 74% occupied (59,200 sf leased), Class B

Line ItemWithout Gross-UpWith Gross-Up
Base Rent$1,184,000$1,184,000
CAM Recovery$286,000$352,700
Tax Recovery$220,000$220,000
Insurance Recovery$38,400$38,400
Total Revenue$1,728,400$1,795,100
CAM Expenses (actual)($420,000)($420,000)
Other Expenses($340,000)($340,000)
NOI$968,400$1,035,100

The gross-up adjustment — normalizing the $420,000 CAM pool to 95% occupancy before calculating tenant shares — adds $66,700 to NOI. At a 7.5% cap (office rates are higher), that's $889,000 in value from correctly applying a lease provision that was already there. See cam-gross-up-calculation-guide for the full methodology.

CAM Recovery as a Revenue Line: Why It Matters

Most NOI models show a single "Revenue" figure. That obscures the recovery ratio — the single most important diagnostic metric for CRE FinOps. Always model recovery as its own line:

Recovery Ratio = CAM Recovery Revenue ÷ Total CAM Expenses Incurred

Track this monthly, not just at year-end. A property running 78% recovery in Q1-Q3 that expects 95% for the full year has a significant true-up to bill tenants in Q4 — and those true-ups generate disputes. Far better to be within 5% throughout the year.

The cam-variance-analysis framework shows how to track this in real time and identify which tenants are driving the gap.

How CAM Recovery Fits the Full NOI Formula

Think of the NOI formula in two parts:

Part 1: Base Rent NOI (predictable, contractual) = Base Rent − Management Fees − Non-Recoverable Expenses

Part 2: Recovery-Expense Net (accuracy-dependent) = All Recovery Revenue − All Recoverable Expenses

In a perfectly structured and perfectly managed property, Part 2 equals zero — full pass-through. In reality, Part 2 is slightly negative because of caps, exclusions, and billing gaps. The discipline of what-is-cam-reconciliation is keeping Part 2 as close to zero as your leases allow.

Modeling NOI for Different Lease Structures

Lease TypeRecovery RevenueKey NOI Variable
Triple Net (NNN)Minimal/zero (tenant pays direct)Base rent level, expense stop sizing
Modified GrossPartial (landlord pays some)Which expenses are stopped vs. passed through
Full Service GrossZero (all costs to landlord)Expense management
CAM + Stop (Office)Above-stop amounts onlyStop setting vs. actual expense inflation

For properties with mixed lease structures across a portfolio, see how-to-calculate-noi-real-estate for normalization approaches.

NOI Spreadsheet Structure

When building a NOI spreadsheet for a commercial property, use this column structure for each tenant:

Tenant Name | SF | Base Rent | CAM Billed | Tax Billed | Ins Billed | % Rent | Total Revenue

Then below the tenant section:

Total Expenses: CAM Incurred | Taxes | Insurance | Mgmt Fee | Non-Rec Expenses
Recovery Ratio: [CAM Billed ÷ CAM Incurred]
NOI: [Total Revenue − Total Expenses]
Cap Rate: [User input]
Implied Value: [NOI ÷ Cap Rate]

The NOI impact calculator handles this automatically for your portfolio, including recovery ratio sensitivity analysis showing the value impact of each percentage point improvement.

Next Steps

For the full step-by-step calculation walkthrough, see noi-formula-calculation-guide. For how NOI translates to property value through cap rate mechanics, see noi-to-value-commercial-property. And for three more NOI calculation examples with detailed assumptions, see noi-calculation-example.

Need lease data before you reconcile?

lextract.io abstracts commercial leases into 126 structured fields in minutes — CAM definitions, pro-rata share, caps, base year, and more. No manual data entry.

Go to lextract.io