IRR Calculator

View results · 12.64%

Cash flows and rates

Cash flows

Period 0 is today. Enter money you pay out as negative and money you receive as positive.

Rates are per period: use annual rates for yearly cash flows.

Result

Internal rate of return (IRR)
NPV at 8%
Modified IRR (MIRR)
10.54%
Payback period
3.33 periods
Discounted payback
4.1 periods
Profitability index
1.123
Net cash flow (undiscounted)
$40,000

A positive NPV means the investment earns more than the discount rate.

NPV profileNPV by discount rate. The curve crosses zero at the IRR of 12.64%; the dashed line marks your discount rate.
NPV=∑t=05Ct(1+r)t=−100000+250001.081+300001.082+350001.083+⋯≈12315\text{NPV}=\sum_{t=0}^{5}\frac{C_t}{(1+r)^t}=-100000+\frac{25000}{1.08^{1}}+\frac{30000}{1.08^{2}}+\frac{35000}{1.08^{3}}+\cdots\approx12315
Cash flow table
PeriodCash flowDiscountedCumulativeCumulative discounted
0-$100,000.00-$100,000.00-$100,000.00-$100,000.00
1$25,000.00$23,148.15-$75,000.00-$76,851.85
2$30,000.00$25,720.16-$45,000.00-$51,131.69
3$35,000.00$27,784.13-$10,000.00-$23,347.56
4$30,000.00$22,050.90$20,000.00-$1,296.66
5$20,000.00$13,611.66$40,000.00$12,315.00

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.

∑t=0nCt(1+IRR)t=0\sum_{t=0}^{n} \frac{C_t}{(1+\text{IRR})^t} = 0

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 3+10000÷30000≈3.333 + 10000 \div 30000 \approx 3.33 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: MIRR=(FV+÷PV−)1/n−1\text{MIRR} = (FV_{+} \div PV_{-})^{1/n} - 1.

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.

ParameterValueIf omitted
currencyISO 4217 code, for example USD or EURyour saved or detected currency
cash_flowsCash flowsvalues in order from the first one, separated by commas; allowed -1000000000000–1000000000000required
discount_rate_pctDiscount rate for NPVpercent: 6.5 means 6.5%; allowed > -100 – 1000default 8
finance_rate_pctFinance rate (MIRR)percent: 6.5 means 6.5%; allowed > -100 – 1000default 8
reinvestment_rate_pctReinvestment rate (MIRR)percent: 6.5 means 6.5%; allowed > -100 – 1000default 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"]