4D v18
NPER
- 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
- RUNTIME_CURRENT_TIME
- RUNTIME_DATE
- RUNTIME_STRING
- RUNTIME_TIME
- RUNTIME_VIEW_STRING
- SIN
- SQRT
- STDEV.P
- SUBSTITUTE
- SUM
- TAN
- TEXT
- TODAY
- TRUE
- TYPE
- VAR.P
4D v18
NPER
NPER
| NPER ( i , m , p {, f} ) | ||||||||
| Paramètre | Type | Description | ||||||
| i | Numérique |
|
The interest rate for a period | |||||
| m | Numérique |
|
The monthly payment paid at the end of the period (use a negative value). For acquired value: pass an empty parameter (see example) |
|||||
| p | Numérique |
|
The current value of the loan | |||||
| f | Numérique |
|
The future value of the loan (use a negative value) | |||||
The NPER function returns the number of periods needed to reimburse a loan. Two formulas can be used:
- First formula, when you know the monthly payment:
- Second formula, when you know the total payment:
You borrowed 6,500 euros with 10.5% annual interest and you reimburse 166.42 euros per month:
NPER(10.5%/12,-166.42,6500) //48You borrowed 3,000 euros with 10.5% annual interest and you know that the total monthly payments will be 5,000 euros:
NPER(10.5%/12,,3000,-5000) //58
PROPRIÉTÉS
Produit : 4D
Thème : Formules 4D View Pro
Nom intl. : NPER
HISTORIQUE
UTILISATION DE L'ARTICLE
4D View Pro ( 4D v18)
© 1985-2020 4D SAS / 4D, Inc. All rights reserved.