4D v17
FV
- 4D View Pro
-
- Formules 4D View Pro
-
- Opérateurs et valeurs
- Références des cellules
- Conversion des formules du plug-in 4D View
- ABS
- ACOS
- AND
- ASIN
- ATAN
- AVERAGE
- COLUMNLETTER
- COS
- COUNTA
- EXP
- FALSE
- FINDCELL
- FV
- IF
- INDIRECT
- ISBLANK
- LEN
- LN
- LOOKUP
- MAX
- MID
- MIN
- NOT
- NOW
- NPER
- OR
- PI
- PMT
- PV
- RAND
- RATE
- ROUND
- ROW
- SIN
- SQRT
- STDEV.P
- SUBSTITUTE
- SUM
- TAN
- TEXT
- TODAY
- TRUE
- TYPE
- VAR.P
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) | |||||
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.275603126Single interest rates: same type of scenario as above.
FV(12%,35,,-35*1000) //1847986.69
Produit : 4D
Thème : Formules 4D View Pro
Nom intl. : FV
4D View Pro ( 4D v17)
