Link Search Menu Expand Document

pmt

Explanation Find the repayment amount for each term when the borrowing amount is borrowed at the interest rate with the equal repayment of principal and interest for the number of repayments. For monthly repayments, the interest rate specifies the monthly interest rate as a decimal.
Call format var p = pmt (borrowing amount, interest rate, repayment frequency, payment date )
Return value The repayment amount for each term is returned when the borrowed amount is borrowed at the interest rate with the equal repayment of the principal and interest of the number of repayments.
Arguments Number borrowing amount
Number interest rate
Number frequency repayment Number of repayments.
Number payment date 1 for the beginning of the period and 0 for the end of the period.
If omitted, payment will be made at the end of the term .
Exception None
Example of use
Related item