Returns the interest rate per period of an annuity based on a number of periods, the amount of payments per period, a present value, a future value, a value indicating whether payments are due at the beginning or the end of period (type) and a guess.
RATE(Nper, Pmt, PV[, FV , Type, Guess])
(Number of Periods)
(Payment per Period - Amount)
Payment at Beginning of Period (Annuity Due) = 1
Payment at End of Period (Ordinary Annuity) = 0
RATE(Nper, Pmt, PV, FV , Type, Guess)