Cap Rate Calculator

Solve for the cap rate, the value a cap rate implies, or the NOI a price requires. The sensitivity table shows what the answer does when the rate moves, which is the part the formula on its own leaves out.

Solve for
$
$
Cap rate
—

Enter an NOI and a property value to see the result.

Download the Excel versionLive formulas, works offline, no signup.
TL;DR

A cap rate calculator divides net operating income by price to give the unlevered yield a commercial real estate asset produces. Capitalization rate is the same number under its full name. This one runs the equation in all three directions: the rate from income and price, the price a target rate implies, and the NOI an asking price requires. It also shows what the answer does when the rate moves 50 or 100 basis points, the exposure a single number hides. Free, no signup, and there is a cap rate calculator Excel version carrying the same formulas.

Cap rates, as Simon Jawitz wrote in Thesis Driven, “serve a real purpose but are often misunderstood and misused,” much as price/earnings ratios do in corporate finance. The division itself takes four seconds; almost every wrong cap rate is a wrong input rather than wrong arithmetic.

A stated NOI that quietly omits a management fee. An asking price treated as the all-in basis. A rate typed as 0.075 when 7.5 was meant, which is wrong by a factor of a hundred and looks perfectly plausible on the screen. The tool above is built to make those inputs visible instead of inherited, and to flag the third error rather than compute it.

Which direction to solve in

Three numbers, two of them always known, so there are three questions rather than one. Most tools answer only the first.

  • The yield. An NOI and a price produce the cap rate. This is the comparison number, the one that travels between deals.
  • The price. An NOI and a target rate produce the value that rate supports. A broker quotes an ask; this is what answers whether the ask is rich. It is the calculation people mean by a reverse cap rate calculator.
  • The income. A price and a rate produce the NOI the price requires. Useful in the other direction: an offering memorandum quoting a 6 cap on a $12 million ask is claiming $720,000 of income, and the trailing statements either support that or they do not.
Cap rate=NOI ÷ property value

The cap rate formula, rearranged: value = NOI ÷ cap rate, and NOI = value × cap rate.

Where a real estate cap rate calculator gets its two numbers

Both inputs are softer than they look, and both are usually handed over by the party selling the building.

Net operating income appears twice in a deal package, in the offering memorandum and in the trailing twelve months of operating statements (the T12), and the two rarely agree. The OM figure is forward-looking; the T12 is what actually happened. The gap between them is the seller’s assumption about what the asset does next, and it belongs in the analysis rather than in the numerator. NOI itself runs after operating expenses and before debt service, capital expenditure, tenant improvements and depreciation.

Property value on an acquisition means the all-in basis, not the headline price. Closing costs, immediate capital needs and any assumption or defeasance costs belong in the denominator. A cap rate struck on the purchase price alone overstates the yield on the money actually committed, which is the flattering direction to be wrong in.

Worked example, in-place rents at market
Gross potential rent
$720,000
Vacancy and credit loss at 5%
−$36,000
Effective gross income
$684,000
Operating expenses
−$274,000
Net operating income
$410,000
All-in basis
$6,000,000
Cap rate
6.83%

$410,000 divided by $6,000,000 is 6.83%. Run the same NOI at a 7.5% exit and the building supports $5,466,667, so $533,333 of value disappears with nothing changing at the property. That asymmetry is the reason the sensitivity table exists.

Checking the expense load

A stabilised asset typically runs operating expenses around 40% of effective gross income. That single ratio catches more bad NOI than any other check, which is why the builder above reports it back.

Fifty to sixty percent signals an asset that is not performing, or one carrying heavy payroll. Below about 25% usually means something is missing from the expense load rather than a building that is cheap to run, and the omission is most often management, insurance or reserves. For a multifamily cap rate calculation the load includes taxes on assessed value, insurance quoted per unit, a management fee struck as a percentage of effective gross revenue, and replacement reserves that lenders commonly require at 25 to 50 cents per square foot.

