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.

Equation:

XNPV

Lets see an example,

XNPV(R, V, dates)

B C

-10000 02-01-2009

3000 04-01-2009

4300 11-30-2009

3250 03-15-2010

2200 05-01-2010

?UNIQ4279e6deca12de8c-nowiki-00000002-QINU? is 2069.5268 '

---

Syntax

---

Remarks

---

Examples

---

Description

---

	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

File:Calci1.gif

---