Apers_

FINANCIAL MODELING

NOI Calculator and Formula: Net Operating Income for Commercial Real Estate (Line-by-Line)

May 2026 · 18 min

Key Takeaways

  • NOI = Effective Gross Income − Operating Expenses. EGI is gross potential revenue net of vacancy and credit loss, plus other income. OpEx is the full nine-line institutional stack — tax, insurance, repairs, management, utilities, payroll, marketing, professional services, and G&A.
  • Broker NOI and institutional NOI are not the same number. On the same property the two figures typically diverge by 5–10% — which translates to 25–50 bps of cap-rate movement at a fixed price. The calculator surfaces both side by side.
  • Replacement reserves sit BELOW the NOI line per the NCREIF and MBA conventions ($300–$400/unit/year for multifamily, $0.20–$0.40/SF/year for office and retail). Mixing conventions makes your cap rate non-comparable to comp data.
  • Insurance and property tax are the 2024–2026 opex story. Coastal multifamily insurance has 2–3x'd since 2021; acquisition tax reassessments reset basis 20–30% above the seller's tax line. Use current-market, not in-place, for both.
  • Worked example: 180-unit Phoenix multifamily. $2.7M PGR + $135K other − 5.5% vacancy = $2,686,500 EGI. $1,320,000 of OpEx. NOI = $1,366,500 on the institutional convention; the broker version on the same property prints $1,441,500 — a 5.5% gap.

Net Operating Income (NOI) is the most consequential line on a commercial real-estate operating statement. It is the numerator of cap rate, the numerator of debt service coverage ratio, the starting point for unlevered cash flow, and the single number a lender, an appraiser, and a buyer will spend the most time arguing about. The formula is mechanically simple — revenue minus operating expenses — but the institutional conventions around which revenue and which expenses make the difference between a number the IC will accept and a number the lender will rebuild from scratch.

This calculator computes NOI line by line on the institutional convention. Enter gross potential revenue, other income, and vacancy. Enter the nine operating-expense line items practitioners actually argue about. The widget returns EGI, total OpEx, NOI, NOI margin, and the asset-class opex-ratio benchmark band so you can sanity-check the result against the institutional comp data. The Broker NOI vs. Institutional NOI panel below the primary outputs shows the same NOI rebuilt against the conventions a broker offering memorandum typically applies — and the cap-rate delta the gap creates at the asking price.

For the methodology behind the broker-vs-institutional split — T-12 normalization, market vs. in-place rent, capex reserves above vs. below the line, management fee inclusion, non-recurring stripping — see the companion methodology pillar: Broker NOI vs. Institutional NOI. This page is the widget; that page is the deep dive.

Calculate Your NOI

Defaults model a 180-unit garden multifamily property in Phoenix — the same worked example used across the Apers Learn valuation cluster. Edit any cell to compute against your own deal.

Revenue

Operating Expenses

Annual, $

Asset Class

For opex-ratio benchmark
Effective Gross Income
Total Operating Expenses
Net Operating Income
NOI Margin
Opex Ratio (your inputs vs. asset-class band)
Note · Replacement Reserves Reserves are held below the NOI line per institutional convention — typical $300–$400/unit/year for multifamily, $0.20–$0.40/SF/year for office/retail. This widget intentionally does not deduct them above the line.

Broker NOI vs. Institutional NOI

Broker offering memoranda typically normalize differently than institutional underwriting. This panel applies a standard set of broker conventions to your inputs and shows the resulting gap. Toggle the adjustments to mirror the assumptions in your OM.

Broker NOI
Institutional NOI
Gap

For multifamily NOI specifically — rent roll normalization, RUBS treatment, payroll allocation — see AQ-110, the Multifamily Acquisition Pocket Model →

BUILD IT IN APERS

Apers builds the full institutional NOI from T-12 normalization — line by line, every adjustment auditable, capex reserves placed correctly. Try Apers free →

Or start in a pocket model: AQ-110 (multifamily) → · AQ-301 (anchored retail) → · AQ-401 (industrial) →

What NOI Measures

