Calculator explainer
NPV Calculator Explained: Formula, Worked Example & Free Tool
Net present value (NPV) measures whether an investment creates value after you translate all future cash flows into today's dollars using a discount rate. Positive NPV usually means accept the project; negative NPV means the return does not cover your required hurdle rate.
Formula in plain language
Add up each future cash flow divided by (1 + discount rate) raised to the year number, then subtract the upfront investment.
Worked example
Equipment upgrade with five-year cash flows
- Initial cost (Year 0): $250,000 outflow.
- Annual net cash savings: $80,000 in Years 1–5.
- Discount rate (WACC / hurdle): 12% (r = 0.12).
- Year 1 PV: $80,000 ÷ 1.12 = $71,429; Year 2: $63,776; Year 3: $56,943; Year 4: $50,842; Year 5: $45,395.
- Sum of discounted inflows ≈ $288,385. Subtract $250,000 initial investment.
NPV ≈ $38,385 — the upgrade clears a 12% hurdle and generally should be accepted if assumptions hold.
Try the calculator
Open full toolNet Present Value (NPV) Calculator
Templates
Save and load common input configurations
No templates saved yet
Save your current inputs as a template to reuse later
NPV Calculator
Calculate the net present value of an investment to determine its profitability
Compare Calculations
Save at least 2 calculations to use the comparison feature
Need shareable exports for lenders?
Pro saves scenarios and exports PDF and Excel built for bankers and buyers.
Related tools
- IRR Calculator
Cross-check return when NPV is borderline.
- DCF Calculator
Build enterprise value from discounted cash flows.
- Payback Period
See how fast cash recovers the investment.
- Acquisition calculator pack
Model SBA deals with NPV, DSCR, and seller notes.
- WGU D775 NPV topic
Introductory capital budgeting walkthrough with worked arithmetic.
Frequently asked questions
What does a positive NPV mean?
A positive NPV means discounted cash inflows exceed the initial investment at your chosen discount rate. The project is expected to add economic value relative to your required return.
What discount rate should I use for NPV?
Use WACC for firm-wide projects, a risk-adjusted equity hurdle for acquisitions (often 15–25% for small businesses), or the opportunity cost if capital is scarce.
Can NPV and IRR disagree?
Yes, when cash flows are non-conventional or projects differ in scale. NPV is generally the tie-breaker because it reflects absolute dollar value created.
Is the MBACalc NPV calculator free?
You can run calculations free in the browser. MBACalc Pro adds saved scenarios and shareable PDF and Excel exports for lender conversations.