Back to blog
Underwriting••12 min read

Cap Rate Calculator for CRE: A Practical Guide

A field guide to calculating going-in and stabilized cap rates, interpreting what the number means, and building sensitivity analysis into your underwriting workflow.

By crematic editorial team

What a cap rate calculator actually tells you

A cap rate is one number that compresses a lot of assumptions into a single ratio. It is not a valuation. It is not a return. It is a snapshot of what the market currently demands for a specific income stream at a specific risk level. Understanding that distinction changes how you use the tool.

The basic formula is simple, but the inputs are not

Net operating income divided by purchase price. That is it. The problem is that NOI is itself a constructed number. It depends on rent roll, vacancy assumptions, operating expenses, and capital reserves. Change any one of those and the cap rate moves, even if the price stays the same.

This is why a cap rate calculator commercial real estate tool matters more than a simple spreadsheet. When the calculator enforces consistent definitions, the team stops debating whether NOI includes replacement reserves and starts debating whether the deal clears the threshold.

Going in cap rate versus stabilized cap rate

The going in cap rate uses trailing twelve-month NOI. It tells you what the property produces today, which is useful for stabilized assets with long lease terms and predictable expenses. The stabilized cap rate projects NOI after rent bumps, lease-up, or operational improvements.

Both numbers are valid. The mistake is comparing a going in cap rate on a value-add deal against a stabilized cap rate on a core asset. The first is a snapshot of current dysfunction. The second is a forecast of future performance. A good calculator lets you toggle between both so the committee knows which version they are looking at.

Why the spread to Treasuries matters more than the absolute number

A 5% cap rate means something different when the 10-year Treasury is at 2% than when it is at 4.5%. The spread, not the cap rate itself, measures how much extra return the market demands for illiquidity, operational risk, and asset-specific exposure.

In April 2026, with the 10-year at 4.33%, a 5% cap rate is a tight 67 basis point spread. That signals either a very safe asset or a market that is pricing in rent growth. A 6.5% cap rate in the same rate environment is a 217 basis point spread, which either means higher risk or a mispriced opportunity.

How to run cap rate sensitivity analysis before committee

Most deals die in committee because one partner asks what happens if rent growth is 50 basis points lower and nobody has the number ready. Cap rate sensitivity analysis fixes that by pre-computing the scenarios so the conversation stays strategic instead of turning into a live modeling session.

The two axes that matter: NOI and price

The standard sensitivity matrix varies NOI and purchase price independently, usually in 5% increments. This produces a grid where the center cell is your base case and the corners show best-case and worst-case combinations. The value is not in any single cell. It is in seeing how fast the cap rate moves when both variables shift.

A deal that drops from 6.0% to 4.8% with a 10% NOI decline and 10% price increase is fragile. A deal that only drops to 5.3% under the same stress is more resilient. That difference is what committee members actually care about when they ask how conservative the underwriting is.

When to add vacancy and expense stress

For multifamily and office assets, vacancy is the biggest driver of NOI variance. A stabilized cap rate calculator should let you stress vacancy independently, showing what happens at 90%, 85%, and 80% occupancy. For retail and industrial, expense ratios matter more because tenant improvement and leasing commissions can swing operating costs.

The rule of thumb is to stress the variable that has the widest historical range in your target submarket. If Class B office in your market has seen vacancy swing from 8% to 22% in the last decade, that is your stress range. Using a generic 5% stress misses the actual risk.

Building the matrix into your memo workflow

The sensitivity matrix belongs in the memo, not in a separate spreadsheet that the committee may or may not open. Embed it as a visual table with the base case highlighted so partners can scan the grid in seconds. The best practice is to add one sentence of commentary explaining which corner of the matrix would trigger a pass.

The matrix stops being a data artifact and starts acting like a decision tool. Instead of presenting numbers and waiting for questions, you bring a pre-analyzed range and a clear threshold. That is the difference between an analyst who reports and one who recommends.

