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.