Dies ist die alte 4D Dokumentations-Website. Die neue und aktualisierte Dokumentation finden Sie unter developer.4d.com

Home

 
4D v19
FV

FV 


 

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

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:

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

Single interest rates: same type of scenario as above.

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



Siehe auch 

PV

 
EIGENSCHAFTEN 

Produkt: 4D
Thema: Formeln in 4D View Pro

 
SEITENINHALT 
 
GESCHICHTE 

 
ARTIKELVERWENDUNG

4D View Pro Handbuch ( 4D v19)