© Mark Conway Munro 2017

Mark Conway Munro, Learn FileMaker Pro 16, https://doi.org/10.1007/978-1-4842-2863-0_20

20. Financial and Trigonometric Functions

Mark Conway Munro

(1)Lewisburg, Pennsylvania, USA

These two categories of functions handle financial and advanced mathematical calculations.

Financial Function Reference

Financial functions are used to calculate financial results for investment and interest payments. FileMaker provides the following built-in financial functions:

  • FV

  • NPV

  • PMT

  • PV


The FV function returns the future value of an investment, based on a fixed interest rate and payment amount for a specified period of months.


FV ( payment ; interestRate ; periods )


payment = a number indicating the amount ...

Get Learn FileMaker Pro 16: The Comprehensive Guide to Building Custom Databases now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.