Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual
Product codes
TJ083LL/A
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.
You can calculate the result using the NPV function.
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.
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).
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.
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.
NPV
loan amount
1 interestRate
+
--------------------------------------
first payment
1 interestRate
+
(
)
2
---------------------------------------------
second payment
1 interestRate
+
(
)
3
---------------------------------------------
…
n
th
payment
1 interestRate
+
(
)
n 1
+
----------------------------------------------------
+
+
+
+
=
PMT
payment
1
1 interestRate
+
(
)
–
periods
–
interestRate
--------------------------------------------------------------------
⎝
⎠
⎛
⎞
⁄
=