writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 6:
Line 6: − + − + − + − + − + − <math>\sum_{i=1}^N\dfrac{P_i}{(1+rate)^\tfrac{(date_i-date_0)}{365}}=0</math>+
→Description
==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:
XNPV
XNPV