RATE
Returns the interest rate per period of an annuity
Syntax
RATE(nper, pmt, pv, [fv], [type], [guess])
Parameters
- nper: Required. The total number of payment periods
- pmt: Required. The payment made each period
- pv: Required. The present value
- fv: Optional. The future value (default 0)
- type: Optional. When payments are due (0=end, 1=beginning)
- guess: Optional. Your guess for the rate (default 0.1)
Example
=RATE(4*12, -200, 8000)