U.M. (Mac OS)

Summary of functions C-13
Financial functions
Keep these points in mind:
1 Term is expressed in months
1 Interest rate is a value from 0.0 to 1.0, divided by 12 (months).
Trigonometric functions
Syntax Definition
FV (payment, interest rate, periods) Returns the future value of an investment based on
interest rate and payment for periods
NPV (payment, interest rate) Returns net present value of a series of unequal
payments (in a repeating field) made at regular
intervals using a fixed interest rate (in a number
field) per interval. (When payments contains equal
values, use the PV function.)
PMT (principal, interest rate, term) Returns the payment needed to meet the
requirements of principal, interest rate, term
PV (payment, interest rate, periods) Returns the present value of equal payments made
at regular periods, assuming a fixed interest rate
per payment
Choose FileMaker Help Index from the or Help menu, and then type:
E financial functions
Syntax Definition
Atan (number) Returns the trigonometric arc (inverse) tangent of
number. The arc tangent is the angle, in radians,
whose tangent equals number.
Cos (number) Returns the cosine of the angle (in radians) of
number
Degrees (number) Converts number from radians to degrees
(π/180 radians)
Ln (number) Returns the base-e (natural) logarithm of number
Log (number) Returns the common logarithm (base 10) of number,
which is any positive value
PI Returns the value of pi (π), approximately 3.14159