FV
Description
Calculates the future value of an investment based on periodic constant payments and a constant interest rate
Syntax
FV (rate, nper, payment[, pv, type])
Cannot be used in the condition of a FIND action.
Parameters
- Rate – interest rate per period (in percents, 50% is 0.5).
- Nper – total number of payment periods in an annuity
- Payment – payment made each period
- Present value (optional) – present value or the lump-sum amount that a series of future payments is worth right now. If omitted assumed to be 0
- Type (optional) – indicates when payments are due. 0 or omitted – at the end of the period; 1 – at the start of the period
Returns
Number: the future value of the investment.
Example
FV (0.08, 12 * 20, 500, 0, 0)