NPV Calculator
Enter a discount rate, the money you put in at the start and the cash each year pays back, and this NPV calculator works out the net present value — what the whole project is worth in today's dollars.
Use the NPV Calculator
On this page
It discounts each year's cash flow back to today at the rate you enter, adds them up, and subtracts the initial investment.
What this calculator does
Net present value, or NPV, answers the question every project decision comes down to: is this worth more than it costs, in today's dollars? A dollar received next year is worth less than a dollar in hand today, because today's dollar could be earning a return in the meantime — so future cash has to be discounted back to the present before it can be compared with money spent now. You put in a discount rate, the initial investment and the cash flow for each of five years. The calculator works out the present value of the inflows, the net present value, and the undiscounted total for comparison.
NPV is the standard test for business projects, equipment purchases, rental property and any decision where money goes out now and comes back over time. A positive NPV means the project is worth more than it costs at the discount rate you entered; a negative NPV means it is not. This calculator is a general-purpose arithmetic tool, not investment advice, and it does not predict future cash flows.
How this is calculated
Net present value is −initial investment + CF1/(1+r) + CF2/(1+r)2 + CF3/(1+r)3 + CF4/(1+r)4 + CF5/(1+r)5, where CFt is the cash flow in year t and r is the discount rate as a decimal. Each year's cash flow is divided by (1+r) raised to the power of the year, which shrinks later cash flows more than earlier ones. The present value of the inflows is the sum of those discounted cash flows, before the initial investment is subtracted.
Source
The net present value formula is the standard definition used in investment analysis and taught in introductory finance. It is an arithmetic definition, not a program rule, so no agency source sets it; the figures you enter decide the result.
Limitations
The result is only as good as the discount rate and the cash flows you enter. A rate that is too low makes every project look good; a rate that is too high rejects projects that would pay off. The calculator assumes cash flows arrive at the end of each year and that the discount rate stays the same every year. It does not account for taxes, inflation or risk beyond what is already built into the rate you choose, and it covers five years — a longer project needs its later cash flows added to the final year or worked out separately.
What each input means
Discount rate. The yearly rate that reflects the time value of money for this project, entered as a number such as 10 for 10%. Often this is your cost of capital, or the return you could earn elsewhere at similar risk. Initial investment. The money paid out at the start, before any cash comes back. Year 1 to Year 5 cash flow. The net cash each year brings in, after costs. Enter 0 for a year with no cash flow, and a negative number for a year when money goes out. Cash flows are treated as arriving at the end of each year.
How to read your result
Start with the net present value. A positive NPV means the project adds value at the discount rate you entered — the inflows, in today's dollars, are worth more than the outlay. A negative NPV means the opposite: the project costs more than it returns, and the money would do better at the discount rate elsewhere. An NPV of zero means the project exactly breaks even. Then compare the present value of the inflows with the undiscounted total: the gap between them is the cost of waiting, and it grows with the discount rate and with how far in the future the cash arrives. Try the calculation at a higher and a lower rate to see how sensitive the decision is to the rate you chose.
Worked example
You invest $100 and receive $30 in year 1, $35 in year 2, $40 in year 3 and $45 in year 4, with nothing in year 5. At a discount rate of 10%, the present value of the inflows is $30/1.10 + $35/1.102 + $40/1.103 + $45/1.104 = $27.27 + $28.93 + $30.05 + $30.74 = $116.99. Subtract the $100 invested and the net present value is $16.99 — the project adds about $17 of value at a 10% rate. At an 8% rate the same cash flows give an NPV of $22.61, because future cash is discounted less heavily.
Common questions
What does a positive NPV mean?
A positive NPV means the project is worth more than it costs, in today's dollars, at the discount rate you entered. The inflows, discounted back to the present, exceed the initial investment. A negative NPV means the project costs more than it returns, and the money would do better earning the discount rate elsewhere.
How do I pick a discount rate?
Use the rate that reflects what the money is worth to you: often the cost of borrowing it, or the return you could earn on an alternative of similar risk. A higher rate sets a tougher test. If you are unsure, try the calculation at two or three rates and see whether the decision changes.
How is NPV different from IRR?
NPV gives a dollar figure — how much value a project adds at a chosen discount rate. IRR gives a percentage — the discount rate at which the NPV would be zero. They usually agree on whether a project is worth doing, but NPV is better for comparing projects of different sizes, since it shows the amount of value, not just the rate.
What if my cash flows are monthly, not annual?
This calculator works with annual cash flows. For monthly cash flows, add each year's months together into an annual figure, or use a monthly discount rate — the annual rate divided by 12 — with monthly periods in a spreadsheet. Mixing monthly cash flows with an annual rate would understate the present value.
Does NPV include the initial investment?
Yes. Net present value is the present value of the inflows minus the initial investment. The present value of the inflows alone is also shown, so you can see the two parts separately.