Filemaker Pro 8.5 Advanced Maintenance TG761Z/A User Manual

FV(payment;interestRate;periods)

payment - payment to be made per period
interestRate - interest rate per period
periods - number of periods

number

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 

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.

•

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.

FV(50;.11/12;5 * 12) returns 

.

FV(2000;.12;30) + 5000 * (.12 + 1) ^ 30 returns 

.

FV(500;.11/5;60) returns 

.

To set the decimal precision of the returned value, enclose the current formulas with the 
Round function. For example, Round(Current Formula;2).

NPV(payment;interestRate)

payment - a 

 containing unequal payment amounts, or an 

returns a reference to one.

FV

payment * 

1 interestRate

+

(

)

periods

1

–

interestRate

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

=