O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

RATE()

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).

Arguments

  • 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required