For this example, we want to find the payment for a $5000 loan with a 4.5% interest rate, and a term of 60 months. To do this, we configure the PMT function as follows: rate - The interest rate per period. We divide the value in C6 by 12 since 4.5% represents annual interest, and we need the periodic interest. nper - the number of periods comes from cell C7; 60 monthly periods for a 5 year loan. pv - the loan amount comes from C5. We use the minus operator to make this value negative, since a loan represents money owed. With these inputs, the PMT function returns 93.215, rounded to $92.22 in the example using the currency number format.
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
