How to use Net Present Value Calculator
- Enter one cash flow per line, starting with time zero.
- Set a discount rate for one interval between flows.
- Review the present-value table and the summed NPV.
Example: Net Present Value Calculator
Cash flows -1000, 400, 400, 400 at periods 0 to 3; discount rate 10% per period.
You add
Cash flows -1000, 400, 400, 400 at periods 0 to 3; discount rate 10% per period.
You get
NPV rounds to -5.26.
Supported inputs and limits
1 to 1,201 signed cash flows, one per equal period. The first is not discounted. Rate must be greater than -100% and at most 1,000% per period. Irregular dates and internal rate of return are not modeled. Enter plain decimals with at most 64 characters, 25 digits and 12 fractional places. Monetary inputs are limited to 10^12. Very small or large nonzero amounts use scientific notation. Use one currency throughout; no exchange rates, taxes or fees are added unless you enter them.
Where your input is processed
This tool processes your input in this browser. Your text and files are not uploaded to UseFreeTools. Check this tool's limits for anything it may save on your device.
Use the same period throughout
Each flow at period t is divided by (1 + rate)^t. The sum includes positive receipts and negative payments, with no implicit initial outlay.
Questions about Net Present Value Calculator
Is the first cash flow discounted?
No. Line one is period zero. The next line is discounted for one period, and so on.
Should I enter an annual discount rate?
Only if each interval is a year. Match the rate to the actual interval between your entered flows.
Does a positive result guarantee a good investment?
No. NPV follows the entered cash flows and discount assumption. It does not assess risk or whether those amounts will occur.