NPV Calculator
Calculate net present value by discounting future cash flows and adding the initial investment at your chosen hurdle rate.
Enter the initial investment (usually negative), a discount rate, and comma-separated cash flows to measure project NPV.
About Net Present Value
Net present value (NPV) asks whether a project earns more than your required return after the time value of money. The NPV calculator treats the initial investment as a time-zero cash flow—enter it as a negative number for an outflow—and discounts each later cash flow at the stated rate. Period 1 is the first comma-separated amount, period 2 the next, and so on. NPV is the initial amount plus the present value of those future flows. A positive NPV means the discounted inflows exceed the discounted outflows at that rate. For an initial −$10,000, a 10 percent discount rate, and cash flows of 4,000, 4,000, and 5,000, the present value is $10,698.72 and NPV is $698.72. That is a modestly value-creating project at 10 percent. Doubling the initial outlay to −$20,000 with the same inflows produces NPV of −$9,301.28, which destroys value at the same hurdle. Spreadsheet NPV functions sometimes exclude time zero; this calculator expects you to put time zero in the initial-investment field so the sign is explicit. The discount rate should match the risk and the period of the cash flows. Annual flows need an annual rate. Do not discount nominal cash flows at a real rate or the reverse. Uneven timing, mid-year conventions, taxes, inflation, and residual values are not modeled unless you bake them into the cash-flow list. Changing the rate is the cleanest sensitivity: a lower hurdle raises NPV, a higher hurdle can flip a thin project from accept to reject. Use NPV alongside IRR, payback, and a reality check on the cash-flow forecast. A positive NPV on heroic volume assumptions is still a weak decision. The calculator does not solve for IRR or for mutually exclusive project ranking beyond the NPV number itself. Treat the result as a capital-budgeting estimate, not a market valuation of a company.
NPV Calculator Examples
Future cash flows are discounted from period 1; the initial investment is added at time zero.
| Input | Output | Notes |
|---|---|---|
| Initial investment −$10,000; discount rate 10%; cash flows 4000,4000,5000 | Present value $10,698.72; NPV $698.72; periods 3.00 | A three-year project that clears a 10 percent hurdle by a small margin. |
| Initial investment −$20,000 with the same 10% rate and cash flows | Net present value −$9,301.28 | The same inflows cannot support twice the upfront outlay at 10 percent. |
| Initial investment −$10,000; discount rate 8%; cash flows 4000,4000,5000 | Present value $11,102.22; NPV $1,102.22 | A lower hurdle rate increases present value and NPV. |
How to Calculate Net Present Value
- Enter the time-zero investment as a negative number if it is a cash outflow.
- Enter the discount rate that matches the risk and the cash-flow period.
- List future cash flows as comma-separated amounts in chronological order.
- Select Calculate and accept the project only if NPV is positive after you trust the forecast.
NPV Calculator FAQ
Should the initial investment be negative?
Yes, when it is an outflow. NPV adds that time-zero amount to the present value of later flows. A positive initial value would treat time zero as an inflow.
Does this match Excel NPV?
Excel NPV typically discounts the listed range starting at period 1 and does not include time zero. Add the initial investment separately, which is what this calculator does in one step.
What does a negative NPV mean?
At the chosen discount rate, the project earns less than the required return. That is a reject signal unless the cash-flow forecast or the rate is wrong.
Can cash flows be negative?
Yes. Later outflows, such as decommissioning costs, can be entered as negative numbers in the comma-separated list.
Is NPV the same as IRR?
No. IRR is the rate that makes NPV zero. NPV states value created at a chosen hurdle rate and is usually the better rule for accept-or-reject decisions.