RATE
Description
Returns the interest rate for an investment or loan for the specified period.
Syntax
RATE(
nper
,
pmt
,
pv
, [
fv
], [
type
], [
guess
])
- nper: The total number of periods for the loan or investment.
- pmt: The payment amount for each period.
- pv: The present value.
- fv: The future value.
- type: The payment timing. 0 = the payment occurs at the end of the period; 1 = the payment occurs at the beginning of the period.
- guess: The estimated rate. The default is 0.1 (10%).