How does the XNPV function (DAX) work?
The XNPV function (DAX) returns the present value for a schedule of cash flows that is not necessarily periodic.
XNPV Formula Syntax
<table>, <values>, <dates>, <rate>
How do you use the XNPV function?
The Excel XNPV function calculates the net present value (NPV) of an investment based on a discount rate and a series of cash flows that occur at irregular intervals. Cash flows need to be listed with dates in chronological order. Negative values represent cash paid out; positive values represent cash received
Related Blog Posts
Related Support Forum Posts
Considerations when using the XNPV function
- Rate is provided as a percentage (.12 for 12%)
- Dates and values must be in chronological order.
- Dates must be valid Excel dates
- XNPV doesn’t discount the initial cash flow
Related Video Tutorials
Formula examples using the XNPV function
Present value := XNPV( CashFlows, [Payment], [Date], 0.09 )
=XNPV(.09, A2:A6, B2:B6)
Related Course Modules
To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.