XNPV

XNPV(arg1, arg2, arg3) → { number | string | boolean }

Returns the net present value for a schedule of cash flows.

Parameters:

Name Type Description
arg1 any

Is the discount rate to apply to the cash flows.

arg2 any

Is a series of cash flows that correspond to a schedule of payments in dates.

arg3 any

Is a schedule of payment dates that corresponds to the cash flow payments.

Returns:

Type
number | string | boolean