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