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

	A	B
1	-12000	02-01-2009
2	3000	04-01-2009
3	4300	11-30-2009
4	3250	03-15-2010
5	2200	5-1-2010

=XNPV(0.95,A1:A5,B1:B5)= -4330.389965454265