Functions Reference

FILEMAKER FUNCTIONS REFERENCE 72
“Your payment will be ” & PMT(150000;.13/12;Months) & “.” returns Your payment
will be, followed by the payment amount, based on a total cost of $150,000, at a 13 percent annual
percentage rate, over the duration stored in Months.
Related topics
Contents
Functions reference (alphabetical list)
PV
Purpose
Returns the present value (PV) of a series of equal payments made at regular intervals (periods),
assuming a fixed
interestRate per interval.
Format
PV(payment;interestRate;periods)
Parameters
payment - payment amount to be made per period. Type a negative number for money you pay and
a positive number for money you receive.
interestRate - interest rate per period.
periods - number of periods (intervals between payments).
Data type returned
number
Originated in
FileMaker Pro 6.0 or earlier
Description
Use this function to calculate PV.
Note When interestRate is 0, this function returns the result of payment * periods.
Examples
Your cousin borrowed $2,000 from you, offering to pay you back $500 a year for five years, for a
total of $2,500 at the end of five years. If inflation was 5 percent annually, with the following entry
you could find out what those payments are worth with the
PV function.
PV(500;.05;5) returns 2164.73833531....
If you want the return value to return two decimal places, enclose the formula with the correct Round
function: Round(Current Formula;2).
PV payment *
1 1 interestRate+–
periods–
interestRate
------------------------------------------------------------------------------
=