Values Required.A series of cash flows that corresponds to a schedule of payments in dates. The first payment is optional and corresponds to a cost or payment that occurs at the beginning of the investment.

Dates Required.A schedule of payment dates that corresponds to the cash flow payments. Dates may occur in any order. Dates should be entered by using the DATE function, or as results of other formulas or functions.

本文介绍 Microsoft Excel 中 XNPV 函数的公式语法和用法。. 说明. 返回一组现金流的净现值，这些现金流不一定定期发生。 若要计算一组定期现金流的净现值，请使用函数 NPV。