IRR Meaning: Internal Rate of Return for Real Estate Investors
Internal Rate of Return (IRR) is the gold standard metric for evaluating real estate investments over time. While cap rate tells you about one year's performance and cash-on-cash return focuses on your cash investment, IRR captures the full picture — cash flow, appreciation, loan paydown, and the time value of money — in a single percentage.
This guide explains what IRR means, how to calculate it, what constitutes a good IRR for different strategies, and when to use it versus simpler metrics.
What Is IRR?
IRR is the annualized rate of return that makes the net present value (NPV) of all cash flows from an investment equal to zero. In simpler terms, it's the discount rate at which the total of all money you put in equals the total of all money you get out, adjusted for the timing of each cash flow.
Think of IRR as the answer to this question: "What annual return did this investment actually produce, accounting for when I invested money and when I received money back?"
Why IRR Matters in Real Estate
Real estate investments have irregular cash flows. You might put down $50,000 on Day 1, receive $500/month in cash flow for 5 years, spend $20,000 on a new roof in Year 3, and sell the property for $350,000 in Year 5. IRR handles all of this complexity and gives you a single number to compare against other investment options.
IRR accounts for:
- Time value of money — a dollar today is worth more than a dollar in five years
- Cash flow timing — when you receive income matters, not just how much
- Capital appreciation — the sale price relative to your purchase price
- Leverage effects — how debt amplifies (or diminishes) your returns
- Holding period — short holds vs. long holds are compared on equal footing
How to Calculate IRR
The IRR formula doesn't have a simple algebraic solution. It's solved iteratively (trial and error), which is why everyone uses spreadsheets or calculators. Here's the conceptual formula:
0 = CF₀ + CF₁/(1+IRR)¹ + CF₂/(1+IRR)² + ... + CFₙ/(1+IRR)ⁿ
Where CF₀ is your initial investment (negative number), CF₁ through CFₙ are your cash flows in each period, and the final period includes both cash flow and the sale proceeds.
Example: Fix and Flip
- Month 0: Purchase + rehab = -$150,000 (cash invested)
- Month 6: Sell for $220,000 after all costs = +$220,000
- Net profit: $70,000
- IRR: ~93% annualized (because you doubled your money in 6 months)
Example: Buy and Hold Rental
- Year 0: Down payment + closing = -$60,000
- Years 1-5: Net cash flow = $6,000/year
- Year 5: Sell for $350,000 less remaining mortgage of $220,000 = $130,000 equity
- IRR: ~22% annualized
How to Calculate in a Spreadsheet
In Excel or Google Sheets, use the =IRR() function. List your cash flows in a column (negative for money out, positive for money in), then use =IRR(A1:A6) where the range covers all your cash flows. For irregular timing, use =XIRR() with dates.
What's a Good IRR?
Target IRR varies by strategy and risk level:
| Strategy | Typical IRR | Minimum Target |
|---|---|---|
| Core (stabilized, low-risk rentals) | 6-10% | 7% |
| Core-Plus (minor value-add) | 8-12% | 10% |
| Value-Add (rehab + lease-up) | 12-18% | 14% |
| Opportunistic (ground-up, distressed) | 18-25%+ | 18% |
| Fix and Flip | 20-50%+ | 20% |
| Syndication (LP investor) | 12-20% | 13% |
As a general rule, your target IRR should exceed what you could earn in passive investments (stock market average of ~10%) by enough to compensate for the additional risk, illiquidity, and effort of real estate.
IRR vs. Other Metrics
IRR vs. Cap Rate
Cap rate measures a property's income return at a single point in time, ignoring financing, appreciation, and the holding period. IRR captures the entire investment lifecycle. Use cap rate for quick property comparisons; use IRR for investment decisions.
IRR vs. Cash-on-Cash Return
Cash-on-cash return measures annual cash flow relative to your cash invested. It's useful for Year 1 analysis but ignores appreciation, loan paydown, and future cash flows. IRR captures all of these over the entire hold.
IRR vs. Equity Multiple
Equity multiple tells you how many times you got your money back (e.g., 2.0x means you doubled your investment). It ignores timing — a 2.0x over 3 years is much better than a 2.0x over 10 years. IRR captures the timing difference.
Limitations of IRR
- Assumes reinvestment at the same rate — IRR assumes you reinvest interim cash flows at the IRR rate, which may not be realistic. Modified IRR (MIRR) addresses this.
- Favors shorter holds — a quick flip with modest profit can show a higher IRR than a long-term hold with much more total profit. Don't use IRR as your only metric.
- Sensitive to assumptions — small changes in projected rent growth, appreciation, or exit timing can dramatically change the IRR. Always run sensitivity analysis.
- Garbage in, garbage out — IRR is only as good as your cash flow projections. Overly optimistic rent assumptions or understated expenses will inflate your IRR.
Practical Tips for Using IRR
- Always pair IRR with equity multiple — together they tell you the rate of return AND the total return
- Run multiple scenarios — best case, base case, and worst case. If your worst-case IRR is still acceptable, the deal is solid.
- Use XIRR for real dates — the basic IRR function assumes equal periods. XIRR lets you input actual dates for precise calculations.
- Compare apples to apples — make sure you're using the same assumptions (hold period, exit cap, rent growth) when comparing IRR across different properties
- Don't chase IRR at the expense of total return — a 40% IRR on a $20,000 investment produces $8,000 in profit. A 15% IRR on a $200,000 investment produces far more total wealth.
Related Articles
- Cap Rate Explained: Formula, Good Rates & How to Calculate
- What Is NOI? Net Operating Income Explained
- Passive Income Real Estate: 10 Strategies for 2026
- BRRRR Method Explained