Skip to content

NPV and IRR Calculator

Evaluate an investment from its cash flows: enter the initial outlay as a negative number followed by the returns of each period, and get the net present value at your discount rate, the internal rate of return, the payback period and the sum of all cash flows.

Reset

Frequently asked questions

How do I enter the cash flows?

In order, starting with period 0, separated by commas, spaces or new lines. Money you pay out is negative and money you receive is positive, for example -10000, 3000, 4000, 4000, 3000. Do not use thousands separators.

What is the net present value?

The sum of all cash flows, each discounted back to today at the discount rate: NPV = sum of CF(t) / (1 + r)^t. A positive NPV means the investment earns more than the discount rate.

What is the internal rate of return?

The discount rate at which the NPV is exactly zero. It is the yearly return the investment earns on the money tied up in it, if the periods are years.

Why is no IRR shown?

An IRR only exists when the cash flows contain both negative and positive values and the NPV changes sign between a loss of almost 100% and a return of 1,000% per period. Unusual cash flow patterns with several sign changes can also have more than one IRR.

Does the first cash flow get discounted?

No. The first value is period 0, today, and counts in full, like the NPV functions of most finance textbooks. Spreadsheet NPV functions start discounting with the first value, so add the initial investment separately there.

What is the payback period?

The number of periods until the cumulative cash flow turns positive, interpolated within the period in which it happens. It ignores the time value of money.

About OneClick Pro

OneClick Pro is a free collection of more than 150 web tools for everyday work: converting images and units, formatting and validating code, checking domains and SEO, and working with text, dates and numbers. Every tool runs without registration or subscription, and what you enter is only used to calculate your result and is never stored. Use it as a quick toolbox for one-off tasks, or bookmark the tools you rely on every day.