How to Calculate NPV in Excel: NPV and XNPV With Examples
- Tahir Abbas
- November 18, 2026
Net present value, or NPV, tells you whether an investment is worth making by converting all future cash flows into today’s money and subtracting the cost. A positive NPV means the project earns more than your required return, and a negative NPV means it earns less. Excel has the NPV function for regular yearly or

