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