FV
Description
Returns the future value of an investment based on periodic payments and a constant interest rate.
Syntax
FV(
rate
,
nper
,
pmt
, [
pv
], [
type
])
- rate: The interest rate for each period.
- nper: The number of periods over the life of the investment.
- pmt: The payment made for each period.
- pv: The present value of the investment.
- type: The payment timing. 0 or Empty = the payment occurs at the end of the period; 1 = the payment occurs at the beginning of the period.