4 years ago
... Visit this page for written instructions, and to download the sample file.
To calculate a loan payment in Excel, you can use the PMT function. The PMT function calculates the payment for a loan that has constant payments and a constant interest rate.
Enter an interest rate, the number of payments, and the loan amount on the worksheet. Then, refer to those cells in the PMT formula.
Watch this short video to see the steps for setting up a payment calculation, using the PMT function.