# NPV

Returns the net present value (NPV) of a series of unequal payments made at regular intervals, assuming a fixed interest rate per interval.

`NPV(payment;interestRate)`

## Parameters

`payment`

- a repeating field containing unequal payment amounts, or an expression that returns a reference to one.

`interestRate`

- interest rate.

## Data type returned

number

## Originated in

FileMaker Pro 6.0 or earlier

## Description

Use this function to calculate NPV. For example, if someone borrows money from you and pays you back in unequal amounts over a period of several years, you can use the NPV function to calculate the result.

## Example 1

`NPV(Loan;.05)`

returns **156.91277445...**, when the repeating field, Loan, contains -2000 (the initial payment), 600, 300, 500, 700, and 400. The result (156.91277445...) is the actual profit in today’s dollars that will be realized from this transaction.

## Example 2

`NPV(Amounts;.10)`

returns **16758.35604870...**, when the repeating field, Amounts, contains -5000 (the initial investment), 10,000, 0, 10,000, and 10,000.

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas