Microsoft Office Tutorials and References
In Depth Information
Figure 12-11: The XNPV function works with irregular cash flows.
This book's website contains the workbook irregular cash flows.xlsx, which contains all
the examples in this section.
The formula in cell B17 is
Similar to NPV, the result of XNPV can be checked by duplicating the cash flows and netting the result with the
first cash flow. The XNPV of the revised cash flows will be zero.