Calcady™
Home / Financial / Net Operating Income (NOI) & Pro Forma Calculator

Net Operating Income (NOI) & Pro Forma Calculator

Generate a professional CRE Pro Forma to calculate a property's true Net Operating Income (NOI). Excludes debt service and depreciation for accurate Cap Rate valuation.

Income Pipeline

$
$
%

Operating Expenses (OpEx)

Crucial: Do not subtract the Mortgage here!

$
$
$
$
% of EGI

Net Operating Income

$78,480
Unlevered Property Profitability

Pro Forma Waterfall

Gross Potential Rent:$120,000
Other Income:$5,000
(-) Vacancy Loss:-$6,000
Effective Gross Income:$119,000
Fixed/Variable OpEx:$31,000
Management Fee (8.0% of EGI):$9,520
Total OpEx:-$40,520
Operating Margin:65.9%
Email LinkText/SMSWhatsApp

What is The Pro Forma & Net Operating Income (NOI)?

Net Operating Income (NOI) is the foundational metric of commercial and investment real estate valuation. It measures the pure profitability of the operating property itself, prior to the interference of the owner's specific financing choices, corporate taxes, or depreciation accounting rules. If you do not know a building's true NOI, you cannot calculate its Cap Rate, and therefore you cannot accurately underwrite the asset's market value.

Mathematical Foundation

The Income Pipeline
EGI=Gross Potential Rent+Other Income−Vacancy Loss\text{EGI} = \text{Gross Potential Rent} + \text{Other Income} - \text{Vacancy Loss}
GPR\text{GPR}= Gross Potential Rent. The theoretical scenario where every single unit in the building is rented 365 days a year with zero defaults or evictions.
EGI\text{EGI}= Effective Gross Income. Reality. The hard cash that actually entered the property's operating bank account after tenants skipped rent and units sat empty.
The Core Calculation
NOI=Effective Gross Income (EGI)−Operating Expenses (OpEx)\text{NOI} = \text{Effective Gross Income (EGI)} - \text{Operating Expenses (OpEx)}
OpEx\text{OpEx}= Operating Expenses required to keep the building physically standing, insured, and functional (Taxes, Insurance, Utilities, Maintenance).

Laws & Principles

  • The 'Below-the-Line' Rule (CRITICAL ERROR): You must NEVER include mortgage payments (Debt Service), Income Taxes, or Depreciation under Operating Expenses! These live 'below the line' because they are specific to the investor, not the physical building. A building's NOI does not change just because its owner needs a bank loan. Including a mortgage in OpEx artificially crushes the NOI and ruins the property's capitalization valuation.
  • The Vacancy Reality Check: Sellers will frequently hand you a 'Pro Forma' (a projected income statement) that assumes 0% vacancy. This is a mathematical fiction. A standard commercial underwriting model demands a 5% to 10% "Vacancy and Credit Loss" deduction baked into the EGI to account for turnovers and remodeling time.
  • Management Fee Pegging: Property managers typically charge a percentage of the cash actually collected. The engine dynamically calculates the Management Fee against the Effective Gross Income (EGI), rather than the theoretical Gross Potential Rent (GPR).

Step-by-Step Example Walkthrough

" An apartment complex has a theoretical GPR of $120,000/yr and collects $5,000 in laundry coins. It sustains a 5% historical vacancy rate. It pays $15,000 in property taxes, $4,500 in insurance, $8,000 for maintenance, and $3,500 for utilities. The manager takes an 8% cut of collected rent. "

  1. 1. Calculate Vacancy Loss: 5% of $120,000 = $6,000 lost to empty units.
  2. 2. Calculate EGI: $120,000 + $5,000 - $6,000 = $119,000 cash actually collected.
  3. 3. Calculate Management Fee: 8% of EGI ($119,000) = $9,520.
  4. 4. Sum Pure OpEx: $15,000 + $4,500 + $8,000 + $3,500 + $9,520 = $40,520.
  5. 5. Calculate NOI: $119,000 (EGI) - $40,520 (OpEx) = $78,480.
Final Result: The true operating NOI is $78,480. Because OpEx correctly excludes the owner's mortgage, this $78,480 is the pure cash generated by the brick-and-mortar asset itself. If this building trades at a 6% Capitalization Rate, the building is valued at $1,308,000 ($78,480 / 0.06).

Quick Answer: How do you calculate Net Operating Income (NOI)?

To calculate Net Operating Income (NOI), start with the property's Gross Potential Rent, subtract Vacancy Losses to establish the Effective Gross Income (EGI), and then subtract all standard Operating Expenses (Taxes, Insurance, Utilities, Maintenance, Management). You must explicitly exclude your mortgage payment (debt service) and depreciation to isolate the property's pure unlevered yield.

The Commercial Property NOI Equation Formula

Standard Pro Forma Pipeline

