Parameter List
Syntax
FV(rate, number_of_periods, payment_amount, present_value,
[end_or_beginning]
)rate
The interest rate. For example: 2%.
number_of_periods
The number of payments to be made. For example: 12.
payment_amount
The amount per period to be paid. For example: 100. If payment_amount is omitted, you must include the present_value argument.
present_value
The current value of the annuity. For example: 400. If present_value is omitted, it is assumed to be 0 (zero), and you must include the payment_value argument.
[optional] end_or_beginning
Whether the payments are due at the end (0) or beginning (1) of each period. For example: 0 or 1. The default type is 0.