Calculate monthly loan payment, total payment and total interest, with the matching Excel PMT formula.
Enter the principal amount.
Enter the annual nominal interest rate.
Enter the repayment period in years.
Select how often payments are made.
Payment Per Period
—
=PMT(B1/12,C1*12,-A1)
Total Number of Payments
—
=C1*12
Total Payment
—
Payment × Number of Payments
Total Interest
—
Total Payment - Loan Amount
Interest as % of Principal
—
=TotalInterest/Principal
Excel tip
For monthly payments, if loan amount is in A1, annual rate in B1, and years in C1:
=PMT(B1/12,C1*12,-A1)
This calculator assumes a fixed interest rate and equal payments. It does not include fees, taxes, insurance or changing interest rates.