NPV directly measures the dollar value an investment creates — not a percentage, not a payback time, but actual currency value added. It correctly handles any cash flow pattern, properly discounts future dollars to today's value, and gives an unambiguous accept/reject signal. Other metrics like IRR, ROI, or payback period have important roles, but they all have edge cases where they mislead. NPV doesn't. It's the metric every MBA finance class teaches first and every CFO uses last.
NPV Calculator
tune Project Inputs
Upfront cost (cash outflow at year 0)
analytics Results
| Yr | CF | PV |
|---|
tips_and_updates Tips
- • Positive NPV → accept the project; negative NPV → reject; zero → indifferent
- • Use your weighted average cost of capital (WACC) as the discount rate for company projects
- • For personal investments, use your required rate of return or opportunity cost
- • When comparing mutually exclusive projects, pick the one with the highest NPV (not highest IRR)
- • Profitability index > 1 means NPV is positive — useful for ranking when capital is constrained
- • Discounted payback is longer than undiscounted payback because future dollars are worth less
- • NPV is sensitive to the discount rate — try multiple rates to see how robust the decision is
How to Use This Calculator
Enter initial investment
The upfront cost of the project (cash outflow at time 0).
Set discount rate
Your required rate of return — WACC for companies, opportunity cost for individuals.
Enter yearly cash flows
Comma-separated list of expected cash inflows for each year (year 1, year 2, ...).
Read NPV
See the net present value, decision (Accept/Reject), profitability index, and payback periods.
Try different discount rates
NPV is sensitive to the discount rate — try a few scenarios to test how robust your decision is.
The Formula
Each future cash flow is divided by (1+r)^t to convert it to present value — a dollar received in year 5 is worth less than a dollar today because of the time value of money and the opportunity cost of tying up capital. The sum of all present values minus the initial investment is the NPV. If NPV > 0, the project earns more than your discount rate; if NPV < 0, it earns less.
NPV = -Initial + Σ CF_t / (1 + r)^t for t = 1..n
lightbulb Variables Explained
- NPV Net present value (positive = create value)
- Initial Initial investment (cash outflow at t=0)
- CF_t Cash flow in period t
- r Discount rate (cost of capital, decimal)
- t Period number (1, 2, 3, ..., n)
- n Number of periods
tips_and_updates Pro Tips
Positive NPV → accept the project; negative NPV → reject; zero → indifferent
Use your weighted average cost of capital (WACC) as the discount rate for company projects
For personal investments, use your required rate of return or opportunity cost
When comparing mutually exclusive projects, pick the one with the highest NPV (not highest IRR)
Profitability index > 1 means NPV is positive — useful for ranking when capital is constrained
Discounted payback is longer than undiscounted payback because future dollars are worth less
NPV is sensitive to the discount rate — try multiple rates to see how robust the decision is
The biggest decision you'll make in NPV analysis isn't the cash flow estimates — it's the discount rate. A small change in rate (10% → 12%) can flip a positive NPV to negative. Always document your discount rate assumption and run sensitivity analysis with at least three rates: optimistic (low), base case, and pessimistic (high). If NPV stays positive across all three, the project is robust. If it flips, you need better cash flow estimates or a different project.
Frequently Asked Questions
Related Tools
View all Financial View all arrow_forwardTags
Data sourced from trusted institutions
All formulas verified against official standards.