NPV Calculator guide
Net present value converts future cash flows into today’s dollars using a required return or discount rate. Positive NPV means modeled returns exceed that entered requirement.
Forecast quality and the chosen discount rate drive the answer; NPV is not a guarantee.
How to use the NPV calculator
- Enter current amounts: Use current, documented values from the same relevant period.
- Enter assumptions: Use realistic rates, percentages, periods, and costs where applicable.
- Review the full result: Review the primary estimate together with its supporting measures.
- Stress-test risk: Model less favorable timing, value, cost, or rate assumptions.
Formula and variables
The estimate applies the entered values and assumptions to the stated formula.
NPV = Σ cash flowₜ ÷ (1 + discount rate)ᵗ- Inputs — Entered values
- The amounts, percentages, or periods supplied to the calculator.
- Result — Calculated output
- The estimate produced by applying the formula to the entered values.
Worked example: NPV calculator
A user enters a representative set of values and assumptions.
- Key inputs
- Amounts, percentages, periods, and costs
- Apply the stated formula.
- Include all relevant entered values and constraints.
- Compare the result with an alternative scenario.
Result: Net present value and profitability index at the entered discount rate.
Use the estimate as a planning input and verify important decisions with current records or qualified guidance.
Understanding your results
Primary estimate
Net present value and profitability index at the entered discount rate.
Risk measures
Use supporting payment, leverage, cost, and cash figures together.
Assumptions
- Entered rates and costs remain constant.
- Payments and cash flows occur on schedule.
Limitations
- Taxes, legal terms, accounting treatment, and transaction-specific costs may differ.
- Future values, timing, and rates are uncertain.
Common mistakes
- Reviewing only the headline result.
- Ignoring relevant costs, timing, or supporting measures.
- Using optimistic timing or value assumptions.
- Treating an estimate as a guaranteed outcome.
Practical use cases
Compare scenarios consistently
Change one assumption at a time or enter each alternative using the same basis.
Plan cash requirements
Estimate funds needed before committing.
Planning and decision guide
Stress-test the assumptions
Use after-tax incremental cash flows and include working capital, maintenance, and terminal value where appropriate.
Review the important risks
Stress-test the discount rate and forecast rather than relying on one result.
Verify the source values
Compare mutually exclusive projects with scale, constraints, and strategic risks in mind.
Frequently asked questions
What does positive NPV mean?
Modeled discounted inflows exceed outflows at the entered required return.
What discount rate should I use?
Use a rate reflecting opportunity cost, financing, and project risk.
Is period 0 discounted?
No. Period 0 represents present value already.
How is NPV different from ROI?
NPV explicitly accounts for cash-flow timing and required return.
Sources and review
- Capital budgeting — Federal Deposit Insurance Corporation. Accessed 2026-07-10.
Reviewed 2026-07-10.