NOI and cap rate calculator
This calculator turns a property's rent and operating expenses into net operating income (NOI), then shows the cap rate at your purchase price and the value at the cap rate you target.
NOI$101,036
- Effective gross income
- $164,400
- Operating expenses
- $63,364
- Expense ratio
- 38.5%
- Cap rate at this price
- 5.46%
- Value at target cap rate
- $1,554,400
For planning only. Not a loan offer or commitment to lend.
What NOI is, and is not
NOI is income after vacancy and operating expenses, before any loan payment. Debt service, depreciation, and capital improvements are not operating expenses, so they stay out of NOI. That keeps NOI about the property itself, separate from how it is financed.
The formula, step by step
Gross potential rent = monthly rent x 12 Effective gross income = gross potential rent - (gross potential rent x vacancy %) + other income x 12 Management = effective gross income x management % Operating expenses = taxes + insurance + management + repairs and maintenance + utilities + other expenses NOI = effective gross income - operating expenses Expense ratio = operating expenses / effective gross income Cap rate at this price = NOI / purchase price Value at target cap rate = NOI / target cap rate
Two details in how this calculator works:
- Vacancy and credit loss apply to the gross rent only. Other income is added after vacancy.
- Management is a percent of collected income, which here is the effective gross income, other income included.
Worked example with the default numbers
| Input | Default |
|---|---|
| Gross rent, per month | $14,000 |
| Other income, per month | $400 |
| Vacancy and credit loss | 5% |
| Property taxes, per year | $18,500 |
| Insurance, per year | $14,000 |
| Management, % of collected | 6% |
| Repairs and maintenance, per year | $9,000 |
| Utilities, per year | $7,200 |
| Other expenses, per year | $4,800 |
| Purchase price | $1,850,000 |
| Target cap rate | 6.5% |
- Gross potential rent: $14,000 x 12 = $168,000.
- Vacancy at 5%: $8,400. Other income: $400 x 12 = $4,800.
- Effective gross income: $168,000 - $8,400 + $4,800 = $164,400.
- Management at 6%: $9,864.
- Operating expenses: $18,500 + $14,000 + $9,864 + $9,000 + $7,200 + $4,800 = $63,364.
- NOI: $164,400 - $63,364 = $101,036.
- Expense ratio: $63,364 / $164,400 = 38.5%.
- Cap rate at this price: $101,036 / $1,850,000 = 5.46%.
- Value at a 6.5% cap rate: $101,036 / 6.5% = $1,554,400.
| Result | Default output |
|---|---|
| NOI | $101,036 |
| Effective gross income | $164,400 |
| Operating expenses | $63,364 |
| Expense ratio | 38.5% |
| Cap rate at this price | 5.46% |
| Value at target cap rate | $1,554,400 |
Reading the two cap rate lines
The calculator runs cap rate both ways. At the $1,850,000 price, this NOI is a 5.46% cap rate. If you want a 6.5% cap rate, the same NOI supports a value of $1,554,400. The gap between the two shows how far the asking price is from the cap rate you want.
How sensitive NOI is
Small inputs move NOI. Raise vacancy from 5% to 8% in the default example and NOI drops from $101,036 to $96,298. The cap rate at the price falls from 5.46% to 5.21%, and the value at a 6.5% cap rate falls from $1,554,400 to $1,481,514.
How lenders use NOI
Commercial loans are sized on the property's NOI, DSCR, and debt yield. Take your NOI to the commercial loan sizing calculator to see the loan each test allows, or to the cash-on-cash calculator to see your return after the loan payment.
The numbers behind NOI come from two documents in the format lenders ask for:
- A T-12 operating statement: trailing twelve months of income and expenses, NOI, and expense ratio.
- A rent roll: units, leases, rents, and occupancy.
Frequently asked questions
What is NOI in real estate?
NOI, or net operating income, is the income left after vacancy and operating expenses, before any loan payment. Effective gross income minus operating expenses equals NOI. With the default numbers, $164,400 of effective gross income minus $63,364 of operating expenses leaves $101,036 of NOI for the year.
What counts as an operating expense?
Taxes, insurance, management, repairs and maintenance, utilities, and other running costs count. Debt service, depreciation, and capital improvements do not, so they stay out of NOI. That keeps NOI separate from how the property is financed. The T-12 operating statement template follows the same rule for twelve months of actual numbers.
How do you calculate cap rate?
Divide NOI by the price. $101,036 of NOI on a $1,850,000 price is a 5.46 percent cap rate. The calculator also runs it the other way: at a 6.5 percent target cap rate, the same NOI supports a value of $1,554,400, which is NOI divided by the cap rate.
What is the expense ratio?
The expense ratio is operating expenses divided by effective gross income. In the default example, $63,364 of operating expenses on $164,400 of effective gross income is a 38.5 percent expense ratio. The T-12 operating statement template computes the same ratio from twelve months of actual income and expenses.
Does vacancy apply to other income in this calculator?
No. Vacancy and credit loss apply to gross rent only, and other income is added after vacancy. Management is then figured as a percent of the collected total, other income included. If your own model applies vacancy to all income, your NOI will come out slightly lower than this calculator shows.
How do lenders use NOI?
Commercial loans are sized on the property's NOI, DSCR, and debt yield, so NOI drives the loan amount. Take the NOI from this calculator into the commercial loan sizing calculator to see what each test allows. The T-12 and rent roll templates hold the numbers in the format lenders ask for.
Templates and guides
- T-12 operating statementTrailing twelve months of income and expenses, NOI, and expense ratio.Excel · 54 KB
- Rent rollUnits, leases, rents, and occupancy in the format lenders ask for.Excel · 54 KB
- Deal analyzer workbookRental analysis, 5-year pro forma with IRR, flip and BRRRR, commercial loan sizing.Excel · 243 KB
Run your scenario by us
Two minutes. No credit pull, no SSN, no fee to talk. A licensed loan officer calls you back the same business day.
(813) 356-9448info@aluracapital.com
Ready to apply? The application opens on NEXA Mortgage's site, the licensed mortgage company our loans run through. Same team, same file.
Apply now on NEXA Mortgage's site, opens in a new tabGot it.
A licensed loan officer will call you the same business day. Want to skip the wait? Call or text (813) 356-9448.
Ready to start your application now? It opens on NEXA Mortgage's site.
Apply now on NEXA Mortgage's site, opens in a new tab