About this tool
IRR is a popular way to compare investments because it expresses a project's return as one percentage that can be set against a hurdle rate, such as the cost of capital. A project whose IRR exceeds the hurdle rate has a positive NPV at that rate.
IRR also has known weaknesses. It implicitly assumes that interim cash flows are reinvested at the IRR itself, which flatters projects with very high returns, and cash flows that change sign more than once can have several IRRs or none. MIRR addresses the first problem with explicit finance and reinvestment rates, and the NPV profile chart shows every rate at which the NPV crosses zero.
How it works
Enter the initial investment as a negative number in period 0, then the cash flow for each following period: positive for money coming in, negative for further outlays. Periods are usually years, but they can be months or quarters as long as the rates you enter are per period.
The internal rate of return is the discount rate at which the net present value of all the cash flows is zero. The calculator scans a wide range of rates for every point where the NPV changes sign, narrows each one down by bisection and refines it with Newton's method. It also reports the NPV at your discount rate, the modified IRR (MIRR) with separate finance and reinvestment rates, and the simple and discounted payback periods.
Example
An investment of 100,000 returns 25,000, 30,000, 35,000, 30,000 and 20,000 over five years. Its IRR is about 12.6%, because discounting all six cash flows at that rate brings their sum to zero. At an 8% discount rate, the NPV is about 12,315, so the project earns more than an 8% hurdle.
The simple payback is years: after three years, 90,000 has come back, and the remaining 10,000 is recovered a third of the way through year four. Discounted at 8%, payback takes about 4.1 years, and the MIRR with 8% finance and reinvestment rates is about 10.5%, lower than the IRR because the interim cash flows are assumed to earn 8% rather than 12.6%.
Assumptions and limits
The results assume that each cash flow arrives at the end of its period and that the periods are evenly spaced. Irregular dates need a date-based method such as Excel's XIRR. The NPV here includes the period 0 cash flow without discounting; Excel's NPV function discounts its first value by one period, so add the initial investment separately when you compare.
When cash flows change sign more than once, the IRR may not be unique. The calculator lists every rate it finds between −99% and 10,000% per period and warns you; in that case, rely on the NPV or MIRR. This tool is for analysis and education, not investment advice.
Frequently asked questions
What is a good IRR?
One that exceeds your hurdle rate, the return you could earn elsewhere at similar risk, which is often the cost of capital. A project with an IRR of 12% is attractive if capital costs 8%, but not if it costs 15%.
Why does my project have two IRRs, or none?
IRR solves a polynomial equation, and every change in the sign of the cash flows can add a solution. A project with a large clean-up cost at the end, for example, can have two IRRs. If the cash flows never change sign, no IRR exists. In these cases, use the NPV at your discount rate or the MIRR.
What is the difference between IRR and MIRR?
IRR assumes that interim cash flows are reinvested at the IRR. MIRR compounds the positive cash flows to the end at a reinvestment rate you choose and discounts the negative ones at a finance rate, giving a single, usually more conservative rate: .
Do the results match Excel's IRR, NPV and MIRR functions?
IRR and MIRR match Excel for the same list of values. Excel's NPV function treats its first value as arriving after one period, so the equivalent of the NPV shown here is NPV(rate, cash flows 1 to n) plus the period 0 cash flow.
What is the discounted payback period?
It is the time it takes for the discounted cash flows to repay the investment. Because later cash flows are worth less after discounting, it is always at least as long as the simple payback, and a project may never pay back on a discounted basis even if it does on a simple one.
Link with your values
Add these parameters to this page’s address to open it with the values filled in, for example to share a calculation or to link to it from an AI assistant. The result is calculated in the browser: the page HTML shows an example for the default values, and the tool sets the data-url-params attribute once the link’s values are applied.
| Parameter | Value | If omitted |
|---|---|---|
currency | ISO 4217 code, for example USD or EUR | your saved or detected currency |
cash_flowsCash flows | values in order from the first one, separated by commas; allowed -1000000000000–1000000000000 | required |
discount_rate_pctDiscount rate for NPV | percent: 6.5 means 6.5%; allowed > -100 – 1000 | default 8 |
finance_rate_pctFinance rate (MIRR) | percent: 6.5 means 6.5%; allowed > -100 – 1000 | default 8 |
reinvestment_rate_pctReinvestment rate (MIRR) | percent: 6.5 means 6.5%; allowed > -100 – 1000 | default 8 |
Examples
?cash_flows=-50000,12000,15000,18000,20000?currency=EUR&cash_flows=-10000,3000,4200,6800&discount_rate_pct=10
Write decimals with a point. Encode a space as %20, + as %2B, # as %23 and & as %26.
Result elements: [data-result-block="irr"]