NOI measures a property's unlevered, pre-tax operating yield in dollars — the cash a property would generate annually if it were owned free and clear, before debt service, before depreciation, and before any capital expenditures. It is the cleanest single number for comparing the operating economics of one asset to another, and it is the input that flows into cap rate (NOI ÷ value), debt service coverage ratio (NOI ÷ debt service), and the first year of every multi-year unlevered cash flow.

The formula:

  • Effective Gross Income (EGI) = Gross Potential Revenue − Vacancy and Credit Loss + Other Income
  • NOI = EGI − Operating Expenses
  • NOI Margin = NOI ÷ EGI

Three line items routinely cause disagreements between practitioners and break the comparability of NOI across deals: (1) replacement reserves, which the institutional convention holds below the NOI line but some broker packages deduct above; (2) management fees, which are normalized to market (typically 3–4% of EGI for multifamily, 3–5% for retail and office) even when the in-place owner self-manages; (3) one-time items — lease termination fees, settlement payments, storm damage — which are normalized out of a clean NOI but routinely left in by sellers who benefit from the noise.

The deep treatment of these conventions lives in the methodology pillar: Broker NOI vs. Institutional NOI. Read that next if your reason for landing here is a broker number you don't trust.

How to Use This Calculator

The widget computes three layers of output. Each answers a different question.

The primary NOI

The four boxes at the top return EGI, Total OpEx, NOI, and NOI Margin. The default Phoenix inputs return $2,686,500 of EGI, $1,320,000 of OpEx, an NOI of $1,366,500, and a 50.86% NOI margin. NOI margin is the headline metric — everything else is plumbing — but it is meaningful only in context (see asset-class benchmarks below).

The opex-ratio benchmark

Total OpEx ÷ EGI returns the opex ratio. On the default Phoenix inputs the opex ratio prints 49.1%, against an institutional band of 35–45% for stabilized multifamily. A 4–5 point overshoot is meaningful — either the line items contain non-recurring expense the seller did not strip, or the property is sub-stabilized, or the in-place tax line has already been reassessed up at acquisition. The benchmark band switches with the asset-class selector. Treat the band as a directional signal, not a definitive comp — submarket and asset-quality variance is substantial.

The Broker NOI vs. Institutional NOI comparison

The bottom panel rebuilds your NOI two ways. The Institutional NOI applies the full conventional adjustments: market management fee if the property is self-managed, capex reserves at the institutional default, no stripping of non-recurring items unless explicitly flagged. The Broker NOI applies the conventions a typical broker OM uses to maximize the headline number: management fee left at in-place, no reserves, optional stripping of "non-recurring" items the seller categorizes loosely. The gap between the two is the cap-rate delta at your asking price.

On the default inputs the broker-vs-institutional gap prints in the $70–$85K range (~5–6% of NOI), which at the default $27.3M ask price translates to ~25–30 bps of cap-rate movement. That is the typical institutional-vs-broker delta on a single property — and it is precisely the magnitude a lender will rebuild on its own before sizing debt.

THE 30-SECOND TAKEAWAY

A 5–10% NOI gap between the broker number and the institutional number is normal — not a sign of malpractice, just a sign that two different conventions are in play. Resolve the gap explicitly before debating price. The cap rate cannot be debated if the NOI underneath isn't agreed.

NOI Across Asset Classes

"What's a good NOI margin?" The honest answer is it depends on the asset class. The table below shows institutional opex-ratio bands (Total OpEx ÷ EGI) for the major property types, drawn from NCREIF, IREM, BOMA, and the CBRE / JLL quarterly opex surveys. NOI margin is the complement: 100% − opex ratio.

Asset Class Typical OpEx Ratio NOI Margin Drivers
Multifamily (stabilized) 35–45% 55–65% Payroll-heavy; insurance has 2–3x'd in coastal markets since 2021
Industrial (Tier 1 logistics) 10–20% 80–90% NNN structures dominate; landlord retains structural roof/wall capex
Office (Class A, gross lease) 40–55% 45–60% HVAC, janitorial, security; TI/LCs sit below the NOI line
Office (Class A, NNN) 10–15% 85–90% Landlord retains insurance + structural capex; tenant carries the rest
Anchored Retail (NNN) 15–30% 70–85% CAM recovery rate is the variance; vacancy on small-shop space matters
Self-Storage 25–35% 65–75% Low payroll; tenant insurance and ancillary revenue lift margin
Hospitality (full-service) 65–75% 25–35% Departmental + undistributed costs; payroll & F&B compress margin

