Whether an investment earns more than your required return, in today's money.
Your figures
Keep units consistent: kg with kg, minutes with minutes. Results update as you type.
Net present value
—
Present value of the cash flows
—
Profitability index
—
Formula
Sum of each year's cash flow ÷ (1 + rate)^year, minus the investment
=NPV(B2/100,D2:D11)-C2Excel: B2 discount rate; C2 investment; yearly cash flows down column D
Above zero, the investment earns more than the discount rate; below zero, less.
Save this calculation
Enter your figures (or try the worked example) to save them.
General calculation. Confirm your site's own definitions, validated limits and specifications before using a result for process control or product release.