Free calculators

NOI calculator

Net operating income from gross potential rent, through vacancy, concessions and recoveries to operating expenses, and the value it supports at a cap rate. Free, in the browser, no sign-up.

Net operating income is effective gross income less operating expenses: rent at full occupancy, less loss to lease, vacancy, concessions and bad debt, plus recoveries and other income, less the costs of running the building. With the defaults below, an illustrative 120,000 square foot multi-tenant property has NOI of $3,446,680, worth $55,146,880 at a 6.25 per cent cap rate.

Calculate

Results, updated as you type. The defaults reproduce the worked case.
ResultValue
Effective gross income (EGI)5,244,000
Management fee157,320
Total operating expenses1,797,320
Net operating income (NOI)3,446,680
NOI margin65.73%
Value at the cap rate55,146,880

Runs in your browser: nothing you type is sent anywhere.

Using this for a real deal?

The formula

EGI = GPR − loss to lease − vacancy − concessions − credit loss + recoveries + other income

NOI = EGI − operating expenses

Value = NOI / cap rate

How it works

Capital expenditure, tenant improvements, leasing commissions, debt service, depreciation and income taxes are not operating expenses: they come below NOI. A cap rate quoted on NOI already assumes the buyer pays for them out of the yield, which is why lenders also test coverage on cash flow after those items.

Use the same basis as the cap rate you apply: a market cap rate on in-place NOI, a stabilised cap rate on stabilised NOI. Mixing them is the commonest way to overvalue a building.

Go further with the worked example, step by step and the companion files for Real Estate Fund Management.

Embed this calculator

Free to embed on your website, blog or intranet, with no sign-up and no tracking. Copy the code below and paste it into any HTML block; the calculator resizes itself to fit.

Preview the embedded version

Questions people ask

How do you calculate NOI?

Start from gross potential rent, subtract loss to lease, vacancy, concessions and credit loss, add recoveries and other income to get effective gross income, then subtract operating expenses. The default property has $5,244,000 of EGI and $1,797,320 of expenses: NOI of $3,446,680.

Does NOI include debt service or capex?

No. NOI is before debt service, capital expenditure, tenant improvements and leasing commissions, depreciation and income taxes. Those belong to the owner’s financing and investment decisions, not to the building’s operations.

How do you value a property from NOI?

Divide NOI by the market cap rate: $3,446,680 / 6.25% = $55,146,880.

The book behind this calculator

This calculator comes from Real Estate Fund Management by Julian R. Sterling, which works the same case in full, with every figure in a free workbook.

Get the book on Amazon → DRM-free PDF edition, $19.99

If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review.

Not on Amazon: 10 paperbacks by Julian R. Sterling on tax and incentives, printed on demand and shipped worldwide. Browse the bookshop →

All free calculators → · Free Excel templates →