Vous êtes sur le site Web historique de la documentation de 4D. Les documentations sont progressivement déplacées vers developer.4d.com

Accueil

 
Accueil
4D v19
4D View Pro
Formules 4D View Pro
NPER

NPER 


 

NPER ( i , m , p {, f} )  
Paramètre Type   Description
i  Numérique in The interest rate for a period
m  Numérique in 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 in The current value of the loan
f  Numérique in 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) //48

You 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

Page préc.
Page suiv.

 
PROPRIÉTÉS 

Produit : 4D
Thème : Formules 4D View Pro

 
PAGE CONTENTS 
Description
Exemple 1
Exemple 2
 
HISTORIQUE 

 
UTILISATION DE L'ARTICLE

4D View Pro ( 4D v19)