PMT function
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. |