XNPV

Scripting Formulas Finance

FINANCE.XNPV

FINANCE.XNPV(rate, amounts..., dates...)

Calculates the net present value for a schedule of cash flows. The amounts and dates parameters must be the same length.

The first amount should correspond to the first date, and so on.

  • rate: Discount rate of the investment over one period.

  • amounts: List of the income or payments for the investment.

  • dates: List of the dates corresponding to the income or payment amounts.

    FINANCE.XNPV(0.1, amount1, amount2, amount3, date1, date2, date3)