|
<< Click to Display Table of Contents >> FV (future value) |
Syntax:
FV(Rate, NPer, Pmt [, PV] [, Type])
Description:
Returns the future value of an investment based on periodic constant payments and a constant interest rate.
You can use this function to calculate the future value (= terminal value) of a loan, for example.
The function expects the following arguments:
Rate is the interest rate (per payment period).
NPer is the total number of payment periods.
Pmt is the payment made for each period.
PV (optional) is the present value. If omitted, it will be set to zero.
Type (optional) is the timing of the payments:
0 or omitted: Payment at the end of each period.
1: Payment at the beginning of each period.
Example:
FV(6.5%/12, 10, -1000) returns 10,247.30
See also: