Quick Answer: Calculate net present value by discounting projected cash flows and terminal value back to today, then subtracting the initial investment.
How This Calculator Works
NPV compares today's investment with the present value of future cash flows. Positive NPV suggests the project exceeds the entered discount-rate hurdle.
Worked Scenario: Scenario: Evaluating a Five-Year Project
A business compares an upfront investment with future cash flows using a required return.
Scenario Inputs
- Initial investment: USD 100,000
- Year 1 cash flow: USD 24,000
- Discount rate: 10%
Outcome: The NPV estimates whether future cash flows justify the investment after discounting for risk and time.
Formula and Methodology
PV cash flow = cash flow / (1 + discount rate)^year
PV terminal value = terminal value / (1 + discount rate)^years
NPV = sum of present values - initial investment
Variables
- Discount rate: Required return or opportunity cost
- Terminal value: Estimated value at the end of the analysis period
Assumptions
- Cash flow grows at a constant entered rate.
- Terminal value is received at the end of the final year.
Limitations
- NPV is highly sensitive to discount rate and terminal value.
- Actual cash flows can differ from projections.
NPV converts future promises into today's value
A future cash flow is not worth the same as cash today because time, risk, inflation, and opportunity cost matter. NPV makes that tradeoff explicit.
The result is only as strong as the cash-flow forecast and discount rate. Sensitivity analysis is not optional for serious decisions.
Key Takeaways
- Positive NPV depends on the selected discount rate.
- Terminal value can dominate the model.
- Use payback and IRR as secondary views, not replacements.
Stress-testing NPV
Run lower cash-flow growth, higher discount rate, and lower terminal value cases. If NPV only works in the optimistic case, the project is fragile.
For strategic projects, also consider non-financial benefits, but keep them separate from the numeric NPV.
- Change one assumption at a time.
- Document the discount rate.
- Review downside cases before approval.
NPV is disciplined skepticism
A positive NPV should come from credible cash flows, not a convenient discount rate or oversized terminal value.
Sources and Verification Notes
- Investor.gov: Investment fee awareness (https://www.investor.gov/introduction-investing/getting-started/understanding-fees)
- U.S. Small Business Administration: Business planning context (https://www.sba.gov/counseling/plan-your-business/)
Related Calculators and Guides
- IRR calculator: Compare implied return.
- Payback calculator: Check capital recovery timing.
Practical FAQs
What does positive NPV mean?
It suggests projected cash flows exceed the required return under the entered assumptions.
What discount rate should I use?
Use a rate that reflects risk, opportunity cost, financing cost, and required return.
Why is terminal value important?
Terminal value can represent sale proceeds or continuing value and can heavily influence NPV.