Manuals/calci/XNPV

XNPV(Rate,V,Dates)

• $Rate$ is the discount rate to apply to the cash flows
• $V$ is a series of cash flows that corresponds to a schedule of payments in dates
• $Dates$ is a schedule of payment dates.

Description

• This function computes the net present value for a schedule of cash flows that is not essentially periodic.
• The arguments should be numeric's.
• XNPV shows the error value whenever any number in dates precedes the starting date or values and dates contain a different number of values.
• XNPV is calculated as follows:

$\sum _{i=1}^{N}{\dfrac {P_{i}}{(1+rate)^{\tfrac {(date_{i}-date_{0})}{365}}}}=0$ where:

• $d_{i}$ = the $i^{th}$ payment date,
• $d_{0}$ = the $0^{th}$ payment date
• $P_{i}$ = the $i^{th}$ payment.

Examples

	Column1	Column2	Column3	Column4
Row1	-10000	02-01-2009	2069.5268
Row2	3000	04-01-2009
Row3	4300	11-30-2009
Row4	3250	03-15-2010
Row5	2200	05-01-2010
Row6
Row7