FINANCIAL MODELING

IRR Calculator and Formula for Real Estate: A Practitioner's Guide

May 2026 · 20 min

Free IRR Calculator

Enter the equity outflow at Year 0 (as a negative number) and the cash inflows in each subsequent year. For the last year, include both operating distributions and the net sale proceeds (sale price minus loan payoff minus selling costs). The widget computes IRR via Newton-Raphson iteration with a bisection fallback; it returns IRR, MOIC, total profit, and average annual cash-on-cash live as you type.

IRR (LEVERED) —

MOIC —

TOTAL PROFIT —

AVG ANNUAL CASH-ON-CASH —

Outputs assume cash flows occur at year-end. For monthly or irregular timing, use Excel's =XIRR() function with explicit dates. For an apples-to-apples MIRR with a chosen reinvestment rate, see the sibling methodology pillar.

DO IT IN APERS

The widget above is fine for a single-deal IRR check. For an actual underwrite — with NOI build-up, debt sizing, exit cap sensitivity, levered/unlevered toggles, and a 2×2 sensitivity table — AQ-130, the Apers Multifamily Value-Add Pocket Model, runs all of it on a single sheet from eight inputs in minutes. Screen your value-add deal →

The Calculator Practitioners Actually Need

Search "IRR calculator" on Google in May 2026 and the top three results are generic finance tools: Calculator.net, OmniCalculator, and a Janover sub-brand that — despite the URL — isn't actually a multi-period IRR calculator. It accepts an initial investment, a single total return, and a holding period, then computes a payback-style return dressed as an IRR. A practitioner modeling a CRE deal who lands there leaves immediately because the tool can't represent the cash flow shape of an actual acquisition.

A real CRE deal has Year 0 equity, Years 1–N operating distributions that grow with NOI, a refi event or two in the middle, a sale at exit, and a debt payoff that nets out the loan balance. The IRR for that stream is the practitioner's first-pass return signal. This page is the calculator built for that math, with the institutional depth around it that the search results above are missing — the formula, a worked $25M multifamily example, the reinvestment-assumption problem, 2026 asset-class benchmarks, and the seven mistakes that show up most often at investment committee.

THE 30-SECOND VERSION

IRR is the discount rate that makes the present value of a deal's cash flows equal zero. For CRE, that means Year 0 equity, operating distributions, refi events, and a net sale at exit. Use IRR alongside MOIC (total cash returned per dollar in) and cash-on-cash (current-period yield). Quote IRR in the 2026 rate environment with MIRR or a reinvestment-rate caveat — the gap between IRR and realized return is now wide enough to matter.

What IRR Actually Is

The internal rate of return on a CRE deal is the single discount rate at which the net present value of all the deal's cash flows — the equity check at Year 0, the operating distributions during the hold, any capital events like a refinance, and the net sale proceeds at exit — sums to zero. Mathematically, IRR is the value of r that solves the NPV equation. Operationally, it is the annualized return on the equity dollars at risk in the deal, time-weighted across the hold.

Two things IRR is not. It is not a forecast of the dollar amount in the LP's bank account at exit — that requires a separate assumption about what happens to interim distributions after they are received. And it is not a complete return picture for any deal with material capital events or a non-trivial hold; pair it with MOIC and cash-on-cash before quoting. The metric stack section below makes this concrete.

The IRR Formula

The IRR is defined as the discount rate r that solves:

THE IRR FORMULA

NPV = Σ_t=0ⁿ CF_t / (1 + IRR)^t = 0

For cash flows beyond two periods, the equation has no closed-form solution and must be solved numerically. The calculator above uses Newton-Raphson iteration with a guess of 10%, falling back to bisection on pathological cash flows. Excel does the same thing internally when you call =IRR().

