What Is IRR in Commercial Real Estate? And Why It Can Mislead

The Short Answer

IRR, or internal rate of return, is the discount rate at which the net present value of all a deal's cash flows equals zero. In plain terms, it is the annualized return that accounts for exactly when money goes out and when it comes back. Two deals can return the same total dollars and have very different IRRs, because IRR is time-weighted: a dollar returned in year 2 is worth more to your IRR than the same dollar returned in year 5.

That time-sensitivity is also what makes IRR easy to misuse. A high IRR does not automatically mean a better deal. It needs context from other metrics, which we cover below. You can run your own numbers with our free IRR calculator.

How IRR Is Calculated

There is no simple formula you plug numbers into and get an answer, the way you can with a cap rate. IRR is solved iteratively: the calculation tests different discount rates until it finds the one where the present value of all inflows minus outflows equals zero. In practice, this means using a tool built for it, like Excel's XIRR function or a dedicated calculator, rather than working it out by hand.

• Every cash flow matters: the initial investment, every distribution along the way, and the final sale proceeds all get discounted back to today's dollars.
• Timing matters as much as amount: the same total return generates a lower IRR if it arrives later.
• It is solved, not computed directly: the software tries rates iteratively until NPV lands at zero.

A Worked Example

Here is an illustrative example to show the mechanics. Assume you invest $1,000,000 at year 0. You receive $60,000 per year in years 1 through 4. In year 5, you receive $60,000 plus a sale of $1,400,000, for a total year-5 cash flow of $1,460,000.

• Year 0: -$1,000,000
• Years 1-4: $60,000 each
• Year 5: $1,460,000 (operating cash flow plus sale proceeds)

The IRR that sets the net present value of this stream to zero is roughly 12 to 13 percent, solved iteratively rather than by a direct formula. That number is approximate and illustrative, meant to show how the pieces fit together, not a benchmark to underwrite against. Run your own cash flow schedule through our IRR calculator to see the exact rate for a specific deal.

Where IRR Misleads

IRR has real blind spots, and each one has caused real underwriting mistakes.

• It ignores deal size. A $50,000 investment that returns $100,000 in one year has a much higher IRR than a $10,000,000 investment that returns $20,000,000 in one year, even though the dollar profit is wildly different. Always pair IRR with the equity multiple (MOIC) so you know how much capital actually came back, not just how fast.
• It assumes reinvestment at the same rate. The math implicitly assumes every interim distribution gets reinvested at that same IRR. In reality, you might sit on that cash or reinvest it at a lower return. This is rarely true and inflates the apparent attractiveness of deals with frequent early distributions.
• It is highly sensitive to hold period and exit assumptions. Shift the exit cap rate or push the hold period out a year, and the IRR can swing significantly, even if the underlying property performance barely changed.
• It can be inflated by early distributions. A sponsor can boost IRR by returning capital early, even if that capital is simply return of principal rather than profit. A high IRR on a tiny equity multiple can be a worse outcome than a lower IRR on a larger multiple, because the second deal actually made you more money.

How to Use IRR in Underwriting

Never read IRR by itself. Read it alongside the equity multiple and cash-on-cash return, so you can see both the rate of return and the actual multiple of capital returned. For a full breakdown of cash-on-cash, see our post on cash-on-cash return.

Then stress test the assumptions that swing IRR the most: the exit cap rate and the hold period. Model a range of exit caps, not just the sponsor's base case, and check what happens to IRR if the hold stretches longer than planned. If a deal's IRR only looks good under one narrow set of exit assumptions, that is a signal worth flagging, not ignoring. For the metric IRR is most often confused with, see our explainer on cap rate.

This is also where underwriting speed matters. Our AI underwriting copilot runs IRR, equity multiple, and cash-on-cash side by side across multiple exit and hold scenarios automatically, so you see the full picture instead of a single flattering number.

Want to test your own deal? Plug your cash flow schedule into our free IRR calculator and see the rate, alongside the multiple, in one pass.