Syntax: PMT ( principal; interestRate; term )
principalA number (or numeric expression) representing the initial amount borrowed.
interestRateA decimal number (or numeric expression), representing the monthly interest rate used to amortize the principal amount. Given an annual interest rate, you can divide by 12 to get the monthly interest rate.
termA number (or numeric expression) representing the period of loan, expressed in months.
Data type returned: Number
Returns the monthly payment that would be required to pay off the principal based on the interestRate and term specified.
The PMT calculation makes it easy to see the effect of interest rates on the monthly payment of an installment loan. For instance, buying a $20,000 car at 6.9% for 48 months would require a $478.00 monthly payment, but at 3.9%, the payment would be $450.68.
Someone borrows $1,000 from you, and you want to set up a payment schedule whereby the loan is paid off in 2 years at an interest rate of 6%. To determine the monthly payment,
PMT (1000; .06/12; 24)
: FileMaker Specifications
FileMaker 8 Product Line
Specifications and Storage Limits
Field Types and Import/Export Formats
: Calculation Functions
Working with Calculations Primer
: Custom Functions
Custom Functions Primer
Useful Custom Functions
: Script Steps
Script Step Reference
: Quick Reference
FileMaker Error Codes
FileMaker Keyboard Shortcuts
FileMaker Network Ports
FileMaker Server Command Line Reference
FileMaker XML Reference
: Other Resources
Where to Go for More Information