Paycheck Tax Calculators
What do you want to work out?

NPV calculator

The NPV calculator discounts a list of cash flows back to today at the rate you choose and adds them up. A positive result means the flows are worth more than the discount rate demands, and a negative one means they are worth less. It also returns the internal rate of return, the profitability index and the discounted payback, and shows the discounted cash flow table.

What net present value tells you

The fields hold the worked example. Change any value and the result updates at once.

The return you require per period, above −100, for example 10.

In order, separated by semicolons, spaces or new lines. Money paid out is negative. 2 to 100 values.

The discount rate is per period of this length.

Result

Fill in the fields above to see the result and every step here.

Solve a single payment or rate problem →

Worked example: a three-year project

Each cash flow is divided by one plus the discount rate, raised to the number of periods from today, and the results are added. With the first flow at time zero it is not discounted. If you choose time one, every flow is discounted one more period, which is how the spreadsheet NPV function works. The internal rate of return is the rate that makes the net present value zero, found by repeated search. Discounted payback is when the running total of discounted flows turns positive.

Time zero or time one

Most project cash flows start with an outlay today, followed by returns at the end of each later period. This calculator treats the first value as time 0, so it is counted in full and not discounted, and the second value is one period away. That is the usual textbook layout and the default here.

The NPV function in common spreadsheets works differently: it treats the first value it is given as one period away and discounts every value at least once. Analysts usually add the time-0 outlay separately outside the function. If you want to match a spreadsheet that puts every flow inside NPV(), switch the setting to time 1 and every flow moves one period later, which lowers the result.

The internal rate of return does not depend on this choice, because moving every flow by the same period scales the whole sum without changing where it crosses zero. The period length only labels the result: a rate per month must be entered as a monthly rate, and the IRR is then a rate per month too.

Questions about calculating NPV

Related calculators

How to calculate NPV on a financial calculator?

Enter the first cash flow, then each later cash flow, then the discount rate, and ask for NPV. This page does the same and shows the working in a table. For the example flows at 10% percent, the NPV is −$21.04.

How to find NPV on a financial calculator?

The key choice is when the first cash flow happens. If it is today, it is not discounted. If it falls one period from now, every flow is discounted one more period. With cash flows of $300, $400 and $500 starting at time one and a rate of 10% percent, the NPV is $978.96.

How to do NPV on a financial calculator?

Treat the initial outlay as a negative cash flow and the later receipts as positive, set the discount rate, then compute. A second project with an outlay of −$5,000 and four yearly receipts at 8% percent gives an NPV of −$31.81 and an IRR of 7.714% percent.

Results follow the rules named above and are estimates. They are not tax, legal or financial advice and do not replace your pay stub or your tax return.