Excel Functions

Excel RATE Function

Pinterest LinkedIn Tumblr

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.

Purpose of Excel RATE Function

Get the interest rate per period of an annuity.

Return value

The interest rate per period.


=RATE (nper, pmt, pv, [fv], [type], [guess])


nperThe total number of payment periodsMandatory
pmtThe payment made each periodMandatory
pvThe present value, or total value of all loan payments now Mandatory
fvThe future value, or desired cash balance after last payment. Default is 0Optional
typeWhen payments are due. 0 = end of period, 1 = beginning of period. Default is 0. Optional
guessYour guess on the rate. Default is 10% Optional

Usage notes

  • You must be consistent with units for guess and nper.
  • If you make monthly payments on a five-year loan at 10 percent annual interest, use 10%/12 for guess and 5*12 for nper.
  • If you make annual payments on the same loan, use 10% for guess and 5 for nper.


Since 2007 for Windows.
Since 2011 for Mac.

Related Posts

Write A Comment