NET PRESENT VALUE

NPV Calculator

Discount equal end-of-year project cash flows and subtract the time-zero investment to get net present value.

Enter your values

Discount the annual cash flows, then subtract the outlay

Net present value puts a time-zero investment and a stream of equal end-of-year cash flows on the same footing. Each future amount is discounted at the required return you enter. A positive NPV adds value at that hurdle rate under these assumptions. Present value discounts a lump or an ordinary annuity without subtracting an investment. XIRR uses dated irregular amounts. ROI is an undiscounted profit-to-cost ratio.

Present value of annual cash flows = annual cash flow × (1 − (1 + r)−n) ÷ r
At 0%, present value = cash flow × years
NPV = present value of annual cash flows − initial investment
Profitability index = present value of annual cash flows ÷ initial investment

Example

A $100,000 project that returns $30,000 a year for 5 years at a 10% discount rate has about $113,724 of future-cash-flow present value and an NPV of about $13,724. The profitability index is about 1.14. At 0% the NPV is the undiscounted $50,000 surplus.

What this model leaves out

Project life must be a whole number of years. Cash flows are ordinary end-of-year amounts, not monthly or mid-year. Taxes, inflation, residual sale value, and unequal yearly amounts stay outside this equal-period identity. A negative NPV means discounted future cash flows do not recover the initial outlay. The profitability index is conventionally interpreted for a non-negative future stream; when annual cash flow is negative, use the NPV result rather than that ratio.

Frequently asked questions

Is this Excel NPV?

Excel NPV discounts the future values you pass in and does not include year 0. Add the initial investment separately, as this page does.

Can cash flow be negative?

Yes. Equal annual outflows reduce NPV; in that case the displayed profitability index is not a conventional investment-screening ratio.

What is the profitability index?

For a non-negative future stream, it is present value of those cash flows divided by the investment. A value above 1 matches a positive NPV.

How is this different from XIRR?

XIRR solves a dated irregular stream. This page discounts equal annual amounts at a rate you already know.

More calculators

Calculations run in your browser. Values are not uploaded or stored.