Functions Reference

FILEMAKER FUNCTIONS REFERENCE 63
Examples
FV(50;.11/12;5 * 12) returns 3975.90398429....
FV(2000;.12;30) + 5000 * (.12 + 1) ^ 30 returns 632464.97928640....
FV(500;.11/5;60) returns 61141.65130790....
To set the decimal precision of the returned value, enclose the current formulas with the Round
function. For example,
Round(Current Formula;2).
Related topics
Contents
Functions reference (alphabetical list)
NPV
Purpose
Returns the net present value (NPV) of a series of unequal payments made at regular intervals,
assuming a fixed
interestRate 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.
FV payment *
1 interestRate+()
periods
1–
interestRate
-----------------------------------------------------------------------------
=
NPV
loan amount
1 interestRate+
--------------------------------------------
first payment
1 interestRate+()
2
--------------------------------------------------- -
second payment
1 interestRate+()
3
--------------------------------------------------- -
…
n
th
payment
1 interestRate+()
n1+
------------------------------------------------------------
++++=