FV function
Summary
Returns the future value of an investment
Syntax
FV(rate,nper,pmt,[pv],[type])
For a more complete description of the arguments in FV and for more information on annuity functions, see PV.
The FV function syntax has the following arguments:
• Rate Required. The interest rate per period.
• Nper Required. The total number of payment periods in an annuity.
• Pmt Required. The payment made each period; it cannot change over the life of the annuity. Typically, pmt contains principal and interest but no other fees or taxes. If pmt is omitted, you must include the pv argument.
• Pv Optional. The present value, or the lump-sum amount that a series of future payments is worth right now. If pv is omitted, it is assumed to be 0 (zero), and you must include the pmt argument.
• Type Optional. The number 0 or 1 and indicates when payments are due. If type is omitted, it is assumed to be 0.
0 | At the end of the period
1 | At the beginning of the period
The FV function syntax has the following arguments:
• Rate Required. The interest rate per period.
• Nper Required. The total number of payment periods in an annuity.
• Pmt Required. The payment made each period; it cannot change over the life of the annuity. Typically, pmt contains principal and interest but no other fees or taxes. If pmt is omitted, you must include the pv argument.
• Pv Optional. The present value, or the lump-sum amount that a series of future payments is worth right now. If pv is omitted, it is assumed to be 0 (zero), and you must include the pmt argument.
• Type Optional. The number 0 or 1 and indicates when payments are due. If type is omitted, it is assumed to be 0.
0 | At the end of the period
1 | At the beginning of the period
Example
=FV(A2/12, A3, A4, A5, A6)
=FV(A2/12, A3, A4)
=FV(A2/12, A3, A4,, A5)
=FV(A2/12, A3, A4)
=FV(A2/12, A3, A4,, A5)