Filemaker Pro 8.5 Advanced Maintenance TG762Z/A 사용자 설명서
제품 코드
TG762Z/A
60 FileMaker Functions Reference
FV
Format
FV(payment;interestRate;periods)
Parameters
payment - payment to be made per period
interestRate - interest rate per period
periods - number of periods
interestRate - interest rate per period
periods - number of periods
Data type returned
number
Description
Returns the future value of an initial investment, based on a constant interestRate and
payment amount for the number of periods in months. For example, you can calculate
payment amount for the number of periods in months. For example, you can calculate
how much you’ll earn on an investment in which you pay $50 a month for 60 months at a
6 percent annual interest rate.
6 percent annual interest rate.
Notes
•
When interestRate is 0, this function returns the result of payment * periods.
•
The FV function doesn’t account for the present value of your investment, and it
assumes that payment is made at the end of each period.
Examples
FV(50;.11/12;5 * 12) returns
3975.90398429...
.
FV(2000;.12;30) + 5000 * (.12 + 1) ^ 30 returns
632464.97928640...
.
FV(500;.11/5;60) returns
61141.65130790...
.
To set the decimal precision of the returned value, enclose the current formulas with the
Round function. For example, Round(Current Formula;2).
Round function. For example, Round(Current Formula;2).
NPV
Format
NPV(payment;interestRate)
Parameters
payment - a
containing unequal payment amounts, or an
returns a reference to one.
FV
payment *
1 interestRate
+
(
)
periods
1
–
interestRate
--------------------------------------------------------------------
=