Fnpv()

Description:

The function equals the Excel NPV function.

Syntax:

Fnpv(rate,values)

Equivalent to Excel NPV function

Fnpv(rate,values,dates)

Equivalent to Excel XNPV function

Note:

The function returns the net present value of an investment, based on the discount rate and a series of future payments (negative value) and income (positive value). The net present value is the difference between the present value of future cash inflows and outflows from an investment and the amount of investment.

Parameters:

rate

The discount rate over one period (which is equal to inflation rate and the rate of competitive investment); it is a fixed value.

values

A sequence of values representing payments and incomes that must occur at regular time interval and at the end of each period.

dates

A sequence of dates corresponding to the array of cash payments. The first date of payment denotes the beginning of the payments for the investment.

Example:

Fnpv(0.11,[-10000,3000,5000,6000])

1034.2010420979072

Fnpv(0.11,[-10000,3000,5000,6000],[date("2008-01-01"),date("2008-05-23"),date("2009-03-10"),date("2009-5-15")])

2497.061973416109