Extended Net Present Value (XNPV) Calculator
Calculate the net present value of investments and returns occurring at irregular date intervals, adjusted for a given annual discount rate.
Enter your discount rate and flows on the left to calculate.
Understanding XNPV (Extended Net Present Value)
The XNPV calculation is a financial metric used to estimate the value of an asset or investment project today, based on future cash flows occurring on irregular dates. By discounting all cash flows back to the date of the first transaction, investors can evaluate whether a series of investments and returns will meet their target rate of return (hurdle rate).
The Mathematical Formula
The Extended Net Present Value is computed using the following equation:
Where:
- Ci = The cash flow amount (Negative for outflows, Positive for inflows).
- di = The date of the transaction.
- d1 = The starting date reference point (date of the first transaction).
- r = The annual discount rate (hurdle rate) as a decimal.
Worked Example
Scenario: 1-Year Investment Project at 10% Discount Rate
| Date | Amount ($) | Days from start | Discounted Present Value ($) |
|---|---|---|---|
| 2025-01-01 | -10,000 | 0 Days | -10,000.00 |
| 2025-07-01 | +5,000 | 181 Days | +4,769.41 |
| 2026-01-01 | +7,000 | 365 Days | +6,363.64 |
Adding up the discounted present values: -10,000 + 4,769.41 + 6,363.64 = +$1,133.05. Since the Net Present Value is positive, the project generates returns above your 10% hurdle rate.