What Is IRR? Internal Rate of Return (IRR) Explained

Quick Answer

IRR (Internal Rate of Return) is the discount rate that makes an investment’s net present value (NPV) equal to zero. In plain English: it’s the annualized rate that summarizes how your money grows given when you invest cash and when you get cash back. IRR is useful for comparing projects with different cash flow timing, but it can be misleading when projects differ in size, timeline, or have unusual cash flow patterns.

What IRR Means (Plain English Definition)

IRR is the single annual percentage rate that makes the “present value” of all cash flows equal to the initial investment. It treats the investment like a deal where money goes out and money comes back in over time—and asks:

“What constant annual rate would make these cash flows break even in present-value terms?”

The reason it’s called “internal” is that it’s based only on the cash flows of the project itself (the “inside” of the deal), not on external market comparisons. IRR doesn’t know your alternative options; it only summarizes what this specific cash flow stream implies.

What IRR is not

• Not ROI: ROI ignores time; IRR is time-sensitive.
• Not guaranteed: IRR is computed from assumed or historical cash flows. Future IRR is a projection, not a promise.
• Not always comparable: A higher IRR is not automatically “better” if the deal is smaller or shorter.

Intuition: Why Timing Matters (The Core Reason IRR Exists)

Consider two investments that both make you $10,000 in profit. One returns the profit in one year, the other returns the profit in ten years. Most people agree the one-year version is better. Why?

• You get your money back sooner (you can reinvest it).
• You take risk for less time.
• Inflation and uncertainty have less time to harm you.

ROI alone can’t distinguish these cases well because it doesn’t “care” about time. IRR does. IRR is essentially a time-weighted way to express: how fast did this investment compound, given the timing of cash flows?

IRR and NPV: The Relationship (Why IRR Is a “Discount Rate”)

You don’t need to love formulas to use IRR, but this one idea makes everything click:

NPV takes each cash flow and discounts it back to today using a discount rate (your required return / hurdle rate). If NPV is positive at your hurdle rate, the investment clears your requirement.

IRR flips the question: instead of choosing a discount rate and calculating NPV, it finds the discount rate where the NPV would be exactly zero. That “break-even discount rate” is the IRR.

Why that matters

• If IRR is above your hurdle rate, NPV is typically positive (good sign).
• If IRR is below your hurdle rate, NPV is typically negative (bad sign).
• But comparisons get tricky when deal sizes differ or cash flows are unusual.

Simple IRR Example (One Buy, One Sell)

Suppose you invest $100,000 today and receive $110,000 exactly one year later. Intuitively, that’s a 10% one-year return.

• Initial cash flow: -$100,000 (money out)
• Year 1 cash flow: +$110,000 (money in)

The IRR here is 10% because discounting the $110,000 back one year at 10% gives $100,000. This is the simplest case and it matches intuition.

Why this example is too clean

Real investments rarely have just one inflow. Real estate can include monthly cash flow, repairs, refinance proceeds, and a final sale. That’s where IRR becomes more useful—and also more fragile.

IRR Example With Multiple Cash Flows

Here’s a more realistic “many cash flows” pattern:

• Today: invest -$100,000
• End of Year 1: receive +$5,000
• End of Year 2: receive +$5,000
• End of Year 3: receive +$5,000
• End of Year 4: receive +$5,000
• End of Year 5: receive +$115,000 (final distribution / sale)

Total cash received is $135,000, which looks like a 35% “total” gain. But IRR will be lower than 35% because the gains arrive over time. IRR converts this pattern into an annual rate that “explains” all those flows.

What changes IRR the most in multi-cash-flow deals

• Earlier cash flow increases IRR (even if the total is the same).
• A higher final sale increases IRR.
• Delays reduce IRR (because money is tied up longer).

IRR in Real Estate: What You Must Include

Real estate investors use IRR constantly because real estate cash flows are rarely neat and periodic. A correct real estate IRR typically includes:

• Down payment (negative cash flow at purchase)
• Closing costs (negative cash flow)
• Renovation / CapEx outlays (negative cash flows when paid)
• Operating cash flow / distributions (positive or negative over time)
• Refinance proceeds (positive cash flow when cash is pulled out)
• Sale proceeds net of selling costs and loan payoff (final positive cash flow)

Levered IRR vs unlevered IRR

In real estate you’ll often see two IRRs:

• Unlevered IRR: cash flows assuming no debt (or before debt). This reflects the property economics.
• Levered IRR: cash flows to equity after debt. This reflects the investor’s return with financing.

Leverage can increase IRR, but it also increases risk. Comparing levered IRRs across deals with different leverage is risky unless you adjust for risk and understand the debt terms.

How to Calculate IRR (Excel / Google Sheets)

Most people calculate IRR using spreadsheets. The key is choosing the right function:

IRR(values) for periodic cash flows

Use IRR() when cash flows happen at equal intervals (e.g., every year, every month). The function assumes spacing is consistent.

