MihsabaInternal Rate of Return Calculator

Internal Rate of Return Calculator

Calculate one or more internal rates of return for periodic cash flows: rates that make NPV equal zero, with warnings for multiple roots or no root in the search range.

How to use

Internal rate of return is the periodic discount rate that makes the net present value of a periodic cash-flow series equal zero. Some cash-flow patterns can have more than one valid rate, so this calculator searches for multiple roots rather than assuming IRR is always unique.

  1. Enter CF0, CF1, CF2… with their real signs, separated by commas or lines.
  2. At least one positive and one negative cash flow are required, with no more than 40 values.
  3. Calculate to display each IRR root found in the search interval from -99.9999% up to a decimal rate of 1,000,000.

How it is calculated

0=Σ CFₜ÷(1+IRR)ᵗ

Example

Example: -1000, 400, 400, 400 gives a periodic IRR of about 9.70%. Cash flows with multiple sign changes can produce more than one root.

Important notes

This is a mathematical tool, not investment advice. It assumes equal periods and does not use actual dates, so it is not XIRR. A real root may not exist in the search range, and multiple roots are possible; interpret IRR alongside NPV and project assumptions.

Frequently asked questions

Why can there be multiple IRRs?

Multiple sign changes in cash flows can make the NPV=0 equation have several real roots.

Is IRR always annual?

No. IRR has the same period as the cash-flow spacing; monthly flows produce a monthly IRR unless converted appropriately.

Is this calculator free?

Yes. It is free to use and requires no account.