Changes

Jump to navigation Jump to search
91 bytes added ,  12:25, 27 February 2014
Line 6: Line 6:  
==Description==
 
==Description==
 
*This function computes the net present value for a schedule of cash flows that is not essentially periodic.  
 
*This function computes the net present value for a schedule of cash flows that is not essentially periodic.  
*The arguments should be numerics.
+
*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 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:  
 
*XNPV is calculated as follows:  
 
+
<math>\sum_{i=1}^N\dfrac{P_i}{(1+rate)^\tfrac{(date_i-date_0)}{365}}=0</math>
 
where:
 
where:
*di = the ith payment date,
+
*<math>d_i</math> = the <math>i^{th}</math> payment date,
*d1 = the 0th payment date  
+
*<math>d_0</math> = the <math>0^{th}</math> payment date  
*Pi = the ith payment.
+
*<math>P_i</math> = the <math>i^{th}</math> payment.
 
Equation:
 
Equation:
<math>\sum_{i=1}^N\dfrac{P_i}{(1+rate)^\tfrac{(date_i-date_0)}{365}}=0</math>
+
 
    
XNPV
 
XNPV
writer
5,435

edits

Navigation menu