FV

Excel Functions

Get the future value of an investment

Syntax

EXCEL

=FV(rate, nper, pmt, [pv], [type])

Parameter	Description
`rate`	The interest rate per period.
`nper`	The total number of payment periods.
`pmt`	The payment made each period. Must be entered as a negative number.
`pv`	[optional] The present value of future payments. If omitted, assumed to be zero. Must be entered as a negative number.
`type`	[optional] When payments are due. 0 = end of period, 1 = beginning of period. Default is 0.

future value

The future value (FV) function calculates the future value of an investment assuming periodic, constant payments with a constant interest rate.