description:
Calculates the payment for a loan based on constant payments and a constant interest rate. |
syntax:
=PMT( reference, rows, cols, [height], [width] ) |
required arguments:
rate | The interest rate per period. |
pmt | The payment made each period. |
pv | The present value, or a total value of all payments. |
optional arguments:
[fv] | The future value. |
[type] | 0 = end of period. 1 = beginning of period. Default is 0. |