Functions Reference

Financial functions
F
ILEMAKER PRO FUNCTIONS REFERENCE 90
NPV
Purpose
Returns the net present value (NPV) of a series of unequal payments made at regular intervals,
assuming a fixed interest rate per interval.
Format
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.
NPV
loan amount
1 interestRate+
--------------------------------------------
first payment
1 interestRate+()
2
----------------------------------------------------
second payment
1 interestRate+()
3
----------------------------------------------------
…
n
th
payment
1 interestRate+()
n1+
------------------------------------------------------------
++++=
Examples
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.
NPV(Amounts;.10) returns 16
758.35604870..., when the repeating field, Amounts, contains -
5000 (the initial investment), 10,000, 0, 10,000, and 10,000.
If you want each return value to return 2 decimal places, surrou
nd the current formulas with the
correct Round function: Round(Current Formula;2).