Returns the interest rate per period of an annuity.
الصيغة
RATE(nper, pmt, pv, [fv], [type], [guess])المعاملات
nperمطلوب
The total number of payment periods in an annuity.
pmtمطلوب
The payment made each period, which cannot change over the life of the annuity.
pvمطلوب
The present value, or the total amount that a series of future payments is worth now.
The RATE function calculates the interest rate per period for a loan or investment by using an iterative method. It assumes constant payments and a constant interest rate throughout the duration of the annuity.
=RATE(48, -200, 8000)→0.0077Calculates the monthly interest rate for a 48-month loan of 8000 with monthly payments of 200.
Enter the loan parameters
Input the total number of periods, the periodic payment amount, and the present value into your spreadsheet.
Apply the RATE function
Use the formula =RATE(nper, pmt, pv) to calculate the periodic interest rate.
This usually happens if the function cannot find a result after 20 iterations, or if the provided arguments are mathematically impossible.