Key Takeaways
- IRR is the annualized return that makes the NPV of all cash flows equal to zero—it captures timing, cash flow, appreciation, and loan paydown.
- The 20-unit example projects a 22.4% IRR over 5 years, exceeding a typical 15% hurdle rate.
- IRR penalizes back-loaded returns and rewards strong early cash flow, unlike the Equity Multiple.
- No single metric tells the full story—use Cap Rate, Cash-on-Cash, DSCR, IRR, and Equity Multiple together.
While Cap Rate and Cash-on-Cash provide point-in-time snapshots, the Internal Rate of Return (IRR) captures the total return story—cash flow, appreciation, loan paydown, and the time value of money—across the entire holding period. IRR is the metric institutional investors and sophisticated syndicators rely on most heavily because it accounts for when cash flows are received, not just how much. This lesson explains IRR conceptually, walks through its calculation, and introduces the 20-unit example's projected IRR.
Understanding IRR Conceptually
The Internal Rate of Return is the annualized discount rate that makes the Net Present Value (NPV) of all cash flows—both inflows (annual cash flow, sale proceeds) and outflows (initial equity investment)—equal to zero. In simpler terms, IRR answers the question: "What annualized return did my equity earn, accounting for the timing of every cash inflow and outflow?" A 15% IRR means your equity effectively grew at 15% per year, compounded. IRR is superior to static metrics because it penalizes deals where returns are back-loaded (you wait years for a big exit) and rewards deals with strong early cash flow. However, IRR has limitations: it assumes interim cash flows can be reinvested at the same IRR rate (the reinvestment assumption), and it can produce misleading results for unconventional cash flow patterns.
Why it matters: Understanding this concept is essential for making informed investment decisions.
IRR Calculation: The 20-Unit Example
For our 20-unit building, project a 5-year hold. Year 0: equity investment of -$400,000. Annual BTCF grows with 2% annual rent increases and stable expenses: Year 1 = $44,220, Year 2 = $48,844, Year 3 = $53,561, Year 4 = $58,373, Year 5 = $63,284. At exit, assume a 7.25% exit cap rate on Year 6 projected NOI of $165,180, yielding a sale price of $2,278,345. After paying off the remaining loan balance of approximately $1,528,000 and 2% selling costs ($45,567), net sale proceeds = $704,778. The Year 5 total cash flow = $63,284 + $704,778 = $768,062. Using a financial calculator or spreadsheet IRR function on the cash flow series (-$400,000; $44,220; $48,844; $53,561; $58,373; $768,062), the IRR is approximately 22.4%. This exceeds most investors' minimum hurdle rate of 15%, confirming the deal's attractiveness.
Why it matters: IRR solves for r in: 0 = −Equity + CF₁/(1+r)¹ + CF₂/(1+r)² + ... + (CFₙ + Sale Proceeds)/(1+r)ⁿ 20-Unit Example Cash Flows: Year 0: −$400,000 (equity) Year 1: +$44,220 Year 2: +$48,844 Year 3: +$53,561 Year 4: +$58,373 Year 5: +$768,062 (BTCF + net sale proceeds) IRR ≈ 22.4%
IRR vs. Other Return Metrics
Cap Rate is an unlevered, single-year snapshot that ignores financing and future value changes. Cash-on-Cash is a levered, single-year metric that shows current equity yield but ignores appreciation and loan paydown. IRR is a levered, multi-year metric that captures all sources of return (cash flow, appreciation, loan paydown, tax benefits if modeled) weighted by timing. Equity Multiple (total distributions / total invested) captures total return magnitude but ignores timing—a 2.0x equity multiple over 3 years is far superior to 2.0x over 10 years. The best practice is to evaluate deals using all metrics together: Cap Rate for pricing context, Cash-on-Cash for current yield, DSCR for debt safety, IRR for total return, and Equity Multiple for absolute return.
| Metric | Type | Time Horizon | Includes Appreciation? | Includes Leverage? |
|---|---|---|---|---|
| Cap Rate | Yield | Single Year | No | No |
| Cash-on-Cash | Current Return | Single Year | No | Yes |
| DSCR | Safety | Single Year | No | Yes |
| IRR | Total Return | Multi-Year | Yes | Yes |
| Equity Multiple | Total Return | Multi-Year | Yes | Yes |
Comparison of key real estate return metrics
Why it matters: Understanding this concept is essential for making informed investment decisions.
Key Takeaways
- ✓IRR is the annualized return that makes the NPV of all cash flows equal to zero—it captures timing, cash flow, appreciation, and loan paydown.
- ✓The 20-unit example projects a 22.4% IRR over 5 years, exceeding a typical 15% hurdle rate.
- ✓IRR penalizes back-loaded returns and rewards strong early cash flow, unlike the Equity Multiple.
- ✓No single metric tells the full story—use Cap Rate, Cash-on-Cash, DSCR, IRR, and Equity Multiple together.
Sources
Common Mistakes to Avoid
Comparing IRR across deals with different holding periods without adjustment
Consequence: A 25% IRR over 2 years generates less total wealth than a 18% IRR over 7 years due to compounding
Correction: Use Equity Multiple alongside IRR to capture both rate of return and total wealth creation
Relying solely on IRR for back-loaded return profiles
Consequence: IRR can be manipulated by delaying equity contributions or concentrating returns at exit
Correction: Evaluate IRR in conjunction with Cash-on-Cash and Equity Multiple to ensure returns are not artificially inflated
Test Your Knowledge
1.What does IRR measure that Cap Rate and Cash-on-Cash do not?
2.In the 20-unit example, what is the approximate IRR over a 5-year hold?
3.What is a limitation of IRR as a return metric?