RATE function


DESCRIPTION:

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

 

SYNTAX:

=RATE( nper, pmt, pv, [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%.