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 enter first for XNPV?
Enter the discount rate and dated cash flows first. Keep valuation date and cash-flow timing consistent before comparing present values.
Why can XNPV results differ from nearby tools?
Differences usually come from discount rate, valuation date, cash-flow timing, and sign convention. Match those assumptions before comparing this result with another CalcBE page, spreadsheet, or external tool.