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.