Net Present Value (NPV) Calculator Guide
Use this net present value calculator to calculate NPV, present value of cash flows, IRR, profitability index, payback period, and discount-rate sensitivity for an investment project.
How to use the NPV calculator
Enter the project name, discount rate, initial investment, and expected cash flow for each year. The calculator discounts each future cash flow, subtracts the initial investment, and shows whether the project creates value at the selected rate.
Use cash flows after operating expenses and taxes when possible. If a project has uneven annual cash flows, enter each year separately so the present value calculation reflects the actual timing.
Net present value formula
The NPV formula is: NPV = sum of CFt / (1 + r)^t - Initial Investment. CFt is the cash flow in each period, r is the discount rate, and t is the period number.
A positive NPV means the projected cash flows are worth more than the initial investment after discounting. A negative NPV means the project may not meet the required return at the selected discount rate.
How to interpret NPV results
When NPV is above zero, the project is usually considered acceptable because it is expected to add value. When NPV is below zero, the project may destroy value unless there are strategic reasons to proceed.
This calculator also shows IRR, profitability index, and payback period. These metrics help explain the result, but NPV is often the strongest project decision metric because it estimates value in dollars.
NPV vs IRR and payback period
IRR estimates the discount rate where NPV equals zero. It is useful as a percentage return, but it can be misleading when cash flows are unusual or when comparing projects of different sizes.
Payback period shows how long it takes to recover the initial investment. It is simple and useful for risk screening, but it can ignore the value of cash flows after payback.
Common NPV calculator mistakes
The most common mistake is using revenue instead of cash flow. NPV should use expected cash flows after relevant costs, taxes, and working capital changes when those apply.
Another mistake is using a discount rate that does not match project risk. A riskier project usually needs a higher discount rate than a stable, low-risk investment.
- Use cash flow, not sales revenue alone.
- Match the discount rate to project risk and cost of capital.
- Enter cash flows in the correct year or period.
- Include terminal value only when it is realistic.
- Compare mutually exclusive projects with NPV, not only IRR.