Manuals/calci/RATE
RATE(NoOfPeriod, Payments, PresentValue, FutureValue, Type, Guess)
where,
NoOfPeriod - represents the total number of payment periods.
Payments - represents the payment made each period.
PresentValue - represents the present value.
FutureValue - represents the future value.
If omitted then considered as 0.
Type - represents the payments due.
Type Payments due
0 or omitted end of the period 1 beginning of the period
Guess - represents the guess for rate will be.
If omit, it considered as 10%.
It returns the interest rate per period for a year.
If the successive results of RATE do not converge to within 0.0000001 after 20 iterations, RATE returns the #ERROR.
RATE
Lets see an example in (Column2, Row1)
=RATE(R1C1, R2C1, R3C1, 0, 1, "10%")
RATE returns -0.040126.
Consider an another example
=RATE(8,-100,50000,0,5,0.01)
It returns #ERROR(Type=5).
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 2 | -0.040126 | ||
| Row2 | -50 | |||
| Row3 | 2000 | |||
| Row4 | ||||
| Row5 | ||||
| Row6 |
