RATE
Basic Overview
AVAILABLE SINCE 5.7.0
Description  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. 
Signature  RATE(Nper, Pmt, PV[, FV , Type, Guess]) 
Parameters 

Notes 

Limitations 

Example
Nper (Number of Periods)  60 
Pmt (Payment per Period  Amount)  100 
Pv (Present Value)  5000 
Fv (Future Value)  0 
Type Payment at Beginning of Period (Annuity Due) = 1 Payment at End of Period (Ordinary Annuity) = 0  0 
Guess  0.1 
Valsight Formula  RATE(Nper, Pmt, PV, FV , Type, Guess) 
Result  0.0062 