Use the XNPV and XIRR functions for cash flows that appear _______.
A)with a regular pattern
B)at unevenly spaced intervals
C)at evenly spaced intervals
D)to be cyclical

Question

Quizplus · Accepted Answer

XNPV and XIRR functions are used for cash flows that appear at unevenly spaced intervals. XNPV calculates the net present value of cash flows that occur at irregular intervals, while XIRR returns the internal rate of return for a series of cash flows at uneven intervals.

Use the XNPV and XIRR Functions for Cash Flows That