Manuals/calci/XNPV

Revision as of 07:30, 27 February 2014 by Abin (talk | contribs) (→‎Description)
XNPV(Rate,V,Dates)


  • is the discount rate to apply to the cash flows
  • is a series of cash flows that corresponds to a schedule of payments in 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:

  where:

  •   = the   payment date,
  •   = the   payment date
  •   = the   payment.

Examples

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

See Also

References