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) none of the above

Question

Quizplus · Accepted Answer

XNPV and XIRR functions are specifically designed to handle unevenly spaced cash flows. For cash flows that appear with a regular or evenly spaced pattern, other functions such as NPV and IRR are more appropriate.

Use the XNPV and XIRR Functions for Cash Flows That