Skip to main content
ponderloop

IRR and NPV Calculator

A project that costs 10,000 now and returns 3,000, 4,200 and 6,800 over the next three years has a net present value of 1,307.29 at a 10% discount rate and an internal rate of return (IRR) of 16.34%. NPV is each cash flow divided by (1 + rate) raised to its period, added up; the IRR is the rate at which that sum is exactly 0. Because the NPV is above 0 and the IRR is above 10%, the project earns more than the discount rate. The profitability index is 1.1307, the simple payback 2.41 years and the discounted payback 2.74 years. Type your own cash flows, one per line with time 0 first, to see every period’s discount factor and present value, the NPV at other rates, every IRR when there are several, and the MIRR. These are estimates from the numbers you enter, not advice.

Updated Runs in your browser: nothing you enter is uploadedHow this tool works

One cash flow per line (or separated by commas, spaces or semicolons). The first is time 0, usually negative. Use a dot for decimals and no thousands separators.

NPV 1,307.29, IRR 16.34%

4 cash flows (periods 0 to 3) discounted at 10% a year.

NPV
1,307.29
IRR
16.34%
Profitability index
1.1307
Simple payback
2.41 years
Discounted payback
2.74 years
MIRR
14.6%
Sum of the cash flows
4,000.00
Cash flows
4 (periods 0 to 3)

Each cash flow is divided by (1 + rate)^period, with period 0 undiscounted. IRR is the rate that makes NPV exactly 0, found between −99% and 1,000% per period. An estimate, not financial advice.

The working, period by period

Discount factor = 1 ÷ (1 + rate)^period; present value = cash flow × discount factor. Every row is rounded on its own from the exact value, so a column can differ from its total by a cent.

PeriodCash flowDiscount factorPresent valueCumulative PVCumulative cash
0−10,000.001.000000−10,000.00−10,000.00−10,000.00
13,000.000.9090912,727.27−7,272.73−7,000.00
24,200.000.8264463,471.07−3,801.65−2,800.00
36,800.000.7513155,108.941,307.294,000.00

NPV profile: NPV at other discount rates

Annual discount rateNPVRule: NPV > 0
0%4,000.00Accept: NPV above 0
5%2,540.76Accept: NPV above 0
10%1,307.29Accept: NPV above 0
15%255.61Accept: NPV above 0
20%−648.15Reject: NPV below 0
25%−1,430.40Reject: NPV below 0
30%−2,111.97Reject: NPV below 0

NPV against the discount rate for the example

NPV of the cash flows −10000, 3000, 4200, 6800 at annual discount rates from 0% to 30%, computed by the calculator. The IRR, 16.34%, is where the NPV crosses 0.
Annual discount rateNPVRule: NPV > 0
0%4,000.00Accept: NPV above 0
5%2,540.76Accept: NPV above 0
10%1,307.29Accept: NPV above 0
15%255.61Accept: NPV above 0
20%−648.15Reject: NPV below 0
25%−1,430.40Reject: NPV below 0
30%−2,111.97Reject: NPV below 0

IRR of simple investments

One payment now and one amount back later, with nothing in between. The IRR is the compound yearly growth rate; the NPV is at an 8% discount rate. Computed by the calculator.
InvestmentCash flowsIRRNPV at 8%
Pay 1,000, get 1,100 after 1 year−1000, 110010%18.52
Pay 1,000, get 1,210 after 2 years−1000, 0, 121010%37.38
Pay 1,000, get 1,331 after 3 years−1000, 0, 0, 133110%56.59
Pay 1,000, get 2,000 after 5 years−1000, 0, 0, 0, 0, 200014.87%361.17
Pay 1,000, get 2,000 after 10 years−1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20007.18%−73.61
Pay 1,000, get 1,000 after 4 years−1000, 0, 0, 0, 10000%−264.97
Pay 1,000, get 500 after 1 year−1000, 500−50%−537.04

NPV and IRR decision rules

