The FV function calculates the future value of an investment. The future value is the lump sum or closing balance received at the end of an investment.
For example, you could use this function to calculate the return of an investment given a certain interest rate, principal, and regular payments into the investment.
FV(Interest rate, Number of periods, Payments [, Present value] [, Payment timing])
|Interest rate (required)||Number||The interest rate per period.|
|Number of periods (required)||Number||The number of periods that the investment is held for, and that the interest rate applies to.|
|Payments (required)||Number||The amount paid into the investment each period.|
The present value of the investment at the start of the investment period.
If you omit this argument, the present value is equivalent to 0.
Determines whether each payment is made at the start or end of each period. If a payment is made at the start of the period, that period's interest applies to it.
You can enter a zero or non-zero number for this argument. If you enter:
The FV function returns a number, which is the future value of the investment.
You can create a formula equivalent to the FV function with the structure below:
IF Rate = 0 THEN - Present value - Payments * Number of periods ELSE - Present value * POWER(1 + Interest rate, Number of periods) - Payments * (1 + Interest rate * Payment timing) * (POWER(1 + Rate, Number of periods) - 1) /Interest rate
In this formula, Payment timing must either be zero for payments to be made at the start of each period, or non-zero for the end.
For any values you give the FV function via an argument, or that the function returns:
- a positive value represents money you receive, such as a dividend or loan
- a negative value represents money paid, such as a deposit or interest payment
You must use the same time period granularity for the Interest rate, Number of periods, and Payments arguments. This means that they should all consistently be monthly, quarterly, annual, or over another interval.
For example, an investment might over 3 years. In this case, there are 36 monthly periods, and you should divide the annual interest rate by 12. Additionally, any payment amounts should also be monthly.
In this example, the five items within the Contracts list are on columns. On rows, there are six line items. One for each of the arguments of the FV function, and one that uses the FV function to calculate the future value of each contract.
|Contract 1||Contract 2||Contract 3||Contract 4||Contract 5|
|Number of periods||24||12||12||12||12|