Reserves sit below the NOI line by convention, which is why two buildings with identical NOI are not identical if one has just had a roof and the other needs one. Entering a reserve figure gives the economic rather than the nominal number, a distinction the cap rate guide covers in full. Published operating-expense benchmarks come from Income/Expense IQ, compiled jointly by IREM, the National Apartment Association and BOMA from property-level data by asset type and market.

Why there is no mortgage field

The omission is deliberate: NOI is struck before any loan payment, so the same building returns the same rate bought all cash or at 65% leverage, and that is what makes two buildings comparable. Add financing and the number stops describing the asset and starts describing the buyer.

The metric that carries the loan and still rhymes with a cap rate is debt yield, which is NOI over loan amount rather than NOI over value. When debt yield equals the cap rate, the loan equals the property value and the deal is 100% levered, which is why lenders want debt yields comfortably above prevailing cap rates. For the levered view use debt service coverage ratio, debt yield, or cash-on-cash return.

What happens when the cap rate moves

Cap rates are set outside the building, which is why they move value more than operations do. The five-year Treasury works as a rough proxy, and it ran under 2% in early 2022, near 3% by the middle of that year, and close to 4% by 2025. Current levels are published daily by the US Treasury and weekly by the Federal Reserve. A cap rate lifted from a 2022 comparable and applied to a 2026 deal is not conservative. It is stale.

A single quoted cap rate carries that staleness forward, which is why a range across a five, five and a half, six and six and a half cap works better: it lets a reader see the return scenarios rather than accept one rate that may not be backed by much. The table above does that in basis points, holding NOI still so the movement shown is pure valuation exposure, the kind that arrives between signing and closing or between underwriting and exit.

The formula is not the hard part; the exit assumption is, and the operators who compound through a cycle treat theirs as a bet to stress-test rather than a figure to plug in.

Keep building your underwriting stack

Frequently asked questions

What is the best cap rate calculator?

Short answer: The one that solves in the direction the question actually runs. Most cap rate calculators only divide NOI by price, which answers the easy question and leaves the two harder ones alone.

The useful additions are a reverse mode, so an asking price can be tested against a target rate, and a sensitivity view, so the answer is not a single number pretending to be certain. This calculator does both, plus an expense-ratio check on the income side.

How do you use a cap rate calculator?

Short answer: The direction comes first, then the two numbers that are known. Solving for the rate needs an NOI and a price; solving for value needs an NOI and a target rate; solving for NOI needs a price and a rate.

The inputs matter more than the operation: net operating income runs after operating expenses and before debt service, capital expenditure and depreciation, and property value means the all-in basis on an acquisition rather than the headline price. With those two right the arithmetic is trivial.

Can a cap rate calculator work backwards from a cap rate to a price?

Short answer: Yes, and it is the mode that gets used most on live deals. Switching to “What should I pay?” divides the NOI by the target rate and returns the value that rate supports.

That is the move behind a reverse cap rate calculation: a broker quotes an asking price, and the operator wants to know what price a defensible rate actually justifies before responding.

Does a cap rate calculator include the mortgage?

Short answer: No, and that is the point. A cap rate is struck on NOI, which sits above debt service, so the same building returns the same rate bought all cash or at 65% leverage.

A cap rate calculator with mortgage inputs is measuring something else. For the levered view the metrics are debt service coverage ratio, debt yield and cash-on-cash return, each of which takes the loan terms the cap rate deliberately leaves out.

How do you work out the NOI to put into a cap rate calculator?

Short answer: Gross potential rent less loss to lease, less vacancy and credit loss, plus other income, less operating expenses. The builder above runs that order and shows every line.

Replacement reserves sit below the NOI line, giving the economic rather than the nominal figure. The check worth running afterwards is the expense ratio: a stabilised asset lands near 40% of effective gross income, and a number far below that usually means a cost has been left out.

Is there a cap rate calculator for Excel?

Short answer: There is one linked under the calculator above, free and without a signup.

It carries live formulas rather than a static snapshot, solves in the same three directions, builds NOI from a rent roll, and includes the basis-point sensitivity table. A second sheet covers what belongs in NOI and where cap rates stop being comparable.

Last updated: September 2026