4D v18
PMT
- 4D View Pro Handbuch
-
- Formeln in 4D View Pro
-
- Operatoren und Werte
- Zellenreferenzen
- Formeln vom Plug-In 4D View konvertieren
- 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
PMT
PMT
| PMT ( i , n , p ) | ||||||||
| Parameter | Typ | Beschreibung | ||||||
| i | Zahl |
|
The interest rate for a period | |||||
| n | Zahl |
|
The number of periods | |||||
| p | Zahl |
|
The current value of the loan (use a negative value) | |||||
The PMT function returns the value of monthly loan payments.
Here is the formula for PMT:
You borrowed 6,500 euros over 48 months with 10.5% interest:
PMT(10.5%/12,48,-6500) //166.42
Siehe auch
EIGENSCHAFTEN
Produkt: 4D
Thema: Formeln in 4D View Pro
GESCHICHTE
ARTIKELVERWENDUNG
4D View Pro Handbuch ( 4D v18)
© 1985-2020 4D SAS / 4D, Inc. Alle Rechte vorbehalten.