IRR Calculator
Find the internal rate of return for any investment. Enter your cash flows and get the annualized return that makes NPV equal zero.
Cash Flows
5 / 20 periodsEnter negative values for money going out (investments) and positive values for money coming back (returns).
IRR Explained: The Complete Guide
Everything you need to know about internal rate of return, how it works, and how to use it for smarter investment decisions.
IRR (Internal Rate of Return) is the discount rate that makes the net present value (NPV) of all cash flows from an investment equal to zero. In plain language, it's the annualized rate of return your money actually earns when you account for the timing and size of every cash flow — both the money going out and the money coming back.
How IRR differs from simple ROI:
- ROI ignores timing — ROI treats a dollar received in year one the same as a dollar received in year ten. IRR recognizes that money received sooner is worth more because you can reinvest it.
- ROI doesn't handle multiple cash flows — ROI works best when you invest once and cash out once. IRR handles complex patterns: initial investment, ongoing distributions, capital calls, and a final exit.
- IRR is already annualized — ROI gives you a total percentage that you then need to annualize separately. IRR is inherently an annual rate, making it directly comparable to other annual benchmarks like the S&P 500 return or a bond yield.
- IRR accounts for the time value of money — A fundamental principle of finance is that a dollar today is worth more than a dollar tomorrow. IRR bakes this concept directly into the calculation.
When to use IRR over ROI: Any time your investment involves cash flows at different points in time — rental income from real estate, quarterly distributions from a private equity fund, or periodic dividends from stock holdings. For a simple buy-and-sell transaction with no interim cash flows, ROI and annualized ROI work just fine.
Think of ROI as the quick back-of-napkin calculation, and IRR as the more precise, finance-grade measure that professionals rely on when timing matters.
IRR is the rate (r) that satisfies the equation where the sum of all discounted cash flows equals zero:
0 = CF₀ + CF₁/(1+r)¹ + CF₂/(1+r)² + ... + CFₙ/(1+r)ⁿ
There is no algebraic formula to solve this directly — you can't simply rearrange the equation to isolate r. Instead, IRR must be found using numerical methods that iteratively converge on the answer.
This calculator uses the Newton-Raphson method, which is the same approach used by Excel's IRR function and most financial software. Here's how it works:
- Start with an initial guess — The algorithm begins with an estimated rate (typically 10%).
- Calculate NPV at that rate — Discount all cash flows using the guessed rate and sum them up. If the sum is zero, you've found the IRR.
- Calculate the derivative (slope) — The derivative of the NPV function tells us how fast NPV is changing relative to the rate, which determines the direction and size of the next guess.
- Refine the guess — Using the formula new_rate = old_rate − NPV/NPV', the algorithm moves closer to the true IRR. This process repeats until the change between iterations is smaller than a tolerance threshold (0.0000001 in this calculator).
- Multiple starting guesses — If the first guess doesn't converge, the algorithm tries several alternative starting points to handle edge cases like very high or very low IRRs.
The Newton-Raphson method typically converges in under 20 iterations for well-behaved cash flow patterns, making it both fast and accurate. It can fail in rare cases — for example, if cash flows alternate signs many times, there may be multiple valid IRRs, and the algorithm will return whichever it finds first.
What qualifies as a "good" IRR depends entirely on the type of investment, the risk involved, and the opportunity cost of your capital. Here are the benchmarks professionals use across major asset classes:
Public equity (stock market):
- The S&P 500 has delivered roughly 10% annualized over the long term (before inflation). Any stock investment should ideally beat this benchmark since you're taking on individual stock risk.
- Hedge funds typically target 12-20% IRR net of fees, though actual performance varies widely.
Private equity and venture capital:
- Private equity buyout funds target 15-25% gross IRR (before fees). After the typical 2-and-20 fee structure, investors see roughly 12-18% net.
- Venture capital targets higher — 25-35%+ gross IRR — to compensate for the high failure rate. Most individual VC investments return zero, so the winners must be exceptional.
- Growth equity sits in between at 20-30% gross IRR.
Real estate:
- Core real estate (stable, Class A properties): 6-10% IRR.
- Value-add projects (renovation, repositioning): 12-18% IRR.
- Opportunistic development: 18-25%+ IRR.
The golden rule: Higher expected IRR should correspond to higher risk. If someone promises a 30% IRR on a "safe" investment, be skeptical. Risk and return are inseparable in finance, and IRR benchmarks exist precisely to help you evaluate whether the return justifies the risk.
IRR is one of the most widely used metrics in finance, but it has well-known limitations that can lead to poor decisions if you're not aware of them.
Key limitations:
- The reinvestment rate assumption — IRR implicitly assumes that all intermediate cash flows can be reinvested at the IRR itself. If a project has a 30% IRR, the math assumes you can reinvest every distribution at 30%. In reality, reinvestment opportunities might only yield 5-10%. This makes high-IRR projects look better than they actually are.
- Multiple IRRs — When cash flows change sign more than once (e.g., invest, receive, invest again, receive), the equation can have multiple mathematical solutions. This makes the result ambiguous and potentially misleading.
- Scale blindness — IRR doesn't account for the size of the investment. A 50% IRR on a $1,000 investment creates $500 of value, while a 15% IRR on a $1,000,000 investment creates $150,000. IRR alone would favor the smaller investment, even though the larger one generates far more wealth.
- Timing manipulation — Because IRR is sensitive to when cash flows occur, it can be artificially inflated by accelerating early returns. A fund manager could engineer a high IRR by returning capital quickly on small wins, even if the overall investment creates less total value.
- No IRR solution — Some cash flow patterns produce no valid IRR at all. This happens when there's no discount rate that brings NPV to exactly zero.
How to mitigate these limitations:
- Use Modified IRR (MIRR) which allows you to specify a separate reinvestment rate, eliminating the unrealistic reinvestment assumption.
- Pair IRR with NPV to understand the absolute dollar value created, not just the percentage return.
- Look at multiple of invested capital (MOIC) alongside IRR to separate the return magnitude from the timing effect.
IRR is a powerful tool, but it works best as one metric in a toolkit, not as the sole decision driver.
IRR and NPV (Net Present Value) are two sides of the same coin. Both use the concept of discounted cash flows, but they answer different questions and serve different purposes.
The fundamental difference:
- NPV tells you the dollar value created — Given a specific discount rate (your required return), NPV calculates the present value of all future cash flows minus your initial investment. A positive NPV means the investment creates value; a negative NPV means it destroys value.
- IRR tells you the break-even return rate — IRR is the discount rate at which NPV equals exactly zero. It answers: "At what rate of return does this investment just barely pay for itself?"
When they agree and disagree:
For a single, standalone investment decision ("Should I invest in this or not?"), IRR and NPV always give the same answer. If IRR exceeds your required return (discount rate), NPV will be positive — both say "yes."
However, when comparing mutually exclusive projects (you can only pick one), IRR and NPV can disagree. A smaller project with a 25% IRR might have a lower NPV than a larger project with an 18% IRR. In this situation, NPV is the better guide because it measures actual wealth creation.
Practical guidance:
- Use IRR for quick screening ("Does this meet our hurdle rate?") and for communicating returns in a standardized, percentage-based format.
- Use NPV for final investment decisions, especially when choosing between alternatives of different sizes or durations.
- Use both together for the most complete picture. A project with a high IRR and a high NPV is clearly attractive. A project with a high IRR but low NPV might not move the needle enough to be worth your time.
DCF (Discounted Cash Flow) analysis is essentially NPV applied to stock valuation — it discounts a company's projected future cash flows to determine what the business is worth today.
Yes, IRR can absolutely be negative, and it means exactly what you'd expect: the investment is losing money. A negative IRR indicates that the sum of discounted cash inflows is less than the initial outlay, even at a 0% discount rate.
What a negative IRR looks like in practice:
- IRR of -5% — You're losing about 5% of your invested capital per year on an annualized basis. Over five years, a -5% IRR on a $100,000 investment means you'd get back roughly $77,000 in total.
- IRR of -100% — You lost everything. Your total cash received was zero.
- IRR between -100% and 0% — You got some money back, but less than you put in.
Common scenarios that produce negative IRRs:
- A startup that burns through investor capital and fails before generating meaningful revenue.
- Real estate development where construction costs overrun and the property sells below total cost.
- A stock purchased at a peak that's sold at a loss after receiving minimal dividends along the way.
- A business acquisition where the target company's performance deteriorated post-purchase.
What to do with a negative IRR: The first step is understanding why. Is it a timing issue (holding too short), a fundamentals issue (the business isn't generating returns), or a market issue (temporary downturn)? A negative IRR on a partially completed project might turn positive if cash flows improve in later years. Run the calculation with projected future cash flows to see if the trajectory changes.
Remember that IRR is backward-looking when applied to historical cash flows. A negative IRR on a past investment is useful for learning, but it's the projected IRR on future decisions that determines whether to act.
IRR is the dominant performance metric in both real estate investing and private equity. These asset classes involve complex, multi-year cash flow patterns that make simple ROI inadequate — and IRR was practically built for this use case.
Real estate applications:
- Acquisition analysis — Before buying a property, investors model the expected cash flows: purchase price (negative), rental income minus expenses (positive annually), capital expenditures (periodic negatives), and sale proceeds (large positive at exit). The IRR of this stream determines whether the deal meets the investor's return target.
- Development projects — Land acquisition, construction costs, and lease-up periods create front-loaded negative cash flows before any revenue appears. IRR captures the impact of this timing, which is critical because development capital is tied up for years before generating returns.
- Waterfall distributions — Real estate partnerships often use IRR-based hurdle rates to split profits. For example, the general partner might receive 20% of profits only after limited partners achieve a 12% IRR on their invested capital.
Private equity applications:
- Fund performance reporting — Limited partners evaluate PE funds primarily on their net IRR. A top-quartile buyout fund might deliver 18-22% net IRR, while median performance runs 12-15%.
- Deal-level evaluation — Before acquiring a company, the PE firm models leveraged returns. The cash flow pattern includes the equity investment (negative), any dividend recapitalizations (positive), and the exit sale (large positive). The deal only gets approved if the projected IRR exceeds the fund's hurdle rate, typically 15-20%.
- Carried interest calculations — Similar to real estate waterfalls, PE fund managers earn "carry" (typically 20% of profits) only after returning investor capital plus a preferred return, which is defined as an IRR threshold (commonly 8%).
- J-curve analysis — New PE funds typically show negative IRRs in early years (the "J-curve") as management fees are charged before investments mature. Understanding how IRR evolves over a fund's life is critical for setting realistic expectations.
Why IRR dominates these industries: Both real estate and private equity involve illiquid, multi-year investments with irregular cash flow timing. You can't just look at a starting value and ending value like you would with a stock. IRR handles the full complexity of when money goes in, when it comes back, and what that pattern implies about annualized returns.
That said, sophisticated investors always pair IRR with other metrics — particularly MOIC (Multiple on Invested Capital) and DPI (Distributions to Paid-In Capital) — to get the full picture of how an investment actually performed.
Ready to go beyond IRR and find what a stock is really worth?