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%. |