Syntax. XNPV(Rate,Values,Dates)

Definition. This function returns the capital value for a series of not-necessarily periodic surpluses (as the difference between deposits and disbursements) in the intra-annual scope.


  • Rate (required) The annual interest rate for the calculation. This can be a balance interest rate, an interest rate on a current account, or a market interest rate—whatever best defines the initial situation.

  • Values (required) The (actual and/or expected) surpluses from disbursements and deposits, arranged without gaps in a column. Each value stands for a date. Negative surpluses have a minus sign.

  • Dates (required) The dates for the surpluses. The order must correspond to the payments in the Values argument. The first ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.