NPV Calculator for Uneven Cash Flows

What this tool does

Most net present value calculators assume the same amount comes in every year, which almost no real project does. This one takes the series as it actually is: type the cash flows in order, one per period, starting with the outlay as a negative number. Each one is discounted by the number of periods it is away, and the total is what the whole thing is worth in today's money. A positive figure means the project beats the rate you set; a negative one means the money would do better at that rate somewhere else. The internal rate of return comes along for free, since it is simply the rate at which this total would be zero.

Formula

NPV = sum of each cash flow ÷ (1 + rate) raised to its period number

Variables

Worked example

Limitations

• This is an informational calculator, not personalised financial advice. Rates, fees, taxes and contract conditions vary between institutions and countries.
• The calculation runs at full precision and only the display is rounded. If you copy an intermediate value and retype it, small differences can appear.