How each measure is read. The last column is the answer for the example cash flows −10000, 3000, 4200, 6800 at 10%.
MeasureAccept the project whenWatch out forExample
NPVNPV is above 0 at your discount rateThe result depends on the rate you choose; compare projects of different size with the profitability index1,307.29
IRRIRR is above your required rate (hurdle rate)Several IRRs when the sign changes more than once; can rank mutually exclusive projects wrongly16.34%
Profitability indexIndex is above 1Ignores scale: a small project can have a high index and a small NPV1.1307
Simple paybackPayback is shorter than the time you can waitIgnores the time value of money and every flow after payback2.41 years
Discounted paybackDiscounted payback is shorter than the time you can waitStill ignores flows after payback2.74 years
MIRRMIRR is above your required rateDepends on the finance and reinvestment rates you assume14.6%

When the cash flows change sign more than once

Cash flows whose sign changes more than once can have several IRRs, or none. Each IRR below was found by the calculator in the range −99% to 1,000% per period; the NPV is at 10%.
CaseCash flowsIRRsNPV at 10%
Two IRRs−100, 230, −13210% and 20%0.00
Two IRRs, not round numbers−1000, 2300, −13103.82% and 26.18%8.26
Three IRRs−1000, 6000, −11000, 60000%, 100% and 200%−128.47
Sign changes twice but no IRR−100, 150, −100No IRR in the scanned range−46.28

Two mutually exclusive projects: the IRR and the NPV can disagree

Project A returns its money early, project B late. A has the higher IRR, but the NPV favours B below 10.55% and A above it. Computed by the calculator.
ProjectCash flowsIRRNPV at 5%NPV at 10%NPV at 15%
A−10000, 10000, 1000, 100016.04%1,294.68668.67109.31
B−10000, 1000, 1000, 1200012.94%2,225.46751.31−484.10
B minus A0, −9000, 0, 1100010.55%

How to calculate NPV and IRR from a list of cash flows

  1. List the cash flows in order. Type one cash flow per line, starting with time 0 (usually the negative outlay). The example is −10000, 3000, 4200, 6800. Put 0 for a period with no cash flow, so every period is counted.
  2. Enter the discount rate and the period length. Type the annual discount rate (10% in the example) and the length of one period. The default is one year; for monthly flows choose months and the calculator uses the rate of one month (the annual rate times the period length in years).
  3. Read the NPV. Each cash flow is divided by (1 + rate) to the power of its period and the results are added: 1,307.29 for the example. The table under the result shows each discount factor, present value and the running total.
  4. Read the IRR. The IRR is the rate that makes the NPV exactly 0: 16.34% here. If the cash flows change sign more than once the calculator lists every IRR it finds and warns you.
  5. Compare with your hurdle rate and check the other measures. Accept a stand-alone project when the NPV is above 0 or the IRR is above your required rate. Check the profitability index (1.1307), the paybacks (2.41 years and 2.74 years) and the NPV profile for how sensitive the answer is to the rate.

Frequently asked questions