The CRE-specific subtlety is in what counts as a cash flow. A standard convention: Year 0 is the all-in equity check (purchase price + closing costs + immediate-need CapEx − loan proceeds, signed negative). Years 1 through N are net distributable cash to equity (NOI − debt service − replacement reserves − any capital draws). The final year combines operating cash with net sale proceeds (sale price − selling costs − loan payoff). Some practitioners separate the operating final-year cash flow from the sale on two rows for clarity; the math is identical either way.

Worked Example: $25M Multifamily Value-Add

A 180-unit garden-style multifamily acquisition. $25M purchase price; $17.5M agency bridge loan at 6.0% interest-only; $7.5M equity check. Five-year hold. NOI starts at $1.4M (post-acquisition stabilization) and grows to $1.9M by Year 5 through a phased renovation program. Annual debt service runs at $1.05M for the bridge period (60 bps amort after the IO window, but year-five exit closes before meaningful amortization). Exit at a 5.75% cap rate on the Year-5 NOI of $1.9M gives a $33M gross sale; $1M selling costs and $17.5M loan payoff leave $14.5M net to equity. Adding the Year 5 operating cash of $900K, the total Year 5 distribution is $15.4M.

The full cash flow stream to equity:

Five-year cash flow to equity for a $25M multifamily value-add. NOI build through renovation and a 5.75% exit cap drive the headline 21.4% levered IRR. The same stream produces a 2.36x equity multiple and ~8.4% average annual cash-on-cash.

Punching these into the calculator above (Year 0: -7,500; Year 1: 350; Year 2: 500; Year 3: 650; Year 4: 750; Year 5: 15,350) returns the headline metrics:

Levered IRR: 21.4% (Newton-Raphson converges in 6 iterations from the 10% guess)
MOIC: 2.36x (total $17.6M back on $7.5M in)
Total profit: $10.1M
Average annual cash-on-cash: 8.0%

The numbers are reproducible. Calculator, Excel =IRR(), and a Newton-Raphson hand-computation all converge to the same value within rounding error. The widget is the fast path; the formula above is what's happening under the hood.

IRR vs. MOIC vs. Cash-on-Cash

IRR is one number from a set. A complete return picture for the same $25M multifamily deal includes:

Metric	This deal	What it answers	Limitation
IRR	21.4%	Time-weighted annualized return	Says nothing about absolute dollars; can mislead on very short or very long holds
MOIC / Equity Multiple	2.36x	Total cash returned per dollar in	Time-blind — 2.36x in 3 years and 2.36x in 8 years are very different deals
Average Annual Cash-on-Cash	8.0%	Average current yield on equity during the hold	Excludes the exit; ignores time-value across years
Total Profit	$10.1M	Absolute dollars made	Time-blind, scale-bound — useful for IC anchoring, not comparison

The right metric to lead with depends on the audience and the deal shape. Core funds lead with stabilized cash-on-cash and quote IRR as a cross-check. Value-add and opportunistic funds lead with IRR but increasingly cite MIRR alongside. Family offices and direct investors often care more about MOIC than IRR because their hold periods are flexible. Knowing the question you're answering is part of the job. The fuller treatment is in the sibling pillars on equity multiple and MOIC and cash-on-cash return.

The Reinvestment-Assumption Problem

A 21.4% IRR does not mean a $7.5M equity check turns into $7.5M × 1.214⁵ = $19.9M at exit. The actual distribution stream sums to $17.6M. The reconciliation requires assuming the interim distributions ($350K, $500K, $650K, $750K, and the Year 5 operating cash of $850K) reinvested at the IRR itself — an assumption that is exogenously imposed when reconciling IRR to a CAGR, not a property of the IRR formula. The full treatment of this distinction lives in the sibling methodology pillar — including the Magni-Martin academic position and the MIRR formula.

The practical 2026 implication: at a 5% risk-free reinvestment proxy (money-market funds), the MIRR on this deal is roughly 19.7% — about 170 bps below the headline IRR. On a deal with more front-loaded distributions, the spread can be 500–800 bps. Quote both numbers in the IC memo. The market is converging there anyway.

