Internal Rate of Return Calculator
About Internal Rate of Return Calculator
What Is Internal Rate of Return?
Internal Rate of Return (IRR) is the discount rate that makes the net present value of all cash flows from a project equal to zero. In simpler terms, it’s the annualized rate of return an investment is expected to generate. If the IRR exceeds your required rate of return (or hurdle rate), the investment is worth pursuing. Private equity firms, venture capitalists, and real estate investors use IRR constantly because it accounts for both the size and timing of every cash flow.
How IRR Is Calculated
There is no closed-form solution for IRR – it must be found iteratively. The calculator uses Newton’s method to find the rate r where NPV = sum of [CFt / (1+r)^t] = 0. Starting from an initial guess, the algorithm refines the estimate until it converges on a rate accurate to at least four decimal places. This happens in milliseconds behind the scenes.
How to Use This Calculator
Enter your initial investment (as a negative cash flow) and then add the expected cash flows for each subsequent period. Click Calculate to find the IRR. The result tells you the effective annual return. Compare it to your hurdle rate or the returns available from alternative investments. You can add up to 20 periods of cash flows to model complex investment scenarios.
Frequently Asked Questions
What is a good IRR?
It depends on the asset class. Real estate investments typically target 15-20% IRR. Venture capital aims for 25%+ to compensate for high failure rates. For corporate projects, an IRR above the company’s WACC is acceptable.
What is the difference between IRR and NPV?
NPV gives you a dollar amount of value created or destroyed. IRR gives you a percentage return. Both are useful but NPV is generally preferred when projects are mutually exclusive because a higher IRR doesn’t always mean more value created.
Can a project have multiple IRRs?
Yes. When cash flows change sign more than once (for example, an initial outflow, then inflows, then another outflow), there can be multiple mathematical solutions. In such cases, NPV analysis is more reliable than IRR.
Related Tools