How do you calculate NPV?
Divide every cash flow by (1 + r)^t, where r is the discount rate per period and t is the number of periods since today, then add the results. Period 0 is not discounted. For −10000, 3000, 4200, 6800 at 10%: −10,000 + 3,000 ÷ 1.1 + 4,200 ÷ 1.1² + 6,800 ÷ 1.1³ = 1,307.29. The calculator does the sums with exact fractions and rounds the total once at the end, so the present values in the table can differ from the total by a cent.
How is the IRR calculated, and why is it numeric?
The IRR is the rate r that makes NPV(r) = 0. For more than two cash flows the equation is a polynomial of degree 2 or more with no general formula, so it is solved numerically. The calculator reads the exact sign of the NPV at the rates −99% to 100% in steps of 0.1% and 100% to 1,000% in steps of 1% (per period), and wherever the sign flips it narrows the interval with Newton’s method guarded by bisection until it is 0.0000000001 percentage points wide. Every point is judged on the exact NPV, never on a floating-point value. For the example the result is 16.34%.
What is a good IRR?
There is no universal number. An IRR is good when it is comfortably above the return you require from an investment of that risk, your hurdle rate or cost of capital. The example has an IRR of 16.34% against a 10% discount rate, so it clears the hurdle with room to spare; the same 16.34% would be poor against a 20% requirement. The NPV profile table shows where the answer flips: the NPV is 255.61 at 15% and −648.15 at 20%.
Why can there be more than one IRR?
NPV is a polynomial in 1 ÷ (1 + r), and a polynomial can cross zero as many times as the cash flows change sign (Descartes’ rule of signs). One sign change, the usual pattern of an outlay followed by receipts, gives exactly one IRR. Cash flows such as −100, 230, −132 change sign twice and have two IRRs, 10% and 20%; −1,000, 6,000, −11,000, 6,000 has three, 0%, 100% and 200%. Some cash flows with two sign changes have none (−100, 150, −100). The calculator lists every IRR it finds and warns you. When there are several, use the NPV at your own discount rate: for −100, 230, −132 it is 0.19 at 15%, positive between the two IRRs and negative outside them.
What if NPV and IRR give different answers?
For a single project with one outlay followed by receipts they agree: NPV is above 0 exactly when the IRR is above the discount rate. They can disagree when you rank projects. Project A (−10000, 10000, 1000, 1000) has an IRR of 16.04% and project B (−10000, 1000, 1000, 12000) has 12.94%, yet at 10% B has the higher NPV, 751.31 against 668.67. The two NPV curves cross at 10.55%, which is the IRR of the difference between the projects (B minus A): below it B has the higher NPV, above it A does (at 15% A has 109.31 and B has −484.10). Trust the NPV at your own discount rate.
Which project should I choose when they are mutually exclusive?
Choose the one with the higher NPV at your discount rate, provided both are measured over the same horizon and the rate reflects their risk. In the A and B example the choice at 10% is B (751.31 against 668.67) even though A has the higher IRR. The IRR of a larger project can also be lower than that of a small one while adding far more value: 100 turning into 150 has an IRR of 50% and an NPV of 36.36 at 10%, whereas 100,000 turning into 120,000 has an IRR of only 20% but an NPV of 9,090.91. If you cannot do both, the second adds more value. If projects have different lengths, compare them over a common horizon.
Why can the IRR be misleading?
Four common reasons. It can have several values when the sign changes more than once. It ignores scale, so a small project can have a high IRR and add little value (50% on 100 against 20% on 100,000 above). It can rank mutually exclusive projects differently from NPV, as in the A and B example. And it implicitly assumes every cash flow is reinvested at the IRR itself, which is often unrealistic for a very high IRR: doubling money over ten years has an IRR of 7.18%, and it is rarely possible to reinvest all the interim returns at that rate. If the first cash flow is positive (a loan you receive), a lower IRR is better, not higher.
What is the reinvestment assumption, and what does MIRR fix?
Taking the IRR as the project’s return assumes the cash it releases is reinvested at the IRR, while NPV assumes reinvestment at the discount rate. The modified IRR (MIRR) makes the assumption explicit: it compounds the positive cash flows forward to the end at a reinvestment rate, discounts the negative ones back to time 0 at a finance rate, and takes the rate that links the two: (future value of inflows ÷ present value of outflows)^(1 ÷ T) − 1. For the example the MIRR is 14.6% when both rates equal the discount rate, 14.32% with a 6% finance rate and a 9% reinvestment rate, against an IRR of 16.34%. The MIRR is always a single number, whatever the sign pattern.
What discount rate should I use?
Use the return you could expect from the best alternative use of the money with the same risk: your opportunity cost of capital. Companies often use the weighted average cost of their debt and equity, adjusted for how risky the project is compared with the business as a whole; an individual might use the return available on a comparable investment, or the interest rate on debt that the money could pay off. A riskier project should be discounted at a higher rate. Use a nominal rate with nominal cash flows and a real rate with inflation-adjusted flows, never a mix. Because the right rate is uncertain, look at the NPV profile table rather than one number: it shows how far the rate can move before the answer changes.
What is the profitability index?
The profitability index (PI) is the present value of the cash flows after time 0 divided by the initial outlay, which is 1 + NPV ÷ outlay when only the first flow is an outlay. A PI above 1 means a positive NPV. The example has a PI of 1.1307: every 1 invested returns 1.1307 in present value terms. It is useful for ranking projects when money is limited, because it shows value per unit invested, which the NPV alone does not.
What is the difference between payback and discounted payback?
Simple payback is how long the running total of cash flows takes to reach 0: 2.41 years for the example. Discounted payback does the same with present values, so it is longer, 2.74 years here, because later money is worth less. When the total crosses 0 inside a period the calculator interpolates linearly, assuming the cash arrives evenly through that period: (periods before) + (what is still unpaid ÷ that period’s cash flow). Both ignore the cash flows after payback, so use them as a liquidity check and not as a measure of value. If the total never reaches 0 the calculator says so.
How do I enter monthly or quarterly cash flows?
Enter one cash flow per period and set the period length, for example 1 month. The discount rate is still an annual rate; the calculator uses the rate of one period, the annual rate times the period length in years (12% a year is 1% a month). The IRR is then per period, and the calculator also shows it per year, both as the nominal rate (period rate times periods per year) and as the effective compound rate. For −1,000 then 1,010 one month later at 12% a year the IRR is 1% per period, which is 12% nominal and 12.68% effective.
Why does it say there is no IRR?
If every cash flow is zero or has the same sign, NPV never reaches 0 at any rate, so no IRR exists: for 100, 200, 300 the calculator says “No IRR (the cash flows never change sign)”. A project with one outlay and one set of receipts always has an IRR, but it can be outside the scanned range of −99% to 1,000% per period; the calculator then says that the IRR lies outside the range.

