Question: how to calculate in excel interest rate?
Answer: Summary. The Excel RATE function is a financial function that returns the interest rate per period of an annuity. ...  Get the interest rate per period of an annuity. the interest rate per period. =RATE (nper, pmt, pv, [fv], [type], [guess]) nper - The total number of payment periods. ...  RATE is calculated by iteration.