NPV & IRR Calculator
Net present value, IRR, payback and profitability index from your cash flows.
About this tool
List the cash flows one per line β the investment as a negative number first, then each period's net inflow β and set the discount rate. The tool returns NPV, IRR, simple and discounted payback, the profitability index and a table of discount factors and present values per period.
Reading NPV and IRR
Money now is worth more than the same money later, because it could be earning a return in the meantime. Net present value discounts each future cash flow by (1 + rate)^period and adds them to the upfront cost: a positive NPV means the project earns more than your required return, a negative one means you would do better elsewhere. The discount rate should be your cost of capital or the return available at similar risk β 8β12% is common for small businesses. The internal rate of return is the rate at which NPV is exactly zero; the tool solves it by bisection and reports βnoneβ when the flows never change sign, rather than inventing a number. When flows change sign several times there can be more than one IRR, and NPV is the reliable guide. Payback shows how long until the money is back; the profitability index ranks projects when cash is limited. The ROI calculator gives the simple view, the break-even calculator works in units, How to calculate your break-even point (and what it doesn't tell you) explains the basics, and the loan calculator prices the financing. General information, not financial advice.
Frequently asked questions
What is a good NPV?
Any NPV above zero means the project beats the discount rate you chose. Between competing projects, the higher NPV adds more value β provided the cash-flow forecasts are realistic.
Why does it say there is no IRR?
IRR only exists if the cash flows change from negative to positive at some point. If every flow is positive (or negative), no discount rate makes NPV zero.
What discount rate should I use?
Your cost of capital β the blended rate of your loans and the return investors expect β or the return you could get on an investment of similar risk.
Can the periods be months?
Yes. Use monthly cash flows with a monthly rate (an annual 12% is about 0.95% a month). The payback figures are then in months.