What Is IRR — And How Do You Use It to Evaluate a Property’s Potential?
BlueStar Consulting | Educational Series | bsreconsulting.com
When evaluating a commercial real estate investment, one metric comes up in almost every conversation: IRR — Internal Rate of Return.
It shows up in LP decks, development proformas, and broker packages. But what does IRR actually tell you? How is it calculated? And when should it drive your decision — and when should you look past it?
Let’s break it down in practical terms.
What Is IRR?
Internal Rate of Return (IRR) is the annualized rate of return an investor expects to earn over the full life of an investment. It accounts for:
- The initial capital invested
- Ongoing cash flow from the property
- Sale proceeds at exit
- The time value of money
Unlike simpler return metrics, IRR recognizes that a dollar received today is worth more than a dollar received five years from now.
IRR answers one core question: “What annualized return will I earn on my invested capital over the hold period — accounting for both income and sale?”
That single question is why IRR has become the standard performance benchmark across private equity, development, and institutional real estate.
Why IRR Matters in Real Estate
Real estate investments rarely produce returns in a single lump sum. A typical hold generates:
- Annual operating income (NOI)
- Gradual rent growth over the hold period
- Property value appreciation
- A capital event at exit — sale or refinance
IRR captures all of that — and critically, it captures when those returns arrive.
Here’s why timing matters:
- $1M returned in 2 years is fundamentally different from $1M returned in 10 years
- IRR reflects that difference directly
- Simple ROI does not
That’s why IRR is the primary return metric used by private equity funds, development sponsors, syndicators, and institutional capital allocators. It’s the one number that lets you compare two very different deals on a level playing field.
The Concept Behind the Calculation
Technically, IRR is the discount rate that makes the Net Present Value (NPV) of all cash flows equal to zero.
The formula solves for:
NPV = 0 → Present value of future cash flows – Initial investment = 0
Because this equation can’t be solved manually in any practical way, IRR is calculated using:
- =IRR()Excel — the
- Financial modeling software (Argus, CoStar, custom models)
- Investment calculators
At BlueStar, we build our IRR calculations inside comprehensive proformas — with linked cash flow assumptions, sensitivity modules, and exit cap scenario testing. No static inputs.
A Simple IRR Example
Here’s a straightforward scenario to make the math concrete:
Deal Assumptions
- Purchase price: $2,000,000
- Equity invested: $500,000
- Hold period: 5 years
- Net sale proceeds at Year 5: $300,000
The projected cash flows entered into Excel look like this:
| Year | Cash Flow | Notes |
| 0 | -$500,000 | Equity invested (negative) |
| 1 | $40,000 | Net operating income |
| 2 | $45,000 | NOI with rent growth |
| 3 | $50,000 | Continued rent growth |
| 4 | $55,000 | Stabilized performance |
| 5 | $360,000 | $60K NOI + $300K net sale proceeds |
| IRR | ~16–18% | =IRR(A1:A6) in Excel |
The Excel formula is simply: =IRR(A1:A6)
The result — roughly 16–18% IRR — means this investment is projected to generate an annualized return of 16–18% over the five-year hold. Every dollar of equity invested compounds at that rate, year after year.
How Investors Use IRR in Practice
1. Comparing Deals Side by Side
When two deals require the same equity investment, IRR creates a direct comparison:
- Deal A IRR: 12%
- Deal B IRR: 18%
All else equal, Deal B returns capital faster and more efficiently. That’s the power of IRR as a ranking tool.
2. Evaluating Risk vs. Return
IRR doesn’t exist in a vacuum — higher IRR almost always comes with higher risk. Here’s how to read the signals:
3. Rewarding Time Efficiency
IRR naturally rewards deals that return capital faster. A project that exits in 3 years at a strong profit will frequently show a higher IRR than a 10-year hold with similar total returns — even if the equity multiple is smaller.
This is why development deals often target 20%+ IRR — the capital is at risk for a concentrated period, and the return needs to justify that exposure.
IRR vs. Other Real Estate Metrics
IRR should never be used in isolation. Here’s how it fits alongside the other core metrics:
| Metric | What It Measures | Key Limitation |
| IRR | Annualized return over full hold period — income + exit + time | Dependent on exit assumptions |
| Cash-on-Cash | Annual cash income ÷ equity invested | Ignores exit value entirely |
| Equity Multiple | Total cash received ÷ total equity invested | Ignores timing — 2x in 3 yrs ≠ 2x in 10 yrs |
| Cap Rate | NOI ÷ purchase price — a snapshot yield | Ignores financing, appreciation, and time |
The bottom line: IRR combines income, exit value, capital structure, and time into a single number. The other metrics each measure one dimension. IRR integrates all of them.
That’s why sophisticated investors use all four — and why BlueStar’s underwriting reports always present them together.
The Limitations of IRR (What It Doesn’t Tell You)
IRR is powerful. It’s also assumption-driven. Here’s where it can mislead:
1. Garbage In, Garbage Out
IRR is only as reliable as the assumptions underneath it. Small changes in the exit cap rate or rent growth projections can move IRR by 5–10 percentage points. Always stress-test the inputs.
2. The Reinvestment Assumption
IRR mathematically assumes that interim cash flows can be reinvested at the same rate as the IRR itself — which is rarely realistic. For deals with high interim distributions, this can overstate actual performance. The Modified IRR (MIRR) addresses this by using a more conservative reinvestment rate.
3. IRR Can Be Engineered
A shorter hold period, or an optimistic exit price, can inflate IRR artificially. Sponsors sometimes use this to make deals look better than they are. That’s why at BlueStar, we pair every IRR figure with:
- Sensitivity analysis across exit cap scenarios
- Downside and base case stress tests
- Equity multiple cross-checks to confirm total return
What Is a “Good” IRR? Benchmarks by Strategy
Target IRR varies significantly by investment strategy and risk profile:
| Strategy | Risk Profile | Typical Hold | Target IRR |
| Core | Low | 7–10 yrs | 8%–12% |
| Core-Plus | Low–Medium | 5–7 yrs | 12%–15% |
| Value-Add | Medium | 3–5 yrs | 15%–20% |
| Opportunistic | High | 2–5 yrs | 20%+ |
| Ground-Up Dev | Very High | 3–7 yrs | 20%–30%+ |
These targets shift with market conditions, interest rates, and capital availability. In higher-rate environments, return thresholds typically rise — since the cost of capital is higher and alternatives like Treasuries are more competitive.
In the current cycle, value-add multifamily deals in core Sun Belt markets (South Florida, Texas, Colorado) are generally underwritten to 15–20% IRR on a levered basis — with significant sensitivity to exit timing and cap rate compression assumptions.
How BlueStar Uses IRR in Underwriting
At BlueStar Consulting, IRR is not just a single output in a proforma — it’s the anchor of our financial modeling process.
For every deal we underwrite, we build:
- A full 10-year cash flow model with dynamic rent growth and expense assumptions
- Multiple exit scenarios — base, bull, and bear case — each with different cap rate and timing assumptions
- A sensitivity matrix showing how IRR shifts across the most critical variables
- IRR presented alongside equity multiple, cash-on-cash, and NPV — so no metric tells only half the story
This is the difference between a static proforma and a true decision-support tool.
IRR tells you the rate. Sensitivity analysis tells you how confident you should be in that rate. You need both.
Final Thoughts
IRR is one of the most important tools in commercial real estate analysis because it captures the full performance picture: income, appreciation, timing, and capital efficiency — all in a single annualized number.
But it’s only half the work. The other half is stress-testing the assumptions behind it.
A smart investor — or a smart advisory team — always asks:
- What exit cap rate is this IRR based on?
- What happens to IRR if the hold extends by 12–18 months?
- What’s the downside scenario if rent growth is flat?
Answer those questions, and IRR becomes a strategic decision tool — not just a number in a spreadsheet.
Want IRR analysis done right?
BlueStar Consulting builds institutional-grade underwriting models for real estate investors, developers, and advisory firms. If you’re evaluating a multifamily acquisition, development deal, or portfolio position — we’ll build the model and stress-test every assumption.
Reach out at team@bsreconsulting.com | bsreconsulting.com