If your team is still rebuilding cap rate math in Excel for every deal, a standardized calculator saves more time than you think.

Try the free cap rate calculator

How to interpret cap rates by market and asset class

A 5% cap rate in Austin multifamily is not the same as a 5% cap rate in Tampa office. Market depth, rent growth trajectories, expense burdens, and capital availability all change what the number means. Interpreting cap rates without market context is like reading blood pressure without knowing the patient's age.

Gateway markets trade on scarcity, secondary markets on yield

In gateway markets like New York, Boston, and San Francisco, institutional buyers accept sub-4% cap rates because they believe in rent growth, liquidity, and downside protection. The cap rate is not the return. It is the entry fee. In secondary markets like Indianapolis or Columbus, buyers want 6-7% because they need current yield to offset lower growth and thinner liquidity.

This means you cannot use a national average to judge a specific deal. According to CBRE's Q1 2026 survey, the spread between gateway and secondary multifamily cap rates was nearly 200 basis points. That gap is not a pricing error. It is a risk premium.

Asset class tells you what kind of risk the market is pricing

Multifamily typically trades at the tightest cap rates because rents reset annually and demand is relatively stable. Office trades wider because lease terms are longer and remote work has introduced structural demand risk. Industrial has compressed toward multifamily levels due to e-commerce demand, but location quality within that sector varies enormously. Retail is the widest and most heterogeneous, with grocery-anchored centers trading like multifamily and enclosed malls trading like distressed debt.

When you run a going in cap rate on a retail deal, you need to know whether the comp set is grocery-anchored strip centers or mixed-use town centers. The same formula produces a completely different signal depending on what you are comparing against.

Using submarket data to validate your number

Before you present a 5.5% cap rate to committee, check what similar assets have traded for in the same submarket in the last 12 months. Not the same metro. The same submarket. A deal in South Austin is not comparable to a deal in Round Rock, even though both are in the Austin MSA. Submarket boundaries matter because tenant demand, supply pipelines, and rent levels cluster at the neighborhood level, not the metro level.

If your calculated cap rate is more than 75 basis points away from the recent comp average, you need a story. Either you have found a mispriced asset, your NOI is wrong, or your price assumption is off. NCREIF research shows that outliers in either direction often indicate a modeling error rather than a market opportunity. The best analysts treat a wide spread as a warning, not a signal of genius.

Anonymized case study

Mid-Atlantic value-add acquisitions team (anonymized)

Challenge: A seven-person team was passing on deals too slowly because every analyst built their own cap rate model in Excel, creating version drift and inconsistent vacancy assumptions between screening and IC memos.

Approach: The team adopted a standardized cap rate calculator with built-in stabilized logic, locked vacancy and expense assumptions by asset class, and required a sensitivity matrix showing +/- 10% NOI and price variation before any deal moved to committee.

Outcome: Screening throughput rose roughly 40%, IC revision rates dropped by half, and partners stopped asking which version of the cap rate was real because the single source was visible to everyone.

Data points and sources

  • According to CBRE's Q1 2026 US Cap Rate Survey, multifamily cap rates averaged 4.85% nationally, with Class A assets in gateway markets trading below 4.0% and secondary market Class B assets above 6.0%. CBRE - Q1 2026 US Cap Rate Survey
  • The Federal Reserve's H.15 release from April 14, 2026, shows the 10-year Treasury at 4.33%, a spread of roughly 50-150 basis points above typical multifamily cap rates depending on market and asset class. Federal Reserve - H.15 Selected Interest Rates
  • Research from the National Council of Real Estate Investment Fiduciaries (NCREIF) shows that properties acquired at cap rates more than 75 basis points above the submarket average outperformed on a risk-adjusted basis over 10-year holds. NCREIF - Property Performance Research

Next step

If you want cap rate analysis integrated into your live IC process with market data, comps, and automated sensitivity, we can show you how it works.

Book a walkthrough

Related articles