Net Operating Income Calculator Formula
Understand the math behind the net operating income calculator. Each variable explained with a worked example.
Formulas Used
Net Operating Income
noi = egi - total_expensesEffective Gross Income
effective_gross = egiTotal Operating Expenses
total_operating_expenses = total_expensesOperating Expense Ratio
expense_ratio = (total_expenses / egi) * 100Variables
| Variable | Description | Default |
|---|---|---|
gross_rental_income | Gross Rental Income(USD) | 72000 |
other_income | Other Income(USD) | 3600 |
vacancy_pct | Vacancy & Credit Loss(%) | 7 |
property_taxes | Property Taxes(USD) | 6000 |
insurance | Insurance(USD) | 2400 |
maintenance | Repairs & Maintenance(USD) | 4800 |
management_fee | Management Fees(USD) | 5040 |
other_expenses | Other Expenses(USD) | 2400 |
gross_potential | Derived value= gross_rental_income + other_income | calculated |
vacancy_loss | Derived value= gross_potential * vacancy_pct / 100 | calculated |
egi | Derived value= gross_potential - vacancy_loss | calculated |
total_expenses | Derived value= property_taxes + insurance + maintenance + management_fee + other_expenses | calculated |
How It Works
Net Operating Income (NOI)
NOI is the most important metric in commercial real estate. It represents the income a property generates after all operating costs but before debt service and income taxes.
Formula
NOI = Effective Gross Income - Total Operating Expenses
Where:
Worked Example
A rental property earns $72,000 gross rent plus $3,600 other income, with 7% vacancy and $20,640 total expenses.
- 01Gross potential income: $72,000 + $3,600 = $75,600
- 02Vacancy loss: $75,600 x 7% = $5,292
- 03Effective gross income: $75,600 - $5,292 = $70,308
- 04Total expenses: $6,000 + $2,400 + $4,800 + $5,040 + $2,400 = $20,640
- 05NOI: $70,308 - $20,640 = $49,668
- 06Expense ratio: $20,640 / $70,308 = 29.4%
When to Use This Formula
- Evaluating the income-generating potential of a rental property independent of how it is financed, to compare properties on an equal basis.
- Calculating the cap rate of a property by dividing NOI by the purchase price, which is the standard profitability metric in commercial real estate.
- Preparing a pro forma for a property acquisition or refinancing that lenders and investors require to assess the deal.
- Identifying which operating expenses are eating into profitability and where cost reductions would have the greatest impact on the bottom line.
- Tracking property performance year over year to see whether income growth is outpacing expense growth.
Common Mistakes to Avoid
- Including mortgage payments, loan interest, or debt service in operating expenses — NOI is an unlevered metric that must exclude all financing costs, so the property can be compared regardless of how it is funded.
- Using gross rental income without subtracting vacancy and credit loss — even well-managed properties have some vacancy; using 100% occupancy overstates NOI and makes the investment look better than it is.
- Forgetting capital expenditures (CapEx) vs. operating expenses — a new roof is a capital expense, not an operating expense, and including it in the NOI calculation artificially depresses the NOI for that year.
- Double-counting property management fees — if you self-manage, you should still include a market-rate management fee (typically 8-12% of gross rent) to get a realistic NOI that reflects true operating costs.
- Using projected rents instead of actual or verified market rents — sellers and brokers often present optimistic rent assumptions that inflate NOI beyond what the property will actually produce.
Frequently Asked Questions
Why is NOI so important?
NOI is the foundation for property valuation (via cap rate), loan qualification (DSCR), and measuring property performance. It isolates operating performance from financing decisions.
What is NOT included in operating expenses?
Mortgage payments (principal and interest), capital expenditures, depreciation, and income taxes are excluded from operating expenses when calculating NOI.
How can I increase NOI?
Increase income by raising rents, adding revenue streams, or reducing vacancy. Decrease expenses through better management, energy efficiency, tax appeals, or competitive bidding for services.
Ready to run the numbers?
Open Net Operating Income Calculator