Excel formula: Calculate payment for a loan | Exceljet
Calculate payment for a loan. Generic formula. = PMT( rate, periods, - amount) Summary. To calculate a loan payment amount, given an interest rate, the loan term, and the loan amount, you can use the PMT function. In the example shown, the formula in C10 is: = PMT( C6 / 12, C7, - C5) Explanation.
DA: 86 PA: 1 MOZ Rank: 67