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.
gross_rental_income = 72000other_income = 3600vacancy_pct = 7property_taxes = 6000insurance = 2400maintenance = 4800management_fee = 5040other_expenses = 2400
- 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%
Ready to run the numbers?
Open Net Operating Income Calculator