Difference between revisions of "Manuals/calci/XNPV"

Latest revision as of 16:05, 27 July 2018

XNPV (Rate,CashFlowValues,Dates)

$Rate$ is the discount rate to apply to the cash flows
$CashFlowValues$ is a series of cash flows that corresponds to a schedule of payments in dates
is a schedule of payment dates.
- XNPV(), returns the net present value for a schedule of cash flows that is not necessarily periodic.

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:

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

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''XNPV(Rate,V,Dates)'''</div><br/>
+<div style="font-size:30px">'''XNPV (Rate,CashFlowValues,Dates) '''</div><br/>
 *<math>Rate</math> is the discount rate to apply to the cash flows
-*<math>V</math> is a series of cash flows that corresponds to a schedule of payments in dates
+*<math>CashFlowValues</math> is a series of cash flows that corresponds to a schedule of payments in dates
 *<math>Dates</math> is a schedule of payment dates.
+**XNPV(), returns the net present value for a schedule of cash flows that is not necessarily periodic.
 ==Description==