Internal Rate of Return (IRR): Definition, Underwriting & Formula
Internal Rate of Return (IRR) is the annualized rate of return earned on each dollar invested in a commercial real estate property over an entire multi-year holding period, accounting for the time value of money.
Model Full Multi-Year Underwriting in Deal Analyzer
Combine Cap Rate, DSCR, Cash-on-Cash, and full deal stress testing in our comprehensive underwriting suite.
What is IRR (Internal Rate of Return)?
Internal Rate of Return (IRR) is the gold-standard metric used by private equity syndicators, real estate funds, and institutional investors to evaluate investment performance across an entire holding cycle (typically 3 to 10 years). Unlike static single-year metrics like Cap Rate or Cash-on-Cash Return, IRR accounts for the timing and magnitude of all cash inflows and outflows—including initial acquisition equity, ongoing annual operating distributions, capital calls, and the final net profit from property refinancing or ultimate disposition.
Why This Metric Matters in CRE Underwriting
IRR incorporates the time value of money: a dollar returned in Year 1 contributes far more to IRR than a dollar returned in Year 7. Private equity waterfall fee structures and sponsor promote hurdles are universally pegged to IRR tiers.
IRR Formula & Equation
0 = NPV = Σ [ CFt / (1 + IRR)^t ] (Discount rate where Net Present Value of all cash flows equals zero)Worked Commercial Example
An investor commits $500,000 in equity to acquire a commercial asset. Over a 5-year hold, the property distributes $35,000 in Year 1, $40,000 in Year 2, $45,000 in Year 3, $50,000 in Year 4, and $55,000 in Year 5. In Year 5, the property is sold for net proceeds of $750,000 (total Year 5 cash flow = $805,000).
Analysis: The investor earned a compounded annualized yield of 17.4% on their capital throughout the 5-year holding period.
IRR Industry Rules of Thumb & Benchmarks
- Core Institutional Assets: 7.0% - 9.5% target IRR.
- Value-Add Renovation Strategies: 12.0% - 16.0% target IRR.
- Opportunistic & Ground-Up Development: 17.0% - 22.0%+ target IRR.
Frequently Asked Questions (FAQs)
What is the main limitation of IRR in real estate?
IRR mathematically assumes that interim cash flow distributions are immediately reinvested at the same high internal rate of return, which may be unrealistic in ordinary financial markets.
Why do investors compare IRR with Equity Multiple?
IRR measures speed and efficiency of return, while Equity Multiple measures the total absolute dollar wealth generated. Investors evaluate both together to prevent distortion from short-term holds.
How does disposition cap rate affect terminal IRR?
Exit (terminal) cap rate assumptions have a tremendous impact on IRR. An expansion of just 50 basis points on exit cap rate can reduce a 5-year project IRR by 200 to 400 basis points.