4D v17
RATE
- 4D View Pro Reference
-
- 4D View Pro Formulas
-
- Operators and values
- Cell references
- Converting 4D View plug-in formulas
- 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
4D v17
RATE
RATE
| RATE ( n , m , p {, f} ) | ||||||||
| Parameter | Type | Description | ||||||
| n | Number |
|
The number of periods | |||||
| m | Number |
|
The monthly payment paid at the end of the period (use a negative number). For future value: pass an empty parameter (see example) |
|||||
| p | Number |
|
The current value of the loan | |||||
| f | Number |
|
The future value (use a negative number) | |||||
The RATE function returns the interest rate corresponding to the values passed in parameters. Two formulas can be used:
- First formula, when you know the monthly payment paid at the end of the period
- Second formula, when you know the acquired value:
You borrowed 3,000 euros and your monthly payments are 1,000 euros over 5 months:
RATE(5,-1000,3000) //0.19You borrowed 2,800 euros and the total paid value is 6,000 euros over 5 months:
RATE(5,,2800,-6000) //0.16
See also
PROPERTIES
Product: 4D
Theme: 4D View Pro Formulas
HISTORY
ARTICLE USAGE
4D View Pro Reference ( 4D v17)
© 1985-2020 4D SAS / 4D, Inc. All rights reserved.