|
<< Click to Display Table of Contents >> FV (future value) |
Syntax:
FV(Rate, NPer, Pmt [, PV] [, Type])
Description:
This returns the future value of an investment based on periodic constant payments and a fixed 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 annuity (payment made for each period).
PV (optional) is the present value. If the argument PV is 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: