RATE
Basic Overview
Description | Returns the interest rate per period of an annuity based on a number of periods, the amount of payments per period, a present value, a future value, a value indicating whether payments are due at the beginning or the end of period (type) and a guess. |
Signature | RATE(Nper, Pmt, PV[, FV , Type, Guess]) |
Parameters |
|
Notes |
|
Limitations |
|
Example
Nper (Number of Periods) | 60 |
Pmt (Payment per Period - Amount) | -100 |
Pv (Present Value) | 5000 |
Fv (Future Value) | 0 |
Type Payment at Beginning of Period (Annuity Due) = 1 Payment at End of Period (Ordinary Annuity) = 0 | 0 |
Guess | 0.1 |
Valsight Formula | RATE(Nper, Pmt, PV, FV , Type, Guess) |
Result | 0.0062 |