Definition

Internal Rate of Return (IRR) is the annualized rate of return that makes the net present value (NPV) of all cash flows from a real estate investment equal to zero. It accounts for the timing of every dollar in and every dollar out, making it the most complete single-number measure of investment performance in CRE.

Unlike cap rate or cash-on-cash, IRR doesn't just look at one year. It captures the full arc of a deal: acquisition, holding period cash flows, and exit proceeds.

Tyler's Take

IRR is the number I use to compare every deal against every other deal. Cap rate tells me about the market. Cash-on-cash tells me about Year 1. But IRR tells me the whole story of a deal from acquisition through exit, and it's the only metric that accounts for the time value of money.

The thing nobody explains about IRR is that it punishes lazy capital. If you park $500k in a deal and it does nothing for three years, then doubles in Year 5, the IRR is lower than a deal that starts paying you Day 1 and exits at the same multiple. IRR rewards speed and efficiency, which is why it's the standard for private equity and institutional CRE.

My benchmarks for Nashville in 2026: I want to see 8-10% IRR on stabilized core deals (that better come with low risk and strong credit tenants), 14-20% on value-add, and 18%+ on opportunistic or development plays. Anything above 25% is usually aggressive underwriting or a very short hold. If someone pitches you a "30% IRR" on a five-year value-add deal, ask to see the assumptions, because something is probably off.

The other thing I tell CRE Accelerator members: never evaluate a deal on IRR alone. Always pair it with equity multiple. A 25% IRR on a 1.3x equity multiple means you made a quick buck on a small deal. A 15% IRR on a 2.0x equity multiple means you actually built serious wealth. Both numbers matter.

How to Calculate IRR

IRR solves for the discount rate (r) that makes the NPV of all cash flows equal zero:

NPV = CF₀ + CF₁/(1+r) + CF₂/(1+r)² + ... + CFₙ/(1+r)ⁿ = 0

You can't solve this algebraically. Excel's =IRR() function or a financial calculator uses trial and error to find the rate. Here's the process:

1. List every cash flow by year. Year 0 is your equity investment (negative). Years 1-N are net cash flow after debt service. The final year includes sale proceeds.

2. Plug them into Excel's =IRR() function. The formula solves for the annual rate that makes the NPV zero.

3. Compare to your hurdle rate. If IRR exceeds your minimum target, the deal clears the bar.

Worked Example

I buy a Nashville flex building for $1.5M total, putting $500,000 in equity and financing the rest. Over five years:

Year 0: -$500,000  (equity in)
Year 1:  $30,000   (cash flow after debt service)
Year 2:  $30,000
Year 3:  $30,000
Year 4:  $30,000
Year 5:  $830,000  ($30k cash flow + $800k net sale proceeds)

So I put in $500,000, collected $30,000 a year for five years ($150,000 total), then walked away with $800,000 at sale. My total profit is $450,000 on $500,000 in, but spread over five years the IRR comes out to about 14.9%. That's the number I'd compare against a stock index, a bond, or the next deal sitting on my desk.

IRR vs. Other Return Metrics

IRR vs. Cap Rate: Cap rate measures the property's unlevered return at a single point in time. IRR measures the investor's total levered return over the full hold. They answer different questions.

IRR vs. Cash-on-Cash: Cash-on-cash measures Year 1 cash flow against equity. IRR captures every year plus the exit. Cash-on-cash is a snapshot; IRR is the full movie.

IRR vs. Equity Multiple: Equity multiple tells you how much total money you made. IRR tells you how fast. A 2.0x in 3 years is a much higher IRR than a 2.0x in 10 years. Always use both.

Common Mistakes

1. Ignoring the timing of cash flows. IRR is extremely sensitive to when cash arrives. Front-loaded deals look much better on IRR than back-loaded ones, even at the same equity multiple.

2. Using IRR on short holds. A 6-month flip that nets 10% profit can show a 20%+ annualized IRR, which is mathematically correct but misleading. Always look at the equity multiple alongside it.

3. Trusting sponsor IRR projections blindly. Most sponsor pro formas show IRR under optimistic assumptions. Stress-test the exit cap rate and rent growth to see how IRR moves.

4. Confusing levered and unlevered IRR. Levered IRR (after debt) is always higher than unlevered IRR (no debt) in a performing deal, because leverage amplifies returns. Make sure you're comparing apples to apples.

Frequently Asked Questions

What's a good IRR for commercial real estate?
It depends on the risk profile. In Nashville in 2026, I target 8-10% for core/stabilized, 14-20% for value-add, and 18%+ for opportunistic. Below 8% and I'd rather buy a bond.

What's the difference between IRR and ROI?
ROI is a simple profit-on-investment percentage that ignores timing. IRR accounts for when each dollar flows in and out, which makes it a much more accurate measure for multi-year holds.

Can IRR be negative?
Yes. A negative IRR means the deal lost money. If you put in $500k and got back $400k over five years, the IRR is negative.

Does IRR account for leverage?
Only if you calculate levered IRR, which uses cash flows after debt service. Most sponsor presentations show levered IRR because it looks better. Always ask which version you're looking at.

How do I calculate IRR in Excel?
Use =IRR(range) where the range contains your cash flows by year, starting with the negative equity outlay in Year 0. Excel iterates to find the rate that makes NPV equal zero.

Run Your Own Numbers

Use the free Commercial Real Estate Calculators to model IRR alongside cash-on-cash, equity multiple, and cap rate on your next deal.

Related Terms

Want to learn how to underwrite deals like a real broker? Join the CRE Accelerator or read the CRE blog.