Functions Reference

54 FileMaker Functions Reference
Notes
• When interestRate is 0, this function returns the result of payment * periods.
• The FV function doesn’t account for the present value of your investment, and it
assumes that payment is made at the end of each period.
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).
NPV
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
Description
Returns the net present value of a series of unequal payments made at regular intervals,
assuming a fixed interestRate per interval. For example, suppose someone borrows
money from you and pays you back in unequal amounts over a period of several years.
You can calculate the result using the NPV function.
Φς παψμεντ ∗
1 ιντερεστΡατε+()
περιοδσ
1–
ιντερεστΡατε
---------------------------------------------------------------------------- -
=
ΝΠς
λοαν αμουντ
1 ιντερεστΡατε+
--------------------------------------------
φιρστ παψμεντ
1 ιντερεστΡατε+()
2
---------------------------------------------------
σεχονδ παψμεντ
1 ιντερεστΡατε+()
3
--------------------------------------------------- …
ν
τη
παψμεντ
1 ιντερεστΡατε+()
ν1+
---------------------------------------------------------- -++++=