Calculate annual IRR, NPV, and simple payback for 1–10 years of net cash flows. IRR and NPV use year-end payments; fractional payback assumes cash flow is earned evenly within a year.

Enter net cash flows, including 0 for an empty year. IRR/NPV assume end-of-year flows; payback assumes even cash flow within each year.

Internal Rate of Return Formula

The internal rate of return (IRR) is the value of r that makes the investment’s net present value (NPV) equal to zero, based on the timing of the cash flows. The calculator above finds r by solving the following equation.

0 = -C0 + C1/(1+r)1 + C2/(1+r)2 + … + Cn/(1+r)n

  • Where r is the internal rate of return per period (as a decimal; multiply by 100 to express it as a percent).
  • C0 is the initial investment (cash outflow) at time 0.
  • C1 through Cn are the cash flows at the end of each year (period), and n is the total number of years (periods).

Because the cash flows occur at different times, they generally cannot be combined into a single “final value” and then converted into an IRR with an exponent. In most real cases, the IRR must be found numerically (iteratively) by solving the NPV equation above.

Solve for r such that NPV(r) = 0 (typically using an iterative numerical method).

  • The calculator counts distinct real rates above −100% using exact decimal coefficients, then refines each rate numerically. Signed cash flows may have multiple IRRs or no IRR; numerical range or separation limits produce an explicit error.

Internal Rate of Return Definition

The Internal Rate of Return (IRR) is a financial metric used to assess the profitability of an investment. It represents the discount rate that makes the net present value (NPV) of the investment equal to zero. In other words, it is the rate at which the present value of cash inflows equals the present value of cash outflows.

IRR is crucial because it allows investors to evaluate the potential profitability of an investment project.

FAQ

What is the difference between IRR and ROI?
IRR (Internal Rate of Return) is a financial metric that calculates the rate of return at which the net present value of all cash flows (both positive and negative) from a project or investment equals zero. ROI (Return on Investment), on the other hand, measures the efficiency of an investment by comparing the net profit of the investment to its initial cost.

How does the time value of money affect the calculation of IRR?
The time value of money is a core principle in finance that suggests money available now is worth more than the same amount in the future due to its potential earning capacity. This principle is crucial in calculating IRR because it involves discounting future cash flows to their present value to determine the rate at which the net present value of these cash flows equals zero.

Can IRR be used for investments with irregular cash flows?
Annual cash-flow amounts may vary, but this IRR calculation requires equally spaced years. For irregular payment dates, use a dated method such as XIRR. Signed cash flows can produce multiple IRRs, so compare NPV at a justified discount rate rather than assuming one IRR always exists.

Why might an investment with a high IRR not always be the best choice?
While a high IRR indicates a potentially attractive investment, it may not always be the best choice due to several factors. These can include risk level, the scale of investment, liquidity concerns, or the time horizon of the investment. Additionally, projects with high IRRs may also involve higher levels of uncertainty or require a longer period to realize the returns, making them less desirable compared to investments with lower, but more certain returns.