Functions Reference

FILEMAKER FUNCTIONS REFERENCE 71
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 16758.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, surround the current formulas with the
correct
Round function: Round(Current Formula;2).
Related topics
Contents
Functions reference (alphabetical list)
PMT
Purpose
Returns the payment (PMT) required by the term, interestRate, and principal.
Format
PMT(principal;interestRate;term)
Parameters
principal - principal amount.
interestRate - interest rate. If the interest rate is annual, divide the rate by 12.
term - length of time, expressed in number of months.
Data type returned
number
Originated in
FileMaker Pro 6.0 or earlier
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.
PMT payment
1 1 interestRate+–
periods–
interestRate
------------------------------------------------------------------------------


=