# 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.

## 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.

Your ad here?

[Email us](mailto:hi@dennn.is?subject=Advertising%20on%20OneClick%20Pro)

[Ad 433 tools for your AI agents through one MCP server.](https://multitaskai.com/?ref=oneclickpro)