What's a Good IRR in 2026?

"Good" depends on asset class, capital structure, and strategy. As of May 2026 — with the 10-year Treasury around 4.20%, money-market funds at 4.00–4.50%, and agency multifamily debt at 5.5–6.5% all-in — institutional levered IRR target bands look approximately like this:

Strategy / Asset Class	Target Levered IRR	Typical hold
Multifamily core (gateway)	8–11%	7–10 yrs
Multifamily core-plus	11–13%	5–7 yrs
Multifamily value-add	14–18%	3–5 yrs
Multifamily opportunistic / development	18%+	3–7 yrs
Industrial core	9–12%	5–10 yrs
Industrial value-add	14–17%	3–5 yrs
Office core (top-of-market only in 2026)	10–13%	5–10 yrs
Office opportunistic / repositioning	18%+	3–5 yrs
Retail anchored center	10–14%	5–7 yrs
Hospitality (full-service)	15%+	3–5 yrs
Self-storage	10–14%	5–7 yrs

These bands have shifted upward 200–300 bps from 2019 norms because the cost of capital is higher. A 12% multifamily value-add IRR target made sense at a 3.5% agency rate; at 5.75% it doesn't. Per NCREIF, CBRE, and Green Street data, transaction-based IRR targets in the May 2026 market sit consistently 200 bps above the 2019–2021 baseline at the same risk level.

Seven Mistakes Practitioners Make