Asset-class opex bands (May 2026). Sources: NCREIF Property Index expense ratios, IREM Income/Expense Analyses, BOMA Experience Exchange Reports, CBRE and JLL quarterly opex surveys.

Two reads from this table that matter for the calculator user. First, NOI margin is not comparable across asset classes — an industrial property at 85% NOI margin and a multifamily property at 60% NOI margin are not better-or-worse, they are differently structured. Industrial NNN pushes most of the opex onto the tenant; the landlord books a tighter, cleaner margin against gross rents that are already net of those items. Multifamily landlords absorb payroll, utilities, marketing, and turnover — the higher opex ratio is structural.

Second, the margin bands move with the rate environment. The 2024–2026 insurance and property tax inflation have compressed multifamily NOI margins 2–4 points in coastal Florida, Texas Gulf Coast, and Louisiana submarkets relative to 2020–2021 vintages. Office gross-lease margins have compressed similarly on energy and labor; industrial NNN margins are relatively insulated because the tenant carries the variable opex. Use 2024 or later comp data when benchmarking; 2019–2021 vintages will read low against the current cost base.

Opex ratio bands by asset class, May 2026 Opex ratio: institutional bands by asset class MAY 2026 · STABILIZED · PERCENT OF EGI 0% 25% 50% 75% MULTIFAMILY 35–45% INDUSTRIAL NNN 10–20% OFFICE (GROSS) 40–55% RETAIL NNN 15–30% SELF-STORAGE 25–35% HOSPITALITY 65–75% Bands reflect stabilized institutional comps. Multifamily and office gross-lease bands have widened 2–4 points since 2021 on insurance + payroll inflation. Source: NCREIF, IREM, BOMA, CBRE/JLL quarterly opex surveys. Apers_
Asset-class opex-ratio bands. The hospitality bar (highlighted) is the outlier — departmental and undistributed costs structurally compress the NOI margin even on well-run full-service hotels.

What NOI Excludes

A clean NOI excludes four categories of cash flow that practitioners regularly confuse for operating expense. Each exclusion has a reason; each reason matters for how you compare NOI to other metrics downstream.

Debt service

NOI is unlevered. Mortgage principal and interest sit below the NOI line. Your actual equity yield depends on leverage, debt cost, and capital reserves — not on NOI alone. The metric that captures debt service is DSCR: NOI divided by annual debt service. See the DSCR calculator for that math.

Depreciation and amortization

Depreciation is an accounting expense, not a cash cost. NOI is a cash-yield metric, so depreciation is excluded. The IRS-recognized depreciation schedules (27.5 years residential, 39 years commercial) matter for tax modeling, not for NOI.

Capital expenditures (capex) and replacement reserves

Capex — roof replacement, HVAC overhaul, parking-lot resurfacing — sits below NOI per the institutional convention. Replacement reserves — the annual accrual that pre-funds known future capex — also sit below NOI in the NCREIF / MBA convention, though some broker packages deduct them above. The widget treats reserves as below-line and the Broker vs. Institutional comparison shows what happens when broker conventions add them in.

Tenant improvements and leasing commissions (TI/LCs)

For office, retail, and industrial deals, TI/LCs are real cash outflows that sit below NOI. Office leases at $40–$80/SF of TI plus 4–6% LCs on the rent stream can absorb multiple years of NOI on a single lease. The mistake is to compute NOI cleanly and then forget these costs when sizing the equity check.

One-time and non-recurring items

Lease termination fees, settlement payments, insurance recoveries, the year-end utility refund, a one-off storm damage line — all should be normalized out of a clean stabilized NOI. The honest test is whether the item will recur in a normal year. If yes, keep it. If no, strip it — but disclose what you stripped, because the broker might not have.

