XNPV

Investment net present value

Description

Calculates an investment's net present value, using a series of cash flows that are potentially irregular.

Function signature

XNPV(discount: Number, сashflowamounts: Array, сashflowdates: Array) => Number

Parameter

Description

Discount

The discount rate of the investment over one period.

Сashflow amounts

A range of cells containing the income or payments associated with the investment.

Сashflow dates

A range of cells with dates corresponding to the cash flows in сashflow amounts

Examples

cash1 = [1,2,3,4,5]
dates1 = [
"2019-07-11T13:06:15+03:00",
"2019-07-12T13:06:15+03:00",
"2019-07-13T13:06:15+03:00",
"2019-07-14T13:06:15+03:00",
"2019-07-15T13:06:15+03:00"
]
cashSmall = [1,2,3]
datesSmall = [
"2019-07-11T13:06:15+03:00",
"2019-07-12T13:06:15+03:00",
"2019-07-13T13:06:15+03:00"
]

Formula

Return value

XNPV(1, cash1, dates1)

14.92427256

XNPV(2, cash1, dates1)

14.88019094

XNPV(1, cashSmall, datesSmall)

5.984832948