All functions / Financial
RATE
The interest rate per period of a loan or investment.
Syntax
=RATE(nper, pmt, pv, [fv], [type], [guess])
Arguments
nper: Total number of payments.pmt: The payment each period.pv: The present value.fv(optional): Final balance (default 0).type(optional): 0 (default) = payments at the end of each period, 1 = at the start.guess(optional): Starting guess (default 10%).