Excel Magic Trick 1430

DAX Functions XNPV & XIRR for Irregular Cash Flow Net Present Value & IRR

DESCRIPTION

See how to use the DAX Functions XNPV and XIRR to calculate the Net Present Value and Internal Rate of Return of Cash Flows that occur at irregular date intervals.

WORKBOOKS

Download “Excel Magic Trick 1427-1430.zip” Excel-Magic-Trick-1427-1430.zip – Downloaded 26 times – 1 MB







Be the first to comment

Leave a Reply