Filemaker TH325Z/A Fiche technique télécharger pdf (Page 62)

62 FileMaker Functions Reference

Examples

In the following example, the PMT function calculates payments for purchasing a sports

car costing $21,000, at an annual rate of 6.9% over 48 monthly payments.

PMT(21000;.069/12;48) returns the payment amount $501.90.

PMT(Cost;.13;Years) returns a payment amount, based on the purchase value

stored in Cost, at a 13 percent rate, over the duration stored in Years.

“Your payment will be “ & PMT(150000;.13/12;Months) & “.” returns Your

payment will be, followed by the payment amount, based on a total cost of $150,000, at

a 13 percent annual percentage rate, over the duration stored in Months.

Format

PV(payment;interestRate;periods)

Parameters

payment - payment amount to be made per period. Type a negative number for money

you pay and a positive number for money you receive.

interestRate - interest rate per period.

periods - number of periods (intervals between payments).

Data type returned

number

Description

Returns the present value of a series of equal payments made at regular intervals

(periods), assuming a fixed interestRate per interval.

Note When interestRate is 0, this function returns the result of payment * periods.

Example

Your cousin borrowed $2,000 from you, offering to pay you back $500 a year for five

years, for a total of $2,500 at the end of five years. If inflation was 5 percent annually, with

the following entry you could find out what those payments are worth with the PV function.

PV(500;.05;5) returns 2164.73833531....

If you want the return value to return two decimal places, enclose the formula with the

correct Round function: Round(Current Formula;2).

PV payment *

1 1 interestRate+()–

periods–

interestRate

--------------------------------------------------------------------

1 2 ... 57 58 59 60 61 62 63 64 65 66 67 ... 237 238

Pas de commentaire

Filemaker TH325Z/A Fiche technique Page 62