NOI = (Gross Rent - Vacancy Loss) - Operating Expenses

  • 1. Effective Gross Income (EGI)— The first bracket (Rent minus Vacancy) generates your EGI. This is the actual cash deposited into the bank.
  • 2. Operating Expenses (OpEx)— The cost to physically run the asset. This exclusively includes Taxes, Insurance, Utilities, Maintenance, and Management Fees.
  • 3. Excluded Items— Always exclude Mortgage Payments, Income Taxes, and Capital Expenditures (CapEx).
  • 4. Final Valuation— The resulting NOI is structurally divided by the market Cap Rate to determine the property's purchase price.

OpEx Destruction vs Expansion Models

Model A: Forced Appreciation

Value-Add | Expense Reduction

  1. 1. Context: An investor buys a 10-unit building with an $80,000 NOI. The local market operates at a 5% Cap Rate, implying a $1.6M valuation.
  2. 2. Action Plan: The investor installs low-flow toilets and LED lighting, cutting the \"Utilities\" OpEx line by $4,000 a year. They also install $50/mo coin-laundry machines, creating $6,000/yr in new \"Other Income.\"
  3. 3. The Math: NOI instantly increases by $10,000 (from $80k to $90k).

→ Result: Because the building is valued at NOI / 0.05, that $10,000 spike in NOI mathematically forced the building's valuation up by $200,000. They created $200k in equity instantly.

Model B: The Property Tax Reset Shock

Blind Underwriting | NOI Collapse

  1. 1. Context: A syndicate buys a commercial building running a $150,000 NOI. The current owner has held it for 30 years, so their property tax base is artificially locked at only $5,000/year.
  2. 2. The Trap: The buyers use that $5,000 tax line item in their OpEx projections, ignoring post-sale valuation resets.
  3. 3. The Reset: Six months after closing, the county reassesses the building based on the massive new purchase price. The property taxes spike from $5,000 to $45,000.

→ Result: The building's NOI collapses from $150,000 down to $110,000. The massive drop in NOI triggers a DSCR covenant breach with their lender, forcing a default.

The "Above vs Below the Line" Matrix

Financial Line Item Classification
Property Taxes Above the Line (OpEx)
Property Management Fee Above the Line (OpEx)
Mortgage Payment (Debt Service) Below the Line (NCF)
Capital Expenditures (Roof/HVAC) Below the Line (Reserve)
Depreciation & Income Tax Below the Line (Paper)
*Items categorized 'Above the Line' reduce NOI. Items 'Below the Line' reduce Net Cash Flow (NCF) but preserve the pure NOI valuation multiplier.

Pro Tips & Execution Hazards

Do This

  • ✓The Cap Rate Multiplier. NOI is the direct engine of property value. Value = NOI / Cap Rate. If a market Cap Rate is 5%, every single $1.00 you increase the NOI (by either raising rent or cutting an expense) forces the building's value to increase by $20.00.
  • ✓RUBS & Utility Bill-Backs. To heavily expand NOI, modern owners implement a Ratio Utility Billing System (RUBS). Instead of paying the $3,500 water bill as an OpEx, they bill it back to the tenants. This drops OpEx, boosts NOI, and forces the property's paper valuation higher.

Avoid This

  • ✗The "Broker's Pro Forma" Scam. When buying a building, the listing broker will provide a 'Pro Forma' (projected future NOI). They will almost universally project 0% vacancy, exclude management fees, and recycle the previous owner's artificially low property tax bill. Never trust a broker's NOI. Re-underwrite every line item.
  • ✗CapEx vs OpEx Commingling. Do not write off a $50,000 roof replacement into the "Maintenance" bucket of your OpEx. Replacing a roof is a Capital Expenditure (CapEx). If you place it in OpEx, it will erroneously crush your NOI and make your building look worthless to the bank appraiser.

Frequently Asked Questions

Should I include my mortgage in the NOI calculator?

No. Never. A mortgage (Debt Service) is specific to the investor, not the building. The building generates cash regardless of how it was financed. If you subtract the mortgage from the NOI, you are technically calculating "Net Cash Flow" (NCF), which is an entirely different metric that ruins Cap Rate valuations.

How does Vacancy Loss affect the final NOI?

It acts as a permanent, systemic drag. Even the best-run buildings experience tenant turnover. A 5% vacancy rate applied to a $100,000 Gross Potential Rent means you deduct $5,000 off the top line before paying a single expense. It is a mandatory deduction when presenting a Pro Forma to a commercial bank.

Are Capital Expenditures (CapEx) included in Operating Expenses?

No. Operating Expenses (OpEx) keep the building functional day-to-day (fixing a leaky pipe, mowing the lawn). CapEx involves massive, infrequent structural upgrades (a new roof, replacing the HVAC system). Because CapEx is erratic, it is placed in a 'CapEx Reserve' line item below the NOI line.

How do I underwrite a Pro Forma if the building is completely empty?

If you are acquiring a vacant or severely distressed asset, you must build a "Stabilized Pro Forma." This means you forecast what the building will generate in Gross Rent and OpEx once it is repaired and leased up to a normal 90-95% market occupancy. You use the Stabilized NOI to determine the "After Repair Value" (ARV).

Related Real Estate Analytics