XNPV Function
Calculates net present value for cash flows on specific dates.
Category
Financial
Available in
All versions, Microsoft 365
Returns
A net present value
Overview
XNPV discounts each cash flow by the exact number of days since the first one, using an annual rate. Unlike NPV, the first cash flow is today (not discounted) and the flows can be any distance apart.
It's the standard for deal valuations and real project schedules.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| rate | Yes | The annual discount rate. |
| values | Yes | The cash flows. The first is usually the investment (negative). |
| dates | Yes | The matching dates. The first date is the starting point. |
Examples
Example 1 — Store opening on a real schedule
The same store, with cash arriving on actual dates.
| A | B | |
|---|---|---|
| 1 | Date | Cash flow |
| 2 | 4/1/2026 | -$150,000 |
| 3 | 9/15/2026 | $40,000 |
| 4 | 6/30/2027 | $50,000 |
| 5 | 3/31/2028 | $60,000 |
| 6 | 12/15/2028 | $55,000 |
| 7 | XNPV | $30,129.97 |
Higher than the NPV version because the cash comes in sooner than whole years apart. The 8% is annual — XNPV handles the days.
Common mistakes
- #VALUE! or #NUM!. Values and dates must be the same size, the dates must be real dates, and none can be before the first date.
- Using a monthly rate. XNPV always takes an annual rate.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.