Help

FILEMAKER PRO HELP 725
Description
Use this function to calculate PMT.
Examples
In the following example, the PMT function calculates payments for purchasing a sports car costing
$21,000, at an annual rate of 6.9% over 48 monthly payments.
PMT(21000;.069/12;48) returns the payment amount $501.90.
PMT(Cost;.13;Years) returns a payment amount, based on the purchase value stored in Cost,
at a 13 percent rate, over the duration stored in Years.
“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
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
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
PMT payment
1 1 interestRate+()–
periods–
interestRate
------------------------------------------------------------------------------
⎝⎠
⎛⎞
⁄=