How it works

Cash flows CF_0 to CF_T are taken at the end of periods 0 to T, with period 0 undiscounted. The annual discount rate is converted to a per-period rate by multiplying by the period length in years (the nominal convention), which keeps every rate an exact fraction. NPV = Σ CF_t ÷ (1 + r)^t. With 1 + r = A ÷ B, NPV × scale × A^T = Σ CF_t × B^t × A^(T−t) is a whole number, so the NPV, the discount factors, the present values and the running totals are exact fractions of BigInts (the cash flows you typed are decimals, read exactly). They are rounded once, half away from zero, for display: the NPV and present values to 2 decimals, discount factors to 6. The profitability index is the present value of the flows after time 0 divided by the outlay −CF_0, and is not defined when CF_0 is not negative. Payback is the first period in which the running total of cash flows (undiscounted or discounted) reaches 0 or more, interpolated linearly inside that period as (t − 1) + (−running total at t − 1) ÷ CF_t, assuming the cash arrives evenly through the period; if the first cash flow is not negative there is nothing to pay back, and the first crossing is used if the total later falls below 0 again. IRR: the exact sign of NPV is read at the per-period rates −99% to 100% in steps of 0.1% and 100% to 1,000% in steps of 1%. A rate where the NPV is exactly 0 is an IRR; two neighbouring rates with opposite signs bracket one. A root where the NPV touches 0 without changing sign (a double root) between two grid rates is not found, and nothing is searched below −99% or above 1,000% per period. Each bracket is refined with Newton’s method guarded by bisection: Newton’s step is computed in double precision and used only if it falls strictly inside the bracket, and every point is then tested with the exact sign of NPV; if Newton leaves the bracket, or the bracket did not at least halve, the next point is the midpoint. The loop ends when the bracket is 1e-12 wide, so the IRR does not depend on floating-point accuracy. Descartes’ rule of signs bounds the count: the number of IRRs above −100% is at most the number of sign changes in the cash flows, with zeros ignored, and one sign change gives exactly one. The IRR per year is shown as the nominal rate (per-period IRR ÷ period length in years) and, when a whole number of periods fits in a year, the effective rate (1 + i)^m − 1. MIRR = (FV of the positive flows at the reinvestment rate ÷ −PV of the negative flows at the finance rate)^(1 ÷ T) − 1, with both rates defaulting to the discount rate; the ratio is exact and the T-th root is located to 1e-12 by exact comparison. Limits: up to 240 cash flows, a period length of up to 100 years, a discount rate above −100% and up to 10,000% per period. Estimates for planning, not financial advice; the cash flows and the discount rate are your assumptions.

Sources

More: Saving and investingAll money & costsAll toolsHome & DIY calculators