
What Is IRR in Commercial Real Estate? And Why It Can Mislead
IRR is the discount rate that makes a deal's net present value equal zero, weighted by when cash arrives, not just how much comes in. It is essential for comparing deals but dangerous read alone, since it ignores deal size and assumes reinvestment at the same rate.
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.
Related Articles
Cash-on-Cash Return in Commercial Real Estate: Formula and Limits
Cash-on-cash return measures the annual pre-tax cash flow a deal produces relative to the actual cash you put into it: divide annual cash flow after debt service by total cash invested. It is a fast read on current yield, not a full-cycle return measure.
Debt Yield in Commercial Real Estate: The Constraint That Cuts Deals
Debt yield is Net Operating Income divided by loan amount. Lenders trust it because, unlike DSCR and LTV, it ignores interest rate, amortization, and appraised value entirely. Most lenders want 8 to 10 percent minimum, and in a low-cap-rate market it is often the metric that caps your loan size, not LTV.
Equity Waterfalls and Fund Metrics (DPI, TVPI, RVPI) Explained
An equity waterfall sets the order LPs and the GP get paid: return of capital, then a preferred return (commonly around 8 percent), then a GP catch-up, then a promote split (commonly 80/20) above the hurdle. DPI, RVPI, and TVPI measure how much of that has actually been paid out versus still marked on paper.
