FV
Definition of FV
Calculates the future value of an annuity investment based on constantamount periodic payments and a constant interest rate.
Sample Usage
FV(2,12,100,400)
FV(A2,B2,C2,D2,1)
Syntax
FV(rate, number_of_periods, payment_per_period, present_value, [end_or_beginning])
rate
 The interest rate.number_of_periods
 The number of payments to be made.payment_amount
 The amount per period to be paid.present_value
 The current value of the annuity.end_or_beginning
 [ OPTIONAL 0
by default ]  Whether payments are due at the end (0
) or beginning (1
) of each period.
Notes
 Ensure that consistent units are used for
rate
,number_of_periods
, andpayment_per_period
. For example, a car loan for 36 months may be paid monthly, in which case the annual percentage rate should be divided by 12 and the number of payments is 36. On the other hand, a different type of loan of the same length might be paid quarterly, in which case the annual percentage rate should be divided by 4 and the number of payments would be 12.
See Also
PV
: Calculates the present value of an annuity investment based on constantamount periodic payments and a constant interest rate.
PPMT
: Calculates the payment on the principal of an investment based on constantamount periodic payments and a constant interest rate.
PMT
: Calculates the periodic payment for an annuity investment based on constantamount periodic payments and a constant interest rate.
NPER
: Calculates the number of payment periods for an investment based on constantamount periodic payments and a constant interest rate.
IPMT
: Calculates the payment on interest for an investment based on constantamount periodic payments and a constant interest rate.
FVSCHEDULE
: Calculates the future value of some principal based on a specified series of potentially varying interest rates.
To use the FV Formula, simply begin with your edited Excellentable:
Then begin typing the FV formula in the area you would like to display the outcome:
By adding the values you would like to calculate, Excellentable generates the outcome:
A

B

C



1


2


3


4


5


6

D

E



1


2


3


4


5


6
