NPV & IRR Calculator

Enter your initial investment, discount rate and yearly cash flows — get NPV, IRR, profitability index, payback period and discounted payback, with each year's present value shown.

Investment

Cash flows leave later years blank · negatives allowed

Net present value

IRR
Profitability index
Payback period
Discounted payback
Total cash in
Present value of inflows

Year by year

YearCash flowDiscount factorPresent valueCumulative PV

Related calculators

NPV, IRR and what they tell you

Net present value answers one question: after paying for the money you tie up, does this project create value? Each future cash flow is discounted back to today at your required rate — a dollar in year 3 at 10% is worth 1 ÷ 1.1³ = $0.751 now — and the discounted inflows are summed against the initial outlay. Invest $1,000 and receive $300, $400, $500 and $600 over four years at a 10% discount rate and the NPV is 272.73 + 330.58 + 375.66 + 409.81 − 1,000 = $388.77. Positive NPV means the project earns more than your hurdle rate; negative means it destroys value even if it "makes money" in nominal terms.

Internal rate of return is the discount rate at which NPV is exactly zero — the project's own annualised return. For the example it is about 24.9%. There is no closed-form formula; the calculator solves it numerically by bisection, which is robust for conventional projects (an outflow followed by inflows). Compare IRR with your cost of capital: an IRR above the hurdle rate agrees with a positive NPV. Where they disagree, for mutually exclusive projects of different sizes, trust NPV — it measures dollars created, not a rate.

Profitability index is present value of inflows ÷ investment; anything above 1.0 is value-creating and the ratio helps rank projects when capital is limited. Payback period is how many years until cumulative cash flow turns positive — simple to explain, but it ignores the time value of money and everything after the payback point, so it is a liquidity check, not a decision rule. Discounted payback fixes the first flaw by using present values instead.

Choosing a discount rate. Use your weighted average cost of capital for typical corporate projects, a higher rate for riskier ventures, or the return on your next-best alternative. Small changes matter: the example's NPV falls from $389 at 10% to $235 at 15%. If cash flows change sign more than once (an outflow in the middle, for instance) the IRR can have multiple solutions — the calculator reports the one nearest a sensible range and NPV remains the reliable guide.

Frequently asked questions

What is a good NPV?
Any positive NPV means the project returns more than your discount rate; larger is better in absolute dollars. Compare projects of different sizes with the profitability index (PV of inflows ÷ investment) rather than raw NPV.
What is the difference between NPV and IRR?
NPV is a dollar amount at a rate you choose; IRR is the rate at which NPV equals zero. They agree on accept/reject for a single conventional project. For ranking projects of different scale or timing, NPV is the more reliable measure.
How is IRR calculated?
By trial and error: the calculator searches for the discount rate that makes the present value of all cash flows sum to zero, using bisection between −99% and 1,000% to a precision of 0.0001%. Spreadsheets do the same with Newton's method.
Why does my IRR say 'none' or look strange?
IRR only exists when the cash flows change sign at least once. All-positive or all-negative flows have no IRR, and flows that change sign several times can have more than one. NPV is always well defined; use it in those cases.
Can I enter cash flows monthly instead of yearly?
Yes — enter monthly amounts and a monthly discount rate (annual ÷ 12). The IRR returned will then be a monthly rate; multiply by 12 for a simple annual figure or compound it ((1 + r)^12 − 1) for an effective one.
What discount rate should I use?
Your cost of capital or required return: often 8–12% for established businesses, 15–25% for startups or high-risk projects, or the yield on your best alternative investment. Higher rates lower NPV and make projects harder to justify.

Last reviewed · How ListCalc calculates · Report an error