XIRR(values, dates) for irregular cash flows

Use XIRR() when cash flows happen on irregular dates (very common in real estate). You provide a list of cash flows and a matching list of dates.

Common setup mistakes (that break IRR)

• Missing the initial negative cash flow: IRR needs at least one negative and one positive cash flow.
• Wrong signs: money you invest is negative; money you receive is positive.
• Using IRR instead of XIRR: irregular timing can materially change the result.
• Forgetting fees/selling costs: leaving out friction inflates IRR.

How to Interpret IRR (What a “High IRR” Actually Means)

IRR is an annualized rate. That sounds like a “yield,” but it’s not the same as a stable yearly yield. It’s the one rate that fits the entire cash flow timeline.

Interpretation rule #1: IRR is not a promise

Forward-looking IRR is a projection based on assumptions (rent growth, occupancy, expenses, sale cap rate, appreciation). Small assumption changes can shift IRR meaningfully—especially when the exit sale is a large portion of total returns.

Interpretation rule #2: compare IRR to a hurdle rate, not to other random IRRs

A “good IRR” depends on risk and alternatives. Your hurdle rate is your required return for that risk. If your hurdle rate is 10%, an 8% IRR may be unattractive even if it’s “positive.”

Interpretation rule #3: watch the timeline

A short deal can have a very high IRR because money turns fast. That doesn’t automatically mean it creates more wealth in dollars. Always look at:

• Total dollars returned
• Equity multiple (how many times your money you got back)
• NPV at your hurdle rate

IRR vs ROI vs CAGR vs NPV (When Each Metric Wins)

IRR vs ROI

ROI is total return: profit ÷ invested amount. It ignores time. IRR is time-aware and annualized. If timing varies, IRR is more informative. If you only care about total profit regardless of time, ROI can be fine.

IRR vs CAGR

CAGR (compound annual growth rate) works best when you invest once and get one final value. IRR handles multiple inflows/outflows (which is why it’s used for funds and real estate). If your cash flows are “one in, one out,” CAGR and IRR can be similar.

IRR vs NPV

NPV measures value in dollars at a chosen discount rate (your hurdle rate). IRR gives you a percent rate. When comparing projects of different sizes, NPV can be the more correct decision tool because it asks: “Which option creates more value in dollars at our required return?”

Common IRR Pitfalls (And How to Avoid Them)

1) Multiple IRRs (when cash flows change sign more than once)

If cash flows go negative → positive → negative → positive, the IRR equation can have multiple solutions. That means IRR can become ambiguous or misleading.
Fix: use NPV, or consider MIRR (modified IRR), or restructure the analysis to isolate phases.

2) Reinvestment assumption

IRR implicitly assumes interim cash flows are reinvested at the IRR itself. For very high IRRs, this can be unrealistic.
Fix: use MIRR (which uses a realistic reinvestment rate) or check NPV/equity multiple.

3) Comparing different-sized projects using only IRR

A tiny deal can have a huge IRR but create fewer dollars than a larger deal with a lower IRR.
Fix: compare NPV and total profit alongside IRR.

4) Comparing different timelines using only IRR

Short deals often show higher IRR. That doesn’t mean they are better for building wealth if capital can’t be redeployed reliably.
Fix: consider your realistic ability to “repeat” the short deal and keep capital deployed.

5) Ignoring fees, taxes, and friction

Leaving out transaction costs or fees inflates IRR. In real estate, ignoring selling costs and CapEx is especially common.
Fix: model net-of-fee cash flows and use conservative exit assumptions.

6) Using IRR without scenario ranges

A single IRR number can be fragile. One rent assumption or exit price change can swing it.
Fix: run conservative / base / optimistic scenarios and check sensitivity.

Quick Checklist: Use IRR the Right Way

• ✅ Include at least one negative and one positive cash flow (correct signs)
• ✅ Use XIRR if cash flow dates are irregular (common in real estate)
• ✅ Include all friction: closing costs, fees, major CapEx, selling costs, taxes if you model them
• ✅ Compare IRR to a hurdle rate that matches risk (not to a random benchmark)
• ✅ Pair IRR with at least one backup metric (NPV or equity multiple)
• ✅ Run conservative and optimistic scenarios (don’t trust one perfect case)
• ✅ Watch for multiple IRRs if cash flows change sign more than once

Related links

Frequently Asked Questions

Bottom Line

IRR is a powerful metric because it compresses complex cash flow timing into one annualized rate. But it’s easy to misuse. To use IRR correctly: calculate it with the right timing method (often XIRR), include all real-world costs, compare it to a risk-appropriate hurdle rate, and pair it with NPV or equity multiple. If a deal’s IRR looks great but collapses with small assumption changes, treat that as a warning—not a win.

Methodology and assumptions

Educational only. IRR depends entirely on cash flow assumptions and timing. Real-world results vary with risk, leverage, fees, taxes, and market conditions. For irregular real estate cash flows, XIRR is typically more appropriate than IRR.