How to Calculate NOI (Net Operating Income) on a Rental Property
Net operating income, or NOI, is the income a rental property produces in a year after operating expenses, but before mortgage payments and income tax. The formula is rental income plus other income, minus vacancy, minus operating expenses. It shows how the property itself performs, regardless of how it was financed.
The template for thisSmall Business Spreadsheet Bundle $20.30 · 30% off→
The formula
NOI = (gross potential rent - vacancy and unpaid rent + other income) - operating expenses
Step by step
- Work out gross potential rent: the rent you would collect in a year if every unit were let and paid in full.
- Subtract vacancy and unpaid rent. Use your actual figures, or an estimate such as 5% if you are projecting.
- Add other income: parking, laundry, storage, pet fees, late fees.
- Total your operating expenses for the year.
- Subtract operating expenses from the income figure. The result is NOI.
What counts as an operating expense
| Included in NOI | Not included in NOI |
|---|---|
| Property taxes | Mortgage principal and interest |
| Landlord insurance | Income tax |
| Repairs and maintenance | Depreciation |
| Property management fees | Major improvements (new roof, extension) |
| Utilities the owner pays | Purchase and loan closing costs |
| Cleaning, gardening, pest control | The owner's personal costs |
| Advertising, letting and legal fees | |
| Association or service charges |
The mortgage is left out on purpose. Two owners of identical buildings, one with a loan and one without, have the same NOI. That is what makes NOI useful for comparing properties.
Worked example
A duplex has two units let at 1,800 a month each.
| Line | Amount per year |
|---|---|
| Gross potential rent (2 x 1,800 x 12) | 43,200 |
| Less vacancy at 5% | -2,160 |
| Rent collected | 41,040 |
| Other income (laundry and parking) | 600 |
| Effective gross income | 41,640 |
| Property taxes | 4,500 |
| Insurance | 1,600 |
| Repairs and maintenance | 2,600 |
| Management (8% of rent collected) | 3,283 |
| Utilities | 1,200 |
| Other (gardening, advertising, fees) | 900 |
| Total operating expenses | 14,083 |
| Net operating income | 27,557 |
Operating expenses are about 34% of effective gross income. This operating expense ratio is a useful check: if a seller's figures show a very low ratio, some costs have probably been left out.
Repairs versus improvements
Fixing a leaking tap or repainting between tenants is a repair, and belongs in operating expenses. Replacing the whole roof or adding a room is a capital improvement, and is normally left out of NOI. Because big replacements do eventually come, many owners set aside a yearly reserve for them and look at NOI both with and without it. The line between repair and improvement also matters for tax, where the rules are specific to your country, so check with an accountant.
What NOI is used for
- Cap rate: NOI divided by property value. Here, 27,557 / 360,000 = 7.65% on a 360,000 purchase price.
- Estimating value: NOI divided by a market cap rate.
- Checking loan cover: lenders often compare NOI with yearly loan payments.
- Tracking performance: is NOI rising or falling year on year?
NOI is not cash flow
Cash flow is what is left after the mortgage. If the loan payments on this duplex total 20,479 a year, cash flow before tax is 27,557 - 20,479 = 7,078. A property can have a healthy NOI and still lose cash every month if the loan is large.
Common mistakes
- Assuming no vacancy. Even good properties have gaps between tenants.
- Leaving out management because you manage it yourself. Your time has a cost, and a future buyer or lender will include it.
- Underestimating repairs by using one quiet year.
- Including the mortgage, which makes NOI useless for comparison.
- Trusting a listing's figures. Ask for actual records and rebuild the NOI yourself.
- Mixing months and years. NOI is an annual figure.
This guide explains how the calculation works. It is not investment, tax or legal advice. Speak to qualified professionals before buying or valuing a property.
NOI per property, calculated for you
The Content Crib Rental Property Manager handles up to 10 properties with units and tenants, a rent ledger with a 12-month grid, expenses and a maintenance log. It produces a profit and loss for each property with NOI, cap rate and cash-on-cash return, and flags leases that are ending soon. It works in Excel, Google Sheets and Apple Numbers.

Skip the blank page
The Small Business Spreadsheet Bundle includes the Rental Property Manager, laid out and ready to use. $20.30, instant download.
Get the Small Business Spreadsheet BundleRelated guides
- How to Do Bookkeeping for a Small Business (Beginner Guide)
- Cash Basis vs Accrual Accounting: The Difference in Plain English
- Profit and Loss Statement for a Small Business: How to Make One
- Simple CRM Spreadsheet: What to Track and How to Set It Up
- Sales Pipeline Stages Explained (With Examples for Small Business)