FV

Home

4D v19

FV


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

Parameter	Typ	Beschreibung
i	Zahl	The interest rate for a period
n	Zahl	The number of periods
m	Zahl	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	Zahl	For single interest rate: the final value at the end of a period (use a negative value)

Beschreibung

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:

Beispiel 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

Beispiel 2

Single interest rates: same type of scenario as above.

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

Siehe auch