Download Filemaker Pro 8.5 Retail

Transcript
Chapter 6
|
Financial functions
61
interestRate - interest rate.
Data type returned
number
Description
Returns the net present value of a series of unequal payments made at regular intervals,
assuming a fixed interestRate per interval. For example, suppose someone borrows
money from you and pays you back in unequal amounts over a period of several years.
You can calculate the result using the NPV function.
loan amount - + -------------------------------------------first payment - + -------------------------------------------second payment - + … + ---------------------------------------------------n th payment
NPV = ------------------------------------1 + interestRate ( 1 + interestRate ) 2 ( 1 + interestRate ) 3
( 1 + interestRate ) n + 1
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).
PMT
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
Description
Returns the payment required to meet the requirements of the term, interestRate,
and principal you supply.
1 – ( 1 + interestRate )
PMT = payment ⁄ ⎛⎝ --------------------------------------------------------------------⎞⎠
interestRate
– periods