RATE formula in Excel is used to calculate the interest rate per period of an annuity, comes in handy when we need to identify interest rate/ rate of return