JJENCP CalculatorsFree tools from JENCP Templates

Cap rate and NOI calculator

Build net operating income the way a lender or appraiser would, then see the cap rate at the asking price and the price that hits your target.

Inputs

Price and income
Gross scheduled rent at 100% occupancy.
Laundry, parking, storage, pet fees.
% of rent.
Operating expenses
Use the post-sale assessment if your state reassesses.
% of gross rent.
% of collected income. Include it even if you self-manage.
Owner-paid only.
Your target

Results

Loading… (this calculator needs JavaScript)

How the numbers are calculated

Effective gross income = rent × 12 × (1 − vacancy %) + other income × 12 Operating expenses = taxes + insurance + other × 12 + repairs % × gross rent + management % × EGI NOI = EGI − operating expenses Cap rate = NOI ÷ price Value at target cap = NOI ÷ target cap rate Expense ratio = operating expenses ÷ EGI

NOI excludes the mortgage, depreciation, income taxes and one-time capital projects. That’s the point: it measures the property, not how you financed it, so you can compare deals. The expense conventions here match the Rental Deal Quick Analyzer spreadsheet.

Worked example

A small multifamily at $500,000 with $4,000 a month in rent and $150 a month of laundry and parking income.

Gross scheduled rent$48,000
Vacancy (5%)−$2,400
Other income$1,800
Effective gross income$47,400
Taxes−$7,000
Insurance−$2,400
Repairs (6% of gross rent)−$2,880
Management (8% of EGI)−$3,792
Utilities and other ($300 × 12)−$3,600
NOI$27,728

Cap rate is $27,728 ÷ $500,000 = 5.55%. At a 7% target the same NOI supports a price of $27,728 ÷ 7% = $396,114. To justify the asking price at 7%, NOI would need to be $35,000, which is $7,272 more than it is today. The expense ratio is 41.5%.

Practitioner notes

  • Underwrite your NOI, not the seller’s. Listing NOI often leaves out management (“I self-manage”), uses last year’s taxes, and skips vacancy. Rebuild it here.
  • Taxes reset on sale in many places. Use the tax bill you’ll get at your purchase price.
  • Expense ratios for small residential rentals often land somewhere around 35–50% of EGI once management and reserves are in. A pro forma well under that deserves a second look.
  • A cap rate is only meaningful against market cap rates for the same asset type and location. A 6% cap on a new building and a 6% cap on a 1920s walk-up aren’t the same deal.