RATE


Definition of RATE

Calculates the interest rate of an annuity investment based on constant-amount periodic payments and the assumption of a constant interest rate.

Sample Usage

RATE(12,-100,400,0,0,0.1)

RATE(A2,B2,C2,D2,1,0.08)

Syntax

RATE(number_of_periods, payment_per_period, present_value, [future_value, end_or_beginning, rate_guess])
  • number_of_periods - The number of payments to be made.
  • payment_per_period - The amount per period to be paid.
  • present_value - The current value of the annuity.
  • future_value - [ OPTIONAL ] - The future value remaining after the final payment has been made.
  • end_or_beginning - [ OPTIONAL - 0 by default ] - Whether payments are due at the end (0) or beginning (1) of each period.
  • rate_guess - [ OPTIONAL - 0.1 by default ] - An estimate for what the interest rate will be.

See Also

PV: Calculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate.

PPMT: Calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate.

PMT: Calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate.

NPER: Calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.

IPMT: Calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate.

FVSCHEDULE: Calculates the future value of some principal based on a specified series of potentially varying interest rates.

FV: Calculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate.

CUMPRINC: Calculates the cumulative principal paid over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.

CUMIPMT: Calculates the cumulative interest over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.


To use the RATE Formula, start with the Excellentable you would like to edit.

Screen Shot 2016-05-27 at 12.13.57 PM.png


Then type the RATE formula into the cell you have chosen to display the outcome:

Screen Shot 2016-05-27 at 12.14.17 PM.png


Fill in the 2 values

Screen Shot 2016-05-27 at 12.14.30 PM.png

By adding the values you would like to calculate, Excellentable generates the outcome: