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.