RATE function

description:

Returns the interest rate per period of a loan or an investment.

 

syntax:

=RATE( nperpmtpv[fv][type][guess] )

 

required arguments:

nper The total number of payment periods.
pmt The payment made each period.
pv The present value, or a total value of all loan payments now.

 

optional arguments:

[fv] The future value.
[type] 0 = end of period. 1 = beginning of a period. The default is 0.
[guess] Your guess on the rate. Defaults to 10%.