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
Result
How it was calculated
Fill in the fields above to see the result and every step here.
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.
Project what regular investing could grow to. See the balance year by year, the split between contributions and growth, and the value after inflation.
Compare with a steady growth rateCalculate the compound annual growth rate from a start value, an end value and the years between them, with the formula shown and the edge cases flagged.
Compare with a certificate of depositFind what a certificate of deposit earns by maturity, convert between rate and APY, and test the net result if you break the CD early.
See the tax side of a cash flowEstimate your federal tax return: taxable income, tax by bracket, credits and whether you get a refund or owe, using the published tax tables.
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.