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

Home

 
Home
4D v19
4D View Pro Handbuch
Formeln in 4D View Pro
NPER

NPER 


 

NPER ( i , m , p {, f} )  
Parameter Typ   Beschreibung
i  Zahl in The interest rate for a period
m  Zahl 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  Zahl in The current value of the loan
f  Zahl 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

Vorige Seite
Nächste Seite

 
EIGENSCHAFTEN 

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

 
SEITENINHALT 
Beschreibung
Beispiel 1
Beispiel 2
 
GESCHICHTE 

 
ARTIKELVERWENDUNG

4D View Pro Handbuch ( 4D v19)