The RATE function is commonly multiplied by 12 to arrive at an annual rate.
The RATE function calculates by iteration.
RATE Function
The Excel RATE function is a financial function that returns the interest rate per period of an annuity. You can use RATE to calculate the periodic interest rate, then multiply as required to derive the annual interest rate. The RATE function calculates by iteration.