Quoting IRR alone without MOIC. A 30% IRR on a four-month deal returns less absolute cash than a 12% IRR on a five-year deal. IRR rewards speed regardless of scale; MOIC reveals the difference. Pair them on every memo.
Comparing levered IRR to unlevered IRR without flagging it. A deal can show 11% unlevered and 18% levered — but the levered number includes term, refi, and bridge-to-perm risk that the unlevered number doesn't. When comparing two deals or two scenarios, hold leverage constant or explicitly disclose which IRR is which.
Ignoring the reinvestment-assumption gap. A 22% IRR in a 4% risk-free environment overstates the realized CAGR by 500–800 bps unless interim distributions actually compound at 22%. Quote MIRR alongside on long-hold value-add and opportunistic deals.
Using IRR on very short holds. A 1.15x return in six months annualizes to ~32% IRR. Including that in a comp table next to 5-year-hold IRRs is statistical malpractice. Either annualize the longer holds the same way (don't) or restrict the comp set to comparable hold periods.
Treating IRR as path-independent. Two deals with identical total cash returns and identical holds can produce different IRRs depending only on when the cash comes back. Earlier cash always wins on IRR — even when it's earlier because the deal has unhealthy front-loaded distributions that won't sustain. Read the cash flow shape, not just the IRR.
Using =IRR() on irregular cash flows. Real CRE models run on monthly or quarterly cash flows with mid-period refi closings and lumpy capex. The =IRR() function assumes equal-interval flows and returns garbage when the assumption is violated. Use =XIRR(values, dates) for any model with non-annual periods.
Treating projected IRR as a number, not a distribution. A 17% IRR with 25-point sensitivity (downside 6%, upside 28%) is a different deal than 17% with 5-point sensitivity. The first is a venture bet marketed as core-plus. The second is core-plus. Build the sensitivity tables — this is what sensitivity analysis is for.

The 2021-Vintage IRR Refresh

A meaningful share of 2021–2022 vintage value-add multifamily deals were underwritten at 18–25% IRR on a stack of assumptions that have not held: 3.5% agency take-out, 4.0–4.5% exit caps, IRR-itself reinvestment of interim distributions. All three legs are broken in 2026. Today's take-out debt is 5.5–6.5%, exit caps have widened to 5.5–6.5% on most submarkets, and reinvestment proxies are 4–5% rather than 18–25%.

Re-running the same cash flow stream through a refreshed underwriting produces an IRR materially below the advertised number. For an LP holding a 2021 commitment, the question is no longer "what is my IRR?" — it is "what IRR is this deal actually going to deliver given the current take-out market?" The math is straightforward when the cash flows are visible: extend the hold by 12–36 months to bridge the refi gap, refresh the exit cap to current submarket, recompute. The advertised IRR was a function of assumptions that have changed; the refreshed IRR is a function of the assumptions that are now true.

For sponsors and LPs working through these deals in 2026, AQ-130 handles the refreshed underwriting in minutes — updated rate cap, updated exit cap, updated hold period, fresh IRR/MOIC/cash-on-cash output.

How to Model IRR in Excel

Three Excel functions cover essentially all CRE IRR work:

=IRR(values, [guess]) — the standard IRR for an annual cash flow stream. Values is the range of cash flows starting with the Year 0 equity check (negative). Guess is optional; 0.10 is the default. Returns the annualized IRR. Use this only when cash flows occur exactly at year-end intervals — the function silently produces nonsense when the assumption is violated.
=XIRR(values, dates, [guess]) — the right function for any real CRE model. Values is the range of cash flows; dates is a parallel range of the actual dates of those cash flows. XIRR computes the IRR using actual day-count between flows. Default this in your model templates.
=MIRR(values, finance_rate, reinvestment_rate) — the modified IRR that explicitly handles interim cash flow reinvestment. Finance_rate is the cost of capital for the negative cash flows (typically the debt rate or WACC); reinvestment_rate is the assumed yield on distributed cash (typically the risk-free rate or the LP's opportunity cost). In 2026, a sensible default reinvestment_rate is 4.5–5%.

Common Excel-side errors: forgetting to format Year 0 as negative; using =IRR() on a column that starts with the wrong row; entering a non-annual cash flow stream into =IRR() without converting to =XIRR(); leaving the guess argument off when the cash flow stream is unusual (very short, very long, or sign-changing) and letting the function fail silently. The widget at the top of this page handles all of these automatically, but in a production model, default to =XIRR() with explicit dates.

From a Quick IRR to a Full Pro Forma

The calculator on this page checks an IRR. The harder work is building the cash flow stream that the IRR is computed on. Real CRE underwriting requires unit-by-unit rent rolls, monthly NOI build-up, bridge-to-perm debt modeling with rate cap costs, replacement reserve scheduling, exit cap sensitivity, and 2×2 stress tables on the inputs that move the answer. None of that fits in an 8-row cash flow grid.

Apers ships a stack of multifamily acquisition models that handle the underwriting end-to-end:

AQ-130 — Multifamily Value-Add Pocket Model. Five-minute pre-LOI screen with the full IRR + MOIC + cash-on-cash output stack and a 2×2 sensitivity table on exit cap and rent growth. The natural next step from this calculator.
AQ-110 — Multifamily Core/Core-Plus Pocket Model. Same architecture, calibrated for stabilized assets.
AQ-111 — Multifamily Core/Core-Plus Pro Forma. The full institutional model with 10-year monthly cash flow, unit-level rent rolls, bridge-to-perm debt mechanics, and IC-ready outputs. The graduate-to when the pocket-screen passes.

DO IT IN APERS

You can run a single-deal IRR in the calculator above or in Excel. For an actual underwriting — rent roll, debt sizing, exit cap sensitivity, full IRR/MOIC/cash-on-cash stack with a sensitivity table — AQ-130 handles it on a single sheet from eight inputs in minutes. Screen your value-add deal →

The calculator pillar links into the broader returns-analysis cluster and the valuation cluster:

IRR Formula and the Reinvestment-Assumption Question — the methodology pillar; deeper treatment of the formula, MIRR, and the academic critique.
Equity Multiple and MOIC: When the Multiple Matters More Than IRR — the time-blind complement metric.
Cash-on-Cash Return: Levered vs. Unlevered — the current-yield metric.
IRR Sensitivity Analysis and Stress Testing — how to read IRR as a distribution, not a number.
TVPI, DPI, and RVPI: Fund-Level Return Metrics for LPs — fund-level analogs of IRR and MOIC.
Cap Rate Calculator and Formula — the entry-yield metric every IRR conversation eventually references.
Preferred Return: Simple vs Compounding vs Accruing — how IRR interacts with promote structures.

FAQ

Frequently Asked Questions

How do you calculate IRR for a real estate investment?

Build the cash flow stream to equity: Year 0 is the all-in equity check signed negative; Years 1 through N are net distributions to equity (NOI minus debt service minus reserves, plus any refi proceeds, plus the net sale at exit minus loan payoff and selling costs). IRR is the discount rate that makes the NPV of that stream equal zero. Use the calculator above or Excel's =XIRR() function (preferred over =IRR() because real CRE cash flows are rarely on perfect annual intervals).

What is a good IRR for real estate in 2026?

Depends on strategy and asset class. Multifamily core targets 8–11% levered, core-plus 11–13%, value-add 14–18%, opportunistic 18%+. Industrial core 9–12%, value-add 14–17%. Office in top markets 10–13%, repositioning 18%+. Hospitality 15%+. These ranges shifted upward 200–300 bps from 2019 norms because the cost of capital is higher. Always interpret IRR alongside MOIC and the sensitivity around the assumptions.

What is the difference between IRR and ROI for real estate?

ROI is a simple total-return percentage with no time weighting: (cash returned − cash invested) ÷ cash invested. A deal that returns $15M on $7.5M in five years has the same ROI (100%) as one that returns it in two years — but very different IRRs (the two-year deal would IRR at ~41%; the five-year at ~14.9%). IRR is the time-weighted answer.

What is the difference between IRR and equity multiple?

Equity multiple (MOIC) is the total cash returned per dollar invested — a time-blind number. IRR is the annualized time-weighted return on that same cash flow stream. A 2.0x MOIC over three years and over seven years are very different deals; their IRRs differ accordingly. Quote both.

Is a higher IRR always better?

No. Higher IRR on the same total cash usually means earlier cash, which can reflect a healthy fast turn or unsustainable front-loaded distributions. IRR also rewards very short holds disproportionately — a 32% IRR on a six-month flip is not comparable to a 15% IRR on a five-year hold. Read the cash flow shape and the absolute scale (MOIC, total profit) before declaring a winner.

How does IRR work with a sale at exit?

The sale at exit is a cash flow in the final year: gross sale price minus selling costs minus loan payoff equals net proceeds to equity. Add that to the final-year operating distribution. The IRR is computed on the full stream — Year 0 equity check through final-year operating cash plus net sale. The exit dominates IRR on most CRE deals because it's the largest single cash flow.

What is MIRR vs IRR in real estate?

MIRR (modified IRR) explicitly assumes interim distributions reinvest at a chosen rate (typically the risk-free rate, ~4.5% in May 2026) rather than at the project IRR itself. In a high-rate environment, the IRR-MIRR spread can be 200–500 bps. The full treatment is in the sibling methodology pillar; in practice, quote both numbers on long-hold value-add or opportunistic deals.

Why is my IRR negative?

Three common causes. (1) Total cash returned is less than total cash invested. (2) Cash flow stream has no sign change (all positive or all negative — IRR is mathematically undefined). (3) The cash flows are correct but the deal is genuinely negative — common on 2021-vintage value-add deals with refi gaps that absorbed all the equity. If the calculator returns no value, check that the Year 0 equity check is negative and at least one subsequent year is positive.

What is the difference between =IRR() and =XIRR() in Excel?

=IRR() assumes cash flows occur at equal annual intervals. =XIRR() takes an explicit date for each cash flow and computes the annualized return using actual day-count between flows. Real CRE models run on monthly or quarterly cash flows with irregular events (refi closings, mid-quarter capex). Default to =XIRR() in any production model.

Ready to try Apers?

Start using Apers today — no credit card required.

Start for Free