Internal Rate of Return (IRR) is the discount rate at which the net present value (NPV) of all future cash flows from an investment equals zero — effectively the annualized compound return on invested capital. IRR is the primary total-return metric used by private equity, CRE investors, and corporate finance professionals for investment underwriting. See federal reserve economic data at fred.stlouisfed.org and sec.gov filings for IRR benchmarks in PE and CRE.
IRR solves for the discount rate r such that: NPV = Σ [Cash Flow_t / (1 + r)^t] = 0, where t = 0, 1, 2, …, n. Because this equation has no closed-form solution, IRR is calculated iteratively (Newton-Raphson method) or via financial calculators and spreadsheet IRR() functions. Why IRR beats simpler metrics: CoC return and ROI ignore the time value of money and terminal value. A dollar returned in year 1 is worth more than a dollar returned in year 10. IRR incorporates the precise timing of all cash flows — initial investment, intermediate distributions, and terminal sale proceeds — into a single annualized figure. This makes IRR the standard metric for comparing investments with different holding periods and cash flow profiles. Limitations of IRR: 1. *Reinvestment rate assumption:* The IRR calculation implicitly assumes that interim cash flows are reinvested at the IRR itself — which may be unrealistic for very high IRR projects. Modified IRR (MIRR) corrects this by specifying a reinvestment rate. 2. *Multiple IRR problem:* When a project has non-conventional cash flows (alternating positive and negative), there can be multiple mathematically valid IRRs. NPV analysis is more reliable in these cases. 3. *Scale blindness:* A $10,000 investment with a 50% IRR ($5,000 return) is less valuable in absolute terms than a $1,000,000 investment with a 20% IRR ($200,000 return). IRR must always be read alongside deal size and NPV. 4. *Leverage effects:* Equity IRR (return to equity holders) is magnified by leverage — the same deal with 75% LTV financing will show a much higher equity IRR than an all-equity purchase, while the underlying asset return (unleveraged IRR) stays constant. Private equity and CRE IRR benchmarks: Private equity funds typically target gross IRR of 20-25%+ on individual investments, with net-of-fee IRR of 15-20% delivered to LPs. CRE value-add strategies commonly target unlevered IRR of 8-12% and levered equity IRR of 12-18%. Core CRE trades at 5-8% unlevered IRR. See sec.gov Form ADV filings from major PE firms for reported fund IRRs.
Benchmarks vary by asset class and risk: venture capital targets 25-35%+ gross IRR; private equity buyouts target 20-25%; CRE value-add targets 12-18% levered IRR; CRE core targets 5-8% unlevered IRR; public equity long-run average is ~10%. The relevant benchmark is your hurdle rate — the minimum return required given the investment's risk profile and the cost of your capital. For business acquisitions and real estate deals requiring bridge or acquisition financing, apply.
ROI = (Gain - Cost) / Cost — a simple ratio that ignores time. ROI on a 5-year investment does not tell you the annual rate of return. IRR is an annualized, compound, time-weighted return that accounts for the exact timing of every cash flow. A 50% ROI over 10 years is a 4.1% IRR; over 2 years it is 22.5% IRR. Always use IRR for comparing investments with different holding periods.
IRR solves iteratively for the discount rate that sets NPV = 0. In Excel or Google Sheets: =IRR(range of cash flows) where the first value is the negative initial investment and subsequent values are periodic cash flows. Financial calculators use the same Newton-Raphson iterative method. For project finance or CRE models with quarterly cash flows, use XIRR() which handles irregular date spacing. See sec.gov for PE fund performance reporting guidance.