# Documentation/Calc Functions/XNPV

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

XNPV

## Category:

Financial Analysis

## Summary:

Calculates the capital value (net present value) for a list of payments which take place on different dates. The calculation is based on a 365 days per year basis, ignoring leap years.

## Syntax:

XNPV(**Rate**; **Values**; **Dates**)

## Returns:

## Arguments:

**Rate** is the internal rate of return for the payments.

**Values** and **Dates** refer to a series of payments and the series of associated date values. The first pair of dates defines the start of the payment plan. All other date values must be later, but need not be in any order. The series of values must contain at least one negative and one positive value (receipts and deposits)

## Additional details:

If the payments take place at regular intervals, use the NPV function.

## Examples:

Calculation of the net present value for the above-mentioned five payments for a national internal rate of return of 6%.

=XNPV(0.06;B1:B5;A1:A5) returns 323.02.