FV Function - Excel
Overview
The FV function in Excel is a useful tool for calculating the future value of an investment based on interest rate, number of payments, and payment amounts. Additional data points are present value and the timing of payments. This function helps users estimate the future worth of an investment or a series of cashflows.
Example:
=FV(0.05, 10, -100)
Syntax:
=FV(rate, nper, pmt, [pv], [type])
rate: The interest rate per period.
nper: The total number of payment periods.
pmt: The payment made each period; it remains constant throughout the annuity's life.
[pv]: (Optional) The present value or lump sum amount.
[type]: (Optional) The timing of payments; 0 if payments are due at the end of the period, 1 if at the beginning.
Example
In this example, the FV function takes in three inputs to give us the future value output. First it takes in the rate, which is 5% in this example. Next it takes in the number of payment periods, which is 10 in this example. Finally it takes in the payment amount each period, which is -100 in this example. The payment amount is negative because it’s an outgoing payment. The final output of this function is a future value of “$1,257.79”.
Example: Optional input [pv]
In this example, we will use the optional “present value (pv)” input for the FV function. All of the inputs are the same as the previous example except this time we are adding the pv input, which is -1000 in this example. The pv input is negative because it represents an initial outgoing investment. The final output of this function is a future value of “$2,886.68”.
Example: Optional input [type]
In this example, we will use the optional “type” input for the FV function. The “type” input has two options, you can either enter 0 to indicate that a payment is due at the end of a period or a 1 to indicate that a payment is due at the beginning of a period. In this example I show the difference between the 0 type entry and the 1 type entry. When the payment is due at the beginning of a period (1 type entry), the future value tends to be higher. The reason for the future value being higher with the payment period at the beginning is because you have more time to earn interest on that money.
