Net Present Value Calculator
Discount signed, equally spaced cash flows, including an initial cash flow today.
Formula
NPV = Σ CFt / (1 + rate/100)^t, starting at t = 0.
Discount rate per period (%) = 10
How to use
- Separate flows with semicolons; use minus signs for payments.
- Set a discount rate for one cash-flow period.
- Review NPV and the undiscounted total.
Examples
- −100 now and 110 after one period, discounted at 10%, give NPV 0.
Frequently asked questions
How do I enter decimals?
Use a decimal point and semicolons between flows; omit thousands separators.
When do flows occur?
The first occurs now; all later flows occur at equally spaced period ends.
Does a positive NPV guarantee profit?
No. The result depends on your projected cash flows and discount rate; dates, tax rules and risk are not inferred.
Sources
Updated: