How To Use
- Enter annual discount rate (%).
- Enter dated cash flows (CSV/TSV paste supported).
- Check XNPV, base date, and discounted totals.
Use negative values for outflows and positive values for inflows.
Inputs
Result
Discounted cash-flow table
| Date | Amount | Discounted amount | Note |
|---|
FAQ
How is the base date selected in XNPV?
The earliest date in your cash-flow table is used as the base date.
What is the difference between NPV and XNPV?
XNPV supports irregular dates. Standard NPV assumes equal period spacing.
Which discount rate should I use?
Use your decision benchmark such as required return, hurdle rate, or cost of capital.
What should I do first on this page?
Start with the minimum required inputs or the first action shown near the primary button. Keep optional settings at defaults for a baseline run, then change one setting at a time so you can explain what caused each output change.
Why does this page differ from another tool?
Different pages often use different defaults, units, rounding rules, or assumptions. Align those settings before comparing outputs. If differences remain, compare each intermediate step rather than only the final number.