Syntax. Rate(Nper,Pmt,Pv,Fv,Type,Guess)

Definition. This function determines the applicable interest rate for compound interest tasks and annuity calculation (repayment calculation according to the principle of annuity repayment).


  • Nper (required) The number of interest periods. It is assumed that possible regular payments (that is, the Pmt argument is greater than zero) take place at the end (or the start) of the interest periods.

  • Pmt (required/optional, see Note) The amount of the regular payments, which can be interpreted as annuity.

  • Pv (required/optional, see Note) The start value of one payment direction. For disbursement plans, this is the account balance at the beginning of these considerations; for repayment plans, it is the ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.