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(total_periods, payment_amount, present_value, [future_value], [type], [rate_guess])

  • total_periods - The total number of payment periods.
  • payment_amount - The amount to be paid per period.
  • present_value - The current value of the annuity.
  • future_value - [OPTIONAL] The future value remaining after the final payment has been made.
  • type - [OPTIONAL] The due date type for the payment – at the beginning (0) or end of each period (1).
  • rate_guess - [OPTIONAL] An estimate of the interest rate. If unspecified, it defaults to 0.1.


RATE(12,-100,400) calculates the interest rate of the annuity investment.