📈IRR Calculator
Calculate the Internal Rate of Return (IRR) for any investment with fixed or irregular cash flows. Enter an initial investment and periodic returns to find the annualized IRR, NPV, and payback period.
Prefer to skip the form? Scroll down and Ask AI Instead. Just describe your situation and let AI handle the math for you in seconds.
Internal Rate of Return (IRR)
9.6059
Cumulative Cash Flow Over Time
✦ Ask AI Instead
IRR Calculator: How to Calculate Internal Rate of Return
The Internal Rate of Return (IRR) is the discount rate that makes the Net Present Value of all cash flows equal to zero. It is the annualized rate of growth an investment is expected to generate, accounting for the timing and size of each cash flow. A higher IRR is better; an investment is worthwhile if its IRR exceeds your required rate of return (hurdle rate).
Formula: NPV = −I₀ + CF₁/(1+r)¹ + CF₂/(1+r)² + ... + CFₙ/(1+r)ⁿ = 0 → solve for r
| Investment | Annual CF | Years | IRR |
|---|---|---|---|
| $50,000 | $8,000 | 10 | 9.6% |
| $100,000 | $15,000 | 15 | 13.9% |
| $25,000 | $5,000 | 8 | 15.7% |
The IRR calculator finds the annualized rate of return that equates the present value of future cash flows to your initial investment. It is the single most widely used metric in capital budgeting and private equity, appearing in every investment memo, project approval, and fund performance report. Unlike simple ROI — which ignores time — IRR accounts for when money is received, making it the correct measure for comparing investments with different lifespans or irregular cash flow patterns.
IRR vs NPV: Which Metric Matters More?
IRR and NPV are related but answer different questions. NPV asks: "Given my required rate of return, how much value does this investment create in today's dollars?" IRR asks: "What rate of return does this investment actually deliver?" Both metrics solve for the same equation; they just hold different variables fixed.
For most decisions, NPV is theoretically superior: it tells you the absolute dollar value created, and you can always compare it directly to your cost of capital. The decision rule is simple — accept any investment with a positive NPV at your hurdle rate. However, IRR is easier to communicate ("this project returns 18% per year") and allows quick comparison across projects of different sizes without knowing the exact cost of capital.
The practical rule: use IRR to screen and rank; use NPV to make the final call when capital is constrained or when comparing mutually exclusive projects. Both metrics are calculated here — use the NPV output with your target discount rate to verify that a high IRR corresponds to genuine value creation.
Fixed vs Irregular Cash Flows
The fixed cash flow mode handles investments that produce the same income each period — rental properties with stable rent, bonds, annuities, or equipment with predictable output. You can choose annual, semi-annual, quarterly, or monthly frequencies, and add a terminal (salvage) value at the end of the holding period.
The irregular cash flow mode handles real-world investments where returns vary by year — development projects where cash comes in only at sale, startups that take years to turn profitable, private equity funds with a J-curve (negative early years, large exits late), or real estate with renovation costs in year one and growing rents thereafter. Enter each year's net cash flow directly. A negative value in a future year means an additional capital call or cost; a large positive value in a later year typically represents a sale or refinancing event.
How to Interpret IRR Results
IRR has no meaning in isolation — it must be compared to a benchmark. The most common benchmark is the Weighted Average Cost of Capital (WACC), also called the hurdle rate. If IRR exceeds WACC, the project creates value; if it falls below, the project destroys value even if the nominal return is positive.
Typical IRR benchmarks by asset class: public equities (S&P 500 long-run average) ~10%; institutional real estate core returns 7–10%; value-add real estate 12–18%; private equity buyouts 20–25%; venture capital portfolio targets 25–35% (with wide dispersion). These benchmarks reflect both the risk premium and illiquidity premium investors demand for each asset class. An IRR of 15% is excellent for a stabilized commercial property but would be considered below-average for a seed-stage startup.
Limitations of IRR: When to Be Cautious
IRR has well-documented limitations. First, the reinvestment rate assumption: IRR implicitly assumes that all intermediate cash flows are reinvested at the same rate as the IRR itself. For high-IRR investments, this is unrealistic — cash flows from a 25% IRR project are unlikely to be reinvested at 25%. The Modified IRR (MIRR) addresses this by explicitly specifying a reinvestment rate, though it is less commonly used in practice.
Second, multiple IRRs: if cash flows change sign more than once (e.g., positive in early years, negative in middle years due to a capital call, positive again at exit), the polynomial can have multiple roots, producing multiple valid IRRs. This calculator uses Newton-Raphson initialized at 10%, which typically finds the economically meaningful root, but if your cash flows include sign changes, verify the result by calculating NPV at several discount rates and confirming the NPV curve crosses zero where expected.
Third, scale insensitivity: IRR is a percentage and ignores absolute size. A $1,000 investment returning 50% IRR creates less wealth than a $1,000,000 investment at 15% IRR. When comparing mutually exclusive projects of different scales, NPV is the definitive metric.
Frequently Asked Questions
What is a good IRR for an investment?
A "good" IRR depends entirely on the asset class and risk level. For stabilized real estate, 8–12% is typical. For value-add real estate or private equity buyouts, 15–25%+ is expected. For venture capital, fund targets often exceed 25–30% to compensate for high failure rates. The key comparison is always: does the IRR exceed your hurdle rate or cost of capital? If yes, the investment creates value; if no, you would do better investing the same capital at your required rate of return.
What is the difference between IRR and ROI?
ROI (Return on Investment) is the total profit divided by the initial investment, expressed as a percentage. It ignores when the cash flows are received. IRR is an annualized rate that accounts for the time value of money — $1 received today is worth more than $1 received in 5 years. A project can have a high total ROI but a low IRR if the returns come very late, and vice versa. IRR is the correct metric for comparing investments with different holding periods or cash flow timing.
How is IRR calculated mathematically?
IRR is the rate r that satisfies: NPV = −I₀ + CF₁/(1+r)¹ + CF₂/(1+r)² + ... + CFₙ/(1+r)ⁿ = 0. There is no closed-form algebraic solution for r when n > 4, so IRR is solved numerically using the Newton-Raphson method (or bisection). Starting from an initial guess (typically 10%), the algorithm iteratively adjusts r using the formula r_new = r_old − NPV(r_old)/NPV'(r_old) until NPV converges to zero within a small tolerance.
What does a negative IRR mean?
A negative IRR means the investment loses money even before accounting for the time value of money — the total undiscounted cash flows returned are less than the initial investment. This typically signals a failed investment where the project was written down, went bankrupt, or was sold at a loss. In private equity fund reporting, a negative IRR on an individual deal is common and expected (not every deal succeeds); the portfolio IRR reflects the weighted outcome across all investments.
What is the difference between IRR and XIRR?
Standard IRR assumes cash flows are evenly spaced (e.g., exactly one year apart). XIRR (Extended IRR, used in Excel and financial modeling) handles cash flows on specific dates — useful when investments and returns occur on irregular calendar dates rather than exactly one year apart. For most planning calculations, the difference between IRR and XIRR is small. XIRR matters most for precise LP reporting in private funds where capital calls and distributions happen on specific dates.