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: The PPMT function calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate.
PMT: The PMT function calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate.
NPER: The NPER function calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.
IPMT: The IPMT function calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate.
FVSCHEDULE: The FVSCHEDULE function calculates the future value of some principal based on a specified series of potentially varying interest rates.
FV: The FV function 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.