FV

4D v18

FV


FV ( i , n , m {, f} )

Paramètre	Type	Description
i	Numérique	The interest rate for a period
n	Numérique	The number of periods
m	Numérique	For compound interest: the monthly payment at the end of each period (use a negative value). For single interest: pass an empty parameter (see example)
f	Numérique	For single interest rate: the final value at the end of a period (use a negative value)

Description

The FV function calculates:

the final value of a sum using compound interest, or
the final value of a sum using single interest

To calculate the value acquired during an investment, if the monthly payments are paid at the end of the period, pass the m parameter and omit the f parameter. Here is the formula for this calculation:

To calculate the final value of a sum using single interest, pass the f parameter and pass an empty parameter (,,) for the m placeholder. Here is the formula for this calculation:

Exemple 1

Compound interest: you plan on depositing €1,000 each month in a savings account, which earns you 12% annual interest, for 35 months.

FV(1%,35,-1000) //41660.275603126

Exemple 2

Single interest rates: same type of scenario as above.

FV(12%,35,,-35*1000) //1847986.69

Voir aussi