Calculates an annuity investment's interest rate. This is done based on a constant interest rate and constant-rate periodic payments.
RATE(numberofperiods: Number, paymentperperiod: Number, presentvalue: Number, futurevalue: Number, endorbeginning: Boolean, rateguess: Number = 0.1) => Number
Number of periods
The total number of payment periods in an annuity
Payment per period
The payment made each period, does not change over the life of the annuity
The present value — the total amount that a series of future payments is worth now
Future value left when the final payment has been completed, defaults to 0.
End or beginning
Whether payments are due at the end (false) or beginning (true)
An estimate for what the interest rate will be