See the methodology pillar (Broker NOI vs. Institutional NOI) for the conventions around when to strip vs. normalize, the T-12 vs. T-3 question, market vs. in-place rent, and the rest of the institutional NOI rulebook.

Common Mistakes in NOI Calculation

Seven recurring mistakes account for most NOI disputes between buyers, sellers, lenders, and appraisers. Each is straightforward to avoid once named.

  • Using broker NOI as the underwriting NOI. 5–10% NOI inflation is the broker convention — not malicious, just optimized for headline cap rate. The lender will rebuild it; the buyer should too. The Broker vs. Institutional comparison in the widget above is built to surface the magnitude of the rebuild before you debate price.

  • Including replacement reserves above the NOI line. The institutional convention is to hold reserves below NOI. Mixing conventions makes the cap rate and DSCR non-comparable to broker comps and submarket data. If the reserves are above the line, either rebuild the NOI or apply the equivalent adjustment to every comp you're using.

  • Using management fee at the in-house rate when the property is self-managed. Institutional convention is to normalize management fee to market (3–4% of EGI for multifamily, 3–5% for retail and office) even when the in-place owner self-manages at 1–2%. The justification: the next buyer may not self-manage, and the cap rate must reflect the third-party operating cost basis.

  • Treating one-time income as recurring. Lease termination fees, settlement payments, insurance recoveries, the year-end utility refund — all are non-recurring and should be normalized out. Brokers leave them in; buyers strip them; lenders strip them more aggressively. Be explicit about what you stripped and why.

  • Treating one-time expenses as non-recurring when they aren't. Storm damage in a storm-prone market is not non-recurring; it is an under-reserved insurance event. Coastal Gulf and Florida multifamily storm-damage lines that print zero in T-12 because the property got lucky should be reserved for, not stripped. Honesty cuts both ways.

  • Pricing on in-place property tax instead of post-acquisition reassessment. Texas, Florida, and California (Prop 13 reset) routinely reassess tax basis 20–30% higher at acquisition than the seller's in-place line. The widget will print a clean NOI on the seller's tax number; your underwriting should print a clean NOI on the reassessed tax number. The difference can be $100K–$300K per year on a mid-sized MF deal.

  • Using a T-3 or T-1 instead of a T-12. Short trailing periods miss seasonality — utility costs in summer Texas multifamily, snow removal in winter Midwest office, hospitality occupancy in shoulder months. Use T-12 as the floor; T-24 or T-36 when available, especially for hospitality and seasonal multifamily. The methodology pillar covers the T-12 normalization workflow in detail.

The NOI calculator is the anchor for the Apers Learn valuation cluster. Sibling deep-dives:

FAQ

Frequently Asked Questions

What is NOI in commercial real estate?

Net Operating Income (NOI) is a property's annual income after operating expenses but before debt service, depreciation, capital expenditures, and income taxes. It measures the unlevered cash yield of the asset itself, independent of how it is financed. NOI is the numerator of cap rate (NOI ÷ value) and DSCR (NOI ÷ debt service), and the starting point for unlevered cash flow.

How do you calculate NOI?

NOI = Effective Gross Income (EGI) − Operating Expenses. EGI is gross potential revenue, minus vacancy and credit loss, plus other income (parking, laundry, RUBS, ancillary fees). Operating expenses are the nine-line institutional stack: property tax, insurance, repairs and maintenance, property management fee, utilities, payroll, marketing, professional services, and other G&A. Use the calculator above to compute it on your inputs.

What's the difference between NOI and EBITDA?

NOI is a real-estate-specific operating metric that excludes depreciation, amortization, debt service, capex, and TI/LCs. EBITDA is a corporate-finance metric that also excludes depreciation, amortization, interest, and taxes — but typically includes all corporate operating expenses (including management compensation that NOI normalizes to market). NOI is the property-level number; EBITDA is the operating-company number. On a single-asset operating company they can be close, but they are not the same definition.

Does NOI include debt service?

