Net Operating Income Real Estate Formula: Three Property Scenarios
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 Item | Amount |
|---|---|
| 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 Ratio | 95.5% |
| NOI Margin | 60.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 Item | As-Is | Corrected |
|---|---|---|
| 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 Item | Without Gross-Up | With 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 Type | Recovery Revenue | Key NOI Variable |
|---|---|---|
| Triple Net (NNN) | Minimal/zero (tenant pays direct) | Base rent level, expense stop sizing |
| Modified Gross | Partial (landlord pays some) | Which expenses are stopped vs. passed through |
| Full Service Gross | Zero (all costs to landlord) | Expense management |
| CAM + Stop (Office) | Above-stop amounts only | Stop 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.