No. NOI is unlevered — it is computed before mortgage interest and principal. Debt service sits below the NOI line. The metric that combines NOI and debt service is the Debt Service Coverage Ratio (DSCR), which is NOI divided by annual debt service.

Does NOI include depreciation?

No. Depreciation is an accounting (non-cash) expense and is excluded from NOI. NOI is a cash-yield metric. Tax depreciation matters for after-tax returns and Schedule E, but it does not enter the NOI calculation.

Does NOI include capital expenditures?

No. Capital expenditures (capex) — major roof, HVAC, parking lot, building system replacements — sit below the NOI line per institutional convention. Replacement reserves (the annual accrual that pre-funds expected capex) also sit below the NOI line in the NCREIF and MBA conventions, though some broker offering memoranda deduct them above. The Broker vs. Institutional comparison in the widget above surfaces both treatments.

Does NOI include reserves?

Under the institutional convention (used by NCREIF, the MBA, and most institutional comp tables), replacement reserves sit below the NOI line — typical $300–$400/unit/year for multifamily, $0.20–$0.40/SF/year for office and retail. Under some broker conventions, reserves are deducted above the NOI line. The two conventions produce NOI numbers that differ by the reserve amount and are not directly comparable. This calculator follows the institutional convention.

What is included in operating expenses for NOI?

The institutional operating-expense stack includes nine line items: property tax, insurance, repairs and maintenance, property management fee, utilities, payroll, marketing and advertising, professional services (legal, accounting, audit), and other / general and administrative. Excluded above the NOI line: debt service, depreciation, amortization, capital expenditures, replacement reserves (institutional convention), tenant improvements, and leasing commissions.

How is NOI used to calculate cap rate?

Cap rate = NOI ÷ Property Value. A property generating $1,366,500 of NOI and trading at $27,300,000 carries a 5.00% cap rate. NOI is the numerator; the going-in cap rate is computed on year-one stabilized NOI and the acquisition price. See the cap-rate calculator for the full treatment.

What is a good NOI margin?

Asset-class dependent. Multifamily stabilized NOI margin is typically 55–65% (35–45% opex ratio); industrial NNN is 80–90%; suburban office gross-lease is 45–60%; anchored retail NNN is 70–85%; self-storage is 65–75%; hospitality is 25–35%. The widget above plots your opex ratio against the band for the selected asset class.

What's the difference between broker NOI and institutional NOI?

Broker NOI typically uses market vacancy (often lower than in-place), management fee at in-place (often lower than market), strips non-recurring expenses aggressively, and excludes replacement reserves above the line. Institutional NOI uses the higher of in-place or submarket vacancy, normalizes management fee to market, retains non-recurring expenses unless explicitly normalized with disclosure, and holds reserves below the line. On the same property the two figures typically diverge by 5–10%. See the methodology pillar for the full treatment.

Should I use T-3, T-12, or T-24 to compute NOI?

T-12 is the institutional floor — twelve months captures full seasonality. T-3 or T-1 misses winter heating, summer cooling, snow removal, and hospitality occupancy swings; do not use as the base. T-24 or T-36 is useful when the property has had ownership or management changes recently or when the T-12 contains visible one-offs. For hospitality and seasonal multifamily, T-24 minimum is the institutional norm.

Sources

  • NCREIF Property Index — quarterly institutional NOI, opex, and cap-rate data by sector. user.ncreif.org/data-products/property
  • IREM (Institute of Real Estate Management) — Income/Expense Analysis annual benchmarks for conventional and federally assisted multifamily, office, shopping centers, and condo/co-ops. Cited by name.
  • BOMA International — Experience Exchange Report opex benchmarks for office. Cited by name.
  • Mortgage Bankers Association (MBA) — commercial/multifamily reporting standards and quarterly originations data. Cited by name.
  • CBRE Research — quarterly U.S. cap-rate and opex surveys by sector. Cited by name.
  • JLL Research — quarterly U.S. opex and operating-cost surveys. Cited by name.
  • Investopedia — Net Operating Income definitional reference. Cited by name.

Ready to try Apers?

Start using Apers today — no credit card required.

Start for Free